/build/static/layout/Breadcrumb_cap_w.png

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:

A38cbhmUVY+5AAAAAElFTkSuQmCC

My asset:

9+Kb2YNAEAgCQSAIBIHrIvAHcWLGIjRjCSgAAAAASUVORK5CYII=


The idea is how I do the import, the field Monitor have to be two values selected.

Thank you all.


0 Comments   [ + ] Show comments

Answers (1)

Posted by: Hobbsy 3 years ago
Red Belt
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 3 years ago
  • Hello Hobbsy. The importation it's working now. My mistake it was the comma between the two select values. - winnertako 3 years ago
    • Awesome stuff, well done - Hobbsy 3 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 3 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