|
 Author | Topic: Exporting and importing data (Read 938 times) |
hoogendoorn
Member
member is offline
![[homepage]](http://s1.images.proboards.com/buttons/www_sm.gif)
Joined: Aug 2007
Posts: 2
Location: Taiz, Yemen
Karma: 1 |  | Exporting and importing data
« Thread Started on Aug 27, 2007, 9:58am » | |
Currently my weather station (Davis Vantage Pro2) does not function properly so I have quiet a lot of missing data which are stored as zeros in the database as well as erroneous measurements. Now I want to change these zeros and erroneous data by the missing value indicator (---). Doing this within WeatherLink is very troublesome as you can edit only one record/field at a time. I thought about exporting the database to a text-file and importing this file into a spreadsheet for the edit work and after that export the data as a *.txt or *.csv file. However, WeatherLink does support import of ASCII files. Does anybody know if there is a program available which converts data text-files to *.wlk files or something similar?
| |
|
Mark / Ohio
Contributor
member is offline
![[avatar]](http://img.photobucket.com/albums/v176/memmurphy/cal_baloon.gif)
Joined: Jun 2005
Gender: Male 
Posts: 46
Location: Fairfield County Ohio, USA
Karma: 2 | |
jruys
Member
member is offline
Joined: Aug 2007
Gender: Male
Posts: 4
Location: Highlands Ranch, CO
Karma: 0 |  | Re: Exporting and importing data
« Reply #2 on Aug 29, 2007, 8:16am » | |
Hi, I wrote the little app posted above and I just uploaded an update last night that fixes some errors people were getting with the bulk insert wizard. If you have any problems with the imports just let me know.
-jruys
www.ruysfamily.com
|
-jruys
www.ruysfamily.com |
|
hoogendoorn
Member
member is offline
Joined: Aug 2007
Posts: 2
Location: Taiz, Yemen
Karma: 1 | | Re: Exporting and importing data
« Reply #3 on Aug 29, 2007, 10:07am » | |
Ah, there you are. I downloaded and tried your program and it seems that it might do the work. However, the importing ended due to errors. Do you prefer to continue our conversation by this site or directly by email?
| |
|
jruys
Member
member is offline
Joined: Aug 2007
Gender: Male
Posts: 4
Location: Highlands Ranch, CO
Karma: 0 | | Re: Exporting and importing data
« Reply #4 on Aug 30, 2007, 9:01pm » | |
All right, in looking at the code I would think that the dates should be working. Do you know what errors you are getting? Just let me know and I will try to fix them.
|
-jruys
www.ruysfamily.com |
|
jruys
Member
member is offline
Joined: Aug 2007
Gender: Male
Posts: 4
Location: Highlands Ranch, CO
Karma: 0 | | Re: Exporting and importing data
« Reply #5 on Sept 5, 2007, 9:33pm » | |
The errors have hopefully been fixed and uploaded to the website. There was a problem with the Evapo-Transparation not importing correctly, but it has now been fixed.
|
-jruys
www.ruysfamily.com |
|
|
![[Search This Thread]](http://s1.images.proboards.com/search2.gif)
![[Send Topic To Friend]](http://s1.images.proboards.com/buttons/sendtopic.gif)
![[Print]](http://s1.images.proboards.com/buttons/print.gif)
Logged![[image]](http://fairfieldcountyweather.com/fixedWeatherlogo.jpg)