Export data from listview blank page

💬 General Discussion
1

Export data from listview with more than 1000 records goes to blank page. No error or warning shown. Increased all necessary limit in php.ini

2

Hi arshath ,

Check your roles & user preference

Avdhut

3

Hi Avdhut,

Its an Admin role less than 1000 i can take an export but more than that its showing error. I have increased special query limit and values in php.ini

4

Solved it. Thanks for your comments

5

@arshath Could you please share with the community how you managed to solve the issue?

It will be beneficial for those who encounter the same problem in the future! :wink:

Thanks!

6

Ya sure.

Enable your error. If you find error as Notice:$where missing.
Just go to the file export.utils and add

$where=’ ';
above the if statement.

Now the problem is solved.

Cheers

7

Listview Data in suitecrm:

I can pass this values is API directly, But some of HREF and Link URL issue.

How to fix this problems???

8

Hi all,

If you have any problems with the complexity to export data from SuiteCRM I suggest Suite2Excel plugin. After install you can export any data from any list view or report to Excel.

https://store.suitecrm.com/search/1/suite2excel/