vtiger

[philip]

Dear Community,

We are pleased to release the Migration tool for Open Source SugarCRM 3.5 free version to vitgerCRM 4.2

Regards,
Philip


Migration Procedure from SugarCRM 3.5 to vtigerCRM 4.2:

Kindly note that both SugarCRM and vtigerCRM should be installed in the same server

Download the tool from the following url http://prdownloads.sourceforge.net/vtigercrm/sugar35Tovtiger42Migration.zip?download

1. unzip the sugar35Tovtiger42Migration.zip file under vtigerCRM home directory(parallel to index.php).
(
Sugar35ToVTiger42Migration.php,
SugarMigration/Sugar35ToVTiger42Migrator.php,
SugarMigration/VTigerMigrator.php &
vtigerpatch.php
)

2. Edit the Sugar35ToVTiger42Migration.php file present under the vtigerCRM home directory and configure the following parameter:
2.1. Specify the absolute path for $sugar_root_directory.

3. Now access the file Sugar35ToVTiger42Migration.php (present under vtigerCRM home) through your browser.

Now in the webpage necessary details will be displayed and the database values from sugarCRM 3.5 will be transferred to vtigerCRM 4.2 version

Note :
------

1. In this migration process the sugarCRM 3.5 database will not be modified.
2. During this migration first vtigerCRM 4.2 database values will be deleted and then new sugarCRM 3.5 values will be inserted.
3. After migration vtigerCRM 4.2 Patch2 will be applied automatically if you have not applied the patch already.

4. The data migration is handled for the following modules:
a. Users
b. Leads
c. Accounts
d. Contacts
e. Potentials (Opportunities)
f. Emails
g. Calls, Meetings (In vtiger these will be in Activites)
h. Notes
i. Tasks

5. The following functionalities has also been handled
a. Roles
b. Custom Fields
c. Picklists

Limitations:
------------

1. In customfields, the PickList(Combo values) and TextArea has not been handled as we have some problems in these fields in sugarCRM.
2. Attachments are not supported in this migration script.

[jrydbeck]

I haven't had a chance to even trial this, but once I have approval from our sales director, we're going to migrate over from Sugar. Thanks for building this!

[Guest]

Hello,

We are having a little challenge getting this together. Here is the error being received:

Fatal error: Cannot redeclare query_module_access_list() (previously declared in /home/argusi/public_html/sugar/include/utils/security_utils.php:38) in /home/argusi/public_html/sugar/include/utils/security_utils.php on line 38

Need more info? suggestions?

David

[mickie]

Dear David,

I am confused in this message because we didnot use query_module_access_list() in our migration script anywhere.
we have included only the config.php and custom/include/language/en_us.lang.php files which are not include any other sugar files. There files have been included to get the dbconfiguration and the standard picklist arrays.
so could you please let us know
1. The path you have installed sugar
2. The path given for the variable $sugar_root_directory in Sugar35ToVTiger42Migration.php and
3. The path, where you have placed the migration script.
This will help us to proceed further.

Please feel free to contact us in Toll free number or send mail to mickie@vtiger.com
Thanks & Regards
Mickie

[davlun]

So as is often the case, was user error. total user error.

Import ran successfully once i figured that one out, but do get an error on viewing imported users. Now i am guessing user error, but if you wish to take a look, here is a section from the log:

