I've used the "export logs" feature on the GB website. I imported the CSV into Excel, and ON THE SURFACE it looks fine, with no import problems and all the data being there.
On closer inspection however, I've found a major flaw... the formatting of dates is not consistent across the logs. Some of the dates came through as dd/mm/yy and some came through as mm/dd/yy. Also, in the CSV when viewed in Excel some of the date cells are formatted as "Date", but others are formatted as "General".
Is there something that could be causing this inconsistency in the formatting of dates within the GB system? Sometimes I enter my data through the logs screen in the GB iPhone app, sometimes I enter them through the "Add Log" screen, and sometimes I enter them directly into the GB website. Is there a possibility that the dates are not consistent in each of these areas. Also, being in Australia our dates are different to US and other countries (day entered before month). Since the iPhone uses your global date settings when entering dates, could there be an issue there?
I've just spent the last 3 hours trying to work out what I did wrong in my import (even though it's very straightforward), and having to retype every single date for every single entry.
As you can image, the inconsistency with the date formatting becomes a big problem if I sort my data differently to how the CSV handles it (eg. most recent BGLs first) OR if I decide I want to change my dates to show the actual day or the name of the month (to make it easier to read). This problem means that the different dates are in the wrong order or against the wrong day.
Thanks for looking into this and sorting as quickly as possible. I would be keen to know if anyone else is finding this same problem?
|