gnumed-devel
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


From: Jim Busser
Subject: Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams
Date: Fri, 19 Feb 2010 12:30:39 -0800

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.

Attachment: create_dpd_db.sql
Description: Binary data

Attachment: fetch_dpd.sh
Description: Binary data


reply via email to

[Prev in Thread] Current Thread [Next in Thread]