[Free Lance Web Project]

Looking for someone with good web development knowledge, php & MySQL, reliable and responsible, for a urgent project (see below).

It should be a 1 - 2 days project by scope. Deadline to finish is by end of Sunday 3/11.

Budget is around RMB 600 - 1000, or best offer.

If you are interested, please send email me at: leezhcn@163.com, providing tech background & skill set, as well as asking price. If you are chosen, we’ll communicate over the phone about task details as well as payment method.

P.S. if this project goes well, we could build a long term relation for future projects, especially if you also have good knowledge of ASP.NET, C#, and SQL Server.


[Task Summary]

1. Write a program (any language, prefer C#) to extract data from a web site, into a csv data file
2. Write php code for loading extracted data into MySQL tables

[Extract data from a web site]

Data to extract: motorcycle’s color info:
www.colorrite.com >> click on Paint Wizard >> click on Motorcycle Paint (http://www.colorrite.com/matrix-step1.cfm?type=2)
With both Dirt and Street checked,
then step 2 (choose Make), step 3 (choose model), then color data page

Get color data for all the listed years, all the makes (companies), all the models.
Color data for each year + company + model consists of the following fields:
 Code, Paint Name, Color Chip (background color #RGB)

End result: create a data file out of all the fetched data (csv):
company name, model name, model year,code,paint name,color R,color G,color B

Note: R, G, B in integer format 0 - 255


[Write Code to load data into MySQL tables]

Write php code to load the fetched data file into MySQL tables (see below). The php code will be later put into a web page to load the file from the web server’s local drive into tables.

mccompanies:
id:　 int, not null, primary key, AUTO_INCREMENT
Name: string, len:50, not null

mcmodels:
id:　 int, not null, primary key, AUTO_INCREMENT
company_id:　 int, not null, foreign key (mccompanies.id)
Name: string, len:50, not null
Year:  int, not null (yyyy)

mccolors:
id:　 int, not null, primary key, AUTO_INCREMENT
code: string, len:24, not null
Name: string, len:50, not null
angle: string, len:5, not null
R: int, not null
G: int, not null
B: int, not null
tricoat: string, len:1 not null

mccolors_models: color_id, model_id
model_id:　 int, not null, foreign key (mcmodels.id)
color_id:　 int, not null, foreign key (mccolors.id)

Note:
 Need to check before insert: if record exists, skip
 for mccolors: combination of code, R, G, B is unique
 Set mccolors.angle = “00:00”, mccolors.tricoat = “N” for all colors