how to import csv file in mysql

tuannh88

Dear all,
I have a problem about csv import file.
With a simple module with form_fields parameter

$fields['csv_import'] = array(
'type' => 'file',
'overwrite' => false,
'accept' => 'csv|txt|xls',
'order' => 1000,
'label' => 'CSV Import',
'upload_path' => TRAVEL_PORTAL_PATH.'assets/data/',
'overwrite' => TRUE //TODO: Check if file already exists
//'filename' => */
);
After that, i want to insert csv column record to MySQL via fuel cms.
How to import csv ?

admin

You would need to implement a model hook like on_before_post or on_before_save that would upload the file (perhaps using the CodeIgniter Upload class http://ellislab.com/codeigniter/user-guide/libraries/file_uploading.html) and import the data. More on model hooks can be found here:
http://docs.getfuelcms.com/general/models#hooks

FUEL only provides the ability to export as CSV files by specifying the "exportable" parameter for you simple module's configuration:
http://docs.getfuelcms.com/modules/simple