Suljettu

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

About the Employer:
( 9 reviews ) Wichita, United States

Projektin tunnus: #417108

20 freelanceria on tarjonnut keskimäärin 79 $ tähän työhön

lightcresent

Can be done... Thanks

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

Check PM for more info...

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

easy work.

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

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)
5.8
zub

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

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

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)
5.6
Kurei

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)
5.4
kraynyukov

Please check PM. Thanks.

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

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)
4.4
forwardme

================================ 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)
3.8
Manshasolution

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

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

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

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

See PMB for more information

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

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)
0.0
ramal

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)
0.0
DigeratiJiitu

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)
0.0
serranoneves

I'm interested to work on this project.

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

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

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

I can help you, check pm please.

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

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)
0.0