Cerrado

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]

Habilidades: MySQL, PHP, Arquitectura de software

Ver más: matlab mysql database insert, php mysql database insert, insert form mysql database, flyer maker online download, megavideo url online download, megavideo online download, search online download results

Información del empleador:
( 53 comentarios ) PARIS, France

ID de proyecto: #12016032

31 los freelancers están ofertando un promedio de $138 para este trabajo.

rinsadsl

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 en 3 días
(782 comentarios)
8.3
waelfree

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

$105 USD en 2 días
(176 comentarios)
7.7
mmadi

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 Más

$150 USD en 4 días
(40 comentarios)
6.9
csajit

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 Más

$120 USD en 2 días
(255 comentarios)
6.7
shihan033010

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 en 1 día
(303 comentarios)
6.7
sat12

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

$111 USD en 3 días
(283 comentarios)
6.5
elbruninh

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 [url removed, login to view]

$100 USD en 1 día
(41 comentarios)
5.9
Codomotive

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 Más

$200 USD en 5 días
(28 comentarios)
5.7
yogeshssanwal

Hi there - My name is Jhalak. I’ve read your [url removed, login to view] 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 Más

$155 USD en 3 días
(100 comentarios)
5.9
snapycode

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 Más

$150 USD en 5 días
(23 comentarios)
5.2
FutureTechno1

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 Más

$155 USD en 3 días
(8 comentarios)
5.2
phpfreelancer86

Hello Sir, I've reviewed your requirement and I'm ready to work with you. I will provide quality work as well full support for any query. I'm giving you trust for good quality work. I have almost 7+ years of expe Más

$135 USD en 3 días
(43 comentarios)
4.8
$155 USD en 3 días
(13 comentarios)
4.7
shafiq31

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 Más

$111 USD en 3 días
(29 comentarios)
4.4
cracken

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 Más

$149 USD en 3 días
(8 comentarios)
4.3
stylishwebtech

we will do this quickly and delivery soon.

$100 USD en 2 días
(14 comentarios)
3.6
KothariNeha

I read your requirements and i have designed many things like yours. I will Provide Services Until You get 100% satisfied. I am not just looking for money OR one project, as i firmly believe in long term business r Más

$155 USD en 3 días
(11 comentarios)
3.6
ankita0389

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

$133 USD en 5 días
(6 comentarios)
3.5
Newforce

Hello there, we can work on this project at the most reasonable rate. We have successfully completed similar projects in the past and having gone through your requirements, we are quite comfortable to deliver it on agr Más

$155 USD en 3 días
(6 comentarios)
3.3
jasphineinfotech

I will be more than happy to work on this project for you. I'm currently the CEO at Jasphine InfoTech in Ahmedabad,India. I hope you trust in my skills as former leaders have trusted in my skills for client Más

$155 USD en 3 días
(3 comentarios)
2.9