Just started using this google drive api - with it I can log direct from my lightwaverf ruby gem into a google spreadsheet online. I like this, hope I can trust the google with my data. A bit closer to getting rid of my own web hosting. I'll do this for the remote control logging with the 433mhz receiver next too, absolutely no need to be logging it on @ourduino - except to make it visible to workmates...
About to publish a new version of the gem in the meantime, here is a code snippet:
session = [GoogleDrive](/wiki/#google).login self.get_config['spreadsheet']['username'], self.get_config['spreadsheet']['password']
ws = session.spreadsheet_by_key( spreadsheet ).[worksheets](/wiki/#work)[0]
rows = ws.num_rows
row = rows + 1
ws[ row, 1 ] = data['timestamp']
ws[ row, 2 ] = data['message']['usage']
ws[ row, 5 ] = data['message']['annotation']['title']
ws[ row, 6 ] = data['message']['annotation']['text']
ws.save( )Maybe Clare will be more interested in this stuff now it is a spreadsheet. She loves spreadsheets...
⬅️ Bad christmas gift idea for the boys :: Lard spillage! ➡️
Paulʼs weblog - I live in A sleepy town, Kent. Wed + dad to two, I'm a full stack web engineer, + I do js / node, some ruby, other languages etc. I like pubbing, parkrun, restaurants, home automation 🤖 + other diy stuff, history, tree stuff, telly 📺, squirrels, pirates, lego, + time travel.