Drugref no longer updates from Health Canada site. Wrong filename in DPDImport.class

Preconditions

not applicable

Steps to Reproduce

Admin, Integration, Update Drugref

Expected Result

It should update the drugref database with new medications.

Is the new (Jun 1,2018) URL being used?
https://www.canada.ca/en/health-canada/services/drugs-health-products/drug-products/drug-product-database/what-data-extract-drug-product-database.html

Did they split the meds into multiple files?
eg. Fucibet is in drugs_ap.txt but NOT in drugs.txt
I downloaded the files manually.

Observed Result

Original database is restored. New medications are not added.

Additional Comments

The inactive.txt file includes:
"83313","02347768","NTP-LORAZEPAM","06-AUG-2015",""
"81342","Not Applicable/non applicable","MIRALUMA","15-MAR-2017",""
Miraluma was never assigned a DIN.

Easiest fix is probably to change "Not Applicable/non applicable" to NA.

Assignee

Unassigned

Reporter

Earl Wertheimer

Labels

None

OSCAR Build Date

2018/05/28

OSCAR Build Tag

Client Browser

Firefox

Client OS

Windows 7

Are you or your organization planning on submitting a fix for this bug in the next 30 days?

No

Validated by Reporter

No

SourceForge Link

None

SourceForge Reporter

None

SourceForge Assigned To

None

SourceForge Date Created

None

Priority

8
Configure