Page 1 of 1
Please, i need help with my Dayfile/Monthfile (database)
Posted: Sun 02 Jan 2011 12:19 pm
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!
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!
Re: Please, i need help with my Dayfile/Monthfile (database)
Posted: Sun 02 Jan 2011 12:47 pm
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=".";
Re: Please, i need help with my Dayfile/Monthfile (database)
Posted: Sun 02 Jan 2011 1:24 pm
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

Re: Please, i need help with my Dayfile/Monthfile (database)
Posted: Sun 02 Jan 2011 1:41 pm
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

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.
Re: Please, i need help with my Dayfile/Monthfile (database)
Posted: Sun 02 Jan 2011 2:06 pm
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)
Re: Please, i need help with my Dayfile/Monthfile (database)
Posted: Sun 02 Jan 2011 2:26 pm
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

If not ill contact you if its ok pls?
grtz
Richard
Re: Please, i need help with my Dayfile/Monthfile (database)
Posted: Sun 02 Jan 2011 2:41 pm
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

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.
Re: Please, i need help with my Dayfile/Monthfile (database)
Posted: Sun 02 Jan 2011 2:46 pm
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!
Re: Please, i need help with my Dayfile/Monthfile (database)
Posted: Sun 02 Jan 2011 2:50 pm
by beteljuice