6.3.4.1     Import from a CSV-file

 

SiDiary is able to import from SiDiary’s csv-format, which is also used with the export of data.

 

 

The structure of the SiDiary own file-format is as follows: The csv file must use the same fields, which SiDiary uses also with the csv export as field names. The sequence of the fields is not important, but the field name must be typed ACCURATE:

Example:

DAY;TIME;KETONE;BG_LEVEL;CH_BE_KHE;BOLUS;BASAL;BLOODPRESSURE;

REMARK

 

Description of the possible fields:

DAY – date (in date format of your system setting)

TIME – Time

KETONE – Ketones

BG_LEVEL – blood glucose level in mg/dl

BG_LEVEL_MMOL – blood glucose level in mmol/l

CH_BE_KHE – Amount of meal (Exchange BE or KE/KHE)

CH_GR – Amount of meal in gram carbohydrates

BOLUS – Bolus dose

BASAL – Basal dose

BLOODPRESSURE – (Format „Syst./Diast.“)

REMARK – Remarks

WEIGHT_LBS – weight in lbs (=engl. Pound)

WEIGHT_KG – weight in kilogram

 

You can also copy the field syntax from the csv export templates of SiDiary, in the folder Templates\export (just open it with notepad).

 

It is not possible to import csv-files which were generated from other programs, which are not in the format described above!

 

Hint

If you have text data or CSV data in another format, you can transfer it very simply e.g. with MsExcel to the SiDiary format and transfer your data from other programs. For further information about converting e.g. from MsExcel, please see the appropriate manual. A lot of users provide their knowledge about this in SiDiary’s forum, too!