Installing Diabetes Pilot

Make a Place for Your Data

Diabetes Pilot for Mac is licensed to track data for up to five different people (if you'd like to track data for more than five people, please contact us for more information).

The first time you start Diabetes Pilot, you'll need to create a new data file so that you can start tracking your data. Choose "File->New" from the menu to do this (or click the "Start with a new data file" button on the welcome screen.

If you're using Diabetes Pilot with an iPhone or iPod Touch:

Create a new data file, as described above.

If necessary, install Diabetes Pilot on your iPhone / iPod by purchasing it from the iTunes App Store.

You can create additional datasets in the future by repeating the steps above for each additional person that will be using Diabetes Pilot to track their data.

If you've created more than one data file, you can select which data you want to work with by using the "File->Open" or "File->Open Recent" menu.

Purchasing and Activating

In some cases, when you install Diabetes Pilot it will run in a time-limited free trial mode. The program is fully functional during this time, but will only operate for a limited number of days. The program will not operate after the trial period expires. Please purchase it before your trial period expires - your purchase helps support further development of the program.

If you purchased Diabetes Pilot at www.diabetespilot.com, you will have received a license key file via email. Follow the instructions in the email to use the license key file to unlock the program. (Just open the license key file or drop it on the Diabetes Pilot icon in the dock).

Entering Data

This section explains how to record your data in Diabetes Pilot for Mac. Diabetes Pilot can track your glucose, food, medication, exercise, and nearly any other type of information that you'd like to record.

Creating a new entry

To enter new data, go the the My Records page by clicking the My Records icon in the toolbar.

To record a new data item, click on one of the buttons at the bottom of the main screen:

Click the "Glucose" button to record a new glucose (blood sugar) measurement

Click the "Food" button to record a new food or meal

Click the "Medication" button to enter a medication or insulin dose.

Click the "Exercise" button to enter a new exercise activity.

Click the "BP" button to enter a blood pressure and pulse reading.

Click the "Note" button to record any other type of data. You can use this type of entry to record nearly anything. You might use it to record HbA1C measurements, blood pressure, other test results, notes about how you're feeling, or anything else you'd like.

To edit an existing item, click on the record. Clicking on the record will take you to the Details window for the record (see Recording and Editing Data below)

When you enter a new item change an existing one, it may or may not be immediately visible in the list on the main screen. The display in the My Records section depends on the filter settings that you have set - see Displaying Your Data for more information.

Recording and Editing Data in the Details Window

Diabetes Pilot allows you to record information in as much or as little detail as you would like - it provides for both quick data entry as well as the ability to record additional details when needed.

When you create a new record, a detail window will appear. The date and time will be set to the current time. You can change the date and time if necessary by typing over the values or using the arrow controls located next to each entry. Then, enter the values for the item:

For glucose records, enter your blood sugar reading. You can choose to use either mg/dL units (typically used in the United States) or mmol/L units (typically used throughout the world) by setting the desired units in from the preferences menu - see Setting Preferences for more information.

For medication records, enter the amount of insulin or medication, and select the type from the drop-down list next to the value. The list remembers the medications that you commonly use. Try to select an item from the list first - if the item you want isn't in the list, simply type it in the box and it will be added to the list for next time.

For food records, enter the details of the meal using the food database and allow Diabetes Pilot to add up the contents of the meal for you. See Food Records below for details.

For exercise records, enter the amount of exercise and select the type of exercise from the drop-down list next to the value. Use the "amount" to record whatever units are most useful to you - you might, for example, choose to record "minutes of exercise", "miles walked", "number of situps" or any other measure that you find convenient. As with the medication list, the exercise list remembers the exercises that you commonly enter. Try to select an item from the list first - if the item you want isn't in the list, simply type it in the box and it will be added to the list for next time.

For note records, just enter the note that you'd like to make. Use this to record events in the day, A1C and other test results, or whatever you'd like.

You can enter notes in the space provided. These notes will appear in the "My Records" list.

A category for each record can be also be selected. This category can be use to categorize records in any manner that is useful to you. You may want to use the category to identify records by time of day (breakfast, lunch, dinner, etc). The category list can be customized however you would like. To customize the category list, finish entering your record. Then, click on the small "Edit" button below the category list on the "My Records" window.

Click "OK" when you are done making your entry. The details window will close and your record will be added. Clicking on "Cancel" returns you to the previous screen without saving your changes.

Food Records

When you add a food record, you can use the food database in Diabetes Pilot to record your meal details and add up the contents of the meal.

There are several ways to add foods to your meal record. To start, find a food that you'd like to add to the meal by using the food database on the right side of the window. See Using the Food Database for more information about the food database, finding foods, and adding new foods. After you've found the food that you want, add it to the meal record by dragging it to the "foods in this meal" grid.

After you've added to food to the Meal Details, edit the entry as necessary. Change the "Qty" column to reflect how many servings of that item you've eaten. The nutrition values shown in the grid reflect the "per serving" values (just like on a food label) - they are multiplied by the quantity you've entered and the meal totals are calculated accordingly. Double-click on the values to change them. When you're editing an item in the grid, you can also use the "tab" key to move through the grid. As you make changes to the Meal Details, the totals will be updated.

If you want to add a food that's not in the database, click the "Quick Add" button. A new item will be added to the grid. You can then edit it as necessary. If you'd like to save the new item in the database for future use, just drag it from the grid to the food database window.

If you want to quickly enter your own self-calculated carb total without bothering with entering individual foods, just click the "Quick Add" button to add a single item to the grid. Then, adjust the carb total as necessary.

You can also save and recall entire meals, so that you don't need to re-enter details for meals that you frequently eat.

To save a meal for future use:

Add foods to the meal listing, as described above.

Click the "Save list as a saved meal.." button.

Enter a name for the meal, then tap the "OK" button.

To recall a previously saved meal:

Click on the "Saved Meals" tab in the food database.

Drag the meal from the food database and drop it on the "Foods in this meal" grid. The foods in the saved meal will be added to the record.

Many of the food descriptions are abbreviated. This helps Diabetes Pilot Desktop work with the handheld version of Diabetes Pilot and allows the food descriptions to fit in the available screen space. You can get a list of the abbreviations here.

Deleting Records

You can delete your records if necessary.

To delete an individual record:

Select a record by clicking on it. The record window will appear.

Click on the delete ("-") button.

To delete a group of records by date:

From the "File" menu, select "Purge Old Records..."

In the window that appears, select the range of dates you'd like to delete. Be careful - once you delete the records, they cannot be retrieved.

Click the "OK" button.

Displaying Your Data

This section explains how to control the display of your data in Diabetes Pilot for Mac. Diabetes Pilot provides several different filtering options for displaying your data. This allows you to focus on the information that is important to you at a particular moment, without being distracted by other data that you may have recorded.

Display Filters

The display filter control is located on both the My Records page and on the Reports page. On the My Records page, the filter controls which records are displayed in the record grid. On the Reports page, the filter controls which records are included in the report that you generate. Records can be filtered by type, category, and date:

To control which dates are displayed, select an item from the list labeled "Display these dates".

To control which record types are displayed, check the boxes next to the types you wish to display in the box labeled "Display these record types"

To control which record types are displayed, check the boxes next to the categories you wish to display in the box labeled "Display these categories". Note that you may need to use the scroll bar along the right side of the box to access all of the categories in the list.

A record must match all of the filter criteria to be displayed.

Click on the "Show All Records" to allow all of the records to be shown. If you're having trouble finding a record that you think should appear in the list, click this button so that all of the records are displayed - this may help you locate what you're looking for.

Use the "All" or "None" buttons in each section to select or deselect all of the items in a section. This provides a convenient starting point for when you want to display just a few records.

Scrolling the Display

If you've selected more records that can fit on a single screen, a scrollbar will be visible along the right side of the record list. Slide the bar up and down or tap on the bar's arrows to scroll the list and view all of the records.

Sorting the Display

You can change the way that records are sorted on the My Records page. To resort your records, click on the heading of the column that you would like to sort by. For example, if you wanted to sort your records by type, click on the word "Type" that is at the top of the type column. To sort by time, click on the "Time" heading. You can sort your data by any of the columns. To reverse the sort order, click on the column heading a second time.

Using the Food Database

This section explains how to use the Diabetes Pilot Desktop food database. The food database provides reference information on thousands of foods. You can add your own foods to the database and customize it to meet your needs.

Accessing the Food Database

The food database can be accessed in two different ways:

By selecting "Edit Foods" from the toolbar. This will display the food database and allow you to look up food information and do things like add, edit, and organize the foods and mark foods as favorites.

When you are building a new meal entry (see Food Records) the food database will be displayed.

Finding Foods

You can locate foods in the food database in several different ways:

Option 1: Browse through the foods by category.

To browse through the foods by category, click on the "All Foods" button near the top of the listings. This displays an organized listing of the foods and groups. You can browse through the groups or see a food's information by by clicking on the items - it works similar to the MacOS Finder.

Option 2: Search for foods by name.

To search for foods by name, type a word or phrase in the search box. The food database will be searched for what you enter. Any food or group containing your search will be displayed in the search box. You will usually have better results with the search feature if you enter just a few letters of a food name - this way, the food will appear in the results even if it is named a bit differently than you'd expect.

This is a usually the fastest way to find a food.

Option 3: Display a list of the foods you have marked as favorites.

To do this, click on the "Favorites" button near the top of the window. A list of the foods that you've marked as favorites will be displayed. To select a food, click on it in the list.

Adding New Foods and Groups

To add a new food or group to the food database, click the "All Foods" button so that you can see the whole food database. Start by browsing to the location where you would like the new item added (see Finding Foods above). Select the group in which you would like to add the new item.

To add a new group, tap on the "New Group" button, enter a name for the new group, and press the enter key.

To add a new food, tap on the "New Food" button, enter a name for the new food, and press the enter key. Then, fill out the "Food Information" located on the right side of the screen, and click the "Done" button.

Marking Foods as Favorites

When a food is marked as a favorite, it will appear in the "Favorites" list. To mark a food as a favorite:

Find the food in the database (see Finding Foods above) using the "Edit Foods" toolbar button.

Select the food (by tapping on it to highlight it)

Check the "Favorite" checkbox.

To remove a food from the favorites list, select it and uncheck the "Favorite" checkbox. The food will be removed from the favorites list.

Organizing and Customizing the Food Database

Several functions are available to help you organize and customize the food database.

Setting Preferences

To set general program preferences, select "Preferences..." from the "Tools" menu. The "General" preferences tab allows you to set several options that determine how Diabetes Pilot works:

Blood glucose ranges. Set your limits for high and low blood sugars and a target range. These values are used with various reports.

Default Medication: This allows you to specify the medication that appears as a default when you are entering a new medication entry. If the medication you want isn't in the list, just type a new one in the box.

Default Exercise: This allows you to specify the exercise that appears as a default when you are entering a new exercise entry. If the exercise you want isn't in the list, just type a new one in the box.

For Meals Show: This allows you to specify which nutrient data appears for Meal records on the record listing screen and in certain reports.

Glucose Units: This items allows you to select between either mg/dL units (typically used in the United States) or mmol/L units (typically used throughout the world) for glucose measurements. Please note that if you change this setting, your existing glucose data and target glucose ranges will be converted to the system of measurement that you select. Please note that converting back and forth between the two systems of measurement may result in small changes to your data that are caused by rounding during the conversion process. For this reason, you should select the system that you prefer and then leave this setting unchanged. Important - If you are using Diabetes Pilot Desktop with a handheld version of Diabetes Pilot, be sure that you are using the same units in both the desktop version and the handheld version.

Smart Categories: When "Smart Categories" is turned on, the program will try to preselect an appropriate category for your new records, based patterns in your previous records. This can save you time when entering new records. When this setting is turned off, new records will start in the "Unfiled" category. In any case, you can always change a record's category to whatever you'd like.

Share New Foods: When this setting is turned on, new foods that you add to the database will be sent to DiabetesPilot.com. By sharing your new foods, they are considered for inclusion in future versions of the program - you're helping other people by sharing the food information that you add. This happens anonymously, automatically, in the background. None of your meal data, record data or other personal information is sent, only the nutrition data for new foods that you add. If you don't want to do this, simply turn this setting off.

On the "Reports" tab, you can set the following option:

Additional Text to Display on Reports: The text that you enter here will be displayed on any reports that you create. You can use this to enter your name and any other data that you'd like to appear at the top of your reports.

Editing Categories

Diabetes Pilot allows you to categorize your records however you would like. Many people like to use these categories to group their records by time of day. However, you can change the category names to anything that you'd like.

To edit the category list:

On the "My Records" display, click the small "Edit" button under the category list on the left side of the window.

Use the New ("+") and Delete ("-") buttons to modify the list. To rename a category, double-click on it.

Because you can use any categories name you want, Diabetes Pilot does not automatically know how to order the categories in reports. You need to tell Diabetes Pilot the order that you'd like the categories to appear.

To change the order of the categories in reports:

On the "My Records" display, click the small "Edit" button under the category list on the left side of the window.

Select a category by clicking on it in the list.

Use the "Move Up" and "Move Down" buttons to change the order of the category.

Repeat steps 2 and 3 until the categories are listed in the order that you want them to appear.

Reports: Analyzing, Printing, and Sharing Your Data

The reporting features in Diabetes Pilot allow you to review and analyze your data, send it to your doctor, archive it for safekeeping, and transfer it to other programs.

To access the reporting features, click the "Reports" icon on the toolbar.

Logbook by Time - Shows your records in a logbook format in a flexible grid organized by time

Record Listing - Lists your records in a manner similar to how they appear on the My Records page.

Record Graph - Graphs your individual glucose readings, food, and medication over time

Average BG by Category - Shows your average glucose organized by category

Average BG by Hour - Shows your average glucose as an average for each hour of the day

Average BG by Month - Shows your average glucose by month

Glucose Ranges - Shows the number of glucose measurements in your target range, above your "high" limit, and below your "low" limit. These ranges can be set in the preferences window (seeSetting Preferences for more information)

Medication Totals by Day - Shows a total of the medications you've entered for each day

Exercise Totals by Day - Shows a total of the exercises you've entered for each day

Blood Pressure Graph - Graphs your blood pressure readings

Weight Graph - Graphs your weight over time

CSV Record Export - Creates a plain text "comma separated values" file that contains your record data. This is useful for importing your data into other programs (such as spreadsheets) that can read these types of files directly. When you use this report, you'll be prompted for a file to save the data to, rather than having it displayed on the screen.

Next, choose the records that you would like in the report using the filter controls (see Display Filters for more information). Or, click the "Show All Records" button to include all of your records.

Note that if your filters do not allow any records to be selected, the report will be blank - if this happens, change the filter settings to select the dates, categories, and record types that you want to include.

Also, note that some filter settings may not apply to certain types of reports and will be ignored. For example, the "Recent Glucose Averages" report will always show your recent averages (and ignore the date filter) and the "Medication Totals" report will always show medication records (ignoring the record type filter).

The filter controls provide for numerous report possibilities. For example, if you want a listing of your blood pressure readings, create a "Record Listing" report and select only the "BP" record type.

Step 3: Create the Report

Click the "Create Report" button to create the report. Your records will be processed and the report will be displayed in a few moments.

Viewing the Report

Many reports will be more than one screenful - use the scroll bars as necessary to see the whole report.

Choose "File->Print" from the menu to print the report.

Using Your Reports

In addition to viewing your reports on-screen in Diabetes Pilot, there are various ways to use your reports outside of the program. First, create a report. Then:

Printing a Report

Choose "File->Print" from the menu to print the report.

Saving a Report as a PDF

Saving your report as a PDF allows it to be read without needing Diabetes Pilot

Choose "File->Print" from the menu.

In the "Print" window, click the "PDF" button and choose "Save as PDF".

Emailing a Report

This allows you to email your report to your doctor or whomever you choose. The report is send as a PDF, which allows the recipient to read it without needing Diabetes Pilot themselves.

Choose "File->Print" from the menu.

In the "Print" window, click the "PDF" button and choose "Mail PDF".

Copying a Report

You can copy and paste information from the report. This lets you paste it into a word processor, spreadsheet or wherever you choose:

Highlight the part of the report you'd like to copy by clicking-and-dragging on it. Alternately, click on the report and type Command-A (or use the "Edit->Select All" menu item) to select the whole report.

Copy the report by typing Command-C (or use the "Edit->Copy" menu item) to copy the text

Paste the copied information into another program.

Transfer and Sync Your Data

If you have an iOS device, Diabetes Pilot for Mac can sync with the Diabetes Pilot app on your device - use your handheld to record data while you're on the go, then synchronize it to Diabetes Pilot for later reporting and analysis.

The Diabetes Pilot iPhone and iPad apps are separate products and sold separately from Diabetes Pilot for Mac. They are available through the iTunes App Store.

There are several ways to transfer data from your iOS device:

Synchronize Your Data Via WiFi

This feature lets you transfer your record data and food database between your desktop computer and your handheld.

To use the WiFi sync, you will need your computer and your handheld connected to the same network.

To start, make sure that both devices are connected to your network:

Make sure that your computer is connected to your network. We recommend using a private, secure, network that you control (i.e. a properly configured home network rather than a public WiFi hotspot)

Make sure that your handheld is connected (via WiFi) to the same network as your computer. (The sync will not work if your device is connected only with a cellular (3G) data connection). If necessary, use the iPhone's "Settings" app to verify your WiFi settings - check that you're connected to the correct network. You may also wish to use an application such as the Safari web browser (surf to a new page or two) to confirm that you have an active, working, network connection.

On your computer, choose the desired sync options. You will usually want to leave the "Synchronize my Data" option selected. This will merge data from both locations into one common dataset. With this, records entered in one location will be transferred to the other and vice-versa.

On your computer, click the "Sync Now" button to start the sync.

One-way Data Transfer Via Email

The WiFi sync described above is generally the best choice for transferring your data. However, you can also transfer your records from your handheld via email to a computer with Diabetes Pilot Desktop. This can be useful for a variety of purposes: sending your data to a doctor's office that has Diabetes Pilot Desktop, a child sending data to a parent, sending data to yourself for later analysis, transferring your data when the WiFi connection described above isn't practical, and many other situations.

On the screen that appears, enter your email address and tap the "Send" button to send your data. Please note that, to keep the data sent to a reasonable size, your food database is not transferred with this method.

Receive the email on your desktop computer. It may take a several minutes or more to arrive, depending on your email system. (Be sure that the message hasn't mistakenly gone into your junk mail folder.)

Save the file attached to the email on your computer.

Start Diabetes Pilot for Mac on your computer.

Open the dataset that you'd like to fill with your backup data. Note that this data will be REPLACED with the data from your handheld. Because of this, you may wish to back up the existing data first, or create a new dataset (by choosing "File->New from the menu) to hold the incoming data from your handheld.

From the "File" menu, select "Open...". In the window that appears, select the file you saved in step 4. Alternately, drop the file on the Diabetes Pilot icon in the dock.

Note: With this option, the food reference database is not transferred. Thus, the food database will be blank in the received data. If you'd like to transfer the food database, use the WiFi sync instead.

Backing Up Your Data

If your Diabetes Pilot data is important to you, you should make a backup of it periodically. This is important to protect against hardware failure, mistakes, or other issues. You can use a backup system such as Apple's Time Machine to back up your data file. Diabetes Pilot also provides its own options for making a backup copy of your data.

Backing Up Your Data

Start Diabetes Pilot and open the dataset that you'd like to back up. This backup procedure only backs up the currently open dataset.

From the "File" menu, select "Save Backup..."

In the window that appears, choose a location to save the backup. It's a good idea to save the backup file to an external disk, memory device, or CD so that you have a safe copy even if something happens to your computer.

Restoring a Backup

To restore your data from a backup copy:

Start Diabetes Pilot.

Open the dataset that you'd like to fill with your backup data. Or, create a new one by selecting "File->New" from the menu. Note that restoring your data will replace the data in the dataset with the data in the backup.

From the "File" menu, select "Open..." and select your backup file. Alternately, drop the backup file on the Diabetes Pilot icon in the dock or just double-click it.

Restoring an Automatic Backup

Diabetes Pilot Desktop will occasionally make automatic backups of your data for you. This serves as a secondary backup, but it should not take the place of the regular backups described above. If you make a mistake with your data, you may wish to restore one of the automatic backups:

Start Diabetes Pilot.

Open the dataset that you'd like to fill with your backup data. Or, create a new one by selecting "File->New" from the menu. Note that restoring your data will replace the data in the dataset with the data in the backup.

From the "File" menu, select "Show Automatic Backups in Finder"

In the window that appears, find the backup that you would like to restore. Double-click the file to restore it in Diabetes Pilot or drop it on the Diabetes Pilot icon in the dock.

Food Database Abbreviations

Some foods in the food database have abbreviated descriptions. Here is a list of of the abbreviations used:

All Purpose

ALLPURP

Aluminum

AL

And

&

Apple

APPL

Apples

APPLS

Applesauce

APPLSAUC

Approximate

APPROX

Approximately

APPROX

Arm and Blade

ARM&BLD

Artificial

ART

Ascorbic Acid

VIT C

Aspartame

ASPRT

Aspartame-sweetened

ASPRT-SWTND

Babyfood

BABYFD

Baked

BKD

Barbequed

BBQ

Based

BSD

Beans

BNS

Beef

BF

Beverage

BEV

Boiled

BLD

Boneless

BNLESS

Bottled

BTLD

Bottom

BTTM

Braised

BRSD

Breakfast

BRKFST

Broiled

BRLD

Buttermilk

BTTRMLK

Calcium

CA

Calorie, calories

CAL

Canned

CND

Carbonated

CARB

Center

CNTR

Cereal

CRL

Cheese

CHS

Chicken

CHICK

Chocolate

CHOC

Choice

CHOIC

Cholesterol

CHOL

Cholesterol-free

CHOL-FREE

Chopped

CHOPD

Cinnamon

CINN

Coated

COATD

Coconut

COCNT

Commercial

COMM

Commercially

COMMLY

Commodity

CMDTY

Composite

COMP

Concentrate

CONC

Concentrated

CONCD

Condensed

COND

Condiment, condiments

CONDMNT

Cooked

CKD

Cottonseed

CTTNSD

Cream

CRM

Creamed

CRMD

Dark

DK

Decorticated

DECORT

Dehydrated

DEHYD

Dessert, desserts

DSSRT

Diluted

DIL

Domestic

DOM

Drained

DRND

Dressing

DRSNG

Drink

DRK

Drumstick

DRUMSTK

English

ENG

Enriched

ENR

Equal

EQ

Evaporated

EVAP

Except

XCPT

Extra

EX

Flank steak

FLANKSTK

Flavored

FLAV

Flour

FLR

Food

FD

Fortified

FORT

French fried

FRENCH FR

French fries

FRENCH FR

Fresh

FRSH

Frosted

FRSTD

Frosting

FRSTNG

Frozen

FRZ

Grades

GRDS

Gram

GM

Green

GRN

Greens

GRNS

Heated

HTD

Heavy

HVY

Hi-meat

HI-MT

High

HI

Hour

HR

Hydrogenated

HYDR

Imitation

IMITN

Immature

IMMAT

Imported

IMP

Include, includes

INCL

Including

INCL

Infant formula

INF FORMULA

Ingredient

ING

Instant

INST

Juice

JUC

Junior

JR

Kernels

KRNLS

Large

LRG

Lean

LN

Lean only

LN

Leavened

LVND

Light

LT

Liquid

LIQ

Low

LO

Low Fat

LOFAT

Marshmallow

MARSHMLLW

Mashed

MSHD

Mayonnaise

MAYO

Medium

MED

Mesquite

MESQ

Minutes

MIN

Mixed

MXD

Moisture

MOIST

Natural

NAT

New Zealand

NZ

Nonfat Dry Milk

NFDM

Nonfat Dry Milk Solids

NFDMS

Nonfat Milk Solids

NFMS

Noncarbonated

NONCARB

Not Further Specified

NFS

Nutrients

NUTR

Nutrition

NUTR

Ounce

OZ

Pack

PK

Par fried

PAR FR

Parboiled

PARBLD

Partial

PART

Partially

PART

Partially fried

PAR FR

Pasteurized

PAST

Peanut

PNUT

Peanuts

PNUTS

Phosphate

PO4

Phosphorus

P

Pineapple

PNAPPL

Plain

PLN

Porterhouse

PRTRHS

Potassium

K

Powder

PDR

Powdered

PDR

Precooked

PRECKD

Preheated

PREHTD

Prepared

PREP

Processed

PROC

Product code

PROD CD

Propionate

PROP

Protein

PROT

Pudding, puddings

PUDD

Ready-to-bake

RTB

Ready-to-cook

RTC

Ready-to-drink

RTD

Ready-to-eat

RTE

Ready-to-feed

RTF

Ready-to-heat

RTH

Ready-to-serve

RTS

Ready-to-use

RTU

Reconstituted

RECON

Reduced

RED

Reduced-calorie

RED-CAL

Refrigerated

REFR

Regular

REG

Reheated

REHTD

Replacement

REPLCMNT

Restaurant-prepared

REST-PREP

Retail

RTL

Roast

RST

Roasted

RSTD

Round

RND

Sandwich

SNDWCH

Sauce

SAU

Scalloped

SCALLPD

Scrambled

SCRMBLD

Seed

SD

Select

SEL

Shank and sirloin

SHK&SIRL

Short

SHRT

Shoulder

SHLDR

Simmered

SIMMRD

Skin

SKN

Small

SML

Sodium

NA

Solids

SOL

Solution

SOLN

Soybean

SOYBN

Special

SPL

Species

SP

Spread

SPRD

Standard

STD

Steamed

STMD

Stewed

STWD

Stick

STK

Sticks

STKS

Strained

STR

Substitute

SUB

Summer

SMMR

Supplement

SUPP

Sweet

SWT

Sweetened

SWTND

Sweetener

SWTNR

Teaspoon

TSP

Thousand

1000

Toasted

TSTD

Toddler

TODD

Uncooked

UNCKD

Uncreamed

UNCRMD

Undiluted

UNDIL

Unenriched

UNENR

Unheated

UNHTD

Unprepared

UNPREP

Unspecified

UNSPEC

Unsweetened

UNSWTND

Variety, varieties

VAR

Vegetable, vegetables

VEG

Vitamin A

VIT A

Vitamin C

VIT C

Water

H20

Whitener

WHTNR

Whole

WHL

Winter

WNTR

With

W/

Without

WO/

Yellow

YEL

Importing Record Data

Diabetes Pilot provides several options for importing and exporting food and record data. This allows you to exchange information with sources such as spreadsheets, glucose meters, and other programs. This feature is intended for advanced users who are familar with the topics discussed below.

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.

Category

No

Contains the record's category. If this column is not supplied, you'll be prompted for how to categorize the new records: The program can either import the records to the "unfiled" category or it can try to guess the category based on each record's time and the category patterns in your existing records.