PHP MySQL expert, preferably with experience modifying OpenBiblio

Cancelled

Description

Need PHP MySQL expert, preferably with experience modifying OpenBiblio. Additional skills include scripting/scraping web pages.

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/[url removed, login to view]

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/[url removed, login to view]

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/[url removed, login to view]

others?

5. Search results should show language and content summary as well as current return results.

openbiblio/shared/[url removed, login to view]

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 [url removed, login to view]), 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 [url removed, login to view] extensions from my laptop but not from my hosting site. The [url removed, login to view] 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 [url removed, login to view] / PHP 5.2.

Skills: PHP, Website Design

See more: mysql openbiblio, write my book online, write card online, what software do i need to write a book, what's needed to write a book, what can you do with php, what are organization skills, web search how do i find this online, web pages icon, web expert online, web design without hosting, web design uses language, web content dump, web content classification, test your php skills, test excel expert, software to help write a book, site scraping online, search system icon, search for books by isbn number, search for a book online by author, script to pull data from a website, scraping web content, pull data from website into excel, problem summary

Project ID: #425653

4 freelancers are bidding on average $150 for this job

dagdya99

Lets start

$199 USD in 9 days
(104 Reviews)
6.5
subhrajitweb6ix

Dear Sir or Madam Thank you for the opportunity to submit my proposal for your project 425653, Modifying openBiblio in PHP+MySql. Enclosed please find all information relative to my skills and experience, as well as More

$110 USD in 5 days
(1 Review)
1.8
vizonetraining

We have given above quote by taking 2 day buffer for delivery.

$120 USD in 10 days
(0 Reviews)
0.0
vipulphp

Dear Sir, Please Check PM. Thanx, Vipulphp.

$171 USD in 7 days
(0 Reviews)
0.0