List Export Limits

[slider]

Hello.

Issue: I'm unable to export a list.

Steps:

Click on Lists -> Show Lists -> Click on List ID -> Scroll to Bottom -> Click on 'Click here to download this list'

Observations:

Smaller lists work. They download as a txt file and I can view them just fine. Larger list (this one has 229,441 records) do not. It saves a 0KB text file.

Question:

I'm curious to know if you know what this maximum list size is for download and if there is a work around in the web interface.

Assumption:

I'm assuming as a temporary fix I'll just get it from the database but my goal is to have something in the web interface so our managers can download data. Thanks everyone.

-----VERSION INFO-----

VERSION: 2.4-296
BUILD: 110111-1305
LoadAvg: 0.08
Agents: 10-20

Single Server (Database/Web/Vici)
Dell R710, 8 Cores, 8GB Memory
Sagoma USB Voice Timer / g711 to carrier

Linux vicibox-2 2.6.34.7-0.7-default #1 SMP 2010-12-13 11:13:53 +0100 x86_64 x86_64 x86_64 GNU/Linux

Asterisk 1.4.27.1-vici built by root @ vicibox-2 on a x86_64 running Linux on 2011-01-25 16:09:16 UTC

*No Extra Software After Install, No VTiger.

[williamconley]

you are likely experiencing a timeout issue with your web server. increase your timeout settings or use phpmyadmin (which has the option of zipping during download, drastically reducing file size)

[slider]

thanks william. you mind letting me know which file has the web server settings?

[mflorell]

php.ini

[boybawang]

php.ini look for file_uploads something, the value is in MB

[slider]

I see this,

; Maximum amount of memory a script may consume (128MB)

But not much else, any thoughts?

[boybawang]

just leave it that to stock , its the file uploads that you want to change

[mflorell]

You probably want to raise all of these:


max_execution_time = 30 ; Maximum execution time of each script, in seconds
max_input_time = 60 ; Maximum amount of time each script may spend parsing request data
memory_limit = 128M ; Maximum amount of memory a script may consume (128MB)
default_socket_timeout = 60

[slider]

I decided not to modify anything to keep our config stock in case we need other support. Instead I'm simply starting with a new list. Thank you for your help. I'll assume the list export limit is around 200,000+ records.

[williamconley]

When Matt says you can/should change it ... you should.

These changes will not make your system "non-stock" per se, they merely allow php to take more time with each page (handy for large uploads).

Also: many installs (such as Vicibox Web Only Install, if I recall) will change these during installation on a Stock box. So ...

[infinitegary]

I too am having this same issue i have 1 list that i kept adding to over the last year and the size of the list has grown to just under 900k records.
I first tried to export via phpmy admin but got timeout error as well.
I then tried what matt suggested with the following............

max_execution_time = 30 ; Maximum execution time of each script, in seconds
max_input_time = 60 ; Maximum amount of time each script may spend parsing request data
memory_limit = 128M ; Maximum amount of memory a script may consume (128MB)
default_socket_timeout = 60

Heres what i changed my settings to.......

max_execution_time =3000 Maximum execution time of each script, in seconds
max_input_time = 30000 ; Maximum amount of time each script may spend parsing request data
memory_limit = 2000M ; Maximum amount of memory a script may consume (2000MB)
default_socket_timeout = 3000


After making these changes i do not see any results the download dont even act like its trying to think about taking longer to perform this task. The same reult happens i open the file it says it downloaded and its blank.

Any ideas what i may need to do?

[sdixit311]

Hello Team , Hope you all are good

I have vicibox-express server 16GB RAM/1TB HDD / and Intel Xeon 12 Core processor

everything seems to be fine but I am facing an issue that I can't export a larger size file (like 100,000 records or more than this )

I have tried to change PhP.ini
max execution time and all

but still not happening

any suggestion will be really helpful
thanks in advance

[williamconley]

1) Welcome to the Party!

2) As you are obviously new here, I have some suggestions to help us all help you:

When you post, please post your entire configuration including (but not limited to) your installation method (7.X.X?) and vicidial version with build (VERSION: 2.X-XXXx ... BUILD: #####-####).

This IS a requirement for posting along with reading the stickies (at the top of each forum) and the manager's manual (available on EFLO.net, both free and paid versions)

You should also post: Asterisk version, telephony hardware (model number is helpful here), cluster information if you have one, and whether any other software is installed in the box. If your installation method is "manual/from scratch" you must post your operating system with version (and the .iso version from which you installed your original operating system) plus a link to the installation instructions you used. If your installation is "Hosted" list the site name of the host.

If this is a "Cloud" or "Virtual" server, please note the technology involved along with the version of that techology (ie: VMware Server Version 2.0.2). If it is not, merely stating the Motherboard model # and CPU would be helpful.

Similar to This:

Vicibox X.X from .iso | Vicidial X.X.X-XXX Build XXXXXX-XXXX | Asterisk X.X.X | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel DG35EC | Core2Quad Q6600

3) The export utility scripts have 100k hard-coded limits. In addition to modifying php.ini to allow extra time and size, you must also modify that max results directly in the file. Look for "100000" in the file and you'll likely find it.