CRM

All installation and configuration problems and questions

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

CRM

Postby JR » Tue Sep 12, 2006 6:24 am

We have our Windows - Web based CRM that has the customer information among other things such as production reports for our type of work, export to certain software, etc.

Is there a way to integrate ViciDial's production data with our Windows based Web CRM:

1. Can we have our customer information Form (not script) show up as a screen pop when the call is answered using ViciDial? This would mean the same telephone number along with the other customer info.

2. Can the production data (such as - Leads generated, etc) be exported to our web hosted SQL database? Or can the 2 databases (MySql and SQL) communicate with each other?

Thanks
JR
 
Posts: 36
Joined: Mon Aug 21, 2006 10:24 pm

Re: CRM

Postby mflorell » Tue Sep 12, 2006 10:18 am

JR wrote:1. Can we have our customer information Form (not script) show up as a screen pop when the call is answered using ViciDial? This would mean the same telephone number along with the other customer info.


Yes, as long as it can accept the URL GET Query string data that vicidial sends to your CRM system. We have integrated with vtiger in this way.


2. Can the production data (such as - Leads generated, etc) be exported to our web hosted SQL database? Or can the 2 databases (MySql and SQL) communicate with each other?


Since it is just a database you can write any program you want to exchange or synchronize data between the two, but nothing comes pre-written with VICIDIAL except for the vtiger integration script.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby JR » Tue Sep 12, 2006 10:36 am

Would the URL GET Query work with non vtiger Windows CRM's?

Would this above mentioned Query bring up the customer information webform screen pop from our Web-based CRM realtime as VICIDial dials that number and there is a response from the part being called?

Thanks
JR
 
Posts: 36
Joined: Mon Aug 21, 2006 10:24 pm

Postby mflorell » Tue Sep 12, 2006 11:07 am

You would have to program a search page to work with your CRM. Nothing horribly difficult, but you would have to have knowledge of what field names your CRM search pages needs to accept the data as.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby JR » Tue Sep 12, 2006 12:17 pm

Where or which files in ViciDial would we have to modify in order to use the URL GET Query string data that vicidial would send to our CRM system.

Thanks
JR
 
Posts: 36
Joined: Mon Aug 21, 2006 10:24 pm

Postby mflorell » Tue Sep 12, 2006 12:32 pm

Nothing. You would need to create a middle-ware script to connect the two.

Take a look at the vtiger_search.php script to see how we do it there.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby JR » Tue Sep 12, 2006 12:44 pm

Thanks. Will do. Where or which loaction would I find the the vtiger_search.php script?
JR
 
Posts: 36
Joined: Mon Aug 21, 2006 10:24 pm

Postby mflorell » Tue Sep 12, 2006 1:22 pm

in the www/vicidial folder of the SVN 2-X trunk and the 2.0.1 beta releases.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida


Return to Support

Who is online

Users browsing this forum: Google [Bot] and 101 guests