[alcimedes]

Can anyone help me out here? I'm ready to pull my hair out with this one. I've posted this at the FMP forums as well, but I know we have some smart cookies here. (the below data is publicly available, elected official etc.)

http://fmforums.com/forum/topic/8574...efiles-inside/

Long story short, the XML looks like this:

This XML file does not appear to have any style information associated with it. The document tree is shown below.<bio><generalInfo>...</generalInfo><candidate><candidateId>16646</candidateId><crpId/><photo>http://static.votesmart.org/canphoto/16646.jpg</photo><firstName>Wesley</firstName><nickName>Wes</nickName><middleName/><preferredName>Wesley</preferredName><lastName>Chesbro</lastName><suffix/><birthDate>08/20/1951</birthDate><birthPlace>Glendale, CA</birthPlace><pronunciation/><gender>Male</gender><family><![CDATA[ Wife: Cindy; 2 Children: Alen, Collin ]]></family><homeCity>Arcata</homeCity><homeState>CA</homeState><education><![CDATA[BA, Organizational Behavior, University of San FranciscoAttended, Natural Resources, California State University, Humboldt]]></education><profession><![CDATA[Director, Arcata Community Recycling Center, 1971-1972]]></profession><political><![CDATA[Assembly Member, California State Assembly, District 1, 2008-presentSenator, California State Senate, 1998-2006Supervisor, Humboldt County, 1980-1990Member, Arcata City Council, 1974-1980]]></political><religion>United Methodist</religion><congMembership><![CDATA[Member, Pacific Fisheries Legislative Task Force, presentMember, Western Legislative Forestry Task Force, presentMember, Local Agency Formation Commission, 1982-1990Member, California Senate Solid Waste Task Force, 1988-1989Member, Solar Cal, Local Government Commission, 1981-1982Member, Board of Directors, Humboldt Bay Housing CorporationMember, Board of Directors, Mental Health Services Oversight and Accountability Commission]]></congMembership><orgMembership><![CDATA[Vice Chair, Western States Recycling Coalition, 1995-1997Member, California Integrated Waste Management Board, 1990-1998, 2007-2008Founding Member, California Integrated Waste Management Board, 1990-1998Member, Board of Directors, County Supervisors Association of California, 1988-1990Member, Humboldt County Child Welfare Advisory Board, 1986-1990Member, Board of Directors, Redwood Natural History Association, 1986-1990Member, Humboldt Health Planning Council, 1985-1990Member, Juvenile Justice & Delinquency Prevention, Humboldt County, 1983-1990Member, Humboldt Transit Authority Board, 1982-1990Member, Redwood Empire Division, League of California Cities, 1978Member, North Coast Environmental Center, 1971-1974Member, Multiple Sclerosis SocietyMember, Board of Directors, Open Door Health SystemsMember, United Methodist Church]]></orgMembership><specialMsg><![CDATA[ ]]></specialMsg></candidate><office><name>State Assembly</name><parties>Democratic</parties><title>Assembly Member</title><shortTitle>AM</shortTitle><name>State Assembly</name><type>State Legislative</type><status>active</status><firstElect>11/04/2008</firstElect><lastElect>11/02/2010</lastElect><nextElect/><termStart>12/01/2008</termStart><termEnd/><district>1</district><districtId>21271</districtId><stateId>CA</stateId><committee><committeeId>9886</committeeId><committeeName>Budget</committeeName></committee><committee><committeeId>9890</committeeId><committeeName>Environmental Safety and Toxic Materials</committeeName></committee><committee><committeeId>13129</committeeId><committeeName>Fisheries and Aquaculture</committeeName></committee><committee><committeeId>9891</committeeId><committeeName>Governmental Organization</committeeName></committee><committee><committeeId>416</committeeId><committeeName>Natural Resources</committeeName></committee><committee><committeeId>12363</committeeId><committeeName>Wine</committeeName></committee></office><election><office>State Assembly</office><officeType>State Legislative</officeType><parties>Democratic</parties><district>2</district><districtId>21272</districtId><stateId>CA</stateId><status>Running</status><ballotName>Wesley Chesbro</ballotName></election></bio>

And my XSL file looks like this:

<?xml version="1.0" encoding="UTF-8" ?><FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"><ERRORCODE>0</ERRORCODE><PRODUCT BUILD="06-18-2009" NAME="FileMaker" VERSION="Pro 10.0v3"/><DATABASE DATEFORMAT="M/d/yyyy" LAYOUT="" NAME="State_Legislators_NEW.fp7" RECORDS="7" TIMEFORMAT="h:mm:ss a"/><METADATA><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="candidateId" TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="firstName" TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="nickName" TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="middleName" TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="preferredName" TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="lastName" TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="suffix" TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="birthDate" TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="birthPlace" TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="pronunciation" TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="gender" TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="family" TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="photo" TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="homeCity" TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="homeState" TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="education" TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="profession" TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="political" TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="religion" TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="congMembership" TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="orgMembership" TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="specialMsg" TYPE="TEXT"/></METADATA><RESULTSET FOUND=""><xsl:for-each select="bio/candidate"><ROW MODID="" RECORDID=""><COL><DATA><xsl:value-of select="column[@name='candidateId']"</DATA></COL><COL><DATA><xsl:value-of select="firstName"</DATA></COL><COL><DATA><xsl:value-of select="nickName"</DATA></COL><COL><DATA><xsl:value-of select="middleName"</DATA></COL><COL><DATA><xsl:value-of select="preferredName"</DATA></COL><COL><DATA><xsl:value-of select="lastName"</DATA></COL><COL><DATA><xsl:value-of select="suffix"</DATA></COL><COL><DATA><xsl:value-of select="birthDate"</DATA></COL><COL><DATA><xsl:value-of select="birthPlace"</DATA></COL><COL><DATA><xsl:value-of select="pronunciation"</DATA></COL><COL><DATA><xsl:value-of select="gender"</DATA></COL><COL><DATA><xsl:value-of select="family"</DATA></COL><COL><DATA><xsl:value-of select="photo"</DATA></COL><COL><DATA><xsl:value-of select="homeCity"</DATA></COL><COL><DATA><xsl:value-of select="homeState"</DATA></COL><COL><DATA><xsl:value-of select="education"</DATA></COL><COL><DATA><xsl:value-of select="profession"</DATA></COL><COL><DATA><xsl:value-of select="political"</DATA></COL><COL><DATA><xsl:value-of select="religion"</DATA></COL><COL><DATA><xsl:value-of select="congMembership"</DATA></COL><COL><DATA><xsl:value-of select="orgMembership"</DATA></COL><COL><DATA><xsl:value-of select="specialMsg"</DATA></COL></ROW></xsl:for-each></RESULTSET></FMPXMLRESULT>

There are three tables here, and if I can just get the first one to import, I'm sure I can work out the rest, but I'm now lost. Tried every variation I could think of based on the examples I found, but none of them work.