Xa Cov Ntaub Ntawv ntawm Wireless Kub thiab Vaum Sensor mus rau Excel: 34 Cov Kauj Ruam

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

Peb tab tom siv NCD Qhov Kub thiab Vaum qhov ntsuas, tab sis cov kauj ruam nyob sib npaug rau ib qho ntawm cov khoom ncd, yog li yog tias koj muaj lwm lub ncd wireless sensors, muaj kev paub los soj ntsuam ib sab ntxiv. Los ntawm kev nres ntawm cov ntawv no, koj yuav tsum muaj kev nkag siab ruaj khov ntawm yuav teeb tsa lub ntsuas pa li cas, teeb tsa lub ntsej muag liab, thiab pom cov ntaub ntawv ntawm lub dashboard zoo li ib qho duab nyob ntawm no.

Kauj ruam 1: Kho vajtse thiab Software xav tau:

Kho vajtse:

• 1. NCD Long Range Kub thiab Vaum Sensor
• 2. NCD Long Range Wireless Mesh Modem nrog USB Interface

Software:

Node-Liab

Kauj Ruam 2: Teeb Node-liab

Tam sim no koj muaj cov ntsuas ntsuas ua haujlwm, peb xav tau txoj hauv kev los ua qee yam muaj txiaj ntsig nrog cov ntaub ntawv ntawd.

• Ua ntej tshaj plaws, koj yuav tsum teeb tsa Node-Red.
• Thaum ua tiav qhov no, koj yuav tsum nkag mus rau koj kab lus hais kom ua, lossis Lub Hwj Chim Lub Hwj Chim rau Windows cov neeg siv, taug kev mus rau cov npe Node-RED tau teeb tsa.
• Tam sim no ntaus "npm i ncd-red-wireless node-red-dashboard". Qhov no yuav teeb tsa cov node xav tau kom tau txais cov ntaub ntawv los ntawm koj lub wireless sensors thiab koj tuaj yeem pib Node-RED thaum qhov no ua tiav.
• Txhawm rau pib node server sau node-liab hauv qhov hais kom ua lossis davhlau ya nyob twg thiab nias nkag mus.

Kauj Ruam 3: Cov Kauj Ruam los Tsim Cov Dej

Txog ntawm qhov no koj yuav pom qhov khoob loj nrog cov npe ntev ntawm cov nodes nyob rau sab laug, sab tes no hu ua palette.

Kauj Ruam 4: Mus Ua Ntej thiab Luag Lub Wireless Gateway Node Tshaj rau Koj Cov Canvas Flow kom Pib

ncd-liab-wireless Muab cov nodes uas tswj kev sib txuas, txheeb xyuas cov ntaub ntawv khoom xa tuaj, lim nws los ntawm qhov tshwj xeeb, thiab tso cai rau koj teeb tsa lub wireless sensors.

Kauj Ruam 5: Nrhiav Koj Li Wireless Sensors:

Thaum koj tau xa cov node koj yuav tuaj yeem pom cov ntaub ntawv tab, uas muaj cov ntaub ntawv hais txog ntawm lub peev xwm muaj peev xwm, lub tab no tau muaj neeg nyob zoo rau qhov siab tshaj plaws ntawm cov pob liab thiab muaj cov txheeb cais muaj txiaj ntsig, feem ntau koj yuav tam sim no tsis xav tau txhawm rau saib lwm cov ntaub ntawv sab nraum ntawm cov ntaub ntawv tab, yog li tuav nws hauv kev xav txawm tias koj tab tom tsim koj cov dej ntws thaum koj muaj lus nug kwv yees li cas ntawm cov node ua haujlwm. Lub ntsiab lus tom ntej peb xav ua yog teeb tsa lub node, thaum koj thawj zaug ntxiv nws koj yuav nco ntsoov tias muaj daim duab peb sab me me nyob rau ntawm kaum sab xis saum toj ntawm lub cim xiav, daim duab peb sab qhia tias lub hauv paus xav tau kev teeb tsa ntxiv, xiav dot qhia tias lub node tsis muaj lawm tab sis tau muab tso ua ib feem ntawm qhov ntws.

