Processing to add/create real fields in an existing file

[GCC Consulting]

  _____  

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

 As John asked
1. What is the format(s) of the file(s) you are importing.
2. How many different organizations are you getting files from
3. How long do you need to hold this data
 
You could create you own file, create processing based on who the sender is
(their file layout), read the date into either declared or dummy fields and the
post it to your file for analysis.
 
You could start the process from *clerk using @entsel and a listbox of
organization names.  Select the organization and the call the correct processing
table to import and post the data to you analysis file.
 
This may not be a "clean" as creating a file on the fly, but it will give you
control over what is coming in.  You may want to post first to a working file
just to verify the data before finally posting to your working file.  
 
Richard Kreiss
GCC Consulting 

 


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