locked
Import "Custodian" values with CSV RRS feed

  • Question

  • I need to import in Service Manager Database bulk computer CI values, as "Status" and "Custodian". I read with attention the article  to http://blogs.technet.com/b/servicemanager/archive/2010/09/24/importing-computers-via-csv.aspx link, but (I'm newby) I have some problem as to import the field Custodian by CSV. About the example files the document suggest to format the file about Alias=Custodian value with the property "Domain" (required) and "User Name". The result is that the fields are populated with the value domain.user, not only the user name. If I cancel "Domain" CSV import come back with an error.

    How to resolve the problem to format the .xml CSV file in right way.

    thanks for the help

    mario

    Wednesday, May 4, 2011 12:59 PM

Answers

All replies

  • Hey Mario

    This is a bit late, but I have written an article about (almost) that. Should help with your problem --> http://blog.scsmfaq.ch/2011/05/20/csv-import-of-objects-using-type-projections/

    regards
    Marcel


    SCSMfaq - http://blog.scsmfaq.ch ##### Microsoft Virtualization and Systems Management Partner - http://www.itnetx.ch
    • Marked as answer by mario2007 Saturday, May 21, 2011 5:50 AM
    Friday, May 20, 2011 9:45 PM
  • Thanks, Marcel. I thought I'd returned all the articles but for some reason I missed that one.

    regards

    Mario

    Saturday, May 21, 2011 5:50 AM
  • Hey Mario

    That's maybe because I wrote the article yesterday and it was not there before :) But good that it helped you.

    regards
    Marcel


    SCSMfaq - http://blog.scsmfaq.ch ##### Microsoft Virtualization and Systems Management Partner - http://www.itnetx.ch
    Saturday, May 21, 2011 9:28 AM