I use a Bayer Ascencia meter, which means I use WinGlucoFactsPro.
While it’s not a bad program, I would, on occasion like to play with the numbers myself. The powers that be did not include an export function in the program however.
I’ve figured out the following for getting the data OUT of WinGlucoFactsPro so that it can be opened in Excel or whatever spreadsheet application you prefer.
It turns out the WGFP program stores your data as an access file. If you have access, you should be able to just use it to open the file and do what you like.
If like me, you don’t have access, you have to be tricky.
This is what I do when I want to export my results.
1.) I downloaded a free MDB viewer application - I use MDB View, but there are probably others. http://www.softpedia.com/get/Internet/Servers/Database-Utils/MDB-View.shtml
2.) Go to your WGFP program folder
Mine is at C:\Program Files\WinGlucofacts Professional 3.03\data
3.) Look for a file named Your Name.Dex That’s the data file.
4.) Copy the file and name the copy Your Name.MDB
5.) Run MDB view (just click on mdbview.exe) and close the nag screen.
6.) Go to File->Open and select the mdb file you made in step 4
7.) Go to File->Export as CSV and select the directory you want to put the export files into.
You’ll now have a bunch of files named things like Your Name.mdb - Data.csv, Your Name.mdb - Medication.csv
The one named ‘Data.csv’ contains your blood meter results. You can now open it in any spreadsheet application
The file will have no headings. The column titles are:
Date & Time, Glucose, Meter Type, User Entered, Delete, Event, Control, Pre Meal, Post Meal, Exercise, Diet, Special, Stress, Symptom, Illness, Insulin, InsulinA, Comment, Flag_OK, Checksum
Many of these you can ignore, but several of them tie into special features of your meter, like the ‘Pre meal’ and ‘Post Meal’ flags.
What you do with the data from here is of course, up to you.
I’d like to get a copy of an export file made by One Touch Diabetes Management Software - then I could write a script to upload into SugarStats.com.
Nice writeup Laura, thanks.
I use an Aviva and was given a copy of Accu-Chek Camit Pro 2.3 with my infrared data cable by my Diabetes education program. I used he cable to upload to Roche’s online Diabetes Assistant but didn’t pursue it further until my current stint on Workman’s Comp, when I tried out the Camit Pro. Its installation failed immediately
after the language choice, with an error message box titled “Get Borland Database String Value”, and reading “Unable to read string CONFIGFILE01.” Roche refused to give any help, saying the software was only supported for physician use, so I downloaded WinGlucoFacts Pro and have been entering my datapoints there both ongoing and from a pdf printout of a Diabetes Assistant report of my readings. Roche’s customer service sucks, as usual, for the end consumer. When I asked about reprogramming a Canadian Aviva that read in mmol/dl they kindly offered to sell me a new one at full price. And if you have old strips they not only won’t let you exercise your discretion to use them anyway instead of throwing them away, they lock up the whole meter so you can’t get at you preexisting data until you realize unaided that you can unlock the meter by removing the expired chip. (Once you’ve bought new strips with a new chip the expired strips work just fine, btw.) Anyway, thanks for the info about decoding the .DEX file. Also look at Startseite - Mediaspects.