Search documentation
Find a documentation page by the words on it.
Documentation
Office Ally Roster Import
Use this importer when you are moving off Office Ally and want your patient list in Serelora. It creates a patient for each row of your Practice Mate export. It brings over who your patients are, not their chart contents.
Step 1: Export the list from Practice Mate
The importer page repeats these steps so you can follow them in another tab:
- Go to Practice Mate, then the Manage Patients tab.
- Hover over Reports on the far right of the screen.
- Select Patient List (CSV/Excel Export).
- Leave Account Type and Status set to "All".
- Under CSV Output File Format, choose Long Record.
- Select GO, then Export to Excel.
The downloaded file is an Excel workbook ending in .xls. Upload it exactly as exported.
Step 2: Upload the file
In Serelora, select Patient List, then Import, then Office Ally. Drop the file on the box that reads "Drop the .xls file here, or click to choose". The page says "Reading the patient list…" while it works. Files can be up to 32 MB.
Step 3: Review before importing
Nothing has been saved yet. The Review before importing card shows the file name, how many rows were read, and a count for each outcome:
| Outcome | What it means | Created? |
|---|---|---|
| Will import | No match in your clinic. | Yes |
| Already imported | The Patient ID matches a patient already in your clinic. | No |
| Possible duplicate | The name and date of birth match a chart that has no Office Ally number. Check it by hand. | No |
| Repeated in file | The same Patient ID appears earlier in this file. | No |
| Cannot import | A problem stops the row, for example no Patient ID. | No |
A table lists every row with its status. A line such as "Not present in this export, so left empty: ..." names columns your report did not include. Warnings appear on rows whose values needed attention.
Select Import N patients to go ahead, or Choose a different file to start over. If nothing would be created, the button reads "Nothing to import".
Step 4: Wait for the import
The Importing patients card shows "N of M rows processed" with a progress bar. The import runs on the server, so it still finishes if you close the page, but the progress bar only shows while the page is open. To check afterward, look at the Patient List.
Step 5: Read the result
Import complete says how many patients were created, skipped, and failed. Any failed row is listed as "Row N: ..." with the reason. Select View patient list to see the new patients, or Import another file to run another.
If the import says "Import did not finish", or stops partway, see Resuming an Interrupted Import.
What comes across
- Patient ID becomes the patient's MRN. Keep it: it is how a second upload recognizes patients already imported.
- Name, address, home phone, date of birth, sex, email, race, ethnicity and preferred language.
- Account status, account type and primary provider.
- Primary and secondary insurance: payer, insured ID and insured name. The relationship to the subscriber is left blank, because the report does not give it. Add it in Insurance Coverage.
- Guarantor, employer details and an emergency contact.
The UD1 to UD6 free-text columns are not imported. Race, ethnicity and phone values that do not match Serelora's lists are saved as written and flagged with a warning on their row.
Everything imported can be corrected afterward in The Patient Record Editor.