How does the Data Loader handle Multi-Select Lookup Custom Fields?

The Data Loader can handle Multi-Select Lookup Custom Fields by processing them as a list of values separated by Comma - e.g. CSV.




Your column in your Excel file / CSV should use Quotes for the fields, and in turn, it should look like this:




", , .. "




During the import, the system will check if the Multi-Select Lookup Custom Field has each in its collection. If it has, it will save the value against the record being loaded (i.e. Organisation, Contact, Note etc). If it doesn't contain the value, then the will be added into the Custom Field items and then that value will be saved against the record being loaded.

6 views0 comments

Recent Posts

See All

The purpose of this utility is to allow ChilliDB users to import multiple records retrieved from a list of values stored in an external CSV, XML, XLS, or XLSX file. Currently it is possible to import

Some tips / Notes concerning the files used for data import: When uploading excel files you don’t need to use special column delimiters or row delimiters Make sure the data in your excel columns match

Address validation is available to Hosted clients through System -> Data Management -> Address Validation menu. Note, the user should have all appropriate security tickets to see this menu. We source