additional fields on vicidial.php

[saurabh4485]

how can i add new fields on telecaller screen in vicidial.php ?
in-which table i have to add those fields ?
Please help !!

[mflorell]

It is actually quite difficult to do which is why we recommend linking with a CRM or other application like Vtiger to allow you a more robust and customizable screen.

This is not a very difficult task using the WEB FORM or SCRIPT tab with an IFRAME inside it.

In the SVN trunk codebase we have even done a more complete integration with Vtiger.

[saurabh4485]

I want to add two new fields on vicidial.php
1) Annual Income.
2) DOB.
How can i change it in code.

[mflorell]

You would need to change the vicidial_list table in the database.

You would need to add those fields into the code in the vicidial.php and vdc_db_query.php scripts in about 20-30 places.

[williamconley]

On the other hand ... dob is already in the table.

For income you could use another field you aren't using ("title"?) and just rename it on the agent screen

... and make the birthday visible.

[saurabh4485]

thanks alot to give me idea,It's work.

[lemmor27]

i have the same needs, but for me i just need to insert "Order Number" on the interface.

actually here is the scenario, our web devs have a script that pull's out everything that in vicidial_closer_log.

we added a new field on the said table which is "odernum".

i already have a field in the agent interface "Oder Number" next to "Address1" but the question is how can i put the value of that field to vicidial_closer_log "ordernum" field.

i cant seem to find a query in vicidial.php that inserts something on vicidial_closer_log.

please help.

[mflorell]

The query isn't in vicidial.php, it is in vdc_db_query.php most likely and you have to use the XMLHTTPRequest functions that are already there to pass it to that script.

[lemmor27]

Thanks for the reply.

it seems to be harder than i think because i am not familiar with XML, thought it was just a simple PHP/Mysql editing.

is this the only way to have it done?

Thanks

[mflorell]

Yep, AJAX isn't easy. and yes, that's the only way to have it show up on the screen and be updated in the logs.

[lemmor27]

thanks again.

seems like i am going somewhere now.

i was able to locate the $GET and $POST part on the vdc_db_query.php
i added this part.

if (isset($_GET["ordernumber"])) {$order_number=$_GET["ordernumber"];}
elseif (isset($_POST["ordernumber"])) {$order_number=$_POST["ordernumber"];}

and have something like this on the dispo part

$stmt = "UPDATE vicidial_closer_log set status='$dispo_choice', ordernum='$order_number' where lead_id='$lead_id' and user='$user' order by closecallid desc limit 1;";

but all that it gives me is a blank "ordernum" which is one step forward because i have it as "null" by default, i was thinking that it now passes the value but it doesn't get the value that the agent inputted.

i supposed when you press "Hangup Customer" on agent interface it means submit? or am i getting this wrong...

thanks again.

[mflorell]

Well, that's one small piece of the puzzle, adding a field usually takes me a couple of hours to do it properly, and I wrote VICIDIAL. That's 2 hours without touching the admin side of things too.

The problem is that at this point VICIDIAL is quite complex and has so many features that you need to check multiple places to make sure you are sending data in all possible situations. In your case, you need to account for auto-dial calls, inbound calls, manual dial calls, preview dial calls and callbacks. Each with their own special conditions that need to be taken into consideration.

[lemmor27]

i see.

thanks.

[sam111]

thanks again.

seems like i am going somewhere now.

i was able to locate the $GET and $POST part on the vdc_db_query.php
i added this part.

if (isset($_GET["ordernumber"])) {$order_number=$_GET["ordernumber"];}
elseif (isset($_POST["ordernumber"])) {$order_number=$_POST["ordernumber"];}

and have something like this on the dispo part

$stmt = "UPDATE vicidial_closer_log set status='$dispo_choice', ordernum='$order_number' where lead_id='$lead_id' and user='$user' order by closecallid desc limit 1;";

but all that it gives me is a blank "ordernum" which is one step forward because i have it as "null" by default, i was thinking that it now passes the value but it doesn't get the value that the agent inputted.

i supposed when you press "Hangup Customer" on agent interface it means submit? or am i getting this wrong...

thanks again.

hello
there are two or three directory where did u make change.

/var/www/html/agc.new OR /var/www/html/agc or /usr/src/astguiclient/www/ all having same kind of files..

[sam111]

On the other hand ... dob is already in the table.

For income you could use another field you aren't using ("title"?) and just rename it on the agent screen

... and make the birthday visible.

hi
please guide me how to make birth date visible...