FileMaker Server Custom Web Publishing with XML

Transcription

1 FileMaker Server 12 Web with XML

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

3 7 7 1 Web 8 Web 9 Web 9 Web with PHP 10 Web with XML 10 PHP XML 10 PHP 10 XML 11 2 Web with XML 12 Web Web 12 Web with XML 13 Web 13 Web 13 Web Web Web 15 Web Web MIME ) 16 Web Web 19 FileMaker Web Web 20 Web 21

4 4 4 Web XML 22 Web with XML 22 Web FileMaker Pro XML / 22 Web XML 23 Web XML 24 XML URL 24 XML URL 24 XML FileMaker URL 25 URL 26 Web XML 26 FileMaker XML 27 FileMaker 27 FileMaker 27 fmsresultset 28 fmresultset 28 fmresultset XML 30 FileMaker XML 31 FMPXMLRESULT 31 FMPXMLRESULT XML 32 FMPXMLLAYOUT 33 FMPXMLLAYOUT XML 35 UTF-8 36 FileMaker XML 36 XML 38 XML 38 XML Web 40 Web 40 XML Web 42 Web 42 Web 44 Tomcat 44

5 5 A dbnames 49 -delete 50 -dup 50 -edit 50 -find -findall -findany 51 -findquery ( ) 51 -layoutnames 52 -new 52 -scriptnames 52 -view db 53 -delete.related 53 -field op 55 -lay 56 -lay.response 56 -lop 56 -max 57 -modid ID 57 -query 57 -recid ID 58 -relatedsets.filter 59 -relatedsets.max 59 -script 60 -script.param 60 -script.prefind 61 -script.prefind.param 61 -script.presort 61 -script.presort.param 62 -skip 62 -sortfield 62 -sortorder 63

6 6 B Web 64 XML 64 FileMaker 64 C FileMaker 12 XML 71 XML 71 XML

7 XML Web FileMaker Pro FileMaker Server Web with XML 1 XML Web 1 XML 1 Web Web 1 FileMaker Server XML FileMaker Web FileMaker Server FileMaker Server Web Web with PHP Web with XML FileMaker Server FileMaker Server FileMaker Web FileMaker Server Web with PHP FileMaker Server Web with XML ODBC JDBC FileMaker ODBC JDBC ODBC JDBC

8 1 Web FileMaker Server FileMaker Web Web Web Web Web Web Web FileMaker Pro FileMaker Pro Advanced FileMaker Server Advanced 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 Web with PHP FileMaker Pro PHP FileMaker API for PHP FileMaker PHP Web PHP Web 1 Web with XML XML FileMaker Web FileMaker HTTP URL FileMaker Server XML XML

9 1 Web 9 Web Web Web FileMaker Server FileMaker Server Web Web Web Web FileMaker Server Web with XML Web Web HREF Web FileMaker URL Uniform Resource LocatorWeb XML Web with PHP Web Web FileMaker Server PHP Web FileMaker API for PHP Web FileMaker Server Web fmp12.fmp12 Web Web Web FM API PHP Web Web 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 6. Web Web Web FileMaker Pro PDF

10 1 Web 10 Web with PHP FileMaker API for PHP FileMaker PHP FileMaker API for PHP FileMaker Pro Web API FileMaker Pro PHP Web PHP PHP Web with XML XML FileMaker Web FileMaker Server FileMaker Pro HTTP FileMaker XML XML PHP XML PHP 1 PHP 1 FileMaker API for PHP FileMaker Pro Web 1 PHP 1 PHP 1 PHP Web 1 PHP 1 PHP Web with PHP FileMaker Server Web with PHP

11 1 Web 11 XML 1 FileMaker XML 1 XML W3C 1 XML Unicode 1 XML 1 Web XML FileMaker Pro XML FMPXMLRESULT

