Yes I see. So you are using a separate database if I understand correctly? If you use the WeeWX extended database you only need the PM sensor data. I will share my method in more detail later today. Ian
On Mon, 30 Nov 2020 at 07:59, Calo Geyer <[email protected]> wrote: > See, Ian, if we managed to use this file, we got PPM10, PPM2.5, > Temperature, Humitidy and Wlan. > > On Monday, November 30, 2020 at 8:58:06 AM UTC+1 Calo Geyer wrote: > >> [image: Screenshot_20201130-085211.jpg] >> >> On Monday, November 30, 2020 at 8:53:16 AM UTC+1 Calo Geyer wrote: >> >>> Hi, I also worked according this link >>> https://tech.hamm7.de/blogs/feinstaub/feinstaubphp >>> and managed to get the log file recording. I also created the >>> feinstaub.db (using myphpadmin) which I fed by the php script (from the >>> feinstaub.log) however my issue to solve was the connection of script to >>> database (connectdb.php). I think I can solve soon and then we would have >>> all directly in the database. >>> But is good to hear that you explore the other way to get it work as >>> well. Do you mind sharing details how to create the data file? >>> I will share how my log now looks like in a second as I need to pick >>> from home network. >>> On Monday, November 30, 2020 at 8:43:49 AM UTC+1 [email protected] >>> wrote: >>> >>>> I have worked out a method but the json data file that you have is more >>>> complicated than the one I have from my process. The only data you need to >>>> extract are the pm2.5 and pm10.0 figures. It is difficult to see which is >>>> which in your file. My method uses a piece of php code to parse the json >>>> data file and insert the data into a txt file in the format that filepile >>>> requires. You must also be using the new extended WeeWX database which has >>>> additional fields for air quality. >>>> Ian >>>> >>>> On Mon, 30 Nov 2020 at 06:15, miso k <[email protected]> wrote: >>>> >>>>> Hi, >>>>> I have successfully added inner Humidity fields and graphs to my >>>>> webpage as a training (values are already measured). So only step is to >>>>> fill the data from AirQual sensor to database. >>>>> Did you find a way to do it? >>>>> >>>>> Michal >>>>> >>>>> Dátum: piatok 27. novembra 2020, čas: 21:56:07 UTC+1, odosielateľ: >>>>> miso k >>>>> >>>>>> Hi again, >>>>>> so I tried to do it your way, it works now. >>>>>> the feinstaub.log looks like this: >>>>>> {"time":1606510522, >>>>>> "datum":"2020-11-27", >>>>>> "zeit":"21:55:22", >>>>>> "ipAddress":"192.168.1.23", >>>>>> "daten":{"esp8266id": "759897", "software_version": "NRZ-2020-131", >>>>>> "sensordatavalues":[{"value_type":"SDS_P1","value":"465.88"},{"value_type":"SDS_P2","value":"66.15"},{"value_type":"BME280_temperature","value":"-0.09"},{"value_type":"BME280_pressure","value":"98677.09"},{"value_type":"BME280_humidity","value":"100.00"},{"value_type":"samples","value":"3565079"},{"value_type":"min_micro","value":"39"},{"value_type":"max_micro","value":"43094"},{"value_type":"interval","value":"145000"},{"value_type":"signal","value":"-62"}]} >>>>>> } >>>>>> >>>>>> now we need to save it to main database weewx.sdb I hope. Let's ask >>>>>> Ian how to do it with filepile. >>>>>> >>>>>> Or let me know, when you will be further with your solutions. >>>>>> >>>>>> Thanks, >>>>>> M >>>>>> >>>>>> Dátum: piatok 27. novembra 2020, čas: 21:29:24 UTC+1, odosielateľ: >>>>>> miso k >>>>>> >>>>>>> so i added the file named data_simple.php with content as in the >>>>>>> example above. Then I have browsed the address >>>>>>> myRPiweewxIPaddress/data_simple.php and i got the answer: >>>>>>> Sensor: ok >>>>>>> ,but this will be also without any imput data from sensor... >>>>>>> No csv is produced. >>>>>>> >>>>>>> rights on data_simple.php are -rw-r--r-- . is it ok? >>>>>>> >>>>>>> >>>>>>> Dátum: piatok 27. novembra 2020, čas: 13:14:25 UTC+1, odosielateľ: >>>>>>> miso k >>>>>>> >>>>>>>> Hello, >>>>>>>> I have this answer from sensor developer: >>>>>>>> >>>>>>>> this feature exists in this firmware. Just look for "Send data to >>>>>>>> custom API". There you can configure a server and a path to a script on >>>>>>>> i.e. a Raspberry PI. If configured the firmware will send a JSON >>>>>>>> object to >>>>>>>> this address. There is a sample script at >>>>>>>> https://github.com/opendata-stuttgart/madavi-api/blob/master/data_simple.php >>>>>>>> that >>>>>>>> will take this object and save the data to a CSV file. >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> Dňa pi 27. 11. 2020, 12:18 Calo Geyer <[email protected]> >>>>>>>> napísal(a): >>>>>>>> >>>>>>>>> And this is what I am going to do this night or later when I got >>>>>>>>> time; changing the script to fill the database directly. >>>>>>>>> >>>>>>>>> https://tech.hamm7.de/blogs/feinstaub/feinstaubphp >>>>>>>>> >>>>>>>>> On Friday, November 27, 2020 at 12:10:01 PM UTC+1 Calo Geyer wrote: >>>>>>>>> >>>>>>>>>> Hi, I now made some php call using the setting "send to own API" >>>>>>>>>> and do get the data into a log file. It basically looks like the json >>>>>>>>>> output when you retrieve via IPaddress/data.json directly from the >>>>>>>>>> sensor. >>>>>>>>>> Requirements are apache (httpd) and php installed. Do not forget >>>>>>>>>> to start httpd (sudo systemctl start httpd on archlinux) >>>>>>>>>> >>>>>>>>>> I initially followed this instruction >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> https://blog.helmutkarger.de/feinstaubsensor-teil-12-sensordaten-selbst-speichern/ >>>>>>>>>> >>>>>>>>>> creating a folder in srv/http/weewx/feinstaub and placed the >>>>>>>>>> SDS011.php there. The SDS011.php contains the code which is shown in >>>>>>>>>> the >>>>>>>>>> thread above. >>>>>>>>>> <?php >>>>>>>>>> $json = file_get_contents("php://input"); >>>>>>>>>> file_put_contents("feinstaub.log", $json); >>>>>>>>>> ?> >>>>>>>>>> I then created an empty feinstaub.log file in that folder too >>>>>>>>>> and make sure you grant write and read access to it (chmod 666 >>>>>>>>>> feinstaub.log). If you then add the server and path including name >>>>>>>>>> of .php >>>>>>>>>> (in my case weewx/SDS011.php) in your sensor configuration then you >>>>>>>>>> should >>>>>>>>>> see the updated data every 145 seconds. >>>>>>>>>> >>>>>>>>>> Since I missed the timestamp etc. I moved to this php script >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> https://www.a-d-k.de/20170226_221904-Feinstaubalarm+oder+wie+gut+ist+die+Luft.htm >>>>>>>>>> >>>>>>>>>> ?php >>>>>>>>>> >>>>>>>>>> $logURL="feinstaub.log"; >>>>>>>>>> >>>>>>>>>> $logToOrdner="feinstaublog/".date('Ymd').".log"; >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> $itime= time();//timestamp Januar 1 1970 00:00:00 GMT >>>>>>>>>> >>>>>>>>>> $datum= date('Y-m-d'); >>>>>>>>>> >>>>>>>>>> $zeit= date('G:i:s'); >>>>>>>>>> >>>>>>>>>> $ipAddress=$_SERVER['REMOTE_ADDR']; >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> $daten = file_get_contents('php://input'); >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> if(isset($daten) && !empty($daten)){//wenn Daten leer, nicht >>>>>>>>>> speichern >>>>>>>>>> >>>>>>>>>> //create oder add; aktuelles Messwert >>>>>>>>>> >>>>>>>>>> $handle=fopen($logURL,'w'); >>>>>>>>>> >>>>>>>>>> fwrite ($handle, "{" ); >>>>>>>>>> >>>>>>>>>> fwrite ($handle, '"time":'.$itime.','.chr(10)); >>>>>>>>>> >>>>>>>>>> fwrite ($handle, '"datum":"'.$datum.'",'.chr(10)); >>>>>>>>>> >>>>>>>>>> fwrite ($handle, '"zeit":"'.$zeit.'",'.chr(10)); >>>>>>>>>> >>>>>>>>>> fwrite ($handle, '"ipAddress":"'.$ipAddress.'",'.chr(10)); >>>>>>>>>> >>>>>>>>>> fwrite ($handle, '"daten":'.$daten.chr(10) ); >>>>>>>>>> >>>>>>>>>> fwrite ($handle, "}".chr(10) ); >>>>>>>>>> >>>>>>>>>> fclose ($handle); >>>>>>>>>> >>>>>>>>>> } >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> if(isset($daten) && !empty($daten)){//wenn Daten leer, nicht >>>>>>>>>> speichern >>>>>>>>>> >>>>>>>>>> //als Datensätze in Ordner, >>>>>>>>>> >>>>>>>>>> $add=file_exists($logToOrdner); >>>>>>>>>> >>>>>>>>>> $handle=fopen($logToOrdner,'a'); >>>>>>>>>> >>>>>>>>>> if($add)fwrite ($handle, "," ); >>>>>>>>>> >>>>>>>>>> fwrite ($handle, "{" ); >>>>>>>>>> >>>>>>>>>> fwrite ($handle, '"time":'.$itime.','); >>>>>>>>>> >>>>>>>>>> fwrite ($handle, '"datum":"'.$datum.'",'); >>>>>>>>>> >>>>>>>>>> fwrite ($handle, '"zeit":"'.$zeit.'",'); >>>>>>>>>> >>>>>>>>>> fwrite ($handle, '"daten":'.$daten ); >>>>>>>>>> >>>>>>>>>> fwrite ($handle, "}".chr(10) ); >>>>>>>>>> >>>>>>>>>> fclose ($handle); >>>>>>>>>> >>>>>>>>>> } >>>>>>>>>> >>>>>>>>>> ?> >>>>>>>>>> >>>>>>>>>> This log is then in a separate folder having the date on it. I >>>>>>>>>> will now continue later on the next steps. >>>>>>>>>> >>>>>>>>>> Regards, >>>>>>>>>> Andreas >>>>>>>>>> On Friday, November 20, 2020 at 9:35:16 AM UTC+1 >>>>>>>>>> [email protected] wrote: >>>>>>>>>> >>>>>>>>>>> Michal, >>>>>>>>>>> I have emailed you directly. >>>>>>>>>>> Ian >>>>>>>>>>> >>>>>>>>>>> On Friday, November 20, 2020 at 3:10:23 AM UTC [email protected] >>>>>>>>>>> wrote: >>>>>>>>>>> >>>>>>>>>>>> Hi Ian, >>>>>>>>>>>> Just a kindly reminder, if you will have little time. >>>>>>>>>>>> >>>>>>>>>>>> I am desperate to provide PM info to my neighbors, which are >>>>>>>>>>>> using wood for heating! >>>>>>>>>>>> >>>>>>>>>>>> Thanks, >>>>>>>>>>>> Michal >>>>>>>>>>>> >>>>>>>>>>>> Dňa ut 17. 11. 2020, 9:11 steeple ian <[email protected]> >>>>>>>>>>>> napísal(a): >>>>>>>>>>>> >>>>>>>>>>>>> Morning, >>>>>>>>>>>>> I am just doing some work on the weather34 skin at the moment. >>>>>>>>>>>>> Give a little time and I will write this up more fully for you. >>>>>>>>>>>>> Ian >>>>>>>>>>>>> >>>>>>>>>>>>> On Tue, 17 Nov 2020 at 07:36, [email protected] < >>>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>>> >>>>>>>>>>>>>> thanks for guiding me! >>>>>>>>>>>>>> >>>>>>>>>>>>>> 1. I am able to install weewx-sds011, but i am not able to >>>>>>>>>>>>>> repeat all your steps. >>>>>>>>>>>>>> 2. how can i rsync data? just throught API in the web >>>>>>>>>>>>>> interface of luftdaten sensor? >>>>>>>>>>>>>> >>>>>>>>>>>>>> 3. how filepile works? it saves data to a plain text >>>>>>>>>>>>>> document? >>>>>>>>>>>>>> filename = /var/tmp/pond.txt >>>>>>>>>>>>>> Or are you able to store it in the new SDB database? >>>>>>>>>>>>>> >>>>>>>>>>>>>> 4. I will be probably able to create .tmpl and integrate it >>>>>>>>>>>>>> to my webpage. Only how the $parameters and formating looks like >>>>>>>>>>>>>> is the >>>>>>>>>>>>>> question >>>>>>>>>>>>>> >>>>>>>>>>>>>> thanks for your help! >>>>>>>>>>>>>> >>>>>>>>>>>>>> btw, my webpage: http://jastrabie.online/weewx/ >>>>>>>>>>>>>> >>>>>>>>>>>>>> Dátum: pondelok 16. novembra 2020, čas: 9:41:36 UTC+1, >>>>>>>>>>>>>> odosielateľ: [email protected] >>>>>>>>>>>>>> >>>>>>>>>>>>>>> Google weewx-sds011. There is an extension for that sensor. >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> In my case I rsync data to my main server and then use >>>>>>>>>>>>>>> weewx-filepile extension to insert data into the new extended >>>>>>>>>>>>>>> database. I >>>>>>>>>>>>>>> then use a custom .tmpl to aggregate the data for a rolling >>>>>>>>>>>>>>> 24hr AQI. >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Ian >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> On Sun, 15 Nov 2020 at 20:46, [email protected] < >>>>>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> Hello, >>>>>>>>>>>>>>>> has anybody integrated the air quality API to WeeWX? >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> It should be probably something easy, as the sensor >>>>>>>>>>>>>>>> firmware has API with custom server, path, port, >>>>>>>>>>>>>>>> username/password to entry. >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> or there is also api for sensor.community service >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> https://sensor.community/ >>>>>>>>>>>>>>>> https://opensensemap.org/ >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> thanks for info, >>>>>>>>>>>>>>>> Michal, SVK >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> -- >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> You received this message because you are subscribed to the >>>>>>>>>>>>>>>> Google Groups "weewx-user" group. >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> To unsubscribe from this group and stop receiving emails >>>>>>>>>>>>>>>> from it, send an email to [email protected]. >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> To view this discussion on the web visit >>>>>>>>>>>>>>>> https://groups.google.com/d/msgid/weewx-user/0171755b-7bd6-49f8-bc18-39261c278466n%40googlegroups.com >>>>>>>>>>>>>>>> <https://groups.google.com/d/msgid/weewx-user/0171755b-7bd6-49f8-bc18-39261c278466n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>>>>>>>>>>> . >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> -- >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> You received this message because you are subscribed to the >>>>>>>>>>>>>> Google Groups "weewx-user" group. >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> To unsubscribe from this group and stop receiving emails from >>>>>>>>>>>>>> it, send an email to [email protected]. >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> To view this discussion on the web visit >>>>>>>>>>>>>> https://groups.google.com/d/msgid/weewx-user/3f5f192a-541f-4918-ab85-1f91c612c429n%40googlegroups.com >>>>>>>>>>>>>> <https://groups.google.com/d/msgid/weewx-user/3f5f192a-541f-4918-ab85-1f91c612c429n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>>>>>>>>> . >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> -- >>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> You received this message because you are subscribed to a >>>>>>>>>>>>> topic in the Google Groups "weewx-user" group. >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> To unsubscribe from this topic, visit >>>>>>>>>>>>> https://groups.google.com/d/topic/weewx-user/UJhz34G5r8s/unsubscribe >>>>>>>>>>>>> . >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> To unsubscribe from this group and all its topics, send an >>>>>>>>>>>>> email to [email protected]. >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> To view this discussion on the web visit >>>>>>>>>>>>> https://groups.google.com/d/msgid/weewx-user/CADASSaTpGmhGVTTVjxdvnufG2AgUmOq7bS2RKYUrOsHuGyknCA%40mail.gmail.com >>>>>>>>>>>>> <https://groups.google.com/d/msgid/weewx-user/CADASSaTpGmhGVTTVjxdvnufG2AgUmOq7bS2RKYUrOsHuGyknCA%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>>>>>>>>>>> . >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> >>>>>>>>> >>>>>>>>> You received this message because you are subscribed to a topic in >>>>>>>>> the Google Groups "weewx-user" group. >>>>>>>>> >>>>>>>>> >>>>>>>>> To unsubscribe from this topic, visit >>>>>>>>> https://groups.google.com/d/topic/weewx-user/UJhz34G5r8s/unsubscribe >>>>>>>>> . >>>>>>>>> >>>>>>>>> >>>>>>>>> To unsubscribe from this group and all its topics, send an email >>>>>>>>> to [email protected]. >>>>>>>>> >>>>>>>> >>>>>>>>> >>>>>>>>> To view this discussion on the web visit >>>>>>>>> https://groups.google.com/d/msgid/weewx-user/a845b1f2-a4f2-46cd-b129-5083c68bb4fen%40googlegroups.com >>>>>>>>> <https://groups.google.com/d/msgid/weewx-user/a845b1f2-a4f2-46cd-b129-5083c68bb4fen%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>>>> . >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> >>>>> >>>>> You received this message because you are subscribed to the Google >>>>> Groups "weewx-user" group. >>>>> >>>>> >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>> an email to [email protected]. >>>>> >>>>> >>>>> To view this discussion on the web visit >>>>> https://groups.google.com/d/msgid/weewx-user/8d351ab5-4a52-4916-bb85-d52f0162c7c0n%40googlegroups.com >>>>> <https://groups.google.com/d/msgid/weewx-user/8d351ab5-4a52-4916-bb85-d52f0162c7c0n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>> . >>>>> >>>>> >>>>> -- > You received this message because you are subscribed to the Google Groups > "weewx-user" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/077df435-bdd0-42aa-8051-40868fb4e721n%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/077df435-bdd0-42aa-8051-40868fb4e721n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CADASSaSGBw2vaBNNqy9Q7Axcih_wEeXmmQA9-12tevucXK4KFA%40mail.gmail.com.
