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.

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

Go to Workspace tab > Import > User Defined Fields.
​

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

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.

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

NOTE: All field headers should be in uppercase.

Example 1: CUSTOMLIST1 (50999 New List 1)

Example 2: UDF1 (UDF1)

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

Importing

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.

​
​