FREE!Sign Up Log In Download



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 01-25-2010, 05:55 PM
mhstar99 mhstar99 is offline
Junior Member
 
Join Date: Jan 2010
Posts: 1
Default 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
Reply With Quote
  #2  
Old 01-25-2010, 09:39 PM
lmadsen lmadsen is offline
Junior Member
 
Join Date: Jan 2010
Posts: 1
Default 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...
Reply With Quote
  #3  
Old 01-26-2010, 02:44 PM
dano dano is offline
Super Moderator
 
Join Date: Jan 2010
Location: South Central Kentucky
Posts: 3,909
Default

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!
__________________
Regards;

Danny

Last edited by dano; 02-01-2010 at 04:48 PM.
Reply With Quote
  #4  
Old 01-26-2010, 05:17 PM
mpace mpace is offline
Junior Member
 
Join Date: Jan 2010
Posts: 4
Default

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.
Reply With Quote
  #5  
Old 01-26-2010, 06:12 PM
dano dano is offline
Super Moderator
 
Join Date: Jan 2010
Location: South Central Kentucky
Posts: 3,909
Default

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.
__________________
Regards;

Danny
Reply With Quote
  #6  
Old 02-01-2010, 09:07 PM
newbeginning newbeginning is offline
Junior Member
 
Join Date: Feb 2010
Posts: 3
Default 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).
Reply With Quote
  #7  
Old 02-23-2010, 09:39 PM
dobrecht dobrecht is offline
Junior Member
 
Join Date: Feb 2010
Posts: 3
Default 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.
Reply With Quote
  #8  
Old 03-31-2010, 04:45 PM
superchop superchop is offline
Junior Member
 
Join Date: Mar 2010
Posts: 1
Default

Try Copy/Past from Website to Excel. You'll have to format the results to match your older Excel logs.
Reply With Quote
  #9  
Old 04-05-2010, 11:23 PM
rebitzman rebitzman is offline
Junior Member
 
Join Date: Feb 2010
Posts: 1
Default Excel Export

GREAT feature - you guys listen, and act.

Thank you.
Reply With Quote
  #10  
Old 04-08-2010, 03:58 PM
dano dano is offline
Super Moderator
 
Join Date: Jan 2010
Location: South Central Kentucky
Posts: 3,909
Default

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

Danny

Last edited by dano; 04-08-2010 at 08:19 PM.
Reply With Quote
Reply

Tags
csv, excel, export all logs, export filtered logs

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Exporting to Excel: Separating date / time fields on CSV files bceaglejoe Glucose Buddy Specific (Questions/Support) 2 06-03-2012 03:53 PM
export logs horizontally? jcvkamp Glucose Buddy Specific (Questions/Support) 1 02-21-2011 08:27 PM
Exporting logs to Excel. Can it be done? clem Glucose Buddy Specific (Questions/Support) 1 08-30-2010 06:26 PM


All times are GMT. The time now is 07:36 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright © 2011 SkyHealth LLC. All rights reserved.