Having trouble importing a CSVDE.exe file

Snow.bros · February 2014

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 · February 2014

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

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

Snow.bros · February 2014

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 · February 2014

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 · February 2014

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 · February 2014

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 · February 2014

try putting objectClass (and user) at the beginning

Asif Dasl · February 2014

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 · March 2014

Finally it worked! thanks for the replies!!!

NotHackingYou · March 2014

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

Snow.bros · March 2014

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.

Having trouble importing a CSVDE.exe file

Comments