Google Apps CSV import

[googlemad]

Is there any utility that I can run as a scheduled task on Windows to look at a CSV file and upload any new users in it to our Google Apps domain?

 

The CSV file will also contain existing user accounts and it is very important that they are not modified including resetting the user passwords which is the big problem with the online admin panel tool!

 

Also ideally the users would be added to a specified group and moved to a specified organizational unit automatically...

[NotSoFast]

Isn't this what Google School Directory Sync does?

[googlemad]

Just spotted that before leaving work funnily enough, might have a play tomorrow

[NotSoFast]

Let me know how you get on. We are looking at it too.

[googlemad]

Binned the idea of the School system as our CIS system chucks out two CSV files at the moment - One for the AD and one for the Gmail. So might as well just set up the Google AD sync tool which is similar.

 

Anyway I've chucked a few settings together and happily communicating between AD and Gmail, but since we only want to do students at the moment is there a way to exclude any Google accounts not in our 'students' Google sub organization from being modified? As I did a simulation and it was looking to suspend all the staff accounts which I don't think would go down too well!!!

 

Also can it be made so when the sync takes place all the accounts in the 'students' Google sub organization are added to our Google 'allstudents' group automagically? I've been using GAM to do this previously but it would be nice to let the sync do the work!