FileMaker Server Custom Web Publishing with XML and XSLT

Transcription

1 FileMaker Server 10 Web with XML and XSLT

2 FileMaker, Inc. All rights reserved. FileMaker, Inc Patrick Henry Drive Santa Clara, California FileMaker Bento Bento FileMaker, Inc. Mac Mac Apple Inc. FileMaker FileMaker, Inc. FileMaker E URL E URL Acknowledgements URL 01

3 9 1 Web 11 Web 12 Web 12 PHP Web 13 XML XSLT Web 13 PHP XML XSLT 14 PHP 14 XML XSLT 14 2 XML XSLT Web 15 Web Web 15 XML Web 15 XSLT Web 15 XSLT 16 XML XSLT Web 16 Web 17 Web 17 Web Web Web 19 Web Web MIME 21 Web Web 21 FileMaker Web Web 23 Web 23

4 4 FileMaker Server Web with XML and XSLT 4 Web XML 25 XML Web 25 Web FileMaker Pro XML / 25 Web XML 26 Web XML 27 XML URL 27 XML URL 27 XML FileMaker URL 28 URL 29 Web XML 29 FileMaker XML 29 FileMaker 30 FileMaker 30 fmsresultset 31 fmresultset 31 fmresultset XML 32 FileMaker XML 33 FMPXMLRESULT 33 FMPXMLRESULT XML 34 FMPXMLLAYOUT 35 FMPXMLLAYOUT XML 36 UTF-8 36 FileMaker XML 37 XML 39 XML XML 40 5 XSLT Web 41 FileMaker XSLT 41 FileMaker XSLT 41 XSLT Web 41 Web XML XSLT 42 XSLT Web 43

5 5 FileMaker XSLT Site Assistant FileMaker XSLT 44 XSLT Site Assistant 44 XSLT Site Assistant 44 XSLT Site Assistant 45 XSLT Site Assistant 45 Web FileMaker XSLT 45 XSLT 47 6 FileMaker XSLT 49 Web XSLT 49 FileMaker XSLT 49 FileMaker XSLT Starter Solution 50 FileMaker XSLT URL 50 XSLT FileMaker URL 51 FileMaker XSLT 51 FileMaker XSLT XML 52 FileMaker XSLT XSLT 55 FileMaker Server XSLT 55 55

6 6 FileMaker Server Web with XML and XSLT FileMaker XSLT 56 Web FileMaker XSLT Web URI 57 URI Web Web Cookie Perl Web 75 Web 76 XML Web 78 Web 78 Web 78 Web 78

7 7 A FileMaker dbnames 84 -delete 85 -dup 85 -edit 85 -find -findall -findany 85 -findquery 86 -layoutnames 86 -new 86 -process XSLT 86 -scriptnames 87 -view 87

8 8 FileMaker Server Web with XML and XSLT 87 -db 87 -delete.related 87 -encoding XSLT 88 -field op 89 -grammar XSLT 89 -lay 90 -lay.response 90 -lop 90 -max 90 -modid ID 91 -query 91 -recid ID 92 -relatedsets.filter 92 -relatedsets.max 92 -script 93 -script.param 93 -script.prefind 93 -script.prefind.param 93 -script.presort 94 -script.presort.param 94 -skip 94 -sortfield 94 -sortorder 95 -stylehref href 95 -styletype 96 -token.[ ] XSLT 96 B Web 97 FileMaker 97 Web 103 FileMaker XSLT

9 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 FileMaker Web FileMaker Server FileMaker Server Web PHP Web PHP Site Assistant XML XSLT Web 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 10 FileMaker Server Web with XML and XSLT

11 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 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 PHP Web : FileMaker Pro PHP PHP FileMaker API FileMaker PHP Web PHP Site Assistant PHP Web PHP Web 1 XML XSLT Web : 1 XML FileMaker Web 1 XSLT FileMaker Web XSLT Site Assistant XSLT

12 12 FileMaker Server Web with XML and XSLT Web Web Web FileMaker Server FileMaker Server Web Web Web Web FileMaker Server XML XSLT Web : Web XSLT HTML XML vcard Web Web Web Web Web Web HREF Web FileMaker URL Uniform Resource Locator URL XML XSLT Web XML XSLT PHP Web : Web Web FileMaker Server PHP Web FileMaker API for PHP Web FileMaker Server Web 1 Web 2 3 Web.fp7.fp7 Web Web FM API PHP XSLT Web 1. Web Web 2. Web FileMaker Web Web 3. Web Database Server 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