Code: Wed Oct 19 06:28:37 2005,219 [419] DEBUG index - ****Starting for session 436ef484a4a8fea7855e85e2f282a641
Wed Oct 19 06:28:37 2005,219 [419] DEBUG index - We have an authenticated user id: 11
Wed Oct 19 06:28:37 2005,219 [419] DEBUG index - array (
  'action' => 'DetailView',
  'module' => 'Users',
  'record' => '21',
  'PHPSESSID' => '436ef484a4a8fea7855e85e2f282a641',
  'ck_login_id' => '11',
  'ck_login_theme' => 'blue',
  'ck_login_language' => 'en_us',
  'timezone' => '0',
)
Wed Oct 19 06:28:37 2005,219 [419] INFO index - About to take action DetailView
Wed Oct 19 06:28:37 2005,220 [419] DEBUG index - in DetailView
Wed Oct 19 06:28:37 2005,220 [419] INFO index - current page is modules/Users/DetailView.php
Wed Oct 19 06:28:37 2005,220 [419] INFO index - current module is Users
Wed Oct 19 06:28:37 2005,227 [419] DEBUG VT - Message ->query being executed : SELECT name from tab where tabid in ('1','2','3','4','6','7','8','9','10','13','14','15','16','17','18','19','20','21','22','23','24','25') and presence = 0 order by tabsequence
Wed Oct 19 06:28:37 2005,228 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,229 [419] DEBUG VT - Message ->getRowCount rows= 17
Wed Oct 19 06:28:37 2005,230 [419] DEBUG user - Retrieve User: SELECT * FROM users WHERE id = '11'
Wed Oct 19 06:28:37 2005,230 [419] DEBUG VT - Message ->query being executed : SELECT * FROM users WHERE id = '11'
Wed Oct 19 06:28:37 2005,230 [419] FATAL VT - PearDatabase ->TRANS creating new connection
Wed Oct 19 06:28:37 2005,231 [419] DEBUG VT - Message ->getRowCount rows= 1
Wed Oct 19 06:28:37 2005,234 [419] DEBUG VT - Message ->query being executed : SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = '11' and u1.deleted=0
Wed Oct 19 06:28:37 2005,234 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,234 [419] FATAL VT - PearDatabase ->ADODB fetchByAssoc return null
Wed Oct 19 06:28:37 2005,235 [419] DEBUG user - additional detail query results:
Wed Oct 19 06:28:37 2005,235 [419] DEBUG index - Current user is: admin
Wed Oct 19 06:28:37 2005,235 [419] DEBUG index - Current theme is: blue
Wed Oct 19 06:28:37 2005,235 [419] DEBUG index - current_language is: en_us
Wed Oct 19 06:28:37 2005,240 [419] DEBUG user - About to call tracker (user_id, module_name, item_id)(11, Users, )
Wed Oct 19 06:28:37 2005,240 [419] DEBUG VT - Message ->query being executed : DELETE from tracker WHERE user_id='11' and item_id='21'
Wed Oct 19 06:28:37 2005,240 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,241 [419] INFO VT - Message ->in  track view method Users
Wed Oct 19 06:28:37 2005,241 [419] DEBUG VT - Message ->query being executed : select first_name,last_name from users where id=21
Wed Oct 19 06:28:37 2005,242 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,242 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,243 [419] INFO Tracker - Track Item View: INSERT into tracker (user_id, module_name, item_id, item_summary) values ('11', 'Users', '21', ' standarduser')
Wed Oct 19 06:28:37 2005,243 [419] DEBUG VT - Message ->query being executed : INSERT into tracker (user_id, module_name, item_id, item_summary) values ('11', 'Users', '21', ' standarduser')
Wed Oct 19 06:28:37 2005,244 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,244 [419] DEBUG Tracker - About to verify history size: SELECT count(*) from tracker WHERE user_id='11'
Wed Oct 19 06:28:37 2005,244 [419] FATAL VT - PearDatabase ->ADODB getOne sql=SELECT count(*) from tracker WHERE user_id='11'
Wed Oct 19 06:28:37 2005,245 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,245 [419] DEBUG Tracker - history size: (current, max)(5, 5)
Wed Oct 19 06:28:37 2005,245 [419] DEBUG index - setting cookie ck_login_id to 11
Wed Oct 19 06:28:37 2005,246 [419] DEBUG index - setting cookie ck_login_theme to blue
Wed Oct 19 06:28:37 2005,246 [419] DEBUG index - setting cookie ck_login_language to en_us
Wed Oct 19 06:28:37 2005,246 [419] DEBUG index - including headers
Wed Oct 19 06:28:37 2005,251 [419] INFO VT - Message ->module  is Contacts
Wed Oct 19 06:28:37 2005,251 [419] DEBUG VT - Message ->query being executed : select tabid from tab where name='Contacts'
Wed Oct 19 06:28:37 2005,252 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,252 [419] INFO VT - Message ->module  is Leads
Wed Oct 19 06:28:37 2005,252 [419] DEBUG VT - Message ->query being executed : select tabid from tab where name='Leads'
Wed Oct 19 06:28:37 2005,253 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,253 [419] INFO VT - Message ->module  is Accounts
Wed Oct 19 06:28:37 2005,254 [419] DEBUG VT - Message ->query being executed : select tabid from tab where name='Accounts'
Wed Oct 19 06:28:37 2005,254 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,255 [419] INFO VT - Message ->module  is Potentials
Wed Oct 19 06:28:37 2005,255 [419] DEBUG VT - Message ->query being executed : select tabid from tab where name='Potentials'
Wed Oct 19 06:28:37 2005,255 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,256 [419] INFO VT - Message ->module  is HelpDesk
Wed Oct 19 06:28:37 2005,256 [419] DEBUG VT - Message ->query being executed : select tabid from tab where name='HelpDesk'
Wed Oct 19 06:28:37 2005,256 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,257 [419] INFO VT - Message ->module  is Faq
Wed Oct 19 06:28:37 2005,257 [419] DEBUG VT - Message ->query being executed : select tabid from tab where name='Faq'
Wed Oct 19 06:28:37 2005,258 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,258 [419] INFO VT - Message ->module  is Products
Wed Oct 19 06:28:37 2005,258 [419] DEBUG VT - Message ->query being executed : select tabid from tab where name='Products'
Wed Oct 19 06:28:37 2005,259 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,259 [419] INFO VT - Message ->module  is Notes
Wed Oct 19 06:28:37 2005,260 [419] DEBUG VT - Message ->query being executed : select tabid from tab where name='Notes'
Wed Oct 19 06:28:37 2005,260 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,260 [419] INFO VT - Message ->module  is Emails
Wed Oct 19 06:28:37 2005,261 [419] DEBUG VT - Message ->query being executed : select tabid from tab where name='Emails'
Wed Oct 19 06:28:37 2005,261 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,262 [419] INFO VT - Message ->module  is Events
Wed Oct 19 06:28:37 2005,262 [419] DEBUG VT - Message ->query being executed : select tabid from tab where name='Events'
Wed Oct 19 06:28:37 2005,262 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,263 [419] INFO VT - Message ->module  is Activities
Wed Oct 19 06:28:37 2005,263 [419] DEBUG VT - Message ->query being executed : select tabid from tab where name='Activities'
Wed Oct 19 06:28:37 2005,263 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,264 [419] INFO VT - Message ->module  is Vendor
Wed Oct 19 06:28:37 2005,264 [419] DEBUG VT - Message ->query being executed : select tabid from tab where name='Vendor'
Wed Oct 19 06:28:37 2005,265 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,265 [419] DEBUG VT - Message ->query being executed : select * from profile2tab where profileid=5
Wed Oct 19 06:28:37 2005,265 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,266 [419] DEBUG VT - Message ->getRowCount rows= 22
Wed Oct 19 06:28:37 2005,268 [419] INFO VT - Message ->module  is PriceBook
Wed Oct 19 06:28:37 2005,269 [419] DEBUG VT - Message ->query being executed : select tabid from tab where name='PriceBook'
Wed Oct 19 06:28:37 2005,269 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,270 [419] DEBUG VT - Message ->query being executed : select * from profile2tab where profileid=5
Wed Oct 19 06:28:37 2005,270 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,271 [419] DEBUG VT - Message ->getRowCount rows= 22
Wed Oct 19 06:28:37 2005,273 [419] INFO VT - Message ->module  is Quotes
Wed Oct 19 06:28:37 2005,273 [419] DEBUG VT - Message ->query being executed : select tabid from tab where name='Quotes'
Wed Oct 19 06:28:37 2005,273 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,274 [419] INFO VT - Message ->module  is Orders
Wed Oct 19 06:28:37 2005,274 [419] DEBUG VT - Message ->query being executed : select tabid from tab where name='Orders'
Wed Oct 19 06:28:37 2005,275 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,275 [419] INFO VT - Message ->module  is SalesOrder
Wed Oct 19 06:28:37 2005,275 [419] DEBUG VT - Message ->query being executed : select tabid from tab where name='SalesOrder'
Wed Oct 19 06:28:37 2005,276 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,276 [419] DEBUG VT - Message ->query being executed : select * from profile2tab where profileid=5
Wed Oct 19 06:28:37 2005,277 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,277 [419] DEBUG VT - Message ->getRowCount rows= 22
Wed Oct 19 06:28:37 2005,280 [419] INFO VT - Message ->module  is Invoice
Wed Oct 19 06:28:37 2005,280 [419] DEBUG VT - Message ->query being executed : select tabid from tab where name='Invoice'
Wed Oct 19 06:28:37 2005,280 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,295 [419] DEBUG Tracker - About to retrieve list: SELECT * from tracker inner join crmentity on crmentity.crmid=tracker.item_id WHERE user_id='11' and crmentity.deleted=0 ORDER BY id DESC
Wed Oct 19 06:28:37 2005,295 [419] DEBUG VT - Message ->query being executed : SELECT * from tracker inner join crmentity on crmentity.crmid=tracker.item_id WHERE user_id='11' and crmentity.deleted=0 ORDER BY id DESC
Wed Oct 19 06:28:37 2005,295 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,297 [419] INFO VT - Message ->module  is Activities
Wed Oct 19 06:28:37 2005,297 [419] DEBUG VT - Message ->query being executed : select tabid from tab where name='Activities'
Wed Oct 19 06:28:37 2005,298 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,298 [419] INFO VT - Message ->getActionName   4
Wed Oct 19 06:28:37 2005,298 [419] DEBUG VT - Message ->query being executed : select * from profile2tab where profileid=5
Wed Oct 19 06:28:37 2005,299 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,299 [419] DEBUG VT - Message ->getRowCount rows= 22
Wed Oct 19 06:28:37 2005,302 [419] INFO VT - Message ->in getUserId 773
Wed Oct 19 06:28:37 2005,302 [419] DEBUG VT - Message ->query being executed : select * from crmentity where crmid = 773
Wed Oct 19 06:28:37 2005,302 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,303 [419] FATAL VT - PearDatabase ->ADODB fetchByAssoc return null
Wed Oct 19 06:28:37 2005,303 [419] DEBUG VT - Message ->query being executed : select activitytype from activity where activityid = 773
Wed Oct 19 06:28:37 2005,304 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,305 [419] INFO VT - Message ->module  is Users
Wed Oct 19 06:28:37 2005,305 [419] DEBUG VT - Message ->query being executed : select tabid from tab where name='Users'
Wed Oct 19 06:28:37 2005,305 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,306 [419] INFO VT - Message ->get Actionid DetailView
Wed Oct 19 06:28:37 2005,306 [419] INFO VT - Message ->action id selected is 4
Wed Oct 19 06:28:37 2005,312 [419] DEBUG user - Retrieve User: SELECT * FROM users WHERE id = '21'
Wed Oct 19 06:28:37 2005,312 [419] DEBUG VT - Message ->query being executed : SELECT * FROM users WHERE id = '21'
Wed Oct 19 06:28:37 2005,312 [419] FATAL VT - PearDatabase ->TRANS creating new connection
Wed Oct 19 06:28:37 2005,313 [419] DEBUG VT - Message ->getRowCount rows= 1
Wed Oct 19 06:28:37 2005,315 [419] DEBUG VT - Message ->query being executed : SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = '21' and u1.deleted=0
Wed Oct 19 06:28:37 2005,316 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,316 [419] FATAL VT - PearDatabase ->ADODB fetchByAssoc return null
Wed Oct 19 06:28:37 2005,316 [419] DEBUG user - additional detail query results:
Wed Oct 19 06:28:37 2005,317 [419] DEBUG VT - Message ->query being executed : select roleid from user2role where userid='21'
Wed Oct 19 06:28:37 2005,317 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,318 [419] DEBUG VT - Message ->query being executed : select * from role where roleid=
Wed Oct 19 06:28:37 2005,318 [419] INFO VT - Message ->checkconnect using old connection
Wed Oct 19 06:28:37 2005,318 [419] FATAL VT - PearDatabase ->ADODB error  Query Failed:select * from role where roleid=::->[1064]You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1


