+ Post New Thread
Results 1 to 8 of 8
Windows Server 2008 R2 Thread, Import Users via Excel in Technical; A few years ago I had a vbs script that would pull users from an Excel sheet and put them ...
  1. #1
    jmair's Avatar
    Join Date
    Aug 2007
    Posts
    274
    Thank Post
    58
    Thanked 9 Times in 9 Posts
    Rep Power
    16

    Import Users via Excel

    A few years ago I had a vbs script that would pull users from an Excel sheet and put them in my Windows 2003 Active Directory. I've tried searching for something like this again, but haven't found anything and to be honest, I'm not sure if it would work in 2008 R2 anyhow. Would any of you have one to share by chance?

  2. #2

    Join Date
    Nov 2007
    Location
    Rotherham
    Posts
    1,675
    Thank Post
    122
    Thanked 126 Times in 102 Posts
    Rep Power
    45
    DSADD is whe windows scripting command and works fine. I've got it set up in an excel spreadsheet but it's designed for the specific export from SIMS. i.e. run a report copy the results into my spreadsheet, copy the cell's containg my formula's into a .bat file and run.

  3. #3
    bio
    bio is offline
    bio's Avatar
    Join Date
    Apr 2008
    Location
    netherlands
    Posts
    520
    Thank Post
    16
    Thanked 130 Times in 102 Posts
    Rep Power
    37
    If you can be more specific.. like which ou, what user properties, mail account ? etc... i can adjust my script and post it here.

    bio..

  4. #4
    rh91uk's Avatar
    Join Date
    Sep 2008
    Location
    UK
    Posts
    876
    Thank Post
    137
    Thanked 132 Times in 114 Posts
    Rep Power
    35
    @bio - i'd be very interested in the script please too? cheers!

    Meanwhile, I use this..... http://www.wisesoft.co.uk/software/a...t/default.aspx and it's very effective.

  5. #5

    Join Date
    Jul 2009
    Posts
    48
    Thank Post
    3
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    i cannot get this reg the dll in server 2008, any way? thanks

  6. #6

    Join Date
    Jul 2009
    Posts
    48
    Thank Post
    3
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    BUMP

    i have a excel page like:
    first line: givenName displayName sAMAccountName description streetAddress mail password st homeDirectory homeDrive

    second line
    abc abc xpto abcdef teacher 21 street abcderf@domain.com 12344 Porto \\server\teacher\%username%\ H:

    etc

    where is easy way to import this into active directory?

    thanks

    flavio rodrigues

  7. #7
    jsnetman's Avatar
    Join Date
    Oct 2007
    Posts
    887
    Thank Post
    23
    Thanked 134 Times in 126 Posts
    Rep Power
    39
    This page describes the various methods and sytax to use:

    Create Users for Testing Purposes

  8. #8


    Join Date
    Mar 2009
    Location
    Leeds
    Posts
    6,578
    Thank Post
    228
    Thanked 853 Times in 732 Posts
    Rep Power
    294
    the spreadsheet i use has this as the output (i diddnt write it i have heavily edited it but its based on someone elses work so i dont feel i can publish)

    dsadd user cn=8hpotte,ou=2008,ou="pupils",dc=school,dc=local -upn 8hpotte@school.local -display "Harry potter" -pwd pass -hmdir \\server\8hpotte$ -hmdrv u: -profile \\server\profiles$\man\pupil.man -memberof cn=2008,ou=2008,ou="pupils",dc=school,dc=local -fn Harry -ln Potter -desc 2008 -loscr pupil.bat -mustchpwd no -canchpwd no

    as input i just dump first name, lastname and year of entry (2008 in this case) into it and it works the rest out (server name/domzin name/profile path etc) are all on a page that i change depending on the school but are just plain text fields

SHARE:
+ Post New Thread

Similar Threads

  1. EXCEL - Recording survey details in excel - Easiest way
    By reecec in forum Office Software
    Replies: 2
    Last Post: 28th April 2010, 08:16 PM
  2. Replies: 1
    Last Post: 22nd December 2009, 05:05 PM
  3. MOSS2007 - SProfile and Import Settings - import profiles has hung
    By damienharrison in forum Web Development
    Replies: 5
    Last Post: 3rd February 2009, 11:40 AM
  4. Import Users Into RM Maths From Serco Facility CMIS
    By DreddMetal in forum Educational Software
    Replies: 0
    Last Post: 26th November 2008, 02:37 PM
  5. Import-Mailbox
    By faza in forum How do you do....it?
    Replies: 2
    Last Post: 18th August 2008, 09:35 AM

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
  •