github taers232c/GAMADV-XTD3 v6.30.07
GAM 6.30.07
on GitHub

latest releases: v7.00.35, v7.00.34, v7.00.33...
22 months ago

Scroll to bottom of page for installation/downloads

Latest updates

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:

If you are upgrading from standard Gam

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

sha256 hashes

fa0357d46970daa66dfc8352af8f48940d950028271b47ecc5a0a03dd01a525a  gamadv-xtd3-6.30.07-linux-arm64-glibc2.23.tar.xz
cfb52275b45c2188c71ba215658082e6721cea949bf49419dc8f00f074f24016  gamadv-xtd3-6.30.07-linux-arm64-glibc2.27.tar.xz
13bcff3ed82b61a779997674c8f8a449891c5a0ecf388c4e808b4bf617ddbde7  gamadv-xtd3-6.30.07-linux-arm64-glibc2.31.tar.xz
a08dd2f39ce59176021c9fd1e4fc8863cdde6d27132055d69699f4cc60447263  gamadv-xtd3-6.30.07-linux-x86_64-glibc2.19.tar.xz
93db677a944308373b364e15e78688aff8c4b12956583179c074203b3c595345  gamadv-xtd3-6.30.07-linux-x86_64-glibc2.23.tar.xz
cb70a15e3c07a7771680775ac726345f15dc3266e6b101cbe4c30c96d34e723c  gamadv-xtd3-6.30.07-linux-x86_64-glibc2.27.tar.xz
cb2eae25020d4e6c72f055850db60fa674460bb8e8786f1049bb94c3f61ce4cc  gamadv-xtd3-6.30.07-linux-x86_64-glibc2.31.tar.xz
60b4c57548726adec7c7824f904860aea8e306189df63d35491f27fe78d03cf0  gamadv-xtd3-6.30.07-linux-x86_64-glibc2.35.tar.xz
be1513b187add2c0fedcbeea09a912fcc07e837f48a0d728af0d366740aae8ab  gamadv-xtd3-6.30.07-linux-x86_64-legacy.tar.xz
447dfa6b306bf3facfa53a057ed7353873bc6b96d90d6191353a673699a65f23  gamadv-xtd3-6.30.07-macos-arm64.tar.xz
eeef3922db38e445ba95d309fa84174e74f535d56d777a865685d97a05d3d3c3  gamadv-xtd3-6.30.07-macos-x86_64-legacy.tar
2b6ce7c5796b95f24a724823c10fd98d934cb7f2d8cfa84429cb1457e1218ea7  gamadv-xtd3-6.30.07-macos-x86_64.tar.xz
fd71f8cca15ef18cc8c2b0907f6eb935b0a28d6696438b1e8cd085104d86b4df  gamadv-xtd3-6.30.07-windows-x86.msi
df6023bed8ea551bbaf9f8986fc42fd9eac110defdc4089576878c7ab79ceac0  gamadv-xtd3-6.30.07-windows-x86.zip
985fc1c27734427942ffe222934ee9350489e8d75a3831c6e2e3a28fe386d994  gamadv-xtd3-6.30.07-windows-x86_64.msi
efccb0e44e37fa79ed6ce574fd3385cea4536bbd0697b2be70311f8cdaf78142  gamadv-xtd3-6.30.07-windows-x86_64.zip
Check out latest releases or
releases around taers232c/GAMADV-XTD3 v6.30.07

Don't miss a new GAMADV-XTD3 release

NewReleases is sending notifications on new releases.

Get notifications