Question about Cdr report export limit

Hi! i searched trough google and the forum but couldnt find an answer.
Im trying to export like 100.000+ record from the cdrReport, and so far i only manage to export about 20.000, is there a way to export this many records? is it posible? Any help would be apreciated! Thanks! :slight_smile:

pd:i know the ram has a lot to do with this, is there a way to change the ram size in the cdrReport module?

You could change the memory and time-out limits in php.ini, but easier is to either just get the

/var/log/asterisk/cdr-csv/Master.csv*

files and filter to suit, or construct a mysql query to suit, something like:-

mysql -uuser -ppassword -D asteriskcdrdb -e “select * from cdr WHERE ‘calldate’ >‘2013-01-02’”

Great thanks Dicko!! changed the settings in php.ini and exports fine, cant use the query cause is for a dummy user so i have to make it work trough the gui of freepbx, but it works thanks again! here are the settings on php.ini:

max_execution_time = 180
max_input_time = 180
memory_limit = 512M