Jump to content
Make Add-ons Better

Help with XML Example

CCBtx

By CCBtx
in XML/XSL

 Share

This topic is 4429 days old. Please don't post here. Open a new topic instead.

Recommended Posts

CCBtx Community Regular

CCBtx

Posted
Posted

I have the following xsl.  After the xsl, I have listed the xml example.

 

The xsl imports each "region" record perfectly.  If you will notice, in this example, there are 78 and I get 78 records imported.

 

I also, however, want to import the <list><count> record (78) and the <message><code> (0) record.

 

Can somone modify my xsl to import those?

 

Thanks.

 

 

<xsl:template match="/">
<FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">
<ERRORCODE>0</ERRORCODE>
<PRODUCT BUILD="" NAME="FileMaker" VERSION="ProAdvanced 12.0v2"/>
<DATABASE DATEFORMAT="" LAYOUT="" NAME="" RECORDS="" TIMEFORMAT=""/>

<METADATA>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="list" TYPE="TEXT" />
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="id" TYPE="TEXT" />
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="name" TYPE="TEXT" />
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="zindex" TYPE="TEXT" />
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="latitude" TYPE="TEXT" />
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="longitude" TYPE="TEXT" />
</METADATA>

<RESULTSET FOUND="">
<xsl:for-each select="//list/region">
<ROW RECORDID="" MODID="" >
<COL><DATA><xsl:value-of select="id"/></DATA></COL>
<COL><DATA><xsl:value-of select="name"/></DATA></COL>
<COL><DATA><xsl:value-of select="zindex"/></DATA></COL>
<COL><DATA><xsl:value-of select="latitude"/></DATA></COL>
<COL><DATA><xsl:value-of select="longitude"/></DATA></COL>
</ROW>
</xsl:for-each>
</RESULTSET>
</FMPXMLRESULT>
</xsl:template>
</xsl:stylesheet>

 

 

<?xml version="1.0" encoding="utf-8"?>
<RegionChildren:regionchildren xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.zillow.com/static/xsd/RegionChildren.xsd http://www.zillowstatic.com/vstatic/06a8f7686d49e3474a5513a28d0b106c/static/xsd/RegionChildren.xsd" xmlns:RegionChildren="http://www.zillow.com/static/xsd/RegionChildren.xsd">
<request>
 <state>CO</state>
 <city>Denver</city>
 <childtype>neighborhood</childtype>
</request>
 <message>
  <text>Request successfully processed</text>
  <code>0</code>
 </message>
