Bulk Importing Assets

Derek Torres
Derek Torres
  • Updated

This is a reference to bulk importing Assets into ServiceTrade.

Before you get started on completing our Asset Type import template, you should:

Note: It is important to test your bulk Imports. All of our customers should have a Demo ServiceTrade Account. Use your Demo Account to test the import first, to avoid duplication or creating errors in your Production Account. It is not possible to delete in bulk in ServiceTrade.
If you do not know what your Demo Account credentials are, please reach out to Customer Support.

 

Asset Import Template Field Definitions

The following Field Names are used by all Asset Type import templates.  It's important to understand that every Asset Type will have different fields.

Below is a list of the only two Field Names and Definitions that are available and required on every Asset Type Import Template.

Field Names Field Definitions
location_id

This is the numerical Location ID. This can be found in a Locations Export.

*required

asset_type

The coded Asset Type that you are importing.

A full listing of possible Asset Types can be found here.

Values for this field are always lowercase, with underscores, and no spaces. Example: hvac_unit, not HVAC Unit.

*required

 

Based on the Asset Type other fields may also be required.

We do not publish a list of which fields are required for which Asset, nor do we publish definitions for what those fields mean. These are usually both industry-specific and mostly self-explanatory.

To test which fields are required for an Asset Type, go to a test Location and attempting to manually create a single Asset of that Asset Type in your Account.

The Create Asset Menu will show you all available fields for a given Asset Type, and which fields are required.

 

How to Download the Correct Asset Type Template

  1. Click Customers.
  2. Then click Bulk Import.
  3. Click the Assets tab.
  4. Click the Asset Type drop-down.
  5. Select your preferred Asset Type.
  6. Then click Download Template to download a CSV file of the selected Asset Type Import Template.

Asset_Type_Import_Template.gif

 

How to Download a Locations Export and Find Location IDs

The image below will show you how to download a Location CSV Export File.

Location_Export.gif

 

The Location IDs column header is "ID"
Location_IDs.png

 

FAQs

The Asset I want to import isn't available?

If you are attempting to test Asset Types and find that a particular kind of Asset is not available to you, the availability of Asset Types is driven by Service Lines.  Follow this link to learn more.

My Asset Type Import Template has a date field...

For date fields, use the format "mm/dd/yyyy".

I want to import Assets, but have no Locations.

You may only import Assets to existing Locations.  

If you have not yet created Locations for any of the Assets that you wish to import, do so before proceeding.

 

Was this article helpful?

/