• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3117
  • Last Modified:

CSVDE import failing

Hi, I am trying to create a number of contacts via csvde. I have a csv with the following column headers. Also the 2nd line indicates what I have for a user format

objectClass, DN, displayName, mail
contact, "CN=Bob Loblaw, OU=Contacts,OU=_domaincontainer,DC=mydomain,DC=com, Bob Loblaw", bob.loblaw@mydomain.com

I get the following error when I try to run it:

C:\Windows\system32>csvde -i -j c:\scripts -f c:\scripts\contactimport05122011.csv
Connecting to "(null)"
Logging in as current user using SSPI
Importing directory from file "c:\scripts\contactimport05122011.csv"
Error reading attribute list
0 entries modified successfully.
An error has occurred in the program

I'm assuming it's an issue with the way I have my columns set up. Anyone?
  • 3
1 Solution
Check the first parameter in your file ...

CN=Bob Loblaw, OU=Contacts,OU=_domaincontainer,DC=mydomain,DC=com, Bob Loblaw

I have never seen a ", Bob Loblaw" at the end.

subversive99Author Commented:
Sorry, the quotes should have ended after the com

This is it. Stuff between the quotes is in the column below DN.

objectClass, DN, displayName, mail
contact, "CN=Bob Loblaw, OU=Contacts,OU=_domaincontainer,DC=mydomain,DC=com", Bob Loblaw, bob.loblaw@mydomain.com

subversive99Author Commented:
Hey, I got it. I opened the csv using notepad (instead of excel which I had been using) and there were a bunch of ,,,,, after each row of data. I went back into excel and deleted a whole bunch of columns to the right of my final column of data and now it worked. I guess the commas got left behind as I cleaned up a spreadsheet into my csv. Thanks for your help.
subversive99Author Commented:
Solved it myself.

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now