Search found 8 matches

by SteveWx
Fri Nov 03, 2017 12:47 pm
Forum: Problems
Topic: Recovering from bad data import
Replies: 12
Views: 15729

Re: Recovering from bad data import

Thanks again Luc, excellent suggestions, and I ran the reformat script this morning. I live in the woods and tend to get knocked off the grid a couple of times a year, and will certainly remember to use tab delimiting with WeatherDisplay from here on out. Although I keep thinking WeeWX on a Pi might...
by SteveWx
Thu Nov 02, 2017 7:48 pm
Forum: Ideas
Topic: Feature request- option to increase sample size on bulk data import
Replies: 3
Views: 4790

Re: Feature request- option to increase sample size on bulk data import

Well, it was worth asking. I'll continue to do it the way I resolved my issue today, which was to upload a text file, test, edit the text file to delete the top row, upload the text file again, test again, edit the text file again, deleting rows until the hour changes from 9 to 10, upload the edited...
by SteveWx
Thu Nov 02, 2017 6:58 pm
Forum: Ideas
Topic: Feature request- option to increase sample size on bulk data import
Replies: 3
Views: 4790

Feature request- option to increase sample size on bulk data import

After recently encountering database import errors, would it be possible to have the 'test import' functionality include more than one row of data? Matching the field numbers with the first row of data appeared to work in the test, yet failed significantly when differences in subsequent rows were en...
by SteveWx
Thu Nov 02, 2017 6:46 pm
Forum: Problems
Topic: Recovering from bad data import
Replies: 12
Views: 15729

Re: Recovering from bad data import

Using tab as the delimiter instead of a space worked much better! Thanks for the bulk database editor too Jachym, it made the cleanup less painful. Now I'll head on over to the feature request thread and ask for the option to have more than one line of data to be tested before a bulk import.
by SteveWx
Thu Nov 02, 2017 1:44 pm
Forum: Problems
Topic: Recovering from bad data import
Replies: 12
Views: 15729

Re: Recovering from bad data import

Maybe this will illustrate it better- as I noted, the formatting in the forum truncated the extra space:

Image
by SteveWx
Thu Nov 02, 2017 1:12 pm
Forum: Problems
Topic: Recovering from bad data import
Replies: 12
Views: 15729

Re: Recovering from bad data import

Thanks Luc, but I think I have figured out where the process is failing. WeatherDisplay doesn't seem to use forwarding zeros, and the Meteotemplate space delimiter parsing script doesn't handle that well. In this example, the time (minute) is in field 5 at 10:09AM and in field 4 at 10:10AM. There ar...
by SteveWx
Wed Nov 01, 2017 5:23 pm
Forum: Problems
Topic: Recovering from bad data import
Replies: 12
Views: 15729

Recovering from bad data import

Due to a severe storm, I was knocked offline for a couple of days. In any event, I did a test import which looked terrific, so I imported the records from WeatherDisplay and everything did not follow the pattern of the first record? Here is the test import: Summary The following would be imported to...
by SteveWx
Mon Oct 02, 2017 1:18 pm
Forum: Problems
Topic: Auto-updates
Replies: 158
Views: 256860

Re: Auto-updates

Tested OK.