voxxrin / voxxrin3

GNU Affero General Public License v3.0
9 stars 2 forks source link

Introduce google spreadsheet crawler #100

Open fcamblor opened 2 months ago

fcamblor commented 2 months ago

Benefits :

I created a Voxxrin template spreadsheet for this : https://docs.google.com/spreadsheets/d/1ulA9VuwWbSZucE8TQToyawC1GL-6JqQnpWCe1XeqP_M/edit?usp=sharing

JSON from this spreadsheet can be gathered through : GET https://docs.google.com/spreadsheets/d/1ulA9VuwWbSZucE8TQToyawC1GL-6JqQnpWCe1XeqP_M/gviz/tq?tqx=out:json&tq&gid=1914487150 (this is JSONP-like)

If I can implement a data from gspreadsheet reader, this would allow to avoid implementing it right into Voxxrin and would make configuration far more flexible/agile.

fcamblor commented 6 days ago

It would also be a nice thing to allow to import a conference-hall event config into this spreadsheet, so that every conference-hall information is automatically gathered (only the timeslot definition remains)

This process would have to be idempotent (we should re-import conference-hall data multiple times without erasing provided timeslots)