FileMaker Server 17とINTER-MediatorによるWebアプリ開発

FileMaker Server 17ͱINTER-Mediator ʹΑΔWebΞϓϦ։ൃ 2018/11/08 INTER-Mediator Meet-up 2018 দඌ ಞʢ‫ࣜג‬ձࣾΤϛοΫʣ

Agenda • FileMakerʴWeb • σʔλϕʔε઀ଓखॱͷ֓ཁ • αϯϓϧΞϓϦͷσϞͱ঺հ

FileMakerʴWeb

FileMakerʴWebͷχʔζ • ࣾ಺ͰFileMakerϓϥοτϑΥʔϜΛ࢖ͬ ͍ͯΔ͕࣍ͷΑ͏ͳέʔε͕͋Δ ྫɿࣾ಺‫ۀ‬຿ͷҰ෦Λࣾ֎͔ΒͰ͖ΔΑ ͏ʹ͍ͨ͠৔߹ ྫɿࣾ֎ͷऔҾઌͱ΍ΓͱΓ͍ͨ͠৔߹

FileMaker੡඼ͱ࠷ۙͷಈ޲ • ೥ʹ1౓ͷόʔδϣϯΞοϓ ηΩϡϦςΟߋ৽͸‫ݪ‬ଇ࠷৽൛ͷΈ • ϥΠηϯεମ‫ܥ‬ͷසൟͳมߋ Ҏલͱൺֱ͢ΔͱՁ֨΋࣍ୈʹ্ঢ • Ϋϥ΢υ΁ͷ؇΍͔ͳγϑτ FileMaker Cloudͷී‫ٴ‬͸͜Ε͔Β

INTER-MediatorͰWebΞϓϦ • ҆શͳ࠷৽൛ʹࣗಈߋ৽ Webϒϥ΢βʔͰ͋Ε͹ࣗಈతʹߋ৽ • ઀ଓϥΠηϯεͷίετ࡟‫ݮ‬ ΧελϜWebͳΒαʔόʔ઀ଓϥΠηϯεෆཁ • ΧελϜWebͱData APIʹ྆ରԠ ΋͠΋ΧελϜWeb͕ඇਪ঑ʹͳͬͨͱͯ͠΋ FileMaker Data APIʹҠߦͰ͖Δ

FileMakerʴWebΞϓϦ • FileMakerʹWebΞϓϦΛϓϥε • ࠓ͋Δ΋ͷʹϓϥε͍͚ͯ͠͹΋ͬͱ ੈք͕޿͕Δ • ίετ௿‫ݮ‬ख๏ͷ1ͭͱ͍͏ଆ໘΋

σʔλϕʔε઀ଓ खॱͷ֓ཁ

Step1 σʔλϕʔεΛ༻ҙ FileMaker ServerͰϗετ ΞΧ΢ϯτઃఆ΍XML Webެ։ͰͷΞΫηεΛ‫ڐ‬Մ͢Δઃఆ΋ඞཁ

FileMaker Server΁ͷ઀ଓ • FileMaker ServerͷΧελϜWebެ։‫ػ‬ೳ Λར༻ʢXML Webެ։ʣ • XML Webެ։ͰͷΞΫηεΛ‫ڐ‬Մ͢Δ ઃఆ͕ඞཁ • ֦ுΞΫηε‫ݖ‬ͷΩʔϫʔυ͸fmxml

New! • INTER-Mediator 5.8ͰFileMaker Server 17 ͷFileMaker Data APIΛαϙʔτ • ֦ுΞΫηε‫ݖ‬ͷΩʔϫʔυ͸fmrest

Step2 ఆٛϑΝΠϧΛ࡞੒ ϑΝΠϧ໊ɿinclude.phpʢྫʣ  QIQ
SFRVJSF@PODF EJSOBNF @@'*-&@@

*/5&3.FEJBUPS*/5&3.FEJBUPSQIQ 
*.@&OUSZ




BSSBZ








BSSBZ












SFDPSET














QBHJOH

USVF












OBNF

λεΫৄࡉ


ϨΠΞ΢τ໊


















BSSBZ




BSSBZ




GBMTF


FileMaker Server Ͱͷ‫ݻ‬༗ͷࣄ৘ • ఆٛϑΝΠϧʹ‫ه‬ड़͢Δςʔϒϧ໊͸ ϨΠΞ΢τ໊Λࢦఆ͢Δ • දࣔ΍ೖྗʹඞཁͳϑΟʔϧυΛඞͣ ϨΠΞ΢τ্ʹ഑ஔ͢Δ

