Connecting Tech Pros Worldwide Help | Site Map

CSVDE in Server 2003 Active Directory

Newbie
 
Join Date: Jul 2008
Posts: 7
#1: Aug 5 '08
Hi all,

working in a school and coming into a new school year I have to add 180+ new users to the school network ready for September.

I've been using CSVDE command line app for a while now, to perform AD exports of users and computers, but for some reason cmd keeps giving me an error when trying to import users

As always the faithful windows doesn't tell me why the import failed... it just tells me it failed.

Has anyone had to import users using CSVDE before? if so how did you get it to work

I'm not using anything fancy. Ive tried using the following command lines:

csvde -i -f <filename>
csvde -i -f <filename> -k
csvde -i -f <filename> -s <servername>
csvde -i -f <filename> -b <username_password>
csvde -i -f <filename> -s <servername> -b <username_password>

if you guys have used CSVDE before could you maybe also post the column headers you used in the csv files you have. Just to check I haven't got them wrong

I'll try it again tomorrow and post a screenshot of the cmd window, what i entered and what it tells me when it runs

thanks in advance!!
Needs Regular Fix
 
Join Date: Mar 2008
Posts: 283
#2: Aug 5 '08

re: CSVDE in Server 2003 Active Directory


see this link -

http://www.computerperformance.co.uk/Logon/Logon_CSVDE.htm
Newbie
 
Join Date: Jul 2008
Posts: 7
#3: Aug 7 '08

re: CSVDE in Server 2003 Active Directory


I've been on that site many a time in the last 2 days!! haha, it didn't give me then answers I wanted!!

I eventually got the solution after decyphering some examples from a Win2k3 server book and a bit of trial and error, however now I have a new problem!!!!!!!!


The import works fine, all the user accounts are created, added to AD, have all the info I need to get started, HOWEVER there is no home directory created (even though I specify the home folder in the csv file) and the user can only log onto the network with a local profile, not a roaming profile (I'm guessing because there is no home drive created or something to do with the profile path, but again that is specified in the csv file, and the accounts get set up exactly as all the other working accounts in AD)

any help on this issue???
chars
Newbie
 
Join Date: Jul 2008
Posts: 7
#4: Aug 7 '08

re: CSVDE in Server 2003 Active Directory


Right, I've managed to fix the problem

after crawling through google for 2 days reading all these fancy complicated ways of creating the home folders and assigning the permissions, using vb scripts and creating new cmd programs I've finally found a fix

A 30 second fix

that is as easy as I thought it should be!!

all I did was:

After importing all the user accounts from the csv file I selected all of the new accounts and right-click > properties.
In the multiple user properties box I clicked on profile, checked the box for Home Folder, selected the drive mapping that I wanted and then used a wildcard in the Connect To: box that went like this

\\storage-01\Users\Students\2008\%USERNAME%

Viola!! All the home folders were automatically created for me with the permissions set to the user!
Needs Regular Fix
 
Join Date: Mar 2008
Posts: 283
#5: Aug 9 '08

re: CSVDE in Server 2003 Active Directory


Glad to hear you got it sorted, sorry I have not been on for a few days otherwise I would have replied.
Reply