adding leads to list

[rlabutis]

Sorry to all those technically savvy to be boring you with what is probably a simple question to which I have no answer. I am tryiing to load leads and once loaded create a list. They appear to load fine. I am using an excel format and therefore using the custom mapping. Once loaded the system indicates that 1,845 are good, 1 bad. 1844 total. I then try to add the list and it appears to load it fine until I check the dialable leads and it indicates I only have 240 to dial. Later that day I deleted the list and reloaded them from scratch to find this time I had 340 or so to dial. I have had this problem for a while. Why the discrepancy on the counts? Why aren't my usable leads the same as what it indicates when I load the leads?
I also have the detail campaign setting to "new Leads". FYI
Please help.
Rob

[okli]

What is campaign Local Call Time set to?
It will not show you the leads, which local time is out of campaign call time when you are viewing it.
In other words- if you campaign call time is 9am-9pm and you are checking at 8am or 10pm you will see 0 dialable leads, assuming you are in the same time zone as the leads.
Similar is when leads are in different time zones- if leads local time is out of campaign call times- it will not be counted as dialable lead.

[rlabutis]

I have it set to 24 he dialing so I. Am not sure if that is the problem. ?

[mflorell]

Please post the output from this MySQL query:

Select count(*),status,list_id from vicidial_list group by status,list_id;

[rlabutis]

mysql> Select count(*),status,list_id from vicidial_list group by status,list_id ;
+----------+--------+---------+
| count(*) | status | list_id |
+----------+--------+---------+
| 1 | A | 0 |
| 479 | A | 102 |
| 13 | A | 103 |
| 11 | A | 104 |
| 28 | A | 106 |
| 56 | A | 108 |
| 75 | A | 109 |
| 9 | A | 110 |
| 731 | B | 102 |
| 2 | B | 104 |
| 11 | B | 106 |
| 2 | B | 107 |
| 6 | B | 108 |
| 14 | B | 109 |
| 4 | B | 110 |
| 29 | CALLBK | 102 |
| 1 | CALLBK | 103 |
| 3 | CALLBK | 107 |
| 7 | CALLBK | 109 |
| 108 | CBHOLD | 102 |
| 10 | CBHOLD | 103 |
| 2 | CBHOLD | 104 |
| 16 | CBHOLD | 106 |
| 18 | CBHOLD | 108 |
| 24 | CBHOLD | 109 |
| 29 | CBHOLD | 110 |
| 1 | CBHOLD | 111 |
| 214 | DC | 102 |
| 8 | DC | 103 |
| 3 | DC | 104 |
| 9 | DC | 106 |
| 170 | DC | 108 |
| 238 | DC | 109 |
| 16 | DC | 110 |
| 1 | DC | 111 |
| 1 | DEC | 0 |
| 131 | DEC | 102 |
| 4 | DEC | 103 |
| 4 | DEC | 106 |
| 30 | DEC | 108 |
| 52 | DEC | 109 |
| 7 | DEC | 110 |
| 14 | DNC | 102 |
| 1 | DNC | 106 |
| 6 | DNC | 108 |
| 6 | DNC | 109 |
| 3680 | DROP | 102 |
| 133 | DROP | 103 |
| 53 | DROP | 104 |
| 220 | DROP | 106 |
| 8 | DROP | 107 |
| 1 | INCALL | 0 |
| 1 | INCALL | 108 |
| 5 | INCALL | 110 |
| 10 | N | 0 |
| 1234 | N | 102 |
| 55 | N | 103 |
| 12 | N | 104 |
| 364 | N | 106 |
| 2 | N | 107 |
| 472 | N | 108 |
| 796 | N | 109 |
| 67 | N | 110 |
| 7 | N | 111 |
| 8895 | NA | 102 |
| 300 | NA | 103 |
| 243 | NA | 104 |
| 797 | NA | 106 |
| 50 | NA | 107 |
| 5400 | NEW | 1 |
| 8960 | NEW | 101 |
| 261 | NEW | 102 |
| 15 | NEW | 103 |
| 1145 | NEW | 104 |
| 7 | NEW | 107 |
| 817 | NEW | 108 |
| 42 | NEW | 109 |
| 33 | NEW | 110 |
| 281 | NEW | 111 |
| 1 | NI | 0 |
| 352 | NI | 102 |
| 12 | NI | 103 |
| 9 | NI | 104 |
| 29 | NI | 106 |
| 7 | NI | 107 |
| 87 | NI | 108 |
| 150 | NI | 109 |
| 27 | NI | 110 |
| 1 | NP | 0 |
| 752 | NP | 102 |
| 38 | NP | 103 |
| 18 | NP | 104 |
| 85 | NP | 106 |
| 138 | NP | 108 |
| 421 | NP | 109 |
| 87 | NP | 110 |
| 1 | SALE | 0 |
| 16 | SALE | 102 |
| 3 | SALE | 103 |
| 6 | SALE | 106 |
| 12 | SALE | 107 |
| 9 | SALE | 108 |
| 35 | SALE | 109 |
| 6 | SALE | 110 |
+----------+--------+---------+
104 rows in set (0.21 sec)

[rlabutis]

I found the issue. My agent screen doesn't have a "business name" field so I have been putting that in the place of the address. The name of business was more important than the address. The problem is that the name in most cases exceeded the maximum number of characters allowed in that field. Is that possible. Next question is how do I add another field?

[mflorell]

There is no easy way of adding another field. I would suggest just lengthening the existing field you are using through MySQL.

[williamconley]

Alternately, of course, you could add that information in notes and preface it with "Company Name: "