2 Replies Latest reply on May 17, 2018 1:29 PM by Derek Phillips

    CSV Import

    Derek Phillips

      Trying to import csv data from command line (Detail node) and one of the fields is a list. 

       

      From tw_imp_csv - BMC Discovery 10.2 - BMC Documentation :

       

      "The ip_addrs field is a list and the value starts with a '[' character so it is converted into a list. "

       

      Is that all that's required for a given attribute in the source file to be treated as a list?  At the moment, all that happens is the field is imported, but as a single string, complete with square brackets and quotes.

        • 1. Re: CSV Import
          Andrew Waters

          It is a little more complicated than that. It depends upon what is in your taxonomy.

           

          If you have an entry in the taxonomy telling the system it is a list of string it will do the conversion.

           

          If you do not have an entry (or it is the wrong kind) then it will not. If you have no entry and you using --force to bypass the taxonomy checking then everything is put in as a string.

          1 of 1 people found this helpful
          • 2. Re: CSV Import
            Derek Phillips

            Yeah, I thought it would require a taxonomy definition/extension.  It wouldn't be a bad thing if the documentation was clear on this point - I know a lot of folks might not use the cli import, but still.