search

CarlFK / pici

3 stars 1 forks source link

Download the board configuration information from Google sheet #28

Open mithro opened 2 months ago

mithro commented 2 months ago

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

mithro commented 2 months ago

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

mithro commented 2 months ago

Can ansible import data from a CSV file?

mithro commented 2 months ago

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

CarlFK commented 2 months ago

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.