13 1 Web 13 PHP Web 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 XML XSLT Web 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 XSLT Web XSLT XSLT Site Assistant

14 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 1 PHP PHP Web 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

15 2 XML XSLT Web 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 XML Web XML Web XML Web FileMaker HTTP FileMaker XML XML XML XSLT 4 Web XML XSLT Web XSLT Web XML Web XSLT FileMaker XML XML Web Web 5 XSLT Web Web XSLT HTTP URL Web FileMaker Web XML Web HTML

16 16 FileMaker Server Web with XML and XSLT XML XSLT FileMaker Server Web XSLT FileMaker Server XSLT FileMaker XSLT Site Assistant XSLT FileMaker Web XSLT XSLT Site Assistant FileMaker XSLT XSLT 44 FileMaker XSLT Site Assistant FileMaker XSLT FileMaker Server World Wide Web Consortium XSLT 1.0 XSLT XSLT 1.0 XML XSLT Web XML XSLT FileMaker Server Web 1 FileMaker Server FileMaker Pro 1 XSLT 1 XSLT JavaScript 71 1 FileMaker XSLT XML 53 1 FileMaker Pro Web 20 1 Web FileMaker 75 Web 22 FileMaker Web 1 FileMaker 93 -script.param 93 -script.prefind.param 94 -script.presort.param 1 fmresultset XML 1 XSLT Web 1 A 1 Web FileMaker Pro Web 84

17 2 XML XSLT Web 17 Web Web XML XSLT Web 1 FileMaker Server 1 Microsoft IIS Windows Apache Mac OS X Web 1 Web FileMaker Database Server 1 Web 1 FileMaker Server FileMaker Pro 1 Web IP 1 Web Web Web FileMaker Server Web Web Web XML XSLT Web 1 Web 1 Web 1 Web IP FileMaker Server 1 Web Web 1 FileMaker Server Web IP ISP IP IP IP ISP

18 18 FileMaker Server Web with XML and XSLT Web 1 FileMaker Server Admin Console Web FileMaker Server FileMaker Server 1 FileMaker FileMaker Pro Web 19 Web 1 XML FileMaker 4 Web XML 1 FileMaker XSLT 5 XSLT Web

19 3 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 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 1 Web Web Web 1

20 20 FileMaker Server Web with XML and XSLT 1 Web [ ] Web 1 FileMaker Pro Web Web [ ] Web FileMaker Pro XML XSLT Web 1 Web 1 XML XSLT Web 1 Web 1 Web FileMaker Server Admin Console Web Web FileMaker Server 1 Web IP Web IP Web IP Web 1 Web Web SSL Secure Sockets Layer SSL SSL Web FileMaker PDF

21 3 Web 21 Web MIME MIME Multipurpose Internet Mail Extensions Web Web Web MIME Web Web FileMaker Web Web FileMaker FileMaker Server 28 XML FileMaker URL 51 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

22 22 FileMaker Server Web with XML and XSLT FileMaker Web FileMaker Pro Web Web FileMaker FileMaker 75 Web URL XSLT <?xslt cwp query?> Web FileMaker Pro [ ] [] [Web ]Web FileMaker Pro Web 23 Web Web Web pe_application_log.txt78 Web 1 Web Web Web 1 Web [] 1 [] [] 1 Web [ ] 1 [ ] 1 [ ] 1 1 FileMaker Pro [/] Web Web 1 [/] [] [ ] [ ] [/] Web [ /]

23 3 Web 23 1 Get( ) Web Publishing Engine Web FileMaker Pro 1 XSLT FileMaker Server Admin Console Web XSLT FileMaker Server 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 24 FileMaker Server Web with XML and XSLT

25 4 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 5 XSLT Web 6 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 29 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

26 26 FileMaker Server Web with XML and XSLT FileMaker Pro XML FileMaker Pro 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 Database Server FileMaker Database Server Web CWPE Web.fp7.fp7 Web FileMaker Database Server XML.fp7.fp7 FileMaker Database Server Web XML Web 5. Web XML Web FileMaker Server Web 4. FileMaker Database Server Web 6. Web Web Web Web Web CWPE Web

27 4 Web XML 27 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 3. HTML HREF Web FileMaker XML FileMaker URL HTTP HTTPS Web Web URL URL XML URL 37 FileMaker XML A 4. Web URL XML Web 5. Web XML Web Web 39 XML URL Web FileMaker XML URL XSLT URL XML 50 FileMaker XSLT URL 51 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

