wviewweather.com Forum Index wviewweather.com
wview and Weather Topics
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

create wlk files from mysql / database tables

 
Post new topic   Reply to topic    wviewweather.com Forum Index -> Wish List
View previous topic :: View next topic  
Author Message
Entr04y



Joined: 11 Nov 2005
Posts: 8

PostPosted: Fri Nov 11, 2005 9:42 pm    Post subject: create wlk files from mysql / database tables Reply with quote

I had started my own database and have all the data for the last year in the database, which I just imported into the archive table in the wviewDB. I had to reset my console to use a 5 minute archive (it was set to 30 minutes), and that of course cleared all the archive data. I had been pulling the data every five minutes, so my old data is valid for the new setup. Is there a way to create the wlk files from the data in the archive table?

Thanks!
Back to top
View user's profile Send private message
mteel



Joined: 30 Jun 2005
Posts: 435
Location: Collinsville, TX

PostPosted: Sat Nov 12, 2005 1:36 am    Post subject: Reply with quote

Aha!

This is your crash problem I bet!

How is wview coming up and saying it is finding 30 days of archive records if you just changed from a 30 minute archive interval to a 5 minute archive interval? Did you not heed:
Quote:
6.4 (New Installs) Existing Weatherlink Archive Files
If you have existing archive files (*.wlk) that you want to keep/use, copy them to
/var/wview/archive prior to starting wview. It will find them and use them for
historical charts and NOAA reports. But only if they were collected using the same
archive interval that you are going to use for your VP with wview. See the section
Preparing a New Vantage Pro Console for more details.


If this is the case, you need to move the old 30 minute WLK files out of the way (/var/wview/archive) and start fresh if you want to change your archive interval to 5 minutes...

To answer your other question, no, you cannot backfill WLK files with relational database data. The WLK files are *the* data of record. It could be done I guess, but not any time soon. There is another request to synchronize the database with the WLK files (going the other direction from your request).

Mark
Back to top
View user's profile Send private message Send e-mail Visit poster's website
mhweather



Joined: 07 Aug 2005
Posts: 54

PostPosted: Sat Nov 12, 2005 8:31 am    Post subject: Reply with quote

Slightly off the topic, but does Wview, when configured for MySQL, also continue to record data in *.WLK files ?
Back to top
View user's profile Send private message
mteel



Joined: 30 Jun 2005
Posts: 435
Location: Collinsville, TX

PostPosted: Sat Nov 12, 2005 8:36 am    Post subject: Reply with quote

Yes ... absolutely ... YES!

The WLK files are always created and are the archive of record.

MySQL or PostGreSQL archives are only for convenience and to use externally for reports or other custom apps - they are never used as input to wview, only the WLK files.

Said another way, relational database archives are *output* only, never used as input to wview.

The WLK files are input and output and their central role as the archive of record is not affected by the generation of relational archive records.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Entr04y



Joined: 11 Nov 2005
Posts: 8

PostPosted: Sat Nov 12, 2005 10:24 am    Post subject: Reply with quote

the steps I took when changing the archive interval were:

shut down wview
change the archive settings on the console using vpinstall
truncate the archive table in mysql
backfill the mysql table with my old data
delete all of the .wlk files in /var/wview/archive
restart wview

I put the .wlk file, which is the only one I have at this point at http://www.froody.org/2005-11.wlk if you want to take a look at it.
Back to top
View user's profile Send private message
mteel



Joined: 30 Jun 2005
Posts: 435
Location: Collinsville, TX

PostPosted: Sat Nov 12, 2005 3:24 pm    Post subject: Reply with quote

Yep, that looks right, very odd indeed. Maybe the computed data I added recently doesn't like to run in the first day of archive records - that is a little hard for me to test.

Let me know if you see any other problems.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    wviewweather.com Forum Index -> Wish List All times are GMT - 6 Hours
Page 1 of 1

 
Jump to:  
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 vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group