Author: bulcrack
Email: lito@voicefidelity.net
Tygra Leads Scrubber and Loader is windows based .NET application purposely developed for Vicidial 2.0.1, This will help the user to upload and scrub leads to vicidial server. The main kewl features for this is you can scrub againtst you existing leads from the server, So there is no chance to upload duplicated leads. it also have a self duplicate check. You can also export the Unique and Duplicated leads as .CSV file.
REQUIREMENTS:
.NET FRAMEWORK 2.0
http://www.microsoft.com/downloads/deta ... laylang=en
MYSQL Connector for .NET
http://dev.mysql.com/downloads/connector/net/1.0.html
File: adjust_leads_gmt.php
Please upload this to vicidial web directory (/usr/local/apache2/htdocs/vicidial)
and run cmd +x adjust_leads_gmt.php, This file is needed to adjust gmt offset after uploading the files.
HOW TO USE (DRAFT)
1. The first thing you need to do is to format you leads according to Tygra Leads format, Basically the format is like a standard vicidial leads format except for the first 4 columns are ommited. To see the proper format please click View -> Sample Leads Format on the application menu.
Make sure the file character set is set to UTF-8.
2. Then you need to configure your server settings side. You need to know the vicidial
database server ip, most implementions, the server is seperated from the asterisk server. so you need that information, you need database server ip, database username the default is cron and the database password default is 1234 based on the SCRATCH_INSTALL installation of vicidial.
3.After you punch in that information to Tygra Leads Loader, Click File -> Connect / Disconnect to server menu. The existing leads will now append on the Scrubbing List.
3. After you are connected, Select the formatted leads file to load by clicking SELECT FILE... hyperlink, You
can check if the format is correct by clicking File -> Check format Menu.
4. Okey!, so here it is, this is the most exiting part, To scrub leads againgst your existing list, Check the list Id from "Scrub Against List", Then Click Start Scrub Button to start scrubbing, this will take a while depends on how many leads you select for scrubbing and how big your leads file is. This will download all the phone number to scrubbing dictionary and check if existing, the perform a self duplicate checks on the file.
5. After scrubbing, A message box will pop-up saying the scrubbing results. You can now upload leads, export unique leads and export duplicated leads.
To Upload Leads, Click Upload Leads Link from the lower left corner of the application.
You need to fill up the ffolowing information.
Vendor Lead Code (optional), Source Code (optional), Lead Id, Lead Name.
Note: The system can detect existing list id,
To Export Unique Leads, Click Upload Leads Link from the lower left corner of the application.
To Export Duplicates Leads, Click Upload Leads Link from the lower left corner of the application.
To Copy Scrub Results to Clipboard, Click File -> Copy results to Clipboard.
Thank you for reading this HOW TO USE manual, if you have any comments or recomendation please
email lito@voicefidelity.net.
THANKS!
END
Screenshots
Download Installer Here
adjust_leads_gmt.php
ENJOY!
