Solved

Convert web site form to Fannie Mae 3.2 file

Posted on 2004-08-02
4
1,800 Views
Last Modified: 2016-09-06
I designed a web site for a mortgage company.  I need to convert data from a web site form into a fannie mae 3.2 file.  My client wants to take information that is submitted on a form from their web site and import it into Calyx Point(popular software in the mortgage industry). Somehow, the data from the form needs to be converted to a fannie mae 3.2 file format.  That is the file format that can import directly to Calyx Point.
0
Comment
Question by:Jenny5
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 25

Accepted Solution

by:
Marcus Bointon earned 500 total points
ID: 11697007
It looks like Fannie Mae doesn't publish its file format, so I think you're out of luck in that approach. Fortunately according to: http://www.calyxsoftware.com/solutions/point/features.asp#dataimport Calyx point can import from ASCII formats as well as Fannie Mae. All you need to do is find out how it likes its ASCII data formatted and you should have no difficulty exporting from PHP (in whatever database your data currently resides). The best approach is to either obtain the user documentation for Point, or contact Calyx and ask them how data should be formatted - most data-tool companies are much more co-operative in telling people how to get data into their software than the other direction!
0
 

Expert Comment

by:Georgetpug
ID: 13878622
The fannie mae format is a character delimited text file.
So what you would need to do is format the output of the form (or database) to the Fannie mae 3.2 format.

The output file will look something similar to:
EH                                                  
TH T100099-0021        
TPI 1.0001                              
0001  3.20 W
00ANN
01A01                                                                                      

Where the EH, TH, TPI are simply the headers for the data format.                                            
1

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
deprecated mysql extensions 1 55
How to use 2 ON statements in inner join 3 44
A responsive image gallery using flexbox 6 79
Load string Array from file 23 42
Foreword (July, 2015) Since I first wrote this article, years ago, a great many more people have begun using the internet.  They are coming online from every part of the globe, learning, reading, shopping and spending money at an ever-increasing ra…
3 proven steps to speed up Magento powered sites. The article focus is on optimizing time to first byte (TTFB), full page caching and configuring server for optimal performance.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question