Automate the process of updating our accounting AirTable data

[choldgraf]

We've recently updated our accounting table in AirTable so that it is semi-automatically synchronized when CS&S adds new rows to our accounting data. Documentation about this is found at: https://compass.2i2c.org/en/latest/finance/contracts.html

There is one manual step in the process where we must do the following:

• Watch for (daily) changes to the CS&S google sheet
• Delete all of the records in our AirTable accounting table[^1]
• Import all of the rows in the CS&S google sheet into our (now empty) airtable table

This could almost certainly be automated with either a CRON job or an integration service like make.com / zapier. It is basically just a copy/paste job that runs regularly. Automating it would remove the manual labor, and would also give us more confidence that our dashboards etc are always up to date.

[^1]: Note that this is because there are no unique IDs in our accounting table (unfortunately). The Xero software that CS&S uses doesn't give UIDs for each accounting record, and so the best we can do is a fuzzy match to try and merge/update. So instead of this complexity, we just delete the whole thing and start from scratch.

[colliand]

I'm getting a 404 error when I click the link: https://compass.2i2c.org/finance/contracts.html I thought it must be because compass should be team-compass. https://team-compass.2i2c.org/finance/contracts.html also generates a 404.

[choldgraf]

Argh I forgot the en/latest - I feel like we should stop using that as it makes the URLs harder to remember :-/

Here's the right URL: https://compass.2i2c.org/en/latest/finance/contracts.html

And note that the text will be updated there once we merge #704