RE: [Hardhats-members] Importing FDA national drug files: Request for Comments

[Cameron Schlehuber]

You may want to consider at least keeping up with the patches regularly released for the National Drug File (PSN* patches).  They’ll at least continue until the faster turn around is in place.   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Toppenberg Sent: Friday, November 25, 2005 6:39 PM To: Hardhats Sourceforge Subject: [Hardhats-members] Importing FDA national drug files: Request for Comments   Cameron has said that the VA is working such that "someday" peripheral sites will get updates to National drug file entries at near real time via HL-7 messages. But until then I am thinking about importing the files distributed by the FDA, found here: http://www.fda.gov/cder/ndc/ It looks like a straightforward database dump. It consists of 7 interlinking files in ASCII format I thought that I would do the following: 1. Create new files in Fileman directly mirroring the structure of the FDA files. 2. Import the data into Fileman 3. Use these new, independant files to populate/update/cleanup my VA PRODUCT file. Is this a good idea? Any thoughts? Kevin