+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 17
How do you do....it? Thread, Importing new users into Active Directory in Technical; I know that this has been discussed elsewhere however there is one thing i dont get, How do i get ...
  1. #1
    Mr_M_Cox's Avatar
    Join Date
    May 2007
    Location
    Portsmouth
    Posts
    155
    Thank Post
    5
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Importing new users into Active Directory

    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

  2. #2
    tech-man's Avatar
    Join Date
    Jul 2005
    Location
    The Pub
    Posts
    171
    Thank Post
    13
    Thanked 16 Times in 11 Posts
    Rep Power
    21

    Re: Importing new users into Active Directory

    I use Account Management Spreadsheet from www.wisesoft.co.uk

  3. #3
    Mr_M_Cox's Avatar
    Join Date
    May 2007
    Location
    Portsmouth
    Posts
    155
    Thank Post
    5
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Importing new users into Active Directory

    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

  4. #4

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,684
    Thank Post
    516
    Thanked 2,453 Times in 1,899 Posts
    Blog Entries
    24
    Rep Power
    833

    Re: Importing new users into Active Directory

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

  5. #5

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,613
    Thank Post
    648
    Thanked 1,618 Times in 1,448 Posts
    Rep Power
    421

    Re: Importing new users into Active Directory


  6. #6
    Mr_M_Cox's Avatar
    Join Date
    May 2007
    Location
    Portsmouth
    Posts
    155
    Thank Post
    5
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Importing new users into Active Directory

    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?

  7. #7

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,613
    Thank Post
    648
    Thanked 1,618 Times in 1,448 Posts
    Rep Power
    421

    Re: Importing new users into Active Directory

    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

  8. #8
    Mr_M_Cox's Avatar
    Join Date
    May 2007
    Location
    Portsmouth
    Posts
    155
    Thank Post
    5
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Importing new users into Active Directory

    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

  9. #9

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,613
    Thank Post
    648
    Thanked 1,618 Times in 1,448 Posts
    Rep Power
    421

    Re: Importing new users into Active Directory

    what are the ldap fields you are looking for?

    Ben

  10. #10
    Mr_M_Cox's Avatar
    Join Date
    May 2007
    Location
    Portsmouth
    Posts
    155
    Thank Post
    5
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Importing new users into Active Directory

    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

  11. #11
    Mr_M_Cox's Avatar
    Join Date
    May 2007
    Location
    Portsmouth
    Posts
    155
    Thank Post
    5
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Importing new users into Active Directory

    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

  12. #12

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,684
    Thank Post
    516
    Thanked 2,453 Times in 1,899 Posts
    Blog Entries
    24
    Rep Power
    833

    Re: Importing new users into Active Directory

    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.

  13. #13

    Join Date
    Apr 2007
    Posts
    24
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Importing new users into Active Directory

    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.

  14. #14

    Join Date
    Sep 2005
    Location
    W. Cumbria
    Posts
    89
    Thank Post
    15
    Thanked 3 Times in 3 Posts
    Rep Power
    19

    Re: Importing new users into Active Directory

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

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

  15. #15

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,613
    Thank Post
    648
    Thanked 1,618 Times in 1,448 Posts
    Rep Power
    421

    Re: Importing new users into Active Directory

    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

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Cannot create users in Active Directory
    By WithoutMotive in forum Windows
    Replies: 17
    Last Post: 6th February 2009, 11:20 AM
  2. Active Directory-Script for Creating Bulk Users
    By calapso in forum How do you do....it?
    Replies: 8
    Last Post: 14th January 2009, 06:32 PM
  3. Replies: 2
    Last Post: 28th November 2007, 04:40 PM
  4. Importing Year 7s into Active Directory
    By networkmanager in forum Windows
    Replies: 16
    Last Post: 20th July 2007, 11:18 AM
  5. Importing data to Active Directory
    By fooby in forum Wireless Networks
    Replies: 3
    Last Post: 16th February 2006, 05:08 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •