Newbies agabrean Posted April 13, 2012 Newbies Share Posted April 13, 2012 Hi, I have a calculated field that contains the xml code I need to export. The problem is that when I export it the "<" and ">" tags are transformed into "<" and ">" How can I get the xml code from my field into the final xml file ? I must also say that I use an XSL template to modify my code to the desired format. Here is the code in my calculated field as I see it in my FileMaker: <dealer_id>4527</dealer_id> <ownersvehicle_id>O17068</ownersvehicle_id> <type>car</type> <category>used</category> <body>5_doors</body> <brand>Renault</brand> <model>Espace IV</model> <version>PRIVILEGE</version> <body_colorgroup>Gris Eclipse</body_colorgroup> <doors>5 accents èàé</doors> <gear_type>automatic</gear_type> <gears></gears> <fuel_type>Diesel</fuel_type> <mileage>142000</mileage> <initial_registration>2007-02-06</initial_registration> <licence_number>XUW499</licence_number> <notes>UNIQUEMENT SUR RENDEZ-VOUS ENKEL OP AFSPRAAK </notes> and here is my xsl template : <?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fmp="http://www.filemaker.com/fmpxmlresult" exclude-result-prefixes="fmp"> <xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/> <xsl:template match="/"> <stx3 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <vehicle_data> <vehicles> <xsl:for-each select="fmp:FMPXMLRESULT/fmp:RESULTSET/fmp:ROW"> <vehicle> <xsl:value-of select="fmp:COL[1]/fmp:DATA"/> </vehicle> </xsl:for-each> </vehicles> </vehicle_data> </stx3> </xsl:template> </xsl:stylesheet> Thank you for your help, Adrian. Link to comment Share on other sites More sharing options...
webko Posted April 17, 2012 Share Posted April 17, 2012 You're mixing two ways of creating an XML file here. You can either setup the entire vehicle record like above, the export them all as .txt or .tab and add the top and tail manually, or set up an XML export with all of the fields individually and then run a more complicated stylesheet to transform to the final fie. An XML export will encode any special characters on the way through, including your < and > - which is what is causing the issue, as it sees all of the calculation as needing this encoding Link to comment Share on other sites More sharing options...
Newbies agabrean Posted April 18, 2012 Author Newbies Share Posted April 18, 2012 Hi Webko, Thank you for your answer. I have made a script that exports the data in tab format and then it ads the head and footer at the end and it's working fine. Adrian. Link to comment Share on other sites More sharing options...
beverly Posted April 22, 2012 Share Posted April 22, 2012 Webko is right, just create the entire calculated XML (no XSLT needed). There are also a few things to know about XML/XSLT that might help: disable-output-escaping <http://www.dpawson.co.uk/xsl/sect2/N2215.html> & xs:copy-of <http://dev.ektron.com/blogs.aspx?id=10472> I don't know this these would work for you. It sounds like what you have is not very complex. Calculated xml and then export works well, too. I use it often. Beverly Link to comment Share on other sites More sharing options...
Newbies agabrean Posted April 23, 2012 Author Newbies Share Posted April 23, 2012 Hi Beverly, Thank you for your answer. My XML is not very complex and the calculated field does the job very well, so for the moment I am happy with it. Kind regards, Adrian. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4387 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