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.
Implementation of TSP site
Following demo/proof of concept showing the development of the nuts and bolts of a tsp-like system, the next phase is deployment on the actual TSP databases. Deliverable will be a working TSP database with basic fields.
Recommended hours 20hrs for this build phase
Approval
Approved.
*milestone - Ability to browse, post, and view issue tracking tickets; by status (new, taken etc), by techie who claimed, by customer, and by specific ticket number.
*optional milestone (time dependent) - Be able to browse proposals.
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.