Workspace administrators can set up an import to enter data into a module from a TXT or CSV file. You can also import from a ZIP file as long as it contains only one file in a TXT or CSV format.
You must be in Grid view for the module into which you want to import. You can import line items in Blueprint view, but not other module data.
To import into a module from a file:
- In the Data menu for the target module, select Import.
- Select Upload New File and browse for the file that contains the source data.
If you want to amend a file import that already exists, you can select a previous upload and then Edit.
- Check the import file options are correct.
- Select Next.
- In the Mapping tab of the import dialog, select items in the Source dropdowns to map source columns to dimensions in the target module.
For a single column import, select a column under Source and then select a column for the Data values from dropdown.
- In the top right of the dialog, select either:
- Clear target prior to import to clear the target items before you import.
- Only update imported cells if you only want to edit target items where values in the source and target differ.
- Map source data to target items in the target list tabs.
Values may match automatically on names or codes, but you can choose to manually map items in a module import. You can also choose to ignore items that do not match.
If you import date values to the Time dimension, you must map the module import data to the timescale.
- Select either:
- Run Import.
A progress dialog displays as the import runs.
If you want to cancel the import, select Cancel
in the top-right corner of the dialog.
The import saves as an action, but does not run.
- Run Import.
When the import completes, or if you cancel the import, an Import Completed dialog displays. This reports how many items imported successfully and any that did not. You can open the Details tab for a detailed report or select Close to exit the dialog.
Note: Import never overwrites formulas, so totals and formulas display as ignored.