Sandaysoft

Support forum for Cumulus weather station software
It is currently Wed Jun 19, 2013 8:49 pm
Please click here before posting. Help me to help you!
Useful Links: Cumulus FAQ • Enhancement requests • Wiki (documentation)
Please put your approximate location into your profile
Add your web site to the Cumulus user map
Vantage Pro2 users with firmware 3.00 should upgrade to fw 3.12 and Cumulus 1.9.4

View unanswered posts | View active topics


Board index » Sandaysoft products » Cumulus » 3rd Party Tools

All times are UTC




Post new topic Reply to topic  Page 2 of 2
  [ 28 posts ]  Go to page Previous  1, 2
  Print view Previous topic | Next topic 
Author Message
n9mfk
 Post subject: Re: Display data from SQL in a table on your website
PostPosted: Tue Feb 09, 2010 4:24 pm 
Offline

Joined: Sun May 10, 2009 8:52 pm
Posts: 508
Location: Springfield, IL
Weather Station: davis vp2 Serial datalogger
Operating System: Windows 7 64-bit
Hi David,
I have a friend that uses my site with his screen reader
it does like js so that page can not be read
Beau
Top
 Profile  
 
n9mfk
 Post subject: Re: Display data from SQL in a table on your website
PostPosted: Tue Feb 09, 2010 7:53 pm 
Offline

Joined: Sun May 10, 2009 8:52 pm
Posts: 508
Location: Springfield, IL
Weather Station: davis vp2 Serial datalogger
Operating System: Windows 7 64-bit
Hi David
I us inHG on my davis station for my pressure what wood i need to change to show 3 digits after the point im not sure what file to change?
Thanks Beau
Top
 Profile  
 
daj
 Post subject: Re: Display data from SQL in a table on your website
PostPosted: Tue Feb 09, 2010 8:10 pm 
Offline
User avatar

Joined: Tue Jul 29, 2008 8:00 pm
Posts: 2001
Location: Thornhill, Dumfries, UK
Weather Station: WH1081
Operating System: Mac OSx & Win 7
n9mfk wrote:
Hi David
I us inHG on my davis station for my pressure what wood i need to change to show 3 digits after the point im not sure what file to change?
Thanks Beau

It's actually the import you will need to adjust, not the table that displays it.

Edit the ImportCumulusFile.php file and look for the line starting...
(should be line 100)

Code:
$CreateQuery="CREATE TABLE " . $table_name . " (LogDate date NOT NULL ,HighWindGust decimal(4,1)........


Quite far along the line change the MinPress decimal(6,2) to (7,3) same for MaxPress a little further along

For consistency, also change line 107...

Change ...Pressure decimal(6,2) to (7,3)

Delete your SQL table and re-import so that it creates the table again

_________________
David
Contact Me
Top
 Profile  
 
daj
 Post subject: Re: Display data from SQL in a table on your website
PostPosted: Wed Feb 10, 2010 9:04 pm 
Offline
User avatar

Joined: Tue Jul 29, 2008 8:00 pm
Posts: 2001
Location: Thornhill, Dumfries, UK
Weather Station: WH1081
Operating System: Mac OSx & Win 7
n9mfk wrote:
is there away to do this with out js

Beau

Kevin has done us proud.....

viewtopic.php?f=14&t=2419

_________________
David
Contact Me
Top
 Profile  
 
Hillbilly
 Post subject: Re: Display data from SQL in a table on your website
PostPosted: Sun Feb 14, 2010 1:29 pm 
Offline

Joined: Tue Jan 26, 2010 8:54 am
Posts: 107
Location: Mayenne, France
Weather Station: Maplin N96GY
Operating System: Vista Home Premium SP2
David,

This is now up and running. Thanks very much for producing it. It has worked a treat. :clap:

_________________
Many thanks
Helen
La Locherie Weather
Top
 Profile  
 
gismoat
 Post subject: Re: Display data from SQL in a table on your website
PostPosted: Tue Dec 14, 2010 11:03 pm 
Offline

Joined: Wed Dec 08, 2010 9:37 am
Posts: 3
Location: Thalgau
Weather Station: WH1080
Operating System: Windows7
Hi all,

i have uploadet all files via FTP to my webspace.
dbconfic.php is setup with my login data.

1.) how can i create a dayfile.txt ?
2.) wen i use the read_dayfile i become an error!

=> Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/web10/html/wetter/read_dayfile.php on line 25
Couldn't execute query.You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2

URL to my weather files is http://arbeiter4ever.com/wetter/

Please help me.
thanks
GismoAT
Top
 Profile  
 
daj
 Post subject: Re: Display data from SQL in a table on your website
PostPosted: Wed Dec 15, 2010 8:35 pm 
Offline
User avatar

Joined: Tue Jul 29, 2008 8:00 pm
Posts: 2001
Location: Thornhill, Dumfries, UK
Weather Station: WH1081
Operating System: Mac OSx & Win 7
You need to get your dayfile.txt (created by Cumulus) into your SQL DB. You can do this yourself or use a script to do it

viewtopic.php?f=18&t=2367

_________________
David
Contact Me
Top
 Profile  
 
gismoat
 Post subject: Re: Display data from SQL in a table on your website
PostPosted: Wed Dec 22, 2010 7:30 pm 
Offline

Joined: Wed Dec 08, 2010 9:37 am
Posts: 3
Location: Thalgau
Weather Station: WH1080
Operating System: Windows7
Hi,
the script is working good. But i have a question.
How can i change the table size?
I will include the Historic page to my homepage but the aktual table size is to big.
thanks
GismoAT
Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 2 of 2
  [ 28 posts ]  Go to page Previous  1, 2

Board index » Sandaysoft products » Cumulus » 3rd Party Tools

All times are UTC


Who is online

Users browsing this forum: Google [Bot] and 1 guest

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group