Uploading a Patient Cohort File to Ocean for Batch Emailing

There are multiple formats that you can use for the importer.

Standard Importer

The standard importer expects a comma-separated value file (CSV) with the fields declared in the following order:

  • surname
  • firstName
  • birthDate (yyyy-mm-dd)
  • sex
  • health number
  • reason for visit
  • email address
  • EMR patient #
  • note

Note: There is no header line.

PS Suite Patient Importer

You can do a batch export of patients for this purpose using a PS Suite search. You need to ensure the search has the following columns:

  • surname
  • firstName
  • PSS ID
  • health number
  • birthDate (dd/mm/yr)
  • sex
  • email address
  • privacy

Note: Trailing comma is required!

For your convenience, this is a sample PS Suite export search using the required column format. We recommend importing this file and then changing the search criteria in order to export patients from PS Suite.

  • To import this from PS Suite, Open the EMR (Records) window within PS Suite.
  • From the "Settings" menu, select "Edit Searches...".
  • From the "Edit" menu, select "Import Searches...".
  • Click "Perform Search" to run the search.
  • After you run the search, from the "Report" menu, choose "Utilities" and then "Save as CSV...".
  • This .csv file can now be uploaded into Ocean. This is an example of an exported CSV file.

Once you have uploaded your patients into Ocean, you may wish to send them all a standard email. Please refer to "Batch Emailing with Ocean" for details.

HN Importer (Requires Accuro or TELUS API)

The HN importer should include a header row.

It expects a comma-separated value file (CSV) with the fields declared in the following order:

  • Last Name
  • First Name
  • PHN
  • ...

Note: Any fields can come after "PHN" - only the 3 fields specified above (i.e. first name, last name, and health number) are required.

How to export a CSV from Accuro

    • Click the Accuro icon in the bottom-left corner of the EMR and navigate to Reports > Query Builder.
    • In the Query Builder, click on the green plus icon to create a new query.
    • Name your new query and press "OK" to add it to the definitions list in the leftmost panel of the Query Builder.
    • Add relevant rules to your query to filter the patients you wish to upload to Ocean.

      For example, if you wish to create an export of all patients with a smoking risk factor:
      1. In the "New Rule" panel, select "EMR" from the "Rule Category" and select "Risk Factor" from the dropdown list.
      2. Next, create a new rule in the "Manage Rule" panel and select "Risk Factor" followed by "Smoking."
      3. Click "Add Rule" to the condition to your query.
    • When your query is ready, select "Run Report."
    • You may be prompted to "Check for Alert Matches." Depending on your preferences, you can filter patient matches by provider and view types. You can also decide which query fields you want to display in the final report. Click the "Run" button when you are ready to proceed.
    • When the Report view opens, select the "Export" button.
    • In the Export Results window, ensure "Encryption" is unchecked, as Ocean cannot parse a password protected file.
    • Click the "..." button to define what folder you would like to save the export file. Type in the appropriate filename followed by .csv file extension and click "OK."
    • Locate the exported CSV file on your computer and confirm that the default settings were applied and that the first three columns of the file have the headings "Last Name," "First Name," and "PHN."
    • Upload the file using the Ocean Cohort uploader in the Ocean Portal, ensuring "HN Importer" is selected as the importer type.
PS Suite Patient Importer (Legacy)

The PS Suite legacy importer expects a comma-separated value file (CSV) with the following fields in the following order:

  • surname
  • firstName
  • EMR ID
  • health number
  • birthDate
  • sex
  • email address
Standard Wolf Appointment Importer

This Wolf importer is based on the standard export format from Wolf EMR's appointment scheduler.

It expects a comma-separated value file (CSV) with the fields declared in the following order:

  • booking type
  • insurance province
  • PHN
  • surname
  • firstName
  • birthDate
  • DPID
  • ApptDate (yyyy-mm-dd)
  • ApptDuration
  • ApptReason
  • blank field
  • area code
  • phone number

Note: There is no header line.

Wolf Patient Importer

This Wolf importer expects a file that must include a header row.

However, the columns in the file can be in any order.

Note: Names should be included as a single fields in quotation marks: e.g. “Doe, John”.

Have more questions? Submit a request