Need an open source PHP script to format two vehicle part csv files into a database

Closed

I need an open source and readable (non obfuscated so I can modify it if changes occur) PHP script that will format two CSV files from two manufacturers into two or three database tables which I need for my system.

I want the PHP script to parse the files and load the information into a database.

The two CSV files are basically application guides that include include fitment data. One file is formatted in ACES format and one is in a different format. The hard part is going to be getting the fitment options correct. The ACES formatted file won't be too difficult to work with, but there are 700 different vehicle options that I need to be looked at for the non ACES file. Here's an example:

An option that looks like this: "<b>Drive:</b> Front Wheel Drive<br /><b>Transmission (Type):</b> Automatic" will need to be changed to this: "Front Wheel Drive, Automatic Transmission"

An option like this: "<b>2nd Row Seating Type:</b> Bucket seating" will need to end up looking like this: "2nd Row Bucket Seating"

I want a third database table to contain the original options phrasing and the converted phrasing kind of like this:

options_id, old_options, new_options

1,"<b>Drive:</b> Front Wheel Drive<br /><b>Transmission (Type):</b> Automatic","Front Wheel Drive, Automatic Transmission"

2, "<b>2nd Row Seating Type:</b> Bucket seating","2nd Row Bucket Seating"

I will also need vehicle makes and models in the two CSVs to match vehicle makes an models in my database.

Example on one vehicle:

My Database: 2014,Chrysler,Town & Country

CSV 1: 2014,Chrysler,Town & Country

CSV 2: 2014,Chrysler,Town & Country Van

CSV 2 does not match my database so I would need to have that vehicle name changed from "2014,Chrysler,Town & Country Van" to "2014,Chrysler,Town & Country" This will require a 4th database table very similar to the 3rd one for vehicle options.

Skills: Automotive, Data Processing, MySQL, PHP, Software Architecture

See more: source format, open-table, mysql database models, i need a manufacturers, drive to work, chrysler application, database models, name to be changed, load information from mysql, correct csv, php script open file, source php script, php table csv, format similar, php mysql load table, php load table, database example, drive script, table csv, data vehicle, modify table php, csv table, seating script, mysql load csv file, php options need match

Project ID: #5354060

15 freelancers are bidding on average $471 for this job

toinnisfree

I have read your project details, and I am interested in offering my services. I provide 100% satisfaction guaranteed on all my work. Milestone is required to begin; to be released when the job has been satisfactor More

$500 USD in 7 days
(593 Reviews)
8.0
rajeshsonisl

Hello, With 99% completion rate, 650+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page !!)... you can never go wro More

$618 USD in 4 days
(475 Reviews)
7.4
rinsadsl

Hi there I am quite good in parsing csv files into database. I can comeup with my own php code which you can modify easily as you wish. Looking forward to work with you. Thanks Rinsad

$360 USD in 5 days
(315 Reviews)
7.3
srinichal

I am an expert in delivering custom scripts and willing to discuss further details about the project specifications.

$526 USD in 10 days
(106 Reviews)
7.2
jqMike

Hello! I've read the description of your project and I'm interested in working on it. Please contact me so we can discuss details.

$333 USD in 3 days
(65 Reviews)
7.1
AcuityInfotech

Hi,    We’ve had a good look at your project description and we’re very interested in providing a solution. Recently we have done similar type of project, please have a look at http://acuitywebhosting.com/lionshop More

$421 USD in 7 days
(28 Reviews)
6.7
alifinteractive

Hi, We have a good team of expert coders and designers in New Delhi, India.We have many satisfied clients all over the world.We already have successfully launched many ecommerce,blog, social networking and other websi More

$515 USD in 10 days
(39 Reviews)
6.6
abhius

Hello Sir, Season's Greetings ! I have got an idea on what you require and confident enough to go ahead. As you have mentioned '' An option like this: "<b>2nd Row Seating Type:</b> Bucket seating" will nee More

$575 USD in 10 days
(94 Reviews)
6.2
csajit

Hello there, I am interested in working on this. Please check my reviews and then decide on me. Thanks, Ajit

$421 USD in 10 days
(156 Reviews)
5.9
evidcomm

Hello Hiring manager, Greetings from Evidcomm!!! We have gone through your requirements and would be pleased to work on. We have already done this kind of work in past and surely we will get finished this project More

$380 USD in 10 days
(32 Reviews)
5.7
eComOS

Dear sir, I will complete your project within 9 days and provide ONE YEAR free bug guarantee.. I have gone through your outsourced requirement "Need an open source PHP script to format two vehicle part csv files int More

$465 USD in 365 days
(66 Reviews)
5.5
alphawow

Hello, i have great experience with data parsing so i would like to work with you on this project. I could start work right now. Will be great if you upload links to csv file so I will be able to review structure. More

$444 USD in 10 days
(17 Reviews)
5.1
VariationMedia

Hello, We would be very happy to work with you please check out our behance profile www.behance.net/VariationMedia for some of our more updated pieces as well as our website www.VariationMedia.com/ to learn more abo More

$526 USD in 10 days
(10 Reviews)
4.7
fastworkontime1

Hello! We have read your requirements and we will do this job for you. We have done similar kind of job before also. We have 100% completion rate and trust me, we are going to give you quality work and we are sure afte More

$639 USD in 10 days
(27 Reviews)
4.4
anuyadav1

i can develop this php script to feed data in database from csv files . .

$250 USD in 4 days
(9 Reviews)
4.2
Beacon09

Hi I just read the detailed requirements. I tried my best to understand your description and I am quite interested in creating this script. I am BS(CS) qualified individual with expertise in web development, I am Micro More

$320 USD in 12 days
(8 Reviews)
4.1
idicesolutions01

Hi, We are experienced web, desktop, mobile application developers. Please visit our portfolio for the same. We have worked with CSV/XML/JSON data during various application developments and hence I am confident to More

$566 USD in 10 days
(0 Reviews)
0.0