1. Select and Validate Your Excel File
Browse to and select the Import file(s) containing the data you want to import, then click Validate.
The file validation process reports any discovered errors and/or warnings in each file, as shown in this example.
Keep the original name of the import template file intact (e.g., contacts.xlsx) to ensure validation is successful.
2. Review Errors and Warnings
If an Import file has errors and/or warnings, click Download and open the file. If not, proceed to step 4.
In this example, the Location Features worksheet had not been filled out, so a warning (highlighted in orange) was reported. Errors are highlighted in yellow.
3. Make Corrections
Correct any reported errors and/or warnings in the Import file and re-validate. Repeat for each file that has errors and/or warnings. See Data Import Tool Errors and Warnings.
Note: You must correct all errors before the Import file(s) can be imported. If you don't correct warnings, the file(s) can still be imported but the data that resulted in the warning won't be imported. For example, in the file example above, if you don't fill out the Location Features worksheet, no location feature data will be imported.
4. Add the Data to Your Instance
Once all the Import files are free of errors and warnings, click Insert which inserts the locations, contacts, organizations, and/or resources included in the Import files into your Series25 database and reports the number of each object type (records) inserted.
5. Verify Data in 25Live
Check the success of the import using the data object search features in 25Live.