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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics