organization info overwriting undefined fields

53 views
Skip to first unread message

Daniel Warren

unread,
Jan 26, 2018, 10:23:30 AM1/26/18
to GAM for G Suite
I've been trying to update a few fields with my users and I initially was trying to break it up into two separate commands.  However it appears that breaking up the organization sub commands overwrites undefined organization fields. 

e.g.:

gam csv ~/Downloads/Update\ Student\ Location.csv gam update user ~"Email Address" organization title ~"Employee Title" type "Student" costcenter ~"Cost Center" department ~"Department" primary

This will Remove what I have in the Employee Type field.  If I change my command to:

gam csv Users.csv gam update user ~"Email Address" organization title ~"Employee Title" customtype ~"Employee Type" costcenter ~"Cost Center" department ~"Department" primary

I get no error and it claims that it updates the users however none of them have the Employee Type field filled in.

What might I be missing here?

Thanks

Daniel Warren

unread,
Jan 26, 2018, 1:05:40 PM1/26/18
to GAM for G Suite
To clarify:  I am looking for the command context in order to update the "Employee Title" (in admin console) to a custom field i.e. not one of the predefined fields in gam.  How do I do this without wiping out other Organization information.  Thanks.

Ross Scroggs

unread,
Jan 26, 2018, 2:19:04 PM1/26/18
to google-ap...@googlegroups.com
Daniel,

There is no incremental updating of these kinds of fields; you have to update all of the subfields in the same command.
You have to get the current subfield values, add your values and do one update.

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/c8afc204-fe2e-4934-91cd-3e25eadff8d9%40googlegroups.com.

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



--

Warren, Daniel

unread,
Jan 26, 2018, 2:25:37 PM1/26/18
to google-ap...@googlegroups.com
I've come to that conclusion myself.  However I cannot seem to get the context correct for updating employee type along with the other fields within organization.  I have tried the following:

gam csv Users.csv gam update user ~"Email Address" organization title ~"Employee Title" costcenter ~"Cost Center" customType ~"Employee Type" department ~"Department" primary

The csv is just a modified export from the Google Admin Console so all the header row titles come from Google.  To be clear I am trying to fill in the four fields listed below Employee Details in the screenshot below.



Daniel W Warren
Application Distribution Specialist
Natick Public Schools
(508)-647-6400 x1728

On Fri, Jan 26, 2018 at 2:18 PM, Ross Scroggs <ross.s...@gmail.com> wrote:
Daniel,

There is no incremental updating of these kinds of fields; you have to update all of the subfields in the same command.
You have to get the current subfield values, add your values and do one update.

Ross
On Fri, Jan 26, 2018 at 10:05 AM, Daniel Warren <dwa...@natickps.org> wrote:
To clarify:  I am looking for the command context in order to update the "Employee Title" (in admin console) to a custom field i.e. not one of the predefined fields in gam.  How do I do this without wiping out other Organization information.  Thanks.

On Friday, January 26, 2018 at 10:23:30 AM UTC-5, Daniel Warren wrote:
I've been trying to update a few fields with my users and I initially was trying to break it up into two separate commands.  However it appears that breaking up the organization sub commands overwrites undefined organization fields. 

e.g.:

gam csv ~/Downloads/Update\ Student\ Location.csv gam update user ~"Email Address" organization title ~"Employee Title" type "Student" costcenter ~"Cost Center" department ~"Department" primary

This will Remove what I have in the Employee Type field.  If I change my command to:

gam csv Users.csv gam update user ~"Email Address" organization title ~"Employee Title" customtype ~"Employee Type" costcenter ~"Cost Center" department ~"Department" primary

I get no error and it claims that it updates the users however none of them have the Employee Type field filled in.

What might I be missing here?

Thanks

--
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+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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/c8afc204-fe2e-4934-91cd-3e25eadff8d9%40googlegroups.com.

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



--

