Custom List Sublist Data
You can import data for two sublists — Custom List Values and Custom List Translation.
This topic describes these sublists in more detail. See also Custom List CSV Multiple File Examples for tips on organizing CSV files that include sublist data.
Custom List Values
The Custom List Values sublist specifies the options, or values, to be displayed in the custom list. For example, in a custom list named “Sizes,” sublist values might be “small,” “medium,” and “large.” The sublist fields are described in the following table.
This sublist is selectively updatable based on the ID field.
|
Field |
Notes |
Required? |
|---|---|---|
|
Abbreviation |
Available only if the Matrix Items feature is enabled for your account (at Setup > Company > Enable Features > Items & Inventory). You can use this field to add an abbreviation for each Custom List Values in your list. If, after the import, you review the newly imported record in the UI, note that the Abbreviation field shows up only if Matrix Option List is set to Yes for this particular custom list. However, even if you import abbreviations when setting Matrix Option List to No, the system saves your abbreviations, and they can be displayed later. |
No |
|
ID |
This field — which is the key for the sublist — is automatically generated and read only. Do not attempt to populate this field with a value of your own choosing. Attempts to do so are generally ignored and in some cases (if you use illegal characters) result in errors that halt your import. You should use this field only when attempting to selectively update a record in the sublist using the automatically generated value for the field. This field is not related to the ID field that is available to be mapped as a body field when SuiteScript is enabled. |
No, but if you are trying to selectively update the sublist, you must include a mapping for the ID of those records you want to modify. |
|
Inactive |
A value of No means that the value displays as an option in your custom list. A value of Yes means the value is hidden. |
No, but if you do not include a mapping for this field, the system uses the default value, which is No. |
|
Translation: (Language) |
Available when both of the following are true:
For each language listed on the Languages subtab, the Import Assistant mapping page offers a corresponding Translation: (Language) field. For each sublist record, you can use these fields to add translations for the corresponding entry in the Custom List Values column for this sublist record. |
No |
|
Value |
The value, or option, to be shown in the custom list. For example, for a list of colors, values might be “red,” “blue,” and “green.” |
Yes |
Custom List Translation
The Custom List Translation sublist lets you add translations for the name of the sublist. For you to use this sublist, both of the following must be true:
-
The Multi-Language feature has been enabled (at Setup > Company > Enable Features).
-
You have added one or more languages to the Languages subtab at Setup > Company > General Preferences.
This sublist is selectively updatable based on the Language field.
|
Field |
Notes |
Required? |
|---|---|---|
|
Language |
Use this field to identify the language of the translation. This field is also the key for the sublist. |
Yes. This field is not marked as required on the mapping page, but if you try to import data to this sublist and fail to map a value for Language, the import fails. |
|
Name |
The translation of the Name body field that corresponds with the locale you entered for this sublist record. |
No |
For general information about translations for custom lists, see Adding Translations for Custom Lists.
The Import Assistant is available at Setup > Import/Export > Import Tasks > Import CSV Records. After you select the record type for import, you choose the import character encoding. For more information, see Select a Record Type for Import and Choose Import Character Encoding.