Processing to add/create real fields in an existing file

[John Esak]

See my message to Mark... I did not see your message at first. You can use
the "autoshuf" program to do what you want... with some, well, fairly
sophisticated processing as well. You would import the fields from a file...
determine at that time how many fields would be needed in the destination
file, write them out directly to the map.temp file of that filePro file with
I/O functions and then issue the autoshuf command against that file.  Or,
better yet, if there is NO data in that destination file (and there probably
wouldn't be...) just directly re-write the map to be what you need. (i.e.,
add the fields, then modify the top line of the map file to reflect the
changes.)

However, there is one thing I don't understand. How are you importing the
fields into the current file if you don't already have "it" set up to have
the proper fields??  Or, are you trying to import the data into another
file... the destination file we are talking about?

Also, last thought, if the data is coming in various formats, assuming they
are structured somehow... could you just overlay an alien file against the
data-source file and do your work right there?

More explanation would help... as to what exactly you are doing and wanting
to do.

John Esak

  -----Original Message-----
  From: filepro-list-bounces at lists.celestial.com
[mailto:filepro-list-bounces at lists.celestial.com]On Behalf Of John Koenig
  Sent: Sunday, August 15, 2004 8:17 PM
  To: Filepro List
  Subject: Processing to add/create real fields in an existing file


  Filepro Experts:

   I import files that contain information regarding pools of mortgages,
which I then analyze using Filepro.
  These files do not have a uniform format as they are from various mortgage
lenders.

  The processing that I have written requires that the output be stored in
real fields within the file that I have imported. Therefore
  declaring values will not work. At least I don't see how it would solve my
problem. As a consequence after importing a file I find myself MANUALLY
entering these fields time (various date fields such date next interest
change etc) again and again.

  Is there a simple way to add  real fields to a file via a filepro
processing table (dos/windows version)?

  For example:

  Say I have a mortgage file (named "mortgage") with the following fields.

  1)  MortgageAmount   10, $
  2)  Rate                       6, F
  3)  Term                       3,.0
  4)   ClosingDate             8,yymd

  I would like to write a filepro process (dos version)  that would
automatically add the following fields to the map so that I can calculated
the maturity date and store it in the file. The process can reside in the
mortgage file itself since I always import the new
  data into the same file for initial processing with the standard
processing table I have written.

  5)   maturityDate            8,yymd
  6)   maturityMonth         3,*

  My thanks in advance for any help!

  Regards,

  John Koenig


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.celestial.com/pipermail/filepro-list/attachments/20040815/f091e529/attachment.html