[Steven Metcalf]

Trying to setup a simple XML export for our POS system.  The default export works, but we would like to exclude the prices from being exported.

What little Application Integration documentation I have been able to find mentions there is a way to exclude certain variables from being exported and it shows a short example of this.  However I cannot find a list of these variables anywhere.

 

The Merillat EDI export excludes some fields like this:

<?xml version="1.0" encoding="UTF-8"?>
<!-- Merillat proCAB and EDI Export -->
<VarList active="1">
	<Var exclude="0" Name="WoodPREMium"/>
	<Var exclude="0" Name="FinishPREMium"/>
	<Var exclude="0" Name="CATalogNAMe"/>	
	<Var exclude="0" Name="UserText6"/>
	<Var exclude="0" Name="UserText7"/>
	<Var exclude="0" Name="UserText8"/>
	<Var exclude="0" Name="NumCabBaseDOor"/>
	<Var exclude="0" Name="NumCabDraWer"/>
</VarList>

What I need is a list of those variable names.

[Pasquale Brancati]

Hi Steven,

The Merillat is a custom export compiled to their required variables, Looking at the Application Integration module “out of the box” will include all generic variables, variables can be manually deleted when viewed in a text format. If you want to have a custom report created for you to exclude certain variables, you would need to speak with our sales\professional services teams.

Thank you

2020

[Mike Langensiepen]

Hi Steven,

If you have the Application Integration module, you could get someone to write a simple parsing program to delete any of the variables you want to omit. It should be possible to choose this alternate program rather than the ‘simple export’ option. The Application Integration 2.2 references creating a .QUE file to do this and perhaps support may be able to confirm that this is still a current option (AI 2.2 was for V9).

Our custom Quotation and Project Management system just ignores all the pricing variables in the standard AI XML so perhaps your POS system could be setup to do this?

[Steven Metcalf]

The App Integration documentation specifically mentions you can block variables from being exported by defining a XML file and including it in the .QUE file.   What I am looking for is a listing of those variables.

I understand the Merillat export may be custom..  But the app integration documentation implies it can by done by just knowing what the variable names are.

 

The reason I am trying to do it via this method is specifically because our POS software cannot be set it ignore the pricing.  If it is present, it will use it, which we do not want.

[Mike Langensiepen]

I can identify some of the variable names by checking in Catalog Tools (hope these are what you want). The capitals give you the short variable name:
CostPRice01 to CostPRice99
FeatureOptionPRice01 to FeatureOptionPRice99
ListPRice
PRice1 to PRice99 (leading zero omitted for some reason)
PRiceLevelEstim1 to PRiceLevelEstim4
PRiceLevelGen
RetailPRice01 to RetailPRice99
TotalPRice