Import assets with multi-select values
Hello,
I'm trying to use de Import Assets tool. How can I import multi select values ?
For example, I've one field called Monitor (multi select type). Now, how can I import values from csv file?
My csv file:
My asset:
The idea is how I do the import, the field Monitor have to be two values selected.
Thank you all.
Answers (1)
So looking into this, the multiselect data field within the asset tables are stored as comma separated values as you would enter them in the setup of the asset type.
To import multiple values into that field simply create the excel file with the selected values.
for example if your multi select contains 4 values "Value1,Value2,Value3,Value4" and you want 2 and 4 selected, your column in excel will have Value2,Value4 in the cell.
When you save the file as a CSV (UTF-8 format is best) it somehow knows that there is a comma separated list within the column so imports the value of "Value2,Value4" into your multi select field
Comments:
-
Thank you Hobbsy. I will try this today. - winnertako 4 years ago
-
Hello Hobbsy. The importation it's working now. My mistake it was the comma between the two select values. - winnertako 4 years ago
-
Awesome stuff, well done - Hobbsy 4 years ago
-
I've bad news :(
Today I'm trying to import more assets but I'm facing the same problem with the multi selected values :(
For example for the column Monitor I've this values "HP EliteDisplay E232 [A],HP EliteDisplay E232 [B]" in my csv file, but during the importing two lines are create :( - winnertako 4 years ago
