Welcome to the Cumulus Support forum.

Latest Cumulus MX V4 release 4.4.2 (build 4085) - 12 March 2025

Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024

Legacy Cumulus 1 release 1.9.4 (build 1099) - 28 November 2014
(a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)

Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki

If you are posting a new Topic about an error or if you need help PLEASE read this first viewtopic.php?p=164080#p164080

Please, i need help with my Dayfile/Monthfile (database)

Other discussion about creating web sites for Cumulus that doesn't have a specific subforum

Moderator: daj

Post Reply
Nightflyer
Posts: 26
Joined: Wed 01 Sep 2010 11:01 am
Weather Station: WS2300
Operating System: Windows xp

Please, i need help with my Dayfile/Monthfile (database)

Post by Nightflyer »

Hey everyone,

Let me introduce myself first
I'm Richard and i am located in the Netherlands.
Sorry for mine bad English, i'm trying my best! :cry:
I'm using The WS2300 to read my local weather data

I discovered this software on the net about 3 month's ago en i gladly found out that this software is compatible with my weather station! :)
I have made a customised page as you will see in the next link.

http://home.kpn.nl/richardgringhuis/

I've made several changes in an existing template and it worked out well.

Now i wanted to have a database from the day-file/month-file and year-file so i can read the data from day to day
I did everything i could but i cant get it to work
it show the table but i cant get data in to it, i uploaded the Dayfile and monthfile

I took al the steps that was needed like on this page http://wiki.sandaysoft.com/a/ImportCumulusFile but cant figure out what i'm doing wrong

Can anyone help me pls?? :)
I can upload al the files if needed so maybe someone has time spare to look at it
I would be verry thankfull!

thanks verry much in advance!
User avatar
nitrx
Posts: 1297
Joined: Sun 13 Dec 2009 1:21 pm
Weather Station: WH1080
Operating System: Windows 10
Location: Apeldoorn The Netherlands
Contact:

Re: Please, i need help with my Dayfile/Monthfile (database)

Post by nitrx »

Do you get errors when you execute the script ? (Also verify if you have adjusted the seperators for your date , data you are using a comma for values this has to be sprcified in the script)

edit: look for these fields in the script and adjust them according to your dayfile.txt

$field_delimiter=",";
$date_delimiter="/";
$decimal_separator=".";
Nightflyer
Posts: 26
Joined: Wed 01 Sep 2010 11:01 am
Weather Station: WS2300
Operating System: Windows xp

Re: Please, i need help with my Dayfile/Monthfile (database)

Post by Nightflyer »

nitrx wrote:Do you get errors when you execute the script ? (Also verify if you have adjusted the seperators for your date , data you are using a comma for values this has to be sprcified in the script)

edit: look for these fields in the script and adjust them according to your dayfile.txt

$field_delimiter=",";
$date_delimiter="/";
$decimal_separator=".";

This is what i have in my importcumulusfile:

//

$field_delimiter=",";
$date_delimiter="/";
$decimal_separator=",";
//


this is a part of my dayfile.txt : 17-09-10;0,0;0;00:00;0,0;00:00;11,4;21:38;0,0;00:00;1017,2;23:43;0,2;22:43;0,5;10,8;0,0;0,0;00:00
18-09-10;0,0;360;00:00;7,8;07:42;13,6;15:42;1017,0;00:16;1019,1;13:42;0,0;00:00;0,0;10,7;0,0;0,0;00:00
19-09-10;0,0;360;00:42;6,9;04:42;14,3;14:42;1016,0;19:42;1019,0;00:42;0,2;07:42;0,5;11,0;0,0;0,0;00:42
20-09-10;0,0;360;00:42;11,3;06:42;16,5;16:42;1014,7;06:42;1017,7;23:39;0,5;08:05;0,5;13,6;0,0;0,0;00:42
21-09-10;0,0;360;00:42;12,1;23:42;16,8;16:42;1017,9;00:42;1023,9;23:42;0,0;00:42;0,0;14,4;0,0;0,0;00:42
22-09-10;0,0;360;00:42;10,2;07:42;19,3;13:42;1017,6;23:42;1023,9;00:42;0,0;00:42;0,0;14,8;0,0;0,0;00:42
23-09-10;0,0;360;00:42;12,8;05:42;20,5;16:42;1006,4;23:16;1017,6;00:42;0,0;00:42;0,0;16,5;0,0;0,0;00:42


When i execute the script i get this message:

De pagina is niet gevonden (page not found)

De URL http://home.kpn.nl/richardgringhuis/Imp ... ayfile.txt is niet gevonden op de webserver.
Controleer of het pad in de URL juist is.


I'm not that familiar with php / mysql :cry:
User avatar
nitrx
Posts: 1297
Joined: Sun 13 Dec 2009 1:21 pm
Weather Station: WH1080
Operating System: Windows 10
Location: Apeldoorn The Netherlands
Contact:

Re: Please, i need help with my Dayfile/Monthfile (database)

Post by nitrx »

