Diabetesinfo-Forum
SiDiary => SiDiary English => Thema gestartet von: Galiphrae am Oktober 21, 2006, 18:33
-
I downloaded the DiabyteEN template and it looks good except that the BG readings seem to be multiplied by a factor of 10. (I use mmol/l) What should read 6.5 shows up as 65.0. Can anyone help me with this. I cannot figure out how to fix it in the template.
Thanks
Ron
-
I downloaded the DiabyteEN template and it looks good except that the BG readings seem to be multiplied by a factor of 10. WHat should reat 6.5 shows up as 65.0. an anyone help me with this. I cannot figure out how to fix it in the template.
Do you work with mmol/l and the template uses mg/dl?
Regards
Anja
-
This could be, although there are places in the template where it looks like it recognizes the units are mmol/l. If some Excel Guru could build a template that works in mmol/l, it would be very nice for those of us working in these units. If I understood what was happening better I would do it myself.
-
Hi Ron,
I don't think that the template is using a different unit for the readings because this would mean a ratio of 18.
Ratio 10 sounds like a known decimal placeholder problem:
Please check this FAQ entry and see if it could help...
http://www.sidiary.org/customerservice-faq-171.asp?IDSPrache=2
-
Thanks. I will give that a try. Don't know how I missed it in the FAQ.
Ron
-
I tried the changes as suggested in the faq and the numbers still export incorrectly. If I have a whole number BG like 5.0 it will export correctly. If the number is 5.1 it will export as 51.0 so it appears even stating the DecimalChar it is somehow being ignored unless the number after the deciaml is a 0.
Anyone else have any other thoughts on what I might be doing wrong?
Ron
-
Did you try both DecimalChar settings, the dot and the comma? Even if this setting would not correspond to your windows setting it might help when moving the data to Excel and the behaviour you have described sounds exactly like this.
:kratz:
-
Thanks, I have tried both the , and the . No luck with either. I moved the DecimalChar line in the ini file just in case. It still will not workfor me.
Thanks for the suggestions.
Ron
-
Ron,
then please drop us a line at the SINOVO-support. If you can provide some of your data files along with the Excel template file, we can try to reproduce the behaviour on our side with an appropriate machine. Please let us know, which locale settings you are using (datetime format, decimal settings etc.).
-
Hi Guys,
Just wondering whether you managed to solve this issue.
I've just registered my copy of SiDiary, and I'm having the same issue with the decimal point.
I've have done what you mention in your FAQ, and that has solved the problem for all other templates, but not for DiabyteEN
It does not seem to work well for mmol/l
Can you help?
Henry.-
-
Hi Henry,
well since the other templates are working fine it seems to be a specific problem of the diabyteEn-template.
Since the author is also writing in this board there's at least the chance thathe has some additional suggestions...
-
Hi Alf,
I did more testing and found out that what the issue seems to happen with any Excel template that uses [BLOOD_GLUCOSEX] or [24HXXBZ] . This paramaters don't seem to show the right decimal delimiter.
Hope this help determine what the problem is. It seems to be a problem with SiDiary and not with the template itself.
Cheers,
Henry.-
-
Hi Henry,
your investigations are absolutely right!
The decimal character replacement that youve successfully configured is a workaround especially for Excel, which should primarily use the data list type 2. The fieldnames you have mentioned are part of list type 1 and they were actually not designed for the excel-export...
(List_1 is exporting a list "Day-by-Day", List_2 is exporting a data list "Record-by-Record")
I will keep in mind if we can put the decimal replacement to the other fields too but we need to check the implications to this code fraction.
As a quick workaround you could try to modify your Diabyte-Template and enhance the Blood_Clucose place holders like that:
[BLOOD_GLUCOSE1$REPLACE(.~,)] or [BLOOD_GLUCOSE1$REPLACE(,~.)]
-
Hi Alf,
This worked! I'm a happy man now.
Thanks for your assistance,
Henry.-
-
You're welcome! :)