Please read the posts in the Announcements section about the current status of Cumulus development now that I have retired

Please read this post before posting

Latest Cumulus release v1.9.4 (build 1099) - Nov 28 2014
Latest Cumulus MX release - v3.0.0 build 3043 Jan 20 2017. See this post for download

Database

Discussion and questions about Cumulus weather station software version 1. This section and its subforums are the main place to get help with Cumulus. Anything which is not specific to the type of weather station goes in here; for anything specific to a type of weather station, please use the appropriate subforum. Use the 'website development' section for any questions relating to creating or running a web site for Cumulus data. Discussion of the stations themselves in these sections is fine.
courtil
Posts: 96
Joined: Thu Jan 16, 2014 1:31 pm
Weather Station: WH 1080
Operating System: Windows Seven
Location: France
Contact:

Database

Postby courtil » Mon Feb 02, 2015 10:50 am

Hello everyone,

How to make loading the remote database with Cumulus files: File months (January, February ...) and dayfile.txt

I am using the remote site the contents of the database to format pages

Is there a software intended for it ??

Thank you for your information.

Best Regards

Michel said courtil
OS : Windows 10
Station Météo : WH 1080 Photovoltaïque
Cumulus version 3.00 b 3043
Graphweather version 3.0.27
Meteotemplate 16.0 Physalis
http://lecourtilauxepines.eu/indexDesktop.php
http://lecourtilauxepines.pagesperso-orange.fr

mm23
Posts: 152
Joined: Mon Feb 03, 2014 12:22 pm
Weather Station: ws 2350
Operating System: windows xp sp3
Location: Europe

Re: Database

Postby mm23 » Mon Feb 02, 2015 11:52 am

I use "Cumulus toolbox" to send data to the remote server. ..
On remote server there are three files (realtime, dayfile and monthly). For those files I have set up a cron job that, depending on the desired time interval, sends data in three (realtime, dayfile and monthly) tables in the database
Image

courtil
Posts: 96
Joined: Thu Jan 16, 2014 1:31 pm
Weather Station: WH 1080
Operating System: Windows Seven
Location: France
Contact:

Re: Database

Postby courtil » Fri Feb 06, 2015 11:34 am

Hello,

Thank you for your information.

I installed Cumulus Toolbox.

it for backup files: cumulus.ini, dayfile .....

But not load files (realtime, dayfile, monthly) on database ??


Can you explain to me because my skills are weak !!!

Other Question:

I use "Highcharts" to draw my graphs, the script asks for a timestamp
to date the graphs.
what are the realm of possibility for the date field is dd / mm / yy

Thank you for your information

Best Regards

Michel said courtil
OS : Windows 10
Station Météo : WH 1080 Photovoltaïque
Cumulus version 3.00 b 3043
Graphweather version 3.0.27
Meteotemplate 16.0 Physalis
http://lecourtilauxepines.eu/indexDesktop.php
http://lecourtilauxepines.pagesperso-orange.fr

mm23
Posts: 152
Joined: Mon Feb 03, 2014 12:22 pm
Weather Station: ws 2350
Operating System: windows xp sp3
Location: Europe

Re: Database

Postby mm23 » Sat Feb 07, 2015 6:11 pm

It is easy when you know how to do it.... :D
Cumulus will not upload data on database.. Cumulus toolbox sends data in files on a remote server and from there a cron job upload data on data base ... It is how It's work in my case
Thus, database will load by data with the help, not from my friends :) , but with a help of cron Job which is set on a remote server and your host must be capable to do that…..

The answer to you first question is the following:
Cumulus toolbox got to set to upload your data file using the FTP protocol and is as follows:
Open Toolbox / File / setup / upload files (ftp) / add ..... and then just fill what you want / need
Local file name is the file on your PC which you want to upload, while the remote file name is the file on the server to which you want your file to upload.
As I understand in your case it would be three files
a) C / Cumulus / data / Dayfile
b) C / Cumulus / data / some monthfile
c) C / Cumulus / realtimelog.txt

This realtimelog text file will be form by Cumulus toolbox also because this file does not exist on Cumulus original configuration. You must do that by Cumulus toolbox also .... File / setup / realtime.txt ..... only fulfill what is required

Regarding your second question I am not sure whether I understood well but probably do not know the answer, but I think that in any case there is a solution ... for beginning I suppose that your data format is dd.mm.yyyy?
If you ask me your question is not precise enough...

