micky007192 Posted July 7, 2017 Share Posted July 7, 2017 Hi Guys, This issue is beginning to really pi** me off! I've spent a full day trying to do this, what ever i try i cant seem to get it working correctly. I'll pay the first person $20 via paypal that fixes my issue first. Right so i have an excel file that has nearly 800,000 records in it, im trying to upload it into my MySQL database but i keep getting issues. The first option i tried was turning the file into a CSV and then uploading the file directly via PHPMYADMIN. But that didnt work as a number of issues came about. The next thing i tried was using PHPexcel which i had alot more sucsess with except there was still some issues as you'll see below. These are the issues iv been facing: Excel to CSV: When i save the file as a CSV the data is not enclosed/escaped. Some of the data has a single quote in it, such as if the surname is O'brien then thats messing with the import of the data. When saving as CSV from Excel some of the data may have commas in them which again is messing with the import of data since for some reason the data is not being enclosed/escaped. The DOB (Date of Birth) and Received Date is not importing properly. See screenshot 1. PHPexcel: Some of the data has a single quote in it, such as if the surname is O'brien then that row of data is not inserted. The DOB (Date of Birth) and Received Date is not importing properly. See screenshot 1. Please can someone help me out as i dont know what else to do here. Surely there must be a better way of importing data from Excel to a MySQL database? Thanks in advance! Quote Link to comment https://forums.phpfreaks.com/topic/304267-ill-pay-the-first-person-20-via-paypal-that-fixes-my-issue-data-import-mysql/ Share on other sites More sharing options...
benanamen Posted July 7, 2017 Share Posted July 7, 2017 Email the file to me and I will send you back the Mysql version. My email is in my profile. Quote Link to comment https://forums.phpfreaks.com/topic/304267-ill-pay-the-first-person-20-via-paypal-that-fixes-my-issue-data-import-mysql/#findComment-1548045 Share on other sites More sharing options...
micky007192 Posted July 7, 2017 Author Share Posted July 7, 2017 I cant do this because of it has our customers details including email and full address. Also id need a solution as i have other files that i need to import and not just the 1. Quote Link to comment https://forums.phpfreaks.com/topic/304267-ill-pay-the-first-person-20-via-paypal-that-fixes-my-issue-data-import-mysql/#findComment-1548046 Share on other sites More sharing options...
Jacques1 Posted July 7, 2017 Share Posted July 7, 2017 This isn't eBay for programmers, so cut the crap. If you need somebody to do a job for you, write a proper offer with a contact address in the jobs section. Quote Link to comment https://forums.phpfreaks.com/topic/304267-ill-pay-the-first-person-20-via-paypal-that-fixes-my-issue-data-import-mysql/#findComment-1548047 Share on other sites More sharing options...
micky007192 Posted July 7, 2017 Author Share Posted July 7, 2017 (edited) Ok... well I'm sorry about that. All I'm after is for some help and rewarding the person that helps me. I thought that forum was for projects and not for small things such as this. Edited July 7, 2017 by micky007192 Quote Link to comment https://forums.phpfreaks.com/topic/304267-ill-pay-the-first-person-20-via-paypal-that-fixes-my-issue-data-import-mysql/#findComment-1548050 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.