12 2 Web with XML Web Web Web XML FileMaker Server Web Web 1 Web FileMaker Web 1 FileMaker XML FileMaker Web 1 FileMaker Web Web FileMaker Web 1 FileMaker Server Web XML Web FileMaker Web XML Web Web 1 1 Web XML URL Web with XML Web with XML FileMaker HTTP FileMaker XML XML 26 Web XML

13 2 Web with XML 13 Web with XML XML FileMaker Server Web 1 FileMaker Server FileMaker Pro 1 JavaScript XML 1 FileMaker Pro Web 16 1 Web FileMaker 65 Web 19 FileMaker Web 1 FileMaker 60 -script.param 61 -script.prefind.param 62 -script.presort.param 1 fmresultset XML relatedset 1 A Web Web Web with XML 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 1 Web 1 Web 1 Web IP

14 2 Web with XML 14 FileMaker Server 1 Web Web 1 FileMaker Server Web IP ISP IP IP IP ISP Web 1 Web FileMaker Server Admin Console FileMaker Server FileMaker Server 1 FileMaker FileMaker Pro Web 15 Web 1 XML FileMaker 26 Web XML

15 3 Web Web Web Web with XML Web with XML Web FileMaker Server Web Web Web 1. FileMaker Pro [ ] [ ] 2. fmxml Web with XML 3. Admin Web with XML 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

16 3 Web 16 1 Web Web Web 1 1 Web [ ] Web 1 FileMaker Pro Web Web [ ] Web FileMaker Pro Web with XML 1 Web 1 Web with XML 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 Pro PDF Web MIME ) MIME Multipurpose Internet Mail Extensions Web Web Web MIME Web

17 3 Web 17 Web FileMaker FileMaker Server 25 XML FileMaker URL Web (.mp3).mov.mp4.avi PDF Web Web PDF [Web ] Web 1. FileMaker ProWeb 2. FileMaker Pro [ ] 3. WebWeb 1 IIS Windows < >: Inetpub wwwroot < > FileMaker Server Web 1 Apache Mac OS / /WebServer/Documents 1 MIME Multipurpose Internet Mail Extensions Web MIME Web Web Web MIME Web 1 QuickTime

18 3 Web 18 FileMaker Pro [ ] FileMaker Server FileMaker Server FileMaker Pro 1. FileMaker Server FileMaker Pro WindowsMac OS 1 Windows 32 [ ]: Program Files FileMaker FileMaker Server Data Databases 1 Windows 64 [ ]: Program Files (x86) FileMaker FileMaker Server Data Databases 1 Mac OS / /FileMaker Server/Data/Databases/ 2. RC_Data_FMS 3. RC_Data_FMS Customers Customers FileMaker Server 4. Mac OS fmsadmin FileMaker Server Web (.mp3).mov.mp4.avi PDF Web Web PDF [Web ]

19 3 Web 19 Web Web 1 Web Web 1 Web FileMaker Web FileMaker Pro Web Web FileMaker FileMaker 65 Web URL Web FileMaker Pro [ ] [ ] [ Web ] Web FileMaker Pro Web 20 Web Web Web wpe.log42 Web 1 Web Web Web 1 Web [ ] 1 [ ] [ ]

20 3 Web 20 1 Web [ ] 1 [ ] 1 [ ] 1 1 FileMaker Pro [ / ] Web Web 1 [ / ] [ ] [ ] [ ] [ / ] Web [ / ] 1 Get( ) Web Publishing Engine Web FileMaker Pro Web Web FileMaker Pro FileMaker Pro / URL Web FileMaker Server Web Web Web 19 Web Web Web Web Web Web Web [ ] Web

21 3 Web 21 / Web [ ] Web [ / ] Web FileMaker Pro Web FileMaker Pro FileMaker Pro 12 [ ] OnFirstWindowOpen OnLastWindowClose

22 4 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 XML XML XML FileMaker Web Web XML XML 1.0 XML XML Web FileMaker Pro XML / Web FileMaker Pro FileMaker XML 1 XML Web fmresultset FMPXMLRESULT FMPXMLLAYOUT FileMaker Pro XML FMPXMLRESULT FMPXMLRESULT 26 Web XML 1 Web XML URL Web FileMaker Pro XML FileMaker Pro 1 Web FileMaker Server FileMaker Pro XML

