Importing users to AD with CSVDE?
Hello,
I´m trying to import users to AD, the users are exported with csvde from the old AD. Now when I´m importing csvde its complaining about empty columns. The error message is "Error reading attribute list" and when I´m searching Google I found that its probably empty columns but I can't find anything how to get rid of the problem. I have tried to add a value in the empty columns with * but it still wouldn't take it.
importing with csvde -i -f c:\users.csv
I followed this guide: https://www.petenetlive.com/KB/Article/0000794
Any ideas?
I´m trying to import users to AD, the users are exported with csvde from the old AD. Now when I´m importing csvde its complaining about empty columns. The error message is "Error reading attribute list" and when I´m searching Google I found that its probably empty columns but I can't find anything how to get rid of the problem. I have tried to add a value in the empty columns with * but it still wouldn't take it.
importing with csvde -i -f c:\users.csv
I followed this guide: https://www.petenetlive.com/KB/Article/0000794
Any ideas?
Also, can you post a row from the CSVDE file? Replace data as necessary to obfuscate any sensitive information.
ASKER
Hello,
I´ve uploaded the csv file, I removed a lot of rows so here's only 3 rows but you can see how it looks.
I have exported with Powershell also but couldn't find how to get all the OU in place to. With CSVDE it remain all the OU´s with different locations, in that way I don't have to move the users to different OU´s.
ExpertsExchange.csv
I´ve uploaded the csv file, I removed a lot of rows so here's only 3 rows but you can see how it looks.
I have exported with Powershell also but couldn't find how to get all the OU in place to. With CSVDE it remain all the OU´s with different locations, in that way I don't have to move the users to different OU´s.
ExpertsExchange.csv
You say that CSVDE file came out of a DC? Because there's a weird mix of commas and semicolons being used to separate values and the "CSV" in "CSVDE" stands for "Comma-separated values". That feels like something is wrong right off the bat. Loading the file in Excel shows the column names don't align with the columns because of this issue.
Replacing all the semicolons with commas, saving the file, and opening it again in Excel makes it a little more readable, but none of the columns line up properly still. One wonders if this file is the result of several files being merged.
My suggestion would be to re-try the export, but export only those fields that are absolutely necessary to move from one domain to the other. Alternately , re-run the export, export everything, then groom the export file prior to importing it. The command to output everything is:
CSVDE -f output.csv
The output should look like the sample I've attached.
CSVDE_Demo_Data.csv
Replacing all the semicolons with commas, saving the file, and opening it again in Excel makes it a little more readable, but none of the columns line up properly still. One wonders if this file is the result of several files being merged.
My suggestion would be to re-try the export, but export only those fields that are absolutely necessary to move from one domain to the other. Alternately , re-run the export, export everything, then groom the export file prior to importing it. The command to output everything is:
CSVDE -f output.csv
The output should look like the sample I've attached.
CSVDE_Demo_Data.csv
ASKER
Hello,
Sorry the delay.
I don't see any semicolons in the file. However, could it be due to in the guide one is needed to remove some columns and when I am importing the CSV into an Excel file it automatically break up the commas into columns so it is easier to remove columns that I don't need. After that I saved the file as CSV, maybe its here it goes wrong? Is there another way to save the file back to commas?
Sorry the delay.
I don't see any semicolons in the file. However, could it be due to in the guide one is needed to remove some columns and when I am importing the CSV into an Excel file it automatically break up the commas into columns so it is easier to remove columns that I don't need. After that I saved the file as CSV, maybe its here it goes wrong? Is there another way to save the file back to commas?
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Instead of CSVDE, Could you try with powershell?
https://social.technet.microsoft.com/wiki/contents/articles/24541.powershell-bulk-create-ad-users-from-csv-file.aspx
Cheers !