unable to upload an excel file in codeigniter

Question

I have a Codeigniter project that can insert data into database through uploading an excel file and reading it with PHPExcel. It is working on my localhost however when I uploaded it in a LAMP server, It gives me an error The filetype you are attempting to upload is not allowed. How am I going to solve this?

EDIT In my project, I also have a file image uploading..

 public function uploadConfig(){
    $this->load->library('PHPExcel');  
    $this->load->library('PHPExcel/IOFactory');
    $config['upload_path'] = './csv_uploads/'; 
    $config['allowed_types'] = 'xlsx|csv|xls';
    $config['max_size'] = '10000'; 
    $config['overwrite'] = true;
    $config['encrypt_name'] = FALSE;
    $config['remove_spaces'] = TRUE;

    $this->load->library('upload', $config);
    $this->upload->initialize($config);

    if (!is_dir('csv_uploads'))
    {
        mkdir('./csv_uploads', 0777, true);
    }
    // gif|jpg|jpeg|png
}

This works on my localhost in XAMPP. However, when I uploaded it on my LAMP server, it didn't work.

Possible duplicate of Codeigniter : The filetype you are attempting to upload is not allowed. Yesterday it was fine — MuntingInsekto
– MuntingInsekto, Commented Oct 30, 2015 at 3:04
try checking allowed mime type $config['allowed_types'] = 'xls'; is there — Linus
– Linus, Commented Oct 30, 2015 at 3:05
can you add this lines 'xlsx' => array('application/vnd.openxmlformats-officedocument.spreadsheetml.sheet','application/zip'), to application/config/mimes.php — MuntingInsekto
– MuntingInsekto, Commented Oct 30, 2015 at 3:13

HEMAL · Accepted Answer · 2015-10-30 05:44:43Z

4

For The file type you are attempting to upload is not allowed this issue occur because of your file type is wrong or not fulfill.

Please apply below step to get your file type.

You can looking at system/libraries/Upload.php line 199:

$this->_file_mime_type($_FILES[$field]);

Update that line to:

 $this->_file_mime_type($_FILES[$field]); var_dump($this->file_type); die();

Now you can see your actual file type Like xlsx or csv or xls or ods

Now you can add your file type below code

$config['allowed_types'] = 'xlsx|csv|xls';

also add in config/mimes.php

answered Oct 30, 2015 at 5:44

HEMAL

4303 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

d_unknown Over a year ago

it only displaying string 'application/vnd.ms-excel' (length=24)

HEMAL Over a year ago

go to application/config/mimes.php and apply below changes 'xls' => array('application/excel', 'application/vnd.ms-excel', 'application/msexcel'), to array('application/excel', 'application/vnd.ms-excel', 'application/octet-stream'),

d_unknown Over a year ago

thank you for your help. I noticed that I should just add the string displayed to mimes.php that corresponds to the file extension to be uploaded..

Vitor Novo · Accepted Answer · 2017-04-19 15:12:54Z

3

Codeigniter 3

add to your config/mimes.php types 'application/octet-stream'

'xlsx'  =>  array('application/octet-stream','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'application/zip', 'application/vnd.ms-excel', 'application/msword', 'application/x-zip')

then it will work

answered Apr 19, 2017 at 15:12

Vitor Novo

312 bronze badges

Comments

웃웃웃웃웃 · Accepted Answer · 2018-08-14 07:36:21Z

1

Go to config/mimes.php -> lines no 32 (xls) -> add 'application/vnd.ms-office' into existing array.

'xls'   =>  array('application/excel', 'application/vnd.ms-excel', 'application/msexcel', **'application/vnd.ms-office'**)

This work only for xls for any other type get the mime type and add into this array.

edited Aug 14, 2018 at 7:36

웃웃웃웃웃

12k15 gold badges63 silver badges95 bronze badges

answered Sep 23, 2017 at 7:39

Anup

17910 bronze badges

Comments

Abdulla Nilam · Accepted Answer · 2015-10-30 05:42:03Z

0

In your code

$config['allowed_types'] = 'xlsx|csv|xls';

But in Ubuntu it save file types is ods format. So it will never let allow to upload. add that

$config['allowed_types'] = 'xlsx|csv|xls|ods';

And in config/mimes.php

add this

'ods'   =>  array('application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'application/zip'),

Provide Permeation to write in the folder

sudo chown apache:apache -R /var/www/html

and in php.ini

Check file_upload is on
and check max upload limit
as well as check max execution time

edited Oct 30, 2015 at 5:42

answered Oct 30, 2015 at 4:55

Abdulla Nilam

39.7k18 gold badges85 silver badges115 bronze badges

3 Comments

Abdulla Nilam Over a year ago

@d_unknown check this

d_unknown Over a year ago

I checked the php.ini, added ods to mimes.php and allowed_type ods.. but it still didn't work..

d_unknown Over a year ago

I can actually upload a .xls file.. but not .xlsx and .csv.

Ashutosh Niranjan · Accepted Answer · 2019-11-13 12:22:19Z

0

If you are using liberOffice or Open Office, You will face this problem. add "application/octet-stream" type in 'xlsx' to your application/config/mimes.php

'xlsx'  =>  array('application/octet-stream','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'application/zip', 'application/vnd.ms-excel', 'application/msword', 'application/x-zip')

answered Nov 13, 2019 at 12:22

Ashutosh Niranjan

1451 silver badge7 bronze badges

Comments

Raman Kumar · Accepted Answer · 2018-03-24 11:25:07Z

-1

In Your Code Add Below Line

 $config['allowed_types']        = '*';
 $config['detect_mime']          = false;

this is configuration setting.

answered Mar 24, 2018 at 11:25

Raman Kumar

1298 bronze badges

Collectives™ on Stack Overflow

unable to upload an excel file in codeigniter

6 Answers 6

3 Comments

Comments

Comments

3 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

3 Comments

Comments

Comments

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related