Page 1 of 1

Database

Posted: Mon Feb 02, 2015 10:50 am
by courtil
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

Re: Database

Posted: Mon Feb 02, 2015 11:52 am
by mm23
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

Re: Database

Posted: Fri Feb 06, 2015 11:34 am
by courtil
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

Re: Database

Posted: Sat Feb 07, 2015 6:11 pm
by mm23
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!

Re: Database

Posted: Sat Feb 07, 2015 6:59 pm
by mcrossley
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.

Re: Database

Posted: Sun Feb 08, 2015 10:33 am
by mm23
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

Re: Database

Posted: Thu Aug 17, 2017 11:09 pm
by hruska07
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.

Re: Database

Posted: Sat Aug 19, 2017 3:31 pm
by hruska07
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.

Re: Database

Posted: Thu Oct 12, 2017 6:49 pm
by mm23
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