28 28 FileMaker Server Web with XML and XSLT 1 <XML> FileMaker XML fmresultset.xml FMPXMLRESULT.xml FMPXMLLAYOUT.xml FMPDSORESULT.xml 31 fmsresultset 33 FileMaker XML 1 < > FileMaker XML -dbnames 37 FileMaker XML A URL URL FMPXMLRESULT FMPXMLLAYOUT FMPDSORESULT 81 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 82 < >://< >[:< >]/fmi/xml/cnt/data.< >?< > <> < > < > XML URL : 1 <data> : <data>/images/logo.jpg</data> FileMaker Pro Web Web 21 Web 1 <data>

29 4 Web XML 29 XML XSLT 51 XSLT FileMaker URL URL XML URL UTF-8 Unicode Transformation 8 Bit 36 UTF-8 infofiance'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 31 fmsresultset 1 FMPXMLRESULT FMPXMLLAYOUT:XML XSLT FMPXMLRESULT FMPXMLLAYOUT Web XML Web FMPXMLRESULT FMPXMLLAYOUT 33 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 36 UTF-8 FileMaker XML XML XML <DATABASE> FileMaker XML Oracle XML XML <DATABASE>

30 30 FileMaker Server Web with XML and XSLT 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 DTD HTTP fmresultset FMPXMLRESULT FMPXMLLAYOUT FMPDSORESULT HTTP >[:< >]/fmi/xml/fmresultset.dtd >[:< >]/fmi/xml/fmpxmlresult.dtd >[:< >]/fmi/xml/fmpxmllayout.dtd >[:< ]/fmi/xml/fmpdsoresult.dtd?-db=<>&- lay=< >

31 4 Web XML 31 fmsresultset XML FileMaker fmresultset Web XML URL fmresultset fmresultset.xml : 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 total-count database 1 XML <datasource> date-format MM/dd/yyyy 1 MM dd yyyy - 1 XML <datasource> time-format HH:mm:ss 1 HH mm ss <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 yes no

32 32 FileMaker Server Web with XML and XSLT 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> modid 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" "" <fmresultset xmlns=" version="1.0"> <error code="0" /> <product build="02/07/2007" 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="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" time-of-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" time-of-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" numericonly="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" time-of-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">

33 4 Web XML 33 <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 : FMPXMLLAYOUT Web XML URL -view FMPXMLLAYOUT.xml : FMPXMLRESULT FMPXMLLAYOUT XML Web <?xml...?> <!DOCTYPE> <!DOCTYPE> DTD URL FMPXMLRESULT FMPXMLRESULT <DATABASE> NAME RECORDS DATEFORMAT TIMEFORMAT XML <DATABASE> DATEFORMAT XML <DATABASE> TIMEFORMAT FMPXMLRESULT fmresultset 31 fmresultset

34 34 FileMaker Server Web with XML and XSLT FMPXMLRESULT <METADATA> FIELD <FIELD> / Yes /NoEMPTYOK MAXREPEAT TEXT NUMBER DATE TIME CONTAINER <RESULTSET> <ROW> <ROW> / RECORDID MODID 91 -modid ID <COL> <COL> / <DATA> FMPXMLRESULT XML FMPXMLRESULT XML <?xml version="1.0" encoding="utf-8" standalone="no"?> <!DOCTYPE FMPXMLRESULT PUBLIC "-//FMI//DTD FMPXMLRESULT//EN" "" FMPXMLRESULT.dtd"> <FMPXMLRESULT xmlns=" <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="02/07/2007" NAME="FileMaker Web Publishing Engine" VERSION=" " /> <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

35 4 Web XML 35 <VALUELISTS> <VALUELIST> <VALUE> FileMaker [ ] <VALUE> DISPLAY ID ("100" ) ("Impressionism" ) [ ] DISPLAY 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 68 birthdays birthdatebirthdate fm FMPXMLLAYOUT XML FMPXMLLAYOUT XML <?xml version="1.0" encoding="utf-8" standalone="no"?> <!DOCTYPE FMPXMLLAYOUT PUBLIC "-//FMI//DTD FMPXMLLAYOUT//EN" "" FMPXMLLAYOUT.dtd"> <FMPXMLLAYOUT xmlns="

36 36 FileMaker Server Web with XML and XSLT <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="02/07/2007" 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="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> 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 Unicode

37 4 Web XML 37 1 UTF-8 ASCII Unicode UTF-8 Unicode 50% FileMaker XML FileMaker XML FileMaker URL -findall products FileMaker -new -dbnames -db URL FileMaker XSLT <?xslt cwp query?> 6 FileMaker XSLT FileMaker A Web FileMaker XSLT process 51 FileMaker XSLT -dbnames -delete -dup -edit -find -findall -findany -findquery -layoutnames -new -scriptnames -view Web Web Web FMPXMLLAYOUT fmresultset FMPXMLRESULT XML <metadata> -db -delete.related -field -dbnames -process XSLT -edit URL 28 XML FileMaker URL

