XSL import newbie lost

[Dono K]

Hello - Okay, I am lost. I have rummaged through some examples here, but I can't seem to get my XML database to import records into FM9. I got one example to get me though without errors, but no records import. Here is a truncated version of my xml file:

<?xml version="1.0" encoding="ISO-8859-1"?>

2/26/2008

My [email protected]

"xml.asp?uid=0000&order=appliedto&direction=up"

asc

desc

creditcard

issuer

1144

Card Name

bank

and the xsl file:

<?xml version="1.0" encoding="utf-8"?>

0

Thanks in advance - Don

[Fenton]

Close, but no cigar :-] XSL is generally custom-built for the XML it is transforming. The (or a template-match) must match what you want for a FileMaker row. Yours is still matching what it did from the other solution you copied it from, so it's not going to match anything in your xml. It should be:

Also, "@" syntax is for matching "attributes," not "elements". The data you're targeting is in elements, so you don't need the "@". Example:

Also, I moved the cid to the top of the fields, in the METADATA and RESULTSET sections, just because that's where it is in the xml. It doesn't really matter (I'm neurotic I suppose -), but adjust your FileMaker Import order to match the fields.

creditcard.xsl.zip

[Dono K]

This is really fantastic - thank you - I was able to get the whole thing in to FileMaker and make my changes. Now, I want to export that back out to xml so that I can use it in a site I have using Dreamweaver.

If I use FMPDSOEXPORT with no style sheet - I can read it in DW, but I understand that FMPXMLEXPORT is preferred? But, when I use this, DW sees the XML page as empty - the DATA node set (is that the right term?) is blank. Do I need a style sheet to go back to XML?

Bah! Sorry for being so completely clueless. I have hunted around again to teach myself this, but my eyes glaze over. Any help would be GREALY appreciated.

-- Don

[Fenton]

Yeah, you need a whole different xsl stylesheet to take the FileMaker export syntax, and turn it back into what you started with. I also used dso export in this xsl. I took out the indent="yes", because it added whitespace to the result. But perhaps that doesn't matter. I generally indent xml, just 'cause it's easier to read and troubleshoot, but it doesn't matter to the processor at the other end.

[P.S. I don't know if you need all the stuff at the top, nor where it would come from if you did. So I just whacked it in there, not using any fancy creation tags. Primitive perhaps, but it seems to work.]

CC_out_dso.xsl.zip

Edited March 4, 2008 by Guest

[Dono K]

Amazing - worked perfectly!

Thanks again,

Don