FileMaker Server 8 Advanced Custom Web Publishing Guide

Transcription

1 FileMaker Server 8 Advanced Web

2 FileMaker, Inc. All Rights Reserved. FileMaker, Inc Patrick Henry Drive Santa Clara, California FileMaker FileMaker, Inc. ScriptMaker FileMaker, Inc. FileMaker FileMaker, Inc. FileMaker Acknowledgements 01

3 1 Web 9 10 Web Web 10 XML Web 11 XSLT Web 11 XSLT 11 Web 12 Web 12 Web Web XML XSLT Web 12 FileMaker Web Pro Web Web 17 Web 17 Web Web Web MIME 18 Web Web 19 3 Web XML 21 XML Web 21 Web FileMaker Pro XML / 21 Web XML 22 Web XML 22 XML URL 23 XML URL 23 XML URL 23 XML FileMaker URL 24 URL 25

4 4 FileMaker Server Advanced Web Web XML 25 FileMaker XML 25 FileMaker 26 FileMaker 26 fmresultset 26 fmresultset 27 fmresultset XML 27 FileMaker XML 29 FMPXMLRESULT 29 FMPXMLRESULT XML 30 FMPXMLLAYOUT 31 FMPXMLLAYOUT XML 31 UTF-8 32 FileMaker XML 32 XML 34 XML XML 35 4 XSLT Web 37 FileMaker XSLT 37 FileMaker XSLT 37 XSLT Web 37 Web XML XSLT 38 XSLT Web 38 FileMaker Site Assistant FileMaker XSLT 39 Site Assistant 40 Site Assistant 40 Site Assistant 40 Site Assistant 41 Site Assistant 41 FileMaker CDML Converter 42 FileMaker CDML Converter 42 CDML Converter 42 CDML Converter 42 CDML Converter 43 CDML Converter 44 CDML Converter 44 Web FileMaker XSLT 44 XSLT 45

5 5 5 FileMaker XSLT 47 Web XSLT 47 FileMaker XSLT 47 FileMaker XSLT URL 48 XSLT FileMaker URL 48 FileMaker XSLT 49 FileMaker XSLT XML 49 FileMaker XSLT XSLT 52 FileMaker Server XSLT FileMaker XSLT 53 Web FileMaker XSLT Web URI 55 URI Web Web Cookie Perl

6 6 FileMaker Server Advanced Web 6 71 Web 71 XML Web 72 Web 72 Web 73 Web 73 A FileMaker dbnames 79 -delete 79 -dup 79 -edit 79 -find -findall -findany 79 -layoutnames 80 -new 80 -process XSLT 80 -scriptnames 80 -view db 81 -encoding XSLT 81 -field op 82 -grammar XSLT 83 -lay 83 -lay.response 83 -lop 83 -max 84

7 7 -modid ID 84 -recid ID 84 -script 84 -script.param 84 -script.prefind 85 -script.prefind.param 85 -script.presort 85 -script.presort.param 86 -skip 86 -sortfield 86 -sortorder 86 -stylehref href 87 -styletype 87 -token.[ ] XSLT 88 B Web 89 FileMaker 89 Web 94 FileMaker XSLT 96 C CDML FileMaker XSLT 99 CDML FileMaker XSLT 99 CDML URL 100 CDML -error -errornum 102 CDML 103 CDML 103 CDML 103 CDML 104 CDML XPath 105 CDML XPath 105 CDML XSLT-CWP 106 CDML 106 CDML XSLT-CWP

8 8 FileMaker Server Advanced Web

9 1 Web FileMaker Server Advanced FileMaker 1 XML Extensible Markup Language Web 1 XSLT Extensible Stylesheet Language Transformations Web 1 Web FileMaker Web XML XSLT Web Web FileMaker Server Web FileMaker Pro Web XML XSLT Web FileMaker Server FileMaker Server Web Web Web Web FileMaker Server Web XSLT HTML XMLvCard Web Web Web Web Web Web HREF Web FileMaker URL Uniform Resource Locator URL XML XSLT Web XML XSLT XML XSLT Web FileMaker Server Web 1. Web Web XML XSLT 2. Web Web 3. Web FileMaker Server.fp7.fp7 Web Web Web FileMaker Server Web FileMaker Server 6. Web Web 5. Web FileMaker XML XML Web Web XML 4. FileMaker Server FileMaker Web XSLT Web XSLT XML Web HTML XML Web FileMaker

10 10 FileMaker Server Advanced Web XML XSLT Web FileMaker Pro FileMaker Server XML XSLT Web 1 XML XSLT Web 1 XML XSLT 1 Web Web 1 FileMaker Server XML 1 FileMaker XSLT 1 CDML FileMaker XSLT FileMaker PDF FileMaker Server Advanced FileMaker Server Web XML XSLT Web FileMaker Server Web Web ODBC JDBC ODBC JDBC FileMaker Server FileMaker Server Admin FileMaker Server Advanced Web FileMaker Web FileMaker Server Advanced Web FileMaker ODBC JDBC FileMaker ODBC JDBC Web Web Web XML XSLT FileMaker Server Web Web 1 : Web FileMaker Web 1 : FileMaker XML FileMaker Web 1 : FileMaker XSLT FileMaker Web Web FileMaker Web 1 : Web Web XML Web XSLT Web FileMaker Web XML Web XSLT Web 1 : XSLT

11 1 Web 11 1 : XSLT 1 : Web XML XSLT URL XML Web 1 CDML : FileMaker CDML Converter CDML XSLT XSLT CDML XSLT XSLT CDML XML Web XML Web FileMaker HTTP FileMaker XML XML XML XSLT 3 Web XML XSLT Web XSLT Web XML Web XSLT FileMaker XML XML Web 4 XSLT Web Web XSLT HTTP URL Web FileMaker Web XML Web HTML XML XSLT FileMaker Server Advanced Web XSLT FileMaker Server Advanced XSLT 1 FileMaker Site Assistant XSLT FileMaker Web XSLT Site Assistant FileMaker XSLT XSLT 39 FileMaker Site Assistant FileMaker XSLT 1 FileMaker CDML Converter CDML XSLT Web XSLT CDML Web FileMaker XSLT 42 FileMaker CDML Converter

12 12 FileMaker Server Advanced Web Web Web XML XSLT Web 1 FileMaker Server Web 1 FileMaker Server FileMaker Pro 1 FileMaker Server Web 1 Microsoft IIS Windows Apache Mac OS X Web 1 Web IP 1 Web Web Web Web Web Web XML XSLT Web 1 Web 1 Web 1 Web IP 1 FileMaker Server 1 Web Web 1 Web IP ISP IP IP IP Web ISP XML XSLT Web FileMaker Server Advanced 7 8 XML XSLT Web 1 FileMaker Server FileMaker Pro 1 XSLT 1 FileMaker Server 8 Advanced XSLT JavaScript 67

13 1 Web 13 1 FileMaker XSLT XML 50 1 FileMaker Pro Web 18 1 Web 70 Web FileMaker Web 1 FileMaker Server 8 Advanced FileMaker 84 -script.param85 -script.prefind.param 86 -script.presort.param 1 fmresultset XML 1 XSLT Web 1 A 1 Web FileMaker Pro Web 78 FileMaker Web FileMaker Pro ScriptMaker ScriptMaker Web Web FileMaker Web 70 URL XSLT <?xslt cwp query?> Web FileMaker Pro [ ] [Web ] Web FileMaker Pro Web Web 1 Web Web Web 1 Web []

14 14 FileMaker Server Advanced Web 1 [ ] 1 Web [ ] 1 [ ] 1 [ ] 1 1 FileMaker Pro [ /] Web Web 1 [ /] [ ] [ ] [ ] [ / ] Web [ /] 1 Get Web Publishing Engine 8.0v1 Web FileMaker Pro 1 Web [Web ] Web 1 XSLT Web [XSLT :] FileMaker Server Advanced Web Web FileMaker Pro FileMaker Pro Web FileMaker Server Web Web Web Web Web Web Web Web

15 1 Web 15 / URL / Web Web Web Web [ ] Web [ /] Pro Web FileMaker Pro 8 FileMaker Web XML XSLT XML XSLT 7 1 FileMaker Pro 7 FileMaker Pro 1 FileMaker Pro FileMaker Server FileMaker Server Advanced Web 1 Web Web Web FileMaker Pro FileMaker 1 CDML C CDML FileMaker XSLT 1 FileMaker Pro Web Web 18 Web 1 Web URL FileMaker Pro Server 7 Advanced Web FileMaker Pro Server 7 Advanced FileMaker Server 23 XML URL 48 FileMaker XSLT URL 1 FileMaker Pro 7 Web 1 Web

