search

hackclub / sheets-backup

Backup your Google Sheets to a git repository.
MIT License
5 stars 0 forks source link

Account for Google Sheets export variations #1

Closed zachlatta closed 8 years ago

zachlatta commented 9 years ago

Exports to .ods from Google Sheets seem to have random style changes each time, causing this script to create tons of needless commits. This should be accounted for.

Here's a diff between two commits in a sheet we're keeping track of:

diff --git a/clubs.fods b/clubs.fods
index 329248f..cf73f1d 100644
--- a/clubs.fods
+++ b/clubs.fods
@@ -307,47 +307,47 @@
    <style:table-cell-properties style:vertical-align="top"/>
    <style:text-properties style:use-window-font-color="true" style:text-line-through-style="none" style:text-line-through-type="none" style:text-position="" style:font-name="Courier New" fo:font-size="10pt" fo:font-style="normal" style:text-underline-style="none" fo:font-weight="normal" style:font-name-asian="Courier New" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/>
   </style:style>
-  <style:style style:name="ce22" style:family="table-cell" style:parent-style-name="Default">
+  <style:style style:name="ce23" style:family="table-cell" style:parent-style-name="Default">
    <style:table-cell-properties style:vertical-align="bottom"/>
    <style:text-properties style:use-window-font-color="true" style:text-line-through-style="none" style:text-line-through-type="none" style:text-position="" style:font-name="Courier New" fo:font-size="10pt" fo:font-style="normal" style:text-underline-style="none" fo:font-weight="normal" style:font-name-asian="Courier New" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/>
   </style:style>
-  <style:style style:name="ce23" style:family="table-cell" style:parent-style-name="Default">
+  <style:style style:name="ce26" style:family="table-cell" style:parent-style-name="Default">
    <style:table-cell-properties style:vertical-align="bottom"/>
    <style:text-properties style:use-window-font-color="true" style:text-line-through-style="none" style:text-line-through-type="none" style:text-position="" style:font-name="Arial" fo:font-size="245pt" fo:font-style="italic" style:text-underline-style="none" fo:font-weight="bold" style:font-name-asian="Arial" style:font-size-asian="245pt" style:font-style-asian="italic" style:font-weight-asian="bold" style:font-size-complex="245pt" style:font-style-complex="italic" style:font-weight-complex="bold"/>
   </style:style>
-  <style:style style:name="ce24" style:family="table-cell" style:parent-style-name="Default">
+  <style:style style:name="ce22" style:family="table-cell" style:parent-style-name="Default">
    <style:table-cell-properties style:vertical-align="bottom"/>
    <style:text-properties fo:color="#000000" style:text-line-through-style="none" style:text-line-through-type="none" style:text-position="" style:font-name="Arial" fo:font-size="10pt" fo:font-style="normal" style:text-underline-style="none" fo:font-weight="normal" style:font-name-asian="Arial" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/>
   </style:style>
-  <style:style style:name="ce25" style:family="table-cell" style:parent-style-name="Default">
+  <style:style style:name="ce24" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N10099">
    <style:table-cell-properties style:vertical-align="bottom"/>
    <style:text-properties fo:color="#000000" style:text-line-through-style="none" style:text-line-through-type="none" style:text-position="" style:font-name="Arial" fo:font-size="10pt" fo:font-style="normal" style:text-underline-style="none" fo:font-weight="normal" style:font-name-asian="Arial" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/>
   </style:style>
-  <style:style style:name="ce26" style:family="table-cell" style:parent-style-name="Default">
-   <style:table-cell-properties style:vertical-align="bottom"/>
-   <style:text-properties style:use-window-font-color="true" style:text-line-through-style="none" style:text-line-through-type="none" style:text-position="" style:font-name="Arial" fo:font-size="10pt" fo:font-style="italic" style:text-underline-style="none" fo:font-weight="normal" style:font-name-asian="Arial" style:font-size-asian="10pt" style:font-style-asian="italic" style:font-weight-asian="normal" style:font-size-complex="10pt" style:font-style-complex="italic" style:font-weight-complex="normal"/>
-  </style:style>
-  <style:style style:name="ce27" style:family="table-cell" style:parent-style-name="Default">
+  <style:style style:name="ce25" style:family="table-cell" style:parent-style-name="Default">
    <style:table-cell-properties style:vertical-align="bottom"/>
    <style:text-properties fo:color="#000000" style:text-line-through-style="none" style:text-line-through-type="none" style:text-position="" style:font-name="Arial" fo:font-size="10pt" fo:font-style="normal" style:text-underline-style="none" fo:font-weight="normal" style:font-name-asian="Arial" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/>
   </style:style>
   <style:style style:name="ce28" style:family="table-cell" style:parent-style-name="Default">
    <style:table-cell-properties style:vertical-align="bottom"/>