--
You received this message because you are subscribed to a topic in the Google Groups "GAM for G Suite" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-manager/ScauwPIPJ98/unsubscribe.
To unsubscribe from this group and all its topics, 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/CAJkvRS-5P67GjyF1Vr1kJTLS882VCkRNCW81uDfDM8WZ%2B_tstw%40mail.gmail.com.

Ross Scroggs

unread,
Jan 26, 2018, 2:42:02 PM1/26/18
to google-ap...@googlegroups.com
Daniel,

The Admin GUI field "Employee Type" is named "description" in the Google API that Gam uses; try this:
gam csv Users.csv gam update user ~"Email Address" organization title ~"Employee Title" costcenter ~"Cost Center" description ~"Employee Type" department ~"Department" primary

Ross

To unsubscribe from this group and all its topics, 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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAJkvRS-5P67GjyF1Vr1kJTLS882VCkRNCW81uDfDM8WZ%2B_tstw%40mail.gmail.com.

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

--
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/CAOZaOiCyw5KSNMv5J1T6KJU2QzYXxFeXicVB_h7J5eqx%2BVaS5Q%40mail.gmail.com.

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



--

Daniel Warren

unread,
Jan 26, 2018, 2:49:27 PM1/26/18
to GAM for G Suite
Thank you Ross,
I feel like I have run into that before, my apologies if I missed this in a previous post.


On Friday, January 26, 2018 at 2:42:02 PM UTC-5, Ross Scroggs wrote:
Daniel,

The Admin GUI field "Employee Type" is named "description" in the Google API that Gam uses; try this:
gam csv Users.csv gam update user ~"Email Address" organization title ~"Employee Title" costcenter ~"Cost Center" description ~"Employee Type" department ~"Department" primary

Ross
On Fri, Jan 26, 2018 at 11:25 AM, Warren, Daniel <dwa...@natickps.org> wrote:
I've come to that conclusion myself.  However I cannot seem to get the context correct for updating employee type along with the other fields within organization.  I have tried the following:

gam csv Users.csv gam update user ~"Email Address" organization title ~"Employee Title" costcenter ~"Cost Center" customType ~"Employee Type" department ~"Department" primary

The csv is just a modified export from the Google Admin Console so all the header row titles come from Google.  To be clear I am trying to fill in the four fields listed below Employee Details in the screenshot below.


On Fri, Jan 26, 2018 at 2:18 PM, Ross Scroggs <ross.s...@gmail.com> wrote:
Daniel,

There is no incremental updating of these kinds of fields; you have to update all of the subfields in the same command.
You have to get the current subfield values, add your values and do one update.

Ross
On Fri, Jan 26, 2018 at 10:05 AM, Daniel Warren <dwa...@natickps.org> wrote:
To clarify:  I am looking for the command context in order to update the "Employee Title" (in admin console) to a custom field i.e. not one of the predefined fields in gam.  How do I do this without wiping out other Organization information.  Thanks.

On Friday, January 26, 2018 at 10:23:30 AM UTC-5, Daniel Warren wrote:
I've been trying to update a few fields with my users and I initially was trying to break it up into two separate commands.  However it appears that breaking up the organization sub commands overwrites undefined organization fields. 

e.g.:

gam csv ~/Downloads/Update\ Student\ Location.csv gam update user ~"Email Address" organization title ~"Employee Title" type "Student" costcenter ~"Cost Center" department ~"Department" primary

This will Remove what I have in the Employee Type field.  If I change my command to:

gam csv Users.csv gam update user ~"Email Address" organization title ~"Employee Title" customtype ~"Employee Type" costcenter ~"Cost Center" department ~"Department" primary

I get no error and it claims that it updates the users however none of them have the Employee Type field filled in.

What might I be missing here?

Thanks

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



--

--
You received this message because you are subscribed to a topic in the Google Groups "GAM for G Suite" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-manager/ScauwPIPJ98/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-manager+unsub...@googlegroups.com.
To post to this group, send email to google-ap...@googlegroups.com.

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



--
Reply all
Reply to author
Forward
0 new messages