• State Not Answered
  • Replies 3 replies
  • Subscribers 20 subscribers
  • Views 917 views
  • Users 0 members are here
Options
Related

CSV file format for import

shane seagreen
10 months ago

Hello,

I am using Powershell to create a csv file to use for input with Migration manager for AD. However, when I attempt import the powershell created csv I either get a message saying the file is in an invalid format or nothing happens.

I noticed when I export from a collection, the file encoding is Unicode, have tried adjusting my exported file format to use the same encoding with no luck. I am also exporting specifying the tab delimiter. 

If I paste the data I extract from my file into the Quest created export file, and make no changes just save, the import into the new collection works fine.

Any ideas?

Thanks,

Shane

Parents
  • 0 10 months ago

    Thoughts:

    I generate a lot of input files with Powershell and never bother to make them unicode.  That would be most important IF your objects had accented characters in their names and/or you are putting other localized data in the file (attribute contents).

    Make sure that there are no trailing tabs on any of the lines of the file, no blank lines and that there are no quotation marks around your output.


Reply
  • 0 10 months ago

    Thoughts:

    I generate a lot of input files with Powershell and never bother to make them unicode.  That would be most important IF your objects had accented characters in their names and/or you are putting other localized data in the file (attribute contents).

    Make sure that there are no trailing tabs on any of the lines of the file, no blank lines and that there are no quotation marks around your output.


Children