taers232c/GAMADV-XTD3 v6.30.09

GAM 6.30.09

on GitHub

Scroll to bottom of page for installation/downloads

Latest updates

6.30.09

Added the following shortcuts to <DriveFileQueryShortcut>:

* my_top_files - "'me' in owners and mimeType != application/vnd.google-apps.folder and 'root' in parents"
* my_top_folders - "'me' in owners and mimeType = application/vnd.google-apps.folder and 'root' in parents"
* my_top_items - "'me' in owners and 'root' in parents"

6.30.08

Following Jay's lead, added the following License SKUs:

1010390001 - Assured Controls
1010400001 - Beyond Corp Enterprise

6.30.07

Added option sheetsfields <SpreadsheetSheetsFieldList> to gam <UserTypeEntity> print|show sheet <DriveFileEntity>
that lets you specfiy the desired subfields from the sheets field of a spreadsheet that should be displayed.
By default, all sheets subfields are displayed.

<SpreadsheetSheetsField> ::=
        bandedranges|
        basicfilter|
        charts|
        columngroups|
        conditionalformats|
        data|
        developermetadata|
        filterviews|
        merges|
        properties|
        protectedranges|
        rowgroups|
        slicers
<SpreadsheetSheetsFieldList> ::= "<SpreadsheetSheetsField>(,<SpreadsheetSheetsField>)*"

6.30.06

Fixed bug in gam <UserTypeEntity> create|update|delete drivefileacl <DriveFileEntity> ... updatesheetprotectedranges
that caused a trap.

6.30.05

Cleaned up code for option updatesheetprotectedranges in gam <UserTypeEntity> create|update|delete drivefileacl <DriveFileEntity>.

6.30.04

Improved output formatting for field sheets in gam <UserTypeEntity> info sheet <DriveFileEntity>.

6.30.03

Updated gam <UserTypeEntity> create|update drivefileacl <DriveFileEntity> commands to handle the following error.

ERROR: 403: fileOrganizerOnFoldersInSharedDriveOnly - FileOrganizer role is only allowed on folders.

