Page 1 of 1
Every loaded lead must have unique id?
Posted:
Tue Jun 09, 2015 1:31 pmby scenarist
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?
Re: Every loaded lead must have unique id?
Posted:
Tue Jun 09, 2015 1:42 pmby williamconley
And you do not want to use the Lead_ID field from the asterisk_list table because ....?
Re: Every loaded lead must have unique id?
Posted:
Tue Jun 09, 2015 1:54 pmby scenarist
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 ?
Re: Every loaded lead must have unique id?
Posted:
Tue Jun 09, 2015 1:59 pmby williamconley
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.
Re: Every loaded lead must have unique id?
Posted:
Tue Jun 09, 2015 2:17 pmby scenarist
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
Re: Every loaded lead must have unique id?
Posted:
Tue Jun 09, 2015 2:44 pmby williamconley
No more caffeine for you.
Re: Every loaded lead must have unique id?
Posted:
Tue Jun 09, 2015 2:55 pmby scenarist
I am ashamed!
but,little consolation for me...The end of the day!
Concentration is low
Re: Every loaded lead must have unique id?
Posted:
Tue Jun 09, 2015 3:06 pmby williamconley
Look on the bright side, someone told you ... that coulda been a long day. LOL
Re: Every loaded lead must have unique id?
Posted:
Tue Jun 09, 2015 3:22 pmby scenarist
Just like that!
But I still can not believe what question I made. it's not me...
)) but simple it's just happens
Re: Every loaded lead must have unique id?
Posted:
Tue Jun 09, 2015 3:53 pmby williamconley
So upgrade your system to Vicibox. Maybe you'll enjoy your experience more. LOL
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.