Systems Management Question

Import assets with multi-select values

05/21/2020 190 views


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.

0 Comments   [ + ] Show comments


All Answers


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

Answered 05/21/2020 by: Hobbsy
Red Belt

  • Thank you Hobbsy. I will try this today.
  • Hello Hobbsy. The importation it's working now. My mistake it was the comma between the two select values.
    • Awesome stuff, well done
      • 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 :(
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