38 38 FileMaker Server Web with XML and XSLT.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] -stylehref HREF -styletype -edit -find 88 -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 -styletype URL XML -lay XML XML XML XML -lay.response Budget Salary 100,000 ExecList Salary

39 4 Web XML lay.response=execlist XML XML XML FileMaker Server Web XML 1. -lay 2. URL.global= 3. -script.prefind 4. -find -new 5. -script.presort lay.response 8. -script 9. XML sortfield 102 Web XSLT Web XML XSLT Web 5 XSLT Web 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

40 40 FileMaker Server Web with XML and XSLT -stylehref=/document.xsl / Web Web URL Web Web XML <?xml stylesheet type="text/xsl" href="/mystylesheet.xsl"?> HREF URL Web xslt-template-files XSLT 45 Web FileMaker XSLT Web Web XML Web XML 1 XML Web 19 Web 1 FileMaker Server Database Server FileMaker Server FileMaker Server 1 1 FileMaker Server Web 1 FileMaker Server Web 1 Web XML FileMaker Server

41 5 XSLT Web FileMaker XSLT XML Web FileMaker XSLT XSLT FileMaker XSLT Site Assistant FileMaker XSLT 6 FileMaker XSLT FileMaker XSLT FileMaker XSLT Web 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 56 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 XSLT Site Assistant XML XSLT

42 42 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 Database Server FileMaker Database Server 2. Web XSLT- CWP CWPE CWPE Web.fp7.fp7 Web FileMaker Database Server XSLT-CWP.fp7.fp7 Database Server Web XSLT Web FileMaker Server Web 5. FileMaker Database Server Web 8. Web Web Web Web 6. Web XML CWPE Web 7. CWPE XSLT XML HTML XML Web CWPE Web

43 5 XSLT Web 43 XSLT Web XSLT Web 1. Admin CosoleXSLT FileMaker Server 2. FileMaker FileMaker Pro XSLT Web fmxslt 19 Web FileMaker FileMaker 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 ServerWeb Publishing xslt-template-files 5. Web 45 Web FileMaker XSLT 6. XSLT Web Web XSLT XSLT index.html Web Web XSLT 9.

44 44 FileMaker Server Web with XML and XSLT 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 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 Database 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

45 5 XSLT Web [FileMaker Server Web ] URL >: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 [] XSLT Site Assistant XSLT Site Assistant XSLT Site Assistant XSLT Site Assistant XSLT Site Assistant 45 Web FileMaker XSLT XSLT Site Assistant XSLT Site Assistant XSLT Site Assistant XSLT FileMaker 1 <?xslt-cwp-query params=" "?> XML XSLT Site Assistant 53 1 <xsl:param name="request-query"/> HTML XSLT Site Assistant 56 1 <xsl:param name="authenticated-xml-base-uri"/> XML URI 58 URI utilities.xsl XSLT Site Assistant XSLT XSLT Site Assistant 6 FileMaker XSLT Web FileMaker XSLT Web Web XSLT Site Assistant XSLT

46 46 FileMaker Server Web with XML and XSLT Web FileMaker XSLT 1. XSLT xslt-template-files xslt-template-files Web FileMaker ServerWeb 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 21 Web FileMaker FileMaker Server 4. XSLT URL < >://< >[:< >]/fmi/xsl/< >/< >.xsl[?< >] 50 FileMaker XSLT URL Web XSLT XSLT Site Assistant <?xslt-cwp-query?> home.xsl home.xslxslt-template-filesmy_templates URL Web Web xslt-template-files XSLT Web Web Web

47 5 XSLT Web 47 XSLT XSLT 1 XSLT Web 19 Web 1 FileMaker Server Database Server FileMaker Server 1 1 FileMaker Server Web 1 FileMaker Server Web 1 Web XSLT 1 [FileMaker Server ] >:16000/test < > FileMaker Server 1 [XSLT Web ] FMServer_Sample XSLT FileMaker Server FileMaker Server

48 48 FileMaker Server Web with XML and XSLT

