Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams

[Jim Busser]

Attached are two scripts. By running from the command line

        sh fetch_dpd.sh

This will
- download source Canada files to the working directory
- inflate them
- substitute CSV into pipe-delimited which sqlite better parses
- call sqlite and get it to
-   create tables and import DPD data
-   create FreeDiams tables
- insert what data is easily inserted into the FreeDiams schema
- keeps safe drugs.db (if in the directory) --> drugs.orig
- copies the dpd.db to make a new drugs.db
- exits sqlite

FreeDiams seems presently usable if it lacks the column data to which it is 
accustomed. The above scripts did not fully solve to select from more-fully 
normalized (but non-unique) Canadian data into the FreeDiams schema.

create_dpd_db.sql
Description: Binary data

fetch_dpd.sh
Description: Binary data