CSVDE
Help!!
objectClass,sAMAccountName,DN,Member
Group,Accounting,"cn=Accounting,OU=Groups,DC=contoso,DC=com",
"cn=Linda.Mitchell,OU=People,DC=contoso,DC=com;
cn=Scott.Mitchell,OU=People,DC=contoso,DC=com"
When I try the above CSVDE import command that is
support to create the Accounting group, then add
inda and scott to the group's member attribute,
the Accounting groups gets created, but the users
are not added to the group and I receive the error message below:
Connecting to "(null)"
Logging in as current user using SSPI
Importing directory from file "importgroups.csv"
Loading entries
2: cn=Accounting,OU=Groups,DC=contoso,DC=com
Attribute 0) objectClass: Group
Attribute 1) sAMAccountName: Accounting
Entry modified successfully.
Parsing error: expecting value at column 1. Last read character is 0
Syntax error on line 5
1 entry modified successfully.
An error has occurred in the programAlrick
February 5th, 2011 1:12pm
You are using the command incorrectly. You could only accomplish what you are trying to do with a script. That you can find at the TechNet Script Center. Your other option is to create two CSVDE files and run two separate commands. The first to create
the group and the second to add users to the group. The reason is that you need the group to be created as a separate operation. When you try this with a single line, you are essentially asking CSVDE to create a group and add a user in one LDAP transaction.
That is not how it works.
Look at the TechNet Script Center
ttp://technet.microsoft.com/en-us/scriptcenter/default.aspx scroll down to the bottom, click Active Directory on the left and then click the appropriate entry on the right - like Users and Groups.
You can also check out the CSVDE TechNet Wiki article
http://social.technet.microsoft.com/wiki/contents/articles/how-to-troubleshoot-csvde-import-and-export.aspx that I am actually updating right now with a couple of additional examples.
Also, I have found Guy's examples at Computer Performance
http://www.computerperformance.co.uk/Logon/Logon_CSVDE.htm very helpful in the past. They might help you now.
Good luck and please post again if you are still having issues.
Free Windows Admin Tool Kit Click here and download it now
February 5th, 2011 4:30pm
Thanks very much Kurt. This makes sense as I had done the operation separately, however I was following the Server 2008 Training guide, this was driving me crazy as I decided I would not go on until I just this resolved. I am getting the hang of using
the community forum. Thanks guys!Alrick
February 5th, 2011 5:49pm
Ah, okay. I have not seen that particular guide yet, but I would have hoped by 2008 we could get this information documented in books so that it could be understood. I hope that the TechNet Wiki article I cited above will help. I created it because a colleague
of mine had gone through the forum looking for popular topics from which we could create articles that would help people. So, if the MS Press books are generating questions, then it would be good for us to help resolve them both in the forum and then ask that
O'Reily post errata or further explanation to clarify. In the interim, I want to update that TechNet Wiki article to get this right. Eventually, we can then put that information in the TechNet Library or at least refer to it, so that people can find the help
they need. I know it is very frustrating working with CSVDE. I used to be a trainer teaching Windows 2000 Server and later Windows Server 2003. When we had a module about CSVDE, I was always very busy helping people find typos, which is really challenging
in Notepad. That is why I recommend downloading the free Notepad2 or similar editing utility that points out line numbers, whitespace, end of sentences, and so on (http://sourceforge.net/projects/notepad2/). I
am sure there are many other good ones, I am just suggesting this one because I use it frequently.
Free Windows Admin Tool Kit Click here and download it now
February 5th, 2011 6:25pm


