⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

xls export results in blank page



davedriesmans
  • profile picture
  • Member

Posted 03 July 2013 - 21:11 PM

Is there a limit on the export?

 

I have a table with 10500 records, when i try to export them all i get a blank page and nothing happens.

when i do a search and select 1000+ i get the excel

 

is this because of some parameter limit? anything i can do?

 

this is my controller:

function funbas() 
{
        $data['maintab']=6;
        try{
            $crud = new grocery_CRUD();

            $crud->set_table('funbas');
            $crud->set_relation('GENUS', 'funbasGenus','genus');
            $crud->set_relation('categorie', 'funbasCategorie','categorie');
            $crud->set_relation('Eco1', 'funbasCdeEco','Functionele_groep');
            $crud->set_relation('Eco2', 'funbasCdeEco','Functionele_groep');
            $crud->set_relation('RLNL', 'funbasCdeRLNL', 'catNL');
            $crud->set_relation('RLVL', 'funbasCdeRLVL', 'catVL');
            $crud->set_relation('bibref', 'funbasBib', 'bib_titel');
            $crud->set_relation('funbas', 'funbasStatus', 'verklaring');
            $crud->set_subject('funbas');
            $crud->columns('GENUS', 'SOORTNAAM', 'SPECIES', 'NEDNAAM', 'NEDSYN');

            $output = $crud->render();
            $this->view_output($output, $data);

        }catch(Exception $e){
            show_error($e->getMessage().' --- '.$e->getTraceAsString());
        }
}

 


davidoster
  • profile picture
  • Member

Posted 04 July 2013 - 08:32 AM

It shouldn't! Try to use the datatables theme. It might be a theme issue.