49 6 FileMaker XSLT FileMaker XSLT FileMaker XSLT Web XSLT Web FileMaker XML XSLT 1 Web XSLT URL XSLT Web Web 50 FileMaker XSLT URL 1 UTF-8 Web ASCII 1 FileMaker XML URL <?xslt-cwp-query?> XML Web 52 FileMaker XSLT XML 1 FileMaker XML URL <?xslt-cwp-query?> 50 FileMaker XSLT URL encoding XSLT Web 54 1 <xsl:output> method Web HTML <xsl:output> encoding 54 1 fmxslt:send_ () Web 62 Web Web <?xslt-cwp-query?> <?xslt-cwp-query?> URL Web <?xslt-cwp-query?> URL Web FileMaker XML Web HTML FileMaker XSLT FileMaker XSLT XSLT Reference.fp7 FileMaker FileMaker Server Mac OS / /FileMaker Server/Example/XSLT

50 50 FileMaker Server Web with XML and 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 <> XSLT xslt-template-files 1 <.xsl> XSLT 1 < > XSLT Web 51 FileMaker XSLT A <?xslt-cwp-query?> URL 53 URL URL FMPXMLRESULT FMPXMLLAYOUT 81 FileMaker XSLT Web URL &-lay=mylayout&-findall

51 6 FileMaker XSLT 51 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 82 < >://< >[:< >]/fmi/xsl/cnt/data.< >?< > <> < > < > FileMaker XSLT URL : 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 21 Web 1 <data> FileMaker XSLT URL FileMaker XSLT <?xslt-cwp-query?> FileMaker XML 37 FileMaker XML

52 52 FileMaker Server Web with XML and XSLT FileMaker XSLT XSLT -grammar -encoding -process -token XSLT-CWP XSLT XML FileMaker XSLT XML FileMaker Server XSLT Cookie 55 XSLT XSLT -grammar XSLT FileMaker XSLT XML XSLT Web XML fmresultset XSLT 31 fmsresultset FMPXMLRESULT FMPXMLLAYOUT FMPXMLLAYOUT 33 FileMaker XML XSLT Web FMPDSORESULT FileMaker XSLT URL <?xslt-cwp-query?> -grammar URL &-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

53 6 FileMaker XSLT 53 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 XSLT Site Assistant FileMaker XSLT <?xslt-cwp-query params="query string-fragment"?> query string-fragment 名前 = 値 & 名前 2 = 値 db=products -findall = A URL 29 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 XML Web London&-find

54 54 FileMaker Server Web with XML and XSLT -lay=revenue -edit city citylondon Web XML Web XSLT 1. Content-Type charset 2. -encoding URL <?xslt-cwp-query?> -encoding : encoding=shift_jis&-findall 3. Web [ :] Web Shift_JIS Web Admin Console FileMaker Server Web Content-Type charset encoding 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 Admin Console 1 fmxslt:send_ (string SMTP, String, String ) 62 Web <xsl:output> method encoding

55 6 FileMaker XSLT 55 method html textxml html encoding : <xsl:output method="html" encoding="shift_jis"/> <xsl:output> HTML XSLT XML encoding XSLT page 54. UTF-8 <?xml version="1.0" encoding="utf-8"?> Web UTF-8 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 96 -token.[ ] XSLT

56 56 FileMaker Server Web with XML and XSLT -token -token <xsl:param name="request-query" /> 56 FileMaker XSLT FileMaker XSLT fmxslt XSLT <xsl:stylesheet> fmxslt 52 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 49 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"> Web URI 58 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)>

57 6 FileMaker XSLT 57 <!ATTLIST parameter name CDATA #REQUIRED> ] fmq=" XSLT <xsl:stylesheet> fmq 52 FileMaker XSLT &-findall <xsl:param name="request-query" /> Web XML <query action="my_stylesheet.xsl" xmlns=" <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 58 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?

58 58 FileMaker Server Web with XML and XSLT -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 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 xslt-template-files mystylesheets URL document() <xsl:variable name="mydoc" select="document('mystylesheets/mydoc.xml')" /> Web xslt-template-filesmystylesheets mydoc.xml

59 6 FileMaker XSLT 59 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 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 = 'shirts']/fml:value"> <option> <xsl:attribute name="value"><xsl:value-of select="."/></xsl:attribute> <xsl:value-of </option> </xsl:for-each> </select> Web XSLT Web XSLT XSLT FileMaker 1 fmxslt:create_session(): 60 1 fmxslt:set_header(): 63 1 fmxslt:set_status_code (): 63 1 fmxslt:set_cookie(): 64 Cookie FileMaker XSLT <?xslt-cwp-buffer buffer-content="true"?> <?xslt-cwp-buffer?>

