newbie question - indoor temperature

[Frédéric Clavert]

Dear all,

I bought a WMRS 200 a year ago. As I did not want to install Windows, I used your software to manage my weather station - and I'm happy with that, even if sometimes the rendering on localhost:7680 seems to have some problems (the data is stored, but localhost:7680 seems not to be reachable).

My problem today is the following one: I would like to store internal temperature, which are displayed but not stored in the .csv file.

If I understood clearly, I must first do a sudo wfrog --customize, then switch to a database storage and then activate the storage for indoor temperature? Is that right? There is no way to keep simply the .csv file?

A second question: if my first question is right, what can I do with the .csv file after switching to a database storage? Can I import the data it contains to the database easily?

Thank you for this software.
You can see my weather station on-line at http://inactinique.dyndns.org:7680 if you wish.

Best regards,
Frédéric

[Jordi Puigsegur Figueras]

Hi Frédéric,

My problem today is the following one: I would like to store internal temperature, which are displayed but not stored in the .csv file.

If I understood clearly, I must first do a sudo wfrog --customize, then switch to a database storage and then activate the storage for indoor temperature? Is that right? There is no way to keep simply the .csv file?

CSV files do not support multiple sensors. As you already understood, it is necessary to switch to database storage (mysql and firebird are the supported databases). 

I believe you do not need to run wfrog --customize. Basically you need to change /etc/wfrog/wfcommon/config/storage.yaml. Also remember to create the database with the right fields.

 

A second question: if my first question is right, what can I do with the .csv file after switching to a database storage? Can I import the data it contains to the database easily?

Yes, there is a script to perform this task:

wfcommon/storagecopy.py  (config file: wfcommon/config/storagecopy.yaml)

You can run the script at any moment, even after some time of running wfrog with a database storage. Just do a backup before to be on the safe side.

 

You can see my weather station on-line at http://inactinique.dyndns.org:7680 if you wish.

Would you like your station to be added to the Online Stations page at wfrog's web site (http://code.google.com/p/wfrog/wiki/SeeItInAction)?  If so, please send your location.

sometimes the rendering on localhost:7680 seems to have some problems (the data is stored, but localhost:7680 seems not to be reachable).

If you experience any type of problem, please review the /var/log/wfrender.log log file and check for errors. You can always post an issue with the errors.

Best regards,

Jordi.

[Frédéric Clavert]

Dear Jordi,

thanks for your answers. Two things are not clear right now.

 

I believe you do not need to run wfrog --customize. Basically you need to change /etc/wfrog/wfcommon/config/storage.yaml. Also remember to create the database with the right fields.

How do I know the right fields for the inddor temperature and humidity sensors? How do I name them? (or where do I find the information)

 

Yes, there is a script to perform this task:wfcommon/storagecopy.py  (config file: wfcommon/config/storagecopy.yaml)

I've got some difficulties with this script, but I think that I can handle this.

Best,
Frédéric
 

[Frédéric Clavert]

Just an update: concerning the import of the data stored in the CSV file, I did manually thanks to phpMyAdmin.

I have now a new error: Error 500 when using the 365 days view.

best,
Frédéric

[Jordi Puigsegur Figueras]

Hi Frédéric,

thanks for your answers. Two things are not clear right now.

 

I believe you do not need to run wfrog --customize. Basically you need to change /etc/wfrog/wfcommon/config/storage.yaml. Also remember to create the database with the right fields.

How do I know the right fields for the inddor temperature and humidity sensors? How do I name them? (or where do I find the information) 

1) To record additional values you just need to create the database with the desired fields. Scripts already contain available options (http://code.google.com/p/wfrog/source/browse/#svn%2Ftrunk%2Fdatabase). wfrog reads the available columns and then records the corresponding sensors (if installed)

2) To show these values on the web page you need to:

- modify the template (main.html) 

- modify chart_accumulator.yaml adding the necessary sections to create the necessary accumulators for the new variables. For example:

        tempint: 
            avg: !avg { index: tempint } 
            min: !min { index: tempint } 
            max: !max { index: tempint } 

        temp2: 
            avg: !avg { index: temp2 } 
            min: !min { index: temp2 } 
            max: !max { index: temp2 } 

- modify charts.yaml adding new sections to create the new graphs. For example:

        temp2: !chart 
            interpolate: $interpolate 
            series: 
                temp2.max: 
                    color: wheat 
                    area: { to: temp2.min } 
                    max: { color: darkred, text: darkred, thickness: 0.5 } 
                temp2.avg: 
                    order: 1 
                temp2.min: 
                    color: wheat 
                    min: { color: darkslateblue, text: darkslateblue, 
thickness: 0.5 } 

 

Jordi.