Export for Google Base

[thinkbible]

I'm currently outputing a tab delimited file for Google Base uploads. I'd like to convert to another format. Google accepts RSS and Atom feeds. Is it possible to output from FM in this format? XML format doesn't look right.

Thanks in advance for helping me learn and migrate from tab/comma output to XML/RSS.

[Fenton]

XML Export usually requires an XSL stylesheet to transform the raw FileMaker XML export to the final desired result.

This is an xsl stylesheet that transforms FMPXMLRESULT (one of 2 choices for result type, drop-down in the xml dialog) grammar to RSS.

If that indeed is what you want. I don't know Google Base, so couldn't really say. Also, in the xsl stylesheet you will see that it picks out the fields by their export order.

That , which only happens once per RSS export, is set up by this line:

Which means, just get stuff from the 1st FileMaker record exported.

The is picked out by these lines:

The multiple records, one after another, are then obtained by this line:

The is then gotten (for each row).

Which is the 5th field exported.

The has an added attribute:

disable-output-escaping="yes"

allows you to have special characters, such as "&", etc. in the field, which would otherwise get transformed by the xml processor to their numeric equivalent. You may need that for

also.

RSS_export.xsl.zip

[thinkbible]

That is exactly what I need! (and what I thought- I tried finding info on the stylesheet issue but failed.)

You have saved me a lot of time.

Thank You!