Imports - Asset Custom Fields Import Information

Purpose

Importing will create new vehicle custom field definitions using imported information. If a custom field with the same label already exists, the row will fail.

Once Descriptions are Imported, use Imports - Asset Custom Values to then import the values for the Asset Custom Fields to associate the appropriate fields with the appropriate assets along with the values needed for those fields.

Import Fields and Definitions

Field

Value

Type/Size

Required for Create New

Required for Update

Update Allowed

Custom Field Description

Must not match existing custom field

char(25)

  •  
  •  
  •  

Field Type

Dropdown for Number, Text or Date

char(4) (N/D/A) Number/Date/Alpha

  •  
  •  
  •  

Field Length

How many characters are allowed

char(max) don’t make it required and let them enter whatever they want here

  •  
  •  
  •  

Dropdown Values

comma separated values for all dropdown values

(item1, item2, item3, item4)

  •  
  •  
  •  

Disable

Flag

(tinyint,null) Y/N

  •  
  •  
  •  

Required

Flag

(tinyint,null) Y/N

  •  
  •  
  •  

Refer to How to Import Files for instructions on processing an import.