vicidial.org

hi
My asterisk and vicidialer installation went fine ( although initially i faced many obstacles).
Now my problem is when i tried to upload leads using list loader and super lead loader am getting,
Error: The file does not have required number of fields to process it.
i used the sample list "testMulti_VICIDIAL_lead_file.csv which i got from vici. what would be the issue. .please help me to sort it out....

thanks in advance

make sure the list of the fields in their proper order... or you can try super lead loader to load the fields in custom layout.

Do you have uploads enabled in php.ini?

is your vicidial web directory world-writable?

hi thanks for the replies

make sure the list of the fields in their proper order... or you can try super lead loader to load the fields in custom layout.

i have used the sample format which i got from vici server, so i believe that the fields are in proper order.

Do you have uploads enabled in php.ini?
is your vicidial web directory world-writable?

i have check that and it is fine. i have another doubt. is this problem any way related to crontab. i mean,does this happen if some scripts are not running or not included in crontab.
thankyou

This should have nothing to do with any crontab scripts. The issue is usually an Apache or PHP issue or a problem with file/directory permissions.

I am having the same problem. In addition, when I create a list (add list), and then go to show list, there are none!

root@asterisk:/usr/local/apache2/htdocs# ls -al
total 164
drwxr-xr-x 5 root root 4096 2007-02-23 04:21 ./
drwxr-xr-x 15 root root 4096 2007-02-23 03:14 ../
drwxrwxrwx 3 root root 4096 2007-02-28 21:15 agc/
-rw-r--r-- 1 500 500 2326 2004-11-21 09:35 apache_pb.gif
-rw-r--r-- 1 500 500 1385 2004-11-21 09:35 apache_pb.png
-rw-r--r-- 1 500 500 2414 2004-11-21 09:35 apache_pb2.gif
-rw-r--r-- 1 500 500 1463 2004-11-21 09:35 apache_pb2.png
-rw-r--r-- 1 500 500 2160 2004-11-21 09:35 apache_pb2_ani.gif
drwxrwxrwx 2 root root 4096 2007-02-23 04:21 astguiclient/
-rw-r--r-- 1 500 500 1663 2004-11-21 09:35 index.html.ca
-rw-r--r-- 1 500 500 1583 2004-11-21 09:35 index.html.cz.iso8859-2
-rw-r--r-- 1 500 500 2202 2004-11-21 09:35 index.html.de
-rw-r--r-- 1 500 500 1508 2004-11-21 09:35 index.html.dk
-rw-r--r-- 1 500 500 1828 2004-11-21 09:35 index.html.ee
-rw-r--r-- 1 500 500 1618 2004-11-21 09:35 index.html.el
-rw-r--r-- 1 500 500 1456 2004-11-21 09:35 index.html.en
-rw-r--r-- 1 500 500 1735 2006-06-26 12:14 index.html.es
-rw-r--r-- 1 500 500 1867 2004-11-21 09:35 index.html.et
-rw-r--r-- 1 500 500 1505 2004-11-21 09:35 index.html.fr
-rw-r--r-- 1 500 500 3704 2004-11-21 09:35 index.html.he.iso8859-8
-rw-r--r-- 1 500 500 1604 2004-11-21 09:35 index.html.hr.iso8859-2
-rw-r--r-- 1 500 500 1788 2004-11-21 09:35 index.html.it
-rw-r--r-- 1 500 500 1630 2004-11-21 09:35 index.html.ja.iso2022-jp
-rw-r--r-- 1 500 500 1543 2004-11-21 09:35 index.html.ko.euc-kr
-rw-r--r-- 1 500 500 1837 2004-11-21 09:35 index.html.lb.utf8
-rw-r--r-- 1 500 500 1968 2004-11-21 09:35 index.html.nl
-rw-r--r-- 1 500 500 1534 2004-11-21 09:35 index.html.nn
-rw-r--r-- 1 500 500 1467 2004-11-21 09:35 index.html.no
-rw-r--r-- 1 500 500 1438 2004-11-21 09:35 index.html.po.iso8859-2
-rw-r--r-- 1 500 500 1773 2004-11-21 09:35 index.html.pt
-rw-r--r-- 1 500 500 2046 2004-11-21 09:35 index.html.pt-br
-rw-r--r-- 1 500 500 1522 2004-11-21 09:35 index.html.ru.cp-1251
-rw-r--r-- 1 500 500 1515 2004-11-21 09:35 index.html.ru.cp866
-rw-r--r-- 1 500 500 1520 2004-11-21 09:35 index.html.ru.iso-ru
-rw-r--r-- 1 500 500 1516 2004-11-21 09:35 index.html.ru.koi8-r
-rw-r--r-- 1 500 500 2249 2004-11-21 09:35 index.html.ru.utf8
-rw-r--r-- 1 500 500 1631 2004-11-21 09:35 index.html.sv
-rw-r--r-- 1 500 500 2401 2004-11-21 09:35 index.html.var
-rw-r--r-- 1 500 500 1018 2004-11-21 09:35 index.html.zh-cn.gb2312
-rw-r--r-- 1 500 500 1032 2004-11-21 09:35 index.html.zh-tw.big5
drwxrwxrwx 4 root root 4096 2007-02-28 21:37 vicidial/


