I am about to import 400,000 records contained in 9 files. I did dry runs
and no errors. This is 9 months of Weather-Display data in one-minute
intervals.
I would like to make a copy of the database before I start. I have used
Sqlite before. Not sure how to use your schema to do this. Can I
I am ready to do a dry run.
It took a trivial python program to convert:
day month year hour minute temperature humidity dewpoint barometer
windspeed gustspeed direction rainlastmindailyrain monthlyrain
yearlyrain heatindex
1 1 2017 0 1 44.1 46 24.6 29.953 0.2 0.0 245
On Friday, 21 April 2017 21:35:21 UTC+10, MRL wrote:
>
> What about the date/time?
> The date/time is in 5 fields? Hows do I set that up in the config file?
>
If you are going to go down the path of importing from a CSV file your
date-time data must be in one field. The field can be an epoch
Don't worry about converting to csv, I would much rather have wee_import import
from the raw files. Easiest thing is just to attach a few files, not sure if
you will need to change the extension though, can't remember how fussy google
groups is.
Gary
--
You received this message because you
Correction: The sample is from Weather-Display where I only have less than
a year. Still working om my 3+ years of Weather-Cat.
On Thursday, April 20, 2017 at 7:24:23 PM UTC-4, MRL wrote:
>
> I have about 4 years of Weather-Cat data that I can convert to a CSV file.
> Here is the what the data