Import File

You can partially import from other data systems to an existing M3 DMP dataset for multiple data types or accumulators. The data can be imported according to a specific year, year and period, time mark, transaction type, and budget.

For the file import to be successful, these general conditions must be met:

• The file should have the .csv extension.
• The file should be in the correct format.
• The file should have *FRF as the first column. The value of *FRF for all rows must be blank.

  The part *Content at the first row of the file means a comment. If you add this, you can put comments or notes here.

• The lists in the file should have a separator, preferably comma (,) separated.
• For options that asks for column names, the column name in the file should match the column name that you enter in the Import File tab.
• The file should contain DMP column names that are consistent to the chosen Transaction Type in the Import File tab.

  For example, Transaction Type 34 (Demand/Calculated sales forecast) normally has the accumulators UCDEMA, MFCFOR, and MFMADJ.

• There should be no duplicate entries, meaning two rows that are exactly the same, including Year and Period.
• There should be no duplicate column names.