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.