16 16 FileMaker Server Advanced Web 1 ScriptMaker [ ] [Web ] Web Web Web [Web ] Web 1 Web Web 1 FileMaker Server Admin Web Web FileMaker Server Admin FileMaker Server Advanced Web 1 FileMaker FileMaker Pro Web 17 Web 1 XML FileMaker 3 Web XML 1 FileMaker XSLT 4 XSLT Web

17 2 Web Web Web Web XML Web XSLT Web Web FileMaker Server Web Web Web 1. FileMaker Pro [] [ ] 2. 1 XML Web fmxml 1 XSLT Web fmxslt FileMaker Pro 8 fmxmlfmxslt [ ] 3. Admin Web Web ASCII a z A Z 0 9!% FileMaker Pro Web Web Web Web Web Web HTTP Web Web Web HTTP Web Web 1 Web 1 Web

18 18 FileMaker Server Advanced Web 1 Web Web Web 1 1 Web [ ] Web 1 FileMaker Pro 1 Web Web [ ] Web FileMaker Pro XML XSLT Web 1 Web 1 XML XSLT Web 1 Web 1 Web Web Web FileMaker Server Advanced Web 1 Web IP Web IP Web IP Web 1 Web Web SSL Secure Sockets LayerSSL SSL Web FileMaker Web MIME MIME Multipurpose Internet Mail Extensions Web Web Web MIME Web Web FileMaker Web Web

19 2 Web 19 FileMaker FileMaker Server 24 XML FileMaker URL 48 XSLT FileMaker URL Web QuickTime 1. FileMaker Pro Web 2. FileMaker Pro [ ] 3. Web Web 1 IIS < >\Inetpub\wwwroot 1 Apache /Library/WebServer/Documents MIME Web Web Web Web Web Web 1 OLE 1 Web 1 GIF JPEG Web Web JPEG

20 20 FileMaker Server Advanced Web

21 3 Web XML Web FileMaker XML Extensible Markup Language HTML World Wide Web XML XML XML Web XML URL XML Web Web HTTP URL FileMaker FileMaker Server XML XML Web XSLT XML HTML vcard SVG Scalable Vector Graphics XML 4 XSLT Web 5 FileMaker XSLT XML XML XML FileMaker Web Web XML XML 1.0 XML XML Web FileMaker Pro XML / Web FileMaker Pro FileMaker XML 1 XML XSLT Web Web fmresultset FMPXMLRESULT FMPXMLLAYOUT FileMaker Pro XML FMPXMLRESULT FMPXMLRESULT FMPDSORESULT 25 Web XML 1 Web XML URL Web FileMaker Pro XML FileMaker Pro 1 Web FileMaker Server FileMaker Pro XML 1 Web URL FileMaker XML FileMaker Pro XML XML 1 Web XML FileMaker Pro XML 1 Web FileMaker XML FileMaker Pro 1 Web FileMaker Pro 1 Web HTTP HTTPS FileMaker FileMaker Pro

22 22 FileMaker Server Advanced Web FileMaker Pro XML FileMaker Pro Web XML XML Web Web FileMaker XML Web 1. Web Web XML HTTP HTTPS Web Web 2. Web Web FileMaker Server Web Web CWPE Web 3. Web FileMaker Server FileMaker Server.fp7.fp7 Web FileMaker Server XML.fp7.fp7 FileMaker Server Web XML Web 5. Web XML Web FileMaker Server Web 4. FileMaker Server Web 6. Web Web Web Web Web CWPE Web Web XML Web FileMaker XML 1. Web [XML :] FileMaker Server Advanced Web 2. FileMaker FileMaker Pro XML Web fmxml 17 Web XML [] [ ] [] XML

23 3 Web XML 23 XML XML 3. HTML HREF Web FileMaker XML FileMaker URL HTTP HTTPS Web Web URL URL XML URL 32 FileMaker XML A 4. Web URL XML Web 5. Web XML Web Web 35 XML URL Web FileMaker XML URL XSLT URL XML 48 FileMaker XSLT URL 48 XSLT FileMaker URL XML URL FileMaker Server 7 8 Web XML URL 1 Pro 6 XML FMPro?<CGI > XML URL 1 -dbnames -layoutnames -scriptnames -process XSLT -lay A 1 -format XML XML URL XML URL XML XSLT -grammar 49 FileMaker XSLT XML XML URL Web FileMaker XML URL < >://<>[:<>]/fmi/xml/<xml >.xml[?< >] 1 < > HTTP HTTPS 1 <> Web IP

24 24 FileMaker Server Advanced Web 1 <> Web HTTP 80 HTTPS <XML > FileMaker XML fmresultset.xml FMPXMLRESULT.xml FMPXMLLAYOUT.xml FMPDSORESULT.xml 26 fmresultset 29 FileMaker XML 1 < > FileMaker XML -dbnames 32 FileMaker XML A URL URL FMPXMLRESULT FMPXMLLAYOUT FMPDSORESULT 3 76 Web XML URL XML FileMaker URL XML XML 1 <data> URL <data>/fmi/xml/cnt/data.< >?< ></data> <>.jpg MIME Web < > XML URL <data>/fmi/xml/cnt/data.jpg?-db=products&-lay=sales&-field=product_image(1)&-recid=2</data> XML -field 77 < >://< >[:< >]/fmi/xml/cnt/data.< >?< > < > <> <> XML URL 1 <data> <data>/images/logo.jpg</data> FileMaker Pro Web Web 18 Web

25 3 Web XML 25 1 <data> XML XSLT 48 XSLT FileMaker URL URL XML URL UTF-8 Unicode Transformation 8 Bit 32 UTF-8 info fiancée URL &info= fianc%c3%a9e&-edit URL %C3%A9 UTF-8 é URL URL URL Web XML Web XML FileMaker FileMaker FileMaker URL Web XML XML 1 fmresultset: Web XSLT FileMaker XML XSLT Web FMPXMLRESULT 26 fmresultset 1 FMPXMLRESULT FMPXMLLAYOUT: XML XSLT FMPXMLRESULT FMPXMLLAYOUT Web XML Web FMPXMLRESULT FMPXMLLAYOUT 29 FileMaker XML 1 FMPDSORESULT: FMPDSORESULT FileMaker Pro XML Web XML FMPDSORESULT XSLT FMPDSORESULT FileMaker Pro URL Web XML XML XML FileMaker XML Web FileMaker XML Web XML UTF-8 Unicode Transformation Format 8 32 UTF-8 FileMaker XML XML XML <DATABASE> FileMaker XML Oracle XML XML <DATABASE>

26 26 FileMaker Server Advanced Web Web fmresultset FMPXMLRESULT FMPXMLLAYOUT xmlns=" xmlns=" fmpxmlresult" xmlns=" FileMaker Web XML 0 fmresultset FMPXMLRESULT FMPDSORESULT <error code="0"></error> <ERRORCODE>0</ERRORCODE> <ERRORCODE>0</ERRORCODE> XML XSLT B Web FileMaker FileMaker DTDHTTP fmresultset FMPXMLRESULT FMPXMLLAYOUT FMPDSORESULT HTTP > fmresultset XML FileMaker fmresultset Web XML URL fmresultset fmresultset.xml fmresultset Web fmresultset XML XML Web <?xml...?> <!DOCTYPE> fmresultset <!DOCTYPE> fmresultset DTD URL

27 3 Web XML 27 fmresultset fmresultset <datasource> <metadata> <resultset> <datasource> fmresultset <datasource> table layout date-format time-format timestamp-format total-count database 1 XML <datasource> date-format yyyy/mm/dd 1 yyyy 4 1 MM dd XML <datasource> time-format HH:mm:ss 1 HH mm ss <datasource> timestamp-format date-format time-format 1 yyyy/mm/dd HH:mm:ss <metadata> fmresultset <metadata> <field-definition> <relatedset-definition> yes no max-repeat yes no yes notext numberdatetimetimestampcontainer normalcalculationsummary <relatedset-definition> <relatedset-definition> <field-definition> <relatedset-definition> <resultset> <resultset> <record> <record> mod-id record-id <data> <relatedset> <record> <relatedset> count table fmresultset XML fmresultset XML <?xml version="1.0" encoding="utf-8" standalone="no"?> <!DOCTYPE fmresultset PUBLIC "-//FMI//DTD fmresultset//en" "/fmi/xml/fmresultset.dtd">

