Project Detail

MySQL, PHP & Screen Scrape Script  

MySQL, PHP & Screen Scrape Script is project number 448989
posted at Freelancer.com. Click here to post your own project.

 

| More
Free Trial For New Buyers
 

Status:

Selected Providers: humashahid80

Budget: $750-1500

Created: 06/10/2009 at 3:52 EDT

Bid Count: 24

Average Bid:
$ 1228

06/15/2009 at 3:52 EDT

Project Creator: charliefutcher
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (2 reviews)

Bid On This Project
 

Description

There are 6 parts to this project:

I have a requirement to develop an admin application (PHP) and to access and enter data into Pre Porduction MySQL database that drives product prices on our website.

A robot to query prices on competitor websites and populate results in the Pre Prod MySQL database - Any Language that works is fine

Buinsess logic and formula transferred from excel spreadsheet to Pre Prod MySQL database

Publish utility that transfers all data from Pre Prod to live database

Test Scripts to ensure all data is good and web output is correct

Migration (If necessary) and implementation


Background

Currently our website is in draft but we wish to go live in the next 2 weeks. We currently use an excel spreadsheet to enter all of our product information, including sales prices, competitor prices etc. There is then some simple formula that calculates the price of our products. We currently save the spreadsheet as CSV and use an upload utility to populate all of our online products.

Business Logic transfer and Admin Application

We have multiple staff constantly updating data in the spreadsheet as sales prices, costs etc change on a daily basis. Currently the spreadsheet performs all the logic which we then upload onto the website daily to display all of our prices and product information. We want all the staff to access a database directly via the new application in order to enter data into the database. Some staff need to access the selling price fields (which drive our prices) and we also need to be able to make small changes to the logic using the admin application.

Multiple levels of security is required, some staff just need access to the sales price field, some to change the logic/formula and the sales price and an admin user who can change everything and also still upload CSV file to overwrite the entire database if necessary.
All the business logic and formula currently done by the spreadsheet needs to be performed directly by the database so all this needs to be developed in MySQL.
Finally we require a utility that will publish all the relevant data to the live website database

Robot

We currently manually check approx 8 competitor sites for their prices which we enter into our pricing spreadsheet. These numbers are also used in the formula that drive our online prices. We need a robot to automatically query the websites and populate the Pre Prod database with the results.

Test Scripts & Backup

We need to have confidence that the prices shown on our website following all the changes above are always correct . We need some simple error checking scripts/routines that constantly run and alert if anything doesn’t look right! We will need the supplier (you) to figure out the necessary logic and write and implement script. We also require a simple script that we can run or schedule daily to back up the entire database (live and pre prod) and a mechanism to restore if we need to.

Implementation

We currently host the site on a hosting package from a large ISP. If because of this new functionality we need to move the site to a dedicated server or a new platform, the migration of current website and implementation of new functionality is part of the requirement for this project.


Additional files submitted:
Web solution components.jpg

Messages Posted:2 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

1500

30 days

06-10-2009 03:59 EDT

Can be done as desired. View PM for details

help

 

1400

12 days

06-10-2009 03:59 EDT

VALUEONWEB is a customer-specific service oriented company has got a Professional and creative team. We are the Professional Web Development Company having rich experience in Web design and development. We have expertise and experience in ecommerce site development, flash and animation. Our team can work on HTML,DHTML, JAVA SCRIPT, FLASH, ASP,ASP.NET,PHP,MY SQL, SQL Server, MS SQL. Our Bid includes development , deployment and testing. We are ready to start and send daily reports. we communicate through email,messenger,phone and skype.We will a deliver a professional looking design(s) with proposed functionality to match your concept.

help

 

1500

0 days

06-10-2009 04:58 EDT

please consider our offer.

help

 

1500

21 days

06-10-2009 03:57 EDT

