Completed

Import csv, xls and xlsx to mysql

group the excel file by name,ip,cost

insert into trunks_trunk (name,cost,ip,descr,template_id,max_count,trunk_type,priority) ### these are the grouped values

[login to view URL] will be incremented

get [login to view URL],ext_prefix for every group you made - you will find same trunk id from mysql

will match multiple ext_prefix in xls

insert into trunks_rules (trunk_id,ext_prefix,add_prefix,strip,allow)

Example mysql and example xls attached

Keep in mind that i want this for csv, xls and also xlsx

Skills: Linux, MySQL, PHP, Software Architecture

See more: import excel into mysql workbench, import excel to mysql workbench, excel to mysql converter, how to import excel sheet into mysql database, import excel to mysql phpmyadmin, mysql for excel download, import data from excel to mysql using command line, excel to mysql converter online, access vba import csv xls, import csv php script mysql, webshop import csv xls, perl import csv mysql, perl script import csv mysql, import csv mysql using web form, import csv linux mysql, import csv mysql, import csv script mysql, import csv mysql ssh, script import csv mysql, import csv mysql web interface

About the Employer:
( 93 reviews ) dix hills, United States

Project ID: #17228046

Awarded to:

xingxing1210

Dear Client I read your job description carefully. I'm very interested and confidence in your job and I can start work immediately. I'm a Web expert with 6+ years experience. So I masterted - PHP(Laravel, Cod More

$25 USD in 1 day
(3 Reviews)
2.6

21 freelancers are bidding on average $23 for this job

JinDongZhe

Hello. sir. How are you? I am interested in your project. I have good experience of your project, I did it by using PHPExcel Plugin. It is simple. Are you chatting with another? Can you award me? Now I am free a More

$25 USD in 1 day
(43 Reviews)
6.3
royalwebraisers

Dear Hiring Manager, Hi, How are you ? I have gone through the requirement and still need some more brief of the project. Thanks Mohit

$35 USD in 1 day
(59 Reviews)
5.9
$25 USD in 1 day
(5 Reviews)
5.6
shanymathew

Dear Sir, i can import csv,excel etc to mysql perfectly please reply wish to do this task please come in chat

$30 USD in 1 day
(43 Reviews)
4.8
retroshell

Hello, I'm hamid , I have 10+ yrs experience in web application programming. This is very easy project , I can do it immediately. I can import the file contents to mysql database for you + You can follow-up y More

$25 USD in 1 day
(22 Reviews)
5.0
fastwebsoft

Hello sir , I have read your requirement carefully . i can do it easily.. More than 5 year experience.. Thanks

$25 USD in 1 day
(9 Reviews)
4.4
kovirijagdish

I am a Web Security Researcher & Bug Bounty Hunter at HackerOne, BugCrowd, BountyFactory and many other Independent Bug Bounty Programs Reported Security Vulnerabilities to Google, Facebook, Twitter, TCS, DigitalOcean More

$10 USD in 1 day
(38 Reviews)
3.8
WEBsultion

I have 2 year of experience in python development. I can do this job for you. As you can saw my profile i had already done such projects in python.

$25 USD in 1 day
(17 Reviews)
3.9
$15 USD in 1 day
(8 Reviews)
3.0
srikantbadri

I can do it easily. I am charging very low for that. Hope you consider me:)

$15 USD in 1 day
(2 Reviews)
2.5
$25 USD in 1 day
(6 Reviews)
2.7
lovethomas1026

Hello! Thanks for your post. I read your requirement carefully. I have rich experienced in web development. If you give me a chance, I will satisfy you with good result. Please check my profile. I will wait your More

$20 USD in 1 day
(4 Reviews)
1.8
examplewebs

Hi there, I have read the requirement and seen the xls and txt files attached. I can get this finished within few hours. I am a full stack developer with over 10 years of experience with predominate experience in More

$25 USD in 1 day
(1 Review)
0.8
Amir3040

We are team of web developers with 5 years of experience, we have good coding grip in php (Laravel, Symfony, Codeignator, CakePHP), Ruby on Rails, Javascript, JQuery, AngularJs, Angular, Wordpress, Bootstrap, Ajax, git More

$15 USD in 1 day
(0 Reviews)
0.0
anitadhakad369

Hello I have read your requirement description and feels glad to inform you that I have team of expertise in Skills required to fulfil the expectation of project. We have an experience and dedicated team for Skill se More

$35 USD in 2 days
(0 Reviews)
0.0
MMAtechnology

Good Day, Hey, I'm interested in your project. Please send me a message so that we can discuss more.

$35 USD in 1 day
(0 Reviews)
0.0
$15 USD in 1 day
(1 Review)
0.0
techanu9

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned "I can do More

$21 USD in 7 days
(0 Reviews)
0.0
$15 USD in 1 day
(0 Reviews)
0.0
$15 USD in 1 day
(0 Reviews)
0.0