28 28 FileMaker Server Advanced Web <fmresultset xmlns=" version="1.0"> <error code="0"></error> <product build="06/15/2005" name="filemaker Web Publishing Engine" version=" "/> <datasource database="art" date-format="mm/dd/yyyy" layout="web3" table="art" time-format="hh:mm:ss" timestamp-format="mm/ dd/yyyy HH:mm:ss" total-count="16"/> <metadata> <field-definition auto-enter="no" global="no" max-repeat="1" name="title" not-empty="no" result="text" type="normal" /> <field-definition auto-enter="no" global="no" max-repeat="1" name="artist" not-empty="no" result="text" type="normal" /> <relatedset-definition table="artlocation"> <field-definition auto-enter="no" global="no" max-repeat="1" name="artlocation::location" not-empty="no" result="text" type="normal" /> <field-definition auto-enter="no" global="no" max-repeat="1" name="artlocation::date" not-empty="no" result="date" type="normal" /> </relatedset-definition> <field-definition auto-enter="no" global="no" max-repeat="1" name="style" not-empty="no" result="text" type="normal"/> <field-definition auto-enter="no" global="no" max-repeat="1" name="length" not-empty="no" result="number" type="calculation"/> </metadata> <resultset count="1" fetch-size="1"> <record mod-id="2" record-id="3"> <field name="title"> <data>still Life with Apples, Cup and Glass</data> </field> <field name="artist"> <data>paul Cezanne</data> </field> <relatedset count="2" table="artlocation"> <record mod-id="1" record-id="6"> <field name="artlocation::location"> <data>vault</data> </field> <field name="artlocation::date"> <data>07/07/1997</data> </field> </record> <record mod-id="0" record-id="18"> <field name="artlocation::location"> <data>home</data> </field> <field name="artlocation::date"> <data>08/01/2001</data> </field> </record> </relatedset> <field name="style"> <data>impressionist</data> </field> <field name="length">

29 3 Web XML 29 <data>37</data> </field> </record> </resultset> </fmresultset> FileMaker XML FileMaker XML FMPXMLRESULT fmresultset FMPXMLLAYOUT FMPXMLRESULT FMPXMLLAYOUT FMPXMLRESULT Web XML URL FMPXMLRESULT.xml FMPXMLLAYOUT Web XML URL - view FMPXMLLAYOUT.xml FMPXMLRESULT FMPXMLLAYOUT XML Web <?xml...?> <!DOCTYPE> <!DOCTYPE> DTD URL FMPXMLRESULT FMPXMLRESULT <DATABASE> NAME RECORDS DATEFORMAT LAYOUT TIMEFORMAT XML <DATABASE> DATEFORMAT XML <DATABASE> TIMEFORMAT FMPXMLRESULT fmresultset 27 fmresultset FMPXMLRESULT <METADATA> FIELD <FIELD> / Yes / No EMPTYOK MAXREPEAT TEXT NUMBER DATE TIME CONTAINER <RESULTSET> <ROW> <ROW> / RECORDID MODID 84 -modid ID <COL> <COL> / <DATA>

30 30 FileMaker Server Advanced Web FMPXMLRESULT XML FMPXMLRESULT XML <?xml version="1.0" encoding="utf-8" standalone="no"?> <!DOCTYPE FMPXMLRESULT PUBLIC "-//FMI//DTD FMPXMLRESULT//EN" "/fmi/xml/fmpxmlresult.dtd"> <FMPXMLRESULT xmlns=" <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="06/15/2005" NAME="FileMaker Web Publishing Engine" VERSION=" "/> <DATABASE DATEFORMAT="MM/dd/yyyy" LAYOUT="web3" NAME="art" RECORDS="16" TIMEFORMAT="HH:mm:ss"/> <METADATA> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Title" TYPE="TEXT" /> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Artist" TYPE="TEXT" /> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="artlocation::Location" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="artlocation::Date" TYPE="DATE"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Style" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="length" TYPE="NUMBER"/> </METADATA> <RESULTSET FOUND="1"> <ROW MODID="2" RECORDID="2"> <COL> <DATA>The Dancers in Blue</DATA> </COL> <COL> <DATA>Edgar Degas</DATA> </COL> <COL> <DATA>Study</DATA> </COL> <COL> <DATA>01/08/1979</DATA> </COL> <COL> <DATA>Impressionist</DATA> </COL> <COL> <DATA>19</DATA> </COL> </ROW> </RESULTSET> </FMPXMLRESULT> <COL> <METADATA> <FIELD> <METADATA> Title Artist Village Market Camille Pissarro <RESULTSET> <ROW>

31 3 Web XML 31 FMPXMLLAYOUT FMPXMLLAYOUT <FIELD> <LAYOUT> <FIELD> VALUELIST <VALUELISTS> <VALUELIST> <VALUE> fm fmmm/dd/yyyy HH:mm:ss MM/dd/yyyy HH:mm:ss 64 fm 2 FMPXMLLAYOUT XML FMPXMLLAYOUT XML <?xml version="1.0" encoding="utf-8" standalone="no"?> <!DOCTYPE FMPXMLLAYOUT PUBLIC "-//FMI//DTD FMPXMLLAYOUT//EN" "/fmi/xml/fmpxmllayout.dtd"> <FMPXMLLAYOUT xmlns=" <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="06/15/2005" NAME="FileMaker Web Publishing Engine" VERSION=" "/> <LAYOUT DATABASE="art" NAME="web2"> <FIELD NAME="Title"> <STYLE TYPE="EDITTEXT" VALUELIST="" /> </FIELD> <FIELD NAME="Artist"> <STYLE TYPE="EDITTEXT" VALUELIST="" /> </FIELD> <FIELD NAME="Image"> <STYLE TYPE="EDITTEXT" VALUELIST="" /> </FIELD> <FIELD NAME="artlocation::Location"> <STYLE TYPE="EDITTEXT" VALUELIST="" /> </FIELD> <FIELD NAME="artlocation::Date"> <STYLE TYPE="EDITTEXT" VALUELIST="" /> </FIELD> <FIELD NAME="Style"> <STYLE TYPE="POPUPMENU" VALUELIST="style"/> </FIELD> </LAYOUT> <VALUELISTS> <VALUELIST NAME="style"> <VALUE>Impressionist</VALUE> <VALUE>Modern</VALUE>

32 32 FileMaker Server Advanced Web <VALUE>Abstract</VALUE> </VALUELIST> </VALUELISTS> </FMPXMLLAYOUT> UTF-8 Web XML UTF-8 Unicode Transformation Format 8 ASCII Unicode 16 XML Unicode UTF-8 UTF-8 ASCII Unicode UTF-8 Web UTF-8 1 ASCII UTF-8 ASCII UTF-8 1 ASCII 1 UTF UTF-8 UTF-16 Unicode 1 UTF-8 ASCII Unicode UTF-8 UTF-16 50% FileMaker XML FileMaker XML FileMaker URL -findall products FileMaker -new -dbnames -db URL FileMaker XSLT <?xslt-cwp-query?> 5 FileMaker XSLT FileMaker A Web FileMaker XSLT -process 49 FileMaker XSLT

33 3 Web XML 33 -dbnames -delete -dup -edit -find -findall -findany -layoutnames -new -scriptnames -view Web Web Web FMPXMLLAYOUT fmresultset FMPXMLRESULT XML <metadata> -db -field.op -lay -lay.response XML -lop -max -modid ID -recid ID -script -script.param -script -script.prefind -find -findany -findall -script.prefind.param -script.prefind -dbnames -process XSLT URL 24 XML FileMaker URL -edit -find 82 -find -dbnames -layoutnames -scriptnames -process XSLT -dbnames -layoutnames -scriptnames -process XSLT -find -find -findall -edit -edit -delete -dup -find -find -findall -findany -new -edit -delete -dup -view -script -find -findany -findall -script.prefind

34 34 FileMaker Server Advanced Web -script.presort -script.presort.param -script.presort -skip -sortfield.[1-9] -sortorder.[1-9] -stylehref HREF -styletype -find -findall -script.presort -find -findall -find -findall -find -findall -styletype URL XML -lay XML XML XML XML -lay.response BudgetSalary 100,000 ExecList Salary &-lay.response=execlist XML XML XML FileMaker Server Web XML 1. -lay 2..global= URL 3. -script.prefind 4. -find -new 5. -script.presort lay.response 8. -script 9. XML -sortfield 102

35 3 Web XML 35 Web XSLT Web XML XSLT Web 4 XSLT Web 5 FileMaker XSLT FileMaker -styletype -stylehref Web XML XML CSS Cascading Style Sheet XSLT 1 -styletype TYPE type=text/css type=text/xsl 1 -stylehref HREF href=/mystylesheet.css href=/stylesheets/mystylesheet.xsl.css.xsl FileMaker &-stylehref=/mystylesheet.xsl -stylehref=/document.xsl/ Web Web URL Web Web XML <?xml stylesheet type="text/xsl" href="/mystylesheet.xsl"?> HREF URL Web xslt-template-files XSLT 44 Web FileMaker XSLT Web Web XML Web XML 1 XML Web 17 Web 1 FileMaker Server FileMaker Server Admin 1 1 Web Web 1 Web [XML :] FileMaker Server Advanced Web