Dear Customer! We are specializing in e-commerce web site development and have great experience in shopping cart integration. We have worked with many shopping carts using OS Commerce, CRE Loaded, Drupal, Zen Cart, Virtue mart etc. and also develop shopping carts from scratch in PHP and ASP.NET. Please, see links to our works on PMB. We place a preliminary bid and invite you to provide more details on your project so that it is possible to understand the scope of work more exactly. From our part, we will be glad to answer your questions. Kind regards,

help

 

1500

30 days

06-10-2009 07:11 EDT

Hi Please check pmb.Thanks

help

 

750

7 days

06-10-2009 06:54 EDT

Dear Buyer, I have gone through the details and I am absolutely clear with them. Please check pm for more info. Waiting for your kind response. Many thanks, Naveed

help

 

750

7 days

06-10-2009 10:35 EDT

Hello Charlie, this kind of proect are my speciality, please check PMB for details of my bid. Thanks. Leo.-

help

 

1200

30 days

06-10-2009 06:58 EDT

Hello the project you need can be done fast and professionally. Please check PMB for more details.

help

 

750

13 days

06-11-2009 05:01 EDT

please, see pm , thanks

help

 

1250

20 days

06-10-2009 04:57 EDT

Please view PMB

help

 

1500

20 days

06-10-2009 06:24 EDT

Hi, Please have a look on the PMB for more detial.

help

 

1500

30 days

06-10-2009 21:42 EDT

I would like to have additional details on this project before committing. Thanks. Please see PMB

help

 

1200

30 days

06-10-2009 07:09 EDT

plz check PMB

help

 

1260

20 days

06-10-2009 07:10 EDT

We possess extensive experience of developing numerous high-end websites and are highly organized and adept at meeting tight deadlines that are so common in this industry. Please see PMB for more details. Please take Maniks Tour to know more about us: http://manikssys.com/video.html

help

 

1500

14 days

06-10-2009 05:48 EDT

Please check PM, I am here in the usa and have quite a bit of experience.

help

 

750

14 days

06-10-2009 17:17 EDT

Hi my name is Eric Gibson. I am a programmer and system administrator with over 10 years of experience. I'm a native English speaker, and have extensive experience in the skills necessary to complete your project. I can complete this project for the bid total and in the time allotted.

help

 

1500

31 days

06-10-2009 06:51 EDT

Hi Please see PM. Thanks

help

 

750

10 days

06-10-2009 09:00 EDT

We have the skills to do what you need in a short amount of time. Please check out our latest screen scraping project, SpiderWebSports.com. This website is 100% automated. Everything is automated from picking the games and putting them into the database to inputting the results of the games to handling payments and subscriptions. An excel sheet containing game details is automatically parsed once a week for data which is input in the database. We scrape 4 different sites for this site to work, but obviously adding more if they were needed would not be difficult. Check out SpiderWebTechnologies.com for more information on our USA based business.

help

 

1500

30 days

06-10-2009 13:14 EDT

Hi Charlie, please read the document I have attached to PMB, Hoppy

help

 

1000

20 days

06-10-2009 04:03 EDT

Hi, i have worked on something similar in the past to upload "bulk" data into the database with verification and backup process. Please Refer to PM for further information.

help

 

800

20 days

06-10-2009 06:08 EDT

(No Feedback Yet)

Kindly check my account detail.

help

 

1400

25 days

06-10-2009 08:46 EDT

(No Feedback Yet)

Dear Sir or Madam, I understand what you need. Please read PM for my proposal. Best regards, Krum Cheshmedjiev

help

 

1500

35 days

06-11-2009 06:17 EDT

(No Feedback Yet)

Hello, We are Software Development Company from India provides IT services, having a great experience in development and designing of complex solutions. We have well trained and fully experienced developers and programmers specialized in different technologies for the better accomplishment of the clients needs, want and desires globally. Please find PMB. Thank you, QualSoft Services

help

 

1200

18 days

06-11-2009 06:30 EDT

(No Feedback Yet)

we are ready to do this work. Your satisfaction is our motto

help


    Bid on this Project