CSV file format for import

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

0 JohnnyQuest 2 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.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 JohnnyQuest 2 months ago in reply to JohnnyQuest

Pro tip: Use a text editor that will show you non-printable characters (tabs, LFs, CRs) to sanity check the contents of your file.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 shane seagreen 2 months ago

So looking at this with fresh eyes this morning, I realised I was missing one of the column headers, appreciate the input though.

Thanks
Cancel
Up 0 Down

Reply

Verify Answer

Cancel