|All requests||>||Import a file more of 60000 records i...||>||Request new recommendation||>||Featured requests||>||No recommendations|
by sheyda - 5 years ago (2015-06-24)
I need to search in my SQL database, so I need to import a file with more than 60000 records.
1. by Dave Smith - 5 years ago (2015-06-24) Reply
are you able to produce a file in .csv (comma separated values) format?
If not, then you will need 2 classes. One to convert the excel file to .csv and another to import the csv data into the mysql database.
I was not able to locate a single class on here that does both.
If memory allocated to PHP on the server is an issue, then you will need a class that uses generators to read the file.
2. by sheyda - 5 years ago (2015-06-27) in reply to comment 1 by Dave Smith Comment
Can you say the name of the class?
3. by Manuel Lemos - 5 years ago (2015-06-27) in reply to comment 2 by sheyda Comment
Dave suggested that you use two classes: one to convert the Excel file to .csv and another to import the csv data into the MySQL database. Which one do you need more?
If you have your data in DBF format, this class can convert it to MySQL.