Historic data discrepancies

steve · **Posted:** Sat Sep 12, 2009 12:02 am

risiss wrote:

yepp,its done and its set at gmt -05:00

It must be an error processing the data from the database...

bruce45 · **Posted:** Sat Sep 12, 2009 5:40 pm

Bruiser wrote:

I have those discrepencies also. For whatever reason, when I imprt the data, iget an"Importing" box but the progress bar never appears.....Just a constant importing is all that displays..

i get the same problem. when i check with the data editor i am missing date from 01/01/2009 till 31/8/2009. is there any way of forcing it to load or importing it by editing the file.

daj · **Posted:** Sat Sep 12, 2009 5:45 pm

I'm sure Steve will come along with a fix so we do not need to force the data in. I checked the SQL tables themselves, and they are also missing the data (I knew they would be but just in case...)

steve · **Posted:** Sat Sep 12, 2009 6:48 pm

The inserting of the data into the database is failing after the first few entries, claming a duplicate key - I use date and time as the primary key, so I know that's not true. There's clearly something funny going on that wasn't happening before when I was testing importing the data, but I don't know what it is. I have pretty much decided to revert to SQLite for the database, so I think I will stop trying to understand this, do the necessary changes to go back to SQLite, and do the import using raw SQL which is much quicker, and more importantly, works.

	It is currently Thu May 23, 2013 10:01 pm
Please click here before posting. Help me to help you!
Useful Links: Cumulus FAQ • Enhancement requests • Wiki (documentation)
Please put your approximate location into your profile
Add your web site to the Cumulus user map
Vantage Pro2 users with firmware 3.00 should upgrade to fw 3.12 and Cumulus 1.9.4
Latest Cumulus release v1.9.3 (build 1059) - Feb 09 2013 Latest Cumulus beta v1.9.4 build 1077 - May 23 2013 --> Latest Cumulus Realtime v1.0.0.5 - Sep 05 2009

Sandaysoft

Historic data discrepancies

Who is online