I'd like to select all of my contacts for an export but it only allows me to select the first 1000. Is there a setting I can change to allow me to select more than 1000? Or is there a way to select the 2nd 1000?
I'd like to select all of my contacts for an export but it only allows me to select the first 1000. Is there a setting I can change to allow me to select more than 1000? Or is there a way to select the 2nd 1000?
Where would I find my php.ini file in my Sugar OnDemand instance???
--
Erica Kotula | Marketing Communications Manager
DocFinity - Optical Image Technology, Inc.
(814) 238-0038 x2-295
<http://www.linkedin.com/company/optical-image-technology>
<https://twitter.com/DocFinity>
<https://www.facebook.com/pages/DocFinity/428877853814436>
<http://www.docfinity.com/userconference16>
On Fri, Jul 1, 2016 at 11:24 AM, Ramana Santhana <sugarcrm-public@jiveon.com
Hi Erica,
It is not currently possible to export more than 1000 records which is default List View results, but this is something which we are working on to implement in the future:
https://web.sugarcrm.com/support/issues/66960
For now, the suggested workaround would be to create a report based on your needs and export the results. For more information on this, please see the following link:
Hope this helps. Please let me know if you need some help on creating a report.
-Chris
Yes, please look into this. I understand not being able to upload more than 1000 at a time, but exporting only 1000 at a time is a real problem. My former system (a lesser system) allowed me to download as many as I wanted with a warning that it could time out or take an extended period of time. It also allowed you to choose which fields you wanted to download - I never need all of the fields (it's actually cumbersome to have to go through them all after the download and delete what I don't need). I'm not a developer, but maybe adding this feature could help reduce the time to export and deliver a better list.
As for increasing the PHP memory limit in my php.ini file...I'm familiar with working with code, but where is it in your system? I've come across a couple instructions telling me to add things to the code, but I have no idea where to access it.
Just saw this as I was replying. I will try the report method to see if it works for what I'm trying to do. Thanks!
Since this post is dated July, 2016, it doesn't look like Sugar is going to fix this 1000 record hindrance anytime soon.
Hi Erica,
Actually you can control the amount of records that are selectable with the config parameter
'max_record_fetch_size'
By default this is 1000, you can increase that in the config.php or config_override.php
However increasing this too much might result in running into certain server limits. You can adjust those in the php.ini as suggested by Ramana.
Hope that helps!
- Dennis
Hi Erica Kotula
Check this article also you can increase your PHP memory limit in your php.ini file to do so
In your php.ini file change values accordingly.
Hope this Helps
Best Regars
S Ramana Raju