Autor Thema: Importing CSV files into SiDiary 6...  (Gelesen 18610 mal)

Offline Joerg Moeller

  • Administrator
  • Special Member
  • *****
  • Beiträge: 16763
  • Country: de
  • Ohana heißt "Familie"...
    • Diabetesinfo
  • Diabetestyp: DM 1
  • Therapie: Insulin-Pumpe
Re: Importing CSV files into SiDiary 6...
« Antwort #10 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 )
Meine Seite über Diabetes: http://www.diabetesinfo.de/
Meine Facebook-Seite: https://www.facebook.com/Diabetesinfo.de/

Offline Alf

  • Administrator
  • Special Member
  • *****
  • Beiträge: 6237
  • Country: 00
  • Mein Name ist Shumway. Gordon Shumway.
    • Diabetikertagebuch
  • Diabetestyp: ---
  • Therapie: ---
Re: Importing CSV files into SiDiary 6...
« Antwort #11 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... :)
DM 1, ICT mit Lantus/Humalog/Insuman Rapid, Freestyle Libre, SiDiary Win & Android
Diabetes Software, Windhorst, Helden der Kindheit

Offline bluejay-woman

  • Jr. Member
  • **
  • Beiträge: 13
  • Diabetestyp: DM 2
  • Therapie: Diät
Re: Importing CSV files into SiDiary 6...
« Antwort #12 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.

Offline Alf

  • Administrator
  • Special Member
  • *****
  • Beiträge: 6237
  • Country: 00
  • Mein Name ist Shumway. Gordon Shumway.
    • Diabetikertagebuch
  • Diabetestyp: ---
  • Therapie: ---
Re: Importing CSV files into SiDiary 6...
« Antwort #13 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:
 
DM 1, ICT mit Lantus/Humalog/Insuman Rapid, Freestyle Libre, SiDiary Win & Android
Diabetes Software, Windhorst, Helden der Kindheit

Offline bluejay-woman

  • Jr. Member
  • **
  • Beiträge: 13
  • Diabetestyp: DM 2
  • Therapie: Diät
Re: Importing CSV files into SiDiary 6...
« Antwort #14 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

Offline bluejay-woman

  • Jr. Member
  • **
  • Beiträge: 13
  • Diabetestyp: DM 2
  • Therapie: Diät
Re: Importing CSV files into SiDiary 6...
« Antwort #15 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.

Offline Alf

  • Administrator
  • Special Member
  • *****
  • Beiträge: 6237
  • Country: 00
  • Mein Name ist Shumway. Gordon Shumway.
    • Diabetikertagebuch
  • Diabetestyp: ---
  • Therapie: ---
Re: Importing CSV files into SiDiary 6...
« Antwort #16 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... ;)
DM 1, ICT mit Lantus/Humalog/Insuman Rapid, Freestyle Libre, SiDiary Win & Android
Diabetes Software, Windhorst, Helden der Kindheit