Re: [Hardhats-members] Importing Mass Data

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

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.

This is my setup in fileman

 DATA IMPORT                          Page 1
                                  =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

               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
                          =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
 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. <Ric...@me...> wrote:
> The Fileman User manual is posted here where all the other VistA
> documentation is.
>=20
> http://www.va.gov/vdl/
>=20
> 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.
>=20
> You will have to write Mumps code that opens a host file, reads in the da=
ta,
> and files it (sometimes in a certain required sequence).
>=20
> It just depends on what your target files are in VistA.
>=20
> Good luck.
>=20
> -----Original Message-----
> From: har...@li...
> [mailto:har...@li...] On Behalf Of Mark
> Goudie
> Sent: Thursday, July 28, 2005 2:57 PM
> To: har...@li...
> Subject: Re: [Hardhats-members] Importing Mass Data
>=20
> 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?
>=20
> On 7/27/05, Sowinski, Richard J. <Ric...@me...> 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 difficult=
y
> > (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: har...@li...
> > [mailto:har...@li...] On Behalf Of Mark
> > Goudie
> > Sent: Wednesday, July 27, 2005 1:48 PM
> > To: har...@li...
> > 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/bsce5=
sf
> > _______________________________________________
> > Hardhats-members mailing list
> > Har...@li...
> > 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/bsce5=
sf
> > _______________________________________________
> > Hardhats-members mailing list
> > Har...@li...
> > https://lists.sourceforge.net/lists/listinfo/hardhats-members
> >
>=20
>=20
> --
> - Mark Goudie
>=20
>=20
> -------------------------------------------------------
> SF.Net email is Sponsored by the Better Software Conference & EXPO Septem=
ber
> 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
> Agile & Plan-Driven Development * Managing Projects & Teams * Testing & Q=
A
> Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
> _______________________________________________
> Hardhats-members mailing list
> Har...@li...
> https://lists.sourceforge.net/lists/listinfo/hardhats-members
>=20
>=20
> -------------------------------------------------------
> SF.Net email is Sponsored by the Better Software Conference & EXPO Septem=
ber
> 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
> Agile & Plan-Driven Development * Managing Projects & Teams * Testing & Q=
A
> Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
> _______________________________________________
> Hardhats-members mailing list
> Har...@li...
> https://lists.sourceforge.net/lists/listinfo/hardhats-members
>=20

--=20
- Mark Goudie