crcevans
asked on
CSVDE Error -
CSVDE import says
Parsing error: expect comma after column 1. Last read character is 26
Syntax error on line 2
Contents of the csv is in the code window.
Any ideas. Google isn't yielding much so far...
Parsing error: expect comma after column 1. Last read character is 26
Syntax error on line 2
Contents of the csv is in the code window.
Any ideas. Google isn't yielding much so far...
DN,objectClass,name,cn,displayName,userAccountControl,countryCode,sAMAccountName,sn,c,l,st,postalCode,givenName,initials,co,company,streetAddress,userPrincipalName,title,telephoneNumber,facsimileTelephoneNumber,department,mobile,postOfficeBox,pager
""CN=Dennis L Featherngill,OU=Import,dc=crcus,dc=local"",user,Dennis L Featherngill,Dennis,Dennis L Featherngill,514,840,DFeatherngill,Featherngill,US,Tulsa,OK,74116,Dennis,L,United States,
ASKER
Thanks. Should have mentioned that I started with a CSVDE export to get the correct columns.
OK, great, the columns are correct. have you cross referenced the data to your's just to se where you are going wrong. it would appear that you are missing something in your user details somewhere.
I will have a look too
Krystian
I will have a look too
Krystian
First thing i notice
I'm not sure you need those quotes around your DN
Krystian
I'm not sure you need those quotes around your DN
Krystian
ASKER
Removing the extra quotes yields a different error message:
Add error on line 2: Invalid DN Syntax
The server side error is "Multiple values were specified for an attribute that c
an have only one value."
Add error on line 2: Invalid DN Syntax
The server side error is "Multiple values were specified for an attribute that c
an have only one value."
I'm trying to do your csv into my domain too. and geting errors
I'm working on why :)
Krystian
I'm working on why :)
Krystian
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
HI
I managed to get this one working
Even with the CN which is odd if what henjoh09 says is true :)
Krystian
I managed to get this one working
Even with the CN which is odd if what henjoh09 says is true :)
Krystian
DN,objectClass,cn,distinguishedName,name,userAccountControl,countryCode,sAMAccountName,displayName,sn,givenName,userPrincipalName,c,l,st,postalCode,initials,co
"CN=Dennis L. Feathergill,OU=Import,dc=crcus,dc=local",user,Dennis L. Feathergill,"CN=Dennis L. Feathergill,OU=Import,dc=crcus,dc=local",Dennis L. Feathergill,514,840,DFeathergill,Dennis L. Feathergill,Feathergill,Dennis,DFeathergill@crcus.local,US,Tulsa,OK,74116,L,United States
What i did in the end was create the user manually in my AD then exported it. removed all fields to match yours and imported fine (after i deleted the user i created manually)
Krystian
Krystian
ASKER
My CSV started with a user export. Also, I tried both suggestions: First I removed the CN columns, and ran the import, and then removed the double-quotes, and each yielded the same result.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
did you try my sample as it was, changing nothing?
It worked ok for me - i'll double check it again.
I had the same issues as you did with your original sample.
Krystian
It worked ok for me - i'll double check it again.
I had the same issues as you did with your original sample.
Krystian
ASKER
Thanks guys! Working now...will update the thread.
ASKER
It was the extra set of quotes, as well as the extra CN column that was hanging me up.
Thanks for helping me out!
Thanks for helping me out!
Can i suggest you run this first on your domain
csvde -f C:\testOutput.csv -r (ObjectClass=user)
It will help you ensure you get the corect info in your csv file
Krystian