brad2610 Posted February 27, 2005 Share Posted February 27, 2005 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. Link to comment Share on other sites More sharing options...
Martin Brändle Posted February 27, 2005 Share Posted February 27, 2005 &-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 Link to comment Share on other sites More sharing options...
brad2610 Posted February 28, 2005 Author Share Posted February 28, 2005 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? Link to comment Share on other sites More sharing options...
Martin Brändle Posted February 28, 2005 Share Posted February 28, 2005 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 Link to comment Share on other sites More sharing options...
brad2610 Posted March 3, 2005 Author Share Posted March 3, 2005 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> Link to comment Share on other sites More sharing options...
Martin Brändle Posted March 3, 2005 Share Posted March 3, 2005 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6777 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 accountSign in
Already have an account? Sign in here.
Sign In Now