Importing database from weewx 3.9.2 to weewx 4.5.1

[Rick]

Hi all,

Had a read of many threads and still at a loss on how to import data.

Yes, I know I can copy the 3.9.2 sdb over to my new RPi running 4.5.1 and that works.  However, I'd like to keep the new sdb format with all the extra fields as I'm intending to use the battery status etc, especially on the webpage.

Tried a csv import but get a "TypeError: "delimiter" must be a 1-character string" error.  Also the time/date format is a 10 digit number, not %Y-%m-%d %H:%M:%S as required by wee_import.

I used DB Browser for SQLite to create the csv.

Any ideas please?

Cheers,

Rick

[gjr80]

Hi,

You might want to try working through the Switching to the new wview_extended schema wiki page.

Gary

[Rick]

Cheers Gary.

Had a bit if a read and doesn't seem too difficult :)

Rick

[Rick]

Seems to have worked ok.  Now have v3 data on the v4 system :)