<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1458" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff
size=2></FONT> </DIV><BR>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> filepro-list-bounces@lists.celestial.com
[mailto:filepro-list-bounces@lists.celestial.com] <B>On Behalf Of </B>John
Koenig<BR><B>Sent:</B> Sunday, August 15, 2004 8:17 PM<BR><B>To:</B> Filepro
List<BR><B>Subject:</B> Processing to add/create real fields in an existing
file<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>Filepro Experts:<BR><BR> I import files that contain information
regarding pools of mortgages, which I then analyze using Filepro. <BR>These
files do not have a uniform format as they are from various mortgage
lenders.<BR><BR>The processing that I have written requires that the output be
stored in <B><U>real field</B></U>s within the file that I have imported.
Therefore<BR>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.<BR><BR>Is there a simple way to
add real fields to a file via a filepro processing table (dos/windows
version)? <BR><BR>For example:<BR><BR>Say I have a mortgage file (named
"mortgage") with the following fields.<BR><BR>1)
MortgageAmount 10, $<BR>2)
Rate
6, F<BR>3)
Term
3,.0<BR>4)
ClosingDate
8,yymd<BR><BR>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 <U>mortgage </U>file itself since I always import the new<BR>data into
the same file for initial processing with the standard processing table I have
written.<BR><BR>5)
maturityDate
8,yymd<BR>6)
maturityMonth 3,*<BR><BR>My
thanks in advance for any help!<BR><BR>Regards,<BR><BR>John
Koenig<BR><BR><SPAN class=615364614-16082004><FONT face=Arial color=#0000ff
size=2> As John asked</FONT></SPAN></DIV>
<DIV><SPAN class=615364614-16082004><FONT face=Arial color=#0000ff
size=2>1. What is the format(s) of the file(s) you are
importing.</FONT></SPAN></DIV>
<DIV><SPAN class=615364614-16082004><FONT face=Arial color=#0000ff size=2>2.
How many different organizations are you getting files
from</FONT></SPAN></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=615364614-16082004>3. How long do you need to hold this
data</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=615364614-16082004></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=615364614-16082004>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.</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=615364614-16082004></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=615364614-16082004>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.</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=615364614-16082004></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=615364614-16082004>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. </SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=615364614-16082004></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=615364614-16082004><!-- Converted from text/plain format -->
<P><FONT size=2>Richard Kreiss<BR>GCC Consulting
</FONT></P> </SPAN></FONT></FONT></FONT><BR></DIV></BLOCKQUOTE></BODY></HTML>