<response>
 <region>
  <id>11093</id>
  <latitude>39.764339</latitude>
  <longitude>-104.85511</longitude>
 </region>
 <subregiontype>neighborhood</subregiontype>
 <list>
  <count>78</count>
 <region>
  <id>6018</id>
  <name>Montbello</name>
  <zindex currency="USD">127400</zindex>
  <url>http://www.zillow.com/local-info/CO-Denver/Montbello/r_6018/</url>
  <latitude>39.783938</latitude>
  <longitude>-104.856797</longitude>
 </region>
 <region>
  <id>273809</id>
  <name>Gateway / Green Valley Ranch</name>
  <zindex currency="USD">162800</zindex>
  <url>http://www.zillow.com/local-info/CO-Denver/Gateway-_-Green-Valley-Ranch/r_273809/</url>
  <latitude>39.783851</latitude>
  <longitude>-104.77206</longitude>
 </region>
 <region>
  <id>268671</id>
  <name>Hampden</name>
  <zindex currency="USD">250900</zindex>
  <url>http://www.zillow.com/local-info/CO-Denver/Hampden/r_268671/</url>
  <latitude>39.6648</latitude>
  <longitude>-104.898038</longitude>
 </region>
 <region><id>268778</id><name>Westwood</name><zindex currency="USD">116900</zindex><url>http://www.zillow.com/local-info/CO-Denver/Westwood/r_268778/</url><latitude>39.704001</latitude><longitude>-105.039143</longitude></region>
 <region><id>268628</id><name>Capitol Hill</name><zindex currency="USD">160800</zindex><url>http://www.zillow.com/local-info/CO-Denver/Capitol-Hill/r_268628/</url><latitude>39.733677</latitude><longitude>-104.98021</longitude></region>
 <region><id>268672</id><name>Hampden South</name><zindex currency="USD">270000</zindex><url>http://www.zillow.com/local-info/CO-Denver/Hampden-South/r_268672/</url><latitude>39.638589</latitude><longitude>-104.896905</longitude></region>
 <region><id>268774</id><name>Washington Virginia Vale</name><zindex currency="USD">229500</zindex><url>http://www.zillow.com/local-info/CO-Denver/Washington-Virginia-Vale/r_268774/</url><latitude>39.69824</latitude><longitude>-104.916975</longitude></region>
 <region><id>268771</id><name>Virginia Village</name><zindex currency="USD">261800</zindex><url>http://www.zillow.com/local-info/CO-Denver/Virginia-Village/r_268771/</url><latitude>39.688427</latitude><longitude>-104.922004</longitude></region>
 <region><id>268662</id><name>Five Points</name><zindex currency="USD">281600</zindex><url>http://www.zillow.com/local-info/CO-Denver/Five-Points/r_268662/</url><latitude>39.759365</latitude><longitude>-104.987445</longitude></region>
 <region><id>268689</id><name>Mar Lee</name><zindex currency="USD">145000</zindex><url>http://www.zillow.com/local-info/CO-Denver/Mar-Lee/r_268689/</url><latitude>39.689711</latitude><longitude>-105.039127</longitude></region>
 <region><id>403516</id><name>Windsor</name><zindex currency="USD">86300</zindex><url>http://www.zillow.com/local-info/CO-Denver/Windsor/r_403516/</url><latitude>39.703072</latitude><longitude>-104.884741</longitude></region>
 <region><id>268673</id><name>Harvey Park</name><zindex currency="USD">175400</zindex><url>http://www.zillow.com/local-info/CO-Denver/Harvey-Park/r_268673/</url><latitude>39.674989</latitude><longitude>-105.044093</longitude></region>
 <region><id>268690</id><name>Marston</name><zindex currency="USD">195400</zindex><url>http://www.zillow.com/local-info/CO-Denver/Marston/r_268690/</url><latitude>39.626684</latitude><longitude>-105.081625</longitude></region>
 <region><id>268743</id><name>Speer</name><zindex currency="USD">300200</zindex><url>http://www.zillow.com/local-info/CO-Denver/Speer/r_268743/</url><latitude>39.7192</latitude><longitude>-104.980255</longitude></region>
 <region><id>268657</id><name>East Colfax</name><zindex currency="USD">162100</zindex><url>http://www.zillow.com/local-info/CO-Denver/East-Colfax/r_268657/</url><latitude>39.744395</latitude><longitude>-104.894159</longitude></region>
 <region><id>268643</id><name>Congress Park</name><zindex currency="USD">411000</zindex><url>http://www.zillow.com/local-info/CO-Denver/Congress-Park/r_268643/</url><latitude>39.73288</latitude><longitude>-104.95036</longitude></region>
 <region><id>403510</id><name>Ruby Hill</name><zindex currency="USD">145300</zindex><url>http://www.zillow.com/local-info/CO-Denver/Ruby-Hill/r_403510/</url><latitude>39.689467</latitude><longitude>-105.00881</longitude></region>
 <region><id>268776</id><name>West Colfax</name><zindex currency="USD">216000</zindex><url>http://www.zillow.com/local-info/CO-Denver/West-Colfax/r_268776/</url><latitude>39.740363</latitude><longitude>-105.039146</longitude></region>
 <region><id>403514</id><name>Sunnyside</name><zindex currency="USD">279300</zindex><url>http://www.zillow.com/local-info/CO-Denver/Sunnyside/r_403514/</url><latitude>39.776836</latitude><longitude>-105.011668</longitude></region>
 <region><id>268760</id><name>University</name><zindex currency="USD">303700</zindex><url>http://www.zillow.com/local-info/CO-Denver/University/r_268760/</url><latitude>39.675146</latitude><longitude>-104.96643</longitude></region>
 <region><id>268703</id><name>North Park Hill</name><zindex currency="USD">288600</zindex><url>http://www.zillow.com/local-info/CO-Denver/North-Park-Hill/r_268703/</url><latitude>39.756432</latitude><longitude>-104.9221</longitude></region>
 <region><id>268612</id><name>Athmar Park</name><zindex currency="USD">143400</zindex><url>http://www.zillow.com/local-info/CO-Denver/Athmar-Park/r_268612/</url><latitude>39.703949</latitude><longitude>-105.00872</longitude></region>
 <region><id>268768</id><name>Villa Park</name><zindex currency="USD">134200</zindex><url>http://www.zillow.com/local-info/CO-Denver/Villa-Park/r_268768/</url><latitude>39.73106</latitude><longitude>-105.040337</longitude></region>
 <region><id>268617</id><name>Bear Valley</name><zindex currency="USD">228100</zindex><url>http://www.zillow.com/local-info/CO-Denver/Bear-Valley/r_268617/</url><latitude>39.660127</latitude><longitude>-105.067301</longitude></region>
 <region><id>268777</id><name>West Highland</name><zindex currency="USD">352900</zindex><url>http://www.zillow.com/local-info/CO-Denver/West-Highland/r_268777/</url><latitude>39.764137</latitude><longitude>-105.039184</longitude></region>
 <region><id>273986</id><name>Highland</name><zindex currency="USD">313300</zindex><url>http://www.zillow.com/local-info/CO-Denver/Highland/r_273986/</url><latitude>39.761671</latitude><longitude>-105.011709</longitude></region>
 <region><id>268740</id><name>South Park Hill</name><zindex currency="USD">424200</zindex><url>http://www.zillow.com/local-info/CO-Denver/South-Park-Hill/r_268740/</url><latitude>39.745588</latitude><longitude>-104.9221</longitude></region>
 <region><id>52070</id><name>Fort Logan</name><zindex currency="USD">223200</zindex><url>http://www.zillow.com/local-info/CO-Denver/Fort-Logan/r_52070/</url><latitude>39.640603</latitude><longitude>-105.051058</longitude></region>
 <region><id>268674</id><name>Harvey Park South</name><zindex currency="USD">210100</zindex><url>http://www.zillow.com/local-info/CO-Denver/Harvey-Park-South/r_268674/</url><latitude>39.660491</latitude><longitude>-105.039166</longitude></region>
 <region><id>119762</id><name>Hilltop</name><zindex currency="USD">642900</zindex><url>http://www.zillow.com/local-info/CO-Denver/Hilltop/r_119762/</url><latitude>39.718354</latitude><longitude>-104.922064</longitude></region>
 <region><id>403513</id><name>Berkeley</name><zindex currency="USD">309100</zindex><url>http://www.zillow.com/local-info/CO-Denver/Berkeley/r_403513/</url><latitude>39.777145</latitude><longitude>-105.039201</longitude></region>
 <region><id>268688</id><name>Lowry Field</name><zindex currency="USD">426300</zindex><url>http://www.zillow.com/local-info/CO-Denver/Lowry-Field/r_268688/</url><latitude>39.71989</latitude><longitude>-104.89177</longitude></region>
 <region><id>403517</id><name>Cheesman Park</name><zindex currency="USD">208000</zindex><url>http://www.zillow.com/local-info/CO-Denver/Cheesman-Park/r_403517/</url><latitude>39.734552</latitude><longitude>-104.966404</longitude></region>
 <region><id>268704</id><name>Northeast Park Hill</name><zindex currency="USD">175300</zindex><url>http://www.zillow.com/local-info/CO-Denver/Northeast-Park-Hill/r_268704/</url><latitude>39.776569</latitude><longitude>-104.922197</longitude></region>
 <region><id>268762</id><name>University Park</name><zindex currency="USD">432500</zindex><url>http://www.zillow.com/local-info/CO-Denver/University-Park/r_268762/</url><latitude>39.675842</latitude><longitude>-104.950018</longitude></region>
 <region><id>403512</id><name>Sloan Lake</name><zindex currency="USD">343400</zindex><url>http://www.zillow.com/local-info/CO-Denver/Sloan-Lake/r_403512/</url><latitude>39.751224</latitude><longitude>-105.039223</longitude></region>
 <region><id>268772</id><name>Washington Park</name><zindex currency="USD">534300</zindex><url>http://www.zillow.com/local-info/CO-Denver/Washington-Park/r_268772/</url><latitude>39.701697</latitude><longitude>-104.966358</longitude></region>
 <region><id>45614</id><name>Hale</name><zindex currency="USD">295100</zindex><url>http://www.zillow.com/local-info/CO-Denver/Hale/r_45614/</url><latitude>39.732844</latitude><longitude>-104.931504</longitude></region>
 <region><id>403509</id><name>College View / South Platte</name><zindex currency="USD">140800</zindex><url>http://www.zillow.com/local-info/CO-Denver/College-View-_-South-Platte/r_403509/</url><latitude>39.66958</latitude><longitude>-105.011328</longitude></region>
 <region><id>268659</id><name>Elyria Swansea</name><zindex currency="USD">103800</zindex><url>http://www.zillow.com/local-info/CO-Denver/Elyria-Swansea/r_268659/</url><latitude>39.782563</latitude><longitude>-104.95939</longitude></region>
 <region><id>268773</id><name>Washington Park West</name><zindex currency="USD">418800</zindex><url>http://www.zillow.com/local-info/CO-Denver/Washington-Park-West/r_268773/</url><latitude>39.700541</latitude><longitude>-104.980609</longitude></region>
 <region><id>403153</id><name>Lincoln Park</name><zindex currency="USD">193600</zindex><url>http://www.zillow.com/local-info/CO-Denver/Lincoln-Park/r_403153/</url><latitude>39.732961</latitude><longitude>-105.002669</longitude></region>
 <region><id>268614</id><name>Barnum</name><zindex currency="USD">133800</zindex><url>http://www.zillow.com/local-info/CO-Denver/Barnum/r_268614/</url><latitude>39.718414</latitude><longitude>-105.032325</longitude></region>
 <region><id>268702</id><name>North Capitol Hill</name><zindex currency="USD">270900</zindex><url>http://www.zillow.com/local-info/CO-Denver/North-Capitol-Hill/r_268702/</url><latitude>39.743876</latitude><longitude>-104.980444</longitude></region>
 <region><id>268666</id><name>Goldsmith</name><zindex currency="USD">262200</zindex><url>http://www.zillow.com/local-info/CO-Denver/Goldsmith/r_268666/</url><latitude>39.672983</latitude><longitude>-104.918735</longitude></region>
 <region><id>268761</id><name>University Hills</name><zindex currency="USD">229700</zindex><url>http://www.zillow.com/local-info/CO-Denver/University-Hills/r_268761/</url><latitude>39.667975</latitude><longitude>-104.929607</longitude></region>
 <region><id>268635</id><name>Cherry Creek</name><zindex currency="USD">569300</zindex><url>http://www.zillow.com/local-info/CO-Denver/Cherry-Creek/r_268635/</url><latitude>39.718518</latitude><longitude>-104.95042</longitude></region>
 <region><id>12803</id><name>Montclair</name><zindex currency="USD">309900</zindex><url>http://www.zillow.com/local-info/CO-Denver/Montclair/r_12803/</url><latitude>39.732865</latitude><longitude>-104.9131</longitude></region>
 <region><id>268720</id><name>Platt Park</name><zindex currency="USD">358500</zindex><url>http://www.zillow.com/local-info/CO-Denver/Platt-Park/r_268720/</url><latitude>39.68779</latitude><longitude>-104.98053</longitude></region>
 <region><id>268615</id><name>Barnum West</name><zindex currency="USD">139600</zindex><url>http://www.zillow.com/local-info/CO-Denver/Barnum-West/r_268615/</url><latitude>39.719292</latitude><longitude>-105.04633</longitude></region>
 <region><id>268637</id><name>City Park West</name><zindex currency="USD">305700</zindex><url>http://www.zillow.com/local-info/CO-Denver/City-Park-West/r_268637/</url><latitude>39.74539</latitude><longitude>-104.966585</longitude></region>
 <region><id>268779</id><name>Whittier</name><zindex currency="USD">292000</zindex><url>http://www.zillow.com/local-info/CO-Denver/Whittier/r_268779/</url><latitude>39.756359</latitude><longitude>-104.966544</longitude></region>
 <region><id>268613</id><name>Baker</name><zindex currency="USD">281800</zindex><url>http://www.zillow.com/local-info/CO-Denver/Baker/r_268613/</url><latitude>39.711398</latitude><longitude>-105.001609</longitude></region>
 <region><id>403518</id><name>Cole</name><zindex currency="USD">206800</zindex><url>http://www.zillow.com/local-info/CO-Denver/Cole/r_403518/</url><latitude>39.767451</latitude><longitude>-104.96637</longitude></region>
 <region><id>268684</id><name>Kennedy</name><url>http://www.zillow.com/local-info/CO-Denver/Kennedy/r_268684/</url><latitude>39.652721</latitude><longitude>-104.861489</longitude></region>
 <region><id>403152</id><name>Clayton</name><zindex currency="USD">191200</zindex><url>http://www.zillow.com/local-info/CO-Denver/Clayton/r_403152/</url><latitude>39.767315</latitude><longitude>-104.950165</longitude></region>
 <region><id>268759</id><name>Union Station</name><zindex currency="USD">404700</zindex><url>http://www.zillow.com/local-info/CO-Denver/Union-Station/r_268759/</url><latitude>39.752929</latitude><longitude>-104.999888</longitude></region>
 <region><id>268618</id><name>Belcaro</name><zindex currency="USD">634200</zindex><url>http://www.zillow.com/local-info/CO-Denver/Belcaro/r_268618/</url><latitude>39.706191</latitude><longitude>-104.948985</longitude></region>
 <region><id>268644</id><name>Cory - Merrill</name><zindex currency="USD">376200</zindex><url>http://www.zillow.com/local-info/CO-Denver/Cory----Merrill/r_268644/</url><latitude>39.689763</latitude><longitude>-104.95001</longitude></region>
 <region><id>268731</id><name>Regis</name><zindex currency="USD">237100</zindex><url>http://www.zillow.com/local-info/CO-Denver/Regis/r_268731/</url><latitude>39.787617</latitude><longitude>-105.045192</longitude></region>
 <region><id>403511</id><name>Valverde</name><zindex currency="USD">125400</zindex><url>http://www.zillow.com/local-info/CO-Denver/Valverde/r_403511/</url><latitude>39.718395</latitude><longitude>-105.012723</longitude></region>
 <region><id>268742</id><name>Southmoor Park</name><zindex currency="USD">339000</zindex><url>http://www.zillow.com/local-info/CO-Denver/Southmoor-Park/r_268742/</url><latitude>39.638481</latitude><longitude>-104.916933</longitude></region>
 <region><id>268633</id><name>Chaffee Park</name><zindex currency="USD">172800</zindex><url>http://www.zillow.com/local-info/CO-Denver/Chaffee-Park/r_268633/</url><latitude>39.788305</latitude><longitude>-105.011634</longitude></region>
 <region><id>275564</id><name>Stapleton</name><zindex currency="USD">409300</zindex><url>http://www.zillow.com/local-info/CO-Denver/Stapleton/r_275564/</url><latitude>39.759514</latitude><longitude>-104.883448</longitude></region>
 <region><id>268664</id><name>Globeville</name><zindex currency="USD">108100</zindex><url>http://www.zillow.com/local-info/CO-Denver/Globeville/r_268664/</url><latitude>39.780305</latitude><longitude>-104.982597</longitude></region>
 <region><id>268632</id><name>Central Business District</name><zindex currency="USD">249500</zindex><url>http://www.zillow.com/local-info/CO-Denver/Central-Business-District/r_268632/</url><latitude>39.74618</latitude><longitude>-104.99393</longitude></region>
 <region><id>42385</id><name>Indian Creek</name><zindex currency="USD">150200</zindex><url>http://www.zillow.com/local-info/CO-Denver/Indian-Creek/r_42385/</url><latitude>39.68565</latitude><longitude>-104.896235</longitude></region>
 <region><id>268775</id><name>Wellshire</name><zindex currency="USD">539900</zindex><url>http://www.zillow.com/local-info/CO-Denver/Wellshire/r_268775/</url><latitude>39.660281</latitude><longitude>-104.949975</longitude></region>
 <region><id>40932</id><name>Skyland</name><zindex currency="USD">246400</zindex><url>http://www.zillow.com/local-info/CO-Denver/Skyland/r_40932/</url><latitude>39.756472</latitude><longitude>-104.950154</longitude></region>
 <region><id>268636</id><name>City Park</name><zindex currency="USD">369100</zindex><url>http://www.zillow.com/local-info/CO-Denver/City-Park/r_268636/</url><latitude>39.745636</latitude><longitude>-104.95018</longitude></region>
 <region><id>268646</id><name>Country Club</name><zindex currency="USD">766400</zindex><url>http://www.zillow.com/local-info/CO-Denver/Country-Club/r_268646/</url><latitude>39.721718</latitude><longitude>-104.966283</longitude></region>
 <region><id>403515</id><name>Rosedale</name><zindex currency="USD">307100</zindex><url>http://www.zillow.com/local-info/CO-Denver/Rosedale/r_403515/</url><latitude>39.673121</latitude><longitude>-104.980526</longitude></region>
 <region><id>268683</id><name>Jefferson Park</name><zindex currency="USD">305700</zindex><url>http://www.zillow.com/local-info/CO-Denver/Jefferson-Park/r_268683/</url><latitude>39.751082</latitude><longitude>-105.017473</longitude></region>
 <region><id>268712</id><name>Overland</name><zindex currency="USD">178400</zindex><url>http://www.zillow.com/local-info/CO-Denver/Overland/r_268712/</url><latitude>39.681787</latitude><longitude>-104.995682</longitude></region>
 <region><id>268638</id><name>Civic Center</name><zindex currency="USD">352900</zindex><url>http://www.zillow.com/local-info/CO-Denver/Civic-Center/r_268638/</url><latitude>39.73372</latitude><longitude>-104.992878</longitude></region>
 <region><id>268751</id><name>Sun Valley</name><url>http://www.zillow.com/local-info/CO-Denver/Sun-Valley/r_268751/</url><latitude>39.736495</latitude><longitude>-105.020525</longitude></region>
 <region><id>268652</id><name>DIA</name><zindex currency="USD">102200</zindex><url>http://www.zillow.com/local-info/CO-Denver/DIA/r_268652/</url><latitude>39.856287</latitude><longitude>-104.695671</longitude></region>
 <region><id>276193</id><name>Auraria</name><url>http://www.zillow.com/local-info/CO-Denver/Auraria/r_276193/</url><latitude>39.747435</latitude><longitude>-105.007642</longitude></region></list>
</response>
</RegionChildren:regionchildren>
<!-- H:003  T:204ms  S:10035  R:Sat Feb 16 14:57:36 PST 2013  B:3.0.183456.20130214122025087-comp_rel_b.183456.20130214122210808-comp_rel_b -->

Karsten Wolf Contributor

Karsten Wolf

Posted
Posted

The stylesheet you posted is incomplete.

 

It would be easier to look at if you just zip a folder with stylesheet and xml demo file instead of copy and paste.

This topic is 4429 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.

  I accept