Ruby script to transfer appointed leads to vTiger CRM

[deephack]

Hello All,

Hope this is of some use to somebody, I wrote a little Ruby script which when run as a cron job checks for leads dis-positioned as 'APP' and then inserts them into vTiger as a new lead to be worked. Let me know if there is anything I can cleanup in it, been running well for a couple of months though so I'm happy it's working.

At this site 192.168.1.17 is the server running vTiger and a slave database to the main ViciDial diallers one as I didn't want to load up the main server with these queries. I make the insert as the admin user but assign the lead to the main sales manager.

Gah, forum thinks my code is spam. I'll try and work out another was of sharing this in a sec. Maybe pastebin.

[deephack]

Lol, I can't even paste a link to the pastebin for it. Okay, just visit pastebin and search for paste npA0zN0t

[williamconley]

1) Welcome to the Party!

2) when you post, please post your entire configuration including (but not limited to) your installation method and vicidial version with build.

this IS a requirement for posting along with reading the stickies (at the top of each forum) and the manager's manual (available on EFLO.net, both free and paid versions)

You should also post: Asterisk version, telephony hardware (model number is helpful here), cluster information if you have one, and whether any other software is installed in the box. If your installation method is "from scratch" you must post your operating system and should also post the .iso version from which you installed your original operating system. If your installation is "Hosted" list the site name of the host.

If this is a "Cloud" or "Virtual" server, please note the technology involved along with the version of that techology (ie: VMware Server Version 2.0.2). If it is not, merely stating the Motherboard model # and CPU would be helpful.

Similar to This:

Vicibox X.X from .iso | Vicidial X.X.X-XXX Build XXXXXX-XXXX | Asterisk X.X.X | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel DG35EC | Core2Quad Q6600

3) Consider the value of the "dispo url" in each campaign. Can hold a php or ruby or other script to make this happen at the moment of dispo. (We've written many such php scripts for many clients in vTiger and SugarCRM). The load on the server is negligible.