Concept: Import Data
Whether you are just beginning to use
Adaptive Planning
or you need to update an existing model, getting your data from another source system into your model requires a data import. You can choose to:Import Automatically with Integration
- Import using a Planning Data Loader, that you can schedule with an Integration Task if your organization has Integration.
Import Manually
- Import NetSuite Actuals if you have NetSuite Basic
- Import Transactions if you have Transactions enabled
You may be asked to map account names, level names, and dimension names in the spreadsheet to their corresponding values in .
Adaptive Planning
. You can view and modify any existing manual import mappings you already made by clicking Import Account Mappings, Import Level Mappings, or Import Dimension Value Mappings under Integration > Manual Import
On upload, your data automatically maps to a best-fit for the data contents. You can also manually adjust:
What Happens When You Import Manually
When you import data manually, Adaptive Planning
examines each row of the import file to check if matching data already exists in the system. Adaptive Planning
looks at what dimensions are used, and if data exists in the same level, account, time period, and version. If a row key exists, we match to the row key column or columns, as well.
If data exists in the system at the same location, the import replaces it. This replacement occurs row by row. The import does not replace everything at once.
For example, you perform two imports. Your first import file loads data that your second import file does not contain. That existing data will remain after the second import.
If you want to delete all of the data in a particular column:
- Include the column and leave its cells blank in your spreadsheet import.