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! :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!

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 :cry:

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 :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.

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 :P
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 :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.

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
That would be the 1st topic in website development ;)

https://cumulus.hosiene.co.uk/viewtopic.php?f=14&t=3745