Bulk edit individual contact lists?

841 views
Skip to first unread message

elknwelkjs

unread,
Apr 20, 2017, 1:01:42 PM4/20/17
to GAM for G Suite
We recently switched our primary domain, thus the default email for all users has changed from us...@oldfoo.com to us...@newbar.com . Unfortunately a huge percentage of our users still have us...@oldfoo.com in their personal Google Contacts list. Is there a way for me to control this via GAM? Perhaps I can edit individual entries? Perhaps I can just search for and delete all contact cards that have @oldfoo.com as the domain?

Ross Scroggs

unread,
Apr 20, 2017, 1:23:45 PM4/20/17
to google-ap...@googlegroups.com
This can't be done with standard Gam as it doesn't manage contacts.
My advanced version can do this: https://github.com/taers232c/GAMADV-X

gam redirect csv ./oldfoocontacts.csv all users print contacts emailmatchpattern ".*@oldfoo.com"
Inspect oldfoocontacts.csv to verify that results are what you expect.
gam csv oldfoocontacts.csv gam user "~User" delete contact "~ContactID"

Ross

On Thu, Apr 20, 2017 at 10:01 AM, elknwelkjs <dus...@srax.com> wrote:
We recently switched our primary domain, thus the default email for all users has changed from us...@oldfoo.com to us...@newbar.com . Unfortunately a huge percentage of our users still have us...@oldfoo.com in their personal Google Contacts list. Is there a way for me to control this via GAM? Perhaps I can edit individual entries? Perhaps I can just search for and delete all contact cards that have @oldfoo.com as the domain?

--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.
To post to this group, send email to google-apps-manager@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/17cf1b46-bb2f-41a6-ba59-b5deb1f099f2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--

elknwelkjs

unread,
Apr 20, 2017, 7:31:50 PM4/20/17
to GAM for G Suite
Awesome! I'll check it out. I'm a bit confused by your installation instructions, specifically because I've already got GAM installed and configured. Can I just download GAMADV-X and use the same API credentials? That would be my preference.

Ross Scroggs

unread,
Apr 20, 2017, 8:01:51 PM4/20/17
to google-ap...@googlegroups.com
You want to follow the directions in this section: Installation - Upgrading from a GAM version other than a prior version of GAMADV-X

You will keep you current client_secrets.json and oauth2service.json, you will create a new oauth2.txt.
These three files are kept in a separate location from your current version of Gam so both can be run independently.
You will authorize additional API scopes to be able to manage user and domain contacts.

Contact me directly at ross.s...@gmail.com if you need additional help,

Ross

On Thu, Apr 20, 2017 at 4:31 PM, elknwelkjs <dus...@srax.com> wrote:
Awesome! I'll check it out. I'm a bit confused by your installation instructions, specifically because I've already got GAM installed and configured. Can I just download GAMADV-X and use the same API credentials? That would be my preference.

--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.
To post to this group, send email to google-apps-manager@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.

For more options, visit https://groups.google.com/d/optout.



--

elknwelkjs

unread,
Apr 24, 2017, 7:17:43 PM4/24/17
to GAM for G Suite
Seems to be working - install was a tiny bit confusing but ended up working on the first try just after careful RTFM!

Thanks!

Ryan Afdahl

unread,
Apr 25, 2018, 9:48:54 PM4/25/18
to GAM for G Suite
Hi Ross 

GAMADV-X is great. I'm trying to update ContactID's email address.

After I get the ContactID's that match the pattern. I'm not sure how run a batch and update the ContactID's email.

I'm getting about this far with it:

gam csv admin-Contacts.csv gam user ad...@domain.com update contact "~ContactID" work ry...@correctdomain.com

But I'm not getting the syntax correct. Any direction would be terrific!


On Thursday, April 20, 2017 at 10:23:45 AM UTC-7, Ross Scroggs wrote:
This can't be done with standard Gam as it doesn't manage contacts.
My advanced version can do this: https://github.com/taers232c/GAMADV-X

gam redirect csv ./oldfoocontacts.csv all users print contacts emailmatchpattern ".*@oldfoo.com"
Inspect oldfoocontacts.csv to verify that results are what you expect.
gam csv oldfoocontacts.csv gam user "~User" delete contact "~ContactID"

Ross
On Thu, Apr 20, 2017 at 10:01 AM, elknwelkjs <dus...@srax.com> wrote:
We recently switched our primary domain, thus the default email for all users has changed from us...@oldfoo.com to us...@newbar.com . Unfortunately a huge percentage of our users still have us...@oldfoo.com in their personal Google Contacts list. Is there a way for me to control this via GAM? Perhaps I can edit individual entries? Perhaps I can just search for and delete all contact cards that have @oldfoo.com as the domain?

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



--

Ross Scroggs

unread,
Apr 26, 2018, 12:46:26 AM4/26/18
to google-ap...@googlegroups.com
Ryan,

Here are all of the contact attributes:
<ContactAttributes> ::=
        (additionalname|middlename <String>)|
(address clear|(work|home|other|<String> ((formatted|unstructured <String>)|(streetaddress <String>)|(pobox <String>)|
            (neighborhood <String>)|(locality <String>)|(region <String>)|(postalcode <String>)|(country <String>))* notprimary|primary))|
(billinginfo <String>)|
        (birthday <Date>)|
(calendar clear|(work|home|free-busy|<String> <URL> notprimary|primary))|
        (contactgroup clear|<ContactGroupItem>)|
        (directoryserver <String>)|
(email clear|(work|home|other|<String> <EmailAddress> notprimary|primary))|
        (event clear|(anniversary|other|<String> <Date>))|
        (externalid clear|(account|customer|network|organization|<String> <String>))|
(familyname|lastname <String>)|
        (gender female|male)|
        (givenname|firstname <String>)|
        (hobby clear|(<String>))|
(im clear|(work|home|other|<String> aim|gtalk|icq|jabber|msn|net_meeting|qq|skype|yahoo <String> notprimary|primary))|
        (initials <String>)|
(jot clear|(work|home|other|keywords|user> <String>))|
        (language <Language>)|
(location <String>)|
        (maidenname <String>)|
(mileage <String>)|
        (name <String>)|
(nickname <String>)|
        (note <String>|(file <FileName> [charset <Charset>]))|
(occupation <String>)|
        (organization clear|(work|other|<String> <String>|(location <String>)|(department <String>)|(title <String>)|(jobdescription <String>)|(symbol <String>) notprimary|primary))|
        (phone clear|(work|home|other|fax|work_fax|home_fax|other_fax|main|company_main|assistant|mobile|work_mobile|pager|work_pager|car|radio|callback|isdn|telex|tty_tdd|<String> <String> notprimary|primary))|
(prefix <String>)|
        (relation clear|(spouse|child|mother|father|parent|brother|sister|friend|relative|domestic_partner|manager|assistant|referred_by|partner|<String> <String>))|
        (shortname <String>)|
        (subject <String>)|
(suffix <String>)|
        (userdefinedfield clear|(<String> <String>))|
(website clear|(home_page|blog|profile|work|home|other|ftp|reservations|app_install_page|<String> <URL> notprimary|primary))

Here's what you want.
gam csv admin-Contacts.csv gam user ad...@domain.com update contact "~ContactID" email work ry...@correctdomain.com primary

Ross

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 https://groups.google.com/group/google-apps-manager.

Ryan Afdahl

unread,
Apr 26, 2018, 12:49:12 AM4/26/18
to google-ap...@googlegroups.com
Thank you kindly !
Reply all
Reply to author
Forward
0 new messages