Actual data

If you are going to load actual data, all these data columns must exist in this order, from left to right, in the .txt or .csv file:

• PERIOD_ID
• PERIOD_NAME
• UNIT
• UNIT
• PLANOBJECT_ID
• PLANOBJECT_NAME
• VARIABLE_ID
• VARIABLE_NAME
• Amount

The column names are optional, but not the columns themselves, even if they do not have values. If you are loading data by ID, then all _ID columns (PERIOD_ID, UNIT_ID, PLANOBJECT_ID, and VARIABLE_ID) must have values. Or, if you are loading data by Name, then all _NAME columns (PERIOD_NAME, UNIT_NAME, PLANOBJECT_NAME, and VARIABLE_NAME) must have values. The Amount column is the data column; it does not need values.