tomp Posted January 26, 2005 Share Posted January 26, 2005 I'm using an XML source to create an FM file for the first time and followed with interest the discussion started by Jerry Parlee last week. I was able to use the 'patches' download provided by Fenton (thank you - more useful than any FM documentation I found) to create a style sheet that creates an FM file when doing an open/xml source. BUT - The style sheet creates the correct number of records and the right fields in the FM file, but it does not fill the fields with the data in the xml file. I've tried various ways to get to the data (as you'll see in the .xsl file) but none work. I've run out of ideas. I've enclosed a snippet of the xml file below and attached the xsl file (xsl file has a .txt extension so I can 'attach' it. Could anyone help me get the data into the fields? TIA xml file: 2 records; 1 'result' and 1 'reservation' <?xml version="1.0" encoding="iso-8859-1" ?> <reservations> <result> <status>success</status> <code>0</code> <message><![CDATA[reservation download succeeded]]></message> </result> <reservation id="488"> <guest> <firstName><![CDATA[Charles]]></firstName> <lastName><![CDATA[bailey]]></lastName> <address><![CDATA[123 Main Street]]></address> <address2></address2> <city><![CDATA[Woodbury]]></city> <state><![CDATA[MN]]></state> <zip><![CDATA]></zip> <country><![CDATA[uSA]]></country> <email><![CDATA[[email protected]]]></email> <dayPhone><![CDATA[651-555-1234]]></dayPhone> <eveningPhone></eveningPhone> </guest> <resDetails> <confirmationNumber>20021</confirmationNumber> <unitName></unitName> <typeName><![CDATA[double]]></typeName> <numberOfUnits>1</numberOfUnits> <dateReserved>20041228165256</dateReserved> <arrivalDate>2005-03-10</arrivalDate> <arrivalTime></arrivalTime> <departureTime></departureTime> <daysReserved>3</daysReserved> <adults>2</adults> <children>2</children> <priceDetail></priceDetail> <subTotal>330.00</subTotal> <price>367.95</price> <comments></comments> </resDetails> <payment> <creditCardName><![CDATA[Charles Bailey]]></creditCardName> <creditCardType>Visa</creditCardType> <creditCardNumber>4444222211113333</creditCardNumber> <creditCardExpiration>04/2007</creditCardExpiration> <creditCardSecurityCode>789</creditCardSecurityCode> </payment> <misc> <guestQuestion1></guestQuestion1> <guestQuestion2></guestQuestion2> </misc> </reservation> </reservations> DownloadExport.txt Link to comment Share on other sites More sharing options...
This topic is 6636 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
Already have an account? Sign in here.Sign In Now