Welcome to the Cumulus Support forum.

Latest Cumulus MX release v3.3.0 build 3063 - 10 January 2020.
    Legacy Cumulus 1 release v1.9.4 (build 1099) - 28 November 2014

    See the Wiki for downloading either version.

    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.
    Post Reply
    courtil
    Posts: 109
    Joined: Thu 16 Jan 2014 1:31 pm
    Weather Station: Vantage PRO2
    Operating System: Windows 10 Professionnal
    Location: France
    Contact:

    Database

    Post by courtil » Mon 02 Feb 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 Professionnal
    Station Météo : Vantage PRO2
    Cumulus version 3.00 b 3050
    http://lecourtilauxepines.eu/index.php
    https://lecourtilauxepines.pagesperso-orange.fr/

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

    Re: Database

    Post by mm23 » Mon 02 Feb 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: 109
    Joined: Thu 16 Jan 2014 1:31 pm
    Weather Station: Vantage PRO2
    Operating System: Windows 10 Professionnal
    Location: France
    Contact:

    Re: Database

    Post by courtil » Fri 06 Feb 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 Professionnal
    Station Météo : Vantage PRO2
    Cumulus version 3.00 b 3050
    http://lecourtilauxepines.eu/index.php
    https://lecourtilauxepines.pagesperso-orange.fr/

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

    Re: Database

    Post by mm23 » Sat 07 Feb 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: 5931
    Joined: Thu 07 Jan 2010 9:44 pm
    Weather Station: Davis VP2
    Operating System: Stretch Lite rPi
    Location: Wilmslow, Cheshire, UK
    Contact:

    Re: Database

    Post by mcrossley » Sat 07 Feb 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 03 Feb 2014 12:22 pm
    Weather Station: ws 2350
    Operating System: windows xp sp3
    Location: Europe

    Re: Database

    Post by mm23 » Sun 08 Feb 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 11 Aug 2017 3:33 pm
    Weather Station: Davis VP2
    Operating System: Windows 10

    Re: Database

    Post by hruska07 » Thu 17 Aug 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 11 Aug 2017 3:33 pm
    Weather Station: Davis VP2
    Operating System: Windows 10

    Re: Database

    Post by hruska07 » Sat 19 Aug 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 03 Feb 2014 12:22 pm
    Weather Station: ws 2350
    Operating System: windows xp sp3
    Location: Europe

    Re: Database

    Post by mm23 » Thu 12 Oct 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

    Post Reply