Sheets Revision Hystory

[eric...@ww.com]

Ross,

Is there a way to delete the revision history for a file and or a drive folder with all files in folder.  

Thanks

[eric...@ww.com]

Or is there a way to disable revisions for editors 

[Ross Scroggs]

Eric,

See: https://github.com/taers232c/GAMADV-XTD3/wiki/Users-Drive-Revisions

Contact me directly,

Ross

--
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 on the web visit https://groups.google.com/d/msgid/google-apps-manager/9381d7a3-228a-4159-ab0c-69e7179e81c0n%40googlegroups.com.

--

Ross Scroggs

ross.s...@gmail.com

[Markus Frömmel]

@Ross,

Speaking of revisions – Is it possible to download a "changelog" of a google sheet (e.g. in csv) so that I can see all changes that were ever made to this sheet in one view and potentially process it programmatically?

I have a certain file that I would like to analyze. (I don't care about formating, just content)

Kind Regards, Markus

[Ross Scroggs]

Markus,

I don't think so: see https://developers.google.com/drive/api/v3/manage-revisions

To download the revision content, you need to call revisions.get method with the parameter alt=media. Revisions for Google Docs, Sheets, and Slides can't be downloaded.

Ross

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/4d8a100f-8b0e-4fc3-a62e-835ab3e1462bn%40googlegroups.com.

--

Ross Scroggs

ross.s...@gmail.com

[Kim Nilsson]

Ross, it seems to be possible to download revisions, but not always.

Because when I run the print filerevisions command this I get a nice Sheet with one row for each revision, and it has clickable links where I can export/download revisions of my file in different formats (in my case a Sheet) with different content.

gam user UserName print filerevisions FileID todrive oneitemperrow

That works great with a Sheet with 60k cells, and 4 listed revisions.

I can download the revision I want in all listed formats. Weird that the xlsx export is much smaller than the csv export!

However, it doesn't work at all for a Sheet with 425k cells and a daily revision of all cells since end of November. :-(

This is the Sheet I wish to see what an older revision looks like, but it crashes even in the GUI, so I can't create a copy in the GUI.

I was hoping I could grab it via API.

The GUI allows me to work with the revisions for 7, 6, 5 Feb, but from 4 Feb and down it crashes.

And what's really cool is that I can use the link in the xtd3 filerevisions sheet to download the version from 4 Feb! So it succeeds one older revision than the GUI does.

/Kim

[Markus Frömmel]

This sounds very interesting. However I can't get the command to work

gam user sysadmin print filerevisions 18TvwzgfgfhdhdfhfgdhhfbQqJ3_vPQmMvpM todrive oneitemperrow
Command: /home/markus_zen_it_berlin/bin/gamadv-xtd3/gam user sysadmin print filerevisions 18TvwzdzHiUqk4DlFPIaS6IvW8Rc2fbQqJ3_vPQmMvpM >>>todrive<<< oneitemperrow

ERROR: Invalid Drive Folder Name, Config File: /home/markus_zen_it_berlin/.gam/gam.cfg, Item: todrive_parent, Value: gamoutput, Not Found
Help: Syntax in file /home/markus_zen_it_berlin/bin/gamadv-xtd3/GamCommands.txt
Help: Documentation is at https://github.com/taers232c/GAMADV-XTD3/wiki

The xlsx file it smaller because it is (zip) compressed by default unlike csv which is uncompressed

Now suppose I would succeed in downloading all the revisions, I would still need to write a script which compares the different files in a meaningful way?

--
You received this message because you are subscribed to a topic in the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-manager/-5bb7Jh-0K8/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/f250c536-526f-4418-81ff-572feda266e3n%40googlegroups.com.

[Ross Scroggs]

Markus,

You'ce specified in gam.cfg that files are to be uploaded into a folder named gamoutput; however, either sysadmin or todrive_user if specified don't have a folder of that name.

Ross

--

ross.s...@gmail.com

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 on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAGWJR4brzfyHpPWHMPyrQR8XdytC1Co3wjiEMd_VLc%2BR6iud-Q%40mail.gmail.com.

[Markus Frömmel]

😅 Sometimes it helps to read error messages properly. Thank you!

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/BC616383-332C-4C64-A2E2-4DD5F9ED6D53%40gmail.com.

[Markus Frömmel]

the command works now, but sadly I am getting only 7 revisions on a google sheet file that has been actively used for years

revision.id	revision.modifiedTime
66294	2022-01-27T13:57:42Z
66506	2022-01-31T08:32:10Z
66525	2022-01-31T12:10:30Z
66552	2022-01-31T18:49:22Z
66568	2022-01-31T19:25:46Z
66573	2022-01-31T20:06:04Z
66774	2022-02-02T15:24:22Z

[Ross Scroggs]

Markus,

If you open the file in Sheets, how many revisions does it show?

Ross

--

ross.s...@gmail.com

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAGWJR4a1SuafHPD1ppW5OHNLSbEX%2BaefOh1ekj3ehVmx0KcGxw%40mail.gmail.com.

[Markus Frömmel]

literally hundreds if not thousands ... just takes some time to scroll down .... I stopped trying to go further after a few minutes

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/90476AED-D193-4BFD-A6A8-45E25B0DB46C%40gmail.com.

[Kim Nilsson]

The file seems to have had 66774 versions. 

[Markus Frömmel]

yes you are right – Actually I just tried something in the meantime and it blew my mind:

by looking at the export link  https://docs.google.com/spreadsheets/export?id=18TvwzxyzPQmMvpM&revision=66774&exportFormat=xlsx

I noticed I can put any number there and it actually works. I can go back all the way to revision 1.

My gameplan is now to download every 1000th revision or so and then maybe write a script to analyse / record the changes. Although I don't know yet how exactly I should approach it. I would appreciate if google could simply fix their show cell history feature instead.

Cheers, Markus

Am Di., 8. Feb. 2022 um 22:19 Uhr schrieb Kim Nilsson <there.is.no...@gmail.com>:

The file seems to have had 66774 versions. 

--

You received this message because you are subscribed to a topic in the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-manager/-5bb7Jh-0K8/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-man...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAGPzzFuGKa-OxUf%3Dd0gxSMpDtcB9BVqjvOiQVGnQNrbUVKUfGw%40mail.gmail.com.

[Kim Nilsson]

Oh, totally unfair! 😭

I can't even grab a version from last week.