Sparkline

[Bashy]

Hi

I've just been playing and created 3 more, Wind Speed, Wind DIR and a Solar graph

I have added them to this post in case anyone is interested

You can view them here at the bottom

[pinto]

Thank you Bashy

Jozef

[Bashy]

Ya welcome, tis the least i can do!!

[edje1205]

Yep like it ! Thanx !

[Bashy]

Ok just in case anyone wants it, I have created the Gust speed last 24 hrs
Added to this post

[edje1205]

Thnx 4 more total now, oops have to adapt my webpage.

Joseph,

Was just looking at your page again.
Yesterday the lines changed at about each minute.
Do you upload each minute clientrawhour.txt ? (own server I suppose?)

Here I can't faster then once in 5 min, so always much flat lines and a
change now and then.

(This is beside slow changes of temps baro wind of course)
What's different ?

grtz
edje

[pinto]

Do you upload each minute clientrawhour.txt ? (own server I suppose?)

The answer is ..... mysql

Jozef

[Bashy]

I upload my clientraw every minute i think it is and yeah its to a dedicated server over in the US 

[edje1205]

As in another thread mentioned I'm not allowed to upload mysql data to my host
I only can import with a script on the server. They say it's very common to do that.

Trying it manual, clientraw*.txt , data*csv wil give an error, don't know what's poss more. Are there any other files to import to work with on this ?

If I had should know ..............................(yes other host) 

Bashy,

For sparkline it's about clientrawhour.txt, only poss to upload it once at 5 min.
Do you use otherwise ?

[broadstairs]

One thing you can do is to run MySQL locally on your WD PC (if its powerful enough) and then access your MySQL data from your hosting site on your local PC. All you have to do is setup a read only userid on MySQL and open up the MySQL port to the internet. On my router I allow only access from the specific IP address where my web site is hosted so its pretty secure. I actually only access MySQL for other databases not related to WD as I can upload my clientraw files fast enough.

Stuart

[pinto]

or you can use this script with cron, it reads clientraw and updates your database

[edje1205]

Thanx both !

Broadstairs, my PC isn't dedicated enough to run it that way...wil change host soon.

Pinto,

aha, that's what I can work out , as I can see so far ( why not ? hm my host surprised me before, but keep )

Let you know !

[Tim Hanko]

Is it possible to create/upload clientrawhour.txt every minute?

[pinto]

Is it possible to create/upload clientrawhour.txt every minute?

No, not unless Brian changes it in the settings, as for now, it is 5 minutes

[edje1205]

It's comming up, what is

Code: [Select]

Notice: Undefined variable: query in /var/www/vhosts/weersverwachtingen.eu/httpdocs/update_mysql.php on line 153

Error performing query:
Duplicate entry 'weersverwa' for key 1

in the script I see:

Code: [Select]

$id = "weersverwachtingen.eu"; //id as used by Weather Display (location of your weatherstation***
did
'zaanstreek' 'Zaandam'
but that's not it ,

Joseph ? assistentie aub