MAGMA_tools questions

[kchung]

Special thanks to enjay for contributing his MAGMA_lead_admin scripts to the project.

I do have some questions about it, as I can't seem to get it working right.

First on my mind is the DNC loader. What format does it take? Can we upload the US Federal DNC flatfile list w/o modification?

As for the lead loader, I couldn't seem to get past uploading files. Again, what format does it accept? As for the column names in the first row, should new names be added to the MAGMA_loader table?

Also, if the scripts have problems, does it log the errors somewhere else besides the apache error_log?

[kchung]

[Mon Sep 25 12:50:33 2006] [error] [client 192.168.xxx.xxx] PHP Warning: upload_max_filesize of 2097152 bytes exceeded - file [dncfile=dnc_filename.sample] not saved in Unknown on line 0, referer: http://vicidial01/vicidial/MAGMA_lead_a ... =dncloader

Here's something to put in the instructions:
change upload_max_filesize in php.ini to the desired size. My question is, what's a 'good safe' size for our purpose?

Better: echo that error on the screen when user uploads something too big.

[kchung]

Other considerations:

[Mon Sep 25 13:58:25 2006] [error] [client 192.168.xxx.xxx] PHP Fatal error: Maximum execution time of 30 seconds exceeded in /var/www/html/vicidial/MAGMA_lead_admin_dncloader.php on line 192, referer: http://vicidial01/vicidial/MAGMA_lead_a ... =dncloader

Change max_execution_time = xxx in php.ini, where xxx is a reasonable number.

What do you suggest it be?

[mflorell]

The USA DNC list is NOT a safe size!

There are over 110,000,000 numbers in the US DNC list and it will cripple the system if you load them in.

You need to be filtering your leads by this before they get inserted into VICIDIAL.

[kchung]

We only upload area codes where we have an active campaign at. Is this still not good?

[enjay]

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



upload_max_filesize = 128M

[kchung]

What format does it take? Can we upload the US Federal DNC flatfile list w/o modification?
As for the lead loader, I couldn't seem to get past uploading files. Again, what format does it accept? As for the column names in the first row, should new names be added to the MAGMA_loader table?

What about my other questions?

[enjay]

CSV (if your CSV has quotations it will automatically remove them).

DNC:
PhoneNumber,DateAddedorRemoved,A (for add) D (for delete) is how I receive my DNC flatfiles.

NOTE: date added/removed is not necessary if it doesnt exist it will take it regardless. Additionally if there is no A or D it will always assume its an Add.

As far as the first row goes, yes read the code and make changes according to your environment.

-enjay