I have several scripts that export XML in conjunction with an XSL style sheet to generate HTML. I would like at the top of each HTML file to have something like "(generated from the database on yyyy/mm/dd)" so that a viewer can easily tell how old the HTML data is that they're viewing (these are internal viewers only). The date of export is not in the XML that is exported (a surprise, that - seems quite a basic piece of info); for those of you familiar with XSL it will come as no surprise that XSL provides no built-in way to get current date; I have tried the xml-script element (to run javascript date functions) as well as the EXSLT date extension but apparently FMPro's built-in XML parser (Xalan) doesn't support either of these; I have tried creating a variable with today's date but (a) unless it's displayed on the layout I can't get it into the XML export and (: once it's displayed on the layout it doesn't automatically update to the current date every day. Any ideas? I know there has to be an easy way to do this...

I think you need to define an unstored calculation field = Get (CurrentDate), and add it to the exported fields.

You can export a field whether it's displayed on a layout or not.

It might be different with the server version (I believe it supports some extended functions).

I haven't been able to find a way to export the field unless it's displayed; if you can tell me how to do this I'd be grateful. When I do the XML export (or any export), I have a list of fields down the left to choose from. The date variable I created is not listed. When I add it to the layout, it is listed.

Edited December 3, 200718 yr by Guest

Like this?

Edited December 3, 200718 yr by Guest
Reattached file

Sorry, I can't view this graphic (gives me a 404 error). Can you send it to me directly at [email protected] ?

Just read paragraph 9 here:

http://www.filemaker.com/help/12-Import%20export18.html