CSVDE Import fails with error "Invalid Syntax on line 2, The parameter is incorrect." (Active Directory, Server 2008)
Posted on 2011-03-17
I am trying to import users into AD using CSVDE but it fails with "Invalid Syntax on line 2: The parameter is incorrect."
We are running Server 2008 R1 32-Bit STD (Domain controllers are set to a 2003 Functional Level). We've got a single domain forest, nothing too complicated, I am busy trying to create AD Users for one of our divisions.
My File Format, columns, headings etc. are definitely 100% correct and it can't be due to the incorrect content in the .csv File, here is my reason for saying so:
I did the following test:
I log onto our "main" AD Domain Controller / Global Catalog Server with the Domain Administrator account, go to the command prompt, run the csvde -f adexport.csv in order to generate a file with the correct content (headings columns etc.) that contains all our existing AD objects.
I then open this .csv file in Microsoft Excel 2007, select all the rows except the 1st one (with the headings) and the last one (which is an AD user I created last) and delete the rest, the file then effectively still contains the exact same columns, the same headings in row 1 of the columns and the last row with the last AD user I created, so the format should be 100% correct.
I then try and import this file back into AD with the CSVDE -i -f adexport.csv and immediately get the error "Invalid Syntax on line 2, The parameter is incorrect." without even modifying or adding any parameters in the file.
I then thought it might be because the AD user in the .csv file already exsits in AD, so I went to dsa.msc on the same Domain Controller and deleted the user from AD, then ran the CSVDE -i -f adexport.csv again but to no avail, still the same error.
So my question is basically: why am I getting an error when trying to import the .csv file generated into AD generated by CSVDE if I have not touched the columns, column headings etc? What am I missing or doing wrong?
Thank you for any assistance.