23 4 Web XML 23 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 Web XML XML Web Web FileMaker XML Web 1. Web Web XML HTTP HTTPS 2. Web Web Web FileMaker Server Web Web 3. Web FileMaker FileMaker Web CWPE Web.fmp12.fmp12 Web FileMaker XML.fmp12.fmp12 FileMaker Web XML Web 6. Web Web Web 5. Web XML Web FileMaker Server Web Web 4. FileMaker Web Web CWPE Web

24 4 Web XML 24 Web XML Web FileMaker XML 1. FileMaker Server Admin Console XML FileMaker Server 2. FileMaker FileMaker Pro XML Web fmxml 15 Web XML [ ] [ ] [ ] XML XML XML 3. HTML HREF Web FileMaker XML FileMaker URL HTTP HTTPS Web Web URL URL XML URL 36 FileMaker XML A 4. Web URL XML Web 5. Web XML Web XML URL Web FileMaker XML URL XML URL Web FileMaker XML URL < >://< >[:< >]/fmi/xml/<xml >.xml[?< >] 1 < > HTTP HTTPS 1 < > Web IP 1 < > Web HTTP 80 HTTPS 443

25 4 Web XML 25 1 <XML > FileMaker XML fmresultset FMPXMLRESULT FMPXMLLAYOUT 28 fmsresultset 31 FileMaker XML 1 < > FileMaker XML -dbnames 36 FileMaker XML A URL URL FMPXMLRESULT FMPXMLLAYOUT 45 Web XML URL XML FileMaker URL XML XML <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 47

26 4 Web XML 26 < >://< >[:< >]/fmi/xml/cnt/data.< >?< > < > < > < > XML URL <data> <data>/images/logo.jpg</data> FileMaker Pro Web Web 17 Web <data> URL XML URL UTF-8 Unicode Transformation 8 Bit 36 UTF-8 infofiancée URL &-lay=relationships&-recid=2&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 XML FileMaker Web FMPXMLRESULT 28 fmsresultset

27 4 Web XML 27 1 FMPXMLRESULT FMPXMLLAYOUT XML FMPXMLRESULT FMPXMLLAYOUT Web XML Web FMPXMLRESULT FMPXMLLAYOUT 31 FileMaker XML 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> Web fmresultset FMPXMLRESULT FMPXMLLAYOUT xmlns=" xmlns=" fmpxmlresult" xmlns=" FileMaker Web XML 0 fmresultset FMPXMLRESULT FMPXMLLAYOUT <error code="0"></error> <ERRORCODE>0</ERRORCODE> <ERRORCODE>0</ERRORCODE> XML B Web FileMaker FileMaker DTD HTTP fmresultset FMPXMLRESULT FMPXMLLAYOUT HTTP >[:< ]/fmi/xml/fmresultset.dtd >[:< ]/fmi/xml/fmpxmlresult.dtd >[:< ]/fmi/xml/fmpxmllayout.dtd

28 4 Web XML 28 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 totalcount 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

29 4 Web XML 29 <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 numeric-only 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

30 4 Web XML 30 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="12/31/2012" 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" notempty="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" notempty="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" 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"> <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>

31 4 Web XML 31 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 28 fmresultset FMPXMLRESULT <METADATA> FIELD <FIELD> / Yes / NoEMPTYOK MAXREPEAT TEXT NUMBER DATE TIME CONTAINER <RESULTSET> <ROW> <ROW> / RECORDID MODID 57 -modid ID <COL> <COL> / <DATA>

32 4 Web XML 32 FMPXMLRESULT XML FMPXMLRESULT XML <?xml version="1.0" encoding="utf-8" standalone="no"?> <!DOCTYPE FMPXMLRESULT PUBLIC "-//FMI//DTD FMPXMLRESULT//EN" "" <FMPXMLRESULT xmlns=" <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="12/31/2012" 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>