36 36 FileMaker Server Advanced Web

37 4 XSLT Web FileMaker XSLT XML Web FileMaker XSLT XSLT Site Assistant CDML Converter FileMaker XSLT 5 FileMaker XSLT FileMaker XSLT FileMaker XSLT Web 1 HTML vcard 1 FileMaker XML XML SVG Scalable Vector Graphics 1 FileMaker Web FileMaker 1 FileMaker Server XSLT Web XSLT 1.0 W3C XSLT Cookie FileMaker XSLT 53 FileMaker XSLT Web XSL-FO XSL Formatting Objects FileMaker XSLT FileMaker XSLT 1 FileMaker Web Web Web FileMaker 1 FileMaker Web 1 FileMaker vcard Web 1 FileMaker XML XML XSLT Web XML XSLT FileMaker XSLT FileMaker XML XSLT Web Site Assistant CDML Converter XML XSLT

38 38 FileMaker Server Advanced Web Web XML XSLT Web XSLT-CWP XSLT Web Web URL FileMaker XSLT Web 1. Web Web XSLT-CWP Web Web 3. CWPE Web XML FileMaker Server Web Web 4. Web FileMaker Server FileMaker Server 2. Web XSLT- CWP CWPE CWPE Web.fp7.fp7 Web FileMaker Server XSLT-CWP.fp7.fp7 FileMaker Server Web XSLT Web 8. Web Web Web Web 6. Web XML CWPE FileMaker Server Web Web 5. FileMaker Server Web 7. CWPE XSLT XML HTML XML Web CWPE Web XSLT Web XSLT Web 1. Web [XSLT :] FileMaker Server Advanced Web 2. FileMaker FileMaker Pro XSLT Web fmxslt 17 Web

39 4 XSLT Web 39 FileMaker FileMaker 3. FileMaker XML FileMaker XSLT XSLT FileMaker Site Assistant XSLT FileMaker Site Assistant FileMaker XSLT CDML CDML Converter CDML XSLT 42 FileMaker CDML Converter XSLT XSLT 5 FileMaker XSLT 4. XSLT xslt-template-files xslt-template-files Web FileMaker Server Web Publishing xslt-template-files 5. Web 44 Web FileMaker XSLT 6. XSLT Web Web XSLT XSLT index.html Web 7. FileMaker 8. Web XSLT 9. FileMaker Site Assistant FileMaker XSLT FileMaker Site Assistant XSLT FileMaker Web XSLT Site Assistant FileMaker XSLT XSLT Site Assistant Site Assistant Web FileMaker XSLT Site Assistant

40 40 FileMaker Server Advanced Web XSLT Web XSLT HTTP URL Web FileMaker Web XML Web HTML Site Assistant fmresultset XML FileMaker XML HTML FileMaker XML XML Site Assistant Site Assistant FileMaker Server Advanced Web Site Assistant Site Assistant XSLT 1 fmxslt Site Assistant Web 17 Web 1 FileMaker Server FileMaker Server Admin 1 Web Web 1 XSLT Web [XSLT :] FileMaker Server Advanced Web Site Assistant Site Assistant 1 FileMaker Site Assistant

41 4 XSLT Web 41 1 Windows [ ] [ ] [FileMaker Site Assistant] FileMaker Site Assistant Site Assistant Site Assistant Site Assistant Site Assistant 44 Web FileMaker XSLT Site Assistant Site Assistant Site Assistant XSLT FileMaker 1 <?xslt-cwp-query params=" "?> XML Site Assistant 50 1 <xsl:param name="request-query"/> HTML Site Assistant 54 1 <xsl:param name="authenticated-xml-base-uri"/> XML URI 55 URI utilities.xsl Site Assistant XSLT Site Assistant 5 FileMaker XSLT

42 42 FileMaker Server Advanced Web FileMaker CDML Converter FileMaker Server 7 Advanced FileMaker Web CDML FileMaker XSLT CDML CDML FileMaker XSLT Web FileMaker CDML Converter FileMaker CDML Converter FileMaker CDML Converter CDML XSLT Web XSLT CDML Web FileMaker XSLT CDML Converter CDML CDML Converter XSLT FileMaker Server CDML Converter CDML XSLT XSLT XSLT CDML XSLT.xsl CDML Converter CDML XSLT CDML Converter CDML Web XSLT CDML XSLT Web XSLT fmresultset XML FileMaker HTML CDML Converter CDML Converter FileMaker Server Advanced Web CDML Converter cdml_format_files FileMaker Pro Web XSLT CDML Converter.xsl Myfile.htmlMyfile.cdml CDML Converter Myfile.htmlMyfile.xsl Myfile.cdmlMyfile.xsl Myfile.xslCDML Converter CDML Converter 1. CDML Converter 1 FileMaker CDML Converter

43 4 XSLT Web 43 1 Windows [ ] [ ] [FileMaker CDML Converter] CDML XSLT FileMaker CDML Converter 2. [ ] [...] CDML 3. CDML [ ] 4. [ :] CDML [ ] [...] XSLT CDML Web CDML Converter images GIF CDML.xsl 6. XSLT [ ] 7. [ ] CDML Converter CDML XSLT CDML Converter 8. [ ] CDML Converter CDML Converter CDML Converter cdml2xsl_< >.log < > CDML Converter XSLT XSLT XSLT XSLT <!-- CDML Converter : <> --> <!-- CDML Converter : < > -->

44 44 FileMaker Server Advanced Web CDML Converter CDML XSLT CDML CDML Converter CDML XSLT CDML XSLT XSLT 1 XSLT Web CDML dbclose CDML CDML CDML XSLT 1 CDML CDML CDML XSLT 1 CDML XSLT CDML [FMP-ValueList:, List= ] CDML List CDML XSLT CDML XSLT CDML XSLT C CDML FileMaker XSLT 1 CDML XSLT XSLT 1 XSLT FileMaker fmxslt:get_date() FileMaker Server fm fm MM/dd/yyyy HH:mm:ssMM/dd/yyyy HH:mm:ss 64 / / / / CDML Converter XSLT Web Web FileMaker XSLT CDML Converter XSLT 6 Web FileMaker XSLT Web Web Site Assistant CDML Converter XSLT Web FileMaker XSLT 1. XSLT xslt-template-files xslt-template-files Web FileMaker Server Web Publishing

45 4 XSLT Web 45 xslt-template-files 2. XSLT HTML Web HTML <img src="logo.jpg"> XSLT logo.jpg logo.jpg Web < >/fmi/xsl/logo.jpg 3. FileMaker Pro Web Web 18 Web FileMaker FileMaker Server 4. XSLT URL < >://< >[:< >]/fmi/xsl/< >/< >.xsl[?< >] 48 FileMaker XSLT URL Web XSLT Site Assistant <?xslt-cwp-query?> home.xsl home.xsl xslt-template-files my_templates Web URL Web Web xslt-template-files XSLT Web Web Web XSLT XSLT 1 XSLT Web 17 Web 1 FileMaker Server FileMaker Server Admin 1 1 Web Web 1 Web [XSLT :] FileMaker Server Advanced Web

46 46 FileMaker Server Advanced Web

47 5 FileMaker XSLT FileMaker XSLT FileMaker XSLT Web XSLT Web FileMaker XML XSLT 1 Web XSLT URL XSLT Web Web 48 FileMaker XSLT URL 1 URL UTF-8 Web ASCII 1 FileMaker XML URL <?xslt-cwp-query?> XML Web 49 FileMaker XSLT XML 1 FileMaker XML URL <?xslt-cwp-query?> 48 FileMaker XSLT URL encoding XSLT Web 51 1 <xsl:output> method Web HTML <xsl:output> encoding 52 1 fmxslt:send_ () Web 59 Web Web <?xslt-cwp-query?> <?xslt-cwp-query?> URL Web <?xslt-cwp-query?> URL Web FileMaker XML Web HTML FileMaker XSLT FileMaker Server Web Publishing CD FileMaker XSLT XSLT Reference.fp7 FileMaker FileMaker XSLT FileMaker Server Web Publishing CD Custom Web Publishing Reference

