Download the board configuration information from Google sheet

[mithro]

The Google Sheet @
https://docs.google.com/spreadsheets/d/1CY38U9o4KPCZvfdblJWgpEBKLCnMhlQipjTqfH6QVOw/edit?gid=0#gid=0 has the information about names / mac addresses / etc.

[mithro]

wget "https://docs.google.com/spreadsheets/d/e/2PACX-1vT1MjjK6cAl3wShj8LWfeaXNPjynvm4OP6fI3JV8IteAAxmOPu6TBC8Yl6w1eV5kezQ-XZXIbnSWS4r/pub?output=csv" -o out.csv

[mithro]

Can ansible import data from a CSV file?

[mithro]

https://docs.ansible.com/ansible/latest/collections/community/general/read_csv_module.html

[CarlFK]

yes, maybe, but I think this isn't a good plan.
a good plan is to move all the dynamic pi things into django
which will be needed to store state of a pi (like reserved, status, history)

there will still be the issue of moving data from spreadsheet into db, but that can be a script on the server, or a button on a page.