davelab6
commented
5 years ago https://developers.google.com/sheets/api/quickstart/python can be used to write the table data directly to Google Sheets, instead of the CSV/file/import manual steps
Open dberlow opened 5 years ago
davelab6
commented
5 years ago https://developers.google.com/sheets/api/quickstart/python can be used to write the table data directly to Google Sheets, instead of the CSV/file/import manual steps
djrrb
commented
5 years ago @davelab6 Thanks! I’m trying to keep this script as simple as possible while we develop it, but agree that reading and writing directly from google sheets would make the process less cumbersome. I think that is the direction we are heading...I’ll make a new issue for it.
DJR, Thanks for starting this.
I have a sheet at: https://docs.google.com/spreadsheets/d/1OS9wOXAB6zeoXy7tf7m8Du4zzMmAQYLCJktehCSZ-T8/edit#gid=0
Let's start the Instructions with more details. From Google Sheets? File/Download/comma separate values (csv, current sheet)? "Save it as import/Inputs.csv (make sure empty lines and spaces are removed)" did this, but just went from the the same sheet we've been using. What spaces? like empty columns or rows? are we editing the .csv file for this in a text editor?
"Run buildSpreadsheet.py" In the terminal window of finder?
iMac-Pro:~ DavidiMac$ buildSpreadsheet.py -bash: buildSpreadsheet.py: command not found
I'm guessing there is a download and install of buildSpreadsheet.py? ... I got no further.
"in RoboFont, select designspace when prompted"
"On the command line" In the terminal window?
if yes to all questions, i think I can get it from there if what to do with buildSpreadsheet.py is documented.
$ cd /path/to/my/repository/sources/ $ python3 /path/to/parama_roundup/buildSpreadsheet.py MyDesignspace.designspace (where MyDesignspace.designspace is your designspace filename)
The output will go in:
/export/Axes.csv /export/Measurements.csv /export/Widths.csv Return to Google Sheet and select File > Import and Create New Sheet for each CSV you want to add