Learn and test Filemaker 9 PHP API and/or MySQL PHP API for client and internal use of Filemaker 9 databases. Develop all essential methods and scripting, replicating filemaker app functionality: portals, searching, running filemaker scripts, variable handling, security, printing, containers, etc. The immediate benefits of this RND are for the Alliancedb project, as well as TSPs internal database. The next phase of this RND will include actual TSP development.
Recommended hours: 30, including 8hrs spent already Mar 31, Apr 1.
Step 3 & 4 complete
Submitted complete plan:
.5 Install FMP 9,
.5 Examined instant web publishing
.5 Created test FMP database for publishes
1 Attempted using PHP converter tool from FMP
1 Books and documentation gathering
.5 Testing and installing of PHP converted database
2 PHP 5 and FMP bugs, updated FMP, modified FMP web engine
2 attempted running FMP scripts through PHP API
And to continue...
4 Create SOP for running FMP scripts by passing record ID's and executing scripts
6 portal composing, viewing, related record creation
3 Create SOP for login, user home pages, and user variables
3 Variable passing and usage. Figure out how to bypass no global variable usage
6 (I haven't begun to see how complicated these really may be) Session ID, value lists, wildcard searching, emaling
*milestone - a database that you can log in to, see a portal, have user variables, have value lists created from filemaker, create records and see them in a portal, search, and have modifications sent in an email.
Step 1/2 approval
Approved by John and Mike for initial 3 hours complete plan development, along with work order submission for initial 8 hours, pending plan development.