FileMaker Server Ͱͷ‫ݻ‬༗ͷࣄ৘ • ೔෇ɺ࣌ࠁ͓ΑͼλΠϜελϯϓϑΟʔ ϧυʹ͍ͭͯ͸FMDateTimeσʔλί ϯόʔλʔΛར༻͢Δ

Step3 ϖʔδϑΝΠϧΛ࡞੒ ϑΝΠϧ໊ɿindex.htmlʢྫʣ %0$5:1&
IUNM
IUNM
MBOHKB




IFBE








NFUB
DIBSTFU65'








NFUB
IUUQFRVJW96"$PNQBUJCMF
DPOUFOU*&FEHF








UJUMF*/5&3.FEJBUPS
4BNQMFUJUMF








MJOL
SFMTUZMFTIFFU
UZQFUFYUDTT
ISFG*/5&3.FEJBUPS4BNQMFT TBNQMFDTT








TDSJQU
UZQFUFYUKBWBTDSJQU
TSDJODMVEFQIQTDSJQU




IFBE




CPEZ








UBCMFUSUEJOQVU
UZQFUFYU
OBNFUBTLOBNF
EBUBJNλεΫৄࡉ!λε ΫUEUSUBCMF




CPEZ
IUNM

Step4 IMΛμ΢ϯϩʔυ • GitHub͔ΒVer. 5.8Λμ΢ϯϩʔυ • ʮINTER-Mediatorʯͱ͍͏ϑΥϧμ໊Ͱ index.htmlϑΝΠϧͱಉ͡֊૚ʹ഑ஔ ʢࢀߟʣdist-docsϑΥϧμ಺ʹ͸buildup.shͱ͍͏ σϓϩΠ༻ϑΝΠϧΛੜ੒͢ΔεΫϦϓτ͕ଘࡏ

Step5 DB઀ଓ৘ใͷઃఆ ϑΝΠϧ໊ɿparams.php ʢࠓճ͸INTER-MediatorϑΥϧμ಺ͷϑΝΠϧΛฤूʣ  QIQ



DPNNPO
TFUUJOHT
GPS
%#@'JMF.BLFS@'9
BOE
%#@1%0


EC6TFS


EC1BTTXPSE






%#@'JMF.BLFS@'9
BXBSF
CFMPX


EC4FSWFS


EC1PSU


EC%BUBCBTF

λεΫ
EC1SPUPDPM

IUUQ

αϯϓϧΞϓϦͷ σϞͱ঺հ

σϞ༻αϯϓϧΞϓϦ (1)

σϞ༻αϯϓϧΞϓϦ (1) • BootstrapΛར༻ͯ͠ϖʔδΛ࡞੒ • Ұ෦ͷ‫ػ‬ೳ͸JavaScriptͰ࣮૷

σϞ༻αϯϓϧΞϓϦ (2) • αʔόʔαΠυεΫϦϓτΛ࢖༻ͯ͠ ಈతʹੜ੒ͨ͠PDFϑΝΠϧΛදࣔ • FileMaker Server 16Ҏ߱ͰՄೳ • σʔλϕʔεͷϨΠΞ΢τΛ‫༻׆‬ • ϑΥϯτ͸IPAϑΥϯτΛར༻

INTER-MediatorΛ ར༻ͨ͠αʔϏεྫ

*/5&3.FEJBUPSΛར༻ͨ͠αʔϏεྫ '.1SFTT
1VCMJTIFS
w w 'JMF.BLFSσʔλϕʔε͔Β8FCΞϓϦΛੜ੒
σϞαΠτɿIUUQTEFNPFNJDDPKQ

• https://demo.emic.co.jp

*/5&3.FEJBUPSΛར༻ͨ͠αʔϏεྫ

*/5&3.FEJBUPSΛར༻ͨ͠αʔϏεྫ

*/5&3.FEJBUPSΛར༻ͨ͠αʔϏεྫ

·ͱΊ • FileMakerʴWebͳΒINTER-Mediator • INTER-MediatorͰͷσʔλϕʔε͝ͱͷ ‫ݻ‬༗ͷࣄ৘ʹ͍ͭͯ͸Լ‫ه‬Λࢀর • http://inter-mediator.info/ja/fordevelopers/db.html

• http://inter-mediator.info/ja/for-developers/db.html