We help IT Professionals succeed at work.

Create users from excel (Continuation)

418 Views
Last Modified: 2010-04-16
Hi,

The continuation of this Q...
https://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_22846683.html

1. Need to auto select the "Account tab" User logon name next to it the domain name "Development" has to be selected.
2. Password never expires has to be selected.
3. In Telephones tab the Home,Mobile has to be available in csv
4. Notes colum
5. Title
6. Manager
7. Groups adding local as well as Root domain groups from the csv.
8. Description in the first row.

What is the Alias there for....?
Can these details be integreted in the script as these will very rarely change.
CompanyName,Exchange Server,First Storage Group,Mailbox Store
Regards
Sharath
Comment
Watch Question

Author

Commented:
Email adress is automatically taken from First name and Last name. So can we remove the option from vbs as well csv

Author

Commented:
In ADS the Mailbox rights for the created user is just "SELF" is it correct.
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
Sharath, for point number 1, with the code in
https://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Q_22804838.html

if you don't worry about groups just yet...and it creates a user, does that domain get selected from that box on the Accounts tab?

Regards,

Rob.

Author

Commented:
No the domain name does not get selected....
Yes it is correct and when the user login everything will populate and now only it will be "SELF"

Author

Commented:
Ok Chandru...
Can you try a user logging in and see if it populates all the ACL (access control list)?

Author

Commented:
No the rights did not populate after logging in aswell.

Rob & Chandru any progress with this....
I am expecting another bunch of user creation.If this is done by then it would be of great help...
Your requirement for 1 - 6 can be done easily. I will work on this and will post the code late today as i will be out.

Author

Commented:
Ok Chandru...
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Thanks Rob! I will combine this and will test the code.

Author

Commented:
Awaiting the final code :)

Author

Commented:
Chandru did you have the chance to check the script...
No Sharath! Sorry about that. I am afraid I will be able to work only this weekend on this script.

Author

Commented:
Chandru did you have the time to check....
Sharath,

I am not in chennai and working from Bangalore as a case of emergency. I will be filying back today night. I will give it a go tomorrow

:)
Are you still waiting for the script to create 300 users or you have already finished them?

Author

Commented:
I have started them but not completed....Need to finish them this week...
Until then everyone will login in a common user id...

Still need it very badly...

Author

Commented:
Any Luck on this today....
Sorry Sharath, I didn't have to time to test this and work on this.

Rob and me are looking on a way to add the users to the Root groups.

I will look into other post above and see where i can be of help

I think you are mainitaining a separate database for the EE questions. :-)

regards
Chandru

Author

Commented:
Yes chandru so many excllent solutions and it becomes difficult to remember.So just creating a seperate database.of all the solutions that i got from you experts and storing them for future reference...
Yes that's true.....

Are you maintianing it in excel or access database?

Cheers
Chandru

Author

Commented:
I am creating a new local machine website for this...Which can be shared with my team also.As they dont have access to EE.
Sorry i didn't have time to check

Will work whenever i get time and will post my comments

Author

Commented:
Chandru & Rob i shall close this Question here today...
Chandru please let me know when your free and you are done with the testing...

Planned to close all my posts today and have "0" questions open this year :-)

Hope Rob shall help me doing so....
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.