GAM ADV-X Add/Update User Information

462 views
Skip to first unread message

Eric Dannewitz

unread,
Sep 28, 2017, 5:01:34 PM9/28/17
to google-ap...@googlegroups.com
I want to update my users with more current contact info and what not. This is sort of a triage until we get the Google Directory syncing with our Active Directory (currently only have password sync enabled)

Basically, I have a csv file that contains

email address, title, phone, office, department, company

and I want these to update my google users as such

csv      google
title -> title
phone -> phone
company -> department (google standard field)
office -> campus (custom category)
department -> department (custom category)

How would one do this?


---
Eric Dannewitz 
Technology Assistant
Acalanes Union High School District
District Office Technology Department

Ross Scroggs

unread,
Sep 28, 2017, 5:27:12 PM9/28/17
to google-ap...@googlegroups.com
Eric,

<UserAttributes> ::=

        (organization|organizations clear|([type domain_only|school|unknown|work] [customtype <String>] [name <String>] [title <String>] [department <String>] [symbol <String>]

                [costcenter <String>]  [location <String>] [description <String>] [domain <String>] notprimary|primary))|

(phone|phones clear|([type work|home|other|work_fax|home_fax|other_fax|main|company_main|assistant|mobile|work_mobile|pager|work_pager|car|radio|callback|isdn|telex|tty_tdd|grand_central|(custom <String>)]

                [value <String>] notprimary|primary))|

 

What do you mean by custom category; do you have a user defined schema?


Ross


--
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/4525D525-ADBD-4497-9B4B-1DAA9B058AE4%40auhsdschools.org.
For more options, visit https://groups.google.com/d/optout.



--

Eric Dannewitz

unread,
Sep 28, 2017, 5:47:23 PM9/28/17
to google-ap...@googlegroups.com
If you go into the admin page, and users, and click “Manage user attributes” you can create custom fields in there. Is that accessible or addressable via GAM?


---
Eric Dannewitz 
Technology Assistant
Acalanes Union High School District
District Office Technology Department

Ross Scroggs

unread,
Sep 28, 2017, 6:07:09 PM9/28/17
to google-ap...@googlegroups.com
Eric,

Yes, those are custom user schemas.

# Schemas


<SchemaFieldDefinition> ::=

        field <FieldName> (type bool|date|double|email|int64|phone|string) [multivalued|multivalue] [indexed] [restricted] [range <Number> <Number>] endfield


gam create schema|schemas <SchemaName> <SchemaFieldDefinition>+

gam update schema <SchemaName> <SchemaFieldDefinition>* (deletefield <FieldName>)*

gam delete schema <SchemaName>

gam info schema <SchemaName>


gam update schemas <SchemaEntity> <SchemaFieldDefinition>* (deletefield <FieldName>)*

gam delete schemas <SchemaEntity>

gam info schemas <SchemaEntity>


gam show schema|schemas

gam print schema|schemas [todrive [<ToDriveAttributes>]]



<UserAttributes> ::=

        (<SchemaName>.<FieldName> [multivalued|multivalue|value|multinonempty [type work|home|other|(custom <String>)]] <String>)


Ross

--
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/4CEAFA03-B6D2-4152-B5E1-0C1F1B883269%40auhsdschools.org.

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



--

Ross Scroggs

unread,
Sep 28, 2017, 6:10:53 PM9/28/17
to google-ap...@googlegroups.com
Eric,

Do: gam show schemas
Post your two custom categories and I can give you the full command.

Ross

To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsubscribe...@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.



--



--

Eric Dannewitz

unread,
Sep 28, 2017, 6:12:09 PM9/28/17
to google-ap...@googlegroups.com
root@dvecgam01:/usr/local/gamadv-x# gam show schemas
Show 1 Schema
  Schema: Campus
    schemaId: MdI2KxqWT4mU61QMghQ2zg==
    Field: Campus
      fieldType: STRING
      readAccessType: ALL_DOMAIN_USERS
      fieldId: Jwb0l7TSTFuQOg2rbTbsjA==
      multiValued: False
    Field: Department
      fieldType: STRING
      readAccessType: ALL_DOMAIN_USERS
      fieldId: cG36Jy-_SMCHuYNo7snmOA==
      multiValued: False
