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 excelwith 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. Save the file.

   2. Update Existing Asset Records

      1. Select Update Existing.

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

      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.