All Collections
Xero Integration
Using Xero
Importing CustomLists and CustomFields
Importing CustomLists and CustomFields

Importing Customlist and Customfields through Cloud.WMS

Updated over a week ago


Custom List and Custom fields can be imported into Cloud.WMS.

It is recommended that you export the Item UDF list first, then update information and import the updated list.

Workflow Options

  • Enable CUSTOMFIELD and CUSTOMLIST updates In WMS Prefs.xml set to True either one of the two tags or both:

  • This will activate drop-down list selection for Custom lists and fields in Inventory Card.

Detail Steps

  1. Accessing the Item UDF import.
    Go to Workspace > Import > User Defined Fields.

2. Export Item UDF.

The export feature is accessed within the Import UDF screen.

Click on the Export button to export the Item UDF List.

The exported item CSV file is copied to the clipboard and can be copied to any location.

An example of an exported CSV file is shown below. The prefix 231221-081015 denotes DDMMYY-HHMMSS.

Below is a sample CSV file showing the first 1-24 UDF fields

3. Next are the CustomFields and CustomLists fields.

Workflow Restrictions

CustomFields precedes CustomLists fields, and the order should NOT be changed.

4. Allowed Field Columns

Only 1, 24 or 30 column fields are allowed to exist in the import CSV file.

An error prompt shows if the number of field columns is NOT either 1, 24 or 30.

For example, if the file contains 25 UDF columns, the error message below will appear when importing the file.

One Column Update

A single column can be updated by replacing the column name to be one of UDF(1-24), CUSTOMFIELD(1-3), CUSTOMLIST(1-3).

Workflow Restrictions

All field headers should be in uppercase.

Example 1: CUSTOMLIST1 (50999 New List 1)

Example 2: UDF1 (UDF1)

5. 24 Columns Update (UDF 1-24)

The 24 columns are reserved mainly for UDF1-24 fields ONLY. Therefore, ensure that only UDF1-24 exist in the CSV file when importing UDF fields.

Example 1: UDF 1-24 columns exist, but ONLY UDF 1-3 to be updated

30 Columns Update (UDF 1-24, CUSTOMFILED1-3, CUSTOMLIST1-3)

Example 1: CUSTOMFIELD 1-3 and CUSTOMLIST 1-3

Related Information
​Datapel Xero Integration
​Important Notes

If a CUSTOMLIST does NOT exist, it will be created as a NEW list.

CUSTOMFIELD do NOT exhibit this behaviour.

Example: CustomList T233, when imported, does NOT exist and is created as a NEW list and gets added to the drop-down list shown below.

Did this answer your question?