Nightflyer wrote:
nitrx wrote:Do you get errors when you execute the script ? (Also verify if you have adjusted the seperators for your date , data you are using a comma for values this has to be sprcified in the script)

edit: look for these fields in the script and adjust them according to your dayfile.txt

$field_delimiter=",";
$date_delimiter="/";
$decimal_separator=".";

This is what i have in my importcumulusfile:

//

$field_delimiter=",";
$date_delimiter="/";
$decimal_separator=",";
//


this is a part of my dayfile.txt : 17-09-10;0,0;0;00:00;0,0;00:00;11,4;21:38;0,0;00:00;1017,2;23:43;0,2;22:43;0,5;10,8;0,0;0,0;00:00
18-09-10;0,0;360;00:00;7,8;07:42;13,6;15:42;1017,0;00:16;1019,1;13:42;0,0;00:00;0,0;10,7;0,0;0,0;00:00
19-09-10;0,0;360;00:42;6,9;04:42;14,3;14:42;1016,0;19:42;1019,0;00:42;0,2;07:42;0,5;11,0;0,0;0,0;00:42
20-09-10;0,0;360;00:42;11,3;06:42;16,5;16:42;1014,7;06:42;1017,7;23:39;0,5;08:05;0,5;13,6;0,0;0,0;00:42
21-09-10;0,0;360;00:42;12,1;23:42;16,8;16:42;1017,9;00:42;1023,9;23:42;0,0;00:42;0,0;14,4;0,0;0,0;00:42
22-09-10;0,0;360;00:42;10,2;07:42;19,3;13:42;1017,6;23:42;1023,9;00:42;0,0;00:42;0,0;14,8;0,0;0,0;00:42
23-09-10;0,0;360;00:42;12,8;05:42;20,5;16:42;1006,4;23:16;1017,6;00:42;0,0;00:42;0,0;16,5;0,0;0,0;00:42


When i execute the script i get this message:

De pagina is niet gevonden (page not found)

De URL http://home.kpn.nl/richardgringhuis/Imp ... ayfile.txt is niet gevonden op de webserver.
Controleer of het pad in de URL juist is.


I'm not that familiar with php / mysql :cry:
The settings should be
$field_delimiter=";";
$date_delimiter="-";
$decimal_separator=",";

The date has a dash - (streepje) the data are seperated by ; and you've a comma for the decimals and ofcourse yoy shouldt ftp the dayfile.txt to the right place on your server.
User avatar
nitrx
Posts: 1297
Joined: Sun 13 Dec 2009 1:21 pm
Weather Station: WH1080
Operating System: Windows 10
Location: Apeldoorn The Netherlands
Contact:

Re: Please, i need help with my Dayfile/Monthfile (database)

Post by nitrx »

By the way I'm almost sure your provider doesn's suppurt mysql and php (Dutch: een account bij kpn homepage zal hoogstwaarschijnlijk geen php en databaseondersteuning hebben daarvoor moet je bij een professionele hoster zijn)
Nightflyer
Posts: 26
Joined: Wed 01 Sep 2010 11:01 am
Weather Station: WS2300
Operating System: Windows xp

Re: Please, i need help with my Dayfile/Monthfile (database)

Post by Nightflyer »

I saw that you have a php and database support at your .tk site.
I also saw that it is a free hosting so i signed up at .tk and will try if i can get a database there :P
If not ill contact you if its ok pls?

grtz
Richard
User avatar
nitrx
Posts: 1297
Joined: Sun 13 Dec 2009 1:21 pm
Weather Station: WH1080
Operating System: Windows 10
Location: Apeldoorn The Netherlands
Contact:

Re: Please, i need help with my Dayfile/Monthfile (database)

Post by nitrx »

Nightflyer wrote:I saw that you have a php and database support at your .tk site.
I also saw that it is a free hosting so i signed up at .tk and will try if i can get a database there :P
If not ill contact you if its ok pls?

grtz
Richard
I don't have free hosting .tk gives free forward url's but mine is bought and I host the domain on a commercial server.
Nightflyer
Posts: 26
Joined: Wed 01 Sep 2010 11:01 am
Weather Station: WS2300
Operating System: Windows xp

Re: Please, i need help with my Dayfile/Monthfile (database)

Post by Nightflyer »

ok i get it,
Do you probably know where i can get a free hosting with php en mysql cuz of the database?
firts i want to test the page and if all working ok i'll probably rent a .nl webhosting

thanks in advance and thanks for your quick answers!
User avatar
beteljuice
Posts: 3292
Joined: Tue 09 Dec 2008 1:37 pm
Weather Station: None !
Operating System: W10 - Threadripper 16core, etc
Location: Dudley, West Midlands, UK

Re: Please, i need help with my Dayfile/Monthfile (database)

Post by beteljuice »

That would be the 1st topic in website development ;)

https://cumulus.hosiene.co.uk/viewtopic.php?f=14&t=3745
Image
......................Imagine, what you will KNOW tomorrow !
Post Reply