33 4 Web XML 33 FMPXMLLAYOUT FMPXMLLAYOUT <FIELD> <LAYOUT> <FIELD> VALUELIST <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>

34 4 Web XML 34 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 birthdaysbirthdate birthdate fm

35 4 Web XML 35 FMPXMLLAYOUT XML FMPXMLLAYOUT XML <?xml version="1.0" encoding="utf-8" standalone="no"?> <!DOCTYPE FMPXMLLAYOUT PUBLIC "-//FMI//DTD FMPXMLLAYOUT//EN" "" <FMPXMLLAYOUT xmlns=" <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="12/31/2012" 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>

36 4 Web XML 36 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 1 UTF-8 ASCII Unicode UTF-8 Unicode 50% FileMaker XML FileMaker XML FileMaker URL -findall products FileMaker -new -dbnames -db URL FileMaker 45 -dbnames -delete -dup -edit -find -findall -findany -findquery Web

37 4 Web XML 37 -layoutnames -new -scriptnames -view Web 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 -edit URL 25 XML FileMaker URL -edit -find 54 -find -dbnames -layoutnames -scriptnames -dbnames -layoutnames -scriptnames -find -find -findall -findquery -edit -findquery -edit -delete -dup -find -find -findall -findany -edit -new -dup -findquery -find -edit -new -dup -findquery -find -findall -findany -new -edit -delete -dup -view -findquery -script -findquery -find -findany -findall -findquery -script.prefind -findquery -find -findall -findquery -script.presort -findquery -find -findall -findquery -find -findall -findquery -find -findall

38 4 Web XML 38 XML -lay XML XML XML XML -lay.response Budget Salary 100,000 ExecList Salary -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 script 8. -lay.response 9. XML -sortfield 102

39 4 Web XML 39 XML Web XML 1 XML Web 15 Web 1 FileMaker Server FileMaker Server FileMaker Server 1 1 FileMaker Server Web 1 FileMaker Server Web 1 Web XML FileMaker Server

40 Web 1. 3 Web 2. XML FileMaker Server Admin Console FileMaker Server 3. Web Web 4. Web 1 FileMaker Server FileMaker 1 FileMaker Pro Web Web 1 FileMaker Server 18 RC_Data_FMS 5. Web Web Web XML Web 1 1

41 Web 19 FileMaker Web 1 Web Web Web FileMaker Server URL Web URL 24 XML URL 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 <?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>

42 5 42 Web Web 1 Web 1 Web 1 Web 1 Tomcat IIS WindowsMicrosoft IIS Web Windows W3C Extended Log File Format Web HTTP W3C Common Logfile Format Microsoft IIS Web Apache Mac OSApache Web Apache W3C Common Logfile Format Web HTTP Apache HTTP Apache Web W3C Common Logfile Format W3C Extended Log File Format World Wide Web Consortium Web Web Web wpe.log Web XML Web Web Web wpe.log FileMaker Server Web 1 IIS Windows < >: Program Files FileMaker FileMaker Server Logs wpe.log < > 1 Apache Mac OS/ /FileMaker Server/Logs/wpe.log

43 5 43 Web wpe.log [ Web ] Admin Console wpe.log Web Web Web XML [ ] Admin Console FileMaker Server FileMaker Server 12 Web wpc_access_log.txt pe_application_log.txt wpe.log wpe.log Admin Console wpe.log wpe.log Web wpe.log 1 wpe.log.1 wpe.log wpe.log.1 Web wpe.log [TIMESTAMP_GMT] [WPC_HOSTNAME] [CLIENT_IP:PORT] [ACCOUNT_NAME] [MODULE_TYPE] [SEVERITY] [FM_ERRORCODE] [RETURN_BYTES] [MESSAGE] 1 [TIMESTAMP_GMT] (GMT) 1 [WPC_HOSTNAME] Web 1 [CLIENT_IP:PORT] XML IP 1 [ACCOUNT_NAME] FileMaker 1 [MODULE_TYPE] Web with XML XML Web with PHP PHP 1 [SEVERITY] INFO ERROR 1 [FM_ERROR_CODE] FileMaker 62 FileMaker HTTP: HTTP 1 [RETURN_BYTES] 1 [MESSAGE]

