Project Detail
Need PHP MySQL expert for small library project
Need PHP MySQL expert for small library project is project number 427953
posted at Freelancer.com. Click here to post your own project.
Status: Cancelled
Selected Providers: -
Budget: $250-750
Created: 05/01/2009 at 15:50 EDT
Bid Count: 36
Average Bid:
$ 475
05/08/2009 at 15:50 EDT
Project Creator:
jhawks
Employer Rating: 
(1 reviews)
Description
Need PHP MySQL expert, preferably with experience modifying OpenBiblio. Additional skills include scripting/scraping web pages.I previously posted this same project and did not get the response I was expecting. I really need the help and hope that someone has the necessary skills and talent to successfully complete these tasks.
I'm setting up a small library system for a nonprofit group. We need a few additional fields added to the database and adjustments to several of the the PHP pages to reflect the additional data.
Eventually, this application will be tied into their organization's member database, but for now I just need a table to populate some key pieces of data from their member database.
1. Additional table to accommodate key data from organization's member - CMBMember
Organization's member ID – primary key - CMBID
Member name
Member address
Member phone
Member email
CMBID will need to be added to member table.
2. New member page - openbiblio/circ/mbr_new_form.php
Retrieve record from CMBMember by name or CMBID
Add additional info before saving (card number, classification, etc) in member table.
3. Update member information section with additional CMBID –
openbiblio/circ/mbr_view.php
4. Add 3 fields to bibliographic records:
* language
* publication catalog ID
* content summary
These fields will need to be added to necessary tables and PHP pages updated
openbiblio/catalog/biblio_new.php
others?
5. Search results should show language and content summary as well as current return results.
openbiblio/shared/biblio_search.php
6. It would be nice to also include cover art for each book/CD/DVD in serach results, but not necessary. (Right now a generic material icon appears.)
Additional requirements/requests/information
1. There are a couple of extensions I use with this software (Amazon search and Z39.50), plus I have configured the classifications and a few other categories. I can send you a MySQL dump to use after you have installed the software on your machine or you can work from my hosting site.
2. I can run the Amazon search and Z39.50 extensions from my laptop but not from my hosting site. The Z39.50 extension won't work without YAZ, and the hosting service won't install it. Not that big of a problem... I can use it locally then upload the MySQL dump on the site. But the Amazon search extension is giving a PHP error, so I'm not sure what is going on. It would be great if you could trouble shoot this and correct it. Otherwise, I will just work locally and transfer the records to site.
3. Help populating the bibliographic records. I'm hoping that you can write a script or instruct me how I can populate many of the records without having to do each one manually. The information I'm trying to pull together comes from a number of sources.
The organization I am doing this for has an excel spreadsheet from their main publisher that has the following information:
* catalogID
* title
* author
* category (not needed)
* price
I am trying to get a more complete list from the publisher which would include ISBN numbers, descriptions, and such. But if I do not get a response, perhaps you could scrape their website for the data.
Some books and DVDs have multiple volumes assigned to the same catalogID. They will need to be split out as individual volumes for the bibliographic records.
Perhaps some other sites such as Amazon, WorldCat, Library of Congress Online Catalog, can be scraped as well.
There isn't a huge amount of materials - probably less than 500 books, CDs, and DVDs.
You do not need to give me the script. It does not need to be run more than once. I basically am just looking for you to find a way to help me populate complete records as quickly as possible.
I am hoping that you can complete the updates within a week to 10 days. I will then test everything from my hosting site and my local machine to make sure everything works as requested.
My hosting site uses MySQL 5.0.67 / PHP 5.2.
|
Job Type |
|
Provider Rating
WHAT IS FREELANCER.COM?
Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!
We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started!
Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.
- Plendo Sweden AB © 2004-2009
- PRIVACY POLICY
- TERMS
- AFFILIATES
- API
- QUOTES
- CONTACT
Freelancer™ is a trademark of Ignition Networks Pty Limited (ACN 134 845 748)
Newly Outsourced Projects fed by 
Follow our Freelance Jobs on Twitter 
Add to your
Google search results
Digital Imaging Software * Webmaster Resources * Webmaster Forum