60 60 FileMaker Server Web with XML and XSLT 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> 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?> 59 fmxslt:invalidate_session(string - ) fmxslt:set_session_timeout(string -, Number ) Admin Console fmxslt:session_encode_url(string URL) Cookie ID URL URL

61 6 FileMaker XSLT 61 fmxslt:set_session_object(string -, String, Object ) fmxslt:get_session_object(string -, String ) fmxslt:remove_session_object(string -, String ) <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))"/> XSLT - XSLT XSLT XSLT fmxslt:get_session_object () set_session_object() remove_session_object() XSLT XSLT 1 fmxslt:invalidate_session () 1 Admin Console Web XSLT FileMaker Server 1 Web Web

62 62 FileMaker Server Web with XML and XSLT 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 54 <xsl:output> encoding HTML <xsl:output> encoding Web 1 fmxslt:send_ () SMTP URL RFC 2368 mailto = & 1 from=@from 1 to=@ / 1 reply-to=@ 1 cc=@ 1 bcc=@ 1 subject= from reply-to subject false() 1 " tld com net 1 subject SMTPURL & & %20SMTP XML 1 true() false()

63 6 FileMaker XSLT 63 1 Web Shift_JIS Admin Console FileMaker Server 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 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?> 59 vcard.xsl vcard Content-Disposition.vcf <xsl:value-of select="fmxslt:set_header('content-disposition','attachment;filename=test.vcf')" />

64 64 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 " <!ELEMENT cookie (#PCDATA)> <!ATTLIST cookie name CDATA #REQUIRED> 1 Cookie XML " 1 fmxslt:set_cookie Web fmxslt:set_cookie 1 Cookie 1 fmxslt:set_cookie() <?xslt-cwp-buffer?> 59 : 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')" />

65 6 FileMaker XSLT 65 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 Perl 5 fmxslt:regex_contains() Perl 5 fmxslt:regex_contains(string input, String pattern) input pattern Perl 5 Perl 5 fmxslt:regex_contains()

66 66 FileMaker Server Web with XML and XSLT 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 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:attribute name="checked">checked</xsl:attribute> </xsl:if> </input><xsl:value-of select="."/><br/> </xsl:for-each>

67 6 FileMaker XSLT 67 HTML XSLT [Red] [Medium] Web [x] Red [ ] Blue [ ] Green [ ] Small [x] Medium [ ] Large

68 68 FileMaker Server Web with XML and XSLT 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() fm MM/dd/yyyy fmxslt:get_short_date_format() M/d/yy fmxslt:get_long_date_format() MMM d, yyyy fmxslt:get_fm_time_format() fm HH: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 ) fmxslt:compare_time(string, String ) fmxslt:compare_day(string, String ) fm fm

69 6 FileMaker XSLT 69 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 K AM/PM 11 0 h AM/PM m 30 s 55 S 978 z ; PST Z RFC

70 70 FileMaker Server Web with XML and XSLT 1 : 1 : 1 : yyyy/mm/dd12/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 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

71 6 FileMaker XSLT 71 "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 105 FileMaker XSLT XSLT <xsl:message> Web 78 Web Web XSLT JavaScript XSLT. Java 1 bsf.jar - XSLT 1 js.jsr - Mozilla JavaScript XSLT XSLT XPath XSLT Apache Xalan Extensions 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">

72 72 FileMaker Server Web with XML and XSLT <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)} > 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 >&f=l1gh&e=.csv <> 31.79,31.17,32.12 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=" xmlns:fmrs=" xmlns:fmxslt="xalan://com.fmi.xslt.extensionfunctions" xmlns:xalan="

73 6 FileMaker XSLT 73 > 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> <xsl:template match="/fmrs:fmresultset"> <html> <body> <font size="2" face="verdana, arial"> Apple : <xsl:value-of select="fmp-ex:get_quote('aapl')"/> </font> </body> </html> </xsl:template> </xsl:stylesheet> Web Yahoo! Web get_quote()

74 74 FileMaker Server Web with XML and XSLT

75 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 Database Server FileMaker 6. URL XSLT HTML < >://< >[:< >]/fmi/xsl/< >/< >.xsl[?< >] 1 <> HTTP HTTPS 1 < > Web IP 1 < > Web HTTP 80 HTTPS <> XSLT xslt-template-files 1 < >.xsl 1 < > XSLT Web

76 76 FileMaker Server Web with XML and XSLT <?xslt-cwp-query?> URL XSLT home.xsl A URL URL home.xslxslt-template-files my_templates URL Web Web xslt-template-files XSLT Web Web XSLT Site Assistant HTML Web Web Web Web 22 FileMaker Web 1 Web Web Web FileMaker Server URL Web URL 27 XML URL 50 FileMaker XSLT URL