44 5 44 Web wpe.log 1 Web :15: INFO - - FileMaker Server Web Publishing Engine started :46: INFO - - FileMaker Server Web Publishing Engine stopped. 1 XML :21: WPC_SERVER :0 jdoe XML INFO "/fmi/xml/fmresultset.xml?-db=contacts&-lay=contact_details&-findall" :26: WPC_SERVER :0 jdoe XML ERROR "/fmi/xml/fmresultset.xml?-db=contacts&-layout=contact_details&-findall" :33: WPC_SERVER :0 jdoe - ERROR 4 - Web Scripting Error: 4, File: "10b_MeetingsUpload", Script: "OnOpen", Script Step: "Show Custom Dialog" 1 Web :59: WPC_SERVER :0 jdoe - INFO - - XML Web Publishing Engine is enabled :30: WPC_SERVER :0 jdoe XML ERROR - - Communication failed Web Web Web web_server_module_log.txtweb FileMaker ServerLogs Web FileMaker Server Tomcat Tomcat FileMaker Server Web 1 IIS Windows< >: Program Files FileMaker FileMaker Server Admin admin-master-tomcat logs < > 1 Apache Mac OS/ /FileMaker Server/Admin/admin-master-tomcat/logs/

45 Web FileMaker -dbnames 49 -delete 50 -dup 50 -edit 50 -find -findall -findany 51 -findquery 51 -layoutnames 52 -new 52 -scriptnames 52 -view 53 -db 53 -field 54 fieldname 54 fieldname.op 55 -lay 56 -lay.response 56 -lop 56 -max 57 -modid 57 -query 57 -recid 58 -relatedsets.filter 59 -relatedsets.max 59 -script 60 -script.param 60 -script.prefind 61 -script.prefind.param 61 -script.presort 61 -script.presort.param 62 -skip 62 -sortfield.[1-9] 62 -sortorder.[1-9] 63 -dbnames -layoutnames -scriptnames -lay 1 -new -new -edit 1 -dbnames -db 36 FileMaker XML 1 -db=employees -findall =

46 A 46 1 Web -lop=and, -lop=or, -sortorder=ascend, -sortorder=descend, -max=all 1 MyLayout -lay=mylayout 1 1 myfield.9 1 op opmyfield.op 1 global global myfield.global HTTP XML ID 1 -find Field1=Blue Field1=blue -new -edit LastName=Doe Web XML 1. -database 2. -find&-edit 3. -lop=amd 4. (-db ) 5. (-lay ) lop -delete -lop B Web

47 A 47 table-name::field-name(repetition-number).record-id 1 table-name 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 &-lay=family&firstname=john&lastname=doe&id=9756&dependents::names.0=jane&-new 1

48 A 48 -edit ID ID ID XML <relatedset> <record> record-id 28 fmsresultset URL ID 1001 Dependents NamesNames.2 2 ID &-recid=1001&dependents::names.2=kevin&-edit &-recid=1001&dependents::names.2=kevin&dependents::names.5=susan&-edit -edit ID &-recid=1001&dependents::names.0=timothy&-edit -delete -edit -delete.related URL employees URL Dependents 1001 ID 3 &-recid=1001&-delete.related=dependents.3&-edit 53 -delete.related -relatedsets.filter -relatedsets.max 59 -relatedsets.filter 59 -relatedsets.max :: ( ).global

49 A 49 global 47 FileMaker Pro.global Web XML.global Web &Country.global=USA&-recid=1&-edit XML -dbnames FileMaker Server Web with XML

50 A 50 -delete -recid -db -lay -recid -script -dup -recid -db -lay -recid -script -edit / -recid -recid -db -lay -recid -modid -script 48

