Import entities
- Sign in to ONESOURCE, then selectAdministration.
- SelectCompany Info, thenEntities.
- SelectImporton the toolbar. This opens theImport EntitieswizardStep 1 Upload.
- In the Data Mapping Template section,select from an existing templateor selectCreate a New Template. You can also drag and drop the file in the pane on the screen, orBrowse for file.note
- You can only upload *CSV files. If the upload fails, you will get an error message.
- For multiple versions, you can only update the latest version in the *CSV file. Enter information in theEntity Code of last versionandEffective Date/Version Start Date of latest versioncolumns.
- SelectNext. This opens theStep 2 Map & Import. The template displays a sample of the data. You can assign columns or edit the existing template.
- Enter a template name.
- Select theStart Rownumber using the up and down arrows.
- Select the dropdown buttons on theRowcolumns and map theCode. Mapping the other columns is optional.
- SelectSaveto save your changes, then selectNextto move toStep 3 Validate.
- Step 3 Validatecompares the imported information with the existing data and gives the status of the Entities.tipYou can showAllstatuses or selectOnly Show Issuesto view the entities that need to be fixed.
- Review and fix any errors from the import.
- SelectImport, then selectDone.