We can import data to the Multiselect field as follows:
It is required to use a separator between values in multi-select fields. As default, separator is set to pipe “|”.
Example:
value1|value2|value3
The delimiter can be customized into another single character in Import Assistant > Import Options > Advanced Options > Custom Multi-Select Value Delimiter.
Solution steps:
1. Navigate to Setup > Import/Export > Import CSV Records.
2. On Scan & Upload CSV File page:
- Import Type
- Record Type
- Choose CSV from own PC station. Once user is satisfied, click Next.
3. Select respective Data Handling option. For importing new records mark Add. After that continue by pressing Next button.
4. Expand Advanced Options menu and set desired value in Custom Multi-Select Value Delimiter field and go to next step by clicking Next.
5. Map all fields from the CSV file to NetSuite fields and continue by clicking Next.
6. Initiate the CSV Import by entering Import Map Name and clicking Save & Run.
Please, be aware that update of multi-select field will automatically overwrite previous values in respective multi-select field. Therefore all intended data for import have to be contained in CSV file (including previous selection).