taers232c/GAMADV-XTD3 v6.30.08

GAM 6.30.08

on GitHub

Scroll to bottom of page for installation/downloads

Latest updates

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

2f32ff6082ad1b77ba38adab8032adf3a2c00d133b33cd7388b293239ae8d7ef  gamadv-xtd3-6.30.08-linux-arm64-glibc2.23.tar.xz
40c6ccc341ed77f9d99cf39c3222850d0426413705174679b723ceab68dcf2f3  gamadv-xtd3-6.30.08-linux-arm64-glibc2.27.tar.xz
050481a87791fa63f30feba7e2847c1a4c4aa20293d7ddd5c9aed0e953f1380b  gamadv-xtd3-6.30.08-linux-arm64-glibc2.31.tar.xz
169ec61b15892592055c92e6f80cc3f76c4133983555d0cbf235e25958bb119d  gamadv-xtd3-6.30.08-linux-x86_64-glibc2.19.tar.xz
eb711aa5bd6a4c03c9e6c5c8d0b3ed729b7a058459de659ddea3e079153d5db3  gamadv-xtd3-6.30.08-linux-x86_64-glibc2.23.tar.xz
f40b81e734926ae9c1371c754f9633c3ada3095d5828c5ebde081f110f3999af  gamadv-xtd3-6.30.08-linux-x86_64-glibc2.27.tar.xz
1d7fece27e1e2f76986e433c102241891ce151ce72c78a7d5365d59b3a28de41  gamadv-xtd3-6.30.08-linux-x86_64-glibc2.31.tar.xz
b7ed3ae9bf9e5e5bb69b57719b108e7e062df237d97aa31c70e899c3f8b04b9a  gamadv-xtd3-6.30.08-linux-x86_64-glibc2.35.tar.xz
0811757404667eb0e424e5ac743d37668ab77fa588e720f5bfa1bdf5deb3805b  gamadv-xtd3-6.30.08-linux-x86_64-legacy.tar.xz
2b70d7a5c4a798bf6526e3345d9a8a7611bfd5305853b13622900dbeced8a13e  gamadv-xtd3-6.30.08-macos-arm64.tar.xz
f09e98466ea3487bae46b7c774b20aa627ad9c72199d76bdc924fd3325b67a58  gamadv-xtd3-6.30.08-macos-x86_64-legacy.tar
1a48bb3cb5edaa7fe68bf280eb92bed495a03880b55b627e867f20e6a1e6f871  gamadv-xtd3-6.30.08-macos-x86_64.tar.xz
6f69133682e4ef6e28ae5ba09373783d0a3a621a29922ccc6c97c418e139c11a  gamadv-xtd3-6.30.08-windows-x86.msi
26518ecd34807b601b2374d574bc0433454d5e709f710183ffefde127e87a47c  gamadv-xtd3-6.30.08-windows-x86.zip
c1532bd565bfa35aa8083df3f9edef73c9054143a956f5727e21a086ba4ffe70  gamadv-xtd3-6.30.08-windows-x86_64.msi
decf4eb39152a691593e50d4bc20c7eff9fa56c98724fd0795d9c3cd4915673b  gamadv-xtd3-6.30.08-windows-x86_64.zip