[Galiphrae]

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

[Llarian]

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

[Galiphrae]

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.

[Alf]

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

[Galiphrae]

Thanks.  I will give that a try.  Don't know how I missed it in the FAQ.

Ron

[Galiphrae]

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

[Alf]

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.
 

[Galiphrae]

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  

[Alf]

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.).

[evila]

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.-