• Nyem ob npaug rau ntawm qhov kom qhib qhov kev xaiv teeb tsa.
• Nyem rau ntawm tus xaum cim nyob ib sab ntawm Serial Device teb txhawm rau teeb tsa koj lub USB router, qhov no yuav qhib lub rooj teeb tsa thib ob uas tsuas muaj qee qhov kev xaiv.

Kauj Ruam 6: Nyem rau ntawm lub iav tsom iav tom ntej mus rau Serial Port Field thiab Xaiv Chaw Nres Nkoj uas Sib Raug Zoo Nrog Koj Lub Router, Tom qab ntawd nyem rau "Ntxiv" Khawm rau saum

Kauj Ruam 7: Cov Khoom Siv Hauv Nroog Tam Sim No Yuav Poob Raws Li Qhov Kev Xaiv, thiab Koj tuaj yeem Nyem "Ua tiav", Tam sim no koj muaj kev nkag ncaj qha rau koj lub Wireless Sensors! los Saib Cov Ntaub Ntawv Los Hauv

Kauj Ruam 8: Tam sim no rov qab mus rau koj lub Palette thiab ntaus "debug" rau hauv Chaw Tshawb Nrhiav nyob rau sab saum toj, Lob Ib qho ntawm Cov Nodes no thiab Luag Nws mus rau sab xis ntawm Koj Lub Rooj vag Wireless

Kauj Ruam 9: Ob Nyem Nyem Rau Nws thiab Hloov "msg." kom "ua tiav Msg Object" Nyem Ua tiav

Kauj Ruam 10: Tam sim no Kos Kab Kab Ntawm Ob Lub Nodes, thiab Nyem "Deploy" nyob rau sab saum toj sab xis ntawm lub qhov rais

Kauj Ruam 11: Ua Haujlwm Nrog Cov Ntaub Ntawv:

Tam sim no tawm ntawm koj cov wireless cov ntaub ntawv tau sib sau thiab nws tau tso tawm rau "debug" tab, qhov no "debug tab" tau muab tso rau hauv sab xis sab tom qab cov ntaub ntawv tab. Txhawm rau pom cov ntaub ntawv muaj nyob rau ntaus lub khawm pib dua. Hauv cov ntaub ntawv-liab cov ntaub ntawv tau dhau ntawm cov nodes hauv pob json. Thaum cov khoom msg tuaj rau hauv qhov debug tab koj tuaj yeem ua rau nws loj dua los saib cov npe tag nrho cov ntaub ntawv uas los nrog nws. Qhov no muaj txiaj ntsig tshwj xeeb hauv qhov xwm txheej koj yuav tsum tau pom sai sai uas cov sensors tau tshuaj xyuas hauv. ntawm lub node thiab cov cuab yeej yuav hloov mus rau lub network teeb tsa, ntaus nws ib zaug ntxiv kom rov qab mus rau hom mloog. Thaum peb tau txais cov cuab yeej wi-fi ntawm cov teeb tsa, lawv yuav raug teeb tsa ib txwm teeb tsa lub teeb tsa thaum nws nkag mus rau hauv kev teeb tsa hom, yog li nws ib txwm muaj los tswj xyuas cov rooj vag ntawm no tam sim no ntawm qhov nrawm rau teeb tsa lub cuab yeej.

Kauj Ruam 12: Ntxiv Cov Wireless Sensors:

