|
| | | Forum Newbie
Group: Forum Members
Last Login: 4/18/2007 1:27:00 PM
Posts: 4, Visits: 10 |
| I have been in contact with efanniemae, signed their NDA, etc and received the documents for their data integrity and information for their system. Unfortunately nowhere in there does it explicity say how to actually CREATE the .fnm file!! Does anyone know of a forum or support place to go to find this information? It took months just to get this data and I would hate to wait another month for this info...
Thanks in advance. |
| |
| | | 
Supreme Being
Group: Moderators
Last Login: 12/21/2008 11:16:31 PM
Posts: 837, Visits: 1,901 |
| The data format is really a positional text file. If you export a Fannie Mae file directly from Point, you can open the file in notepad and see how the file is arranged. As far as creating the actual data file, I'm not aware of any forums. Why do you want to use the Fannie format? How many fields do you want to import?
Bryan
Point Product Manager |
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 4/18/2007 1:27:00 PM
Posts: 4, Visits: 10 |
| | Thanks Bryan! We have created our own online mortgage application for our clients/users. We researched several options and decided to do our own because of specific requirements for our system and interface after the application is entered. The system collects about 75% of the traditional 1003 and right now the output file is a csv file. I could create the mapping to import it into Point but we were thinking it would be easier to put it in the .fnm file for easier importing and transferring... Do you think that it is worthwile or should I just do a mapping? In the future we are hoping to add a credit score integration, etc... |
| |
| | |
Supreme Being
Group: Moderators
Last Login: 12/21/2008 11:16:31 PM
Posts: 837, Visits: 1,901 |
| The Fannie format has the entire 1003 but it does not capture the credit scores. You would need to run a second import (CSV) to import the scores. I am not a big fan of the Fannie format for importing data, because it limits your flexibility. I don't know if you considered our mortgage website product WebCaster. It imports a Point file to your system. If you have an existing website, you can frame just the loan application (has about 75% of the entire 1003). I'm curious about your credit score integration.
Bryan
Point Product Manager |
| |
| | | 
Supreme Being
Group: Forum Members
Last Login: 9/12/2008 11:24:50 AM
Posts: 289, Visits: 242 |
| | There is a pre-written utility that would do this for you. Drop me an email for more info. Aside from the 3rd party utility, building a FNMA3.2 file is tedious but not rocket science. I found it easiest to write a class for each segment and place the repeating classes into a collection class. Each class controls the sub-segment length automatically. From there, the only chore is mapping your data to the correct segment. Since the "fields" are simply segments delimited by CRLF and positions, writing the file isn't hard. You do have to make sure that each field is formatted correctly but I do that automatically in the classes. Make sure you use the EDI document while you're creating the classes or you'll end up with the wrong information in the fields. As an aside, a Calyx Point file is far more complete in terms of loan boarding and processing. It doesn't offer the ability to automatically upload to an AUS except through the Point interface but you could use the utility mentioned to transfer between the formats.
- Mike
mike@mtig.biz |
| |
|
|