Yes I will drop the daily summaries when I'm done importing my data. Right now looking through old hard drives I should have at least 5 more years of data.
Thanks Rich On Sunday, January 28, 2018 at 2:56:46 PM UTC-5, Tom Keffer wrote: > > Oh, well. It was just a theory. Gary is better equipped to know the real > answer. > > I do know that, ideally, records should be imported from oldest to newest. > Otherwise, the daily summaries get messed up. If you went the other way, > all is not lost, but you should drop the daily summaries > <http://weewx.com/docs/utilities.htm#Action_--drop-daily> when you're > done with the import. WeeWX will then rebuild them. > > -tk > > > On Sun, Jan 28, 2018 at 12:46 PM, rich T <[email protected] <javascript:> > > wrote: > >> Tom >> >> I would agree if more files did not completely import. I did import >> these files from the newest to oldest individually. Maybe I should of >> imported them from oldest to newest. The following is a list of the files >> imported: >> >> 08-14 - Imported all data >> 09-14 - Imported data until 14/09/14 >> 10-14 - Imported all data >> 11-14 through 03-15 - Imported all data >> 04-15 - Imported data until 20/04/15 >> 05-15 - Imported all data >> 06-15 - Imported data until 02/06/15 >> 07-15 - Imported data until 15/07/15 >> 08-15 - Imported all data >> 09-15 - Imported data until 07/09/15 >> 10-15 through 07-16 - Imported all data >> 08-16 - Imported data until 23/08/16 >> 09-16 through 08-17 - Imported all data >> 09-17 - Imported data until 14/09/17 >> 10-17 - Imported data until 14/10/17 >> 11-17 - Imported data until 14/11/17 >> 12-17 - Imported all data >> >> By the way thanks for a great program. I'm getting it working while >> learning Linux and python. >> >> Rich >> >> >> On Sunday, January 28, 2018 at 12:51:03 PM UTC-5, Tom Keffer wrote: >>> >>> I wonder if the problem is that your import file has DD/MM/YY, while the >>> Cumulus importer expects MM/DD/YY? Because there are 31 days in a month, >>> but only 12 months of the year, you would fill roughly half the database >>> before the errors occurred. >>> >>> Just a guess. I really don't know how the Cumulus importer works. >>> >>> -tk >>> >>> On Sun, Jan 28, 2018 at 9:16 AM, rich T <[email protected]> wrote: >>> >>>> I have imported 42 months worth of data into the database. 8 of the >>>> months only half the month worth of data was imported. Around the 15th of >>>> each month the following error was produced: >>>> >>>> manager: Unable to add record 2017-11-15 00:00:00 EST (1512018000) to >>>> database 'weewx.sdb': UNIQUE constraint failed: archive.dateTime >>>> >>>> I look at those files causing the error and did not see anything. >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "weewx-user" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to [email protected]. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- >> You received this message because you are subscribed to the Google Groups >> "weewx-user" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
