Update building id in employee information

472 views
Skip to first unread message

Dharmateja Tummala

unread,
May 13, 2021, 3:52:25 AM5/13/21
to GAM for Google Workspace
Hello

Am using GAMADV-XTD3 to create Users.

Am able to update Employee id using below command,
gam update user us...@test.com externalid organization 123456

Is there any way to update Building ID inside Employee information.


Thanks
Dharma Teja

Ross Scroggs

unread,
May 13, 2021, 10:36:54 AM5/13/21
to google-ap...@googlegroups.com

--
You received this message because you are subscribed to the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/640d9617-1165-4b61-aa78-cf5b676b4257n%40googlegroups.com.


--

Dharmateja Tummala

unread,
May 14, 2021, 12:16:28 PM5/14/21
to GAM for Google Workspace
Thanks Ross

Using below command was able to update the field building id with value 'building1'

gam create user userid1 firstname firstname1 lastname lastname1 password password1 orgUnitPath orgUnitPath1  location type desk area desk buildingid id:buildingid1 endlocation

Without adding 'id:' unable execute the command. So added 'id:' before buildingid field value. Got this from documentation of GAM.

But while doing the same gam operation in bulk from csv which contains the columns (userid, firstname, lastname, password, org, buildingid) the value for building id is not picked from csv column 'buildingid' instead building value is getting updated as '~buildingid'. Below is the command used for bulk operation.

gam csv 'path to csv' gam create user ~userid firstname ~firstname lastname ~lastname password ~password orgUnitPath ~org location type desk area desk buildingid id:~buildingid endlocation

could you please suggest me the way to use buildingid field value from csv.

Ross Scroggs

unread,
May 14, 2021, 12:25:09 PM5/14/21
to google-ap...@googlegroups.com
Dharma,

When specifying fields from a CSV file, use "~field" when the field is the entire argument; use "~~field~~" when the field is embedded in an argument.
you want: .... buildingid "id:~~buildingid~~" ...

Ross

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/b23050f2-b10c-405a-b6f2-b2f48d0c5aebn%40googlegroups.com.


--

Dharmateja Tummala

unread,
May 14, 2021, 12:36:16 PM5/14/21
to google-ap...@googlegroups.com
Thanks Ross it worked.
.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAJkvRS8apQ7E8TK3z%3DWpKj6cUa4uGbURGw%2B_z%2BmNFRcB4GN3qg%40mail.gmail.com.
Message has been deleted

Arts

unread,
Nov 29, 2023, 6:09:48 AM11/29/23
to GAM for Google Workspace
GAMADV-XTD3 6.29.12 - https://github.com/taers232c/GAMADV-XTD3 - pyinstaller
Python 3.11.0 64-bit final
MacOS 14.1.1 arm64

Hi,

When I run this command 
gam csv 'linktosheet' gam update user ~primaryEmail locations type desk area desk buildingid “~~buildingid~~” endlocation

I get this error

Command: gam update user emailaddress locations type desk area desk buildingid >>>“SS”<<< endlocation

ERROR: Building: “SS”, Does not exist

I don't know why?

Arts

Ross Scroggs

unread,
Nov 29, 2023, 9:28:33 AM11/29/23
to google-ap...@googlegroups.com
What does this show: gam info building SS

The current version is 6.65.17, you might want to update.

Ross
----
Ross Scroggs



Message has been deleted

Arts

unread,
Nov 30, 2023, 4:25:53 AM11/30/23
to GAM for Google Workspace
HI Ross,

It shows this:

Building: SS
buildingId: id:SS
description: Secondary School
FloorNames: 1,2
coordinates:
latitude: 22.3237389
longitude: 39.1085714


I also tried gam csv 'linktosheet' gam update user ~primaryEmail location type desk area desk buildingid “id:~~buildingid~~” endlocation

Command: gam update user emailaddress location type desk area desk buildingid >>>“id:SS”<<< endlocation

ERROR: Building: “id:SS”, Does not exist



Ross Scroggs

unread,
Nov 30, 2023, 10:26:01 AM11/30/23
to google-ap...@googlegroups.com
Did you update? I'm in California (PST) and am generally available starting at 7:30AM, send me a Meet/Zoom invitation and I'll help.


Ross
----
Ross Scroggs


Message has been deleted

Arts

unread,
Dec 3, 2023, 4:20:23 AM12/3/23
to GAM for Google Workspace

Arts
12:13 PM (now) 
to GAM for Google Workspace
Hi Ross,

I just ran the update. Tried same command and same error but found the problem was with the command 

gam csv 'linktosheet' gam update user ~primaryEmail location type desk area desk buildingid “id:~~buildingid~~” endlocation

it worked with this command
gam csv 'linktosheet' gam update user ~primaryEmail location type desk area desk buildingid id:“~~buildingid~~” endlocation

the id: needed to be outside of quotation marks but then the Building had "" with the name so I ran
gam csv 'linktosheet'  gam update user ~primaryEmail locations type desk area desk buildingid id:~~buildingid~~ endlocation which worked


Thanks for your help.

2023-12-03T08:03:02.015+03:00,0/5,Processing complete

mycomputer:~ admin$ gam version checkrc

GAMADV-XTD3 6.66.03 - https://github.com/taers232c/GAMADV-XTD3 - pyinstaller

Ross Scroggs

Python 3.12.0 64-bit final

MacOS Sonoma 14.1.1 arm64

Path: /Users/admin/bin/gamadv-xtd3

Config File: /Users/admin/GAMConfig/gam.cfg, Section: DEFAULT, customer_id: idnumber, domain: domainname

Time: 2023-12-03T08:04:00+03:00

Version Check:

  Current: 6.66.03

   Latest: 6.66.03

Reply all
Reply to author
Forward
0 new messages