
Archive for the ‘CRM’ Category
7 Best Open Source CRM Software For Your Small Business

Major Modules of vTiger CRM and its uses
Lead Management:
This module manages the leads from creating to converting them into opportunities. It import leads from external sources like trade shows, seminars, web downloads, and direct mail. It also changes lead status according to the sales process. Users can convert their leads into sales opportunities, accounts, and contacts with just one-click.Account Management:
It keeps a track on all the activities related to accounts and things related to it. It can easily track the parent-child relation between different account and their divisions. The best thing is it takes accounts from external sources, like GoldMine, ACT, and other applications. For future reference, it attaches customer-specific documents to accounts.Product Customization:
You can consider it as inventory management. It makes custom fields/ pick lists according to business requirements. You can also personalize tabs by using drag & drop functionality to veil the modules irrelevant to sales process.
Activity Management:
This module basically makes your work faster. It adds vital information of clients or customers in vTiger CRM. It also stores all the details of customer’s call and meeting and manages daily tasks.Contact Management:
As mentioned above, it tracks down all contact and related opportunities, activities, and other details from a common place. It creates contact hierarchy within a company for coordinating while dealing with customers. It also imports and exports contacts from external sources and to spreadsheet software respectively for further analysis.Security Management:
For better security management, it defines team roles according to organization structure and controls the access to modules as per employee’s role and saves the login history of each user.Microsoft Outlook Plug-in:
You can also add outbound and forward inbound Outlook e-mails to vTiger CRM. One can also synchronize contacts, tasks, and calendar between Microsoft and Outlook and vTiger CRM. It also helps to filter e-mails in Microsoft Outlook and adds emails, which are necessary.Opportunity Management:
It tracks all sales opportunities and other associated opportunities with accounts, contacts, activities, and other modules to enhance better visibility. It also exports opportunities to spreadsheet software like Open Office, Microsoft Excel, and others in order to examine the sales pipeline and quickly recognize the restricted access.
Conclusion:
In conclusion, vTiger CRM is among the best and easy to use CRMs. It efficiently manage your data at a cost-effective way. So, the choice is yours which one is best for you.SugarCRM vs vTiger- Which on Would You Choose?

