Nest Thermostat History Logger Logger: 6 Cov Kauj Ruam (nrog Duab)

2024 Tus sau: John Day | [email protected]. Kawg hloov kho: 2024-01-30 09:27

Zes thermostat ntsuas kub, av noo thiab cua sov/AC siv thiab cov neeg siv tuaj yeem pom cov ntaub ntawv keeb kwm tsuas yog 10 hnub. Kuv xav sau cov ntaub ntawv keeb kwm (> 10 hnub) thiab hla hla google spreadheets tsab ntawv uas pings zes txhua lub sijhawm thiab tseem tau txais cov ntaub ntawv huab cua hauv zos los ntawm openweathermap.org thiab khaws hauv daim ntawv nthuav tawm.

Txhua yam tau mus zoo rau ib xyoos, thiab tsab ntawv ceeb toom tam sim nres sau cov ntaub ntawv. Tom qab qee qhov tshawb fawb hauv google, Kuv pom tau tias ib kab txhua 5 feeb rau google spreadhseet txhais tau tias tsoo qhov siab tshaj plaws ntawm cov xov tooj hauv google daim ntawv nthuav qhia tuaj yeem nyob tau. Kuv hloov kho tsab ntawv tseem tseem ping zes txhua 5 feeb, thiab tab sis khaws cov ntaub ntawv hauv 1 kab ib hnub. Tsab ntawv txheeb xyuas kab kawg thiab yog tias nws yog tib hnub, tom qab ntawv nws txuas cov ntaub ntawv mus rau tib kab tsis yog ntxiv kab tshiab.

Credit rau thawj tsab ntawv. Kuv tsuas yog kho qee qhov kho kom haum rau kuv cov kev xav tau.

// michael-pesce txoj haujlwm: https://gist.github.com/michael-pesce/a4ba55d4fc4…// BEEZLY txoj haujlwm:

Cov ntsiab lus tseem ceeb: Zais Thermostat Keeb Kwm, Zes Tshav Kub, Zes Kub Kub Keeb Kwm, Zes Thermostat Hack, Zaum Thermostat Cov Lus Qhia, Zes Lub Zog Keeb Kwm, Zes Siv Txhua Hnub, Zes Siv Txhua Hnub, Rub cov ntaub ntawv zes ntsuas cua sov

Kauj Ruam 1: Tsim Google Daim Ntawv Tshiab (Ua Txuag Raws Li Kuv Cov Ntawv Sib Koom)

Pib nrog kuv daim ntawv sib koom google txuas hauv qab no (Qhib cov ntawv ntawd thiab nyem Cov Ntaub Ntawv thiab tom qab ntawd "ua daim ntawv" thiab khaws hauv koj li google drive).

P. S: Tsis txhob nug kuv kom tso cai rau koj kho cov ntawv no. Ua ntej koj hloov pauv, uas koj yuav tsis tuaj yeem ua vim kuv tau qhia qhov no raws li nyeem nkaus xwb daim ntawv teev npe, ua "luam theej tawm" hauv koj tus kheej google drive thiab tom qab ntawd ua qhov hloov kho.

docs.google.com/spreadsheets/d/1zTHUfiltWomhPYmfD3TYRRoJZsgcjrQ_A2xHSTK5_dE/edit?usp=sharing

Rau cov tib neeg uas muaj teeb meem nrog kev tso cai: Sim cov ntawv hauv cov ntawv hauv qab no. Nws muaj kev ua haujlwm ntxiv ntsig txog Nest qhov kev tso cai 2.0 tshiab. Kuv tsis tau sim nws, yog li yog tias koj hla cov lus nug lossis teeb meem, thov tshaj tawm hauv nqe lus pom zoo. Ua tsaug rau mcr2582.

www.dropbox.com/s/8rbtg7pb0xl9n9x/nest%20t…

Lwm qhov kev hloov pauv ntawm tsab ntawv los ntawm Coder56: cov ntsiab lus ntxiv hauv kab lus. Kuv tsis tau sim nws, tab sis tsab ntawv tau teeb tsa zoo heev thiab nws zoo li ua haujlwm tau zoo rau ntau tus neeg siv.

docs.google.com/spreadsheets/d/15bTn9_Cv9I…

Kauj ruam 2: Luam Tsab Ntawv

Hla cov kauj ruam no yog tias koj tau khaws daim ntawv theej ntawm kuv daim ntawv sib koom google.

• Ntawm cov ntawv qhia zaub mov bar nyem Cov Cuab Yeej -> Tsab Ntawv Editor… qhib Script Editor (lub qhov rai tshiab)
• Hauv Tsab Ntawv Editor tshem tawm tag nrho cov ntawv sau/ntawv tsis raug, thiab tsim qhov tshiab (Kuv hu nws "NestScript.gs")
• Txiav thiab muab cov ntawv no tag nrho los ntawm cov ntawv txuas rau hauv NestScript.gs, tom qab ntawd SAVE THE SCRIPT (Rau cov kauj ruam no, thov siv tsab ntawv los ntawm daim ntawv google uas kuv tau qhia hauv kauj ruam 1. Yog tias koj tau khaws daim ntawv theej ntawm cov ntawv ntawd, koj Yog tias koj tsis tuaj yeem qhib cov ntawv ntawd thiab mus rau kab ntawv thiab luam cov ntawv yav dhau los..).

