V . I . C . S ., LLC
- Log to the WEB application (WB).
- From the Main Menu, choose "Accounting Reports".
- Then choose, "WEB Data Dump".
Screenshot:
click to enlarge
This program outputs either an ascii delimited, comma delimited or an xml file. The following are the xml tags
that can be used when uploading a file to be run through a cron job.
All tags except the last one will have a “Y” or “N” response. The last tag <Delimiter> has three possible
values: 1, 2 or 3.
- = Comma Delimiter
- = Tab Delimiter
- = XML file
<Exceltable>
<Active></Active>
<Instock></Instock>
<Close></Close>
<Disc></Disc>
<Drp></Drp>
<One></One>
<Track></Track>
<MillCode></MillCode>
<MillDesc></MillDesc>
<PartNo></PartNo>
<PartDesc></PartDesc>
<ColorCode></ColorCode>
<ColorDesc></ColorDesc>
<StyleGrp></StyleGrp>
<StyleDesc></StyleDesc>
<ActiveFlag></ActiveFlag>
<PricingBy></PricingBy>
<OnSale></OnSale>
<ExpireDate></ExpireDate>
<OddSize></OddSize>
<Sizes></Sizes>
<SizeDesc></SizeDesc>
<UOM></UOM>
<UOMDesc></UOMDesc>
<CaseQty></CaseQty>
<Weights></Weights>
<MultiPrice><MultiPrice>
<CasePrice></CasePrice>
<DozPrice></DozPrice>
<PiecePrice></PiecePrice>
<CrossRef></CrossRef>
<CrossRefDesc></CrossRefDesc>
<ExtendedDesc></ExtendedDesc>
<Images></Images>
<CatalogInfo></CatalogInfo>
<Output></Output>
<Delimiter></Delimiter>
</EXCELTABLE>
<Active></Active>
<Instock></Instock>
<Close></Close>
<Disc></Disc>
<Drp></Drp>
<One></One>
<Track></Track>
<MillCode></MillCode>
<MillDesc></MillDesc>
<PartNo></PartNo>
<PartDesc></PartDesc>
<ColorCode></ColorCode>
<ColorDesc></ColorDesc>
<StyleGrp></StyleGrp>
<StyleDesc></StyleDesc>
<ActiveFlag></ActiveFlag>
<PricingBy></PricingBy>
<OnSale></OnSale>
<ExpireDate></ExpireDate>
<OddSize></OddSize>
<Sizes></Sizes>
<SizeDesc></SizeDesc>
<UOM></UOM>
<UOMDesc></UOMDesc>
<CaseQty></CaseQty>
<Weights></Weights>
<MultiPrice><MultiPrice>
<CasePrice></CasePrice>
<DozPrice></DozPrice>
<PiecePrice></PiecePrice>
<CrossRef></CrossRef>
<CrossRefDesc></CrossRefDesc>
<ExtendedDesc></ExtendedDesc>
<Images></Images>
<CatalogInfo></CatalogInfo>
<Output></Output>
<Delimiter></Delimiter>
</EXCELTABLE>
