Scenarios that can result in errors or warnings
This table shows the scenarios before or during import that may cause an error or result in a warning:
| Scenario | Possible fix |
|---|---|
| The file is not in the correct format.
For example, the file has no *FRF column. |
Ensure the file is in the correct format. Make sure that there is a *FRF column, and that column is empty. |
| The period in the file does not match the dataset's Period
Type.
For example, the dataset's Period Type is months but the file contains period that is more than 12. |
Ensure that the period in your file matches the dataset's Period Type. |
| The file contains non-standard DMP column names. The import action is continued. The event logs contain the non-standard column names that cannot be mapped by DMP. |
Check your import file for non-standard DMP column names.
Look at the event logs for the list of column names that cannot be mapped. |
| The file contains columns with invalid content. For example, the column UCDEMA (Demand Forecast) should contain numbers only but your file contains letters or special characters. The entry or row in the file that contains invalid content is not imported and is logged in an .csverr file. This file is auto-generated for the invalid entries and found on the same path where the import file is located. |
Ensure your import file does not have columns with invalid content.
Check the .csverr file for the list of invalid rows. |
| The selected Transaction Type is inconsistent with the column names in the
import file. For example, Transaction Type 34 (Demand/Calculated sales forecasts) normally has the accumulators UCDEMA, MFCFOR, MFMFOR, and MDFMADJ. |
Ensure that the selected Transaction Type is consistent with the column names in the file. |