permissions are ok and uploads are on in php.ini....

What versions of Apache and PHP?

Apache Version Apache/2.0.59 (Unix) PHP/4.4.4

Those are the same versions I am using, What is your php.ini memory_limit set to?

Try loading testMULTI_VICIDIAL_lead_file.txt in extras directory of setup it's pipe delimited and should load in basic lead loader . by any chance did u made any changes to vicidial_list table ?

mflorell wrote:Those are the same versions I am using, What is your php.ini memory_limit set to?

memory_limit = 64M

aster1 wrote:Try loading testMULTI_VICIDIAL_lead_file.txt in extras directory of setup it's pipe delimited and should load in basic lead loader . by any chance did u made any changes to vicidial_list table ?

ERROR: The file does not have the required number of fields to process it.

No adjustments...

try to use the super list loader. Use the custom layout format as gerski said.

Is this the super lead loader or the standard web-based lead loader?

mflorell wrote:Is this the super lead loader or the standard web-based lead loader?

Same message -- standard or super. If I choose custom, I get the same response...

I also tried, "add a list" and putting in the list ID that I entered into the database during the scratch install. Here is the result of that:

LIST ADDED: 101

MODIFY A LISTS RECORD:
List ID: HELP
List Name: HELP
Campaign: HELP
Active: HELP
Reset Lead-Called-Status for this list: HELP

STATUSES WITHIN THIS LIST:
STATUS STATUS NAME CALLED NOT CALLED
NEW New Lead 0 14
SUBTOTALS 0 14
TOTAL 14


TIME ZONES WITHIN THIS LIST:
GMT OFFSET NOW (local time) CALLED NOT CALLED
-5.00 (Sat Mar 2007 14:19) 0 14
SUBTOTALS 0 14
TOTAL 14


CALLED COUNTS WITHIN THIS LIST:
STATUS STATUS NAME 0 SUBTOTAL
NEW New Lead 14 14
TOTAL 14 14

However, when I then go to show list, there are no lists showing. In addition, if I try to modify the list at all, there are 0 leads and there is then no list showing...

Something is most likely preventing the list from properly being created in the database.

What version of astguiclient are you using?

Can you post the results of "describe vicidial_lists;" in MySQL?

astguiclient 2.0.2

mysql> use asterisk;
Database changed
mysql> describe vicidial_lists;
+-------------------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+---------------------+------+-----+---------+-------+
| list_id | bigint(14) unsigned | | PRI | 0 | |
| list_name | varchar(30) | YES | | NULL | |
| campaign_id | varchar(8) | YES | | NULL | |
| active | enum('Y','N') | YES | | NULL | |
| list_description | varchar(255) | YES | | NULL | |
| list_changedate | datetime | YES | | NULL | |
| list_lastcalldate | datetime | YES | | NULL | |
+-------------------+---------------------+------+-----+---------+-------+
7 rows in set (0.01 sec)

mysql>

Looks like you're using the 2.0.3 database table with your 2.0.2 admin.php code which will not work.

ERROR: The file does not have the required number of fields to process it.

is accuring while uploading a testMULTI_VICIDIAL_lead_file.csv


I am using Fedora core 6

with Apache 2.0, PHP 5.1.6 & MYSQL : 5.0.22

mflorell wrote:Looks like you're using the 2.0.3 database table with your 2.0.2 admin.php code which will not work.

DOH! That solved the problem. Thanks!

I don't know verison of database tables and admin.php i am flowing the scrach install in the site http://astguiclient.sourceforge.net/scr ... stall.html

i have some problem while instaling cpan modules, is cpan module is essential for vicidial how can i reconfigure the cpan