Jump to content
Sign in to follow this  
micky007192

I'll pay the first person $20 via paypal that fixes my issue! - Data Import MySQL

Recommended Posts

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!

post-204714-0-87034800-1499385287_thumb.png

Share this post


Link to post
Share on other sites

Email the file to me and I will send you back the Mysql version. My email is in my profile.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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 by micky007192

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.