Thanks for a wonderful way to transition to your product!

David

[mickie]

Dear David,

Thanks for your reply. From the log file, the roleid is missing for the user with id 21.
The problem may be due to creating role at the time of migration. To get the error please do look into your vtigercrm.log files from START ==> DATA MIGRATION to END ==> DATA MIGRATION . The logs will be placed more than one log files. If you can please have a look into that files otherwise please send me the log files which contains the migration informations ie., in between the above specified START and END DATA MIGRATION strings.
Please send the log files to mickie@vtiger.com.

Please feel free to ask if you have any problems.
Thanks & Regards
Mickie

[Guest]

Hi,

I installed a fresh vTiger(4.2 + patch 2 + Spanish language) and tried to migrate my Sugar (3.5.1b + Spanish language). Apparently everything went smoothly and the migration page appeared but nothing was migrated. When the process ended I tried to login but it didnt accept my previous login and pass. I tried to use the Tip and Trick to recuperate my login and pass but it didnt work. As a result I dumped the vTiger database and ran install.php again in order to have my fresh vTiger back.

I still wondering how I will migrate my data from my Sugar to vTiger, any other suggestion? Is the migration script updated to the constant changes from Sugar (3.5.1a, b, c)?

Many thanks

[mickie]

Dear Team,

In the migration process all the data in vtiger database will be deleted (please see the Note 2 in this announcement first post).
Also it would be very helpful to find the problem, if you look into vtigercrm.log file(i have mentioned in my precious post) and if you cannot find the error then please send me that log files. i will look into the error and then let you know.
Please feel free to contact in Toll free number or mail to mickie@vtiger.com.

Thanks for your understanding.
Thanks & Regards
Mickie

[blaed]

After doing the Sugar migration I'm seeing tables such as

user2role
report
reportfolder

Have been cleared, but never repopulated. This means that you cannot log in with the migrated users, reports are broken etc. It would appear there's no checking to see if some queries return a result, and so they silenty feed in blank strings to following queries, resulting in a

Code: Fatal error: Call to a member function on a non-object in /var/www/vtiger_crm/include/database/PearDatabase.php on line 426

[gavin_tsi]

Is there anyone at VTiger or in teh community who can manage this migration for me.

How much is it likely to cost.


thanks in advance


Gavin Allinson