how to bulk rename user name and email account

2,440 views
Skip to first unread message

Adrian Yong

unread,
Oct 28, 2015, 3:52:53 AM10/28/15
to Google Apps Manager
Hi, I am very new to GAM.

How do I rename both the user name and email address ?

When we moved to Google Unlimited from Google + Postini, they converted the old accounts from Postini to vFE.xxxx.first...@domain.com.

The xxxx is running number added to the email account.

How Do I change such that :
1. User firstname adds a vfe (adrian becomes vfe.adrian)
2. rename the email account vFE.xxxx.first...@domain.com to vFE.firstna...@domain.com (dropping the running number)

Thanks

Glen Pringle

unread,
Oct 29, 2015, 12:59:06 AM10/29/15
to google-ap...@googlegroups.com
Hi Adrian,

You need to make use of the bulk and update/rename features of GAM. Create a csv file with the old email address, new email address, and new name (with "vfe." prepended) and then you can do the update. For example, if you have the csv file bulkrename.csv with the following:

OldEmail,NewEmail,Firstname

a command such as "gam csv bulkrename.csv gam update user ~OldEmail firstname ~Firstname email ~NewEmail" should work. Note that I have not tested this - you should test it before you run it on production accounts!!!!* 

One other comment is that a single user in Postini can have multiple vfe accounts created as part of the Postini to Vault transition. Your approach will fail if this is your situation.

* I accept no responsibility if it doesn't work - you need to confirm with testing that it does what you want.

Glen

--
You received this message because you are subscribed to the Google Groups "Google Apps Manager" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To post to this group, send email to google-ap...@googlegroups.com.
Visit this group at http://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/9ebab2ba-f8d7-43d5-a606-569015d32f0f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Adrian Yong

unread,
Oct 29, 2015, 2:50:59 AM10/29/15
to Google Apps Manager
Thanks....I just tried for 1 hr and failed to get GAM to be authorized....

Anyway thanks...I think I'll do it manually.


On Thursday, October 29, 2015 at 12:59:06 PM UTC+8, Glen Pringle wrote:
Hi Adrian,

You need to make use of the bulk and update/rename features of GAM. Create a csv file with the old email address, new email address, and new name (with "vfe." prepended) and then you can do the update. For example, if you have the csv file bulkrename.csv with the following:

OldEmail,NewEmail,Firstname

a command such as "gam csv bulkrename.csv gam update user ~OldEmail firstname ~Firstname email ~NewEmail" should work. Note that I have not tested this - you should test it before you run it on production accounts!!!!* 

One other comment is that a single user in Postini can have multiple vfe accounts created as part of the Postini to Vault transition. Your approach will fail if this is your situation.

* I accept no responsibility if it doesn't work - you need to confirm with testing that it does what you want.

Glen

On 28 October 2015 at 18:52, Adrian Yong <adria...@tangs.com> wrote:
Hi, I am very new to GAM.

How do I rename both the user name and email address ?

When we moved to Google Unlimited from Google + Postini, they converted the old accounts from Postini to vFE.xxxx.first...@domain.com.

The xxxx is running number added to the email account.

How Do I change such that :
1. User firstname adds a vfe (adrian becomes vfe.adrian)
2. rename the email account vFE.xxxx.first...@domain.com to vFE.firstna...@domain.com (dropping the running number)

Thanks

--
You received this message because you are subscribed to the Google Groups "Google Apps Manager" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.

Amar Thombare

unread,
Jan 28, 2017, 2:59:05 AM1/28/17
to GAM for G Suite
I tried with below command and it`s working fine. we need to re-enable the affected API.

CSV file created in below format.
OldEmail,NewEmail,Firstname

same Command used as mentioned above.

gam csv bulkrename.csv gam update user ~OldEmail firstname ~Firstname email ~NewEmail


-Amar
Reply all
Reply to author
Forward
0 new messages