Good luck!
Image

User avatar
mcrossley
Posts: 5008
Joined: Thu Jan 07, 2010 9:44 pm
Weather Station: Davis VP2
Operating System: Jessie Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Database

Postby mcrossley » Sat Feb 07, 2015 6:59 pm

Have you taken a look at the import Cumlus script in the wiki?

It will put the Cumulus log files into MySQL, the import can be local via a cron job, or remote via a http call.

mm23
Posts: 152
Joined: Mon Feb 03, 2014 12:22 pm
Weather Station: ws 2350
Operating System: windows xp sp3
Location: Europe

Re: Database

Postby mm23 » Sun Feb 08, 2015 10:33 am

mcrossley wrote:Have you taken a look at the import Cumlus script in the wiki?

It will put the Cumulus log files into MySQL, the import can be local via a cron job, or remote via a http call.


Exactly .... I forgot about this option. It is located in the Cumulus / File / setup / remote commands
Image

hruska07
Posts: 4
Joined: Fri Aug 11, 2017 3:33 pm
Weather Station: Davis VP2
Operating System: Windows 10

Re: Database

Postby hruska07 » Thu Aug 17, 2017 11:09 pm

mm23 wrote:I use "Cumulus toolbox" to send data to the remote server. ..
On remote server there are three files (realtime, dayfile and monthly). For those files I have set up a cron job that, depending on the desired time interval, sends data in three (realtime, dayfile and monthly) tables in the database



Hello, could anyone write me the syntax of the cron job for Cumulus files importing to MySQL, please? I would be glad. Thank you.

hruska07
Posts: 4
Joined: Fri Aug 11, 2017 3:33 pm
Weather Station: Davis VP2
Operating System: Windows 10

Re: Database

Postby hruska07 » Sat Aug 19, 2017 3:31 pm

courtil wrote:Hello,

Thank you for your information.

I installed Cumulus Toolbox.

it for backup files: cumulus.ini, dayfile .....

But not load files (realtime, dayfile, monthly) on database ??


Can you explain to me because my skills are weak !!!

Other Question:

I use "Highcharts" to draw my graphs, the script asks for a timestamp
to date the graphs.
what are the realm of possibility for the date field is dd / mm / yy

Thank you for your information

Best Regards

Michel said courtil


Hello, i have another question. Maybe, i annoy too much with my abstract question, but can anybody answer, if i have the dayfile.txt, it is only for import of the values for day or there is a chance to take for example average values for month and realtime instead of "full using". I mean, is there any possibility how to realize this idea with some script or not? Now, i am trying to figure out this solution and run MySQL under phpMyAdmin to represent the all data on a web page. I hope somebody will reply me. Thanks.

mm23
Posts: 152
Joined: Mon Feb 03, 2014 12:22 pm
Weather Station: ws 2350
Operating System: windows xp sp3
Location: Europe

Re: Database

Postby mm23 » Thu Oct 12, 2017 6:49 pm

hruska07 wrote:
mm23 wrote:I use "Cumulus toolbox" to send data to the remote server. ..
On remote server there are three files (realtime, dayfile and monthly). For those files I have set up a cron job that, depending on the desired time interval, sends data in three (realtime, dayfile and monthly) tables in the database



Hello, could anyone write me the syntax of the cron job for Cumulus files importing to MySQL, please? I would be glad. Thank you.


php –q
/yourhomedirectoryincpanel/public_html/yourwebpage.com/pathtoimportcumulusfile.php type=dayfile key=yourkey table=yourdayfiletableinphpmyadmin file=/ yourhomedirectoryincpanel /public_html/yourwebpage.com/pathtoyourdayfile.txt

php -q /yourhomedirectoryincpanel /public_html/ yourwebpage.com/pathtoimportcumulusfile.php type=realtime key=yourkey table=yourrealtimetableinphpmyadmin file= yourhomedirectoryincpanel /public_html/yourwebpage.com/pathtoyourrealtime.txt retainVal=2 retainUnit=day

php -q / yourhomedirectoryincpanel /public_html/yourwebpage.com/pathtoyourimportcumulusfile.php type=monthly key=yourkeytable=yourmonthlytableinphpmyadmin file=/ yourhomedirectoryincpanel /public_html/yourwebpage.com/pathtoyourmonthly.txt
Image


Return to “Cumulus 1”

Who is online

Users browsing this forum: Bing [Bot] and 5 guests