Limitations in loading leads.

[sbenson]

Hello,
I'm trying to figure out if there is a way to import a list of 50,000 leads in one import, currently I'm splitting the list into 10k files and importing them in one at a time. This gets kind of annoying when I have 3 lists of 50k going in. Importing 15 different lists takes forever. We've already modified the php permissions to allow 16mb file uploads. the problem is that "listloader_stmts.txt" only accepts the first 17k or so? If there is something we can change please let me know so this can be a less tedious process. Thanks in advance and have a great day!

Scott

[mflorell]

Try using the command-line lead loader or raise your PHP memory values in php.ini.

[sbenson]

It isn't a PHP size limitation. If I have a list with 50000 leads, and it is 5.8mb all 5.8mb shows up in /tmp then it gets moved to /var/www/html/vicidial/tmp/. Then as it's converting the list to "listloader_stmts.txt" from "vicidial_temp_file.txt" it only grabs the first 15k to 17k lines. I just did it again and the listloader_stmts.txt file is only 1574 lines with ~10 leads per line. Also, what version was the command line lead loader implemented? We're using a somewhat old version and I'd like to see if it's possible to use. Also what is the actual command for it? Thanks

Scott

[eliasferreyra]

you can use this


file_uploads = On
upload_tmp_dir = "/tmp"
upload_max_filesize = 100M
post_max_size = 16M
memory_limit = 128M
max_input_time = 180
max_execution_time = 300

it works fine