Bulk address updates "ERROR: invalid argument [locality] for account organization details"

176 views
Skip to first unread message

Cody Khov

unread,
May 17, 2019, 5:59:32 PM5/17/19
to GAM for G Suite
When updating users' physical address details from CSV, I'm getting an error from this part of the command '... location buildingId ~buildingId'. Error reads,

ERROR: invalid argument (LON) for account organization details


I've checked for hidden UNICODE and ASCII characters in the csv file under the buildingId column and the file reads as I'm seeing LON and not (LON).

Just incase, here are the gam version details on my machine:

Python 3.7.3 64-bit final

google-api-python-client 1.7.8

oauth2client 4.1.3

Darwin-17.7.0-x86_64-i386-64bit x86_64

Ross Scroggs

unread,
May 17, 2019, 6:08:21 PM5/17/19
to google-ap...@googlegroups.com
Cody,

        (location clear|(type default|desk|<String> area <String> [building|buildingid <String>] [floor|floorname <String>] [section|floorsection <String>] [desk|deskcode <String>] endlocation))|


Have you included enlocation at the end of the location attributes list?


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-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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/d938ca9b-aa81-40e8-9fb1-a95cc4c01976%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


--

Cody Khov

unread,
May 17, 2019, 6:34:18 PM5/17/19
to google-ap...@googlegroups.com
Hi Ross,

Just like so?

gam csv ./test-address.csv gam update user ~User addresses type ~type formatted ~formatted primary organization department ~department title ~title type ~type location building ~building floorName ~floorName endlocation


Using 1 processes...


ERROR: invalid argument (LON) for account organization details


If so, the command fails with or without it. The CSV file reads;

User,type,formatted,department,title,areadesk,buildingId,floorname
letme.showyou,work,(physical address\nAddress Line 2\n Address line 3,dpt_name,user_title,desk,LON,floor_number


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


--
vshapesaqua11553186012.gif   Cody Khov
IT Manager

in1552694272.png    fb1552694203.png      tw1552694330.png      ig1552694392.png
1255 Battery St. Ste 500. San Francisco, CA 94111

Ross Scroggs

unread,
May 17, 2019, 6:41:32 PM5/17/19
to google-ap...@googlegroups.com
Cody,

<UserMultiAttributes> ::=

        (addresses clear|(type home|other|work|(custom <String>) [unstructured|formatted <String>] [pobox <String>] [extendedaddress <String>] [streetaddress <String>]

                [locality <String>] [region <String>] [postalcode <String>] [country <String>] [countrycode <String>] notprimary|primary))|

        (location clear|(type default|desk|<String> area <String> [building|buildingid <String>] [floor|floorname <String>] [section|floorsection <String>] [desk|deskcode <String>] endlocation))|

(organization 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>] [fulltimeequivalent <Integer>] notprimary|primary))|


You're missing primary to end organization

gam csv ./test-address.csv gam update user ~User addresses type ~type formatted ~formatted primary organization department ~department title ~title type ~type primary location building ~building floorName ~floorName endlocation


Ross



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


--

Cody Khov

unread,
May 17, 2019, 6:52:36 PM5/17/19
to google-ap...@googlegroups.com
Thanks Ross! That did it.

... primary location building ~building floorName ~floorName endlocation




For more options, visit https://groups.google.com/d/optout.
Reply all
Reply to author
Forward
0 new messages