48 48 FileMaker Server Advanced Web FileMaker XSLT URL FileMaker XSLT Web URL < >://<>[:<>]/fmi/xsl/[< >/]<.xsl>[?< >] 1 < > HTTP HTTPS 1 <> Web IP 1 <> Web HTTP 80 HTTPS < > XSLT xslt-template-files 1 <.xsl> XSLT 1 < > XSLT Web 49 FileMaker XSLT A <?xslt-cwp-query?> URL 50 URL URL FMPXMLRESULT FMPXMLLAYOUT 76 FileMaker XSLT Web URL &-lay=mylayout&-findall XSLT FileMaker URL XSLT XML 1 <data> URL <data>/fmi/xsl/cnt/data.< >?< ></data> <>.jpg.mov < > FileMaker XSLT URL <data>/fmi/xsl/cnt/data.jpg?-db=products&-lay=sales&-field=product_image(1)&-recid=2</data> XML -field 77

49 5 FileMaker XSLT 49 < >://< >[:< >]/fmi/xsl/cnt/data.< >?< > < > <> <> FileMaker XSLT URL 1 <data> logo.jpg FileMaker Pro Web <data> <data>/images/logo.jpg</data> FileMaker Pro Web Web 18 Web 1 <data> FileMaker XSLT URL FileMaker XSLT <?xslt-cwp-query?> FileMaker XML 32 FileMaker XML FileMaker XSLT XSLT -grammar -encoding -process -token XSLT-CWP XSLT XML FileMaker XSLT XML FileMaker Server XSLT Cookie 53 XSLT XSLT -grammar XSLT FileMaker XSLT XML XSLT Web XML fmresultset XSLT 26 fmresultset FMPXMLRESULT FMPXMLLAYOUT FMPXMLLAYOUT 29 FileMaker XML XSLT Web FMPDSORESULT FileMaker XSLT URL <?xslt-cwp-query?> -grammar

50 50 FileMaker Server Advanced Web &-lay=mylayout&-findall <?xslt-cwp-query params="-grammar=fmresultset&-db=mydatabase&-lay=mylayout&-findall"?> FileMaker XSLT XML QUERY -ER0001 B Web FileMaker XSLT XSLT XSLT FileMaker XSLT FileMaker XSLT <xsl:stylesheet> fmresultset XML xmlns:fmrs=" fmrs FMPXMLRESULT xmlns:fmp=" fmp FMPXMLLAYOUT xmlns:fml=" fml XML xmlns:fmq=" fmq FileMaker XSLT xmlns:fmxslt="xalan://com.fmi.xslt.extensionfunctions" fmxslt FileMaker XSLT xmlns:xsl=" <xsl:stylesheet version="1.0" xmlns:xsl=" xmlns:fmrs=" xmlns:fml=" xmlns:fmq=" xmlns:fmxslt="xalan://com.fmi.xslt.extensionfunctions" exclude-result-prefixes="xsl fmrs fmq fml fmxslt"> FileMaker XSLT XML URL Site Assistant CDML Converter FileMaker XSLT <?xslt-cwp-query params=" "?>

51 5 FileMaker XSLT 51 = &=... -db=products -findall = A URL 25 URL <xsl:output> encoding Web & my_stylesheet.xsl <?xslt-cwp-query params="-db=products&-lay=sales&-grammar=fmresultset&productname=the%20item&-find"?> my_stylesheet.xslproductssales fmresultset the%20item productname -find my_stylesheet.xsl XML Web London&-find -lay=revenue -edit city city London Web XML Web XSLT 1. Content-Type charset 2. -encoding URL <?xslt-cwp-query?> -encoding &-encoding=shift_jis&-findall 3. Web [ :] Web UTF-8 Web FileMaker Server Advanced Web Web Content-Type charset encoding

52 52 FileMaker Server Advanced Web US-ASCII ISO ISO ISO-2022-JP Shift_JIS UTF-8 ASCII Latin 1 ASCII Web Latin 9 Latin 1 ISO Web Unicode Web UTF-8 UTF-8 Unicode 1 Web Shift_JIS Web ISO-2022-JP 1 fmxslt:send_ (string SMTP, String, String ) 59 Web <xsl:output> method encoding method htmltextxml html encoding <xsl:output method="html" encoding="shift_jis"/> <xsl:output> HTML XSLT XML encoding XSLT 52 UTF-8 <?xml version="1.0" encoding="utf-8"?> Web UTF-8

53 5 FileMaker XSLT 53 FileMaker Server XSLT -process XSLT -process FileMaker Server -process fmxslt:send_ () 1 -process Web XML -process -grammar fmresultset FMPXMLRESULT -token URL Cookie -token URL &-token.d100=pending&-findall 88 -token.[] XSLT -token -token <xsl:param name="request-query" /> 54 FileMaker XSLT FileMaker XSLT fmxslt XSLT <xsl:stylesheet> fmxslt 50 FileMaker XSLT FileMaker XSLT XPath XSLT XPath XSLT select test User-Agent User-Agent <xsl:variable name="user-agent" select="fmxslt:get_header('user-agent')"/> XSLT FileMaker XSLT FileMaker XSLT 47 FileMaker XSLT

54 54 FileMaker Server Advanced Web Web FileMaker XSLT Web FileMaker XSLT <xsl:param> FileMaker XSLT <xsl:param name="request-query"/> <xsl:param name="client-ip"/> <xsl:param name="client-user-name"/> <xsl:param name="client-password"/> <xsl:param name="xml-base-uri"/> <xsl:param name="authenticated-xml-base-uri"> Web URI 55 URI FileMaker XSLT URL HTML Web FileMaker XML FileMaker XSLT <xsl:param name="request-query"/> Web request-query XML <!DOCTYPE query [ <!ELEMENT query (parameter)*> <!ATTLIST query action CDATA #REQUIRED> <!ELEMENT parameter (#PCDATA)> <!ATTLIST parameter name CDATA #REQUIRED> ] fmq=" XSLT <xsl:stylesheet> fmq 50 FileMaker XSLT &-findall <xsl:param name="request-query" /> Web XML <query action="my_stylesheet.xsl" xmlns=" <parameter name="-db">products</parameter> <parameter name="-db">sales</parameter> <parameter name="-grammar">fmresultset</parameter> <parameter name="-token.1">abc123</parameter> <parameter name="-findall"></parameter> </query>

55 5 FileMaker XSLT 55 XPath request-query URL = '-token.1'] FileMaker XSLT Web Web IP <xsl:param name="client-ip"/> <xsl:param name="client-user-name"/> <xsl:param name="client-password"> XSLT <xsl:template> XML Web 56 Web HTTP 17 Web Web FileMaker XSLT FileMaker XSLT Web URI Web URI Uniform Resource Identifier Web URI FileMaker XML Web Web URI XSLT <xsl:template> <xsl:param name="xml-base-uri"/> FileMaker XML $xml-base-uri URI XML URI <xsl:variable name="layout_information" select="document(concat($xml-base-uri,'/fmi/xml/fmpxmllayout.xml? -db=products&-lay=sales&-view'))" /> URI authenticated-xml-base-uri client-user-name client-password xml-base-uri <xsl:param name="authenticated-xml-base-uri"/> XML XSLT <xsl:template> client-user-name client-password authenticated-xml-base-uri : client-user-name client-password authenticated-xml-base-uri xml-base-uri

56 56 FileMaker Server Advanced Web XSLT XML XML URI XSLT document() document() XML <xsl:variable> FileMaker XML document() FileMaker <xsl:variable name="other-data" select="document(concat($xml-base-uri,'/fmi/xml/fmpxmllayout.xml? -db=products&-lay=sales&-view'))" /> XML authenticated-xml-base-uri document() URI <xsl:variable name="other-data" select="document(concat($authenticated-xml-base-uri, '/fmi/xml/fmpxmllayout.xml?-db=products&-lay=sales&-view'))"/> XML document() URI /? FileMaker XML FileMaker document() <xsl:variable name="other-data" select="document(' /> document() URL Web XML xslttemplate-files mystylesheets URL document() <xsl:variable name="mydoc" select="document('mystylesheets/mydoc.xml')" /> Web xslt-template-files mystylesheets mydoc.xml Web Web URI HTTP HTTP HTTPS FMPXMLLAYOUT XSLT document() FileMaker <xsl:variable name="layout" select="document(concat($xml-base-uri,'/fmi/xml/fmpxmllayout.xml?-view'))" /> Color FileMaker shirts document() XSLT <xsl:variable name="layout" select="document(concat($xml-base-uri,'/fmi/xml/fmpxmllayout.xml?-db=products &-lay=sales&-view'))" /> <select size="1"> <xsl:attribute name="name">color</xsl:attribute> <option value="">select One...</option>

