Open djbusby opened 2 years ago
,,Integrator is not authorized to update licensee: ExternalIdentifier is required: Operation is invalid must be Insert, Update or Delete: InitialQuantity must be numeric: QuantityOnHand must be numeric: TotalCost must be numeric: IsMedical must be True or False: CreatedDate must be a date: Invalid LicenseeID: Invalid Strain: Invalid Area: Invalid Product,226279,,,,,,
Notice the comma in the message "Operation is invalid must be Insert, Update or Delete"
Also this other error message has it too:
412717, Main Section, , 412717-018NY6XC00SECT10N000000000, -system-, 12/29/2021, -system-, 12/29/2021, INSERT, Integrator is not authorized to update licensee, CheckSum and number of records don't match
According to the specifications provided by the LCB, the CSV fields should not have embedded commas -- as that breaks their parser.
However, their own error response CSV files have fields with embedded commas -- and the fields are not quoted -- (see bug #35).
LCB should fix these error messages to not have the embedded commas.