PHP script to reorganize data in MySQL table.

I have a php script that builds a mysql database product table from multiple csv sheets that contain product information organized by vehicle make, model and year. The script runs on a standard PC and uses XAMPP.

The problem is that the csv sheets are from three different sources so the vehicle names are sometimes spelled differently or combined together.

The mysql table that my script creates looks something like this:

make, model, year, etc..

Acura; CL; 2001; ...

Acura; EL; 2001; ...

Acura; Integra; 2001; ...

Acura; Integra / Legend; 2001; ...

Acura; Legend; 2001; ...

Acura; MDX; 2001; ...

Acura; NSX; 2001; ...

Acura; NSX, NSX-T; 2001; ...

I'm looking for a script that will compare Make and Model records to try and find matches. If it finds a match then I want to delete the larger Make/model record and create multiple other records out of it... For example:

The script would find that

Acura; Integra;

is similar to but not the same as

Acura; Integra / Legend;

Because Acura Integra / Legend is larger it would delete the Acura; Integra; record and replace it with two nearly duplicate records. One would be Acura; Integra; and the other would be Acura; Legend;

After the script runs the database table should then look something like:

make, model, year, etc..

Acura; CL; 2001; ...

Acura; EL; 2001; ...

Acura; Integra; 2001; ...

Acura; Integra; 2001; ...

Acura; Legend; 2001; ...

Acura; Legend; 2001; ...

Acura; MDX; 2001; ...

Acura; NSX; 2001; ...

Acura; NSX; 2001; ...

Acura; NSX-T; 2001; ...

I also need this script to be able to complete within a reasonable time frame (30 minutes to an hour or so max) on a reasonably adequately fast PC. The database table currently has about 50,000 lines.

Taidot: PHP

Näytä lisää: mysql reorganize table, mysql reorganize, mysql reorganize database, reorganize mysql database, reorganize mysql table, scipt php create mysql database, reorganize mysql, script sheets, php create table, match problem, find php, create table php, reorganize csv php, php script check record replace match, php script table information, can reorganize mysql table, php script mysql faster, php reorganize mysql table, php script delete table data, php mysql compare tables, table reorganize mysql, php year model csv, php script table, php script post mysql database, php data script mysql

Tietoa työnantajasta:
( 9 arvostelua ) Wichita, United States

Projektin tunnus: #417108

20 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Can be done... Thanks

$100 USD 1 päivässä
(435 arvostelua)

Check PM for more info...

$100 USD 2 päivässä
(96 arvostelua)

easy work.

$80 USD 1 päivässä
(79 arvostelua)

Treewalker is the team of highly professional Software Engineers, Web Developers, Web Designers and Creative designers. Please see PMB for details.

$159 USD 3 päivässä
(19 arvostelua)

Hello Sir, Please see the PM. Thank you. With regards zub

$75 USD 2 päivässä
(39 arvostelua)

Hi, I think i can make it work in less than 10 minutes. maybe even faster... it might be done from sql directly but just to be 100% it will be php script. Cip

$35 USD 0 päivässä
(69 arvostelua)

Hi, i read your requirement and understand what you want! I'm insterested in your project! Please view PMB for bid detail! Thank you!

$65 USD 0 päivässä
(48 arvostelua)

Please check PM. Thanks.

$30 USD 0 päivässä
(9 arvostelua)

Hi, I can do it. I have an idea to complete this task as fast as possible. Can we share ideas? Waiting for your feedback. PHPOpenSource

$102 USD 3 päivässä
(18 arvostelua)

================================ Hi! We are Annapurna Comptech. A Web Development Company. We will do the Job for you and will deliver you the projects with complete satisfaction. We can start immediately. Please cont Lisää

$50 USD 1 päivässä
(9 arvostelua)

Hi, We are having experties in handling such projects. Please view your PM for the details. Thanks! [login to view URL]

$35 USD 1 päivässä
(2 arvostelua)

I'm an experienced PHP/MySQL developer, check PM.

$50 USD 2 päivässä
(3 arvostelua)

See PMB for more information

$250 USD 5 päivässä
(5 arvostelua)

Hi, I am a systems engineer with extensive experience in web development, and my specialty is the model database. I am an expert in MySQL and MSSQL, ASP,. NET, C # and PHP. Currently working as a programmer php iddelsu Lisää

$30 USD 2 päivässä
(0 arvostelua)

I will do this for you. I have done many projects using mysql as backend. I am working with MySQL for past five years.

$30 USD 1 päivässä
(0 arvostelua)

We are a group of IT professionals having expertise in the areas that are the prerequisites for the bidding procedure. We focus on the quality of the work and also believe in delivering the product on time. We have ga Lisää

$100 USD 3 päivässä
(0 arvostelua)

I'm interested to work on this project.

$100 USD 10 päivässä
(0 arvostelua)

I have already done this before . I can provide to you in $50 if you want !

$50 USD 1 päivässä
(0 arvostelua)

I can help you, check pm please.

$30 USD 7 päivässä
(0 arvostelua)

I'm an PHP / database expert with long time experience on big projects. From some project experience with importing large number of data (few milion rows) and finding synonyms, similar words in strings. I think this ca Lisää

$100 USD 2 päivässä
(0 arvostelua)