Every loaded lead must have unique id?

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Every loaded lead must have unique id?

Postby scenarist » Tue Jun 09, 2015 1:31 pm

if I want to have unique id for every loaded lead, how can I realize that?
I have two fields VENDOR ID and SOURCE ID !
EXAMPLE
If I load one list with 10456 leads. Field VENDOR ID will be from 1 to 10456.
But when I need to load another list I must to remember last VENDOR ID number and I will put for second list VENDOR ID number from 10457 to 20789. On this way I always must remember last VENDOR ID !?
Also what is the range of numbers of field VENDOR ID (from x to xxxxx)?
Please any suggestion or solution?
Last edited by scenarist on Tue Jun 09, 2015 1:55 pm, edited 1 time in total.
Goautodial CE 2.1||Asterisk 1.4.39.1-vici||VERSION: 2.4-309a
BUILD: 110430-1642
Kernel Version: 2.6.18-238.9.1.el5.goPAE (SMP)
SIP trunk:15xsiptrunks|80 agents|7xserver
Model:7xIntel(R) Xeon(R) CPU E5520 @ 2.27GHz x16
CPU:2.27GHz|HDD:3*80GB|RAID 1|RAM:8GB
scenarist
 
Posts: 102
Joined: Mon May 23, 2011 2:53 am

Re: Every loaded lead must have unique id?

Postby williamconley » Tue Jun 09, 2015 1:42 pm

And you do not want to use the Lead_ID field from the asterisk_list table because ....?
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Every loaded lead must have unique id?

Postby scenarist » Tue Jun 09, 2015 1:54 pm

No,no. I use Lead_ID field! William you did not understand me completly.
Example: If I loaded 100 lists (Lead_IDs from 100 to 200) (total=200000 leads).
What will be unique ID for every lead ?
Goautodial CE 2.1||Asterisk 1.4.39.1-vici||VERSION: 2.4-309a
BUILD: 110430-1642
Kernel Version: 2.6.18-238.9.1.el5.goPAE (SMP)
SIP trunk:15xsiptrunks|80 agents|7xserver
Model:7xIntel(R) Xeon(R) CPU E5520 @ 2.27GHz x16
CPU:2.27GHz|HDD:3*80GB|RAID 1|RAM:8GB
scenarist
 
Posts: 102
Joined: Mon May 23, 2011 2:53 am

Re: Every loaded lead must have unique id?

Postby williamconley » Tue Jun 09, 2015 1:59 pm

lead_id field is a the unique ID for every lead. That's the definition of that field and it's purpose.

list_id is a different field and groups leads together into lists, which are assigned to campaigns.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Every loaded lead must have unique id?

Postby scenarist » Tue Jun 09, 2015 2:17 pm

OMG :)
you are right ! I inadvertently replaced list_id and lead_id while I was reading :)

System automatically assigns Lead_ID for every loaded lead!
I did not pay attention on that field at all!
Great!

Big Thanks @william
Goautodial CE 2.1||Asterisk 1.4.39.1-vici||VERSION: 2.4-309a
BUILD: 110430-1642
Kernel Version: 2.6.18-238.9.1.el5.goPAE (SMP)
SIP trunk:15xsiptrunks|80 agents|7xserver
Model:7xIntel(R) Xeon(R) CPU E5520 @ 2.27GHz x16
CPU:2.27GHz|HDD:3*80GB|RAID 1|RAM:8GB
scenarist
 
Posts: 102
Joined: Mon May 23, 2011 2:53 am

Re: Every loaded lead must have unique id?

Postby williamconley » Tue Jun 09, 2015 2:44 pm

No more caffeine for you. 8-)
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Every loaded lead must have unique id?

Postby scenarist » Tue Jun 09, 2015 2:55 pm

I am ashamed!
but,little consolation for me...The end of the day!
Concentration is low :)
Goautodial CE 2.1||Asterisk 1.4.39.1-vici||VERSION: 2.4-309a
BUILD: 110430-1642
Kernel Version: 2.6.18-238.9.1.el5.goPAE (SMP)
SIP trunk:15xsiptrunks|80 agents|7xserver
Model:7xIntel(R) Xeon(R) CPU E5520 @ 2.27GHz x16
CPU:2.27GHz|HDD:3*80GB|RAID 1|RAM:8GB
scenarist
 
Posts: 102
Joined: Mon May 23, 2011 2:53 am

Re: Every loaded lead must have unique id?

Postby williamconley » Tue Jun 09, 2015 3:06 pm

Look on the bright side, someone told you ... that coulda been a long day. LOL
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Every loaded lead must have unique id?

Postby scenarist » Tue Jun 09, 2015 3:22 pm

Just like that!
But I still can not believe what question I made. it's not me...:))) but simple it's just happens :oops: :oops:
Goautodial CE 2.1||Asterisk 1.4.39.1-vici||VERSION: 2.4-309a
BUILD: 110430-1642
Kernel Version: 2.6.18-238.9.1.el5.goPAE (SMP)
SIP trunk:15xsiptrunks|80 agents|7xserver
Model:7xIntel(R) Xeon(R) CPU E5520 @ 2.27GHz x16
CPU:2.27GHz|HDD:3*80GB|RAID 1|RAM:8GB
scenarist
 
Posts: 102
Joined: Mon May 23, 2011 2:53 am

Re: Every loaded lead must have unique id?

Postby williamconley » Tue Jun 09, 2015 3:53 pm

So upgrade your system to Vicibox. Maybe you'll enjoy your experience more. LOL 8-)

Did you know you can bring your present Vicidial DB (installed with Goautodial) into a Vicibox-installed up-to-date system ... and not lose any data while upgrading to the latest version of Vicidial to get all the new toys?

Not to mention gaining the ability to "multi-server/Cluster" ... always handy.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to Support

Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 107 guests