Import Excel File Data in MySQL Database using PHP

Concluído Postado Jun 13, 2015 Pago na entrega
Concluído Pago na entrega

Hello,

we have 6 plain excel files exported from our BMC Remedy ticketing system (in xls and xlsx formats, see attached) and we would like to import them in a mysql database.

The table definition in mysql may be defined in advance, but it is part of the job.

We would like to have a basic PHP page that allows to upload the files, with a form similar to this:

Incident data: Select file (submit button) (checkbox) Delete exisiting data

Change data: Select file (submit button) (checkbox) Delete exisiting data

Problem data: Select file (submit button) (checkbox) Delete exisiting data

Incident to problem data: Select file (submit button) (checkbox) Delete exisiting data

Change to problem data: Select file (submit button) (checkbox) Delete exisiting data

Incident and CI: Select file (submit button) (checkbox) Delete exisiting data

Job has to be developed in coder's environment. Once it works, we will install it in our GNU/Linux Apache + PHP + MySQL server.

Thanks in advance

Excel MySQL PHP

ID do Projeto: #7853871

Sobre o projeto

14 propostas Projeto remoto Ativo em Jun 13, 2015

Concedido a:

kevalthacker

Hello, how are you? I am able to do this [login to view URL] you like then i am ready to show you demo of it. I am ready to start right now. thank you. Regards, Keval Thacker

$20 USD em 0 dias
(84 Comentários)
6.4

14 freelancers estão ofertando em média $32 nesse trabalho

prakashmondal

hi, I am interested to develop a php script to upload 6 different types excel upload and save into the database. Please consider my bid and let me start the work right now. Thanks Prakash

$100 USD em 1 dia
(83 Comentários)
6.1
wsafreelancer

Hi!! How Are you? i hope you will be fine If you are looking for a senior developers to bring your great idea come to life? then we are the most responsible team to approach your target !!!. I have 6+ years working ex Mais

$15 USD in 0 dias
(91 Comentários)
5.8
MustafaSR

Hello Sir, I can develop the script in PHP which will take the files in csv format. Yes its csv and NOT xls or xlsx. You will need to do one extra step ie save the files as .csv(comma separated values) format from m Mais

$70 USD em 1 dia
(87 Comentários)
5.8
rodweb

Aucune proposition n'a encore été fournie.

$20 USD em 1 dia
(48 Comentários)
5.5
mrmdreamtech

A proposal has not yet been provided

$15 USD em 1 dia
(40 Comentários)
5.3
david0212

I ever have worked importing data from excel, from newyork times, from csv file,... I think i can help you to import. Please contact me.

$29 USD em 1 dia
(3 Comentários)
2.8
nisarmed

I am an expert PHP developer and I can complete this project very quickly since I am new on freelancer

$25 USD em 1 dia
(0 Comentários)
0.0
ronak01

Hello, i am gone through with your requirements. i have more than 2 years experience in the field of web application development specially in php and in that codeigniter. i would love to work in friendly envi Mais

$35 USD em 1 dia
(0 Comentários)
0.0
shakibhasan89

A proposal has not yet been provided

$25 USD em 1 dia
(0 Comentários)
0.0
hsvhora

A proposal has not yet been provided

$25 USD em 1 dia
(0 Comentários)
0.0