1. Auxita Help
  2. Managing Patients

How to Import a list of Pharmacies to Auxita from your EMR

Any user who is a Facility Admin can import a Pharmacy List to pre-populate the Pharmacy Address Book. If you already have a Pharmacy List in your EMR, many systems allow you to export this as a CSV for import into other applications, like Auxita.

*You must be a Facility Admin to access this feature. 

For instructions on exporting a pharmacy list from Accuro, please check out Accuro’s support page: https://qhrtech.my.site.com/community/s/article/Export-Address-Book 

Pencil icon NOTE A CSV file (comma-separated values) is a delimited text file that uses a comma to separate each value. Most commonly, this file type would be created in Excel and saved specifically as a .CSV

Export your patient data from your EMR and save it in a CSV format in a secure folder on your computer. 

  1. Once logged in to Auxita, from the left-side menu click on Import.
  2. To start your import, click the Import Actions button. Then choose Import Pharmacies from CSV.

    Import Pharmacies from CSV is noted in this screenshot
  3. An Acknowledge Import dialogue box will display to provide consent. Check off  Show advanced mapping options Click OK.

    Acknowledge Import window displayed here.
  4. Browse to the .csv file on your device. Select the file and click Open and the import to Auxita will commence.

    Sample of browsing to select a CSV file is shown in this screenshot.
  5. The Mapping Columns window displays if the advance mapping was selected. Here you can match the column header from your CSV file to the Auxita field where the data is imported. 

    For example, if your CSV File indicates Phone Number and Fax Number for the columns with contact numbers, you’ll want to match those to the Auxita Fields MainPhoneNumber and Fax, respectively.
  6. Any CSV column header that does not match identically to the Auxita Field shows up pink until you choose the appropriate Auxita Field from the dropdown.

    You can see a preview of the data in your file on the far right of the window to help you   identify where it should go in Auxita.
  7. Continue to select the appropriate Auxita fields for all of your CSV column headers. Auxita Fields with an asterisk are Required.  
  8. Once you are done with the mapping, click Import
  9. A  Success dialogue box appears while the upload is processing.

    Success dialogue box is displayed in the top right corner.
  10. The successful records can be viewed from the Accounts page under the Address Book tab. You will not see the records in the Review List on the Import page.

List of imported pharmacies is displayed here.


Pencil icon NOTE The CSV file should be under 2MB (about 1000 records). Required fields are Pharmacy Name and Fax Number.

Download a template CSV File here