goofy78270
Technical User
I currently have the following information in one xml document, but the file list is getting rather large as I am looking to add more documents to the list and more attributes to each branch such as location, phone, etc.. I would like to take out all common data, and put this in one xml file and then list all documents in the second xml file, but how do I link the branch in the first xml to the files in the second xml?
Original code:
First New XML:
Second New XML:
Original code:
Code:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Rows xmlns:xsi="[URL unfurl="true"]http://www.w3.org/2001/XMLSchema-instance">[/URL]
<Row>
<Branch>10</Branch>
<Region>Michigan</Region>
<State>MI</State>
<BranchDoc>Pricing Matrix</BranchDoc>
<BranchDocName>10 Pricing.xls</BranchDocName>
</Row>
<Row>
<Branch>10</Branch>
<Region>Michigan</Region>
<State>MI</State>
<BranchDoc>GFE Matrix (Branch, Wholesale, Retail)</BranchDoc>
<BranchDocName>10 GFE.xls</BranchDocName>
</Row>
<Row>
<Branch>10</Branch>
<Region>Michigan</Region>
<State>MI</State>
<BranchDoc>Subdivision Matrix</BranchDoc>
<BranchDocName>10 Subdivision.xls</BranchDocName>
</Row>
<Row>
<Branch>10</Branch>
<Region>Michigan</Region>
<State>MI</State>
<BranchDoc>Wholesale / Retail Lender Directory</BranchDoc>
<BranchDocName>Area GL Directory.xls</BranchDocName>
</Row>
<Row>
<Branch>10</Branch>
<Region>Michigan</Region>
<State>MI</State>
<BranchDoc>Michigan Closing Data</BranchDoc>
<BranchDocName>Michigan Closing Data.doc</BranchDocName>
</Row>
<Row>
<Branch>10</Branch>
<Region>Michigan</Region>
<State>MI</State>
<BranchDoc>Escrow Tax Chart</BranchDoc>
<BranchDocName>Michigan Tax Chart.doc</BranchDocName>
</Row>
...
First New XML:
Code:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Branches xmlns:xsi="[URL unfurl="true"]http://www.w3.org/2001/XMLSchema-instance">[/URL]
<Branch>
<Branch>10</Branch>
<Region>Michigan</Region>
<State>MI</State>
<Phone>123-456-7890</Phone>
<StreetAddress>1234 Main Street</StreetAddress>
...More Attributes
</Branch>
...
Second New XML:
Code:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Files xmlns:xsi="[URL unfurl="true"]http://www.w3.org/2001/XMLSchema-instance">[/URL]
<Doc>
<Branch>10</Branch>
<BranchDoc>Pricing Matrix</BranchDoc>
<BranchDocName>10 Pricing.xls</BranchDocName>
</Doc>
<Doc>
<Branch>10</Branch>
<BranchDoc>GFE Matrix (Branch, Wholesale, Retail)</BranchDoc>
<BranchDocName>10 GFE.xls</BranchDocName>
</Doc>
...More Documents