57 5 FileMaker XSLT 57 <xsl:for-each = 'shirts']/fml:value"> <option> <xsl:attribute name="value"><xsl:value-of select="."/></xsl:attribute> <xsl:value-of select="."/> </option> </xsl:for-each> </select> Web XSLT Web XSLT XSLT FileMaker 1 fmxslt:create_session(): 58 1 fmxslt:set_header(): 60 1 fmxslt:set_status_code (): 60 1 fmxslt:set_cookie(): 61 Cookie FileMaker XSLT <?xslt-cwp-buffer buffer-content="true"?> <?xslt-cwp-buffer?> Web Content-Length Web Web Web Web Web Cookie ID Cookie fmxslt:session_encode_url() ID URL URL fmxslt:session_encode_url() jsessionid URL ID <a href="my_stylesheet.xsl?-db=products&-lay=sales&-grammar=fmresultset&-findall">hyperlinked text</a> <a href="{fmxslt:session_encode_url('my_stylesheet.xsl?-db=products&-lay=sales&-grammar=fmresultset &-findall')}">hyperlinked text</a>

58 58 FileMaker Server Advanced Web Cookie <a href="my_stylesheet.xsl;jsessionid=<session id>?-db=products&-lay=sales&-grammar=fmresultset&-findall"> hyperlinked text</a> Cookie Web fmxslt:session_encode_url() URL Cookie ID Web XML fmxslt:session_exists(string ) fmxslt:create_session(string ) FileMaker Server Advanced Web <?xslt-cwp-buffer?> 57 fmxslt:invalidate_session(string ) fmxslt:set_session_timeout(string, Number ) fmxslt:session_encode_url(string URL) Cookie ID URL URL fmxslt:set_session_object(string, String, Object ) fmxslt:get_session_object(string, String ) fmxslt:remove_session_object(string, String ) XSLT XSLT XSLT XSLT fmxslt:get_session_object () XSLT XSLT <xsl:variable name="session"> <xsl:choose> <xsl:when test="not (fmxslt:session_exists(string($session-name)))"> <xsl:value-of select="fmxslt:create_session(string($session-name))"/> </xsl:when> <xsl:otherwise>true</xsl:otherwise> </xsl:choose>

59 5 FileMaker XSLT 59 </xsl:variable> <xsl:variable name="favorite-color" select="fmxslt:set_session_object(string($session-name), 'favorite-color', string($color))"/> 1 fmxslt:invalidate_session () 1 Web [XSLT :] FileMaker Server Advanced Web 1 Web Web Web Web Web Web XSLT fmxslt:send_ () fmxslt:send_ () Web XSLT Web fmxslt:send_ (string SMTP, String ) fmxslt:send_ (string SMTP, String, String ) fmxslt:send_ (string SMTP, String XSLT, Node XML, boolean ) Web Web US-ASCII ISO ISO ISO-2022-JP Shift_JIS UTF-8 51 <xsl:output> encoding HTML <xsl:output> encoding Web 1 fmxslt:send_ () SMTP URL RFC 2368 mailto = & 1 from 1 /

60 60 FileMaker Server Advanced Web 1 subject= from reply-to subject false() 1 " tld com net 1 subject SMTP URL & & %20 SMTP XML 1 true() false() 1 Web Shift_JIS FileMaker Server Advanced Web 1 fmxslt:send_ (string SMTP, String XSLT, Node XML, boolean ) XML 1 XSLT URL 1 XML XML XML XML XPath / document() fmxslt:send_ () XML 1 HTML Web true() FileMaker URL Web false () URL Web URL Web <xsl:if> XPath fmxslt:send_ (string SMTP, String XSLT, Node XML, boolean ) fmxslt:send_ ('tom_jones@company.com?subject=project%20status&from=john_smith@company.com &cc=jane_doe@company.com','my_mail_template.xsl', /, true()) SMTP Web FileMaker Server Advanced Web fmxslt:get_header() HTTP fmxslt:set_header() Web HTTP

61 5 FileMaker XSLT 61 fmxslt:get_header(string ) fmxslt:set_header(string, String ) void fmxslt:set_status_code(number ) void HTTP 1 fmxslt:get_header() fmxslt:set_header() fmxslt:set_header() 1 fmxslt:set_header() fmxslt:set_status_code() <?xslt-cwp-buffer?> 57 vcard.xsl vcard Content-Disposition.vcf <xsl:value-of select="fmxslt:set_header('content-disposition','attachment;filename=test.vcf')" /> Cookie Cookie Web Cookie Cookie fmxslt:get_cookie(string ) Cookie COOKIES fmxslt:get_cookies() Cookie COOKIES fmxslt:set_cookie(string, String ) void Cookie fmxslt:set_cookie(string, String, Number, String, String ) void Cookie Cookie Cookie 1 fmxslt:get_cookie() fmxslt:get_cookies() <!ELEMENT cookies (cookie)*> <!ATTLIST cookie xmlns CDATA #FIXED " <!ELEMENT cookie (#PCDATA)> <!ATTLIST cookie name CDATA #REQUIRED> 1 cookies XML " 1 fmxslt:set_cookie Web fmxslt:set_cookie 1 Cookie 1 fmxslt:set_cookie() <?xslt-cwp-buffer?> 57

62 62 FileMaker Server Advanced Web : get_cookie preferences cookie <xsl:variable name="pref_cookie" select="fmxslt:get_cookie('preferences')"/> <xsl:value-of select="concat('cookie Name = ', $pref_cookie/fmc:cookies/fmc:cookie/@name)"/> <br/> <xsl:value-of select="concat('cookie Name = ', $pref_cookie/fmc:cookies/fmc:cookie)"/> : set_cookie Cookie <xsl:variable name="storing_cookie" select="fmxslt:set_cookie ('text1', 'text2', 1800, 'my_text', 'my.company.com')" /> fmxslt:break_encode(string ) HTML & & <br/> <xsl:value-of> <xsl:text> disable-output-escaping yes disable-output-escaping="yes" fmxslt:break_encode() Enter Window return Mac OS fmxslt:html_encode(string ) HTML & & fmxslt:url_encode(string ) URL URL URL URL & %26 href URL fmxslt:url_encode(string, String ) encoding URL US-ASCII ISO ISO ISO-2022-JP Shift_JIS UTF-8 Web Web UTF-8 Shift_JIS Shift_JIS fmxslt:url_decode(string ) URL URL fmxslt:url_decode(string, String ) encoding URL US-ASCII ISO ISO ISO-2022-JP Shift_JIS UTF-8 URL Web ISO

63 5 FileMaker XSLT 63 Perl 5 fmxslt:regex_contains() Perl 5 fmxslt:regex_contains(string, String ) Perl 5 Perl 5 fmxslt:regex_contains() XSLT Perl 5 <xsl:variable name=" " select="'foo@bar.com'"/> <xsl:if test="fmxslt:regex_contains($ ,'^\w+[\w-\.]*\@\w+((-\w+) (\w*))\.[a-z]{2,3}$')">valid </xsl:if> Web FileMaker XSLT FileMaker fmxslt:contains_checkbox_value(string, String ) XPath true() false() HTML checked FileMaker [ ] Red [ ] Blue [ ] Green [ ] Small [ ] Medium [ ] Large [Red] Red Blue fmxslt:contains_checkbox_value(< >,'Blue') < > <data> XPath false

64 64 FileMaker Server Advanced Web Web Web HTML XSLT color_size style <xsl:variable name="field-value" /> <xsl:for-each = 'color_size']/fml:value"> <input type="checkbox"> <xsl:attribute name="name">style</xsl:attribute> <xsl:attribute name="value"><xsl:value-of select="."/></xsl:attribute> <xsl:if test="fmxslt:contains_checkbox_value($field-value,.)"> <xsl:attribute name="checked">checked</xsl:attribute> </xsl:if> </input><xsl:value-of select="."/><br/> </xsl:for-each> HTML XSLT [Red] [Medium] Web [x] Red [ ] Blue [ ] Green [ ] Small [x] Medium [ ] Large fm fm MM/dd/yyyy HH:mm:ss MM/dd/yyyy HH:mm:ss JavaScript fmxslt:get_date() fm fmxslt:get_date(string ) short longfm fmxslt:get_time() fm fmxslt:get_time(string ) short longfm fmxslt:get_day() fmxslt:get_day(string ) short long fmxslt:get_fm_date_format() fm MM/dd/yyyy fmxslt:get_short_date_format() yy/mm/dd fmxslt:get_long_date_format() yyyy/mm/dd fmxslt:get_fm_time_format() fmhh:mm:ss

