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 <misko0...@gmail.com> 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 <calo....@gmail.com> 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 steep...@gmail.com
>>>>>> wrote:
>>>>>>
>>>>>>> Michal,
>>>>>>> I have emailed you directly.
>>>>>>> Ian
>>>>>>>
>>>>>>> On Friday, November 20, 2020 at 3:10:23 AM UTC misk...@gmail.com
>>>>>>> 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 <steep...@gmail.com>
>>>>>>>> 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, misk...@gmail.com <misk...@gmail.com>
>>>>>>>>> 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ľ: steep...@gmail.com
>>>>>>>>>>
>>>>>>>>>>> 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, misk...@gmail.com <
>>>>>>>>>>> misk...@gmail.com> 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 weewx-user+...@googlegroups.com.
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> 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 weewx-user+...@googlegroups.com.
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> 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 weewx-user+...@googlegroups.com.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> 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
>>>>> weewx-user+...@googlegroups.com.
>>>>>
>>>>
>>>>>
>>>>> 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 weewx-user+unsubscr...@googlegroups.com.
>
>
> 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 weewx-user+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/weewx-user/CADASSaQQgmmFxrSyjUD7jyUfKznK4S6exkPndBPOiGSgaXVjLw%40mail.gmail.com.
