Importing and Exporting Data

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.

Importing Record Data

Importing Food Data

Exporting Food Data

Importing Record Data

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:

  1. From the "File" menu, select "Import record data..."
  2. Choose the CSV file that you'd like to import from

Importing Food 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.

Calories

No

Total calories.

TotFat

No

Total fat value. Field can also be labeled "Fat".

ServingSize

No

Serving size

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:

  1. Go to the food database by clicking on the "Food Database" icon on the left side of the window.
  2. Use the "Browse by Group" tab to select a location in the food database where the imported foods should be placed
  3. From the "File" menu, select "Import food data..."
  4. Choose the CSV file that you'd like to import from

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

  1. Go to the food database by clicking on the "Food Database" icon on the left side of the window.
  2. Use the "Browse by Group" tab to select a location in the food database from where you'd like to export foods. During the export, you will have the option of exporting foods from only the selected group, or from the selected group plus all of the groups beneath it. To export ALL of your custom foods, click in the background of the "Browse by group" view to select the top level of the food database.
  3. From the "File" menu, select "Export food data..."