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, click Import.
This works for forms filled out via the Kiosk Manager or using Web Forms. The import process differs slightly depending on the sheet type.
Import a Patient Form (e.g. registration 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.
- FieldName: The name of the field in the database and on the form.
- Current Value: Shows a value if information already exists in Open Dental for this field.
- Entered Value: What the patient entered on the form. If a value is in red bold text, it cannot be imported.
- Import Value: What value, if any, Open Dental has determined should be imported. To change a value, double click on the cell.
- Do Import: If an X appears, this field is marked for import. Single click on a cell to toggle the X on/off. When marked for import, the entire row will be grey.
- Double Click to Pick: The import information is too complex for Open Dental to automatically translate. Double click in the cell to specify the information to import.
- Insurance Policies: Only primary and secondary insurance policies can be imported, and the form must contain the following insurance fields:
- Subscriber: You will always have to double click to select and verify. If the subscriber does not exist in Open Dental, you must cancel the import and add them.
- Insurance Carrier Name and Phone: These rows will also require double clicking each time you import. However, new carriers can be added directly from the Carriers window, so you do not need to cancel the import. By default, the Carriers window will populate with the name and phone values entered by the patient.
When you are ready, click Import again. A Done message will indicate when the import is complete.
New Insurance Plan: If a new insurance plan was flagged for import, the Insurance Plans will open, and the search filters will populate with the import values. This lets you verify the plan does not already exist.
- To create a new plan using the import values, click Blank.
- To use a plan that already exists, select it and click OK. The import process will verify that all import values exactly match the existing plan's information. If a value does not exactly match, a message will popup, and you will have the option to use the existing plans value (click Yes), or create a new Blank plan with the import values (click No). Click Cancel to safely exit out of the import process and return to the Import window.
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).
Import a Medical History
- Select the patient, then click Forms in the main Toolbar.
- Select the completed medical history form, then click Import.
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. If a patient enters new medications, you will always have to double click 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.
- When you are ready, click Import again. A Done message will indicate when the import is complete.
Medical history import logic:
- If the Current Value = Y and Import Value = N
- If Current Value = N and Import Value = Y
- If imported, the item will be made active.
New items will never import with an inactive status.