Adding New Users to Organization for Dummies???

908 views
Skip to first unread message

Gretchen Nobles

unread,
Jan 4, 2011, 3:21:43 PM1/4/11
to google-ap...@googlegroups.com
I need to add about 350 student accounts to my domain.  I want to put them in the organization called Students 7-12.  I would like them to all have a generic password and be forced to change it at first login.  Is this possible?  If so... could you give me the command?  Also... how would I get the information into GAM?  I have an excel spreadsheet with their names in it.  Should I save it to .txt?  Do I have to save the .txt file in the same directory as GAM?

I thought about using the bulk upload in Google Apps and then using GAM to assign Organizational unit but if I can do it all with one command that would be great!

Pretend info:

Organization:  Students 7-12
User Name file:  student_mail.txt (or .csv whatever is best)

First Name: Test
Last Name: Student1
Password: Temppassword

First Name: Test
Last name: Student2
Password: Temppassword


Sorry for so many questions!  I'm a total newb!!!

~G


Oliver Hartley

unread,
Jan 4, 2011, 5:38:57 PM1/4/11
to google-ap...@googlegroups.com
Gretchen, we all have been there.... newB i mean.....

so here is what you need to do

1. goto the gam directory
2. type: gam info domain
insert the domain credentials asked.
3. create all users with the command: gam create user firstname "John" lastname "Smith" username john.smith password Temppassword
4. create organiational units: gam create org "Students 7-12"
5. to move users to a org:
5.1 create a .txt (ie. students.txt) file with all usernames each username in a sperate line if you open the file you should see a list of usernames like:

john.smith
john.adams
albert.einstein

5.2 copy that file to the gam directory
5.3 type the command in the gam directory: gam update org "Students 7-12" addfile students.txt

6. Pray :-)

Oliver Hartley Lyon | CTO | Tel: +562-640-3900 | Cel: +569-9162-7029








--
You received this message because you are subscribed to the "Google Apps Manager" group.
To post to this group, send email to
google-ap...@googlegroups.com
To unsubscribe from this group, send email to
google-apps-man...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/google-apps-manager

Gretchen Nobles

unread,
Jan 5, 2011, 8:38:32 AM1/5/11
to google-ap...@googlegroups.com
Thanks for understanding the newb side of me!!!

And I love the step by step!  I think I can handle it!  (With lots of prayer of course!)  So create the users first then move them into the Org.  Got it.

The piece of the puzzle I still think I'm missing though is how to create multiple users?  I understand the command - gam create user firstname "John" lastname "Smith" username john.smith password Temppassword

But how do I multiply that by 350?  And where do I indicate that they need to change their password at the first login?

Thanks!

Oliver Hartley

unread,
Jan 5, 2011, 11:41:49 AM1/5/11
to google-ap...@googlegroups.com
ok this is what i do.

i create a spreadsheet with all the data an then in one of the cell's y do a concatenante and "create" the gam comand line with that done.... is just a copy and paste into a DOS shell... there is other ways to do it via power shell, but this way also works.... i just created a example for you :-)

With that done you can copy from f2 till the end all 350 lines and past in a DOS shell

Oliver Hartley Lyon | CTO | Tel: +562-640-3900 | Cel: +569-9162-7029







--
example.xlsx

Gretchen Nobles

unread,
Jan 5, 2011, 3:05:47 PM1/5/11
to google-ap...@googlegroups.com
Thanks!  I love the example!  Probably a stupid question but I've been messing with it and I can't figure it out!  How can I add "changepassword" to the end?


Gretchen Nobles

unread,
Jan 5, 2011, 3:09:16 PM1/5/11
to google-ap...@googlegroups.com
Actually I guess it should be "changepassword on" that I need to add to the end right?

Gretchen Nobles

unread,
Jan 5, 2011, 3:42:28 PM1/5/11
to google-ap...@googlegroups.com
Okay!  I think I've got it!!!  (Attached)  Maybe it will help another newb!!!!

Now any suggestions for Hyphenated or double names?  Example: First Name: Mary Jo  Last Name: Hyphenated-name

:-)
Example Add Users.xls

Oliver Hartley

unread,
Jan 5, 2011, 3:44:46 PM1/5/11
to google-ap...@googlegroups.com

Must be betwen "", like "Mary Jo"

Enviado desde mi dispositivo Android

Gretchen Nobles

unread,
Jan 5, 2011, 3:50:46 PM1/5/11
to google-ap...@googlegroups.com
Hmmm... the Firstname was between ""

Should I include "" around the username as well?


See results below:

C:\GAM>gam create user mhyphen-name Firstname "Mary Jo" Lastname "hyphen-name" p
assword temppassword changepassword on

Usage: gam [OPTIONS]...

Google Apps Manager. Retrieve or set Google Apps domain,
user, group and nickname settings. Exhaustive list of commands

Examples:
gam info domain
gam create user jsmith firstname John lastname Smith password secretpass
gam update user jsmith suspended on
gam.exe update group announcements add member jsmith
...

Sandip Shah

unread,
Jan 5, 2011, 4:23:31 PM1/5/11
to Google Apps Manager
Hi Gretchen,

If you are going to put double quotes around username, be careful -
there cannot be a space in username.

Sandip

Gretchen Nobles

unread,
Jan 5, 2011, 4:45:43 PM1/5/11
to google-ap...@googlegroups.com
Thanks.  I couldn't get hyphen user names to work with our without the "" It's okay - I don't have that many - I can just do those by hand.

Gretchen Nobles

unread,
Jan 5, 2011, 5:07:01 PM1/5/11
to google-ap...@googlegroups.com
Update:  

The command:
changepassword on    
Only works with gam update.  

For gam create user use:
changepassword   

Updated Example spreadsheet is attached.

Thanks so much for the help you guys!!!
Example Add Users.xls

Oliver Hartley

unread,
Jan 5, 2011, 6:14:52 PM1/5/11
to google-ap...@googlegroups.com
team work ;)

Oliver Hartley Lyon | CTO | Tel: +562-640-3900 | Cel: +569-9162-7029







--
Reply all
Reply to author
Forward
0 new messages