Let’s first take a look at SugarCRM
SugarCRM is being used from a long time by a community of talented developers all over the world. It has an enterprise edition available which is hosted by Sugar with additional functionality. One can download and install it on their own server. The process is not too difficult, a person with decent technical knowledge could do it within 30 minutes.
Pros:
There are several reasons why it is being used abundantly-- It is flexible as compared to other open source CRMs. There are some CRMs that are built with some main use-cases in mind but doesn’t necessarily adapt for organizations that need a good amount of flexibility.
- Its studio builder is very smooth. It has a drag and drop interface to easily customize different screens. It also has amazing access control to provide access to some user and constricting other users to a tailored view.
- The best part is reporting dashboard as every user can have different view according to their specific needs.
Cons:
- Well, there are no cons as such, the only thing which bothers people now is its enterprise version. There is no community support which means there is no community edition. An enterprise has to buy a premium edition after completing its trial period.
Let’s take a look at vTiger.
Another hugely used open source CRM is vTiger, though it is built with the code used in SugarCRM. It has many tools that make it easy for users to opt-in for certain marketing offers and information becomes populated in the CRM.
Pros:
- Better marketing tools for populating the information in CRM. It is easy for users to opt-in.
- Well-developed and easy-to-use management features as compared to other CRMs.
- A good forefront which makes it easy for the users to work on it. In many systems, the CRM project management feature tends to be a bit overlooked.
Cons:
- UI needs improvements as it has a flat design which doesn’t look so great.
- vTiger’s development community is not as active as Sugar’s community.
Summing up
Let us sum things up to make it easy for you to decide which one is better for you-- vTiger is entirely free and depends on volunteer work while SugarCRM has a paid version.
- SugarCRM has more advanced functionalities that can be altered according to organization’s size.
- vTiger loads faster may due to less complicated functionality, but it really saves time.
- Though vTiger is easy to use, SugarCRM compensates it with customizable user interface.
- Though both applications are considered to have tricky upgrade process, vTiger is still considered easier one.
Rapportive Alternatives
As LinkedIn pulls the plug on the features that once made Rapportive such a popular extension, we analyzed the various similar extensions in the chrome store and how closely they fulfill the void that Rapportive has left :
Rapporto: One of the fastest dropins for Rapportive, the plugin almost emulates the original Rapportive functionality and matches the UI as well seamlessly. The chrome extension might not be exactly same as rapportive but it gets sufficiently close to fill the void. However, if you would to see some trusted names behind the product, then Rapporto might not be the way for you. Moreover, the future of Rapporto is not yet certain as its founders are yet to comment on the roadmap for the extension.
Vibe: We have been using Vibe before Rapportive as well but the current changes in Rapportive make it much more viable. Vibe is just not a gmail extension as it is available on a plenty of platforms including Mobile platforms(Android, iPhone etc). You can just hover over any email on any website and Vibe will bring up a nice looking widget presenting the information about the user. The UI is eye candy though it might not be as sleek as Rapportive’s. The application is free for personal use and you will need to contact their sales team if you wish to use the application for business purposes.
Ark Browser Plugin : Ark is a browser plugin which enables you to see contact information from not only gmail but yahoo, hotmail and AOL as well. The plugin goes quite close to the Rapportive in terms of UI and seems to have quite a lot of contacts indexed. The plugin is available on firefox as well if you are not a Chrome Junkie.
360social.me : 360social.me is an extremely robust browser plugin which presents the information quite similar to Rapportive did in its original role, the UI however is not as sleek as Rapportive. The extension is free to use but it comes with a professional plan as well for which they charge nominal subscription fees.
We are sure that one of the above apps will replace your rapportive workflow. If you are already using some other plugin, we look forward to your comments.Problem displaying picklist values in vTiger
<?php $Vtiger_Utils_Log = true; include_once('vtlib/Vtiger/Module.php'); $module = Vtiger_Module::getInstance('ModuleName'); if ($module) { $module->delete(); } ?>Here ‘ModuleName’ depicts the name of your module. Copy this code to any text editor and then save file with name ‘Delete_ModuleName.php’. Once created run this file on your webserver. Once done with this go to your module creation file where we’ll resemble the following format:
<?php $Vtiger_Utils_Log = true; include_once('vtlib/Vtiger/Menu.php'); include_once('vtlib/Vtiger/Module.php'); $module = new Vtiger_Module(); $module->name = 'ModuleName'; $module->save(); $module->initTables(); // Initialize all the tables required $module->initWebservice(); // Creates a entry in vtiger_ws_entity $menu = Vtiger_Menu::getInstance('Tools'); // Add the module to the Menu $menu->addModule($module); $block1 = new Vtiger_Block(); // Add the basic module block $block1->label = 'LBL_MODULENAME_INFORMATION'; $module->addBlock($block1); $field1 = new Vtiger_Field(); //Create fields and add to the module $field1->name = 'name'; $field1->label = 'Name'; $field1->table = $module->basetable; $field1->column = 'name'; $field1->columntype = 'VARCHAR(255)'; $field1->uitype = 2; $field1->typeofdata = 'V~M'; // Varchar~Mandatory $block1->addField($field1); // Creates the field and adds to block $module->setEntityIdentifier($field1); // Set at-least one field to identifier of module $field2 = new Vtiger_Field(); $field2->name = 'type'; $field2->label = 'Type'; $field2->table = $module->basetable; $field2->column = 'type'; $field2->columntype = 'VARCHAR(100)'; $field2->uitype = 15; $field2->typeofdata = 'V~O'; // Varchar~Optional $block1->addField($field2); $field2->setPicklistValues( Array ('Employee', 'Trainee') ); // Picklist values are set // Common fields that should be in every module, linked to vtiger CRM core table /**Common fileds that have to be incorporated are: * assigned_user_id * createdtime * modifiedtime */ $filter1 = new Vtiger_Filter(); // Create default custom filter $filter1->name = 'All'; $filter1->isdefault = true; $module->addFilter($filter1); $filter1->addField($field1); // Add fields to the filter created $filter1->addField($field2, 1); $filter1->addField($field3, 2); $module->setDefaultSharing('Public_ReadWrite'); / Set sharing access of this module $module->enableTools(Array('Import', 'Export')); //Enable and Disable available tools $module->disableTools('Merge'); ?>Points to be taken care of while creating the ‘vtlib module creation file’: 1) Check your vtlib script for the line “$module->initWebservice()” as it creates entry in vtiger_ws_entity. 2) “$module->setEntityIdentifier” must be set at least once for the mandatory field of the module. 3) While creating field for picklist do ensure that it refers to “$module->basetable” as without it the picklist values will enter the database but won’t be called in UI. This problem was rampant in the default ‘Payslip’ module creation file as its picklist field expunged this table declaration. After formulating this backend and executing we are left with frontend of our module (modules/ModuleName) and all the files of frontend following it. Now in the file naming ‘ModuleName.php’ we have:
var $list_fields = Array (); var $list_fields_name = Array();Here we have to add each and every field (in the format assigned) we have declared in ‘vtlib creation file’ to be listed in UI. Following the above steps can help you eradicated deadly errors with picklist values. Please comment in the blog post if you still face issues and we would be happy to help.
Creating new fields in a vtiger module
- Go to Settings>custom Fields>
- Select the Module for which you want to create new fields
- Click on Add New field option
- Add Label name for the field
- Select the Field Type
<pre>$this->db->query("insert into vtiger_field values ( <tabid>, $this->db->getUniqueID("vtiger_field"), <columnname>, <tablename>, <generatedtype>, <uitype>, <fieldname>, <fieldlabel>, <readonly>, <presence>, <selected>, <maximumlength>, <sequence>, <block>, <displaytype>, <typeofdata>, <quickcreate>, <quickcreatesequence>, <info_type>, <masseditable>, <helpinfo> )"); </pre>Here is an overview of what each of the columns mean:
Field | Description | Allowed Values |
tabid | ID number of the module (from vtiger_tab) | INT, tabid types |
fieldid | ID of field; generated by getUniqueID(“vtiger_field”). Normally obtained at installation. | INT |
columnname | Name of the column in its table | any |
tablename | Name of the table that stores field | any table |
generatedtype | Specifies type of field in module whether 1=’Exisiting’ or 2=’User Defined’ | 1,2 |
uitype | Handles what widget displays field | Ui types |
fieldname | The vTiger name of the field | ?? |
fieldlabel | The label name of the field | vTiger will look for fieldlabel as a key in the the $mod_strings array stored at modules/ModuleName/language/<language prefix>.lang.php |
readonly | 0=true(ro) 1=false(rw) | BOOLEAN |
presence | represent the field existence | 1 to reprsent existence and 0 to represent non-existence |
selected | ?? | ?? |
maximumlength | ?? | ?? |
sequence | The display order of your field in your block. | Number (1,2,3…) |
block | Block id (from Vtiger blocks) where the field will appear | INT |
displaytype | Indicates if field will be displayed on Create/Edit & Detail View. 1=displayed on all views, 2=displayed only in detail view (but not in edit), 3=field will not come separately, it will come along with other field, 4= only in the createview. it will not come other views(detailview & editview) | 1,2,3,4 |
typeofdata | X~Y, where X is the type of data V for varchar, N for numbers etc and Y stands for (O)ptional or (M)andatory | INV…~OM |
quickcreate | if field appears or not on quickcreate field | 0/1 |
quickcreatesequence | sequence of field in quick create screen | number |
info_type | ‘BAS’ field is displayed in Basic Information, ‘ADV’ field is displayed in More information | BAS or ADV |
$this->db->query("insert into vtiger_field values (18,".$this->db->getUniqueID("vtiger_field").",'website','vtiger_vendor',1,'17', 'website','Website',1,2,0,100,6,45,'V~O',1,null,'BAS',1)");You will need to add this query to modules/Users/DefaultDataPopulator.php to bundle the above field with a fresh vtiger installation. And thats all that you need to do to add a new field to a vtiger instance. Please let me know if any queries and we would be happy to answer.
Changing the date format in vTiger
- Goto Settings -> Settings
- Click on the Users
- Click on the edit icon for User that you want to change the date format for.
- In the More information, there will be a drop down listing various formats for the date.
- Chose the date format that you want for this user and you are all done !!!
Join Us