Importing new users into Active Directory

[Mr_M_Cox]

I know that this has been discussed elsewhere however there is one thing i dont get, How do i get the .csv file for import using csvde. i can use SIMS to export a csv of my users however it does not have the LDAP fields in it. I Need to see a step by step i think. has anyone got one

[tech-man]

I use Account Management Spreadsheet from http://www.wisesoft.co.uk

[Mr_M_Cox]

i have trued that but dont really know how to work it. plus it looks like you still have to type in all the names. i want to export from SIMS and then import into ad

[localzuk]

How about http://www.newfawm.com/adi2.htm? Very easy to use

[plexer]

Or:

 

http://www.dovestones.com/

 

Ben

[Mr_M_Cox]

all of the above mentioned utilities are great however i still dont know how to create my .csv with all the relevent LDAP sections in. is there a better way to do it other that manually typing?

[plexer]

If you export a csv with say first name and surname in 2 columns.

 

Once it's open in excel if you wanted the 3rd column to be username and your format for username is say 07 + initial + surname you would enter:

 

="07" & left(a1,1) & b1

 

This would add 07 and the first character of their name to the surname field to return say 07jbloggs

 

You can use the inbuilt string manipulation tools to work with your data further.

 

Ben

[Mr_M_Cox]

AAARRRGGHHHHH!!!!!!! All I want to do is export childrens names from SIMS.net and import them into AD ready for the new term. i have tried all moring looking at various ways ad i thank all that have provded ideas but i just dont get it. PLEASE SOMEONE explain it!. ian get their names but then how do i ge them into AD and what about those LDAP fields? HELP

[plexer]

what are the ldap fields you are looking for?

 

Ben

[Mr_M_Cox]

As far as i know the atached file is what i am trying to achieve (i typed this one out manually). i want to get the same result but with less administrative effort as i have lots to do. i can get the first and last name from sims but that is it

[Mr_M_Cox]

sorry didnt attach, dontknow why, here is a bit of it

 

objextClass sAMAccountName dn

user 07BBaxter CN = Brendan Baxter, DC=meonin,DC=portsmouth,DC=sch,DC=uk

user 07OBeck CN = Oscar Beck, DC=meonin,DC=portsmouth,DC=sch,DC=uk

user 07JBish CN = Joshua Bish, DC=meonin,DC=portsmouth,DC=sch,DC=uk

user 07FBrooke CN = Fleur Brooke, DC=meonin,DC=portsmouth,DC=sch,DC=uk

user 07MClement CN = Millie Clements, DC=meonin,DC=portsmouth,DC=sch,DC=uk

user 07ECollins CN = Evie Collins, DC=meonin,DC=portsmouth,DC=sch,DC=uk

user 07DCripps CN = Daniel Cripps, DC=meonin,DC=portsmouth,DC=sch,DC=uk

user 07EDavis CN = Elliot Davis, DC=meonin,DC=portsmouth,DC=sch,DC=uk

[localzuk]

You don't need to do any of that as far as I am concerned. All you need is a csv file with usernames and any other details you wish to store, then use Ad infinitum, importing the csv file and choosing the correct column for each thing. Choose where you wish to import them to in the AD, set the home directory information etc...

 

You don't need any LDAP stuff at all.

[SurfingBob]

In our schools we use Chancery Winschool and we also can only export limited information into a csv file similar to you.

 

What I do to prepare the xls for AD import is to make a new excell sheet, import the csv into the second page of this xls. On the first page where you will store your AD formatted sheet I make functions so that I can retrieve information off the second page. This example is in french but it might help you anyways, you'd have to find the english version of concatener. Say if you have your first and last name in collumn A and B in page 2 this would do what you're aiming for.

 

=CONCATENER(Feuil2!B1;" CN = ";Feuil2!A1;" ";Feuil2!B1)

(edited since I forgot you were doing multiple columns. This would cover sAMAccountName)

 

 

The end result would be exactly what you typed.

 

This function would complete the format you're looking for and you can simply drag it down for the rest of your lines. This is the method I use and it doesn't take all that long once you have a sheet ready.

[Outpost]

This might be useful, a dedicated program for importing users into AD from Sims.

 

http://www.anbsoftware.co.uk/

[plexer]

Ok lets say you had a csv with firstnames in column a and surnames in column b.

 

In column c you would enter:

 

="objextClass sAMAccountName dn user 07" & left(a,1) & b1 & " CN =" & a1 & " " & b1

 

This will give you the result as you want it.

 

Copy this down to the other columns and voila.

 

Ben

[bigjb]

if you want to import using csvde, run csvde -f output.csv then find the output.csv file and match the column headings from the output to your user .csv file.

[RabbieBurns]

I use Account Management Spreadsheet from WiseSoft - Resources for IT Professionals

 

Used this for the first time today. Excellent utility.