-   <style:text-properties style:use-window-font-color="true" style:text-line-through-style="none" style:text-line-through-type="none" style:text-position="" style:font-name="Arial" fo:font-size="10pt" fo:font-style="normal" style:text-underline-style="none" fo:font-weight="bold" style:font-name-asian="Arial" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="bold" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="bold"/>
+   <style:text-properties style:use-window-font-color="true" style:text-line-through-style="none" style:text-line-through-type="none" style:text-position="" style:font-name="Arial" fo:font-size="10pt" fo:font-style="italic" style:text-underline-style="none" fo:font-weight="normal" style:font-name-asian="Arial" style:font-size-asian="10pt" style:font-style-asian="italic" style:font-weight-asian="normal" style:font-size-complex="10pt" style:font-style-complex="italic" style:font-weight-complex="normal"/>
   </style:style>
-  <style:style style:name="ce29" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N10099">
+  <style:style style:name="ce29" style:family="table-cell" style:parent-style-name="Default">
    <style:table-cell-properties style:vertical-align="bottom"/>
    <style:text-properties fo:color="#000000" style:text-line-through-style="none" style:text-line-through-type="none" style:text-position="" style:font-name="Arial" fo:font-size="10pt" fo:font-style="normal" style:text-underline-style="none" fo:font-weight="normal" style:font-name-asian="Arial" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/>
   </style:style>
   <style:style style:name="ce30" style:family="table-cell" style:parent-style-name="Default">
    <style:table-cell-properties style:vertical-align="bottom"/>
-   <style:text-properties fo:color="#000000" style:text-line-through-style="none" style:text-line-through-type="none" style:text-position="" style:font-name="Arial" fo:font-size="10pt" fo:font-style="normal" style:text-underline-style="none" fo:font-weight="normal" style:font-name-asian="Arial" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/>
+   <style:text-properties style:use-window-font-color="true" style:text-line-through-style="none" style:text-line-through-type="none" style:text-position="" style:font-name="Arial" fo:font-size="10pt" fo:font-style="normal" style:text-underline-style="none" fo:font-weight="bold" style:font-name-asian="Arial" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="bold" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="bold"/>
   </style:style>
   <style:style style:name="ce31" style:family="table-cell" style:parent-style-name="Default">
    <style:table-cell-properties style:vertical-align="bottom"/>
+   <style:text-properties fo:color="#000000" style:text-line-through-style="none" style:text-line-through-type="none" style:text-position="" style:font-name="Arial" fo:font-size="10pt" fo:font-style="normal" style:text-underline-style="none" fo:font-weight="normal" style:font-name-asian="Arial" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/>
+  </style:style>
+  <style:style style:name="ce32" style:family="table-cell" style:parent-style-name="Default">
+   <style:table-cell-properties style:vertical-align="bottom"/>
    <style:text-properties fo:color="#0000ff" style:text-line-through-style="none" style:text-line-through-type="none" style:text-position="" style:font-name="Arial" fo:font-size="10pt" fo:font-style="normal" style:text-underline-style="solid" style:text-underline-width="auto" style:text-underline-color="font-color" fo:font-weight="normal" style:font-name-asian="Arial" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/>
   </style:style>
-  <style:style style:name="ce32" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N134">
+  <style:style style:name="ce27" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N134">
    <style:table-cell-properties style:vertical-align="bottom"/>
    <style:text-properties fo:color="#000000" style:text-line-through-style="none" style:text-line-through-type="none" style:text-position="" style:font-name="Arial" fo:font-size="10pt" fo:font-style="normal" style:text-underline-style="none" fo:font-weight="normal" style:font-name-asian="Arial" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/>
   </style:style>

And this is what happens when the script is allowed to run for a few days without accounting for these variations:

2,502 commits

maxwofford commented 9 years ago

More free internet points!

zachlatta commented 8 years ago

This seems to have fixed itself? Thanks Google.