65 5 FileMaker XSLT 65 fmxslt:get_short_time_format() h:mm a fmxslt:get_long_time_format() h:mm:ss a z fmxslt:get_short_day_format() EEE fmxslt:get_long_day_format() EEEE fmxslt:compare_date(string, String ) fm fmxslt:compare_time(string, String ) fm fmxslt:compare_day(string, String ) fmxslt:get_datetime(string ) fmxslt:convert_datetime(string, String, String ) fmxslt:compare_datetime(string, String, String, String ) A Z a z A Z a z G y 1996; 96 M 7 ; 7; 07 w 27 W 2 D 189 d 10

66 66 FileMaker Server Advanced Web F 2 E ; a AM/PM H 23 0 k K AM/PM 11 0 h AM/PM m 30 s 55 S 978 z ; PST Z RFC : 1 : 1 : yyyy/mm/dd 12/01/ y yy yy/mm/dd /01/ /05/ : -1 3/01/02 003/01/02-3/01/02 1 : 1 : GMT 1 GMT : GMT : 1 : : 1 : 1 : Unicode Basic Latin RFC 822

67 5 FileMaker XSLT 67 1 RFC 822 : RFC RFC822 : 1 : :08:56 "yyyy.mm.dd G 'at' HH:mm:ss z" at 12:08:56 PDT "EEE, MMM d, ' 'yy", 7 4, '01 "h:mm a" "hh 'o' 'clock' a, zzzz" "K:mm a, z" "yyyyy.mmmmm.dd GGG hh:mm aaa" 12:08 12 o'clock, 0:08, PDT :08 "EEE, d MMM yyyy HH:mm:ss Z", :08: "yymmddhhmmssz" Copyright 2003 Sun Microsystems, Inc. XSLT FileMaker XSLT fmxslt:check_error_status() fmxslt:check_error_status() Web 96 FileMaker XSLT XSLT <xsl:message> Web 72 Web Web XSLT JavaScript XSLT FileMaker Server 8 Advanced Java 1 bsf.jar - XSLT 1 js.jsr - Mozilla JavaScript XSLT XSLT XPath XSLT Apache Xalan Extensions Web

68 68 FileMaker Server Advanced Web 1. xalan XSLT fmp-ex <xsl:stylesheet version="1.0" xmlns:xsl= xmlns:xalan= xmlns:fmp-ex="ext1" exclude-result-prefixes="xsl xalan fmp-ex"> 2. <xalan:component prefix="fmp-ex" functions="getvaluecolor"> <xalan:script lang="javascript"> function getvaluecolor(value) { if (value > 0) return ("#009900"); else return ("#CC0000"); } </xalan:script> </xalan:component> "#009900" "#CC0000" <xalan:component> <xsl:stylesheet> 3. XPath "#009900" <font color="{fmp-ex:getvaluecolor(50)}">the value is 50</font> "#CC0000" <font color="{fmp-ex:getvaluecolor(-500)}">the value is -500</font> JavaScript <xsl:choose> XSLT XPath XML Yahoo CSVXPath document() XML CSV XML JavaScript CSV CSV URL <ticker>

69 5 FileMaker XSLT ,31.17,32.12 Yahoo JavaScript XSLT XPath <?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet exclude-result-prefixes="xsl fmxslt fmrs xalan fmp-ex" version="1.0" xmlns:xsl=" xmlns:fmrs=" xmlns:fmxslt="xalan://com.fmi.xslt.extensionfunctions" xmlns:xalan=" xmlns:fmp-ex="ext1" > <?xslt-cwp-query params="-grammar=fmresultset&-process"?> <xsl:output method="html"/> <xalan:component prefix="fmp-ex" functions="include get_quote" > <xalan:script lang="javascript"> function include(url) { var dest = new java.net.url(url); var dis = new java.io.datainputstream(dest.openstream()); var res = ""; while ((line = dis.readline())!= null) { res += line + java.lang.system.getproperty("line.separator"); } dis.close(); return res; } function get_quote(ticker) { url = " "+ticker+"&f=l1gh&e=.csv"; csv_file = include(url); var str_tokenizer = new java.util.stringtokenizer(csv_file, ','); // the first token is the last trade price var last = str_tokenizer.nexttoken(); return last; } </xalan:script> </xalan:component>

70 70 FileMaker Server Advanced Web <xsl:template match="/fmrs:fmresultset"> <html> <body> <font size="2" face="verdana, arial"> Apple Stock Price:<xsl:value-of select="fmp-ex:get_quote('aapl')"/> </font> </body> </html> </xsl:template> </xsl:stylesheet> Web Yahoo get_quote()

71 6 Web Web Web Web 13 FileMaker Web 1 Web Web Web FileMaker Server URL Web URL 23 XML URL 48 FileMaker XSLT URL XML XML XSLT 1 XML Web XML <?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet version="1.0" xmlns:xsl=" xmlns:fmrs=" <xsl:output method="xml"/> <xsl:template match="/"> <xsl:copy-of select="."/> </xsl:template> </xsl:stylesheet> 1 HTML <textarea> XML XSLT XML <?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet version="1.0" xmlns:xsl=" xmlns:fmrs=" <xsl:output method="html"/>

72 72 FileMaker Server Advanced Web <html> <body> <xsl:template match="/fmrs:fmresultset"> <textarea rows="20" cols="100"> <xsl:copy-of select="."/> </textarea><br/> </xsl:template> </body> </html> </xsl:stylesheet> Web Web 1 Web 1 Web 1 Web 1 Web Web Apache Web Apache W3C Common Logfile Format Web HTTP Apache HTTP Apache Web Microsoft IIS Web Windows W3C Extended Log File Format Web HTTP W3C Common Logfile Format Microsoft IIS Web W3C Common Logfile Format W3C Extended Log File Format World Wide Web Consortium Web Web Web Web 1 Web Web 1 Web Web 1 XSLT XSLT <xsl:message> Web XSLT <xsl:message> 5 FileMaker XSLT pe_application_log.txt Web FileMaker Server Web Publishing Logs

73 6 73 pe_application_log.txt Web [ :] 1 [ :] 1 [ :] 1 [ :] [ :] FileMaker Server Web Web Web Web Web web_server_module_log.txt Web FileMaker Server Web Publishing Logs Web Web Web Web 1 wpc_access_log.txtxml FileMaker Server Web Web Web 1 pe_internal_access_log.txtxslt Web XSLT-CWP XML Web XSLT-CWP Web Web FileMaker Server Web Publishing Logs Web [:] [ ] [:] FileMaker Server Web

74 74 FileMaker Server Advanced Web

75 A Web FileMaker -dbnames 79 -delete 79 -dup 79 -edit 79 -find -findall -findany 79 -layoutnames 80 -new 80 -process XSLT 80 -scriptnames 80 -view 81 -db 81 -encoding XSLT 81 -field op 82 -grammar XSLT 83 -lay 83 -lay.response 83 -lop 83 -max 84 -modid 84 -recid 84 -script 84 -script.param 84 -script.prefind 85 -script.prefind.param 85 -script.presort 85 -script.presort.param 86 -skip 86 -sortfield.[1-9] 86 -sortorder.[1-9] 86 -stylehref 87 -styletype 87 -token.[] XSLT 88 -dbnames -layoutnames -scriptnames -process XSLT -lay -dbopen -dbclose -img Web[] Web[] URL 24 XML FileMaker URL 48 XSLT FileMaker URL

76 76 FileMaker Server Advanced Web -password -format -fmtfield -error -errnum -errfmtfield -mailto -mailfrom -mailhost -mailformat -mailcc -mailbcc -mailsub -dbopen Web HTTP 17 Web Web CDML XML CDML C CDML FileMaker XSLT CDML Web B Web 102 CDML -error -errornum Web FileMaker XSLT 59 Web 1 -new -new -edit 1 -dbnames -process -db 32 FileMaker XML 1 -db=employees -findall = 1 -delete -lay 1 MyLayout -lay=mylayout XSLT <xsl:value-of select="fmrs:field[@name='lastname']"/> LastName LastName 1 text.fieldhttp XML XSLT ID 1 -find Field1=Blue Field1=blue -new -edit LastName=Doe

77 A 77 FileMaker FileMaker Server Web Publishing CD FileMaker Query Strings Reference.fp7 FileMaker FileMaker FileMaker Server Web Publishing CD Custom Web Publishing Reference ::( ). ID 1 1 ( ) (2) -new -edit -find 1 ID ID ID -new -edit -find -new 1 1 ID 1 1 URL Employees John Doe Jane Dependents NamesID ID ::Names.0=Jane&-new

