Diabetes Pilot provides several options for importing and exporting food and record data. This allows you to exchange information with sources such as other programs, glucose meters, and other food databases. This feature is intended for advanced users who are familar with the topics discussed below.
Glucose, meal, medication, exercise, and note record data can be imported from standard comma-separated (CSV) files. This format is supported by many databases, spreadsheets, and other programs. For more information on the basics of CSV files, see http://en.wikipedia.org/wiki/Comma-separated_values or http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm
The format of the input file is flexible - the columns can be in any order. A header row with the field names must be the first row in the CSV file. The following columns are available:
|
Field |
Required |
Description |
|
Time |
Yes |
Contains the record date and time. Most standard formats will be recognized. Optionally, a "Date" field can be included if you'd prefer to separate the date and time into two separate fields |
|
Type |
Yes |
Contains the record type. Must be one of: "Glucose", "Food", "Medication", "Exercise", or "Note". Importing blood pressure readings is currently not supported |
|
Value |
Yes |
The record value. For food records, the total carbohydrates for the meal (importing meal details is not currently supported) |
|
Label |
Yes, for medication and exercise records. Optional for glucose records |
For exercise and medications records, contains the type of exercise or medication. For glucose records, contains the units of the glucose reading and must be either "mg/dL" or "mmol/L". If this field is omitted, glucose readings will be imported using the default units. |
|
Note |
No |
Contains the record's notes. |
The following example shows one valid set of data for import:
Date,Time,Type,Value,Label,Note
1/2/2006,12:01,Glucose,125,mg/dL,test row 1
1/2/2006,15:03,Glucose,222,mmol/L,test row 2
1/2/2006,15:03,Glucose,333,,test row 3
3/3/2006,15:03,Medication,32,Humalog,test row 4
4/7/2006,15:03,Exercise,23,Typing,test row 5
To import record data:
Food information can be added to the food database by importing the data from standard comma-separated (CSV) files. This format is supported by many databases, spreadsheets, and other programs. For more information on the basics of CSV files, see http://en.wikipedia.org/wiki/Comma-separated_values or http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm
The format of the input file is flexible - the columns can be in any order. A header row with the field names must be the first row in the CSV file. The following columns are available:
|
Field |
Required |
Description |
|
Description |
Yes |
Contains the food and serving size description. Must be less than 250 characters. |
|
Carbs |
No |
Carbohydrate value. Field can also be labeled "Carbohydrates". |
|
Cholesterol |
No |
Cholesterol value. |
|
FatCal |
No |
"Calories from fat" value. |
|
Fiber |
No |
Fiber value. |
|
Protein |
No |
Protein value. |
|
SatFat |
No |
Saturated fat value. |
|
Sodium |
No |
Sodium value. |
|
Sugars |
No |
Sugars value. |
|
TotFat |
No |
Total fat value. Field can also be labeled "Fat". |
Fields that are not included will have the value set to zero.
The following example shows one valid set of data for import:
Description,Calories,Carbohydrates,FatCal,Fiber,Sugars,Protein,Fat,SatFat,sodium,Cholesterol
Test food 1,123,11,77,22,33,44,55,66,88,99
Test food 2,61.5,5.5,38.5,11,16.5,22,27.5,33,44,49.5
To import food data:
You can also export food data from Diabetes Pilot. The exported data will be stored in a CSV file that's compatible with the import feature described above. This allows you to share your food information with others - export the data, then import it in another copy of Diabetes Pilot.
Only custom foods that you've entered will be exported.
To export food data: