Thanks to all the comments, references and detailed steps. I really appreciate the help.
I'll try these steps some time next week and hope it will work for me. -- Meyer >>> [EMAIL PROTECTED] 10/28/05 10:05 AM >>> I don't have any sample data, but I have imported real patients. Thurman sent me a routine, which I tried, but didn't get to work, so I started with FileMan. This actually applies to any file import, like referring doctors, cpt codes, etc. I got most of this from the FileMan documentation from VDL. 1. FileMan has "mandatory" fields for each file, so you either need to import these, or change the file attributes so that they are no longer "mandatory". The latter is actually easier. Using the Data Dictonary option in FileMan, display the fields, and make note of those, "mandatory" fields you don't want to import. You can also display a list of "required" fields if you install VPE from the hardhats site. Then "MODify file attributes" to change "mandatory" to "no" for these fields. 2. Export your data from your old system to a spreadsheet, choose the fields you want to import and save those columns. You may have to concatenate names to fit the default FileMan .01 NAME format of LAST,FIRST M. Save this as a comma delimited file, with text in quotes. Make note of the order of the fields and the data they contain. 3. Enter FileMan and under "OTHer options", choose import data. You have 'external data', enter the full path of the source file then the file name. You can choose your saved format under 'foreign format' or just tell FileMan how you saved it: no to fixed length, comma delimited and yes to fields quoted. Then enter "Patient" or the destination file in "VA Primary file". 4. Choose 'field selection page' (or saved template the second time you do it). You are then presented with the selection page where you specify the fields, in the order that they appear in the saved file. 5. When you have selected all the fields you wish to import, exit, save and run the import. If you didn't fill or remove the 'mandatory' for a required field you'll get an error which doesn't tell you which field. Format errors, like dob or ssn are identified. Good luck, Mike Kevin Toppenberg wrote: > What?? You couldn't find any easy How-To in the VDL (VistA Doc > Library)? TiskTisk! LOL! > > Sorry, about the bad joke. Don't feel bad about the difficulty in the > VDL. It takes quite a while before you can get to the point where the > documents start to make sense. > > There was a post recently about this (about 2 months ago). Do a > search in the archives for "import" and "patients". > > As I recall, they put the data into an .xml spreadsheet, then used the > fileman import into the PATIENT file. > > The key issue is to ensure that each record that is imported has > certain fields that are "required" fields. E.g. Patient Type, SSN, > Vetaran? Y/N > > If I can find that post, I'll put a URL here. > > Kevin > > > On 10/27/05, Meyer Tanuan <[EMAIL PROTECTED]> wrote: > >>Hi: >> >>1. I found a few threads on importing mass data, but can't seem to find a >>general procedure/tutorial on how to do it properly. Does anyone have a set >>of sample patient data that can be shared for educational purposes? >> >>2. I checked Vista Doc Library and can't seem to find the right document. Is >>there any known procedure/documentation for importing patient data? >> >>Thanks, >>Meyer >> >> >>------------------------------------------------------- >>This SF.Net email is sponsored by the JBoss Inc. >>Get Certified Today * Register for a JBoss Training Course >>Free Certification Exam for All Training Attendees Through End of 2005 >>Visit http://www.jboss.com/services/certification for more information >>_______________________________________________ >>Hardhats-members mailing list >>[email protected] >>https://lists.sourceforge.net/lists/listinfo/hardhats-members >> > > > > ------------------------------------------------------- > This SF.Net email is sponsored by the JBoss Inc. > Get Certified Today * Register for a JBoss Training Course > Free Certification Exam for All Training Attendees Through End of 2005 > Visit http://www.jboss.com/services/certification for more information > _______________________________________________ > Hardhats-members mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/hardhats-members > ------------------------------------------------------- This SF.Net email is sponsored by the JBoss Inc. Get Certified Today * Register for a JBoss Training Course Free Certification Exam for All Training Attendees Through End of 2005 Visit http://www.jboss.com/services/certification for more information _______________________________________________ Hardhats-members mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/hardhats-members ------------------------------------------------------- This SF.Net email is sponsored by the JBoss Inc. Get Certified Today * Register for a JBoss Training Course Free Certification Exam for All Training Attendees Through End of 2005 Visit http://www.jboss.com/services/certification for more information _______________________________________________ Hardhats-members mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/hardhats-members
