Importing or exporting records to and from spreadsheets is easier than ever and makes migration from other systems manageable.
Importing Items
To Import Items, go to the Items View and then click the more button ("...") and select Excel Import.
Step 1: Download Spreadsheet Template & Upload File
A. Download a Spreadsheet template file:
- Existing Items (includes all existing items)
- New Items (blank)
B. Make modifications to the spreadsheet and upload the file.
Step 2: Match Spreadsheet Columns to the Database (optional)
- If you did not see the "Spreadsheet Column Mapping Complete" dialogue, that means you are missing columns or the column names could not automatically be matched by the system.
- Item Name is Required
Not all fields must be matched to the database. However, the Item Name is a required field and if this column is not matched to the database it will not let you proceed.
Importing Additional Item Numbers
You can now import additional item numbers by putting them in the Item Number Column delimited by a "|" (pipe) symbol.
Step 3: Validate and Complete
If the import was successful you will see this:
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article