[2twisty]

I would like to be able to download the data from GB and pull it into a database for more reporting options.

However, Without a truly unique ID for each record, there's no easy way to tell if a given record is "new" or if it has been modified.

For example,

If I take a BG reading on 1/1/2012 at 00:01, and then import that into a databse, and then subsequently realize that it was at NOON rather than at Midnight...then I update the entry and redo the import.

There's no way for the import routine to know that the record was updated rather than is a NEW BG reading, 12 hours later.

I'm sure your database has a unique ID for each record..it must for it to work properly. Could you please add it to the export? Users who don't want that data can just delete that column of data from the excel sheet that results.

I thought of using the date/time field to generate a uniqueID, but that won't help any if you change the time on a record. It will still look "new."

Please advise.

[dano]

I assume that you are working with the CSV file. Have you read through the "GB Help" File? There is one item mentioned there, that might help you with your date and time stamp.

[2twisty]

Where is this help file of which you speak? I can't find it.


I suppose I could always re-import the entire dataset each time, but that's really clunky.

Tell me where the help file is and I'll see if the thing mention is sufficient, although if it's based on the date/time field, it's not, since the date and time of a given log entry can be altered. Having an unalterable and unique identifier for each record will make it much easier to keep track of any data that was changed in an existing record.

[dano]

It's the second thread in the GB Specific section. I would post a link, but I'm on my cell phone.

Edited to add; Here is the link.