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 s 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.

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”.

Batch Emailing with Ocean

Ocean allows you to bulk upload a list of patients from a file to assist with performing population-based interventions or batch patient communication. A list of patients can be uploaded with a user-specified "Cohort ID", which you can use to send batches of online questionnaires or secure messages.

Below is a step-by-step guide outlines how to send a secure mass email message to patients using Ocean.

Download PDF Guide to Sending Bulk Email from Ocean

  1. Create your patient list file.

    • Within your EMR, you will need to export a list of patients, including their basic demographic information in a Microsoft Excel or a .csv text file.
    • The means by which you obtain this list of patients varies depending on which EMR you use, but it usually involves the execution and export of a search report in the system.
    • Many EMRs let you export a list of patients with upcoming appointments, which is particularly useful for using Ocean to send pre-visit questionnaires or reminders. However, as long as you can create a list of patients with their basic demographic fields in Microsoft Excel or as a tab-delimited or .csv text file, you should be able to make it into a format that Ocean accepts.
    • To learn how to obtain a properly formatted file that Ocean accepts, please refer to "Uploading a Patient Cohort File to Ocean for Batch Emailing".
  2. Upload and name your patient list file.

    • In the Ocean Portal, under the Patients tab, select "Upload Patients from File" from the Actions menu at the bottom left.
    • Search for the file that you created in Step 1.
    • Select the appropriate file "Importer" from the dropdown menu (e.g. standard, PSS or Accuro).
    • Give the file a name next to "Assign Cohort ID".
    • If appropriate, you can also add any eForms to be included in the email under "Queue eForms for uploaded patients".
  3. Send a batch of emails to your patient cohort.

    • To send a batch email, select "Email Cohort" from the Actions menu at the bottom left-hand corner of the Patients tab.
    • Select your group using the "Select Cohort" dropdown menu.
    • Select the template that you wish to send from the Templates menu at the top right-hand corner of the dialogue box. (Learn how to set up your online message templates in "Ocean Online Message Templates".
    • Select "Send Invitations" to send your emails.
    • Note: If you wish to edit your templates, you must do so by opening the email window for a single patient from within the Patients tab.
  4. View your batch email transaction logs.

    • For audit or tracking purposes, you may want to download a record of all the batch emails that have been sent to your various patient cohorts. To do this, navigate to the Admin tab of the Ocean Portal.
    • Under "Export Batch Email Transaction Logs", select the date range that you want to see in your exported file. To see all batch email transactions, leave these date fields blank.
    • If you'd only like to see the report for a specific cohort, enter the Cohort ID in the field below the date range. If you'd like to view all your cohorts, leave this field blank.
    • Click "Export" and your log will download as a .csv file, which can then be opened in Microsoft Excel.