Diabetesinfo-Forum

SiDiary => SiDiary English => Thema gestartet von: salvation.tower am Juli 15, 2009, 03:01

Titel: Importing CSV files into SiDiary 6...
Beitrag von: salvation.tower am Juli 15, 2009, 03:01
Hi there,

I'm trying to upload the Data from my Optium Xceed into SiDiary6,  I've got the columns correct (after looking in the help file), but for some reason it is changing the BG value

for example (some values from May this year)

DAY;TIME;KETONE;BG_LEVEL;CH_BE_KHE;BOLUS;BASAL;BLOODPRESSURE;Weight;Exercise;REMARK
2/05/2009;10:41;;5.4;;;;;;;
2/05/2009;9:22;;3.7;;;;;;;
2/05/2009;0:28;;21.8;;;;;;;
1/05/2009;19:12;;1.7;;;;;;;
1/05/2009;13:21;;5.9;;;;;;;
1/05/2009;5:26;;3.3;;;;;;;

they show up with correct dates and time but the values are incorrect... (i've just edited the values as they appear in SiDiary after the import...)

DAY;TIME;KETONE;BG_LEVEL;CH_BE_KHE;BOLUS;BASAL;BLOODPRESSURE;Weight;Exercise;REMARK
2/05/2009;10:41;;0.9;;;;;;;
2/05/2009;9:22;;0.3;;;;;;;
2/05/2009;0:28;;1.2;;;;;;;
1/05/2009;19:12;;0.2;;;;;;;
1/05/2009;13:21;;0.1;;;;;;;
1/05/2009;5:26;;0.3;;;;;;;

there doesn't seem to be any correlation (ie it's readingythe vlues backswards or anything... i'm confused!...  :'(

Titel: Re: Importing CSV files into SiDiary 6...
Beitrag von: Joerg Moeller am Juli 15, 2009, 10:04
Why don't you upload the data directly from the meter? In the meter list it's called 'Abbott Precision Xceed'
Titel: Re: Importing CSV files into SiDiary 6...
Beitrag von: salvation.tower am Juli 15, 2009, 10:31
I'm running SiDiary on Windows7 64bit and the cable doesn't work... Is there and easy way to transfer data between installs of sidiary? (if i do an import of the meter on my vista 32bit machine) how easy is it to transfer the data to my main install on Windows 7???,

last time i tried this it would read the meter but generate errors for how ever many records were on the meter... (but that was on SiDiary 5...)
Titel: Re: Importing CSV files into SiDiary 6...
Beitrag von: Joerg Moeller am Juli 15, 2009, 11:23
I'm running SiDiary on Windows7 64bit and the cable doesn't work...

Yes, in this case you would need a 64Bit driver for the cable. I would try a 64Bit Vista driver, this should work.

Zitat
Is there and easy way to transfer data between installs of sidiary?

Yes by manually copying the files from one data folder to the other.  But it's only possible from V6 to V6 or V5 to V5

If you intend to import your meter on your 32Bit machine and then transfer it to the 64Bit one I would use the SiDiary CSV Export-Function and then the SiDiary-Import.
Titel: Re: Importing CSV files into SiDiary 6...
Beitrag von: salvation.tower am Juli 15, 2009, 11:29
Good Idea... I will try that...

any idea why the import would be deciphering the figures wrong??? (more as a matter of wondering now...)
Titel: Re: Importing CSV files into SiDiary 6...
Beitrag von: salvation.tower am Juli 15, 2009, 12:37
I have done the import from the meter into SiDiary. the values look all OK.

then do the export to csv, copy the csv file over to my 64bit PC..

import an the same thing happens.. it does the import all OK, but the  values are all wrong...

maybe an issue in the import template/process???
Titel: Re: Importing CSV files into SiDiary 6...
Beitrag von: Joerg Moeller am Juli 16, 2009, 08:12
Or maybe the wrong settings in your profile?
Titel: Re: Importing CSV files into SiDiary 6...
Beitrag von: salvation.tower am Juli 16, 2009, 11:01
I have figured out what the issue is... not sure where to correct it.

but i record my levels in mmol/L and when it imports them it is converting them to mg/dL, as far as i can tell my profile is all set at mmol/L

as a suggestion maybe the csv file should have a tag/field to determine which values are which?? as i'm guessing most users would use one or the other but not both...???
Titel: Re: Importing CSV files into SiDiary 6...
Beitrag von: Joerg Moeller am Juli 17, 2009, 06:40
I guess I know on which point it starts to fail, but I'm afraid I must ask you to wait a while befor we can fix it. But it's on our ToDo-list, promised!

In the meantime you could try to transfer the data from both versions by using SiDiary Online (https://diabetes.sinovo.net/)

Or you can try to find a 64Bit driver for your cable
Titel: Re: Importing CSV files into SiDiary 6...
Beitrag von: salvation.tower am Juli 17, 2009, 08:56
Cool no worries.. (if it's on the list that is cool) once i figured out what was happening, i manually calculated the value to their mg/dL value and re-imported...

I've asked abbott/medisense about 64bit drivers but haven't had a response yet... windows 7 detects the device, but doesn't know
what to do with it... (something about virtual com ports (which i don't know how to create))

i did look at the online profile and it was set as mg/dL so maybe somewhere in the mix it has thought values were something else...

i stumbled on siDiary awhile ago (and bought v5, and now v6) it's been fantastic... so much easier that writing it down in a book!...
congrats for the fantastic program...
Titel: Re: Importing CSV files into SiDiary 6...
Beitrag von: Joerg Moeller am Juli 17, 2009, 12:11
...but doesn't know what to do with it... (something about virtual com ports (which i don't know how to create))

These virtual com ports are created by the driver which comes with the cable. But as said: a 64 system urgently needs a 64 driver.

But maybe you can get a normal com-cable somewhere. These cables need a hardware com port, but no driver. On the other hand you can use them with an adapter com2usb, and it's much easier to find a 64 driver for an adapter. Especially if it has a prolific chip, because then you can use a sitecom driver: http://www.sitecom.com/drivers.php

Zitat
i stumbled on siDiary awhile ago (and bought v5, and now v6) it's been fantastic... so much easier that writing it down in a book!...
congrats for the fantastic program...

You're too kind :rotwerd:

(Bur I always love to hear that ;D )
Titel: Re: Importing CSV files into SiDiary 6...
Beitrag von: Alf am Juli 17, 2009, 17:22
Please download the latest package from out server. The csv-import will now support the field BG_LEVEL_MMOL... :)
Titel: Re: Importing CSV files into SiDiary 6...
Beitrag von: bluejay-woman am Januar 31, 2012, 22:25
Sorry to jump in at the end...

I can get my data to import from a CVS file just fine, except the REMARK field. Sadly that was the only field that I was trying the manual import for because the import from my meter loses that data.
Titel: Re: Importing CSV files into SiDiary 6...
Beitrag von: Alf am Februar 01, 2012, 08:52
I tried that a second ago and everything worked as designed so I assume that ther's a problem with the csv file (delimiter, wrong column etc.)!?
 
That was the content of my test file:
 
DAY;TIME;KETONE;BG_LEVEL;CH_BE_KHE;BOLUS;BASAL;BLOODPRESSURE;Weight;Exercise;REMARK
04.01.2012;;;;;;;;;;Forgot the bolus shot for lunch. :(
04.01.2012;07:05;;64;6;8;;;;;
04.01.2012;12:05;BV;113;9;;;;;;

 
And that was the resulting import screen:
 
(http://www.sidiary.org/snapshot/0JX4PW6WP.png) (http://www.sidiary.org/ssc.asp)
Titel: Re: Importing CSV files into SiDiary 6...
Beitrag von: bluejay-woman am Februar 01, 2012, 19:34
I tried that a second ago and everything worked as designed so I assume that ther's a problem with the csv file (delimiter, wrong column etc.)!?
 
That was the content of my test file:
 
DAY;TIME;KETONE;BG_LEVEL;CH_BE_KHE;BOLUS;BASAL;BLOODPRESSURE;Weight;Exercise;REMARK
04.01.2012;;;;;;;;;;Forgot the bolus shot for lunch. :(
04.01.2012;07:05;;64;6;8;;;;;
04.01.2012;12:05;BV;113;9;;;;;;

 
And that was the resulting import screen:

Thanks for the help on the layout. I got an error with my import: "No values!"

Here is the data. Do I use German format for the date and time or USA format?

DAY;TIME;KETONE;BG_LEVEL;CH_BE_KHE;BOLUS;BASAL;BLOODPRESSURE;Weight;Exercise;REMARK[LIST_START_2]
31.01.2012;22:36;BL;101;64;1;;;;;
01.02.2012;09:07;AB-;139;;;;;;;
01.02.2012;;BB;;54;1;;;;;
01.02.2012;05:25;FBG;108;;;;;;;6:49
Titel: Re: Importing CSV files into SiDiary 6...
Beitrag von: bluejay-woman am Februar 01, 2012, 21:36
I figured out the right time and date format and everything is working great. Even figured out to use a pipe (|) to get the exercise info in right.
Titel: Re: Importing CSV files into SiDiary 6...
Beitrag von: Alf am Februar 02, 2012, 08:25
Great!
If you still got problems with the remark import please remove the placeholder [LIST_START_2] at the end of the first row. This is a placeholder for the export-template only... ;)