Import values and append to a multilist

I have thousands of parts that have a field on PAGE_TWO that is a multilist.  There are already values in that field.  Now I want to use the Import tool from the web client to append another value to that field.  I have tried it with one part in a csv file, but it just replaces what is currently there with my new value.  Is the Import tool capable of appending without wiping out the existing values in a multilist attribute?

No Files Were Attached
mrmathison Agile Talent Asked on January 10, 2019 in Product Collaboration.
Add Comment
2 Answer(s)

You cannot do that. There is no way to get Import to add data to the end of an existing value (or set of values). It assumes that the data has the complete value for each attribute that has a value in the data file.
 What I would suggest is to export what the current values are for the parts you need to update, write a macro (or edit the exported data file) to add the value(s) that are needed to the multilist attribute, and to then run that file through Import. That way you will have all the list values that you need.

Kevin Cummings Agile Angel Answered on January 11, 2019.
Add Comment

Agree with Kevin here, OOTB Import doesn’t support appending values and writing a Macro by concatenating existing values with expected values will do the work. 

Also, you can develop simple SDK based utility to read the excel file and append the values to Agile Object. Which you can reuse in future as well. Let me know if you need any help with that.

Arif Agile Angel Answered on January 11, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.