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: [email protected]
> 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: [email protected]
> > 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
> > [email protected]
> > 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
> > [email protected]
> > 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
> [email protected]
> 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
> [email protected]
> 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/hardhats-members
