Import Patient Forms and Medical Histories

When a patient fills out a registration form or a medical history form, the data can be imported into the Open Dental database.

In Patient Forms, highlight a form, then click Import.

This works for forms filled out via the Kiosk Manager, Web Forms, or eClipboard. The import process differs slightly depending on the sheet type.

Import a Patient Form

This window is a review of information on the completed form. Always verify any data with the patient and make sure the correct rows are flagged before you import.

Columns:

When [double click to pick] displays in red, the information is too complex for Open Dental to automatically translate. Double-click in the cell to specify the information to import. For additional details on complex fields, see Complex Fields below.

When the information has been reviewed, click Import. The selected fields will import into Open Dental and a Done message will display.

Import a Medical History

Medical history import values are represented by three states: yes, no and unknown. Empty columns represent unknown, or items which the patient left blank.

To change import status, double-click in the Import Value cell.

Medications: If a patient enters new medications, you will always have to select a value from the Medications List. By default, the medication entered by the patient will show in the Search box. Watch for misspellings, as the search will look for an exact match. Select the correct medication and it will appear in the FieldName column under Medications.

Medical history import logic:

Complex Fields

Insurance Policies: Only primary and secondary insurance policies can be imported, and the form must contain the following insurance fields:

Subscriber: Subscribers must be verified and added manually. Double-click the row to open the Select Subscriber window. If the subscriber does not exist in Open Dental, cancel the import and add them.

Insurance Carrier Name and Phone: Insurance carriers must be added manually. Double-click the row to open the Carriers window. New carriers can be added directly from the Carriers window. By default, the search will populate with the name and phone values entered by the patient.

New Insurance Plan: If a new insurance plan was flagged for import, the Insurance Plans window will open, and the search filters will populate with the import values. This lets you verify the plan does not already exist.

Insurance Order: Importing an insurance policy does not increase the order to secondary, tertiary, etc. A primary insurance import will overwrite primary insurance policies, and secondary insurance import will overwrite secondary insurance policies. For example, a patient has BCBS for primary insurance and they want to add a new Met Life policy as secondary. The new Met Life information must be entered into the secondary insurance fields on the form in order to be imported into the secondary insurance fields in Open Dental. If entered in the primary insurance fields, the import will overwrite the primary insurance instead (BCBS).

Address fields: If the preference Verify Addresses with USPS is enabled, the address is verified when importing.