Tracking Volunteers on Club website - Zope and PostgreSQL

Our yacht club has an excellent and very functional website at [[login to view URL]][1]. All the members, events, and participants are in a postgreSQL database which drives all of the events pages. Club events are managed by member Volunteers. We now want to integrate the Volunteer situation into the database. It means we need to add 5-6 new tables, web pages to allow us to manage the data in those tables and to search for volunteers, and we need to integrate that data into our existing event web page structure. The website uses zope dtml code, although we are willing to explore php or another language if it can be made to interface with our existing functionality. The attached word document (37 pages) explains the project. On page 2 it describes the background. Page 3-5 describes the project requirements. Page 11- 16 describe the web pages we need to build. In short, the Volunteer Project is: ** A.** We want to **Capture the Preferences** of each member - what do they like to do? That is a once a year type data collection. ** B.** Once we finish an event, (we have 100+ per year) we want to **Capture the Activity** - who worked on the event, and what did they do? ** C.** On some of the complex events, we want to **Capture** **Committments** before the event. Who promises to help and what do they promise to do. We obviously want to display the needed jobs to the membership, and then allow members to sign up to do a job. Interested parties may apply for a password to our members only section so they can explore a little more about the project before they bid. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform My instance of Zope is on a server Zope Version (Zope 2.6.2 (source release, python 2.1, linux2), python 2.1.3, linux2) Python Version 2.1.3 (#1, Apr 9 2002, 22:27:11) [GCC 2.96 20000731 (Red Hat Linux 7.1 2.96-98)] System Platform linux2