77 7 77 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"/> <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

78 78 FileMaker Server Web with XML and XSLT Web Apache Mac OS : Apache Web Apache W3C Common Logfile Format Web HTTP Apache HTTP Apache Web IIS Windows : 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> 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

79 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

80 80 FileMaker Server Web with XML and XSLT

81 A Web FileMaker -dbnames 84 -delete 85 -dup 85 -edit 85 -find -findall -findany 85 -findquery 86 -layoutnames 86 -new 86 -process XSLT 86 -scriptnames 87 -view 87 -db 87 -encoding XSLT 88 -field op 89 -grammar XSLT 89 -lay 90 -lay.response 90 -lop 90 -max 90 -modid 91 -query 91 -recid 92 -relatedsets.filter 92 -relatedsets.max 92 -script 93 -script.param 93 -script.prefind 93 -script.prefind.param 93 -script.presort 94 -script.presort.param 94 -skip 94 -sortfield.[1-9] 94 -sortorder.[1-9] 95 -stylehref 95 -styletype 96 -token.[ ] XSLT 96 -dbnames -layoutnames -scriptnames -process XSLT -lay 1 -new -new -edit 1 -dbnames -process -db 37 FileMaker XML

82 82 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

83 A 83 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 &ID=9756&Dependents::Names.0=Jane&-new -edit ID ID ID XML <relatedset> <record> record-id 31 fmsresultset URL ID 1001 Dependents NamesNames.2 2 ID &Dependents::Names.2=Kevin&-edit &Dependents::Names.2=Kevin&Dependents::Names.5=Susan&-edit -edit ID : &Dependents::Names.0=Timothy&-ledit

84 84 FileMaker Server Web with XML and XSLT -delete -edit -delete.related URL employees URL Dependents 1001 ID 3 &-delete.related=dependents.3&-edit 87 -delete.related -relatedsets.filter -relatedsets.max 92 -relatedsets.filter 92 -relatedsets.max ::( ).global global 82 FileMaker Pro.global Web XML XSLT XSLT.global Web : -edit -recid XSLT Admin Console Web XSLT FileMaker Server XML XSLT XSLT -grammar -dbnames FileMaker Server XML XSLT Web

85 A 85 : : : -delete -recid : -db -lay -recid : -script : : -dup -recid : -db -lay -recid : -script : : -edit / -recid -recid : -db -lay -recid : -modid -script 83 : : -find -findall -findany : -db -lay : -recid -lop -op -max -skip -sortorder -sortfield -script -script.prefind -script.presort : : FileMaker Server ID :

86 86 FileMaker Server Web with XML and XSLT -findall : -findany : -findquery : -db -lay -query : -max -skip -sortorder -sortfield -script -script.prefind -script.presort : Fluffy &-q1=typeofanimal&-q1.value=cat&-q2=typeofanimal&-q2.value=dog&-q3=name&-q3.value=fluffy&-findquery -findquery -findquery 1 -query findquery -query 91 -query -layoutnames FileMaker Server XML XSLT Web : -db : : -new / : -db -lay : -script 83 : : -process XSLT XSLT XSLT

87 A 87 : -grammar fmresultset FMPXMLRESULT : 55 FileMaker Server XSLT -scriptnames FileMaker Server XML XSLT Web : -db : : -view FMPXMLLAYOUT FMPXMLLAYOUT fmresultset FMPXMLRESULT XML metadata : -db -lay : -script : : : XML XSLT XSLT 51 FileMaker XSLT -db : -db -db : -dbnames -process : -delete.related : -edit : ID

88 88 FileMaker Server Web with XML and XSLT : jobtable 7 ID encoding XSLT XSLT XSLT Web : US-ASCII ISO ISO ISO-2022-JP Shift_JIS UTF-8 : XSLT : &-grammar=fmresultset&-encoding=shift_jis&-findall 54 -field : 28 XML FileMaker URL 51 XSLT FileMaker URL -find / - : FileMaker 1 myfield.9 1 op opmyfield.op 1 global global myfield.global text.fieldhttp XML XSLT 82 ID : -new -edit -find fm fm MM/dd/yyyy HH:mm:ss MM/dd/yyyy HH:mm:ss : -edit : -new -find : &-max=1&-find

