Implement Recall Database
HI:
I have 4 individual templates for the 4 NHTSA subject searches below. We need to convert the data from Flat file and import to mysql database, then write quality PHP script to insert data to template.
Fields will need to me implemented correctly for quality SEO: Title, Meta Description, Meta Keywords, URL, H1 and breadcrumb.
Here’s the link to the download page:
http://www-odi.nhtsa.dot.gov/downloads/index.cfm
The subjects are Recalls, Technical Service Bulletins, Defect Investigations and Complaints.
Here are links to the 4 NHTSA searches:
http://www-odi.nhtsa.dot.gov/recalls/recallsearch.cfm
http://www-odi.nhtsa.dot.gov/tsbs/tsbsearch.cfm
http://www-odi.nhtsa.dot.gov/defects/defectsearch.cfm
http://www-odi.nhtsa.dot.gov/complaints/
The format looks almost identical in all 4. So completing one should make the others no big deal.
Example: Got to Recalls — http://www-odi.nhtsa.dot.gov/recalls/recallsearch.cfm :
All we want is “vehicle”, so this first selection page is unnecessary for us.
Then the selection is year, make, model (we want to browse by make, model and year instead).
Search: 2000 >> Honda >> Accord >>
This next page shows “Component (Optional)” and “Select this box…” — we don’t need either (so this page is unnecessary). We’re not going to give them the Component choice, and we want “full summary” included with each recall, tsb, etc.
Check the box, don’t select a component, and click “retrieve recalls”.
OK. This is our content page. The only thing I want to do differently, if possible, is group them into the component categories like they did at this site with the TSBs (they’re using the same NHTSA data):
http://www.carcomplaints.com/Honda/Accord/2000/tsbs.shtml
And, if possible, go multipage after a specific number of items.
That’s what I’m looking for. Suggest a price?
The project must be done to high standards and immediately.
Thanks,
Alex