70-290 help:trouble using import user objects using CSVDE

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Hey

I'm studying the MS press book server 2003 exam 70-290, and in chapter 3 page 3-29 exercise 3: Import User Objects Using CSVDE, it keeps saying syntax error on line 2 in command prompt. Here is the commands:

DN,objectClass,sAMAccountName,sn,givenName,userPrincipalName
"CN=Danielle Tiedt,OU=Employees,
DC=contoso,DC=com",user,dtiedt,Tiedt, Danielle,[email protected]
"CN=Lorrin Smith-Bates,OU=Employees, DC=contoso,DC=com",user,lsmithbates,
Smith-Bates,Lorrin,[email protected]

has anybody have had the same problem?

thanks

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

create three lines of text like this;
DN,objectClass,sAMAccountName,sn,givenName,userPrincipalName

"CN=Danielle Tiedt,OU=Employees,
DC=contoso,DC=com",user,dtiedt,Tiedt,Danielle,[email protected]

"CN=Lorrin Smith-Bates,OU=Employees, DC=contoso,DC=com",user,lsmithbates,Smith-Bates,Lorrin,[email protected]

 

It's given me a syntax error on line 3 now.

 

You have a space in this bit on line 3 you need to remove:
"CN=Lorrin Smith-Bates,OU=Employees, DC=contoso,DC=com"

 

Okay here is the full error report in command prompt:

Connecting to "(null)"
Logging in as current user using SSPI
Importing directory from file "c:\user.csv"
Loading entries.
Parsing error. Last read character is 32
Syntax error on line 3
0 entries modified successfully.
An error has occurred in the program
No log files were written. In order to generate a log file, please specify the log file path via the -j option.

thanks

 

Yep, I'm on the same section and spotted the space in the book and thought that was wrong. Remove the spaces and it all works ok

 

Just spotted this, typos and hard to see spaces are the bane of an IT technicians life, so good spot all

 

okay I removed all the spaces but still getting the same error message. Can someone show me how to type it in notepad? Sorry but I just want to move on to other exercises, and this one is just killing me.

thanks for your help so far

 

What happens if you copy the below into notepad into a new csv document, and then try importing?

DN,objectClass,sAMAccountName,sn,givenName,userPrincipalName
"CN=Danielle Tiedt,CN=Employees,DC=contoso,DC=com",user,dtiedt,Tiedt,Danielle,[email protected]
"CN=Lorrin Smith-Bates,CN=Employees,DC=contoso,DC=com",user,lsmithbates,Smith-Bates,Lorrin,[email protected]

Just a quick note, open the file after you change to csv to make sure formatting is correct

 

Okay I tried using CN=Employees command, and its giving error mesage:

Add error on line 2:no such object.
The sever side error is "Directory object not found"

Now when I change it back to OU=Employees, it will add Danielle Tiedt to employees in active directory, but it will not add lorrin smith-bates. It will sometimes say "user already exists". Is it because I used lorrin smith-bates in previous exercises? But it still should move her to the Employees folder right?

 

Ok, what I would do is do a export via csvde and compare the output, to what you are trying to import.

 

It worked okay with the exporting, no errors.

 

Ok, did it export a lorrin smith-bates user?

If so compare that to your import file (it prob will be different as the headings will change, but see if you can see anything that is different to your import file)

 

okay where would it export to so I can look at the file?

 

use a command similar to below (name it as you see fit) -f sets the output file path

CSVDE -f c:\test.csv

then do a find for lorrin to see how it outputs, it may be working fine just cannot overwrite the duplicate, i think there is a csvde command switch to do overwrites, cant remember at mo, just do a csvde /? at the command prompt it should tell you.

 

DN,objectClass,sAMAccountName,sn,givenName,userPrincipalName
"CN=Danielle Tiedt,CN=Employees,DC=contoso,DC=com",user,dtiedt,Tiedt,Danielle,dan [email protected]
"CN=Lorrin Smith-Bates,CN=Employees,DC=contoso,DC=com",user,lsmithbates,Smith-Bates,Lorrin,[email protected]

You create employees and so it would not be a common name (cn) but a Organizational Unit (ou). It should be ou=Employees

As for the practice. It does have a mistake. I have 2 lorrin smith-bates in seperate OUs. Go to the OU in question and move lorrin smith bates to anywhere (e.g. users) and it will work.

 

It exported her to notepad. Her name was on the last line, and there were no errors. So I guess it worked okay. I really need to read the VBS scripting that's on the cd-rom that came with this set, because i'm not familiar with these commands.

Thanks for the help everybody

 

I have as well,

and this is what I've learned.

Other than making sure the syntax is correct, the error on line 2 is because you cannot use Csvde to duplicate certain attributes if those attributes already exist in Active Directory.


the UPN ([email protected]) must be unique in within AD forest and the sAMAccountName (lsmithbates)

Because you have already created the user account Lorrin Smith-Bates, the csvde will give you errors. If you add a different name, it should work fine.

you may need to hit the refresh button in order to see the changes

Hope that helps.