peb yuav tsum tau cais cov ntaub ntawv tsis siv lub tshuab hluav taws xob hauv tsev kom peb muaj peev xwm tso tawm nws, peb tuaj yeem siv qhov hloov pauv los cais tawm cov lus los ntawm lub qhov rooj raws li tag nrho ntawm mac chaw nyob nrog lossis hom sensor, tab sis raws li kuv hais txog, wireless nodes tiag tiag suav nrog kev ua haujlwm ntxiv rau teeb tsa cov cim, yog li peb yuav pib nrog lawv los muab koj cov duab ntxiv ntawm qhov uas cov qauv no tuaj yeem ua haujlwm li cas. Yog tias koj tseem tsis tau pom cov pob ntawv los ntawm ob qho ntawm koj lub ntsuas, hla ua ntej thiab ntaus lub pob pib dua ntawm qhov tsuas yog tsis tau pib. Thaum lub ntsuas ntsuas ntsuas los ntawm ib qho txheej txheem teeb tsa ntawm lub cuab yeej, qhov chaw nyob mac thiab hom kev ntsuas tau kaw rau hauv pas dej ua ke yog li peb tuaj yeem pom sai sai rau lub sijhawm ntawm cov kauj ruam tom ntej no.

Lob Wireless Node los ntawm lub palette thiab rub nws mus rau qhov ntws, ob npaug nias rau nws kom nws teeb tsa

Kauj Ruam 13: Xaiv Cov Khoom Siv Los Ntawm Qhov Tso Tawm Uas Koj Siv Rau Wireless Gateway, Tam sim no Nyem rau lub iav tsom iav tom ntej mus rau "Mac Chaw Nyob" thiab Xaiv Ib qho ntawm Cov Kev Xaiv Muaj

Kauj ruam 14: Nyem Ua tiav

Koj yuav pom qhov no cia li teeb tsa lub hom sensor rau koj, koj tseem tuaj yeem muab nws lub npe los ua kom yooj yim txheeb xyuas. Raws li tau sau tseg hauv cov ntaub ntawv tab, Serial Device for Config field yog nyob ntawm yeem, thiab peb yuav tsis txhawj txog nws tam sim no. Lub node koj nyuam qhuav ntxiv ua haujlwm tau zoo raws li lub lim ntawm cov ntaub ntawv sensor nkag, tsuas yog hla cov ntaub ntawv rau mac chaw nyob, lossis hom sensor yog tias tsis muaj mac chaw nyob.

Kauj Ruam 15: Tam sim no rov qab mus rau koj lub Palette thiab ntaus "debug" rau hauv Chaw Tshawb Nrhiav nyob rau sab saum toj, Lob Ib qho ntawm Cov Nodes no thiab Luag Nws mus rau sab xis ntawm Koj Lub Rooj vag Wireless

Kauj ruam 16: Nyem ob npaug rau nws thiab Nyem Ua Li Cas

Kauj Ruam 17: Ntxiv Txoj Haujlwm Nodes

Txoj haujlwm ua haujlwm tau siv los khiav JavaScript code tiv thaiv cov khoom msg. Lub luag haujlwm ua haujlwm lees txais cov khoom msg raws li kev nkag thiab tuaj yeem xa rov qab 0 lossis ntau dua cov khoom lus raws li tso tawm. Cov lus xa xov no yuav tsum muaj cov peev txheej them (msg.payload) thiab feem ntau muaj lwm yam khoom nyob ntawm qhov ua raws.

Tam sim no lob tus "ua haujlwm" ntawm lub palette, thiab tso nws mus rau sab xis ntawm Temp/Hum node

Kauj Ruam 18: Ob Nyem Nyem rau ntawm Node txhawm rau kho qhov Function Node

Ntawm no koj yuav tsum sau me ntsis javascript code los tsim qhov xwm txheej, yog li qhov ntsuas kub thiab av noo yuav raug sau hauv excel.

Kauj Ruam 19: Tam sim no Lob CSV Node Los Ntawm Cov Palette thiab Muab Nws Rau Sab xis ntawm Txoj Haujlwm Ntawm Txoj Haujlwm, Nws Yuav Hloov Tus Qauv CSV Hom Ie Cov Cim-cais cov txiaj ntsig

Kauj Ruam 20: Tam sim no Ob Nyem Nyem Rau Nws thiab Ntaus Cov Npe Npe Sib cais los ntawm Comma thiab Cov Lus Qhia Raws Li "Cov Lus Rau Ib Leeg" Raws li qhia hauv daim duab hauv qab no

