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
