bcgov / NRPTI

Natural Resources Public Transparency Initiative
Apache License 2.0
5 stars 15 forks source link

COORS Court Conviction CSV importer not properly transcribing location values #1097

Closed RFK250 closed 11 months ago

RFK250 commented 1 year ago

Describe the Bug The COORS Court Convictions importer is not correctly importing the Location field on import.

Expected Behaviour On import, the value in the CSV Location column should populate the Location field in the Court Conviction record.

Actual Behaviour The Location field is not being populated (or at least is showing a "-" on NRCED)

Implications Until this bug is addressed, users will not be able to understand where a given court conviction was made. This is confusing to the user, although the risk is minimal.

Steps To Reproduce Steps to reproduce the behaviour:

  1. Go to the NRPTI Import UI
  2. Select COORS as the system
  3. Select Court Convictions as the Record Type
  4. Drag and drop a court conviction file (ask Kyle for one) and click Start Job.
  5. Look at the court conviction records on NRCED. Records that come from this file will show a "-" as the location.
    • Note that it will look like only some of the Court Convictions are missing locations because some will show locations. The ones that show locations actually come from Violation Ticket files (see the second bullet under Describe the Bug).
RFK250 commented 11 months ago

@pinkyandthekane Did this ever get pushed into production, btw? Or is it in the build that's being held up by the BCMI work?