Having trouble importing a CSVDE.exe file

Snow.bros

Hi All

Just need help here,

Scenario: I have a domain called brosprod.com and inside that domain there is an OU called Productions, I want to create four users in that productions OU.

Now I first created a spreadsheet and have tried creating these users in my virtual lab using CSVDE.exe with this syntax in the command line:

DN, sAMAcountName, userPrincipalName, telePhoneNumber, objectClass

"cn=User01,ou=Productions,dc=brosprod,dc=com", User01, user01@brosprod.com, 011-585-8955, User
"cn=User02,ou=Productions,dc=brosprod,dc=com", User02, user02@brosprod.com, 011-585-8987, User
"cn=User03,ou=Productions,dc=brosprod,dc=com", User03, user03@brosprod.com, 011-585-8852, User
"cn=User04,ou=Productions,dc=brosprod,dc=com", User04, user04@brosprod.com, 011-585-3569, User

I then proceed to import this information to a notepad and save the file as CSVDE in the C drive using the .csv extension using the following syntax:

csvde.exe -i -f C:\CSVDE

When i do this in my virtual lab i get errors instead saying, it could not create a log file.

So do you guys notice any faults in this syntax because i have referenced it to the one written in the exam ref book.

Thanks for any advice!

pjd007

You're running this with an admin a\c ?

Also try using -j switch and specify log file path.

Snow.bros

Thanks for your reply!

I am logged in as the domain controller administrator and I have tried to use the -J switch but the results still persist.

MrJimbo19

You might try creating another folder in the root of c and doing all of this from there. From the looks of it if you are pulling from c:\"filename" or writing to c:\"filename" If I remember correctly I have had problems writing to root via utilities in the past. I know powershell does weird things with it at times.

*Edit* Looking this over again if you are passing the -j with the path of c:\csvde you should be ok as long as the folder CSVDE exists in the root directory. If it does not exist create it and try again.

JasminLandry

Look at how you wrote sAMAccountName.. you're missing a "c". It might be just that.

I'm also not sure about your command. I see that you want to import a file but I don't see the filename or file extension in it. I believe it should be csvde -i -f C:\CSVDE\"filename.csv".

Snow.bros

I have created a folder called scripts and put the csv file in there and have corrected all the above mentioned syntax and imported the file again using the following syntax: csvde.exe -i -f C:\scripts\CSVDE.csv -j C:\script
It comes back with the following error, Error opening input file, 0 entries modified successfully, an error has occurred in the program

I have notice that it had created a csv file and a csv.err file and there is the same errors written into those files and it created those files in the script folder so I changed the folder and the issue still persist.

NotHackingYou

try putting objectClass (and user) at the beginning

Asif Dasl

Format your csvde.csv file like this... it should work then

dn, samAccountName, userPrincipalName, telephoneNumber, objectClass
"cn=User01,ou=Productions,dc=brosprod,dc=com", User01, [EMAIL="user01@brosprod.com"]user01@brosprod.com[/EMAIL], 011-585-8955, User
"cn=User02,ou=Productions,dc=brosprod,dc=com", User02, [EMAIL="user02@nested.local"]user02@[U][COLOR=#0066cc]brosprod.com[/COLOR][/U][/EMAIL], 011-585-8987, User
"cn=User03,ou=Productions,dc=brosprod,dc=com", User03, [EMAIL="user03@nested.local"]user03@[U][COLOR=#0066cc]brosprod.com[/COLOR][/U][/EMAIL], 011-585-8852, User
"cn=User04,ou=Productions,dc=brosprod,dc=com", User04, [EMAIL="user04@nested.local"]user04@[U][COLOR=#0066cc]brosprod.com[/COLOR][/U][/EMAIL], 011-585-3569, User

I just tried it on my server and it worked fine.

You are logged in as administrator? Edit - you are, I skimmed over the thread.

Snow.bros

Finally it worked! thanks for the replies!!!

NotHackingYou

Glad you got it working! Could you post your final working code for reference?

Snow.bros

Asif Dasl wrote: »

Format your csvde.csv file like this... it should work then

dn, samAccountName, userPrincipalName, telephoneNumber, objectClass
"cn=User01,ou=Productions,dc=brosprod,dc=com", User01, [EMAIL="user01@brosprod.com"]user01@brosprod.com[/EMAIL], 011-585-8955, User
"cn=User02,ou=Productions,dc=brosprod,dc=com", User02, [EMAIL="user02@nested.local"]user02@[U][COLOR=#0066cc]brosprod.com[/COLOR][/U][/EMAIL], 011-585-8987, User
"cn=User03,ou=Productions,dc=brosprod,dc=com", User03, [EMAIL="user03@nested.local"]user03@[U][COLOR=#0066cc]brosprod.com[/COLOR][/U][/EMAIL], 011-585-8852, User
"cn=User04,ou=Productions,dc=brosprod,dc=com", User04, [EMAIL="user04@nested.local"]user04@[U][COLOR=#0066cc]brosprod.com[/COLOR][/U][/EMAIL], 011-585-3569, User

I just tried it on my server and it worked fine.

^^^you can reference Asif dasl's code as I also referenced it and it worked fine, but if you can compare my header in my syntax and Asif's header in his syntax, you will notice that i was using capital letters unnecessarily e.i in my header the distinguish name is in capital letters (DN) and sam account is sAMAccountName instead of samAccountName. It turns out I was also pointing it to the wrong OU so I have since pointed it to the right OU and I managed to get it working.