File #2, otherwise known as the Patient File is one of those files, where there are data integrity constraints.
I believe you might have to file your data in a certain sequence in order to establish records in that file. A way to track down that sequence might be to look at the Routines tied to the Register a Patient option, or, Load/Edit Patient Data. There used to be some routines in the CIRN namespace that could create records in the Patient File non-interactively (which would be an excellent guide for you), but I don't know that they still exist or are part of the FOIA release. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Goudie Sent: Friday, July 29, 2005 10: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