51 A 51 -find -findall -findany -db -lay -recid -lop -op -max -skip -sortorder -sortfield -script -script.prefind -script.presort FileMaker Server ID -findall -findany -findquery ( ) -db -lay -query -max -skip -sortorder -sortfield -script -script.prefind -script.presort Fluffy &-query=(q1);(q2);!(q3)&-q1=typeofanimal&-q1.value=cat&-q2=typeofanimal &-q2.value=dog&-q3=name&-q3.value=fluffy&-findquery -findquery -findquery 1 -query q-q1 1 -q1.value=fieldvalue 1 fieldvalue begins with -q1.value=fieldvalue*

52 A findquery -query 57 -query -layoutnames FileMaker Server Web with XML -db -new / -db -lay -script scriptnames FileMaker Server Web with XML -db

53 A 53 -view FMPXMLLAYOUT FMPXMLLAYOUT fmresultset FMPXMLRESULT XML metadata -db -lay -script XML -db -db -db -dbnames -delete.related -edit ID jobtable 7 ID 20

54 A 54 -field 24 XML URL -find / - FileMaker 1 myfield.9 1 op opmyfield.op 1 global global myfield.global text.fieldhttp XML 47 ID -new -edit -find fm fm MM/dd/yyyy HH:mm:ss MM/dd/yyyy HH:mm:ss -edit -new -find max=1&-find FileMaker Server

55 A 55.op -find begins with eq FileMaker Pro = cn * * bw * ew gt gte lt lte neq * > >= < <= -find :: = & ::.op= 1 1 cn bw FileMaker Pro... bw... lay=departments&idnum= &idnum.op=bw&-find FileMaker Pro

56 A 56 -lay -dbnames -layoutnames -scriptnames -lay.response -lay XML -lay.response -lay.response -lay XML -lay.response -dbnames -layoutnames -scriptnames &-lay=budget&salary=100000&salary.op=gt&-find&-lay.response=execlist -lop -find and or and or -lop -find and -find findquery &-lay=departments&last+name=smith&birthdate=2/5/1972&-lop=and&-find

57 A 57 -max all -max -find -findall -findquery?max 59 -relatedsets.max -modid ID ID -edit ID ID ID -edit ID ID FileMaker ID -edit -recid modid=6&last_name=jones&-edit -query 51 -findquery ( ) -findquery -query=< >< >&-findquery < > 1 qq1 1 AND (q1, q2) q1 q2 q and

58 A 58 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 -recid ID -edit -delete -view FMPXMLLAYOUT ID FileMaker -edit -delete -dup -find -view

59 A 59 -relatedsets.filter layout none 1 -relatedsets.filter layout FileMaker Pro [ ] [ ] 1 [ ] [ ] -relatedsets.max -relatedsets.max 1 [ ] -relatedsets.max [ ] [ ] 1 none-relatedsets.filter none Web [ ] [ ] [ ] 1 -relatedsets.filter XML -relatedsets.filter layout none FileMaker Pro 1 [ ] [ ] XML [ ] -find -edit -new -dup -findquery &-relatedsets.filter=none&-findany &-lay=english&relatedsets.filter=layout&-relatedsets.max=all&-findany &-relatedsets.filter=layout&-relatedsets.max=10&-findany -relatedsets.max all 1 -relatedsets.max [ ] FileMaker Pro [ ] -relatedsets.filter layout 1 -relatedsets.max Web 1 -relatedsets.max all Web -relatedsets.filter

60 A 60 -find -edit -new -dup -findquery &-lay=english&relatedsets.filter=layout&-relatedsets.max=all&-findany &-relatedsets.filter=layout&-relatedsets.max=10&-findany -script FileMaker 38 XML dbnames -layoutnames -scriptnames -script.param -script FileMaker 1 param1 param2 param3 param1%7cparam2%7cparam3 URL 1 GetAsNumber(Get( )) 1 -script -script.param -script.param 1 -script.param Web -script &-lay=departments&-script=myscript&-script.param=smith%7cchatterjee%7csu &-findall