Kauj Ruam 3: Tso Tawm Raws Li Web App

• Ntawm cov ntawv qhia zaub mov bar nyem Cov Cuab Yeej -> Tsab Ntawv Editor… qhib Script Editor (lub qhov rai tshiab)
• Ntawm cov ntawv qhia zaub mov bar nyem Publish -> Deploy as Web App
• Xaiv "Ua lub app raws li kuv"
• Xaiv leej twg nkag tau rau lub app: "Txhua tus, txawm tias tsis qhia npe"

• Luam/sau tseg ntawm qhov txuas rau koj lub vev xaib tshiab rau tam sim no, thiab nws yuav raug ntxiv rau runDataCollection cov txheej txheem hauv qab no (thawj tus lej) hauv cov kauj ruam tom ntej.

Kauj ruam 4: Triggers

Nov yog qhov uas koj txheeb xyuas ntau npaum li cas los khaws cov ntaub ntawv.

• Ntawm cov ntawv qhia zaub mov nyem Tam Sim No Qhov Project's Triggers
• Nyem ntxiv txhais tshiab
• Rau Khiav xaiv qhov ua haujlwm runDataCollection, Txheej xwm: lub sijhawm tsav, thiab xaiv qhov seem raws li qhov koj nyiam (Kuv ua txhua 5 feeb)

Kauj Ruam 5: Cov Lus Qhia Ntxiv hauv Tsab Ntawv

Cia peb hloov tsab ntawv mus rau koj lub ntsuas cua sov tshwj xeeb, lub nroog thiab daim ntawv google.

Txhua qhov kev hloov pauv tau teev tseg nrog kab lej ntawm tsab ntawv. Koj yuav tsum mus rau kab ntawd hauv kab ntawv thiab hloov kho raws li qhia hauv qab no. (Kab lej yuav tsum raug yog kab 40 yog "runDataCollection () …").

• Kab 45: ntxiv webapp txuas hauv runDataCollection routing (Nov yog qhov koj tau sau tseg hauv ib qho ntawm cov kauj ruam dhau los)
• Kab 53: Zes username thiab password
• Kab 77: Tus ntsuas cua sov ID

Koj tuaj yeem tau txais tus lej rau txhua lub ntsuas cua sov los ntawm kev mus rau Nest dashboard, nyem rau ntawm Thermostat, nyem lub iav icon nyob rau sab saum toj sab xis ces theej "Qhov Tsis Yog." "Teb. Nws yuav zoo li: 02XX01XX471XXX3S

Kab 90: Nroog ID (cov lus qhia ntxiv hauv tsab ntawv saum toj kab no yuav pab tau.)

Txhawm rau nrhiav lub nroog ID mus rau "https://openweathermap.org/find?q=" tshawb rau koj lub nroog, nyem rau ntawm lub nroog txuas thiab tus ID yuav yog tus lej 7 tus lej hauv URL

Kab 103: Google daim ID (cov lus qhia ntxiv hauv tsab ntawv saum kab no yuav pab tau.)

Daim Ntawv ID tuaj yeem rub los ntawm shee URL Saib cov qauv no qhov twg Daim Ntawv ID nyob hauv URL:

Kauj Ruam 6: Ua kom tiav daim Spreadsheet

Hla cov kauj ruam no yog tias koj pib nrog kuv daim ntawv nthuav qhia sib qhia.

Ob txoj kab no yuav tsum muaj nyob rau hauv daim ntawv nthuav qhia kom cov cai ua haujlwm.

Thawj kab (Header kab): Qhov chaw sib cais txhua kab

Hnub/Sij Hawm Hli Hnub Xyoo Temp Vaum Sab Nraud Sab Nraum Sab Nrauv Kub_Usage AC_Usage Huab Cua AutoAway

Kab thib ob:

Ntxiv nag hmo hnub nyob hauv thawj kab ntawv thiab zeros hauv kab uas seem.

Qhov ntawd yog nws. Cia tsab ntawv sau thiab nws yuav tsum ntxiv ib kab hauv ib hnub thiab pinging koj lub ntsuas cua sov thiab huab cua hauv zos rau cov ntaub ntawv raws li qhov tshwm sim zaus koj tau teeb tsa.

Yog tias koj rov tsim dua lub webapp, siv qhov kev hloov kho tshiab. Kuv muaj teeb meem siv tib qhov kev hloov kho nrog tsab ntawv tsis ua haujlwm

Yog tias tsab ntawv tsis ua haujlwm, hla cov kauj ruam dhau los dua thiab xyuas kom koj tau hloov kho tsab ntawv raws li tau hais los ntawm cov theem no kom raug. Qhov no feem ntau yuav ua rau qhov teeb meem nrog tsab ntawv tsis ua haujlwm

Paub Cov Teeb Meem (Yog tias ib tus neeg paub kho, thov teb hauv nqe lus pom):

1) Tsab ntawv tsis tau txais cov ntaub ntawv los ntawm zes txhua hnub. Kuv muaj kuv qhov ntsuas txhua 5 feeb, uas yuav tsum ua tiav tag nrho 288 nyeem thoob plaws ib hnub. Kuv tau ~ 170. Qhov qis tshaj kuv tau txais yog 16 thiab siab tshaj yog 264.