GAMADV vs GAM7
Lemonade Joe
Upon bit of playing around with GAM7, I found out that 'includes all features of GAMADV' is not exactly true, or I haven't found a way to actually use/find those features.
For example csv merging or field matching always gives an error of invalid command.
Similar when trying to update user profiles with attributes such as primary phones or creating a reporting/ management chain.
This created a problem for us as we are trying to automate employee signatures across locations, profile updates for job titles etc.
How should we approach this? Downgrade to GAMADV?
Jay Lee
--
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 visit https://groups.google.com/d/msgid/google-apps-manager/a595ddd0-e5c0-4666-a597-0c750b553287n%40googlegroups.com.
Lemonade Joe
For now I've been playing with two csv files to filter based on OrgUnitPath header and output to a new csv.
Upon stressful hours I have tried to also follow the GAM ChatGPT module, but that went without results as well.
I have now installed GAM-ADV on top of GAM7
GAM-ADV:
gam csv ./users_list.csv matchfield OrgUnitPath "/Org 1/HQ" {here I type save, write, output, >} ./filtered_users.csv
Results in
ERROR: Invalid choice (write{any of aforementioned}): Expected <gam>
Same for GAM7
What I also was attempting using GAM7:
gam csv users.csv gam user us...@example.com signature drivefileid $(gam csv ou_to_signature.csv matchfield orgUnitPath /HR returnfield drivefileid) replace {{FirstName}} "John" {{LastName}} "Doe" {{JobTitle}} "Freelance Recruiter" {{Email}} "us...@example.com" {{Phone}} "123-456-7890"
To match the signature html file with correct OU location and update placeholders in the html with users info in the csv.
Which resulted in errors across matchfield, returnfield and placeholders, using both {{}} and ~.
Then when I tried to go with a single user in a separate CSV to update PrimaryPhone, neither Primary, Default or just Phone was recognised as a valid command input.
Lemonade Joe
When I was building up the automation on previous version of GAM with GAM-ADV, I haven't had issues merging/ filtering two csv files.
Ross Scroggs
To view this discussion visit https://groups.google.com/d/msgid/google-apps-manager/27a01278-bd31-4816-8ab3-cf98e84cd788n%40googlegroups.com.
Eric Dannewitz
To view this discussion visit https://groups.google.com/d/msgid/google-apps-manager/01facbb3-8340-4dc2-b972-d8f0faf12826n%40googlegroups.com.
Ross Scroggs
GAM7 and GAMADV-XTD3 are the same code: use GAM7
Make a Google Sheet with two tabs: UserData and OUsigFileIDMap
OUsigFileIDMap has these columns:
OU,sigFileID
/HR,54587854857485
/Tech,78488854859485948
...
There is a row for each OU with the file ID of its signature template file.
Define a named range: OUsigFileIDMap with value: OUsigFileIDMap!A2:B3
Replace B3 with Bx where x is the last row
UserData has these columns:
Email,FirstName,LastName,JobTitle,Phone,OU,sigFileID
te...@domain.com,Tech,User,Tech Title,1234567,/Tech,=VLOOKUP(F2,OUsigFileIDMap,2,false)
h...@domain.com,HR,User,HR Title,7654321,/HR,=VLOOKUP(F3,OUsigFileIDMap,2,false)
...
Here's the Sheet URL for the UserData tab.
https://docs.google.com/spreadsheets/d/1gXoQy...-crlo/edit?gid=1234#gid=1234
gam redirect stdout./UpdateSignature.txt multiprocess redirect stderr stdout csv gsheet ludvik...@quivo.co 1gXoQy...-crlo id:1234 gam user "~Email" signature ghtml ludvik...@quivo.co "~sigFileID" replace FirstName "~FirstName" replace LastName "~LastName replace JobTitle "~JobTitle" replace Email "~Email" replace Phone "~Phone"
On Dec 30, 2024, at 6:46 AM, Lemonade Joe <ludvik...@quivo.co> wrote:
To view this discussion visit https://groups.google.com/d/msgid/google-apps-manager/27a01278-bd31-4816-8ab3-cf98e84cd788n%40googlegroups.com.