Follow

Import assets with multiple users/suppliers

Before you begin

  • Records that contain special characters (commas, quotation marks, etc.) can result in corrupted data, and can even cause imports to fail. We suggest doing a test import with only 2 or 3 records to ensure your formatting is correct. To learn more about special characters in import files, see Troubleshooting Imports.
  • When importing, any columns that you leave blank will result in blank records, as they are not auto-populated by the CMMS. To prevent unexpected issues, we suggest removing any columns you don’t need to update.

Overview

In order to import assets that have multiple users and/or suppliers, the CSV file upload is repeated following adjustments to the columns containing the multiples.

1. Create an Asset CSV with supplier and/or user personnel code criteria.

 

2. Verify that the CSV Personnel and Supplier data currently exist in the CMMS. 

 

3. Navigate to the Import functionality by selecting Assets and then Import.

 

4. Upload your CSV and click Continue when finished.

 

5. Define the field mappings by matching the header in your CSV file to the corresponding item from the drop down menu. The fields shown on the left are extracted from your file, while the fields chosen through the drop downs are CMMS fields.

 

6. Once the import completes, click Done to exit.

 

 

7. To import multiple codes assigned to the same asset, use the same CSV file. Replace the users/suppliers columns with the the secondary users/suppliers criteria.  

 

8. Import the second CSV using the same process outlined above. When prompted an asset already exists with that code or name, select the checkbox "Use this answer for all future questions" and click Update:

 

9. Repeat for remaining multiple users/suppliers.

Was this article helpful?
1 out of 1 found this helpful

Comments