Import Assets in the Project Assets Tool

You can import assets to create new records or to update existing ones. If importing from the project's Assets tool, assets are added to both the project and the company's Asset tool.

• Required User Permissions

• Records with the same Asset ID are updated.

• Required fields vary by asset type and their associated fieldset.

  • If exporting your assets first, ensure that your column configuration displays all required fields. Importing the excel spreadsheet with missing required fields will cause your import to fail.

• The following field types are currently not supported in Excel import and are excluded from the import templates: Project Directory User (Single Select), Project Directory User (Multi Select), Tool User (Single Select), and Company fields.

• If any entries fail, you can download an error file listing all failed rows, with an Error Reason explaining the specific issue for each entry.

• Multiple imports can run at the same time. When duplicates appear across files, the first version processed is accepted; others are flagged.

1. Navigate to the project's Assets tool.

2. If updating records, export records to excel with all required fields shown in your column configuration.

3. Click Import and select Import From Excel.

4. Prepare the File.

   1. Create New Asset Records

      1. Select Create New.

      2. Select whether you want to download a template by fieldset, or with the fields for a specific asset type.

         • Fieldset

           1. Select By Fieldset

           2. Select the Fieldset.

         • Asset Type

           1. Select By Asset Type.

           2. Select the Asset Type.

      3. Follow the instructions in the template to prepare the 'Assets' tab in the excel file.

      4. Prepare the file based on the instructions.

         Standard Fields Show/Hide Fields

         • Type: The asset's category or type. You can only select a subtype at the very end of a hierarchy (a "leaf node"). Once you select a type, the form automatically updates to show additional fields based on the fieldset assigned to that asset type.

         • Trade: The trade associated with the asset.

         • Name: A descriptive name for the asset.

         • ID: A unique alphanumeric code for the asset. This code must be unique across the entire company.

         • Status: The asset’s current operational status. This field remains disabled until an asset type is selected. Once the type is chosen, the dropdown is populated with the statuses defined in the status group assigned to that asset type.

         • Photo: A placeholder or representative photo. Uploading a new photo will replace the existing one.

         • Location: The physical location of the asset within the project’s location hierarchy.

         • Latitude: The latitude coordinate for the asset to support map-based positioning.

         • Longitude: The longitude coordinate for the asset to support map-based positioning.

         • Description: Additional details or notes to describe the asset and provide further context.

      5. Save the file.

   2. Update Existing Asset Records

      1. Select Update Existing.

      2. Update a the exported file with the new information.

         Standard Fields Show/Hide Fields

         • Type: The asset's category or type. You can only select a subtype at the very end of a hierarchy (a "leaf node"). Once you select a type, the form automatically updates to show additional fields based on the fieldset assigned to that asset type.

         • Trade: The trade associated with the asset.

         • Name: A descriptive name for the asset.

         • ID: A unique alphanumeric code for the asset. This code must be unique across the entire company.

         • Status: The asset’s current operational status. This field remains disabled until an asset type is selected. Once the type is chosen, the dropdown is populated with the statuses defined in the status group assigned to that asset type.

         • Photo: A placeholder or representative photo. Uploading a new photo will replace the existing one.

         • Location: The physical location of the asset within the project’s location hierarchy.

         • Latitude: The latitude coordinate for the asset to support map-based positioning.

         • Longitude: The longitude coordinate for the asset to support map-based positioning.

         • Description: Additional details or notes to describe the asset and provide further context.

      3. Save the file.

5. Select the file.

   • Click Attach File and select the prepared assets file.

   • Drag and drop the prepared assets file from you computer to the upload box.

6. Click Import.