Find Jobs
Hire Freelancers

MySQL PHP Data import from multiple xls into relational tables with frontend

$8-15 USD / hour

Closed
Posted over 7 years ago

$8-15 USD / hour

I have multiple files with different columns in spreadsheet. There are at least one common column with unique user ID. Id may not be in both files or any other files. Need script to import master file Need script to import update files - different headers - select which headers to import and map to dbase Identify new IDs not in original and handle appropriately (insert record into master and copy as much info over a possible Hosted on standard linux stack with mysql Please advise soon
Project ID: 11914681

About the project

17 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
17 freelancers are bidding on average $13 USD/hour for this job
User Avatar
Hello, I'm a PHP/Drupal/WordPress CERTIFIED EXPERT coder and having over 10 years in programming. My top skills are PHP, HTML, CSS, jQuery, Drupal, WordPress. You would love to work with professional who believe in long term relationships. Please look my portfolio at https://www.freelancer.com/u/minhhoangduc.html?pvpReviewLink=true Please let me help you do it. Best Regards, Minh H
$10 USD in 40 days
4.9 (630 reviews)
8.4
8.4
User Avatar
Hi, I understand that you want a php script which can import data from multiple xls files into a mysql relation tables along with a frontend to manage those data. We will be using the common column as the foreign key for tables to import correct data to correct table mapped with correct user. If required, then we can also reformat the excel or will give you instructions to structure your excels in correct format so that script can import to mysql db correctly. We will also write script to handle new ids, script will check if a id already exist, if not then it will insert the record into master db. We will develop the script to run on any linux based server. If possible then please show the excel files so that I can understand more clearly. I can assure you that we can do it as we are expert in doing this kind of works. Please check our profile, you will get to know that we only take the jobs that we can complete, and for that we have 100% completion for more than 3 years. I will be waiting to discuss in more details with you. Regards, Shouvik Cantrip Solutions Pvt Ltd
$14 USD in 40 days
4.9 (113 reviews)
8.1
8.1
User Avatar
HI Contact me for an efficient, perfect, well documented development of your project according to 100% accuracy and requirements, with dedicated support. Thanks
$12 USD in 40 days
4.9 (662 reviews)
7.6
7.6
User Avatar
Hi , My profile speaks for itself . If you look at my last project that too was related to reading data from an excel file I can surely import that data into a mysql database with any constraints I can start the work today . i`m online right now to talk Mike
$15 USD in 40 days
4.9 (124 reviews)
7.2
7.2
User Avatar
I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably you will get a quick response from my end.
$12 USD in 40 days
5.0 (27 reviews)
7.0
7.0
User Avatar
Hi there,
$8 USD in 40 days
5.0 (50 reviews)
6.8
6.8
User Avatar
WISHING YOU PEACE IN YOUR LIFE. Have java application ,run anywhere I have more than 8 years of experience in JAVA. The breakup of experience as per best of my knowledge: EXCEL/PDF/WORD API : 1 year 7 months Hibernate 3.x - 4.x : 2 years 4 months Web Scraping: 2 year 2 months. Spring2.x - 3.x : 2year 1 months Struts 1.x - 2.x : 14 months HtmlUnit : 4 months XSLT/XML/DOM/JAXB : 2 months Jquery : 9 months javaScript/OOP JavaScript : 6 months Design Patterns : 8 month Database design(Oracle/MySQL) : 33 months. DATA Extraction experience from web-sites to name a FEW sites like facebook, stumbleupon, youtube, amazon, linkedIn, twitter, eBay and yelp and many more. I had experience in web-scrapping software development tool also. Working in a reputed company,Cognizant ,India ,Pune. Believe to be problem solver . "Honesty is the best policy" i really mean it. Worked on Oracle /MYSQL Database & Java Related frameworks most of the time . Basically i am an web/Desktop developer. Thanks & Regards
$12 USD in 40 days
4.7 (18 reviews)
5.1
5.1
User Avatar
A proposal has not yet been provided
$11 USD in 15 days
5.0 (5 reviews)
3.1
3.1
User Avatar
Hi, I've appraised your requirements and I'm perfectly fit with this job as per my skills and experience. I've 6+ years experience and great headiness with LAMP full stack development, Yii 1 & Yii 2, Cake PHP, CodeIgnitor, WordPress, Shopify,Volusion and BigCommerce. If you looking for dedication, quality work and within deadline then you're going to hire perfect person. Looking forward to hearing from your end. Thanks, Nikunj
$13 USD in 30 days
5.0 (2 reviews)
2.6
2.6

About the client

Flag of EGYPT
asyut, Egypt
0.0
0
Member since Oct 27, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.