61 A 61 -script.prefind -find FileMaker -dbnames -layoutnames -scriptnames &-lay=departments&-script.prefind=myscript&-findall -script.prefind.param -script.prefind FileMaker 1 param1 param2 param3 param1%7cparam2%7cparam3 URL 1 GetAsNumber(Get( )) 1 -script.prefind -script.prefind.param -script.prefind.param 1 -script.prefind.param Web -script.prefind &-lay=departments&-script.prefind=myscript&-script.prefind.param=payroll &-findall -script.presort -find FileMaker -dbnames -layoutnames -scriptnames &-lay=departments&-script.presort=myscript&-sortfield.1=dept &-sortfield.2=rating&-findall

62 A 62 -script.presort.param -script.presort FileMaker 1 param1 param2 param3 param1%7cparam2%7cparam3 URL 1 GetAsNumber(Get( )) 1 -script.presort -script.presort.param -script.presort.param 1 -script.presort.param Web -script.presort &-lay=departments&-script.presort=myscript&-script.presort.param=18%7c65 &-sortfield.1=dept&-sortfield.2=rating&-findall -skip -find sortfield -find -findall -sortfield -sortfield. = -sortfield. precedence-number

63 A 63 dept rating -sortorder &-lay=performance&-sortfield.1=dept&-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 &-lay=performance&-sortfield.1=dept&-sortorder.1=ascend&-sortfield.2=rating &-sortorder.2=descend&-findall -sortorder

64 B Web Web XML FileMaker ( XML Web XML XML fmresultset <error code> FMPXMLRESULT FMPXMLLAYOUT <ERROCODE> 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 FileMaker [ ] 6 7 8

65 B Web UTF A Z a z 0 9 ASCII

66 B Web ID FileMaker Pro ) FileMaker Pro

67 B Web EPSF QuickTime 710 QuickTime Excel 716 ODBC DELETE INSERT UPDATE SQL 717 XML/XSL 718 Xerces XML 719 Xalan XSL XML Excel Excel

68 B Web Bento FileMaker Server FileMaker Pro 807 FileMaker Pro / 810 / 811 FileMaker Pro FMI FileMaker FileMaker Server

