Example of importing a text file format

This example shows that format that you can use to import a comma separated text file format.

You can edit a CSV file format using Microsoft Excel, Notepad, or any text editor application.

In Notepad, you can create the dataset using this format:

*Contents;
*FRF;UCITNO;OKDIGC;Year;Period;UCIVQT
;LIQEXTRACT      ;;2012;8;1178.2
;LIQEXTRACT      ;;2012;9;2356.4
;LIQEXTRACT      ;;2012;10;2356.4
;R004            ;;2012;9;900
;R007            ;;2012;8;635

The first letter of the Period column must be capitalized. You must leave the rows for *FRF blank.

The columns after *FRF and before Year and Period are the key columns in the Demand Planner dataset. These keys are found and configured in Menu > Setup > Formats.

The values after the Period column are the M3 dataset accumulator fields. These fields matches the valid fields that are in the PosOssel DMP table.