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
This article will outline how to import a parent asset, and its respective child and grand child assets, making the building of your asset hierarchy that bit quicker and easier.
1. Prepare the assets in Excel and save as CSV format. The 1st line contains the parent asset, subsequent assets are considered child and grand child assets. The concept is that the Location Code for a child asset needs to be the same as the Asset Code of its parent asset. The child asset is located within and underneath its parent, so the child's location is the asset code of its parent.
Important Note: The first column above (Asset Code) was indented for visual aid purposes only. This was to better show the parent/child/grandchild hierarchy. When importing your CSV file into the CMMS, however, ensure that there is no indentation in the first column, as in the screenshot below.
2. To begin the import, save your CSV file, then navigate to the Assets menu and click Import.
3. Click on Upload, locate the Import file, and click Continue.
4. Map the respective fields of the CSV file to the CMMS fields. Click Continue when finished.
5. Review the Import Summary, address any errors, and click on Import.
6. The import results are now displayed. Select Done to check the result.
7. As can be seen below, the parent, child, and grand child hierarchy followed that of the CSV file above.
