Whether you are just beginning to use Adaptive Insights 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 spreadsheet data
- Import NetSuite Actuals if you have NetSuite Basic
- Import Transactions if you have Transactions enabled
- Import from Custom Scripts
You may be asked to map account names, level names, and dimension names in the spreadsheet to their corresponding values in Adaptive Insights. You can view and modify any existing import mappings you already made by clicking Import Account Mappings, Import Level Mappings, or Import Dimension Value Mappings under Integration > 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
When you import data, Adaptive Insights examines each row of the import file to check if matching data already exists in the system. Adaptive Insights looks at what dimensions are used, and if data exists in the same level, account, time period, and version. 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.