SugarCRM 3.5 to vtigerCRM 4.2 Migration Tool Released!

Comments

• 50 Comments sorted by Votes Date Added
• jrydbeck

  October 2005 Vote Up0Vote Down

  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!
• mickie

  October 2005 Vote Up0Vote Down

  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 <!-- e --><a href="mailto:mickie@vtiger.com">mickie@vtiger.com</a><!-- e -->
  thanks & regards
  mickie
• davlun

  October 2005 Vote Up0Vote Down

  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:
  

  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

  October 2005 Vote Up0Vote Down

  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 <!-- 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
• mickie

  October 2005 Vote Up0Vote Down

  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 <!-- e --><a href="mailto:mickie@vtiger.com">mickie@vtiger.com</a><!-- e -->.
  
  thanks for your understanding.
  thanks & regards
  mickie
• gavin_tsi

  October 2005 Vote Up0Vote Down

  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
• jrydbeck

  October 2005 Vote Up0Vote Down

  very similar to blaed, the user2role relationship wasn't populated so i had to manually add it for my users. there were clearly some other items missing as i couldn't go into some activities, items wouldn't appear on the "latest viewed" list. i did a migration of contacts and accounts. the rest will probably be manual.
• jrydbeck

  October 2005 Vote Up0Vote Down

  btw, it was still worth the move to vtiger. my users are already singing its praises over sugar. speed is one big item.
• psv

  November 2005 Vote Up0Vote Down

  same problem here, cannot log in / modify users because user2role table not populated. after updating manually, it was fine, though. very nice feature, got all my information over for a good start - and the outlook plugin works excellent at the first few tries.
  
  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:) -->
• swhitlow

  November 2005 Vote Up0Vote Down

  testing vtiger for the first time. tried the migration tool. however, none of our data was ported over and we can no longer login. i tried running the script again but with no luck.
  
  where should we go from here?
  
  thanks!