CSVDE import failing

Posted on 2011-05-12
Last Modified: 2012-05-11
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",

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?
Question by:subversive99
    LVL 9

    Expert Comment

    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.


    Author Comment

    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,


    Accepted Solution

    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.

    Author Closing Comment

    Solved it myself.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    The saying goes a bad carpenter blames his tools. In the Directory Services world a bad system administrator, well, even with the best tools they’re probably not going to become an all star.  However for the system admin who is willing to spend a li…
    [b]Ok so now I will show you how to add a user name to the description at login. [/b] First connect to your DC (Domain Controller / Active Directory Server) SET PERMISSIONS FOR SCRIPT TO UPDATE COMPUTER DESCRIPTION TO USERNAME 1. Open Active …
    This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
    This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now