Search
Facebook
Twitter
LinkedIn
User Forum Logo

user forum

Welcome Guest

IMPORTANT:
this is not a Support Forum! Experienced users might answer from time to time questions posted here. If you need a professional and reliable answer, or if you want to report a bug, please contact Altova Support instead.

Altova User Forums » Members » domjc1962

Profile: domjc1962
About
User Name: domjc1962
Forum Rank: Newbie
Real Name:
Location United States
Occupation:
Interests:
Gender: None Specified
Statistics
Joined: Monday, January 26, 2015
Last Visit: Wednesday, August 22, 2018 9:27:39 PM
Number of Posts: 4
[0.02% of all post / 0.00 posts per day]
Avatar
Last 10 Posts
Topic: Excel to XML multiple tabs
Posted: Saturday, January 31, 2015 3:40:45 PM
Thank you VLAD
Topic: Excel to XML multiple tabs
Posted: Friday, January 30, 2015 9:06:24 PM
This is the XML im currently getting - I think I need a filter - I have tried setting a filter but it is not working

I have attached the spreadsheet im trying to create an XML from
I have attached the saved mapping
First Tab is a list of loans
Second tab is a list of loan amounts by sequence

sequence is the linker between tabs

XSD is to large to attach

<?xml version="1.0" encoding="UTF-8"?>
<DEAL xmlns="http://www.mismo.org/residential/2009/schemas" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.mismo.org/residential/2009/schemas C:/Users/domjc1962/Desktop/UCD33~1.029/V3.3.0_CR_2014-02/ReferenceModel_v3.3.0_B299/Combined/MISMO_3.3.0_B299.xsd">
<LOANS>
<LOAN SequenceNumber="1">
<LOAN_DETAIL>
<TotalSubordinateFinancingAmount>12</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>23</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>34</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>45</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>546</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>34</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>45</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>56</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>45</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>34</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>23</TotalSubordinateFinancingAmount>
</LOAN_DETAIL>
</LOAN>
<LOAN SequenceNumber="2">
<LOAN_DETAIL>
<TotalSubordinateFinancingAmount>12</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>23</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>34</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>45</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>546</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>34</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>45</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>56</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>45</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>34</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>23</TotalSubordinateFinancingAmount>
</LOAN_DETAIL>
</LOAN>
<LOAN SequenceNumber="3">
<LOAN_DETAIL>
<TotalSubordinateFinancingAmount>12</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>23</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>34</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>45</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>546</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>34</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>45</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>56</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>45</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>34</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>23</TotalSubordinateFinancingAmount>
</LOAN_DETAIL>
</LOAN>
<LOAN SequenceNumber="4">
<LOAN_DETAIL>
<TotalSubordinateFinancingAmount>12</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>23</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>34</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>45</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>546</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>34</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>45</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>56</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>45</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>34</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>23</TotalSubordinateFinancingAmount>
</LOAN_DETAIL>
</LOAN>
<LOAN SequenceNumber="5">
<LOAN_DETAIL>
<TotalSubordinateFinancingAmount>12</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>23</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>34</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>45</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>546</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>34</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>45</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>56</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>45</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>34</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>23</TotalSubordinateFinancingAmount>
</LOAN_DETAIL>
</LOAN>
<LOAN SequenceNumber="6">
<LOAN_DETAIL>
<TotalSubordinateFinancingAmount>12</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>23</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>34</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>45</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>546</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>34</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>45</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>56</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>45</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>34</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>23</TotalSubordinateFinancingAmount>
</LOAN_DETAIL>
</LOAN>
</LOANS>
</DEAL>

This is the XML im trying to get

<?xml version="1.0" encoding="UTF-8"?>
<DEAL xmlns="http://www.mismo.org/residential/2009/schemas" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.mismo.org/residential/2009/schemas C:/Users/domjc1962/Desktop/UCD33~1.029/V3.3.0_CR_2014-02/ReferenceModel_v3.3.0_B299/Combined/MISMO_3.3.0_B299.xsd">
<LOANS>
<LOAN SequenceNumber="1">
<LOAN_DETAIL>
<TotalSubordinateFinancingAmount>12</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>23</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>34</TotalSubordinateFinancingAmount>
</LOAN_DETAIL>
</LOAN>
<LOAN SequenceNumber="2">
<LOAN_DETAIL>
<TotalSubordinateFinancingAmount>45</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>546</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>34</TotalSubordinateFinancingAmount>
</LOAN_DETAIL>
</LOAN>
<LOAN SequenceNumber="3">
<LOAN_DETAIL>
<TotalSubordinateFinancingAmount>45</TotalSubordinateFinancingAmount>
<TotalSubordinateFinancingAmount>56</TotalSubordinateFinancingAmount>
</LOAN_DETAIL>
</LOAN>
<LOAN SequenceNumber="4">
<LOAN_DETAIL>
<TotalSubordinateFinancingAmount>45</TotalSubordinateFinancingAmount>
</LOAN_DETAIL>
</LOAN>
<LOAN SequenceNumber="5">
<LOAN_DETAIL>
<TotalSubordinateFinancingAmount>34</TotalSubordinateFinancingAmount>
</LOAN_DETAIL>
</LOAN>
<LOAN SequenceNumber="6">
<LOAN_DETAIL>
<TotalSubordinateFinancingAmount>23</TotalSubordinateFinancingAmount>
</LOAN_DETAIL>
</LOAN>
</LOANS>
</DEAL>

Use of the Altova User Forum(s) is governed by the Altova Terms of Use.

Use of this site is governed by our Terms of Use, Privacy Policy & Cookie Policy. Copyright 2005-2018 Altova. All Rights Reserved. Patents Pending.