root@dvecgam01:/usr/local/gamadv-x# 


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.

Ross Scroggs

unread,
Sep 28, 2017, 6:33:51 PM9/28/17
to google-ap...@googlegroups.com
Eric,

gam csv Users.csv gam update user "~email address" phone value ~phone primary organization title ~title department ~company primary Campus.Campus ~office Campus.Department ~department

Ross

On Thu, Sep 28, 2017 at 3:12 PM, Eric Dannewitz <edann...@auhsdschools.org> wrote:
root@dvecgam01:/usr/local/gamadv-x# gam show schemas
Show 1 Schema
  Schema: Campus
    schemaId: MdI2KxqWT4mU61QMghQ2zg==
    Field: Campus
      fieldType: STRING
      readAccessType: ALL_DOMAIN_USERS
      fieldId: Jwb0l7TSTFuQOg2rbTbsjA==
      multiValued: False
    Field: Department
      fieldType: STRING
      readAccessType: ALL_DOMAIN_USERS
      fieldId: cG36Jy-_SMCHuYNo7snmOA==
      multiValued: False
root@dvecgam01:/usr/local/gamadv-x# 

On Sep 28, 2017, at 3:10 PM, Ross Scroggs <ross.s...@gmail.com> wrote:

Eric,

Do: gam show schemas
Post your two custom categories and I can give you the full command.

Ross
On Thu, Sep 28, 2017 at 3:07 PM, Ross Scroggs <ross.scroggs@gmail.com> wrote:
Eric,

Yes, those are custom user schemas.
# Schemas

<SchemaFieldDefinition> ::=
        field <FieldName> (type bool|date|double|email|int64|phone|string) [multivalued|multivalue] [indexed] [restricted] [range <Number> <Number>] endfield

gam create schema|schemas <SchemaName> <SchemaFieldDefinition>+
gam update schema <SchemaName> <SchemaFieldDefinition>* (deletefield <FieldName>)*
gam delete schema <SchemaName>
gam info schema <SchemaName>

gam update schemas <SchemaEntity> <SchemaFieldDefinition>* (deletefield <FieldName>)*
gam delete schemas <SchemaEntity>
gam info schemas <SchemaEntity>

gam show schema|schemas
gam print schema|schemas [todrive [<ToDriveAttributes>]]


<UserAttributes> ::=
        (<SchemaName>.<FieldName> [multivalued|multivalue|value|multinonempty [type work|home|other|(custom <String>)]] <String>)

Ross
On Thu, Sep 28, 2017 at 2:47 PM, Eric Dannewitz <edannewitz@auhsdschools.org> wrote:
If you go into the admin page, and users, and click “Manage user attributes” you can create custom fields in there. Is that accessible or addressable via GAM?


---
Eric Dannewitz 
Technology Assistant
Acalanes Union High School District
District Office Technology Department

On Sep 28, 2017, at 2:27 PM, Ross Scroggs <ross.s...@gmail.com> wrote:

Eric,

<UserAttributes> ::=
        (organization|organizations clear|([type domain_only|school|unknown|work] [customtype <String>] [name <String>] [title <String>] [department <String>] [symbol <String>]
                [costcenter <String>]  [location <String>] [description <String>] [domain <String>] notprimary|primary))|
(phone|phones clear|([type work|home|other|work_fax|home_fax|other_fax|main|company_main|assistant|mobile|work_mobile|pager|work_pager|car|radio|callback|isdn|telex|tty_tdd|grand_central|(custom <String>)]
                [value <String>] notprimary|primary))|
 
What do you mean by custom category; do you have a user defined schema?

Ross


-- 
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.



-- 



-- 

-- 
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.

--
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/36CEFF0D-E86C-4508-9B87-3B1D041C8351%40auhsdschools.org.

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



--

Eric Dannewitz

unread,
Oct 2, 2017, 3:48:22 PM10/2/17
to google-ap...@googlegroups.com
This sort of worked except it left out the phone number

> On Sep 28, 2017, at 3:33 PM, Ross Scroggs <ross.s...@gmail.com> wrote:
>
> Eric,
>
Reply all
Reply to author
Forward
0 new messages