Saturday, October 10, 2015

How to Migrate Vtiger crm 6.2.0 to 6.3.0

Vtiger announced New version of  Vtiger CRM 6.3.0. In the past 4 months, since released Vtiger CRM 6.2, Vtiger focused our efforts on improving stability. Vtiger 6.3 also features minor API enhancements for better integration.

Vtiger 6.3.0 Highlights:
  • RelatedList API added to Vtiger Web Services.
  • Fixes for 96 issues reported on trac.vtiger.com, including some long standing issues from 5.4.0.


How to Upgrade Vtiger crm  6.2.0 to 6.3.0

Before Start anything More Important thing is take a Full backup of all Your Database and Home Directory ( all files of previous crm) Then follow the following steps -

1. You can download Vtiger CRM 6.2.0 to 6.3.0 Migraation software from this page: https://www.vtiger.com/open-source-downloads/ ( direct Download )

2. Login to Your Cpanel or Local pc where You are using Your crm

3. Open Your Root Folder, Upload and Extract the vtigercrm-620-630-patch.zip file

4. Now You are ready to Upgrade or Migrate Your Vtiger crm from   6.2.0 to 6.3.0 

5. Open Your Migrate folder /migrate/ ( Example :- domain.com/migrate or localhost/migrate)

6 You can find the Following Screen







7.  Now enter the Admin Login Details Username and Password and check the check box You have backup all your database and Home directory then Click on Start Migrations

8. Just wait and Watch Now its will Move to Next Step


9. Just click on Finish, all Done now Enjoy Your New Vtiger CRM 6.3.0

Note :- Before any installation Take the full backup of your Home directory and database

How to Add Customer attribute in Magento


Do You want to add Some Custom field with

  • Registration Forum
  • Login Forum
  • Cart Checkout
  • Add to Cart 


There are So Much Extension Free or Paid Extension You Can find On magentocommerce. But Which one is best is forever Confusing. which one is perfect or which one ruin all your magento..

I had Same issue. I want to add some Field with my registration forum and i find the Solution with

Customer attributes tool

Purpose of Customer Attributes Manager extension is to help administrator can manage and add attributes of customer easily. The Customer Attributes Magento module makes it possibly to create different types of attributes such as text field, text area, dropdown, multiple select and date field.
Features:
* Unlimited number of attributes
* Displaying in the customer account area
* Add attributes to the customer registration page or disable them for guests
* Ability to make attributes fields mandatory
* Specify default attribute value
* Enable unique value for attributes
* Various attributes types: text field, text area, date, multiple select, dropdown
* Attributes input validation: alphanumeric, numeric only, alpha only, url, or email * Ability to change customers’ data in the backend * Show attributes in admin grid
* Easy customer attributes management

Review :- This Extension is work Like charm i have installed 2-3 before this. i found some fetal errors. but with this its will be easy for You too add custom column.


How to Setup Vtiger CRM PBX Manager with Asterisk


After going through Official configuration guide then I realise that there should be one step by step guide with snapshots for newcomers or who are not familiar with Asterisk PBX and Linux.

I tried to make this step by step very simple and more understandable for all, so please give me any suggestion from your side to make this documentation better.

I have separated configuration parts in different steps.

1) Scenario with Network Diagram.
2) Required Software’s.
3) Vtiger Side Configuration.
4) Asterisk Side Configuration.
5) Troubleshooting.


Network Diagram




Vtiger Server:
                                Windows 7 32 bit , Dual Core CPU , 4 GB RAM , 40 GB HDD.
                                Vtiger 6.1
                                Zoiper SIP Soft Client with 2009 Extension Configured.
Asterisk Server:

Dual Core CPU , 4 GB RAM , 40 GB HDD
AsteriskNOW 5.211.65 (User Any Asterisk Based PBX like FreePBX , Elastix etc..)
Java Jetty Installed.
Note : this scenario has been developed in Virtual Environment ( Vmware Workstation 10 ) in my case.

Configure your Asterisk credentials in Vtiger


After installing Vtiger Asterisk Connector, please follow few simple steps to configure your Asterisk Server information in Vtiger CRM :

1. Login to your CRM instance and click on Setting.png icon on the top right corner of the CRM.
2. Click CRM Settings.
3. Click PBX Manager under Integration in Settings sidebar.
4. Edit Asterisk Server Details.
Vtiger Asterisk App URL - configure server name where Vtiger Asterisk Connector is installed as shown:
Syntax : Protocol://Asterisk_Server_IP:Port

Protocol
http/https
Asterisk_Server_IP
Your Asterisk Server IP
Port
Server Port configured in Vtiger Asterisk Connector config file.

Outbound Context - Vtiger specific context configured in your Asterisk Server

Outbound Trunk - Trunk configured in your Asterisk server for Outgoing Calls.

Vtiger Secret Key - Unique key generated for authentication, which has to be configured in Vtiger Asterisk Connector.

