CCBtx Posted February 16, 2013 Share Posted February 16, 2013 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 --> Link to comment Share on other sites More sharing options...
Karsten Wolf Posted February 17, 2013 Share Posted February 17, 2013 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. Link to comment Share on other sites More sharing options...
Karsten Wolf Posted February 17, 2013 Share Posted February 17, 2013 You'll have to do the import with your data since the copy/pasted demo data has mutilated URLs. fmf_zillow.zip Link to comment Share on other sites More sharing options...
CCBtx Posted February 17, 2013 Author Share Posted February 17, 2013 Thanks so much. That works perfectly. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4092 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 accountSign in
Already have an account? Sign in here.
Sign In Now