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

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:

-1 None 0 Other 1 Humalog® 2 Novolog®
4 Novolin® R 5 Humulin® R 13 NovoRapid® 15 Actrapid®
17 Regular 23 Insuman® R 25 Gensulin R 27 Liprolog®
31 U-500 37 Afrezza™ 38 Fiasp®

The basal_insulin_type must be exactly one of these indexes:


-1 None 0 Other 3 Apidra® 6 Lantus®
7 Novolin® N 8 Humulin® N 3 Apidra® 6 Lantus®
9 Levemir® 10 Novolog® 50/50 11 Novolog® 70/30 12 NovoRapid® 70/30
14 Insulatard® 16 NPH 18 Protaphane® 19 Novolog® 30/70
20 Novolin® 70/30 21 Tresiba® 22 Ryzodeg® 24 Insuman® N
26 Gensulin N 28 NovoMix® 30 29 NovoMix® 50 30 NovoMix® 70
32 Toujeo® 33 Humalog® Mix50/50™ 34 Humalog® Mix75/25™ 35 Mixtard® 30
36 Humulin® 70/30

Category must be exactly one of these indexes:


9 Fasting 0 Snack 1 Before breakfast 11 Breakfast
2 After breakfast 3 Before lunch 12 Lunch 4 After lunch
5 Before dinner 13 Dinner 6 After dinner 10 Before bed
7 Night 14 Before exercise 15 After exercise 8 Other

Exercise_index must be exactly one of these indexes:


-1 Select exercise 0 None 1 Other 2 Aerobics
3 Australian football 4 Backcountry skiing 5 Badminton 6 Baseball
7 Basketball 8 Beach volleyball 9 Biathlon 10 Biking
11 Boxing 12 Calisthenics 13 Circuit training 14 Cricket
15 Cross-country skiing 16 Cross skating 17 Curling 18 Dancing
19 Diving 20 Downhill skiing 21 Elliptical 22 Ergometer
23 Fencing 24 Fitness 25 Fitness walking 26 Football
27 Frisbee 28 Gardening 29 Golf 30 Gymnastics
31 Handball 32 Handcycling 33 Hiking 34 Hockey
35 Horseback riding 36 Housework 37 Ice skating 38 Indoor skating
39 Indoor volleyball 40 Inline skating 41 Jogging 42 Jumping rope
43 Kayaking 44 Kettlebell 45 Kickboxing 46 Kite skiing
47 Kitesurfing 48 Martial arts 49 Meditating 50 Mixed martial arts
51 Mountain biking 52 Nordic walking 53 Open water swimming 54 P90x
55 Paddle boarding 56 Paragliding 57 Pilates 58 Polo
59 Pool Swimming 60 Racquetball 61 Road biking 62 Rock climbing
63 Roller skiing 64 Rowing 65 Rowing machine 66 Rugby
67 Running 68 Sailing 69 Sand running 70 Scuba diving
71 Skateboarding 72 Skating 73 Skiing 74 Sledding
75 Snowboarding 76 Snowmobiling 77 Snowshoeing 78 Soccer
79 Softball 80 Spinning 81 Squash 82 Stair climbing
83 Stair climbing machine 84 Stationary biking 85 Strength training 86 Surfing
87 Swimming 88 Table tennis 89 Team sport 90 Tennis
91 Treadmill 92 Treadmill running 93 Treadmill walking 94 Utility biking
95 Volleyball 96 Wakeboarding 97 Walking 98 Water polo
99 Weight lifting 100 Wheelchair 101 Windsurfing 102 Wrestling
103 Yoga 104 Zumba

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}]"

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):


Humalog® Novolog® Apidra® Novolin R®
Humulin R® NovoRapid®

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


Novolin N® Humulin N® Lantus® Levemir®
Novolog® 50/50 Novolog® 70/30 NovoRapid® 70/30

Category must be exactly one of these strings:


Snack Before breakfast After breakfast Before lunch
After lunch Before dinner After dinner Night
Other Fasting glucose

Exercise must be exactly one of these strings:


Fitness Leisurely walking Walking fast Jogging
Running Swimming Dancing Roller skating
Bicycling Golf Softball Badminton
Football Basketball Volleyball Frisbee
Skiing Boxing Tennis Table tennis
Martial arts Rock-climbing Wrestling Hiking
Garden/Yard work

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

Need more help with this?
Don’t hesitate to contact us here.

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.