Skip to content

Data Exports

Jump to bottom
afwilcox edited this page Nov 26, 2024 · 8 revisions

Introduction to Data Exports

It is the current business process to request data exports every month from the complaint and case management systems. This process may be replaced in the future with self service access via Metabase. This page will describe the location of the exports and the process for running and distributing them.

Location of Exports

The data exports can be found in the /export directory

Connecting to the Production Database

See https://github.com/bcgov/nr-compliance-enforcement/wiki/Openshift

Export of Scripts

  • Execute cos_hwcr_complaint_export.sql
  • Export the results to a CSV File.

Manual Adjustments to Export

  • Convert the results to an XLSX File.
  • Password Protect the XLSX File (See Alec or Miwa for the scheme).
  • Format the date column (Column C 'Date Logged) to be of type Date in the format YYYY-MM-DD

image

  • Format the datetime column (Column D 'Incident Datetime) to be of type Custom in the format YYYY-MM-DD hh:mm

image

  • Resize all the columns so that the whole thing is readable. This can be done easily by highlighting all columns by clicking at the top left of the sheet, and then double clicking between column A and B

image

  • Save the file as Complaint data.xlsx

Delivery of Export

  • Once the file has been password protected it can be emailed.
Clone this wiki locally