6.6. Import/Export formats

Import/export formats for Logbook entries (Simple)
Diabetes:M provides simplified import from tab delimited CSV file. The simple import format of the file is:

Datetime;Glucose;Bolus;Basal;Carbs;Notes
2018-07-23 12:15;5.6;12;13;44;note1
2018-07-24 11:11;150;11;0;0;note2
2018-07-25 10:15;5.2;0;16;44;note3

!The format for the date and time is: yyyy-MM-dd HH:mm
The glucose can be in both mg/dL and mmol/L

Import/export formats for Logbook entries

Diabetes:M provides export and import to and from tab delimited CSV file.

You can download a sample file from here:
https://cdn.manula.com/user/14415/docs/import-template-new.csv

Here are some notes on the file format:

DateTime format is yyyy-mm-DD HH:mm:ss (year-month-day 24hour:minutes:seconds)

Glucose is in mmol/L

Weight is in kilograms

The bolus_insulin_type must be exactly one of these indexes:

The basal_insulin_type must be exactly one of these indexes:

Category must be exactly one of these indexes:

Exercise_index must be exactly one of these indexes:

Medications format

[{""medication_id"":0,""name"":""Metformin"",""dose"":""1"",
""dose_unit"":""mg"",""user_id"":0,""default_quantity"":1.0,""quantity_unit"":""ml"",
""deleted"":false,""last_modified"":0,""input_id"":0,""quantity"":1.0}]"

*The fastest way to see the export/import format is to enter few entries in Diabetes:M, do Export Data (CSV) and see the file.

A working template is attached to that page so it can be downloaded and can be used to produce your own import file. To see the file in the text format described above, open it with NotePad or other text editing program.

Old Import format for Logbook entries (still working, use the template in the end of the paragraph)
Diabetes:M provides export and import to and from tab delimited CSV file.

You can download a sample file from here:
https://cdn.manula.com/user/14415/docs/import-template.csv

Here are some notes on the file format:

Where \t is the tabulator symbol, \n is the carriage return symbol.

DateTime format is dd.MM.yyyy HH:mm:ss (day.month.year 24hour:minutes:seconds)

Glucose is in mmol/L

Weight is in kilograms

The BolusInsulin must be exactly one of these strings (the symbol ® may be omitted):

The BasalInsulin must be exactly one of these strings (the symbol ® may be omitted):

Category must be exactly one of these strings:

Exercise must be exactly one of these strings:

Medications format

[pills]x [medication name] ([dose])|[pills]x [medication name] ([dose])|[pills]x [medication name] ([dose])|...|
[pills]x [medication name] ([dose])

Example:
02x Metformin (500mg)|01x Actos (15mg)

Example:

Total Records\t2
No\tDateTime\tGlucose\tCarbs\tBasalValue\tBolusValue\tBasalInsulin\t
BolusInsulin\tNotes\tCategory\tWeight\tCarbRatio\tSensitivity\tMedications\t
WeightEntry\tHbA1c\tSystolic\tDiastolic\tPulse\tExercise\tDuration\tComment
0\t28.06.2013 11:54:49\t2.0\t20\t8.0\t6.0\tLantus®\tHumalog®\tnote1\t
After breakfast\t81.0\t11.0\t2.0\t02x Metformin (500mg)|01x Actos (15mg)1\t
28.06.2013 08:51:39\t5.0\t10\t12.0\t11.0\tLantus®\tHumalog®\tnote2\t
Before breakfast\t81.0\t11.0\t2.0\t02x Metformin (500mg)\t83.0\t6.9\t130\t80\t
75\tJogging\t60\tearly morning 

A working template is attached to that page so it can be downloaded and can be used to produce your own

import file. To see the file in the text format described above, open it with NotePad or other text editing program.

A sample import file could be downloaded from the next location:
https://cdn.manula.com/user/14415/docs/import-template.csv

Import/export format for foods
The easiest way to import foods in Diabetes:M is to use the sample file below and have in mind that you need to change a few things:

• No column must be incremented by 1 for every new row
• Total records on the first line must match records count in the file
• ID’s column must be unique (increment every row’s ID by 1)
• Date column contains date + time in timestamp format and the ID must be unique. You can convert your dates here http://www.epochconverter.com/. or just use the last row’s date
• Food’s categories are added by their index and the indexes are in the list below |#00.Beans and Legumes|#01.Beverages|#02.Breads and Cereals|#03.Cheese, Milk and Dairy |#04.Deserts|#05.Eggs|#06.Fast Food|#07.Fruits |#08.Nuts and Seeds|#09.Pasta, Rice and Noodles|#10.Salads|#11.Sauces, Spices and Spreads |#12.Snacks|#13.Soups|#14.Vegetables|#15.Meat |#16.Fish and Seafood|#17.Other|#18.User Added Food

The columns that you need to take care of are colored. A sample food import file can be downloaded from here:
https://cdn.manula.com/user/14415/docs/mydiabetes-food-export-201612301630.xls