Importing assets

Modified on Wed, 2 Nov, 2022 at 2:49 PM

In order to import 'Assets', you will need to be an administrator and have access to the Account Settings. You can find an example file in the following article.

1. Go to 'Account settings' and select 'Import' and navigate to 'Assets'.

OPTIONAL 2. Delete existing assets (if necessary)

If you want to replace assets already existing in the system with the newly imported ones, you can delete them prior to the import. If you have no existing assets or do not want to delete the ones already in the system, skip this step and go to step 3.

To delete, collapse the 'field mappings' tab or scroll down to the bottom of the page to 'Upload and import'. Check the box for 'Delete all assets first'. Then click on 'confirm DELETE ALL ASSETS FIRST'

3. Define fieldnames

Before selecting the import file, define the 'Import file fieldnames' which needs to be aligned to your .csv file and click Save. Columns with a (*) are required in order to successfully import a file. Some fields have a '? icon' attached for further information regarding the setups. In order to obtain this information, hover over it with your mouse.

Furthermore, you need to define the mapping types between single column, multiple columns and fixed value. You can find more information on how to use those different mapping types in this article.

Cables: The fields 1st end position Asset ID and 2nd end position Asset ID along with 1st end latitude, 1st end longitude, 2nd end latitude and 2nd end longitude are related to the asset type Cable, which can be connected to two assets and have two locations. To import cables you only need the Asset positions the cable is connected to or the end longitudes and latitudes for the cable, not both. Read about how this is set up the interface under Adding and Editing Assets.

Note: Before importing the .csv file, make sure that imported data are aligned with the information in the tool including Site ID, Asset type, Milestone, Milestone status...

4. Import the file

For the import itself choose the button Choose File on the bottom of the page, select the CSV import file and click on open. After the upload the below-marked button becomes available, this confirms the import.

The import should only need a few seconds.