RERS Web data extract and upload

Data is extracted from RERS Web and submitted online from the practice.  You need to have access rights RBAC 0994, which admins normally do have. Once only, a file needs to be imported.  Thereafter the reports can be run at any time, but you need to change the date range.

Import report file, once only:
  1. Hover over Navigator GPA extract v3,
  2. Right click on “Save target as…” or “Save link as…”, using suggested name.  This is a small xml file, only 5kb, which is sent in a zipped format.  Look where it’s saved.
  3. Click on this folder to “extract all” or “unzip” so RERS can upload the file.
  4. In RERS, Population Reporting>Import>Enquiry Document  find and save this file to a new folder “Dot Community Health”
  5. Name the file eg “Navigator extract”.
Run reports, as required
  1. RERS Population Reporting, select the folder and file you saved above
  2. Highlight the file, click Edit in menu bar, then when open click Edit again in box.
  3. Definition tab, in “Criteria” section, hover over “the Appointment Date is…”
  4. Click Edit again, to see a dialog box with the start and end dates
  5. Change the top date “After or on” to your start date (last updated on your Navigator main menu, probably the date previously set to “Before or on”)
  6. Change the bottom date “Before or on” to your end date (yesterday)
  7. Click OK, OK again
  8. On the menu second from left click “Save and Run”, then Yes
  9. After a brief interval when queued, a patient count is shown
  10. DO NOT click Export Results.  This is the most common reason for failure, as it creates only a 5kb header file.
  11. Click “View Results” on menu bar.  See a screenful of data.
  12. Now click “Export” and a dialog box comes up
  13. Choose “csv“, tick  “Exclude header” and tick “Override hidden patients where possible”, then click OK.
  14. Name the file as you wish.  Do not use dots in the filename.
  15. Save the file to a folder and remember where.
  16. Back on your “Navigator file upload” page, browse for this file and submit.
  17. Now delete the submitted file to avoid confusion next time.

Click here to see screenshot instructions: Screen Captures for RERS web data extract

Date range:  initially the upload is for two years of data, or since your RERS Web installation if more recent.  File size limits mean it is best to split into two separate years and run twice. Later updates will be one run only.