Scripts

[brad2610]

Someone correct me / enlighten me if this is wrong.....

Can I create a script in my filemaker databse that can be executed by the user on the xsl / xml page?

For example... I want to write a script that will email a client their full inventory that is in my warehouse. Can they click a link on the web page that will do this? If so what is the code to run a script?

Once again I thank alll of the XML /XSL / Filemaker gurus who are nice enough to help us newbies out.

[Martin Brändle]

&-script=myscript

BUT: The Send Mail script step is not web compatible, neither in CWP nor in IWP.

You have to stick to fmsxlt:send_email

Martin

[brad2610]

Martin.... what if the script says to save the file out to a specific location where the user can then go download the file. Does this sound reasonable?

[Martin Brändle]

Yep, would be a good idea. The idea of producing a pdf or another format (e.g. an Excel spreadsheet) came also to my mind.

I see your your problem of long searches now. Of course, if you need the whole DB content, the XSL transformation may take a long time.

Martin

[brad2610]

Hi Martin,

I have created the script to export the excel file but am not having luckj invoking the script from my xsl page. I am hoping you could be of some assistance with the syntax. here is what I ahve done:

This is in the utilities.xsl file I have:

<!--Link to the script-->

	<xsl:template name="link-excel">

	<xsl:variable name="link">http://192.168.55.152/fmi/xml/fmresultset.xml?db=MCINVENTORY-lay=PRINT+INVENTORY-script=EXCELOUTPUT-findall

			

		</xsl:variable>

		<xsl:value-of select="fmxslt:session_encode_url($link)"/>

	</xsl:template>

I am then calling this link on the webpage by:

<xsl:attribute name="href">

<xsl:call-template name="link-excel"/>

</xsl:attribute>

<font size="2"> EXCEL </font>

</a>

[Martin Brändle]

Probably you forgot the ampersands & in the URL (but this might be only due to forum engine here).

Two remarks:

- Why do you call the template?

- <xsl:variable name="link-excel" select="'url_here'"> is faster than <xsl:variable ...>....</xsl:variable>

Martin