Diabetesinfo-Forum

SiDiary => SiDiary English => Thema gestartet von: bluejay-woman am Januar 31, 2012, 20:23

Titel: Importing Accu-Chek 360 cvs - Modify the data before import.
Beitrag von: bluejay-woman am Januar 31, 2012, 20:23

I could not find a thread about this in English...

I did see in German that the Events and Comments are not imported because they are plain text.

Do you have some info on the how I could edit the CSV file before import to fix this?

What column does sidiary look for and what format?

Titel: Re: Importing Accu-Chek 360 cvs - Modify the data before import.
Beitrag von: Alf am Februar 01, 2012, 08:43

SiDiary will use the field "KETONE" to populate the event data type.
 
This is kind of historical issue since version 5 didn't had the event marker field but the ketone datatype only. Version 6 reused this field and can now handle all of the defined events and store them in that record type.
 
Note: SiDiary will import all values from the KETONE field as they are given but you should ensure that they match to the KEY-definitions in the event screen (Diabetes Profile->Events)!

Titel: Re: Importing Accu-Chek 360 cvs - Modify the data before import.
Beitrag von: bluejay-woman am Februar 01, 2012, 16:52

Can you post an example of how to format the info in the Ketones field?

Titel: Re: Importing Accu-Chek 360 cvs - Modify the data before import.
Beitrag von: Alf am Februar 01, 2012, 17:27

Pleas refer to my post to the other csv-import thread: http://www.forum.diabetesinfo.de/forum/index.php/topic,7970.msg305637.html#new (http://www.forum.diabetesinfo.de/forum/index.php/topic,7970.msg305637.html#new)
 
This samples includes an event record to be imported "BV" which is the German abbreviation for "Forgot Bolus"...