{"id":1736,"date":"2017-12-17T07:11:11","date_gmt":"2017-12-16T22:11:11","guid":{"rendered":"http:\/\/matoken.org\/blog\/?p=1736"},"modified":"2017-12-17T08:36:46","modified_gmt":"2017-12-16T23:36:46","slug":"try-tosheets-which-can-be-connected-to-pipes-from-stdout-and-recorded-on-google-spreadsheet","status":"publish","type":"post","link":"https:\/\/matoken.org\/blog\/2017\/12\/17\/try-tosheets-which-can-be-connected-to-pipes-from-stdout-and-recorded-on-google-spreadsheet\/","title":{"rendered":"STDOUT\u304b\u3089\u30d1\u30a4\u30d7\u3067\u7e4b\u3044\u3067Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u8a18\u9332\u51fa\u6765\u308btosheets\u3092\u8a66\u3059"},"content":{"rendered":"

shell\u306eSTDOUT\u304b\u3089\u30d1\u30a4\u30d7\u3067\u7e4b\u3044\u3067Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u8a18\u9332\u51fa\u6765\u308btosheets<\/a>\u3068\u3044\u3046\u3082\u306e\u3092\u898b\u304b\u3051\u305f\u306e\u3067\u3061\u3087\u3063\u3068\u8a66\u3057\u3066\u307f\u307e\u3057\u305f\uff0e<\/p>\n

\u5c0e\u5165\u306fpip\u3067\u5165\u308a\u307e\u3059\uff0e<\/p>\n

\n
<\/span>pip install tosheets\r\n<\/pre>\n<\/div>\n
\u521d\u56de\u5b9f\u884c\u6642\u306b\u306f\u8a8d\u8a3c\u304c\u8d70\u3063\u3066\u30d6\u30e9\u30a6\u30b6\u3067\u8a31\u53ef\u3059\u308c\u3070\u4f7f\u3048\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\uff0e<\/p>\n
\"20171216_19:12:40-24220\"\/<\/a><\/p>\n
\u4ee5\u4e0b\u306e1\u3064\u76ee\u306f\u65b0\u898f\u306b\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092tosheet-test\u3068\u3044\u3046\u540d\u524d\u3067\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u4f5c\u308a\u3064\u3064unix time\u3068cpu\u306e\u6e29\u5ea6\u3092\u6295\u3052\u3066\u3044\u307e\u3059\uff0e
\n2\u3064\u76ee,3\u3064\u76ee\u306f1\u3064\u76ee\u3067\u4f5c\u3063\u305f\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306bunix time\u3068cpu\u306e\u6e29\u5ea6\u3092\u6295\u3052\u3066\u3044\u307e\u3059\uff0e<\/p>\n
\n
<\/span>$ echo<\/span> -n `<\/span>date +%s`<\/span>,`<\/span>acpi -t|<\/span>awk '{print $4}'<\/span>|<\/span>tr -s '\\n'<\/span> ','<\/span>`<\/span>|<\/span>tosheets -c a1 --new-sheet=<\/span>'tosheet-test'<\/span> -d ','<\/span>\r\n1dEv7l3FkxEM-NKlmPTdtfKq4aaemtdyHc1mlbAUOq3s\r\n$ echo<\/span> -n `<\/span>date +%s`<\/span>,`<\/span>acpi -t|<\/span>awk '{print $4}'<\/span>|<\/span>tr -s '\\n'<\/span> ','<\/span>`<\/span>|<\/span>tosheets -c a1 --spreadsheet=<\/span>1dEv7l3FkxEM-NKlmPTdtfKq4aaemtdyHc1mlbAUOq3s -d ','<\/span>\r\n$ echo<\/span> -n `<\/span>date +%s`<\/span>,`<\/span>acpi -t|<\/span>awk '{print $4}'<\/span>|<\/span>tr -s '\\n'<\/span> ','<\/span>`<\/span>|<\/span>tosheets -c a1 --spreadsheet=<\/span>1dEv7l3FkxEM-NKlmPTdtfKq4aaemtdyHc1mlbAUOq3s -d ','<\/span>\r\n<\/pre>\n<\/div>\n
\u3061\u306a\u307f\u306b\u3053\u3046\u3044\u3046\u611f\u3058\u306e\u51fa\u529b\u304c\uff0c<\/p>\n
\n
<\/span>$ echo<\/span> -n `<\/span>date +%s`<\/span>,`<\/span>acpi -t|<\/span>awk '{print $4}'<\/span>|<\/span>tr -s '\\n'<\/span> ','<\/span>`<\/span>\r\n1513421821<\/span>,48.0,47.0,\r\n<\/pre>\n<\/div>\n
\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u898b\u308b\u3068\u3053\u3046\u3044\u3046\u3075\u3046\u306b\u8a18\u9332\u3055\u308c\u3066\u3044\u307e\u3059\uff0e<\/p>\n
\"20171216_20:12:07-28689\"\/<\/a><\/p>\n
\u65e2\u5b58\u306e\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u4f7f\u3046\u5834\u5408\u306f\u305d\u306e\u30b7\u30fc\u30c8\u306eURL\u304b\u3089\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8ID\u3092\u8abf\u3079\u3066 spreadsheet<\/code> option\u3067\u6307\u5b9a\u3057\u307e\u3059\uff0e\u4ee5\u4e0b\u306e\u4f8b\u3067\u306f 1y4qtUWqh6gSCUnEWkTcJX7y1k_1U0ph5ubdrxyUTXa4<\/code> \u304c\u305d\u308c\u3067\u3059\uff0e<\/p>\n
\n
https:\/\/docs.google.com\/spreadsheets\/d\/1y4qtUWqh6gSCUnEWkTcJX7y1k_1U0ph5ubdrxyUTXa4\/edit<\/p>\n<\/blockquote>\n
\u304a\u624b\u8efd\u306b\u4f7f\u3048\u3066\u3044\u3044\u3067\u3059\u306d\uff0eRaspberry Pi\u7b49\u306eSBC\u306a\u3093\u304b\u304b\u3089\u30bb\u30f3\u30b5\u306e\u5024\u3092\u6295\u3052\u308b\u3068\u304b\u306eM2M\u7684\u306a\u4f7f\u3044\u65b9\u306b\u3082\u826f\u3055\u305d\u3046\u3067\u3059\uff0e
\nPython3\u88fd\u3067MIT License\u3067\u3059\uff0e<\/p>\n