Download online spreadsheet, process it to insert info in mysql database

We need to download a file and insert data in a database, after some processing. We need a php/mysql script to do the job. The script would do following tasks :

1) Get the file from the website, via curl or whatever.

2) Analyze the data to retrieve appropriate information, as described below.

3) Inject the data in the database, after saving the existing information

Analyze the data : as you will see the spreadsheet has 15 columns, A to I. Columns B to I do not need processing, the information can be stored as is.

The processing is on column A, identity.

In this field, we have the name of the person, possible alias(es), nationality, DOB, etc..

The most important information to process is the name and the aliases.

The database should have an alias table, and a main table (same table as existing + one field ‘NAME’), or an aliases table, a names table, and the main table (existing).

To get the alias(es), if any, the program would probably use regular expressions, because the presentation is not always exactly the same.

We need a very basic demo form to show a simple search (LIKE operator) on names and aliases to find possible names : the user inputs a name, and the form will return matches.

The document is there: [url removed, login to view]

Skills: MySQL, PHP, Software Architecture

See more: download php code insert data mysql database, matlab mysql database insert, iphone development info mysql database, create pdf file info mysql database php, retrieve info mysql database using, php mysql database insert, online accounting software user manual, php mysql database insert edit delete, use fake mysql database online, insert form mysql database, flyer maker online download, megavideo url online download, male online people profile user arabic, male online people profile user kenya, online offline status user php, megavideo online download, insert formulier mysql database php, implement mysql database online bookstore project, implement online bookstore using mysql database, mysql database design online bookstore design answers, upload excel spreadsheet mysql database phpmyadmin version, megaupload link generator online download, youtube online download converter script, search online download results, online retail store user database

About the Employer:
( 53 reviews ) PARIS, France

Project ID: #12016032

29 freelancers are bidding on average $138 for this job


Hello Good Day Thanks for inviting me for this project. I can do all what you are requiring your project requirement. Please feel free to contact me for any discussion. Thanks Rinsad

$200 USD in 3 days
(949 Reviews)

Hi, i can do that let us start .....................................................................

$105 USD in 2 days
(193 Reviews)

HELLO THERE, Over 200+ Positive Reviews. Over 90% Completion Rate. 5 Star Rating. 8+ Years of experience in PHP/MYSQL I AM INTERESTED IN WORKING ON THIS PROJECT. PLEASE CHECK MY REVIEWS AND THEN DECIDE ON More

$120 USD in 2 days
(272 Reviews)

Dear Client, Greetings from Flowgica technologies, I have experience with these skills. We do have similar experience doing something similar to yours therefore I am looking forward to discuss and move ahead. please ch More

$150 USD in 4 days
(40 Reviews)

Hi, I am joomla, virtuemart expert having 5 years of experience... recently i completed these projects [login to view URL] [login to view URL] [login to view URL] please award me the project.

$111 USD in 3 days
(339 Reviews)

Hi there - My name is Jhalak. I’ve read your [login to view URL] team has 4 years experience designing and developing mobile apps and Websites.I would approach your project by starting with wireframes and getting the site complet More

$155 USD in 3 days
(183 Reviews)

Hi I'm interested in your project. I have understood your project requirements. I can complete the functionality. please accept the bid. I am ready to start the project.

$130 USD in 1 day
(318 Reviews)

Hi, i'm interested, could you give me more details please? could you send me a sample spreadsheet? i can do a php scraper right now regards [login to view URL]

$100 USD in 1 day
(70 Reviews)

Hey there, I am a professional PHP developer with 6+ years of experience and I am eagerly interested to build you a script to download and import spreadsheet in mysql database. I would love to discuss with you fu More

$150 USD in 5 days
(48 Reviews)

Hello Sir, We thank you to give us the opportunity to bid on your project. We are really interested to work on your project. I had a look on your requirement and I think we have exact skill set to effectively complet More

$200 USD in 5 days
(32 Reviews)

Hi there, I’d like to be considered for your job position. I’m a Web Developer with a strong background developing with back end & front end. I can turn your requirement in a way that represents your brand and appe More

$155 USD in 3 days
(15 Reviews)
$155 USD in 3 days
(30 Reviews)

Hi, I am competitive to this kind of task. Try me and let me see how can I help you achieve in your goal. Let me know the best of your time so we can discuss further based on your requirements and we can move forwa More

$149 USD in 3 days
(17 Reviews)

Hi, I’m interested in the task you posted. I have been a working as php Developer for 5 years, and am very familiar with it. Below are my expertises • PHP • YII2 • Zen cart • wordpress • Website scrape • W More

$111 USD in 3 days
(39 Reviews)

Hello, I am an accomplished excel programmer and user. I am also very good at writing incisive codes,macros and generating reports that will assist any business enterprise in their venture. I can get this done w More

$55 USD in 2 days
(55 Reviews)

we will do this quickly and delivery soon.

$100 USD in 2 days
(20 Reviews)

I'm a systems analyst with extensive experience in systems development / sites (over 30 years), currently fluent / focused as a developer. Here is some present projects: [login to view URL] - web hosting company More

$250 USD in 10 days
(6 Reviews)

Dear Sir I can help you out in doing the analysis and updating the data to be inserted in [login to view URL] initiate further conversation for better understanding of the issue regards Amit

$211 USD in 3 days
(20 Reviews)

I am a software engineer and have developed multiple such programs. I hope I can be of help to you.

$133 USD in 5 days
(8 Reviews)

I have been in this field for more than 7 years. I have experience in php,perl,postgress sql.i provide support Chester cap llc more than 5 years. Chester cap llc have a grant management system project that brand name i More

$155 USD in 3 days
(8 Reviews)