JonMisurda

In order to deal with my hypoglycemia (not diabetes) I purchased an Accu-Chek Active glucose meter. Working with the information I found on the internet, I made a program to download the results to your PocketPC and save them as a CSV file.

GlucoComm is an application to download your glucose readings from the Accu-Check Active glucose meter. It may work with other models from Accu-Check that have an IR port, but it has not been tested. It will likely not work with other brands.

Currently version 1.0 will download all records from the meter, and allows for saving in a Comma Seperated Values (CSV) file that most spreadsheets can open. (On the PocketPC, Pocket Excel cannot, but SpreadCE and PlanMaker can.)

Download it from http://www.cs.pitt.edu/~jmisurda/ppc.../GlucoComm.htm

I plan to update it in the future as I get time and add more features. I don't plan on making this program a diabetes diary, but I'll see what your suggestions are.

I have only tested it with an Axim x50v running WM2003SE and an Accu-chek Active meter. Let me know if it works for you.

Jon

JonMisurda

Version 1.1 is now released that adds the ability to select records and paste them into Pocket Excel, and now has a VGA icon.

Download at: http://www.cs.pitt.edu/~jmisurda/ppc/

If anyone has found this program useful, or has suggestions, let me know.

Jon

Xanlexian

Originally Posted by JonMisurda

Version 1.1 is now released that adds the ability to select records and paste them into Pocket Excel, and now has a VGA icon. Download at: http://www.cs.pitt.edu/~jmisurda/ppc/ If anyone has found this program useful, or has suggestions, let me know. Jon

Hello Jon,

When I tap one the green arrows, I get the following error message:

(title bar) COM2:
Invalid File Handle



I have the Accu-Chek Compact. To initiate IR transfer mode, I just press my SET and MEM buttons together. Then I get little arrows on the screen.

I've been waiting for a program like this for quite some time!

Please please please tell me that this is some stupid setting I have yet to set -- and not an incompatable meter!

Thanks!
--Alex

JonMisurda

Hmm, thats a problem with my code thats trying to open the IR port. I thought I had it correct to determine the COM port of the IR device automatically.

What model of PDA do you have?