69 B Web XML Web ( 1205 */ ( * 1213 Let 1214 AVERAGE COUNT EXTEND GETREPETITION MAX MIN NPV STDEV SUM GETSUMMARY GetSummary

70 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 1414 SQL 1450 PHP SMTP 1502 SMTP 1503 SSL 1504 SMTP 1505 SMTP 1506 E 1507 SMTP SSL URL 1631

71 C FileMaker 12 XML FileMaker 12 XML XML FileMaker process FileMaker encoding 1 -grammar 1 -stylehref 1 -styletype 1 -token.[string] XML FileMaker 12 Web 46 FileMaker 12 -script -find performfind FileMaker 11 -db=customers&-lay=account&-script=performfind&-find FileMaker FileMaker 12 -findall -db=customers&-lay=account&-findall&-script=performfind FileMaker 12 Web 1 -lop -delete -db=test&-lay=test&-recid=82&-delete&f1=hi&-lop=and -lop and 1 : -dbnames&-dbnames Web -find&-edit

72 C FileMaker 12 XML 72 1 FileMaker 11 1 FileMaker 11 1 field.op -find FileMaker 11 field.op 1 -findany -findall recid -find -findquery -delete -dup 1.global FileMaker 12 Web 1 -findall -findany -find -findquery -new -edit -dup 1 1 neq.op or -lop -find FileMaker find FileMaker 11 1 FileMaker 11 1 [ ] recid FileMaker 11 FileMaker 11 FileMaker 12 -db=basicfinds&-lay=layoutone&-max=-1&-findall -db=basicsorts&-lay=layoutone&-sortfield.=textfield&-findall -db=relfinds &-lay=layoutone&aliasdoesntexist::relatedtextfield=sometext&-find -db=basicsorts&-lay=layoutone&-sortfield.1=&-findall -find -db=basicedits&-lay=layoutone&-find -find -db=basicfinds&-lay=layoutone&globaltextfield.global=sales&-find FileMaker 11 FileMaker

73 A Admin Console 16, 24 auto-enter 29 C CWPE Web 23 D <datasource> 28 -dbnames 49 -db 53 -delete.related 48 -delete 50 -dup 50 E -edit 50 -encoding FileMaker <error code> <ERRORCODE> 64 Extensible Markup Language XML 22 F <field-definition> 29 -field 54 FileMaker 12 -encoding 71 -grammar 71 -process 71 -stylehref 71 -styletype 71 -token 71 FileMaker API for PHP FileMaker Pro Web 22 FileMaker Server 7 7 FileMaker Server Admin Console 16, 24 -findall 51 -findany 51 -findquery 51 -find 51 FMPXMLLAYOUT 33 35, FMPXMLRESULT 22, fmresultset 22, four-digit-year 29 G global 29 -grammar FileMaker H HTML XML 24 J JDBC 7 L -lay.response 38, 56 -layoutnames 52 -lay 38, 56 -lop 56 M max-characters 29 max-repeat 29 -max 57 <metadata> 29 MIME Multipurpose Internet Mail Extensions16 -modid 57 N name 29 -new 52 not-empty 29 numeric-only 29 O ODBC 7 P PDF 7 PHP 10 -process FileMaker 12 71

74 74 Q -query 57 QuickTime Web 17 R -recid 58 <relatedset-definition> 29 -relatedsets.filter 59 -relatedsets.max 59 <resultset> 29 result 29 S SAT FileMaker Server Admin Console 16 -script.param 60 -script.prefind.param 61 -script.prefind 61 -script.presort.param 62 -script.presort 61 -scriptnames 52 -script 60 -skip 62 -sortfield 62 -sortorder 63 SSL Secure Sockets Layer16 -stylehref FileMaker styletype FileMaker T time-of-day 29 -token FileMaker Tomcat 44 type 29 U Unicode 36 URL XML 25 XML 24 URL 26 UTF-8 Unicode Transformation 8 Bit 26, 36 W web_server_module_log.txt 44 Web XML 23 Web 23 Web Admin Console 24 XML Web 9 Web MIME 16 XML Web 42 Web FileMaker 7 Web Web 42 Web QuickTime 17 XML Web 17 Web XML 23 Web 19 Web Web 15 Web 15 V -view 53

75 75 X XML FMPXMLLAYOUT 33 FMPXMLRESULT 31 fmresultset 28 <datasource> 28 <field-definition> 29 <metadata> 29 <relatedset-definition> 29 <resultset> 29 URL 26 UTF-8 27, 36 XML XML 24 XML 39 36, , 36 DTD 27, 28, XML XML 38 XML 38 XML fmxml 15, 24 XML 24 XML 22 XML 22 XML 38 XML ASCII 36 XML 11 XML 26 XML 38 XML 38 <xsl:stylesheet> 41 <xsl:template> 41 Web Web Web Web URL 26 XML 27, Web 19 XML URL Web 8 Web PHP 10 Web 16 Web IP 16 Web 15 XML 10, IP Web with PHP 10 Web with XML 10 Web 13 Web 13

76 76 Web 15 Web 15, , 45 XML 36, , Web [ ] XML Web , 41 8 IP Web 15 URL 26 XML 27 XML 24 Web 40 XML , 14 XML 39 Web Web XML 27 Web 15 Web 15 [ ] [ ] op , 18 DTD 27, 31

77 Web 15 Web 15 FMPXMLLAYOUT 33 FMPXMLRESULT 31 fmresultset 28 FMPXMLLAYOUT 35 FMPXMLRESULT 32 fmresultset 30 XML Tomcat 44 web_server_module_log.txt 44 Web 42 42