78 78 FileMaker Server Advanced Web -edit ID ID ID XML <relatedset> <record> record-id 26 fmresultset URL ID 1001 Dependents Names Names.22 ID &Dependents::Names.2=Kevin&-edit &Dependents::Names.2=Kevin&Dependents::Names.5=Susan&-edit -edit ID &Dependents::Names.0=Timothy&-edit ::( ).global.global ( ) 77 FileMaker Pro.global Web XML XSLT XSLT.global Web -edit -recid XSLT Web [XSLT :] FileMaker Server Advanced Web XML XSLT XSLT -grammar

79 A 79 -dbnames FileMaker Server XML XSLT Web : : : -delete -recid : db, lay, recid : script : : -dup -recid : -db -lay -recid : -script : : dup -edit / -recid -recid : -db -lay -recid : -modid -script 78 : : -find -findall -findany : -db -lay : -recid -lop -op -max -skip -sortorder -sortfield -script -script.prefind -script.presort :

80 80 FileMaker Server Advanced Web 1 FileMaker Server ID : find -findall -findany -layoutnames FileMaker Server XML XSLT Web : -db : : -new / : -db -lay : -script 77 : : -process XSLT XSLT XSLT : -grammar fmresultset FMPXMLRESULT : 53 FileMaker Server XSLT -scriptnames FileMaker Server XML XSLT Web : -db : :

81 A 81 -view FMPXMLLAYOUT FMPXMLLAYOUT fmresultset FMPXMLRESULT XML metadata : -db -lay : -script : : XML XSLT XSLT 49 FileMaker XSLT -db : -db -db : -dbnames -process : -encoding XSLT XSLT XSLT Web : US-ASCII ISO ISO ISO-2022-JP Shift_JIS UTF-8 : XSLT : &-grammar=fmresultset&-encoding=shift_jis&-findall 51 -field : 24 XML FileMaker URL 48 XSLT FileMaker URL

82 82 FileMaker Server Advanced Web -find / - : FileMaker text.fieldhttp XML XSLT ID 77 : -new -edit -find fm fmmm/dd/yyyy HH:mm:ss MM/dd/yyyy HH:mm:ss : -edit : -new -find : &-max=1&-find 1 FileMaker Server.op -find : begins with eq cn bw ew gt gte lt lte neq FileMaker Pro = * * * * > >= < <=, : -find : ::= & ::.op= 1 1 cn

83 A 83 : bw FileMaker Pro... bw... : &-find FileMaker Pro -grammar XSLT XSLT XSLT Web : fmresultset FMPXMLRESULT FMPXMLLAYOUT : XSLT : &-lay=mylayout&-findall 49 FileMaker XSLT XML -lay : : -dbnames -layoutnames -scriptnames -process XSLT : db=employees& lay=departments& view -lay.response -lay XML - lay.response -lay.response -lay -lay.response XML XSLT : : -dbnames -layoutnames -scriptnames -process XSLT : &-lay.response=execlist -lop -find and or : and or -lop -find and

84 84 FileMaker Server Advanced Web : -find : &Birthdate=2/5/1972&-lop=and&-find -max : all all -max : -find -findall : -modid ID ID -edit ID ID ID -edit : ID ID FileMaker ID : -edit : -recid : &last_name=jones&-edit -recid ID -edit -delete : ID ID FileMaker : -edit -delete -dup : -find : -script FileMaker 34 XML : : -dbnames -layoutnames -process -scriptnames : findall -script.param -script FileMaker : 1

85 A 85 1 param1 param2 param3 URL param1%7cparam2%7cparam3 1 GetAsNumber(Get( )) 1 -script -script.param -script.param 1 script.param Web : script : &-script.param=smith%7cchatterjee%7csu&-findall -script.prefind -find FileMaker : : -dbnames -layoutnames -process -scriptnames : -script.prefind.param script.prefind FileMaker : 1 1 param1 param2 param3 URL param1%7cparam2%7cparam3 1 GetAsNumber(Get( )) 1 -script.prefind -script.prefind.param -script.prefind.param 1 -script.prefind.param Web : -script.prefind : &-script.prefind.param=payroll&-findall -script.presort -find FileMaker : -dbnames -layoutnames -process -scriptnames : &-sortfield.1=dept&-sortfield.2=rating&-findall

86 86 FileMaker Server Advanced Web -script.presort.param -script.presort FileMaker : 1 1 param1 param2 param3 URL param1%7cparam2%7cparam3 1 GetAsNumber(Get( )) 1 -script.presort -script.presort.param -script.presort.param 1 -script.presort.param Web : -script.presort : & script.presort.param=18%7c65&-sortfield.1=dept&-sortfield.2=rating&-findall -skip : 0 : -find : findall -sortfield : : -find -findall -sortfield -sortfield.= -sortfield. dept rating-sortorder : &-sortfield.2=rating&-findall -sortorder : < > Custom

87 A 87 ascend descend < > FileMaker Pro a z z a : -find -findall : -sortfield -sortorder -sortfield -sortorder.= 1 -sortorder.-sortorder -sortfield 1 ascend dept ascend rating descend -sortorder.2 -sortorder.2=descend -sortfield.2=rating : &-sortorder.1=ascend&-sortfield.2=rating&-sortorder.2=descend&-findall -sortorder -stylehref href XML CSS Cascading Style Sheet XSLT XML href href=/mystylesheet.css href=/stylesheets/mystylesheet.xsl -stylehref.css.xsl 35 -styletype : : -styletype mystylesheet.xsl Web : &-stylehref=/mystylesheet.xsl&-findall -styletype XML CSS Cascading Style Sheet XSLT XML type type=text/css type=text/ xsl 35 -stylehref : : -stylehref mystylesheet.css Web : &-stylehref=/mystylesheet.css&-findall

88 88 FileMaker Server Advanced Web -token.[] XSLT Cookie XSLT XSLT Web -token.[] : a z A Z : URL : XSLT : &-grammar=fmresultset&-token.d100=active&-findall 53

89 B Web Web Web 1 : XML Web FileMaker 1 Web : Web Web 94 Web 1 FileMaker XSLT : XSLT fmxslt:check_error_status() 96 FileMaker XSLT FileMaker XML Web XML fmresultset <error code> FMPXMLRESULT FMPDSORESULT <ERRORCODE> fmresultset <?xml version="1.0" encoding="utf-8" standalone="no"?> <!DOCTYPE fmresultset PUBLIC "-//FMI//DTD fmresultset//en" "/fmi/xml/fmresultset.dtd"> <fmresultset xmlns=" version="1.0"> <error code="0"></error> FMPXMLRESULT <?xml version="1.0" encoding="utf-8" standalone="no"?> <!DOCTYPE FMPXMLRESULT PUBLIC "-//FMI//DTD FMPXMLRESULT//EN" "/fmi/xml/fmpxmlresult.dtd"> <fmpxmlresult xmlns=" <ERRORCODE>0</ERRORCODE> <error code> <ERRORCODE> Web Web [ ] 6 7

90 90 FileMaker Server Advanced Web UTF A Z a z 0 9 ASCII

91 B Web ID FileMaker Pro ) FileMaker Pro

92 92 FileMaker Server Advanced Web EPSF QuickTime 710 QuickTime Excel 716 ODBC DELETE INSERT UPDATE SQL 717 XML/XSLT 718 Xerces XML 719 Xalan XSL XML Excel Excel 7.0 Excel 95 Excel XP FileMaker Pro 807 FileMaker Pro 808

93 B Web / 810 / 811 FileMaker Pro FMI FileMaker FileMaker Server XML ( 1205 */ ( 1209

94 94 FileMaker Server Advanced Web * 1213 Let 1214 AVERAGE COUNT EXTEND GETREPETITION MAX MIN NPV STDEV SUM GETSUMMARY 1215 Get 1216 GetSummary ODBC ODBC ODBC FileMaker Server ODBC FileMaker Server Web Publishing CD FileMaker ODBC JDBC 1401 ODBC 1402 ODBC 1403 ODBC 1404 ODBC 1405 ODBC 1406 SQL API ODBC 1407 ODBC 1408 ODBC Web Web Web Web 1 <xsl:include> 1 XML 1 XSLT XPath 1 CGI XML 1 Web XML

95 B Web 95 Web Web Web QUERY-ER0001 -grammar XML QUERY-ER0002 xxx FileMaker XSLT XML FILE-ER0001 FILE-ER0002 UNKNOWN MCS-000 MCS-600 MCS-601 MCS-602 MCS-603 MCS-604 MCS-605 MCS-606 MCS-607 MCS-700 MCS-800 x x URL x x HTTP x x content-type x XML x x Web Web pe_server_error.html FileMaker Web XSLT pe_server_error.html pe_server_error.html pe_server_error.html Web publishing-engine cwpe Web FileMaker Server Advanced Web