DATANORM Export
Publish your own article and price data as a DATANORM file – in full or as a price change.
Last updated
⌘Ctrlk
Publish your own article and price data as a DATANORM file – in full or as a price change.
Export is the reverse direction of import: you publish your own article data in a format any DATANORM-capable software can read.
Typical reasons:
You supply trade businesses and make your catalogue available.
You pass a price change on to partners.
You hand data over to another system that reads DATANORM.
Open Export DATANORM File from the role centre or the application search. The wizard walks through three steps.
Export Type
Full Article Export outputs articles with all their details. Price Change Export outputs article numbers and prices only – the counterpart of a DATPREIS file.
DATANORM Version
Format of the output. Pre-filled from Default DATANORM Version in the setup.
Item Category Filter
Restricts the export to one item category.
Vendor Filter
Restricts it to the items of one vendor.
Modified After
Only items changed after this date – ideal for regular delta deliveries.
Only DATANORM Items
Restricts it to items that were imported through the app.
Items to Export
Number of items matching the filters. Check this value before exporting.
File Name
Name of the output file, usually DATANORM.001.
Finish creates the file and offers it for download.
V
Header record with version, creation date and currency.
A
One record per article with description, unit and price.
B
DATANORM 4 only: additional article details.
E
End record confirming completeness.
A price change export omits the article records and outputs article number and price.
Check the Items to Export figure before you create the file. Without filters the app exports your entire item master.
The file is generated in the DOS character set, as the standard requires. Do not open and save it as UTF-8 in a text editor before handing it over – the recipient would not be able to read umlauts correctly.
For regular delta deliveries, set Modified After to the date of your last delivery. That keeps the file small and the recipient only has to process the changes.
The simplest test is a round trip in a sandbox environment: export a small selection and read the file back in there. If the articles appear in staging in full, the file is formally correct.
Last updated