Added option updatesheetprotectedranges to gam create|update|delete drivefileacl commands that causes GAM to update Sheet Protected Ranges if` is a Google Sheet.

6.30.02

Fixed error message in gam print cigroups when an invalid field was specified.

6.30.01

Fixed bug in gam create cigroup <EmailAddress> name <String> <GroupAttribute>+ where the group name was set to <EmailAddress> rather than <String>.

6.30.00

Added option returnidonly to gam <UserTypeEntity> show fileinfo <DriveFileEntity>
that causes GAM to return just the file ID of the files in <DriveFileEntity> file as output.

$ gam user user@domain.com show fileinfo root returnidonly
0AHYenC8f12ALUk9xyz

$ gam user testsimple show fileinfo name "Test File" returnidonly
0B3YenC8f12ALflhUTmtNS3E2Vk9LSUpBVXRSUG5lQ29GWkRtWHM1VzU1blc4ZW1pb2FnNTA

Changed the display format of file paths for files on Shared Drives.

• Old format - SharedDrive(TS Shared Drive 6)/TS SD6 Folder/TS TD6 Doc
• New format -SharedDrives/TS Shared Drive 6/TS SD6 Folder/TS TD6 Doc

Added option returnpathonly to gam <UserTypeEntity> show filepath <DriveFileEntity>
that causes GAM to return just the file path of the files in <DriveFileEntity> file as output.

$ gam user user@domain.com show filepath name "Test File" returnpathonly
My Drive/Classroom/Test File

$ gam user user@domain.com show filepath 0AJ6mqwXP9wHxUk9xyz returnpathonly
TS Shared Drive 6

$ gam user testsimple show filepath 0AJ6mqwXP9wHxUk9xyz returnpathonly fullpath
SharedDrives/TS Shared Drive 6

$ gam user user@domain.com show filepath teamdriveid 0AJ6mqwXP9wHxUk9xyz teamdrivefilename "TS TD6 Doc" returnpathonly
SharedDrives/TS Shared Drive 6//TS SD6 Folder/TS TD6 Doc

Added command gam comment <String>* that displays the comment data on stdout.
This can be used to validate csv_input_row_filters and column value extraction.

$ more Comment.csv
col1,col2
aaa,111
bbb,222
ccc,333
$ gam config csv_input_row_drop_filter "col1:regex:bbb" csv Comment.csv gam comment "Col1:~~col1~~" "Col2:~~col2~~"
2022-12-16T12:41:50.045-08:00,0/2,Using 2 processes...
Col1:aaa Col2:111
Col1:ccc Col2:333

Updated gam <UserTypeEntity> create|delete license <SKUIDList> to take a list of SKUs.

Updated gam create user <EmailAddress> ... license <SKUIDList> to take a list of SKUs.

Updated gam <UserTypeEntity> sync license <SKUIDList> to take a list of SKUs and
added option allskus|onesku that is required when multiple SKUs are specified.

• allskus indicates that users in <UserTypeEntity> will be updated to have all of the SKUs in <SKUIDList>.
  • This is typically used when assigning different types of licenses, such as an Enterprise license and a Voice license.
• onesku indicates that users in <UserTypeEntity> with none of the licenses in<SKUIDList> will be updated to have the first available license SKU in <SKUIDList>.
  • This is typically used with Google Education Plus or Google Education Standard licenses, which are split across multiple SKUs.

Added option basic to gam print cigroups that causes GAM to display the basic
Cloud Identity Group fields, i.e., those fields that do not require an additional API call per group.

Following Jay's lead, added option query <String> to gam print cigroups.

6.29.21

Fixed bugs in gam selectfilter that caused traps or inappropriate error messages.

6.29.20

Fixed bug in gam <UserTypeEntity> archive messages <GroupItem> that caused a trap.

6.29.19

Fixed bug introduced in 6.29.17 in todrive that caused a trap.

6.29.18

Added the following variables to gam.cfg to provide more flexibility when multiple row filters are specified.

• csv_input_row_filter_mode allmatch|anymatch
  • allmatch - all filters must match to include in input; this is the default and is the current behavior
  • anymatch - any filter must match to include in input
• csv_input_row_drop_filter_mode allmatch|anymatch
  • allmatch - all filters must match to drop from input
  • anymatch - any filter must match to drop from input; this is the default and is the current behavior
• csv_output_row_filter_mode allmatch|anymatch
  • allmatch - all filters must match to include in output; this is the default and is the current behavior
  • anymatch - any filter must match to include in output
• csv_output_row_drop_filter_mode allmatch|anymatch
  • allmatch - all filters must match to drop from output
  • anymatch - any filter must match to drop from output; this is the default and is the current behavior

6.29.17

Added option todrive tdcellnumberformat text|number that causes GAM to set the Sheet Number format when uploading files with todrive.

6.29.16

Fixed bug introduced in 6.29.15 that caused an error like this:

ERROR: Config File: gam.cfg, Section: DEFAULT, Item: todrive_locale, Value: "en_us", Expected: ,ar-eg,az-az,be-by,bg-bg,bn-in,ca-es,cs-cz,cy-gb,da-dk,de-ch,de-de,el-gr,en-au,en-ca,en-gb,en-ie,en-us,es-ar,es-bo,es-cl,es

6.29.15

Updated gam [<UserTypeEntity>] info|print|show drivelabels languagecode <DriveLabelLanguageCode> to use the BCP-47 language code.

6.29.14

Added option stripcrsfromtitle to gam <UserTypeEntity> print|show datastudioassets that causes carriage returns,
linefeeds and nulls to be stripped from asset titles.

Installation

If you are a first time Gam user:

• https://github.com/taers232c/GAMADV-XTD3/wiki/How-to-Install-Advanced-GAM

If you are updating your GAMADV-XTD3 version:

• https://github.com/taers232c/GAMADV-XTD3/wiki/How-to-Update-Advanced-GAM

If you are upgrading from standard Gam

• https://github.com/taers232c/GAMADV-XTD3/wiki/How-to-Upgrade-from-Standard-GAM

If you are upgrading from GAMADV-X or GAMADV-XTD

• https://github.com/taers232c/GAMADV-XTD3/wiki/How-to-Upgrade-from-GAMADV-X-or-GAMADV-XTD

sha256 hashes

e90998fc62b90375943b2bf10c2b8841c481261df5c9fc5d4ee124695fa1283b  gamadv-xtd3-6.30.09-linux-arm64-glibc2.23.tar.xz
d40761131b498da58d667e20021ffb32b4619bb404af3e085f0116e0fde792e9  gamadv-xtd3-6.30.09-linux-arm64-glibc2.27.tar.xz
291838b3db2dabd4802e98fe054ea5e039ae2972ff7879764c1eb479683c2c52  gamadv-xtd3-6.30.09-linux-arm64-glibc2.31.tar.xz
9d663d1d765592bb9e10396cdf690a0c371398813f57ae035ebef7a2a937d96f  gamadv-xtd3-6.30.09-linux-x86_64-glibc2.19.tar.xz
a31e4324118817aca3c74465c72386124d96bc4ff5e79de42240938e895f7e25  gamadv-xtd3-6.30.09-linux-x86_64-glibc2.23.tar.xz
6c0dc0d37e45a373bd0bd96e40c904d85152a839a0edc8ad663e567fc8e59172  gamadv-xtd3-6.30.09-linux-x86_64-glibc2.27.tar.xz
2af76961fe4b6c67e0dee3844fed9c3c2c5351cd4d71e098d8f39f5c1cac22ff  gamadv-xtd3-6.30.09-linux-x86_64-glibc2.31.tar.xz
cba0e20d5e57949afccff92c609e44349ee262af1b03f8dac2ac366c276cac13  gamadv-xtd3-6.30.09-linux-x86_64-glibc2.35.tar.xz
9e6d5b56693f1dd32edeac2da8f84e09967295e9dd4f5fa8dd03e35ce937a1b5  gamadv-xtd3-6.30.09-linux-x86_64-legacy.tar.xz
fe99c745b1e47e5e80c5b9cceb5a92098e5813522cf88238c372614a9d81e3ac  gamadv-xtd3-6.30.09-macos-arm64.tar.xz
1b0ccb8f7f6cfbbf117b784302ab89adfb4512d31e443ffe983b21c3eb1a7737  gamadv-xtd3-6.30.09-macos-x86_64-legacy.tar
6b9966c46cccaa6cde4fc27b7ea107771c550d58b91c2ee62b86db19e21e63ad  gamadv-xtd3-6.30.09-macos-x86_64.tar.xz
3e0458c5f76197f0570078cc82672620ab7a4899f0a399b8e354c3e8c8749b7b  gamadv-xtd3-6.30.09-windows-x86.msi
cb2a4f634c7d122c0edf29817ec274b091c509071babb3900fe9861d957f3dbd  gamadv-xtd3-6.30.09-windows-x86.zip
b61336292fbf1508c581e519f288de2ff705d31b523fbae545dde2baa305efa2  gamadv-xtd3-6.30.09-windows-x86_64.msi
601ac84a0200c383feba9f72d0ec5d5b1160d52cd0828ecf5da7cef87c65893e  gamadv-xtd3-6.30.09-windows-x86_64.zip