Mark, Mark, I'm guessing you're dealing with a non-veteran population.
I don't have time to test using the Fileman Import function, but I was able to "get a record into the patient file" programmatically by filling in the fields Mr. Holloway calls out in his message, as I expected I could. NAME: SHMISKISS,HAROLD H SEX: MALE DATE OF BIRTH: 02/17/1955 SOCIAL SECURITY NUMBER: 027458887 DATE ENTERED INTO FILE: JUL 29, 2005 SERVICE CONNECTED?: NO MULTIPLE BIRTH INDICATOR: NO TYPE: EMPLOYEE VETERAN (Y/N)?: NO So he has correctly identified the absolute minimum number of fields needed to "get a patient into the database". And you can definitely get the records in there programmatically by stuffing data into these fields. But, when you then go back in to view a record created this way via the legitimate VistA options used to view and edit the data, you get multiple inconsistencies. This is what I was talking about in terms of data integrity. SHMISKISS,HAROLD H (027-45-8887) FEB 17,1955 ============================================================================ 5 - MARITAL STATUS UNSPECIFIED 6 - RELIGION UNSPECIFIED 8 - ADDRESS DATA INCOMPLETE 13 - POS UNSPECIFIED 14 - ELIG CODE UNSPECIFIED 52 - INSURANCE PROMPT UNANSWERED 53 - EMPLOYMENT STATUS UNANSWERED 61 - MISSING PHONE NUMBER DATA 62 - EMERGENCY CONTACT NAME MISSING 99 - CAN'T PROCESS FURTHER It will be interesting to see if you can get the records into the database using Fileman Import, after "manufacturing" data to stuff into the Service Connected, Multiple Birth Indicator, Type, etc, fields that I'm assuming you don't have. If that's what you chose to do. Please let me know if it works. But the follow-on questions related to this in my mind are. 1. Are fields like "Type", "Service Connected?" even relevant to a non-VA database? And, should they be "required identifiers". 2. And, do you want to manufacture data like "multiple birth indicator", "Veteran(Y/N)?" just to get records into your database? Will that data be correct? Do you care? These are interesting questions, I think. My hope is that Vista Office has done away with some of the "VA specific-ness" we see here. I'm guessing they might have. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Holloway, Thomas (EDS) Sent: Friday, July 29, 2005 10:48 AM To: hardhats-members@lists.sourceforge.net Subject: RE: [Hardhats-members] Importing Mass Data Mark, The data dictionary lists these fields as required identifiers: IDENTIFIED BY: SEX (#.02)[R], DATE OF BIRTH (#.03)[R], SOCIAL SECURITY NUMBER (#.09)[R], STREET ADDRESS 1 (CIVIL) (#.2924), SERVICE CONNECTED? (#.301)[R], SERVICE CONNECTED PERCENTAGE (#.302), TYPE (#391)[R], MULTIPLE BIRTH INDICATOR (#994), VETERAN (Y/N)? (#1901)[R] Also, AGE is a computed field so you shouldn't try to fill it directly. FileMan will compute it when referenced based on DOB and current date. tjh The squeaky wheel doesn't always get the grease. Sometimes it gets REPLACED. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Goudie Sent: Friday, July 29, 2005 11:21 AM To: hardhats-members@lists.sourceforge.net Subject: Re: [Hardhats-members] Importing Mass Data Im just trying to imporant a file with 1 record and i keep getting an error. Do you want to proceed with the import? y YES Following error messages were generated when import failed. The list of fields is missing a required identifier for File #2. The list of fields is missing a required identifier for File #2. The list of fields is missing a required identifier for File #2. This is my setup in fileman DATA IMPORT Page 1 =========== DATA FORMAT SOURCE FILE ----------- ----------- Internal or external: EXTERNAL Full path: /home/vista Host file name: test.csv Foreign format: EXCEL (COMMA) OR Data fixed length? VA FILEMAN FILE Field delimiter: --------------- Fields quoted? Primary file: PATIENT Field selection page... OR Import Template: FIELD SELECTION FOR IMPORT Page 2 ========================== Choose a field from PATIENT Field: Delete last field selected? These are the fields selected so far: 1 - NAME 2 - AGE 3 - SOCIAL SECURITY NUMBER 4 - SEX 5 - DATE OF BIRTH My file looks like this Test Import,36,111111111,Male,3050812^M On 7/28/05, Sowinski, Richard J. <[EMAIL PROTECTED]> wrote: > The Fileman User manual is posted here where all the other VistA > documentation is. > > http://www.va.gov/vdl/ > > But, as I have said, if you are trying to import data into anything other > than the simplest VistA files using the Fileman Import function, you will > not be successful. > > You will have to write Mumps code that opens a host file, reads in the data, > and files it (sometimes in a certain required sequence). > > It just depends on what your target files are in VistA. > > Good luck. > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Mark > Goudie > Sent: Thursday, July 28, 2005 2:57 PM > To: hardhats-members@lists.sourceforge.net > Subject: Re: [Hardhats-members] Importing Mass Data > > I can make the data conform to anything, I just dont know what to > make it look like to be imported by file man succesfully. Any links > to documentation about this? > > On 7/27/05, Sowinski, Richard J. <[EMAIL PROTECTED]> wrote: > > Mark, my answer to your question is that it really depends on what data > you > > are trying to import. > > > > If the data you are importing is complete, and the Vista files you are > > importing it to, have simple input transforms and no data integrity > > constraints, it is pretty easy to import data using the Fileman import > > function. > > > > If, on the other hand, you are trying to import data to a file with > complex > > input transforms and data integrity constraints, you may have difficulty > > (translated no luck at all) using the Fileman import functionality. > > > > In this case, you will have to write software that parses the data and > files > > it in the sequence that meets the data integrity constraints imposed by > the > > Data Dictionary within VistA for the file(s) you are working with. Plus, > the > > data must meet the input transform criteria for each individual field. > > > > It would be an odd coincidence for two databases to match each other so > > closely, on every field. So usually some "conversion" of certain fields is > > necessary. > > > > I can tell you that for certain VistA files, this is not work for a > > beginner, or the squeamish. > > > > Good Luck. > > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Mark > > Goudie > > Sent: Wednesday, July 27, 2005 1:48 PM > > To: hardhats-members@lists.sourceforge.net > > Subject: [Hardhats-members] Importing Mass Data > > > > Im looking at importing alot of data into a vista server, anyone have > > any experience doing this? If so how did you do it? > > -- > > - Mark Goudie > > > > > > ------------------------------------------------------- > > SF.Net email is Sponsored by the Better Software Conference & EXPO > September > > 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices > > Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA > > Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf > > _______________________________________________ > > Hardhats-members mailing list > > Hardhats-members@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/hardhats-members > > > > > > ------------------------------------------------------- > > SF.Net email is Sponsored by the Better Software Conference & EXPO > September > > 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices > > Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA > > Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf > > _______________________________________________ > > Hardhats-members mailing list > > Hardhats-members@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/hardhats-members > > > > > -- > - Mark Goudie > > > ------------------------------------------------------- > SF.Net email is Sponsored by the Better Software Conference & EXPO September > 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices > Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA > Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf > _______________________________________________ > Hardhats-members mailing list > Hardhats-members@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/hardhats-members > > > ------------------------------------------------------- > SF.Net email is Sponsored by the Better Software Conference & EXPO September > 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices > Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA > Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf > _______________________________________________ > Hardhats-members mailing list > Hardhats-members@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/hardhats-members > -- - Mark Goudie ------------------------------------------------------- SF.Net email is Sponsored by the Better Software Conference & EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf _______________________________________________ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members ------------------------------------------------------- SF.Net email is Sponsored by the Better Software Conference & EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf _______________________________________________ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members ------------------------------------------------------- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click _______________________________________________ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members