Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Help with XML Example

CCBtx
in XML/XSL

Featured Replies

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 -->

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.

You'll have to do the import with your data since the copy/pasted demo data has mutilated URLs.

fmf_zillow.zip

  • Author

Thanks so much.  That works perfectly.

Create an account or sign in to comment

https://fmforums.com/topic/87648-help-with-xml-example/
Go to topic listing

Important Information

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

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.