Page 1 of 1

See Lead Date

PostPosted: Fri Jan 11, 2013 1:25 pm
by hiadviser
Hey guys,

I wanted to know if it was possible for the Agents to see the date the lead was loaded on their screen?

We have two lists in a campaign right now, one is older than the other. New leads are being added everyday, so we want to show them the lead date on their screen somewhere.

Is this possible to do?

Thank you.

ViciDial VERSION: 2.6-385a | BUILD: 121124-1957 | Asterisk 1.4.21.2-vici | Single Server| No Digium/Sangoma Hardware | No Extra Software After Installation | Server Being hosted by someone else (dont know specs for it)

Re: See Lead Date

PostPosted: Mon Jan 14, 2013 11:11 am
by DomeDan
Yes it is possible, I've done similar things, just add the date to any of the fields that are not in use.

As an example, I use the field security_phrase as the value of the last order for the lead
and its possible to change the label on the agent-interface under System Settings (depending on what vicidial-version your using though... that you didnt write... do that the next time ;))

Re: See Lead Date

PostPosted: Mon Jan 14, 2013 4:26 pm
by hiadviser
Ah ok, I know what you mean. So would the label be changed to lead_date. Not sure where I would find that or what it is.

Re: See Lead Date

PostPosted: Mon Jan 14, 2013 4:33 pm
by ZoVoS
I think hes telling you to add the date you are uploading it to your file (data to be uploaded) and then

ADMIN -> System Settings -> *scroll to gray area*

And rename whatever field you uploaded it as.

I personally would alter the Vicidial Script to show entry_date as it is part of the table... come to think of it you can add that as a CUSTOM FIELDS and then you wont need to make any changes to anything.

(entry_data is a field in the VICIDIAL_LIST table so if you add it to a custom list it will turn red and auto populate)

Re: See Lead Date

PostPosted: Tue Jan 15, 2013 5:32 am
by DomeDan
Oh I've forgot about entry_date.
Try with that, creating custom fields in covered in the manual

Re: See Lead Date

PostPosted: Wed Feb 13, 2013 9:30 am
by williamconley
Be careful with custom fields unless you can set it to view only (after all, you don't want to allow the agent to modify the entry date field if you use it in statistics ...). but you could dupe the entry date into the birthdate field and show that in custom fields.

Generally, we would likely use the aforementioned security_phrase option and modify the label to Entry Date. It is quite possible to run a simple sql query to Copy entrydate to securityphrase each time you load a list (or every morning, or hourly for those missing that field, etc).

Re: See Lead Date

PostPosted: Wed Feb 13, 2013 11:15 am
by geoff3dmg
I use the date as the listid. So for example, loading a list today would be a list id of '20130213'. Then enable the campaign setting to show the list ID to the agents. Easy :)

Re: See Lead Date

PostPosted: Wed Feb 13, 2013 12:26 pm
by williamconley
geoff3dmg wrote:I use the date as the listid. So for example, loading a list today would be a list id of '20130213'. Then enable the campaign setting to show the list ID to the agents. Easy :)
I like that. Tricky and simple. 8-)

Re: See Lead Date

PostPosted: Tue Jan 26, 2016 8:22 am
by mosskatz
Hi,
I am trying to add --A--entry_date--B-- to my script and it is just showing the text as --A--entry_date--B--

all other fields are fine, is that the correct field name?

Many Thanks

G


VERSION: 2.10-472a
BUILD: 150120-0749

Re: See Lead Date

PostPosted: Tue Jan 26, 2016 8:48 am
by mflorell
You need to upgrade your system, that variable was added to scripts in July of 2015.

Re: See Lead Date

PostPosted: Mon Feb 01, 2016 10:48 am
by mosskatz
Thank you v much

Re: See Lead Date

PostPosted: Tue May 10, 2016 5:40 am
by mosskatz
I've upgraded but cannot see entry_date in the drop down
Is it something else? SQLDate?