Value list are maintained in "Studio → PIM Studio → Settings → value list → PIM"

Any change in value must be validated by List owners (link to update version)

Syensqo IS - Customer Support > Value List Import and Export > image2021-6-14_15-38-30.png

All values/attributes/products can be exported in either csv or excel format.

Export as Excel File is a feature in the CS system that enables easy export of data to Microsoft Excel (or other programs), make new changes and again re-import the data.

Attributes used in Export Files There are list of attribute present in exported CSV or excel file, which will help us in importing new values.

Steps to update or insert values to the values list:

Step 1: Create a new Value list which has to be added with Sub list. (Ignore if value list already created)

Step 2: Create a new values in the value list (Just to identity last unique ID added for last value created)

Syensqo IS - Customer Support > Value List Import and Export > image2021-6-14_13-48-13.png

note: Above we have created a test value which has 4175 as a new unique ID. For upcoming value addition we have to increment from there.

Step 3: Export value list.

Select the new value test created and export as excel as shown below.

Step 4: Add the new values in excel exported from last step

Export CSV/Excel files

Steps to run an export

Go to the list view mode. Example "PIM_MarketSegmentApplication" value list.
Select the values/products/attributes, whose data you want to download and click on the corresponding checkboxes.
To download all the data, simply click on the APPLY ALL or ID checkbox in the list menu. OR
Click on MARKED at the top bottom of the list-menu to select all data.
Click on MARKED again. Select EXPORT AS EXCEL FILE or EXPORT AS CSV FILE.

A pop-up appears asking to confirm your action clicking on OK.

Syensqo IS - Customer Support > Value List Import and Export > image2021-6-14_14-3-10.png

Download and save the generated file.

Open the downloaded file with Microsoft Excel and perform your changes.

Attributes used in Export Files

Take a look at the downloaded Export files in XLS format. Go through the explanation of the attributes used in the various file formats

Syensqo IS - Customer Support > Value List Import and Export > image2021-6-14_13-54-32.png

Filed name	Information	Notes / Supporting images
_ImportAction	U for Update. D for Delete I for Insert A for Add E for External Key	Filed which specifies the action to be performed on the value added in the excel list
_TreeSort	Used to give priority when sorting filed when viewed	Generally set as 0
ValuerangevalueID	unique ID given for the attribute that is to be created or already present when updating	Usually it will be the increment of last recent added value. To know the last unique values used, create a new value inn front end and get the ID Create a new values in the value list (Just to identity last unique ID added for last value created)
ValuerangetypeID
ExternalKey
ParentID
IsFolder
Icon
Value_2
SortOrder_2
Value_1
SortOrder_1
Value_3
SortOrder_3