Best way to process MISMO File

Vinoy K P
Vinoy K P used Ask the Experts™
on
SampleMISMO.txt
hi ,
We have a project to implement Fannie Mae' new file format(MISMO) for LOAN Application . I attached a sample file for reference . Which will be best technical approach
to handle this kind of XML Files ? Please advice.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016

Commented:
I attached a sample file for reference
Where?

Author

Commented:
Sorry I Uploaded again .
Top Expert 2016

Commented:
In theory, any good xml parser will be fine. It's well-formed xml with a schema
OWASP Proactive Controls

Learn the most important control and control categories that every architect and developer should include in their projects.

Author

Commented:
Actually i am concerned about how i can group the values in the various tags. If you see the RELATIONSHIP tag in the sample XML
SequenceNumber="1" xlink:from="ASSET_1" xlink:to="BORROWER_1" i need to pick the corresponding sub tags of this ASSET_1 and it should be associated with BORROWER_1.
The same way it should follow for other labels. i hope you follow.
Top Expert 2016

Commented:
Before you get into building your own parser, it might be worth checking with the people who provide this schema whether any software tools are available
Top Expert 2016

Commented:
Are you in effect saying you want to collect all asset info for all borrowers or is it different?

Author

Commented:
Yes , It would be nice if i can group the information per borrower like Borrower 1 and his Assets and its Liabilities .  All these group info into one Java Object.
Top Expert 2016

Commented:
See if there any tools. Otherwise it's a custom parser i'm afraid
It Looks like i need to build custom parser for this . Thanks for the help.
Top Expert 2016

Commented:
ok - just don't be tempted to do it with anything other than xml tools ;)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial