Import entity rollup
- Sign in to ONESOURCE, then selectAdministration.
- Select .
- Select a rollup.
- SelectImportto go to theImport Rollupwizard.
- Drag and drop the file on theStep 1 Uploadwindow, or selectbrowse for file.noteYou can only upload CSV files. If the upload fails, you'll get an error message.
- SelectNextto move toStep 2 Validate.Step 2 Validatecompares the imported information and gives the status of the rollups.
- To ensure a successful import, follow these file structure rules:
- To define only Code Level 1, enter data only in the Code Level 1 column for that row.
- To link Level 2 to Level 1, add a new row with values in both Code Level 1 and Code Level 2 columns.
- To link Level 3 to Level 2, add another row with values in Code Level 1, Code Level 2, and Code Level 3 columns.
- Ensure the columns in your file follow this sequence:
- Code Level 1
- Code Level 2
- Code Level 3
- % Allocated
- VersionnoteIf there are any issues, the system won't import the file. The import process doesn't support updates. Importing a file will delete the existing hierarchy and replace it with the rollup hierarchy from the file.
- Review and fix any errors from the import.
- Finally, selectImport.