89 A 89 FileMaker Server.op -find : begins with eq cn bw ew gt gte lt lte neq FileMaker Pro = * * * * > >= < <=, : -find : ::= & ::.op= 1 1 cn : bw FileMaker Pro... bw... : &-find FileMaker Pro -grammar XSLT XSLT XSLT Web : fmresultset FMPXMLRESULT FMPXMLLAYOUT : XSLT :

90 90 FileMaker Server Web with XML and XSLT &-lay=mylayout&-findall 52 FileMaker XSLT XML -lay : : -dbnames -layoutnames -scriptnames -process XSLT : -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 : -find -findquery : &Birthdate=2/5/1972&-lop=and&-find -max : all all -max : -find -findall -findquery :

91 A 91 -modid ID ID -edit ID ID ID -edit : ID ID FileMaker ID : -edit : -recid : &last_name=jones&-edit -query 86 -findquery : : -findquery -query=< >< >&-findquery < > 1 q : q1 1 AND (q1, q2) q1 and 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 q2);!(q3) &-q1=typeofanimal&-q1.value=cat&-q2=color&-q2.value=gray&-q3=name&-q3.value=fluffy&-findquery

92 92 FileMaker Server Web with XML and XSLT -recid ID -edit -delete -view FMPXMLLAYOUT : ID ID FileMaker : -edit -delete -dup : -find -view : -relatedsets.filter : layout none 1 none 1 layoutfilemaker Pro [] [] 1 [] [] -relatedsets.max 1 [] FileMaker Pro [] [] 1 -relatedsets.filter noneweb : -find -edit -new -dup -findquery : &-relatedsets.max=all&-findany &-relatedsets.max=10&-findany -relatedsets.max : all 1 Web 1 all Web 1 -relatedsets.max -relatedsets.filter 92 -relatedsets.filter : -find -edit -new -dup -findquery : &-relatedsets.max=all&-findany &-relatedsets.max=10&-findany

93 A 93 -script FileMaker 39 XML : : -dbnames -layoutnames -process -scriptnames : -script.param -script FileMaker : 1 param1%7cparam2%7cparam3 URL param1 param2 param3 1 GetAsNumber(Get(ScriptParam)) 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 param1%7cparam2%7cparam3 URL param1 param2 param3 1 GetAsNumber(Get(ScriptParam)) 1 -script.prefind -script.prefind.param -script.prefind.param 1 -script.prefind.param Web : -script.prefind :

94 94 FileMaker Server Web with XML and XSLT &-script.prefind.param=payroll&-findall -script.presort -find FileMaker : -dbnames -layoutnames -process -scriptnames : &-sortfield.1=dept&-sortfield.2=rating&-findall -script.presort.param -script.presort FileMaker : 1 param1%7cparam2%7cparam3 URL param1 param2 param3 1 GetAsNumber(Get(ScriptParam)) 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 : -sortfield : : -find -findall -sortfield -sortfield.= -sortfield. dept rating -sortorder

95 A 95 : &-sortfield.2=rating&-findall -sortorder : <> Custom 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 39 -styletype : : -styletype mystylesheet.xsl Web : &-stylehref=/mystylesheet.xsl&-findall

96 96 FileMaker Server Web with XML and XSLT -styletype XML CSS Cascading Style Sheet XSLT XML type type=text/css type=text/ xsl39 -stylehref : : -stylehref mystylesheet.css Web : &-stylehref=/mystylesheet.css&-findall -token.[ ] XSLT Cookie XSLT XSLT Web -token.[ ] : a z A Z : URL : XSLT : &-grammar=fmresultset&-token.d100=active&-findall 55

97 B Web Web Web 1 XML Web FileMaker 1 Web Web Web 103 Web 1 FileMaker XSLT XSLT fmxslt:check_error_status() 105 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 [ ]

98 98 FileMaker Server Web with XML and XSLT UTF A Z a z 0 9 ASCII

99 B Web ID FileMaker Pro ) FileMaker Pro

100 100 FileMaker Server Web with XML and XSLT EPSF QuickTime 710 QuickTime Excel 716 ODBC DELETE INSERT UPDATE SQL 717 XML/XSLT 718 Xerces XML 719 Xalan XSL XML

101 B Web Excel Excel 7.0 Excel 95Excel XP FileMaker Server FileMaker Pro 807 FileMaker Pro / 810 / 811 FileMaker Pro FMI FileMaker

102 102 FileMaker Server Web with XML and XSLT FileMaker Server XML ( 1205 */ ( * 1213 Let 1214 AVERAGE COUNT EXTEND GETREPETITION MAX MIN NPV STDEV SUM GETSUMMARY 1215 Get 1216 GetSummary

103 B Web 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 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 :

104 104 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