FileMaker Server 11 Web with XML and XSLT
2007 2010 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento FileMaker, Inc. Bento FileMaker, Inc. FileMaker FileMaker, Inc. FileMaker E URL E URL Acknowledgements URL www.filemaker.co.jp 01
9 1 Web Web 12 Web 12 Web with PHP 13 Web with XML and XSLT 13 PHP XML XSLT 14 PHP 14 XML XSLT 14 2 Web with XML and XSLT Web Web 15 Web with XML 15 Web with XSLT 15 XSLT 16 Web with XML and XSLT 16 Web 17 Web 17 Web Web 17 17 17 3 Web Web 19 19 20 Web MIME ) 20 Web 20 21 21 Web 21 FileMaker Web 21 22 Web 23 Web 23
4 FileMaker Server Web with XML and XSLT 4 Web with XSLT FileMaker XSLT 25 FileMaker XSLT 25 Web with XSLT 25 Web XML XSLT 26 Web with XSLT 26 FileMaker XSLT Site Assistant FileMaker XSLT 27 XSLT Site Assistant 28 XSLT Site Assistant 28 XSLT Site Assistant 28 XSLT Site Assistant 29 Web FileMaker XSLT 29 XSLT 30 5 Web XML Web with XML 31 Web FileMaker Pro XML / 31 Web XML 32 Web XML 32 XML URL 33 XML URL 33 XML FileMaker URL 34 URL 34 Web XML 35 FileMaker XML 35 FileMaker 35 FileMaker 36 fmsresultset 36 fmresultset 36 fmresultset XML 38 FileMaker XML 38 FMPXMLRESULT 39 FMPXMLRESULT XML 40 FMPXMLLAYOUT 40 FMPXMLLAYOUT XML 42 UTF-8 43 FileMaker XML 43 XML 45
5 XML 45 46 XML 46 6 FileMaker XSLT Web XSLT 47 FileMaker XSLT 48 FileMaker XSLT Starter Solution 48 FileMaker XSLT URL 48 XSLT FileMaker URL 49 FileMaker XSLT 50 FileMaker XSLT XML 50 FileMaker XSLT 50 51 52 52 XSLT 53 FileMaker Server XSLT 53 53 FileMaker XSLT 54 Web FileMaker XSLT 54 54 55 Web URI 55 URI 55 56 57 57 Web 58 58 Web 60 61 Cookie 62 63 Perl 5 63 64 65 68 68 68 69 69
6 FileMaker Server Web with XML and XSLT 7 Web 73 Web 74 XML 75 75 Web 75 Web 76 Web 76 Web 76 A 77 77 FileMaker 78 78 79 80 81 -dbnames 81 -delete 81 -dup 81 -edit 81 -find -findall -findany 81 -findquery 82 -layoutnames 82 -new 82 -process XSLT 83 -scriptnames 83 -view 83
7 83 -db 83 -delete.related 83 -encoding XSLT 84 -field 84 84.op 85 -grammar XSLT 85 -lay 85 -lay.response 86 -lop 86 -max 86 -modid ID 86 -query 87 -recid ID 87 -relatedsets.filter 88 -relatedsets.max 88 -script 88 -script.param 88 -script.prefind 89 -script.prefind.param 89 -script.presort 89 -script.presort.param 89 -skip 90 -sortfield 90 -sortorder 90 -stylehref href 91 -styletype 91 -token. [ ] XSLT 91 B Web FileMaker 93 Web 99 FileMaker XSLT 101 103
8 FileMaker Server Web with XML and XSLT
XML XSLT Web FileMaker Pro FileMaker Server Web with XML and XSLT 1 XML XSLT Web 1 XML XSLT 1 Web Web 1 FileMaker Server XML 1 FileMaker XSLT FileMaker www.filemaker.co.jp Web FileMaker Server FileMaker Server Web Web with PHP PHP Site Assistant Web with XML and XSLT XSLT Site Assistant ODBC JDBC ODBC JDBC FileMaker Server FileMaker Server FileMaker Web FileMaker Server Web with PHP PHP Site Assistant FileMaker Server Web with XML and XSLT XSLT Site Assistant FileMaker ODBC JDBC FileMaker Server Auto Update FileMaker Pro FileMaker Server
10 FileMaker Server Web with XML and XSLT
1 Web FileMaker Server FileMaker Web Web Web Web Web Web Web FileMaker Pro FileMaker Server FileMaker Pro Web Web FileMaker Pro FileMaker Web FileMaker Pro Web FileMaker Pro Web Web HTML Web Web Web Web FileMaker Server Web FileMaker Web Web FileMaker Server Web Web FileMaker Server Web FileMaker Pro Web 1 Web 1 1 Web FileMaker Server Web 1 Web with PHP FileMaker Pro PHP PHP FileMaker API FileMaker PHP Web PHP Site Assistant PHP Web PHP Web 1 Web with XML and XSLT 1 XML FileMaker Web 1 XSLT FileMaker Web XSLT Site Assistant XSLT
12 FileMaker Server Web with XML and XSLT Web Web Web FileMaker Server FileMaker Server Web Web Web Web FileMaker Server Web with XML and XSLT Web XSLT HTML XML vcard Web Web Web Web Web Web HREF Web FileMaker URL Uniform Resource Locator URL XML XSLT Web XML XSLT Web with PHP Web Web FileMaker Server PHP Web FileMaker API for PHP Web FileMaker Server Web 1 2 3.fp7.fp7 Web Web Web Web FM API PHP XSLT 6 5 4 Web 1. Web Web 2. Web FileMaker Web Web 3. Web 4. FileMaker Server FileMaker Web 5. Web FileMaker 1 PHP Web API 1 XML Web Web XML 1 XSLT Web XSLT XML Web HTML XML 6. Web Web Web FileMaker PDF www.filemaker.co.jp
1 Web 13 Web with PHP FileMaker API for PHP FileMaker PHP FileMaker API for PHP FileMaker Pro Web API FileMaker Pro PHP Web PHP PHP FileMaker PHP Site Assistant FileMaker Pro PHP PHP Site Assistant Web Web PHP FileMaker PHP Site Assistant PHP Web FileMaker PHP PHP Site Assistant FileMaker API for PHP Web with XML and XSLT XML FileMaker Web FileMaker Server FileMaker Pro HTTP FileMaker XML XML XML XSLT XSLT FileMaker Web Web XML 1 XSLT FileMaker XML XML 1 1 Web Web Web XSLT HTTP URL Web FileMaker Web XML Web HTML FileMaker XSLT Site Assistant Web XSLT XSLT XSLT Site Assistant
14 FileMaker Server Web with XML and XSLT PHP XML XSLT PHP 1 PHP 1 FileMaker API for PHP FileMaker Pro Web 1 PHP 1 PHP 1 PHP Web 1 PHP http://php.net 1 PHP Web with PHP FileMaker Server Web with PHP XML XSLT 1 FileMaker XML 1 XML XSLT W3C 1 XML Unicode 1 XML 1 XSLT XML RSS RTF vcard 1 XSLT XML 1 1 Web FileMaker Pro XML FMPXMLRESULT 1 FileMaker Server FileMaker XSLT XSLT
2 Web with XML and XSLT 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 FileMaker Server Web XML Web XSLT Web FileMaker Web XML Web XSLT Web Web 1 XSLT 1 XSLT 1 Web XML XSLT URL Web with XML Web with XML Web with XML FileMaker HTTP FileMaker XML XML XML XSLT 5 Web XML Web with XSLT Web with XSLT XML Web XSLT FileMaker XML XML Web Web 4 Web with XSLT Web XSLT HTTP URL Web FileMaker Web XML Web HTML XML XSLT FileMaker Server Web www.filemaker.co.jp
16 FileMaker Server Web with XML and XSLT XSLT FileMaker Server XSLT FileMaker XSLT Site Assistant XSLT FileMaker Web XSLT XSLT Site Assistant FileMaker XSLT XSLT 27 FileMaker XSLT Site Assistant FileMaker XSLT FileMaker Server World Wide Web Consortium XSLT 1.0 XSLT XSLT 1.0 Web with XML and XSLT XML XSLT FileMaker Server Web 1 FileMaker Server FileMaker Pro 1 XSLT 1 XSLT JavaScript 68 1 FileMaker XSLT XML 51 1 FileMaker Pro Web 20 1 Web FileMaker 75 Web 21 FileMaker Web 1 FileMaker 88 -script.param 89 -script.prefind.param 89 -script.presort.param 1 fmresultset XML relatedset 1 XSLT Web 1 A 1 Web FileMaker Pro Web 80
2 Web with XML and XSLT 17 Web Web Web with XML and XSLT 1 FileMaker Server 1 Microsoft IIS Windows Apache Mac OS X Web 1 Web FileMaker 1 Web 1 FileMaker Server FileMaker Pro 1 Web IP 1 Web Web Web FileMaker Server Web Web Web Web with XML and XSLT 1 Web 1 Web 1 Web IP FileMaker Server 1 Web Web 1 FileMaker Server Web IP ISP IP IP IP ISP Web 1 FileMaker Server Admin Console Web FileMaker Server FileMaker Server 1 FileMaker FileMaker Pro Web 19 Web 1 XML FileMaker 5 Web XML 1 FileMaker XSLT 4 Web with XSLT
18 FileMaker Server Web with XML and XSLT
3 Web Web Web Web Web with XML Web with XSLT Web FileMaker Server Web Web Web 1. FileMaker Pro [ ] [ ] 2. 1 Web with XML fmxml 1 Web with XSLT fmxslt FileMaker Pro 8 fmxml fmxslt [ ] 3. Admin Web Web ASCII a z A Z 0 9! % FileMaker Pro Web Web Web Web HTTP Web Web Web HTTP Web Web 1 Web 1 Web
20 FileMaker Server Web with XML and XSLT 1 Web Web Web 1 1 Web [ ] Web 1 FileMaker Pro Web Web [ ] Web FileMaker Pro Web with XML and XSLT 1 Web 1 Web with XML and XSLT 1 Web 1 Web FileMaker Server Admin Console Web Web FileMaker Server 1 Web IP Web 192.168.100.101 IP Web IP Web 1 Web Web SSL Secure Sockets Layer SSL SSL Web FileMaker PDF www.filemaker.co.jp Web MIME ) MIME Multipurpose Internet Mail Extensions Web Web Web MIME Web Web FileMaker Web Web
3 Web 21 FileMaker FileMaker Server 34 XML FileMaker URL 49 XSLT FileMaker URL QuickTime 1. FileMaker ProWeb 2. FileMaker Pro [ ] 3. WebWeb 1 IIS < >: Inetpub wwwroot 1 Apache / /WebServer/Documents MIME Web Web Web Web Web Web 1 OLE 1 Web Web 1 GIF JPEG Web Web JPEG FileMaker Web FileMaker Pro Web Web FileMaker FileMaker 75 Web URL XSLT <?xslt cwp query?> Web FileMaker Pro [ ] [ ] [Web ] Web FileMaker Pro
22 FileMaker Server Web with XML and XSLT Web 23 Web Web Web pe_application_log.txt76 Web 1 Web Web Web 1 Web [ ] 1 [ ] [ ] 1 Web [ ] 1 [ ] 1 [ ] 1 1 FileMaker Pro [ / ] Web Web 1 [ / ] [ ] [ ] [ ] [ / ] Web [ / ] 1 Get( ) Web Publishing Engine Web FileMaker Pro 1 XSLT FileMaker Server Admin Console Web XSLT FileMaker Server
3 Web 23 Web Web FileMaker Pro FileMaker Pro / URL / Web FileMaker Server Web Web Web 22 Web Web Web Web Web Web Web [ ] Web [ ] Web [ / ] Web FileMaker Pro ( ) Web Web OnObjectEnter OnObjectEnter FileMaker Pro
24 FileMaker Server Web with XML and XSLT
4 Web with XSLT FileMaker XSLT XML Web FileMaker XSLT XSLT FileMaker XSLT Site Assistant FileMaker XSLT 6 FileMaker XSLT FileMaker XSLT FileMaker XSLT 1 1 1 Web Web 1 HTML vcard 1 FileMaker XML XML SVG Scalable Vector Graphics 1 FileMaker Web FileMaker 1 FileMaker Server Web with XSLT XSLT 1.0 W3C XSLT 1.0 www.w3.org Cookie FileMaker XSLT 54 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 Web with XSLT XML XSLT FileMaker XSLT FileMaker XML XSLT Web XSLT Site Assistant XML XSLT
26 FileMaker Server Web with XML and XSLT 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 FileMaker 2. Web XSLT-CWP CWPE CWPE Web.fp7.fp7 Web FileMaker XSLT-CWP.fp7.fp7 Web XSLT Web FileMaker Server Web 5. FileMaker Web 8. Web Web Web Web 6. Web XML CWPE Web 7. CWPE XSLT XML HTML XML Web CWPE Web Web with XSLT XSLT Web 1. Admin Cosole XSLT FileMaker Server 2. FileMaker FileMaker Pro Web with XSLT fmxslt 19 Web FileMaker FileMaker
4 Web with XSLT 27 3. FileMaker XML FileMaker XSLT XSLT FileMaker XSLT Site Assistant XSLT FileMaker XSLT Site Assistant FileMaker XSLT XSLT XSLT 6 FileMaker XSLT 4. XSLT xslt-template-files xslt-template-files Web FileMaker Server Web Publishing xslt-template-files 5. Web 29 Web FileMaker XSLT 6. XSLT Web Web XSLT XSLT index.html Web 7. 8. Web XSLT 9. FileMaker XSLT Site Assistant FileMaker XSLT FileMaker XSLT Site Assistant XSLT FileMaker Web XSLT XSLT Site Assistant FileMaker XSLT XSLT XSLT Site Assistant Site Assistant Web FileMaker XSLT XSLT Site Assistant 1 1 1 1 1 1 1 1 XSLT
28 FileMaker Server Web with XML and XSLT Web XSLT HTTP URL Web FileMaker Web XML Web HTML XSLT Site Assistant fmresultset XML FileMaker XML HTML FileMaker XML XML XSLT Site Assistant XSLT Site Assistant XSLT 1 fmxslt XSLT Site Assistant Web 19 Web 1 FileMaker Server FileMaker Server 1 FileMaker Server Web 1 FileMaker Server Web 1 XSLT Web XSLT FileMaker Server XSLT Site Assistant XSLT Site Assistant Java Runtime Environment 5 Java Runtime Environment 6 XSLT Site Assistant 1. [FileMaker Server Web ] URL http://< >:16000/tools < > FileMaker Server 2. [PHP Site Assistant XSLT Site Assistant ] [FileMaker Server Web ] 3. [XSLT Site Assistant ] FileMaker Server JAR 4. XSLT Site Assistant [OK] XSLT Site Assistant XSLT Site Assistant XSLT Site Assistant XSLT Site Assistant XSLT Site Assistant 29 Web FileMaker XSLT XSLT Site Assistant
4 Web with XSLT 29 XSLT Site Assistant XSLT Site Assistant XSLT FileMaker 1 <?xslt-cwp-query params="query string-fragment"?> XML XSLT Site Assistant 51 1 <xsl:param name="request-query"/> HTML XSLT Site Assistant 54 1 <xsl:param name="authenticated-xml-base-uri"/> XML URI 55 URI utilities.xsl XSLT Site Assistant XSLT XSLT Site Assistant 6 FileMaker XSLT Web FileMaker XSLT Web Web XSLT Site Assistant XSLT Web FileMaker XSLT 1. XSLT xslt-template-files xslt-template-files Web FileMaker Server Web Publishing 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 20 Web FileMaker FileMaker Server
30 FileMaker Server Web with XML and XSLT 4. XSLT URL < >://< >[:< >]/fmi/xsl/< >/< >.xsl[?< >] 48 FileMaker XSLT URL Web XSLT XSLT Site Assistant <?xslt-cwp-query?> home.xsl home.xslxslt-template-files my_templates URL http://192.168.123.101/fmi/xsl/my_templates/home.xsl Web Web xslt-template-files XSLT Web Web Web XSLT XSLT 1 Web with XSLT 19 Web 1 FileMaker Server FileMaker Server 1 1 FileMaker Server Web 1 FileMaker Server Web 1 Web XSLT 1 [FileMaker Server ] http://< >:16000/test < > FileMaker Server 1 [XSLT Web ] FMServer_Sample XSLT FileMaker Server FileMaker Server
5 Web XML Web FileMaker XML Extensible Markup Language HTML World Wide Web XML XML Web with XML XML URL Web with XML Web HTTP URL FileMaker FileMaker Server XML XML Web XSLT XML HTML vcard SVG Scalable Vector Graphics XML 4 Web with XSLT 6 FileMaker XSLT XML XML XML FileMaker Web www.filemaker.co.jp Web XML XML 1.0 XML www.w3.org XML Web FileMaker Pro XML / Web FileMaker Pro FileMaker XML 1 XML XSLT Web Web fmresultset FMPXMLRESULT FMPXMLLAYOUT FileMaker Pro XML FMPXMLRESULT FMPXMLRESULT FMPDSORESULT 35 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 FileMaker Pro XML FileMaker Pro
32 FileMaker Server Web with XML and XSLT Web XML XML Web Web FileMaker XML Web 1. Web Web XML HTTP HTTPS Web 2. Web Web FileMaker Server Web Web 3. Web FileMaker FileMaker Web CWPE Web.fp7.fp7 Web FileMaker XML.fp7.fp7 FileMaker Web XML Web 5. Web XML Web FileMaker Server Web 4. FileMaker Web 6. Web Web Web Web Web CWPE Web Web XML Web FileMaker XML 1. FileMaker Server Admin Console XML FileMaker Server 2. FileMaker FileMaker Pro XML Web fmxml 19 Web XML [ ] [ ] [ ] XML XML XML
5 Web XML 33 3. HTML HREF Web FileMaker XML FileMaker URL HTTP HTTPS Web Web URL URL XML URL 43 FileMaker XML A 4. Web URL XML Web 5. Web XML Web Web 46 XML URL Web FileMaker XML URL XSLT URL XML 48 FileMaker XSLT URL 49 XSLT FileMaker URL XML URL Web FileMaker XML URL < >://< >[:< >]/fmi/xml/<xml >.xml[?< >] 1 < > HTTP HTTPS 1 < > Web IP 1 < > Web HTTP 80 HTTPS 443 1 <XML > FileMaker XML fmresultset.xml FMPXMLRESULT.xml FMPXMLLAYOUT.xml FMPDSORESULT.xml 36 fmsresultset 38 FileMaker XML 1 < > FileMaker XML -dbnames 43 FileMaker XML A URL URL FMPXMLRESULT FMPXMLLAYOUT FMPDSORESULT 77 Web XML URL http://server.company.com/fmi/xml/fmresultset.xml?-db=products&-lay=sales&-findall http://192.168.123.101/fmi/xml/fmpxmlresult.xml?-db=products&-lay=sales&-findall
34 FileMaker Server Web with XML and XSLT 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 78 < >://< >[:< >]/fmi/xml/cnt/data.< >?< > < > < > < > XML URL http://www.company.com/fmi/xml/cnt/data.jpg?-db=products&-lay=sales&-field=product_image(1)&-recid=2 1 <data> <data>/images/logo.jpg</data> FileMaker Pro Web Web 20 Web 1 <data> XML XSLT 49 XSLT FileMaker URL URL XML URL UTF-8 Unicode Transformation 8 Bit 43 UTF-8 infofiancée URL http://server.company.com/fmi/xml/fmresultset.xml?-db=members&-lay=relationships&-recid=2 &info= fianc%c3%a9e&-edit URL %C3%A9 UTF-8 é URL URL www.w3.org URL
5 Web XML 35 Web XML Web XML FileMaker FileMaker FileMaker URL Web XML XML 1 fmresultset Web XSLT FileMaker XML XSLT Web FMPXMLRESULT 36 fmsresultset 1 FMPXMLRESULT FMPXMLLAYOUT:XML XSLT FMPXMLRESULT FMPXMLLAYOUT Web XML Web FMPXMLRESULT FMPXMLLAYOUT 38 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 43 UTF-8 FileMaker XML XML XML <DATABASE> FileMaker XML Oracle XML XML <DATABASE> Web fmresultset FMPXMLRESULT FMPXMLLAYOUT xmlns="http://www.filemaker.com/xml/fmresultset" xmlns="http://www.filemaker.com/ fmpxmlresult" xmlns="http://www.filemaker.com/fmpxmllayout" FileMaker Web XML 0 fmresultset FMPXMLRESULT FMPDSORESULT <error code="0"></error> <ERRORCODE>0</ERRORCODE> <ERRORCODE>0</ERRORCODE>
36 FileMaker Server Web with XML and XSLT XML XSLT B Web FileMaker FileMaker DTD HTTP fmresultset FMPXMLRESULT FMPXMLLAYOUT FMPDSORESULT HTTP http://< >[:< ]/fmi/xml/fmresultset.dtd http://< >[:< ]/fmi/xml/fmpxmlresult.dtd http://< >[:< ]/fmi/xml/fmpxmllayout.dtd http://< >[:< ]/fmi/xml/fmpdsoresult.dtd?-db=< >&-lay= < > fmsresultset XML FileMaker fmresultset Web XML URL fmresultset fmresultset.xml http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family&-findall fmresultset Web fmresultset XML XML Web <?xml...?> <!DOCTYPE> fmresultset <!DOCTYPE> fmresultset DTD URL fmresultset fmresultset <datasource> <metadata> <resultset> <datasource> fmresultset <datasource> table layout date-format time-format timestamp-format totalcount database 1 XML <datasource> date-format MM/dd/yyyy 1 MM - 01 12 01 12 12 1 dd - 00 31 1 yyyy - 1 XML <datasource> time-format HH:mm:ss
5 Web XML 37 1 HH - 24 00 23 1 mm - 00 59 1 ss - 00 59 1 <datasource> timestamp-format date-format time-format MM/dd/yyyy HH:mm:ss <metadata> fmresultset <metadata> <field-definition> <relatedset-definition> <field-definition > 1 auto-enter yes no 1 four-digit-year yes no 1 global field yes no 1 max-repeat 1 max-characters 1 not-empty yes no 1 yes no 1 text number date time timestampcontainer 1 time-of-day yes no 1 normal calculationsummary 1 <relatedset-definition> <relatedset-definition> <field-definition> <relatedset-definition> <resultset> <resultset> <record> <record> mod-id record-id <data> <relatedset> <record> <relatedset> count table
38 FileMaker Server Web with XML and XSLT fmresultset XML fmresultset XML <?xml version="1.0" encoding="utf-8" standalone="no"?> <!DOCTYPE fmresultset PUBLIC "-//FMI//DTD fmresultset//en" ""http://localhost:16014/fmi/xml/fmresultset.dtd"> <fmresultset xmlns="http://www.filemaker.com/xml/fmresultset" version="1.0"> <error code="0" /> <product build="12/31/2012" name="filemaker Web Publishing Engine" version="0.0.0.0" /> <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="12" /> <metadata> <field-definition auto-enter="no" four-digit-year="no" global="no" max-repeat="1" name="title" not-empty="no" numeric-only="no" result="text" timeof-day="no" type="normal" /> <field-definition auto-enter="no" four-digit-year="no" global="no" max-repeat="1" name="artist" not-empty="no" numeric-only="no" result="text" timeof-day="no" type="normal" /> <relatedset-definition table="artlocations"> <field-definition auto-enter="no" four-digit-year="no" global="no" max-repeat="1" name="artlocations::location" not-empty="no" numeric-only="no" result="text" time-of-day="no" type="normal" /> <field-definition auto-enter="no" four-digit-year="no" global="no" max-repeat="1" name="artlocations::date" not-empty="no" numeric-only="no" result="date" time-of-day="no" type="normal" /> </relatedset-definition> <field-definition auto-enter="no" four-digit-year="no" global="no" max-repeat="1" name="style" not-empty="no" numeric-only="no" result="text" timeof-day="no" type="normal" /> <field-definition auto-enter="no" four-digit-year="no" global="no" max-repeat="1" name="length" not-empty="no" numeric-only="no" result="number" time-of-day="no" type="calculation" /> </metadata> <resultset count="1" fetch-size="1"> <record mod-id="6" record-id="14"> <field name="title"> <data>spring in Giverny 3</data> </field> <field name="artist"> <data>claude Monet</data> </field> <relatedset count="0" table="artlocations" /> <field name="style"> <data /> </field> <field name="length"> <data>19</data> </field> </record> </resultset> </fmresultset> FileMaker XML FileMaker XML FMPXMLRESULT fmresultset FMPXMLLAYOUT FMPXMLRESULT FMPXMLLAYOUT FMPXMLRESULT Web XML URL FMPXMLRESULT.xml
5 Web XML 39 http://192.168.123.101/fmi/xml/fmpxmlresult.xml?-db=employees&-lay=family&-findall FMPXMLLAYOUT Web XML URL -view FMPXMLLAYOUT.xml http://192.168.123.101/fmi/xml/fmpxmllayout.xml?-db=employees&-lay=family&-view FMPXMLRESULT FMPXMLLAYOUT XML Web <?xml...?> <!DOCTYPE> <!DOCTYPE> DTD URL FMPXMLRESULT FMPXMLRESULT <DATABASE> NAME RECORDS DATEFORMAT TIMEFORMAT XML <DATABASE> DATEFORMAT XML <DATABASE> TIMEFORMAT FMPXMLRESULT fmresultset 36 fmresultset FMPXMLRESULT <METADATA> FIELD <FIELD> / Yes / No EMPTYOK MAXREPEAT TEXT NUMBER DATE TIME CONTAINER <RESULTSET> <ROW> <ROW> / RECORDID MODID 86 -modid ID <COL> <COL> / <DATA>
40 FileMaker Server Web with XML and XSLT FMPXMLRESULT XML FMPXMLRESULT XML <?xml version="1.0" encoding="utf-8" standalone="no"?> <!DOCTYPE FMPXMLRESULT PUBLIC "-//FMI//DTD FMPXMLRESULT//EN" ""http://localhost:16014/fmi/xml/fmpxmlresult.dtd"> <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"> <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="12/31/2012" NAME="FileMaker Web Publishing Engine" VERSION="0.0.0.0" /> <DATABASE DATEFORMAT="MM/dd/yyyy" LAYOUT="web" NAME="art" RECORDS="12" 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="Image" TYPE="CONTAINER" /> </METADATA> <RESULTSET FOUND="1"> <ROW MODID="6" RECORDID="15"> <COL> <DATA>Spring in Giverny 4</DATA> </COL> <COL> <DATA>Claude Monet</DATA> </COL> <COL> <DATA>/fmi/xml/cnt/data.jpg?-db=art&-lay=web&-recid=15&-field=Image(1)</DATA> </COL> </ROW> </RESULTSET> </FMPXMLRESULT> <COL> <METADATA> <FIELD> <METADATA> Title ArtistVillage Market Camille Pissarro <RESULTSET> <ROW> FMPXMLLAYOUT FMPXMLLAYOUT <FIELD> <LAYOUT> <FIELD> VALUELIST <VALUELISTS> <VALUELIST> <VALUE> FileMaker [ ] <VALUE> DISPLAY ID ("100" ) ("Impressionism" ) [ ] DISPLAY
5 Web XML 41 1 [ ] DISPLAY XML DISPLAY ID <VALUELISTS> <VALUELIST NAME="style"> <VALUE DISPLAY="100">100</VALUE> <VALUE DISPLAY="101">101</VALUE> <VALUE DISPLAY="102">102</VALUE> </VALUELIST> </VALUELISTS> 1 [ ] [ ] DISPLAY XML DISPLAY <VALUELISTS> <VALUELIST NAME="style"> <VALUE DISPLAY="Impressionism">100</VALUE> <VALUE DISPLAY="Cubism">101</VALUE> <VALUE DISPLAY="Abstract">102</VALUE> </VALUELIST> </VALUELISTS> 1 [ ] [ ] DISPLAY XML DISPLAY ID <VALUELISTS> <VALUELIST NAME="style"> <VALUE DISPLAY="100 Impressionism">100</VALUE> <VALUE DISPLAY="101 Cubism">101</VALUE> <VALUE DISPLAY="102 Abstract">102</VALUE> </VALUELIST> </VALUELISTS> fm fm MM/dd/yyyy HH:mm:ss MM/dd/yyyy HH:mm:ss 65 birthdaysbirthdatebirthdate fm
42 FileMaker Server Web with XML and XSLT FMPXMLLAYOUT XML FMPXMLLAYOUT XML <?xml version="1.0" encoding="utf-8" standalone="no"?> <!DOCTYPE FMPXMLLAYOUT PUBLIC "-//FMI//DTD FMPXMLLAYOUT//EN" ""http://localhost:16014/fmi/xml/fmpxmllayout.dtd"> <FMPXMLLAYOUT xmlns="http://www.filemaker.com/fmpxmllayout"> <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="12/31/2012" NAME="FileMaker Web Publishing Engine" VERSION="0.0.0.0" /> <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="artlocations::Location"> <STYLE TYPE="EDITTEXT" VALUELIST="" /> </FIELD> <FIELD NAME="artlocations::Date"> <STYLE TYPE="EDITTEXT" VALUELIST="" /> </FIELD> <FIELD NAME="Style"> <STYLE TYPE="POPUPMENU" VALUELIST="style" /> </FIELD> </LAYOUT> <VALUELISTS> <VALUELIST NAME="style"> <VALUE DISPLAY="Impressionism">100</VALUE> <VALUE DISPLAY="Cubism">101</VALUE> <VALUE DISPLAY="Abstract">102</VALUE> </VALUELIST> </VALUELISTS> </FMPXMLLAYOUT>
5 Web XML 43 UTF-8 Web XML UTF-8 Unicode Transformation Format 8 ASCII Unicode 16 XML Unicode UTF-8 UTF-8 ASCII 0 127 Unicode UTF-8 Web UTF-8 1 ASCII UTF-8 ASCII UTF-8 1 ASCII 1 UTF-8 1 1 UTF-8 Unicode 1 UTF-8 ASCII Unicode UTF-8 Unicode 50% FileMaker XML FileMaker XML FileMaker URL -findall products FileMaker http://192.168.123.101/fmi/xml/fmresultset.xml?-db=products-lay=sales&-findall -new -dbnames -db URL FileMaker XSLT <?xslt-cwp-query?> 6 FileMaker XSLT FileMaker A Web FileMaker XSLT -process 50 FileMaker XSLT -dbnames -delete -dup -edit -find -findall -findany -findquery -layoutnames Web Web
44 FileMaker Server Web with XML and XSLT -new -scriptnames -view Web FMPXMLLAYOUT fmresultset FMPXMLRESULT XML <metadata> -db -delete.related -field.op -lay -lay.response XML -lop -max -modid ID -query -recid ID -relatedsets.filter -relatedsets.max -script -script.param -script -script.prefind -find -findany -findall -script.prefind.param -script.prefind -script.presort -script.presort.param -script.presort -skip -sortfield.[1-9] -sortorder.[1-9] -dbnames -process XSLT -edit URL 34 XML FileMaker URL -edit -find 84 find -dbnames -layoutnames -scriptnames -process XSLT -dbnames -layoutnames -scriptnames -process XSLT -find -find -findall -edit -findquery edit delete dup find -find -edit -new -dup -findquery -find -edit -new -dup -findquery -find -findall -findany -new -edit -delete -dup -view -script -find -findany -findall -script.prefind -find -findall -script.presort -find -findall -find -findall -find -findall
5 Web XML 45 -stylehref HREF -styletype -styletype URL XML lay XML XML XML XML lay.response Budget Salary 100,000 ExecList Salary http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=budget&salary=100000&salary.op=gt&-find &-lay.response=execlist XML XML XML FileMaker Server Web XML 1. lay 2. URL.global= 3. script.prefind 4. find new 5. script.presort 6. 7. lay.response 8. script 9. XML sortfield 102
46 FileMaker Server Web with XML and XSLT Web XSLT Web XML XSLT Web 4 Web with XSLT 6 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 http://localhost/fmi/xml/fmresultset.xml?-db=products-lay=sales&-findall&-styletype=text/xsl&-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 29 Web FileMaker XSLT Web Web XML Web XML 1 XML Web 19 Web 1 FileMaker Server FileMaker Server FileMaker Server 1 1 FileMaker Server Web 1 FileMaker Server Web 1 Web XML FileMaker Server
6 FileMaker XSLT FileMaker XSLT FileMaker XSLT Web XSLT Web FileMaker XML XSLT 1 Web XSLT URL XSLT Web Web 48 FileMaker XSLT URL 1 UTF-8 Web ASCII 1 FileMaker XML URL <?xslt-cwp-query?> XML Web 50 FileMaker XSLT XML 1 FileMaker XML URL <?xslt-cwp-query?> 48 FileMaker XSLT URL 51 1 -encoding XSLT Web 52 1 <xsl:output> method Web HTML <xsl:output> encoding 52 1 fmxslt:send_email() Web 60 Web Web <?xslt-cwp-query?> <?xslt-cwp-query?> URL Web <?xslt-cwp-query?> URL Web FileMaker XML Web HTML
48 FileMaker Server Web with XML and XSLT FileMaker XSLT FileMaker XSLT XSLT Reference.fp7 FileMaker FileMaker Server Mac OS / /FileMaker Server/Example/XSLT Windows < >: Program Files FileMaker FileMaker Server Examples XSLT < > FileMaker XSLT Starter Solution XSLT FileMaker XSLT Starter Solution XSLT Starter Solution FileMaker Server Mac OS / /FileMaker Server/Example/XSLT/Starter Solution Windows < >: Program Files FileMaker FileMaker Server Examples XSLT Starter Solution < > FileMaker XSLT URL FileMaker XSLT Web URL < >://< >[:< >]/fmi/xsl/[< >/]<.xsl>[?< >] 1 < > HTTP HTTPS 1 < > Web IP 1 < > Web HTTP 80 HTTPS 443 1 < > XSLT xslt-template-files 1 <.xsl> XSLT 1 < > Web with XSLT 50 FileMaker XSLT A <?xslt-cwp-query?> URL 51 URL URL FMPXMLRESULT FMPXMLLAYOUT 77
6 FileMaker XSLT 49 FileMaker XSLT Web URL http://192.168.123.101/fmi/xsl/my_template/my_stylesheet.xsl?-grammar=fmresultset&-db=mydatabase &-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 78 < >://< >[:< >]/fmi/xml/cnt/data.< >?< > < > < > < > FileMaker XSLT URL http://www.company.com/fmi/xsl/cnt/data.jpg? db=products& lay=sales& field=product_image(1)& recid=2 1 <data> logo.jpg FileMaker ProWeb <data> <data>/images/logo.jpg</data> FileMaker Pro Web Web 20 Web 1 <data>
50 FileMaker Server Web with XML and XSLT FileMaker XSLT URL FileMaker XSLT <?xslt-cwp-query?> FileMaker XML 43 FileMaker XML FileMaker XSLT XSLT -grammar -encoding -process -token XSLT-CWP XSLT XML FileMaker XSLT XML 52 53 FileMaker Server XSLT Cookie 53 XSLT XSLT -grammar XSLT FileMaker XSLT XML Web with XSLT XML fmresultset XSLT 36 fmsresultset FMPXMLRESULT FMPXMLLAYOUT FMPXMLLAYOUT 38 FileMaker XML Web with XSLT FMPDSORESULT FileMaker XSLT URL <?xslt-cwp-query?> -grammar URL http://192.168.123.101/fmi/xsl/my_template/my_stylesheet.xsl?-grammar=fmresultset&-db=mydatabase &-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="http://www.filemaker.com/xml/fmresultset" fmrs FMPXMLRESULT xmlns:fmp="http://www.filemaker.com/fmpxmlresult" fmp FMPXMLLAYOUT xmlns:fml="http://www.filemaker.com/fmpxmllayout" fml XML xmlns:fmq="http://www.filemaker.com/xml/query" fmq FileMaker XSLT xmlns:fmxslt="xalan://com.fmi.xslt.extensionfunctions" fmxslt
6 FileMaker XSLT 51 FileMaker XSLT xmlns:xsl="http://www.w3.org/1999/xsl/transform" <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/xsl/transform" xmlns:fmrs="http://www.filemaker.com/xml/fmresultset" xmlns:fml="http://www.filemaker.com/fmpxmllayout" xmlns:fmq="http://www.filemaker.com/xml/query" xmlns:fmxslt="xalan://com.fmi.xslt.extensionfunctions" exclude-result-prefixes="xsl fmrs fmq fml fmxslt"> FileMaker XSLT XML URL XSLT Site Assistant FileMaker XSLT <?xslt-cwp-query params="query string-fragment"?> query string-fragment = & 2= 2... -db=products -findall =A URL 34 URL <xsl:output> encoding Web & my_stylesheet.xsl <?xslt-cwp-query params="-db=products&-lay=sales&-grammar=fmresultset&productname=the%20item&-find"?> my_stylesheet.xsl products sales fmresultset the%20itemproductname -find my_stylesheet.xsl http://server.company.com/fmi/xsl/my_stylesheet.xsl?-lay=revenue&city=london&-edit XML Web http://server.company.com/fmi/xml/fmresultset.xml?-db=products&-lay=sales&productname=the%20item&city= London&-find -lay=revenue -edit city citylondon Web XML
52 FileMaker Server Web with XML and XSLT Web XSLT 1. Content-Type charset 2. -encoding URL <?xslt-cwp-query?> -encoding http://192.168.123.101/fmi/xsl/template/my_stylesheet.xsl?-db=products-lay=sales&-grammar=fmresultset &-encoding=shift_jis&-findall 3. Web [ :] Web Shift_JIS Web Admin Console FileMaker Server Web Content-Type charset encoding US-ASCII ISO-8859-1 ISO-8859-15 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 Admin Console 1 fmxslt:send_email(string SMTP, String, String ) 60 Web <xsl:output> method encoding method html textxml html encoding
6 FileMaker XSLT 53 <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 FileMaker Server XSLT -process XSLT -process FileMaker Server -process 1 1 1 fmxslt:send_email() 1 -process Web XML -process -grammar fmresultset FMPXMLRESULT http://192.168.123.101/fmi/xsl/my_template/my_stylesheet.xsl?-grammar=fmresultset&-process -token URL Cookie -token URL http://192.168.123.101/fmi/xsl/template/my_stylesheet.xsl?-db=products&-lay=sales&-grammar=fmresultset &-token.d100=pending&-findall 91 -token. [ ] XSLT -token -token <xsl:param name="request-query" /> 54
54 FileMaker Server Web with XML and XSLT 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 48 FileMaker XSLT 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"> 55 55 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="http://www.filemaker.com/xml/query" XSLT <xsl:stylesheet> fmq 50 FileMaker XSLT http://192.168.123.101/fmi/xsl/my_stylesheet.xsl?-db=products&-lay=sales&-grammar=fmresultset&-token.1=abc123&-findall
6 FileMaker XSLT 55 <xsl:param name="request-query" /> Web XML <query action="my_stylesheet.xsl" xmlns="http://www.filemaker.com/xml/query"> <parameter name="-db">products</parameter> <parameter name="-lay">sales</parameter> <parameter name="-grammar">fmresultset</parameter> <parameter name="-token.1">abc123</parameter> <parameter name="-findall"></parameter> </query> XPath request-query URL $request-query/fmq:query/fmq:parameter[@name = ' 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 19 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>
56 FileMaker Server Web with XML and XSLT client-user-name client-password authenticated-xml-base-uri http://username:password@hostname:port client-user-name client-password authenticated-xml-base-uri xml-base-uri 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 http://username:password@hostname/path?querystring FileMaker XML FileMaker document() <xsl:variable name="other-data" select="document('http://server.company.com/data.xml')" /> document() URL Web XML xslt-template-files mystylesheets URL document() <xsl:variable name="mydoc" select="document('mystylesheets/mydoc.xml')" /> Web xslt-template-files mystylesheetsmydoc.xml Web Web URI HTTP HTTP HTTPS
6 FileMaker XSLT 57 FMPXMLLAYOUT XSLT document() FileMaker <xsl:variable name="layout" select="document(concat($xml-base-uri,'/fmi/xml/fmpxmllayout.xml?-view'))" /> Color FileMaker shirts Color ID "100" color"light Green" document() DISPLAY 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> <xsl:for-each select="$layout/fml:fmpxmllayout/fml:valuelists/fml:valuelist[@name = 'shirts']/fml:value"> </select> <option> </option> </xsl:for-each> <xsl:attribute name="value"><xsl:value-of select="."/></xsl:attribute> <xsl:value-of select="@display"/> Web XSLT Web XSLT XSLT FileMaker 1 fmxslt:create_session(): 58 1 fmxslt:set_header(): 61 1 fmxslt:set_status_code (): 61 1 fmxslt:set_cookie(): 62 Cookie FileMaker XSLT <?xslt-cwp-buffer buffer-content="true"?> <?xslt-cwp-buffer?> Web Content-Length Web
58 FileMaker Server Web with XML and XSLT 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> 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 - ) Admin Console FileMaker Server <?xslt-cwp-buffer?> 57 fmxslt:invalidate_session(string - ) fmxslt:set_session_timeout(string -, Number ) Admin Console fmxslt:session_encode_url(string URL) Cookie ID URL URL
6 FileMaker XSLT 59 fmxslt:set_session_object(string -, String, Object ) XSLT XSLT fmxslt:get_session_object () set_session_object() 10100 10100 remove_session_object() fmxslt:get_session_object(string -, String ) fmxslt:remove_session_object(string -, String ) XSLT XSLT 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> </xsl:variable> <xsl:variable name="favorite-color" select="fmxslt:set_session_object(string($session-name), 'favorite-color', string($color))"/> 1 fmxslt:invalidate_session () 1 Admin Console Web XSLT FileMaker Server 1 Web Web
60 FileMaker Server Web with XML and XSLT Web Web Web Web XSLT fmxslt:send_email () fmxslt:send_email () Web XSLT Web fmxslt:send_email(string SMTP, String ) fmxslt:send_email(string SMTP, String, String ) Web Web US-ASCII ISO-8859-1 ISO-8859-15 ISO-2022-JP Shift_JIS UTF-8 52 fmxslt:send_email(string SMTP, String XSLT, Node XML, boolean ) <xsl:output> encoding HTML <xsl:output> encoding HTML <xsl:output> encoding Web 1 fmxslt:send_email () SMTP URL RFC 2368 mailto URL @? = & =... @ / 1 from= @ from 1 to= @ / 1 reply-to= @ 1 cc= @ 1 bcc= @ 1 subject= from reply-to subject false() 1 Web @.tld " ID"< @.tld> tld com net 1 subject SMTP URL & & %20SMTP XML 1 true() false()
6 FileMaker XSLT 61 1 Web Shift_JIS Admin Console FileMaker Server 1 fmxslt:send_email(string SMTP, String XSLT, Node XML, boolean ) XML 1 XSLT URL 1 XML XML XML XML XPath / document() fmxslt:send_email() XML 1 HTML Web true() FileMaker URL Web false () URL Web URL Web <xsl:if> XPath fmxslt:send_email(string SMTP, String XSLT, Node XML, boolean ) fmxslt:send_email('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 fmxslt:get_header() HTTP fmxslt:set_header() Web HTTP 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')" />
62 FileMaker Server Web with XML and XSLT 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 "http://www.filemaker.com/xml/cookie"> <!ELEMENT cookie (#PCDATA)> <!ATTLIST cookie name CDATA #REQUIRED> 1 Cookie XML "http://www.filemaker.com/xml/cookie" 1 fmxslt:set_cookie Web fmxslt:set_cookie 1 Cookie 1 fmxslt:set_cookie() <?xslt-cwp-buffer?> 57 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 Value = ', $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')" />
6 FileMaker XSLT 63 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-8859-1 ISO- 8859-15 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-8859-1 ISO- 8859-15 ISO-2022-JP Shift_JIS UTF-8 URL Web ISO-8859-1 Perl 5 fmxslt:regex_contains() Perl 5 fmxslt:regex_contains(string input, String pattern) input pattern Perl 5 Perl 5 www.perldoc.com fmxslt:regex_contains()
64 FileMaker Server Web with XML and XSLT XSLT Perl 5 <xsl:variable name="email" select="'foo@bar.com'"/> <xsl:if test="fmxslt:regex_contains($email,'^\w+[\w-\.]*\@\w+((-\w+) (\w*))\.[a-z]{2,3}$')">valid Email</xsl:if> Web 10311 101 FileMaker XSLT FileMaker fmxslt:contains_checkbox_value(string valuestring, String valuelistentry) valuestring XPath valuelistentry true() false() HTML checked FileMaker [ ] Red [ ] Blue [ ] Green [ ] Small [ ] Medium [ ] Large [Red] Red Blue fmxslt:contains_checkbox_value(< >,'Blue') < > <data> XPath false Web Web HTML XSLT color_sizestyle <xsl:variable name="field-value" select="fmrs:field[@name='style']/fmrs:data" /> <xsl:for-each select="$valuelists[@name = '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:if> </input><xsl:value-of select="."/><br/> </xsl:for-each> <xsl:attribute name="checked">checked</xsl:attribute>
6 FileMaker XSLT 65 HTML XSLT [Red] [Medium] Web [x] Red [ ] Blue [ ] Green [ ] Small [x] Medium [ ] Large fmfm 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() fmmm/dd/yyyy fmxslt:get_short_date_format() M/d/yy fmxslt:get_long_date_format() MMM d, yyyy fmxslt:get_fm_time_format() fmhh:mm:ss fmxslt:get_fm_timestamp_format() fm MM/dd/yyyy HH:mm:ss 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
66 FileMaker Server Web with XML and XSLT 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 ) AZ az AZ az G y 1996; 96 M 7 ; 7 ; 07 w 27 W 2 D 189 d 10 F 2 E ; a AM/PM H 23 0 k 24 24 K AM/PM 11 0 h AM/PM 12 12
6 FileMaker XSLT 67 m 30 s 55 S 978 z ; PST Z RFC 822-0800 1 1 1 yyyy/mm/dd12/01/11 12 11 y yy 80 20 yy/mm/dd/1997 12/01/11 2012 11 64/05/04 1964-1 3/01/02 003/01/02-3/01/02 1 1 GMT 1 GMT GMT : 1 + - 1 1 1 0 1 2 3 4 5 6 7 8 9 23 00 59 Unicode Basic Latin RFC 822 1 RFC 822 RFC 822 1 RFC822 1 00 23
68 FileMaker Server Web with XML and XSLT 2001-07-04 12:08:56 "yyyy.mm.dd G 'at' HH:mm:ss z" 2001.07.04 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 02001.7.04 12:08 "EEE, d MMM yyyy HH:mm:ss Z", 4 7 2001 12:08:56-0700 "yymmddhhmmssz" 010704120856-0700 Copyright 2003 Sun Microsystems, Inc. XSLT FileMaker XSLT fmxslt:check_error_status() fmxslt:check_error_status() Web 101 FileMaker XSLT XSLT <xsl:message> Web 76 Web Web XSLT JavaScript XSLT Java 1 bsf.jar - XSLT 1 js.jsr - Mozilla JavaScript XSLT XSLT XPath XSLT Apache Xalan Extensions Web http://xml.apache.org/xalan-j/extensions.html
6 FileMaker XSLT 69 1. xalan XSLT fmp-ex <xsl:stylesheet version="1.0" xmlns:xsl=http://www.w3.org/1999/xsl/transform xmlns:xalan=http://xml.apache.org/xslt 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) { } </xalan:script> </xalan:component> if (value > 0) else return ("#009900"); return ("#CC0000"); "#009900""#CC0000" <xalan:component> <xsl:stylesheet> 3. XPath "#009900" <font color= {fmp-ex:getvaluecolor(50)} > 50 </font> "#CC0000" <font color= {fmp-ex:getvaluecolor(-500)} > -500 </font> JavaScript <xsl:choose> XSLT XPath XML Yahoo! Web CSV XPath document() XML CSV XML JavaScript CSV URL Yahoo! Web CSV http://quote.yahoo.com/d/quotes.csv?s=< >&f=l1gh&e=.csv < > 31.79,31.17,32.12
70 FileMaker Server Web with XML and XSLT Yahoo! Web XPath JavaScript XSLT <?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet > exclude-result-prefixes="xsl fmxslt fmrs xalan fmp-ex" version="1.0" xmlns:xsl="http://www.w3.org/1999/xsl/transform" xmlns:fmrs="http://www.filemaker.com/xml/fmresultset" xmlns:fmxslt="xalan://com.fmi.xslt.extensionfunctions" xmlns:xalan="http://xml.apache.org/xslt" 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 = "http://quote.yahoo.com/d/quotes.csv?s= + "+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> <xsl:template match="/fmrs:fmresultset"> <html> <body> <font size="2" face="verdana, arial"> Apple :<xsl:value-of select="fmp-ex:get_quote('aapl')"/> </font> </html> </body> </xsl:template> </xsl:stylesheet>
6 FileMaker XSLT 71 Web Yahoo! Web get_quote()
72 FileMaker Server Web with XML and XSLT
7 Web Web 1. 3 Web 2. XSLT XML FileMaker Server Admin Console FileMaker Server 3. Web Web 4. Web XSLT Web XSLT 1 Apache Mac OS/ /FileMaker Server/Web Publishing/xslt-template-files 1 IIS Windows< >: Program Files FileMaker FileMaker Server Web Publishing xslt-template-files < > xslt-template-files 5. Web FileMaker Pro Web Web FileMaker Server FileMaker
74 FileMaker Server Web with XML and XSLT 6. URL XSLT HTML < >://< >[:< >]/fmi/xsl/< >/< >.xsl[?< >] 1 < > HTTP HTTPS 1 < > Web IP 1 < > Web HTTP 80 HTTPS 443 1 < > XSLT xslt-template-files 1 < >.xsl 1 < > Web with XSLT <?xslt-cwp-query?> URL XSLT Site Assistant home.xsl A URL URL home.xslxslttemplate-filesmy_templates URL http://192.168.123.101/fmi/xsl/my_templates/home.xsl Web Web xslt-template-files XSLT Web Web XSLT Site Assistant HTML Web Web Web 1 1 1 Web 21 FileMaker Web 1 Web Web Web FileMaker Server URL http://localhost/ http://127.0.0.1/ Web URL 32 Web XML 48 FileMaker XSLT URL
7 75 XML XML XSLT 1 XML Web XML <?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/xsl/transform" xmlns:fmrs="http://www.filemaker.com/xml/fmresultset"> <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" <html> </html> xmlns:xsl="http://www.w3.org/1999/xsl/transform" xmlns:fmrs="http://www.filemaker.com/xml/fmresultset"> <xsl:output method="html"/> <body> <xsl:template match="/fmrs:fmresultset"> <textarea rows="20" cols="100"> </textarea><br/> </xsl:template> </body> </xsl:stylesheet> <xsl:copy-of select="."/> Web Web 1 Web 1 Web 1 Web 1 Web Web Apache Mac OS Apache Web Apache W3C Common Logfile Format Web HTTP Apache HTTP Apache Web IIS WindowsMicrosoft IIS Web Windows W3C Extended Log File Format Web HTTP W3C Common Logfile Format Microsoft IIS Web
76 FileMaker Server Web with XML and XSLT W3C Common Logfile Format W3C Extended Log File Format World Wide Web Consortium Web www.w3.org Web Web Web 1 Web Web 1 Web Web 1 XSLT XSLT <xsl:message> Web XSLT <xsl:message> 6 FileMaker XSLT pe_application_log.txtweb FileMaker Server Logs pe_application_log.txt Web pe_application_log.txt [ :] Web Web [ :] Web Web [ :] Web Web Admin Console FileMaker Server Web Web Web Web web_server_module_log.txtweb FileMaker ServerLogs Web Web Web Web 1 wpc_access_log.txt XML FileMaker Server Web Web Web 1 pe_internal_access_log.txt XSLT Web XSLT-CWP XML Web XSLT-CWP Web Web FileMaker ServerLogs Web [ ] FileMaker Server
A Web FileMaker -dbnames (81 ) -delete (81 ) -dup (81 ) -edit (81 ) -find -findall -findany (81 ) -findquery (82 ) -layoutnames (82 ) -new (82 ) -process (XSLT ) (83 ) -scriptnames (83 ) -view (83 ) -db (83 ) -encoding (XSLT ) (84 ) -field (84 ) 84.op 85 -grammar (XSLT only) (85 ) -lay (85 ) -lay.response (86 ) -lop (86 ) -max (86 ) -modid (86 ) -query (87 ) -recid (87 ) -relatedsets.filter (88 ) -relatedsets.max (88 ) -script (88 ) -script.param (88 ) -script.prefind (89 ) -script.prefind.param (89 ) -script.presort (89 ) -script.presort.param (89 ) -skip (90 ) -sortfield.[1-9] (90 ) -sortorder.[1-9] (90 ) -stylehref (91 ) -styletype (91 ) -token.[string] (XSLT ) (91 ) -dbnames -layoutnames -scriptnames -process XSLT -lay 1 -new -new -edit 1 -dbnames -process -db 43 FileMaker XML
78 FileMaker Server Web with XML and XSLT 1 -db=employees findall = 1 -delete -lay 1 MyLayout -lay=mylayout XSLT <xsl:value-of select="fmrs:field[@name='lastname']"/> LastName LastName 1 1 myfield.9 1 op opmyfield.op 1 global global myfield.global text.fieldhttp XML XSLT ID 1 -find Field1=Blue Field1=blue -new -edit LastName=Doe FileMaker FileMaker.fp7 FileMaker FileMaker Server Mac: / /FileMaker Server/Examples/XSLT Windows: < >: Program Files FileMaker FileMaker Server Examples XSLT : < > table-name::field-name(repetition-number).record-id 1 table-name
A 79 1 field-name(repetition-number) (2) -new -edit -find 1 record-id ID record-id -new -edit -find -new 1 1 ID 1 1 URL Employees John Doe Jane Dependents NamesID ID http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family&firstname=john&lastname=doe &ID=9756&Dependents::Names.0=Jane&-new 1 -edit ID ID ID XML <relatedset> <record> record-id 36 fmsresultset URL ID 1001 Dependents NamesNames.2 2 ID http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family&-recid=1001 &Dependents::Names.2=Kevin&-edit http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family&-recid=1001 &Dependents::Names.2=Kevin&Dependents::Names.5=Susan&-edit -edit ID http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family&-recid=1001 &Dependents::Names.0=Timothy&-ledit
80 FileMaker Server Web with XML and XSLT -delete -edit -delete.related URL employees 1001 http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family&-recid=1001&-delete URL Dependents 1001 ID 3 http://192.168.123.101/fmi/xml/fmresultset.xml?ñdb=employees&ñlay=family&ñrecid=1001 &ñdelete.related=dependents.3&ñedit 83 -delete.related -relatedsets.filter - relatedsets.max 88 -relatedsets.filter 88 -relatedsets.max :: ( ).global global 78 FileMaker Pro.global Web XML XSLT XSLT.global Web http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments &Country.global=USA&-recid=1&-edit XSLT Admin Console Web XSLT FileMaker Server
A 81 XML XSLT XSLT -grammar -dbnames FileMaker Server Web with XML XSLT http://192.168.123.101/fmi/xml/fmresultset.xml?-dbnames -delete -recid -db -lay -recid -script http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-recid=4&-delete -dup -recid -db -lay -recid -script http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-recid=14&-dup -edit / -recid recid -db -lay -recid -modid -script 79 http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-recid=13&country=usa&-edit -find -findall -findany -db -lay -recid -lop -op -max -skip -sortorder -sortfield -script -script.prefind -script.presort
82 FileMaker Server Web with XML and XSLT http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family&country=usa&-find FileMaker Server ID http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family&-recid=427&-find -findall http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family&-findall -findany http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family&-findany -findquery -db -lay -query -max -skip -sortorder -sortfield -script -script.prefind -script.presort Fluffy http://host/fmi/xml/fmresultset.xml?-db=vetclinic&-lay=animals&-query=(q1);(q2);!(q3) &-q1=typeofanimal&-q1.value=cat&-q2=typeofanimal&-q2.value=dog&-q3=name&-q3.value=fluffy&-findquery -findquery -findquery 1 -query 1 1 1 -findquery -query 87 -query -layoutnames FileMaker Server Web with XML XSLT -db http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-layoutnames -new / -db -lay -script 79 http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&country=australia&-new
A 83 -process XSLT XSLT XSLT -grammar fmresultset FMPXMLRESULT http://192.168.123.101/fmi/xsl/my_template/my_stylesheet.xsl?-grammar=fmresultset&-process 53 FileMaker Server XSLT -scriptnames FileMaker Server Web with XML XSLT -db http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-scriptnames -view FMPXMLLAYOUT FMPXMLLAYOUT fmresultset FMPXMLRESULT XML metadata -db -lay -script http://192.168.123.101/fmi/xml/fmpxmllayout.xml?-db=employees&-lay=departments&-view http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-view XML XSLT XSLT 50 FileMaker XSLT -db -db -db -dbnames -process http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-findall -delete.related -edit
84 FileMaker Server Web with XML and XSLT ID jobtable 7 ID 20 http://host/fmi/xml/fmresultset.xml?-db=career&-lay=applications&-recid=7&-delete.related=jobtable.20&-edit -encoding XSLT XSLT Web with XSLT US-ASCII ISO-8859-1 ISO-8859-15 ISO-2022-JP Shift_JIS UTF-8 XSLT http://192.168.123.101/fmi/xsl/my_template/my_stylesheet.xsl?-db=employees&-lay=departments &-grammar=fmresultset&-encoding=shift_jis&-findall 52 -field 34 XML FileMaker URL 49 XSLT FileMaker URL -find / - FileMaker 1 myfield.9 1 op opmyfield.op 1 global global myfield.global text.fieldhttp XML XSLT 78 ID -new -edit -find fm fm MM/dd/yyyy HH:mm:ss MM/dd/yyyy HH:mm:ss -edit -new -find http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-op=eq&firstname=sam &-max=1&-find FileMaker Server
A 85.op -find begins with eq FileMaker Pro = cn * * bw * ew gt gte lt lte neq * > >= < <=, -find :: = & ::.op= 1 1 cn 1 http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&name=tim&name.op=cn&-find bw FileMaker Pro... bw... http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&idnum=915...925&idnum.op=bw &-find FileMaker Pro -grammar XSLT XSLT Web with XSLT fmresultset FMPXMLRESULT FMPXMLLAYOUT : XSLT http://192.168.123.101/fmi/xsl/my_template/my_stylesheet.xsl?-grammar=fmresultset&-db=mydatabase &-lay=mylayout&-findall 50 FileMaker XSLT XML -lay
86 FileMaker Server Web with XML and XSLT -dbnames -layoutnames -scriptnames -process (XSLT ) http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-view -lay.response -lay XML - lay.response -lay.response -lay -lay.response XML XSLT -dbnames -layoutnames -scriptnames -process XSLT http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=budget&salary=100000&salary.op=gt&-find -lay.response=execlist -lop -find and or and or -lop -find and -find -findquery http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&last+name=smith &Birthdate=2/5/1972&-lop=and&-find -max all all max -find -findall -findquery http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-max=10&-findall http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-max=all&-findall -modid ID ID -edit ID ID ID -edit ID ID FileMaker ID -edit -recid http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-recid=22&-modid=6 &last_name=jones&-edit
A 87 -query 82 -findquery -findquery -query=< >< >&-findquery < > 1 qq1 1 AND (q1, q2) q1 q2 1 FileMaker Pro! (q1);!(q2) q1 q2 1 OR (q1);(q2) q1 or q2 OR 1 < > - -< ID>=< > -< ID>.value=< > -q1=typeofanimal&-q1.value=cat -q2=name&-q2.value=fluffy FluffyGray http://host/fmi/xml/fmresultset.xml?-db=petclinic&-lay=patients&-query=(q1, q2);!(q3) &-q1=typeofanimal&-q1.value=cat&-q2=color&-q2.value=gray&-q3=name&-q3.value=fluffy&-findquery -recid ID -edit -delete -view FMPXMLLAYOUT ID ID FileMaker -edit -delete -dup -find -view http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-recid=22&-delete http://localhost/fmi/xml/fmpxmllayout.xml?-db=test&-lay=empty&-view&-recid=9
88 FileMaker Server Web with XML and XSLT -relatedsets.filter layout none 1 none 1 layoutfilemaker Pro [ ] [ ] 1 [] [ ] -relatedsets.max 1 [ ] FileMaker Pro [ ] [ ] 1 -relatedsets.filter noneweb -find -edit -new -dup -findquery http://localhost/fmi/xml/fmresultset.xml?-db=fmphp_sample&-lay=english&-relatedsets.filter=none&-findany http://localhost/fmi/xml/fmresultset.xml?-db=fmphp_sample&-lay=english&relatedsets.filter=layout &-relatedsets.max=all&-findany http://localhost/fmi/xml/fmresultset.xml?-db=fmphp_sample&-lay=english&-relatedsets.filter=layout &-relatedsets.max=10&-findany -relatedsets.max all 1 Web 1 all Web 1 -relatedsets.max -relatedsets.filter 88 -relatedsets.filter -find -edit -new -dup -findquery http://localhost/fmi/xml/fmresultset.xml?-db=fmphp_sample&-lay=english&relatedsets.filter=layout &-relatedsets.max=all&-findany http://localhost/fmi/xml/fmresultset.xml?-db=fmphp_sample&-lay=english&-relatedsets.filter=layout &-relatedsets.max=10&-findany -script FileMaker 45 XML -dbnames -layoutnames -process -scriptnames http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-script=myscript&-findall -script.param -script FileMaker 1 param1%7cparam2%7cparam3 URL param1 param2 param3
A 89 1 GetAsNumber(Get( )) 1 -script -script.param -script.param 1 -script.param Web -script http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-script=myscript &-script.param=smith%7cchatterjee%7csu&-findall -script.prefind -find FileMaker -dbnames -layoutnames -process -scriptnames http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-script.prefind=myscript&-findall -script.prefind.param -script.prefind FileMaker 1 param1%7cparam2%7cparam3 URL param1 param2 param3 1 GetAsNumber(Get( )) 1 -script.prefind -script.prefind.param -script.prefind.param 1 -script.prefind.param Web -script.prefind http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-script.prefind=myscript &-script.prefind.param=payroll&-findall -script.presort -find FileMaker -dbnames -layoutnames -process -scriptnames http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-script.presort=myscript &-sortfield.1=dept&-sortfield.2=rating&-findall -script.presort.param -script.presort FileMaker
90 FileMaker Server Web with XML and XSLT 1 param1%7cparam2%7cparam3 URL param1 param2 param3 1 GetAsNumber(Get( )) 1 -script.presort -script.presort.param -script.presort.param 1 -script.presort.param Web -script.presort http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-script.presort=myscript &-script.presort.param=18%7c65&-sortfield.1=dept&-sortfield.2=rating&-findall -skip -find 10 11 15 http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-skip=10&-max=5&-findall -sortfield -find -findall -sortfield -sortfield. = -sortfield. dept rating -sortorder http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=performance&-sortfield.1=dept &-sortfield.2=rating&-findall -sortorder < > Custom FileMaker Pro a z -10 10 z a 10-10 < > -find -findall -sortfield
A 91 -sortorder -sortfield -sortorder. = 1 -sortorder. -sortorder -sortfield 1 ascend dept ascend rating descend -sortorder.2 -sortorder.2=descend -sortfield.2=rating http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=performance&-sortfield.1=dept &-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 46 -styletype -styletype mystylesheet.xsl Web http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-styletype=text/xsl &-stylehref=/mystylesheet.xsl&-findall -styletype XML CSS Cascading Style Sheet XSLT XML type type=text/css type=text/xsl46 -stylehref -stylehref mystylesheet.css Web http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-styletype=text/css &-stylehref=/mystylesheet.css&-findall -token. [ ] XSLT Cookie XSLT Web with XSLT -token.[ ] a z A Z URL XSLT http://192.168.123.101/fmi/xsl/template/my_stylesheet.xsl?-db=employees&-lay=departments &-grammar=fmresultset&-token.d100=active&-findall 53
92 FileMaker Server Web with XML and XSLT
B Web Web Web 1 XML Web FileMaker 1 Web Web Web 99 Web 1 FileMaker XSLT XSLT fmxslt:check_error_status() 101 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="http://www.filemaker.com/xml/fmresultset" 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="http://www.filemaker.com/fmpxmlresult"> <ERRORCODE>0</ERRORCODE> <error code> <ERRORCODE> Web Web -1 0 1 2 3 4 5 [ ] 6 7 8
94 FileMaker Server Web with XML and XSLT 9 10 11 12 13 14 15 16 17 UTF-16 18 19 A Z a z 0 9 ASCII 20 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 130 131 200 201 202 203 204 205 206
B Web 95 207 208 209 210 211 212 213 214 215 216 217 300 301 302 303 304 306 ID 400 401 402 403 FileMaker Pro 404 405 406 407 ) 408 409 410 412 FileMaker Pro 413 414 415 416 417 500 501 502 503 504
96 FileMaker Server Web with XML and XSLT 505 506 507 508 509 510 511 512 513 600 601 602 603 700 706 EPSF 707 708 709 QuickTime 710 QuickTime 711 714 715 Excel 716 ODBC DELETE INSERT UPDATE SQL 717 XML/XSLT 718 Xerces XML 719 Xalan XSL XML 720 721 722 723 724 725 726 727 729 730 Excel Excel 7.0 Excel 95Excel 97 2000 XP 2007
B Web 97 731 732 733 734 735 736 737 Bento 800 801 802 1 1 FileMaker Server 1 803 804 805 806 FileMaker Pro 807 FileMaker Pro 808 809 / 810 / 811 FileMaker Pro 813 814 815 816 817 819 820 821 822 FMI 823 824 FileMaker 825 900 901 902 903 904 FileMaker Server
98 FileMaker Server Web with XML and XSLT 905 906 920 921 922 923 951 954 XML 955 956 957 958 959 Web 1200 1201 1202 1203 1204 ( 1205 */ 1206 1207 1208 ( 1209 1210 1211 1212 + - * 1213 Let 1214 AVERAGE COUNT EXTEND GETREPETITION MAX MIN NPV STDEV SUM GETSUMMARY 1215 Get 1216 GetSummary 1217 1218 1219 1220 1221 1222 1223 1224
B Web 99 1225 1400 ODBC ODBC 1401 ODBC 1402 ODBC 1403 ODBC 1404 ODBC 1405 ODBC 1406 SQL API ODBC 1407 ODBC 1408 ODBC 1409 ODBC 1410 ODBC 1411 ODBC 1412 ODBC 1413 ODBC 1450 PHP 1451 1501 SMTP 1502 SMTP 1503 SSL 1504 SMTP 1505 SMTP 1506 E 1507 SMTP Web Web Web Web 1 <xsl:include> 1 XML 1 XSLT XPath 1 CGI XML 1 Web XML Web
100 FileMaker Server Web with XML and XSLT 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
B Web 101 FileMaker XSLT fmxslt:check_error_status() 68-1 0 10000 10001 HTTP 10100 10101 10102 10103 10104 10200 10201 10202 SMTP 10203 To 10204 From 10205 CC 10206 BCC 10207 Subject 10208 Reply-To 10209 10210 - XSLT send_email() 10211 SMTP - 10212 - XSLT set_header() set_status_code() set_cookie() 10213 SMTP 10300 10301 10302 10303 10304
102 FileMaker Server Web with XML and XSLT 10305 10306 10307 10308 10309 10310 URL 10311
A auto-enter 37 B break_encode() 63 C check_error_status() 68, 101 compare_date() 65 compare_datetime() 66 compare_day() 66 compare_time() 66 contains_checkbox_value() 64 convert_datetime() 66 Cookie 62 ID 58 create_session() 58 CWPE Web 32 D <datasource> 36 -dbnames 81 -db 83 -delete.related 80 -delete 81 -dup 81 E -edit 81 -encoding 84 <error code> <ERRORCODE> 93 Extensible Markup Language XMLXML F <field-definition> 37 -field 84 FileMaker Pro Web 31 FileMaker Server 9 9 FileMaker Server Admin Admin Console 20 FileMaker Server Admin Console 32 FileMaker Site Assistant XSLT Site Assistant FileMaker XSLT fmxslt FileMaker XSLT 54 -findall 81 -findany 81 -findquery 82 -find 81 FMPDSORESULT 35 FMPXMLLAYOUT 31 35 40 42 FMPXMLRESULT 31 35 38 40 fmresultset 31, 36 38 fmxslt fmxslt:break_encode() 63 fmxslt:check_error_status() 68, 101 fmxslt:compare_date() 65 fmxslt:compare_datetime() 66 fmxslt:compare_day() 66 fmxslt:compare_time() 66 fmxslt:contains_checkbox_value() 64 fmxslt:convert_datetime() 66 fmxslt:create_session() 58 fmxslt:get_cookie() 62 fmxslt:get_cookies() 62 fmxslt:get_date() 65 fmxslt:get_datetime() 66 fmxslt:get_day() 65 fmxslt:get_fm_date_format() 65 fmxslt:get_fm_time_format() 65 fmxslt:get_fm_timestamp_format() 65 fmxslt:get_header() 61 fmxslt:get_long_date_format() 65 fmxslt:get_long_day_format() 65 fmxslt:get_long_time_format() 65 fmxslt:get_session_object() 59 fmxslt:get_short_date_format() 65 fmxslt:get_short_day_format() 65 fmxslt:get_short_time_format() 65 fmxslt:get_time() 65 fmxslt:html_encode() 63 fmxslt:invalidate_session() 58, 59 fmxslt:regex_contains() 63 fmxslt:remove_session_object() 59 fmxslt:send_email() 60 fmxslt:session_encode_url() 58 fmxslt:session_exists() 58 fmxslt:set_cookie() 62 fmxslt:set_header() 61 fmxslt:set_session_object() 59 fmxslt:set_session_timeout () 58 fmxslt:set_status_code() 61 fmxslt:url_decode() 63 fmxslt:url_encode() 63 four-digit-year 37 FileMaker API for PHP 13 fmresultset 35
104 FileMaker Server Web with XML and XSLT G get_cookie() 62 get_cookies() 62 get_date() 65 get_datetime() 66 get_day() 65 get_fm_date_format() 65 get_fm_time_format() 65 get_fm_timestamp_format() 65 get_header() 61 get_long_date_format() 65 get_long_day_format() 65 get_long_time_format() 65 get_session_object() 59 get_short_date_format() 65 get_short_day_format() 65 get_short_time_format() 65 get_time() 65 GIF Web 21 global 37 -grammar 85 H HTML XML 31 XML 33 html_encode() 63 I invalidate_session() 58, 59 ISO-2022-JP 52 ISO-8859-15 52 ISO-8859-1 52 J JavaScript 68 JDBC 9 JPEG Web 21 L -lay.response 45, 86 -layoutnames 82 -lay 45, 85 -lop 86 M max-characters 37 max-repeat 37 -max 86 <metadata> 37 MIME Multipurpose Internet Mail Extensions20 -modid 86 N name 37 -new 82 not-empty 37 numeric-only 37 O ODBC 9 P PDF 9 pe_application_log.txt 76 pe_internal_access_log.txt 76 pe_server_error.html 100 Perl 63 PHP 30 -process 53, 83 PHP 30 14 Q -query 87 QuickTime Web 21 R -recid 87 regex_contains() extension 63 <relatedset-definition> 37 -relatedsets.filter 88 -relatedsets.max 88 remove_session_object() 59 <resultset> 37 result 37 S SAT Admin Console 20 Scalable Vector Graphics SVGXML 31 -script.param 88 -script.prefind.param 89 -script.prefind 89 -script.presort.param 89 -script.presort 89 -scriptnames 83 -script 88 send_email() 60 session_encode_url() 58 session_exists() 58 set_cookie() 62 set_header() 61 set_session_object() 59 set_session_timeout () 58
105 set_status_code() 61 Shift_JIS 52 Site Assistant 16 Site Assistant XSLT Site Assistant -skip 90 -sortfield 90 -sortorder 90 SSL Secure Sockets Layer20 -stylehref 91 -styletype 91 T -token 53, 91 type 37 U Unicode 43 url_decode() 63 url_encode() extension 63 URL XML 34 XML 33 XSLT 48 XSLT 49 URL 34 US-ASCII 52 User-Agent 54 UTF-8 Unicode Transformation 8 Bit 52 34, 43 V vcard XML 31 -view 83 W web_server_module_log.txt 76 Web 12 Web Admin Console 26, 32 Web 75 MIME 20 XML 32 Web 75 Web FileMaker 9 Web 15 75 74 Web 75 Web QuickTime 21 XML 15, 32 XSLT 26, 47 17 20, 29 93 20 17 Web 21 Web XML 32 12 Web 21 Web 17 19, 56 Web 19 Web 19 56 wpc_access_log.txt 76 Web Admin Console 26, 32 XML 32 XML 33 76 99 100 93 12 12 15 Web 32 76 X XML fmresultset 36 <metadata> 37 <resultset> 37 <datasource> 36 <field-definition> 37 <relatedset-definition> 37 FMPXMLLAYOUT 40 FMPXMLRESULT 39 URL 34 UTF-8 35, 43 XML 1.0 31 XML 46 XML 32 XML 46 43, 77 46 31 31 33 19 35 33, 43 DTD 36, 39
106 FileMaker Server Web with XML and XSLT 35 XML 32 45 XML 45 XML 45 XML XSLT 14 XML fmxml 19, 32 XML 33 XML 31 XML 31 XML 45 XML ASCII 43 XML 35 XML 45 XML 45 XML Web 13 XPath 54 <xsl:message> 68 <xsl:output> 52 <xsl:param name="authenticated-xml-base-uri"/> 55 <xsl:param name="client-ip"/> 55 <xsl:param name="client-password"/> 55 <xsl:param name="client-user-name"/> 55 <xsl:param name="request-query"/> 54 <xsl:param name="xml-base-uri"/> 55 <xsl:param> 54 <xsl:stylesheet> 50, 54, 75 <xsl:template> 55, 75 <xsl:variable> 56 <?xslt-cwp-buffer buffer-content="true"?> 57 <?xslt-cwp-query?> 47, 51 XSLT 61 63 57 -grammar 50 Cookie 62 FileMaker XSLT 54 FileMaker 54 JavaScript 68 Perl 63 Web 29 XSLT 1.0 25 XSLT-CWP 26 XSLT Site Assistant 27 xslt-template-files 27, 29 68 50 78 26 64 19 60 50 65 66 XSLT Site Assistant 28 28 28 29 27 xslt-template-files 27, 29 XSLT fmxslt 19, 26 XSLT 51 XSLT 83 XSLT FileMaker 54 XSLT 16, 27 XSLT Web 13 Web 19 20 22 20 Web 19 64 68, 76 Web 11 9 9 pe_application_log.txt 76 pe_server_error.html 100 Web 99 Web 75 93 101 68, 101 35 93 FMPXMLLAYOUT 40 FMPXMLRESULT 39 fmresultset 36 35
107 -encoding 84 URL 34, 58 XML 35, 43 <xsl:output> 52 XSLT 53 63 52 85 Web 21 XML URL 34 XSLT URL 49 20, 29 9 Web 99 Web 11 68 Web XML 13 XSLT 13 Web 20 Web IP 20 Web 19 XML 31 XSLT 47 11 19 20 16 23 21 IP 17 15 11 19 17 Web 16 Web 17 Web 19 Web 19, 26, 32 78 54 43, 50, 77 XML 43, 77 XSLT 50 XSLT 51 77 78 78 80 43, 50, 77 79 79 78 33, 46 XSLT 55 80 59, 80 59, 80 66 Web 20 20 20 20 57 XSLT 25, 47 [ ] 20 65 66 Web 100 83 83 82 58 82 <xsl:output> 52 52 52 52
108 FileMaker Server Web with XML and XSLT XML 33 22 Web 21 20 59 23 20 22 -grammar 50 Cookie 62 Perl 63 Web 29 XML 46 XSLT Site Assistant 27 XSLT 25 53 47 47 25 68 50 46 57 25, 47 25 58 64 74, 75 60 65 66 61 63 57 53 25 25 25 25 25 25 11 53 IP 20 20 20 51 12 58 58 64 56 35 20 59, 80 Web 19 -encoding 84 URL 34, 58 XSLT 52 52 52 XML 35 63 52 30 XML 32 XSLT 26 Web 74 XML 75 9 60 52 document() 56 9, 17 XML 46 XSLT 30 Web Web 74 23 URI 55 XML 35 XSLT 50
109 Web 19, 55 XML 56 Web 19 [ ] 20 20 [ ] 20 57 Web 99 101 93 65 66 85 78 84 -.op 85 82 87 DTD 36, 39 URI 55 61 88 80 88 79 79 88 88 88 80 80 Perl 63 63 63 Web 19, 55 XML 56 Web 19 65 FMPXMLLAYOUT 42 FMPXMLRESULT 40 fmresultset 38 XML 45 57 83 82 pe_application_log.txt 76 pe_internal_access_log.txt 76 web_server_module_log.txt 76 Web 75 <xsl:message> 76 <xsl:message> 68 75 9 25
110 FileMaker Server Web with XML and XSLT