(Oh and don't worry, its not getting to the communication part yet, so its not a compatability issue.)

Jon

JonMisurda

Oh I've figured it out. I see you have an x50v too.

What you need to do is to go to Start->Settings->Connections->Beam and uncheck the box "Recieve all incoming beams"

That setting keeps the port open and reserved at all times, and thus my program is unable to open it. I just tested it by checking it and got the same error message.

Jon

Xanlexian

Originally Posted by JonMisurda

Hmm, thats a problem with my code thats trying to open the IR port. I thought I had it correct to determine the COM port of the IR device automatically. What model of PDA do you have? (Oh and don't worry, its not getting to the communication part yet, so its not a compatability issue.) Jon

I'm using the X50v -- 2003SE, ROM version A05. If it makes any difference, the hardware version is A03.

I'd reallllly like to use this!! The IR part was where I was having a problem. Once I can transfer the data into the X50v, I can manipulate the data from there. The diary program I actually use is SiDiary (version 5 beta -- since you have to pay for version 5 final).

This little program of your's is precisely what I have been looking for!!!

Thanks for all the work you've done on this, as well as all of the other programs you've written!

--Alex

Xanlexian

heh, seems like we posted at the same time!! I'm giving it a try right now!! Will post the results in a few minutes!

Xanlexian

HAH!!! This is ***GREAT***!!!!

Works like a champ!!!

This is absolutely amazing, Jon! I simply can not thank you enough!!

PM me an email address -- I'll **GLADLY** donate to you for this! You have no idea how much time your program will be saving me!!

On an interesting side note -- my meter will not read a blood/glucose reading higher than 600. If it is higher than that, it just flashes "HI". Your program shows that the times I WAS over 600 (quite frequently, as a matter of fact) -- it has actual readings!! One being 634, the other 712. Simply amazing!

You rock, Jon!


MOST sincerely,
--Alex

EDIT: I can confirm that this program works with the X50v/A05 ROM/A03 HW and the Accu-Chek Compact glucometer.

JonMisurda

Glad it works with the Compact too. I think it's safe to say it'll will work with all the Accu-chek line then. What I will do is in the next version replace the user-cryptic "Invalid File Handle" with a suggestion to check the Beam setting.

I don't accept money for my programs, if you want to donate theres a link to a cystic fibrosis charity on my main page: http://www.cs.pitt.edu/~jmisurda/ppc/

As for the HI readings, I wouldn't put much faith in their numerical values since the machine is likely only certified for that calibrated range. Also its limited to 3 digits, so anything more may display as junk (but with a glucose of >999 you have bigger things to worry about.) LO registers as 000 (i've gotten that and haven't figured out if its from too little blood or below the range.) Also, control readings show up in the record too. You'll have to distinguish them manually.

Glad it works, I'll update the webpage with the information and make a new version tonight possibly. Watch the thread.

Jon

Xanlexian

Originally Posted by JonMisurda

I don't accept money for my programs, if you want to donate theres a link to a cystic fibrosis charity on my main page: http://www.cs.pitt.edu/~jmisurda/ppc/

Then the Cystic Fibrosis charity/foundation will receive a donation by tomorrow morning. Plain and simple.

Quote:

As for the HI readings, I wouldn't put much faith in their numerical values since the machine is likely only cerified for that calibrated range. Also its limited to 3 digits, so anything more may display as junk (but with a glucose of >999 you have bigger things to worry about.) LO registers as 000 (i've gotten that and haven't figured out if its from too little blood or below the range.) Also, control readings show up in the record too. You'll have to distinguish them manually.

I routinely have extraordinarily high readings. Hence all my darned trips to the ER/ICU. Yet, oddly enough, I've been here in England for the last week -- and I haven't had to inject NEAR the amount of insulin I had to back in the states. The vast majority of food here just doesn't have the super-high carb content as the foods in the US. I didn't expect that.

Quote:

Glad it works, I'll update the webpage with the information and make a new version tonight possibly. Watch the thread. Jon

Again, the time you have saved me here is just astounding. As someone who has to test upwards of ten times a day, this guarantees (as much as software in general will allow) that my entries in SiDiary will be much more accurate. I've caught myself entering entries in the wrong areas before. heh.

Again -- MOST sincerely,
--Alex

JonMisurda

So I think the next issue to tackle with this program is data export. So far it can save into a CSV file and can copy selected regions to the clipboard to paste into PocketExcel.

Does SiDiary have any way to load readings from a file?

When you input manually do you do this one value at a time?

I can make it selectable so that you only copy, say the reading and not the time or date, would this be useful?

I'm just looking for suggestions on getting the data out of my program and into others.

Jon

JonMisurda

Version 1.2 is up on the website: http://www.cs.pitt.edu/~jmisurda/ppc.../GlucoComm.htm

This version has a more helpful message on the program failing to get the IR port, and now is HI_RES_AWARE with VGA toolbar icons.

This will be the last release in the 1.x line. The 2.x line will focus on adding new features, as suggested here.

Thanks,

Jon

Randy C

I've downloaded the GC 1.2 CAB file. All that seems to be there are three files: GLUCOC~1.000 (1K, dated 10/11/05), GLUCOC~1.001 (28K, dated 10/11/05), and GSGETF~1.002 (35K, dated 07/07/04). At the risk of sounding like a total nincompoop, how to I make this into a program that will run on my X50v? I would have thought the CAB would have contained an EXE file that would run.

Thanks for all your efforts. Any help on this would be greatly appreciated.

Randy Coffelt
r_coffelt@sbcglobal.net

JonMisurda

CAB files are installers that are meant to run on the pocketpc itself. You opened it up on the desktop like a zip file, and one of those files (GLUCOC~1.001 I'd guess) happens to be the exectutable just renamed, but we really need to install this rather than extract it.

To install, copy the CAB file to your pocketpc using ActiveSync, tap on it in file explorer on your device, and it should install for you.

Jon

Xanlexian

Originally Posted by JonMisurda

Version 1.2 is up on the website: http://www.cs.pitt.edu/~jmisurda/ppc.../GlucoComm.htm This version has a more helpful message on the program failing to get the IR port, and now is HI_RES_AWARE with VGA toolbar icons. This will be the last release in the 1.x line. The 2.x line will focus on adding new features, as suggested here. Thanks, Jon

Sorry for the lack of response. I've been in Holland for the past week (I'm still thousands of miles away from home, though).

As far as features go, the only thing I can think of that'd be nice would probably an "append to existing records" whilst transferring the info from the glucometer to the PDA. CSV is perfectly fine for me. Maybe a plain text file? Or I guess RTF, so you have accurate line breaks?

Appending would be wonderful. Outside of that, your program does PRECISELY what I bought my PDA for in the first place. (yeah, yeah, yeah... I should have done research. I was going to develop something myself, but just never had the time)

--Alex