5. Click Save button.

Note : in my case I am not using any trunk for Outgoing Calls, I just want to test internal Calls only in my LAB. So please Add your Outbound trunk Name which is configured inAsterisk GUI -> Connectivity -> Trunks. ( Name is Case Sensitive so be careful ).


 Configure the extension number for each user


For each user who is allowed to handle incoming and outgoing calls from the CRM, the extension number should be configured in the User preferences page.

1. Open My Preferences.

2. Configure user number in CRM Phone Extension field under “More Information” block.

Number format:

Extension: [Extension_number]

e.g., 2001

Once configuration is completed on both sides i.e., Vtiger and Asterisk, you are now ready to make and receive calls in the CRM.

Vtiger Asterisk Connector Installation on Asterisk Server

Introduction
Vtiger Asterisk application acts a gateway to connect to Vtiger CRM from the Asterisk Server. It makes it easy for Vtiger and Asterisk interaction over HTTP when incoming or outgoing calls need to be handled.

Features
Vtiger Asterisk Connector provides following features:
1. Connect to Vtiger and notify the incoming call.
2. Accept commands from Vtiger and forward it to Asterisk (Click-to-Call).
3. Call recording file management.

Installation.








1.       Download Asterisk Connector ( PBXMagager )Add-on from Official Website.

2.       Download WinSCP and connect to Asterisk server .

3.       Transfer VtigerAsteriskConnector-1.2.zip to root folder ( / ).

4.       Login to Asterisk Server by using putty.exe or ssh terminal and unzip VtigerAsteriskConnector with “unzip VtigerAsteriskConnector-x.y.zip” Command.


5.       Open /VtigerAsteriskConnector/conf/ VtigerAsteriskConnector.properties and update information as below.


6.       Copy and Paste the Vtiger Secret Key that is generated in your Vtiger Instance.
You can find this under Vtiger CRM > Settings > Integration > PBXManager > Asterisk Server Details.

7.       Copy Vtiger URL exact the same because it is case sensitive so better to copy and paste from web browser.

8.       Cd /VtigerAsteriskConnector/Bin


9.       ./Start.sh

10.    Test Vtiger Connector website is working or not http://192.168.1.87:8383 the result should be as below.

11.   If you find above result then you are ready with VtigerAsteriskConnector Configuration.

Asterisk Configuration File Changes

1)      Change In extensions.conf ( /etc/Asterisk/extensions_custom.conf )



Create Vtiger SIP Extension

1)      Open Asterisk GUI -> Applications -> Extensions.
2)      Create SIP Extensions.



Configure Asterisk Manager User

1)      Open Asterisk GUI -> Settings -> Asterisk Manager Users

2)      Create “vtiger” User with ALL Permission.
3)      Make 0.0.0.0 / 0.0.0.0 in Deny Entry.
4)      Permit127.0.0.1/255.255.255.0&192.168.1.0/255.255.255.0&192.168.1.94/255.255.255.255

5)      Click on Submit.
6)      Save Changes.

Check /etc/Asterisk/manager_additional.conf

Add VtigerAsteriskConnector Script in to startup.

1)      Open Asterisk server terminal and give below command.
2)      Echo sh /VtigerAsteriskConnector/bin/start.sh >> /etc/rc.local



Troubleshooting

1)      Monitor Logs in /VtigerAsteriskConnector/Logs

a.       nohup.webapp.<date>.out
b.      nohup.agi.<date>.out
2)      Start or restart VtigerAsteriskConnector Scripts /VtigerAsteriskConnector/bin/
a.       Start.sh
b.      Stop.sh
c.       Agi.sh
d.      Webapp.sh
3)      Check webapp is running or not by visiting http://192.168.1.87:8383 it should show above Scripts in browser.

How to Download Vtiger Modules Packages

Vtiger CRM refers to both cloud and open source versions of the CRM application offered by the company Vtiger. Vtiger's open source CRM application was originally forked from SugarCRM with the intention of being a fully open source CRM application with comparable functionality to SugarCRM and Salesforce.com. It offers reporting, a customer portal and an Outlook plugin in its free edition, whereas those functions are in paid versions of the other CRM applications. Vtiger's cloud application was released in 2010, and offers added functionality such as a new interface, advanced reporting, and email campaigns.

If You are looking for Download Module Package to Import with add and Manage modules. Just follow this link go through this link

1. OPen http://trac.vtiger.com/svn/vtiger/vtigercrm/branches
2. Choose Your Vtiger Package ( choosing Vtiger 6.3.0 )
3. Open the packages/ Folder then vtiger/
4. Now choose Your Packages type from the Following 1: mandatory/ 2: marketplace/ 3: optional/

Download All packages Available Online

Download Direct Packages of 6.3.0 Open Source

Download Mandatory Packages of Vtiger 6.3.0


Download MarketPlace Packages of Vtiger 6.3.0