|
Diabetes
Pilot for More Information
|
Diabetes Pilot Desktop: 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
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:
- From the "File" menu, select "Import record data..."
- 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. |
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:
- Go to the food database by clicking on the "Food Database" icon on the left side of the window.
- Use the "Browse by Group" tab to select a location in the food database where the imported foods should be placed
- From the "File" menu, select "Import food data..."
- 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:
- Go to the food database by clicking on the "Food Database" icon on the left side of the window.
- 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.
- From the "File" menu, select "Export food data..."
Copyright © 2007 Digital Altitudes, LLC. All Rights Reserved. Privacy Policy.