Kauj Ruam 21: Tam sim no rov qab mus rau koj lub Palette thiab ntaus “ntawv” rau hauv Chaw Tshawb Nrhiav nyob rau sab saum toj, Lob tus uas Qhia “Sau Msg.payload” Txhawm rau khaws qhov muaj nqis thiab tso nws mus rau CSV Node. Koj kuj tseem tuaj yeem txuas qhov Debug Node txhawm rau Txheeb Xyuas Cov Ntaub Ntawv Node

Kauj Ruam 22: Ob Nyem Nyem Rau Nws txhawm rau Kho Cov Ntaub Ntawv Node, Sau Lub Npe Cov Ntaub Ntawv Qhov Chaw Koj Xav Khaws Qhov Muaj Nqes Raws Li Qhia hauv Daim Duab

Kauj Ruam 23: Tam sim no Txuas Tag Nrho Cov Hluav Taws Xob thiab Nyem rau ntawm Khw Khw

Kauj Ruam 24: NTUJ

Tam sim no koj tuaj yeem tshawb xyuas qhov ua tau zoo.

Kauj ruam 25: Node_red_flow

Kauj Ruam 26: Tsis tas li, Muaj Lwm Txoj Hauv Kev Xa Cov Ntaub Ntawv rau Excel los ntawm Kev Siv "JSON" Node thiab "excel" Node

• Ua ntej tshaj plaws, kaw lub davhlau ya nyob twg lossis hais kom sai yog tias koj tau ua nrog cov txheej txheem saum toj no.
• Tom qab ntawd koj yuav tsum nruab excel node kom khaws cov ntaub ntawv.
• Yog li koj yuav tsum nkag mus rau koj kab lus hais kom ua, lossis Lub Hwj Chim Plhaub rau Windows cov neeg siv, mus rau phau ntawv teev npe Node-RED tau teeb tsa hauv.
• Tam sim no ntaus "npm nruab ntawm-red-contrib-excel". Qhov no yuav teeb tsa "zoo" ntawm qhov yuav tsum tau khaws cov ntaub ntawv los ntawm koj lub wireless sensors thiab koj tuaj yeem pib Node-RED thaum qhov no ua tiav.
• Txhawm rau pib node server sau node-liab hauv qhov hais kom ua lossis davhlau ya nyob twg thiab nias nkag mus.
• Tam sim no qhib qhov browser thiab mus rau https:// localhost: 1880 kom qhib tus tsim kev ntws.

Kauj Ruam 27: Cov Kauj Ruam Zoo Ib Yam Li Ntxiv Ntxiv Wireless Sensor

• Txhawm rau tsim cov dej ib yam li tau hais los saum no txhawm rau ntxiv lub wireless sensor.
• Tom qab ntawd lob JSON ntawm lub palette thiab muab nws tso rau qhov Kub/Vaum Node.

Kauj Ruam 28: Ob Nyem Nyem Rau Nws Kho JSON Node, Kho Kom Zoo Li Pom Hauv Daim Duab Hauv Qab no thiab Nyem Ua Li Cas

Kauj Ruam 29: Tam sim no Lob tus "excel" Node uas koj tau teeb tsa los ntawm Palette thiab muab tso rau sab xis ntawm "JSON" Node

Kauj Ruam 30: Ob Nyem Nyem Rau Nws txhawm rau Sau Cov Ntaub Ntawv Lub Npe Koj Xav Khaws Cov Temp/hum Cov Ntaub Ntawv thiab Nyem Ua Li Cas

Kauj Ruam 31: Tam sim no Txuas Tag Nrho Cov Hluav Taws Xob

Kauj Ruam 32: Ntaus Tus Khawm Deploy

Kauj Ruam 33: NTUJ

Tab sis qhov txwv nrog node zoo yog tias nws sau cov ntaub ntawv hauv ib kab nkaus xwb.