/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


Import assets with multi-select values

05/21/2020 132 views

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

Comments


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

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

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