Export to Excel
 

Is there a way to export the logs from the GB website to Excel?

If not, this would be very handy.

Thank you,
Mysi

Export to Excel
 

I just want to add my vote to mhstar99's. I've been keeping Excel records since I was diagnosed 5 years ago. If possible I'd like to avoid entering everything twice. Thanks...

There is a way to create an Excel file from the current GB information. First you have to "push" email the logs to yourself. Then you have to copy and paste this information into a text file. Next you have to open a new Excel file and import the text file into the Excel file. It works great, you will just have to play with it to know how it works. I will tell you that the key is using the delimited text, with commas, see the Excel Help by searching for import text file. I know that you have to jump through a few hoops to get what you want, I just wanted to let you both know that this is possilbe to do. Here is a Screen Shot of the final product. I hope that this information helps!

This only works if you mail them from your phone, I *really* need to be able to export to Excel from the web.

Apparently I use GB a bit differently than most - my son is a T1 and we both have the Touch. He (the school nurse) uses his to enter in his BG numbers during the school day and upload them to the web when he comes home, and we'll use either one during meals, and mine when I check him overnight. Being able to sync both iPods to the web is fantastic, but makes getting the data to his diabetes team a bit problematic.

I do agree with you that it would be most benificial to have the ability to create reports, from the GB webiste, in several different formats.

However, I am afraid that your only current solution is to push the information from both iPod Touchs and implement this information into the text file by time and date stamp. I am sorry that I can't be of more help.

Ditto
 

Put me down in favor of exporting to Excel. That couldn't be easier to implement, I'm sure. You can also copy and paste your date straight from the website into a text editor, and then do a series "Find and Replace" actions (for example, find "BG" and replace with "BG" + TAB).

Importing into Excel or Access is fairly simple to do, however, we would benefit greatly if the format of the CSV file could be tweaked. In order for Excel or Access to import the Date and Time fields they need to be in a format of mm/dd/yyyy hh:nn:ss. Currently they are broken into mmm dd, yyyy, hh:nn AM. With this format you can only import as text fields and therefore cannot create meaningful graphs/reports. I've tried many of these applications and GB is the best I've tried so far. It just needs a few tweaks. If GB could provide the Date/Time field as ONE field formatted as mentioned above, it would be a great improvement.

Importing into Excel
 

A couple of things:

If you have a large log, it will be truncated to around 3800 characters when emailing.

It would also be nice if the values were strictly numeric (ex: 140) vs alphanumeric (ex: 140 mg/dL). I would like to graph the out of bed values over time to determine if the Metformin is doing its job. Do trend lines, etc.

Try Copy/Past from Website to Excel. You'll have to format the results to match your older Excel logs.

I agree, we desire a flexible CSV format in order to use this data more effectively. (BTW: Watchout, your competitors at ``iabetics'' are offering this feature).

Jeff;

As always, You are the man! :D

Another vote for flexible export
 

I want to be able to track my BP, weight, and diet info and especially for diet info I don't think any Diabetic log is going to be able to compete with the diet apps out there. Instead I combine Glucose data with my diet app's data with my Blood Pressure App's and exercise App's data so I can see it all in one place, side by side.

Glucose Buddy's email feature is nice but there's no 'type' or 'label' column that lets me distinguish MEDs from Glucose from exercise.

The logs view on the web site lets me filter for a particular type of data but the only way to get that data exported as far as I can tell is to cut and paste it and then edit each page by hand.

Excel Export
 

GREAT feature - you guys listen, and act.

Thank you.

Couldn't be better
 

This is pretty nice, very easy to use.

Yes, it works very well Jeff. You did a great job!

Has there been a change to the export? I was able to download the other day and it will not allow tonight. It eather hangs in excel or says another users has the file locked.

Thanks for the great app guys. I am really enjoying it. It has been very handy since I am dong a clinical study on a new drug right now and now have a way to keep track of anything that is going on with me.

Thanks again and great job,

Shane

xnavy727;

Welcome to the Forum!

There has been no change to my knowledge. After your post I did download my information. It worked just fine, but I did have to re-log in for some reason. I just thought that I would let you know. You may want to try the download again to see if it works for you.

Thanks Danny. I will give that a try.

Jeff;

I had to log back in at ~9:02pm, if that helps. :)

Jeff;

The one hour inactivity would not surprise me. I am sure that is the case.

confused
 

ry the new export logs feature by clicking either the "Export All Logs" link or the "Export Filtered Logs" link found on your logs pages .. This will convert your logs into CSV format (optionally filtered as you wish).


ok..i may be a dumb blond..but I can't find where you "export all logs" or Export Filtered Logs" in the program..can someone help me? I find under tools-reports-cvs and then say "past week" how do i export filtered logs? Can I set it up so that I have say all my fasting in one column and before lunch/after lunch etc all in columns..my dr wants to be able to look down a row for each time of day and see how they were..hope that makes sense..

cindy

I really like that I can download my logs. Unfortunately it's been awhile since I tried to graph from a spreadsheet and todays versions of Excel are downright useless. I can't create a meaningful graph to save my soul.

Would it be possible for someone more knowledgable to make some kind of template that could help produce a graph that allows one to see the correlation between the different variables over time?

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?

Date formats for Excel
 

I'd like to make a suggestion re excel importing:

It would be handy if the time was in a separate column to the date in the CSV file, I graph my BGs with the time taken.

Further, I am Australian - we do dates: dd/mm/yy rather than mm/dd/yy... my Excel doesn't recognise mm/dd/yy as a date and I have to change it (maybe because the time is in there too its too much for it?). The option to chose a date format preference would be good (I'd rather not have to change excel, or the way I read dates its far too confusing...)

loving it otherwise!

I'd like to make a further suggestion re excel exporting.

I noticed that I can view my logs by today, 2 weeks, 30 days but however cannot view them by calender month. Would be great if I could view them by calender month as this is how I store it and how I display the information to my physician. If possible could you guys make this feature too.

Fellow Glucose Buddy users, there is a lot of discussion about the export to Excel. The export to email approach works just fine

Most of the relevant comments pertain to transforming character date information into excel "date" which is done by using the excel character to date conversion function.

Glucose Buddy: Please try to prioritize software development requirements to items that make things better for many people. Example, bidirectional sync with the server that enables multiple iPhones, iPads, etc. to be utilized for the same person.