Migrate from vtiger 6.3

[pmax]

Hi!

This is my first post

I have been using vtiger for a year. It works great but unfortunately the lack of documentation and support, specially if you plan to modify or fix the code is very frustrating.

Most of the things vtiger lacks (like uploading files through REST api) seem to be already present in coreBOS so it would seem like a smart move.

My question is: Do the migration script works if you are in vtiger 6.3? I did some changes in the vtiger code, mainly fixes, the addition of custom modules and fields through vtlib, and finally some customizations to customerportal to allow custom modules.

What do you think? I see that CoreBOS customerportal code is completely different, do custom modules work?

Thank you! and hopefully I will find a new home for my projects.

PM
[url=//www.pinterest.com/pin/create/extension/][/url]

[joebordes]

Hi,

I know the feeling, been there done that :-)

In coreBOS, besides the obvious of fixing and enhancing things one of the areas we have dedicated more time to is the REST interface because we use it a lot to solve different problems for our clients. So hopefully you will find everything you need there.

Migrating from VT6 stopped at 6.1. I remember looking at the 6.2 changes which were insignificant and should be very easy to do but I never even looked at 6.3 so I would have to investigate that, if you need it.

As to the customer portal, the original vtiger CRM portal code should be working, our Yii based portal works well but it is hard to program in Yii and then they went into that phase that everybody has now of throwing it all away and starting again. So we are now developing on the MYC portal code more.


Welcome :-)

[pmax]

Wow! Thanks Joe for your lightning fast response.

It seems I have a long weekend ahead of me I will definitely attempt the migration.

I am checking the upgrade scripts from vtiger from 6.1->6.2->6.3, as you say, I don't think much has changed either in the db.

In 6.1->6.2 all changes to the db seem to be related to Google sync.
In 6.2->6.3 some inserts are done into vtiger_profile2utility and two picklist values are added to no_of_currency_decimals field in Users.

Anyway, I will try to migrate and report back.

Thanks a lot for your response!
PM

[pmax]

Hello again,

Here is my report from the initial migration:

1. At first, the following line in the migration script failed:
$current_user->retrieveCurrentUserInfoFromFile(Users::getActiveAdminId());
It seems it was expecting user_privileges1.php to be present but was not, so I copied it back from my vtiger and moved on.

2. The upgrade process runs but fails at some point. I forced the 6.1 upgrade with ?force=1 because I am on version 6.3 and wanted to see what happened. You can see the output of the upgrade process here:

https://www.dropbox.com/s/5nhp3wgpfuqofja/vtlib%20TSolucio%20coreBOS%20Customizations%20%20migrate%20from%20vtiger%20CRM%206.x.htm?dl=0

Thank you!
PM

[joebordes]

I just uploaded a change that may fix the fatal error. It is most probably due to an enhancement we added to sort the workflow tasks.

https://github.com/tsolucio/corebos/commit/0de169d206ec675f84e51cb3e24d3799b3ce237d

As to the errors I wouldn't worry about any of them except vtiger_ownernotify table. Make sure that table exists and you should be able to ignore the other errors.

Keep me informed.

[pmax]

Tried you fix and the upgrade process completed without errors.

After logging in, I see this, I think it has to do with the handlers on vtiger_ws_entity table. Maybe they are not properly updated?

Thanks!


( ! ) Warning: require_once(include/Webservices/LineItem/VtigerLineItemOperation.php): failed to open stream: No such file or directory in C:\wamp\www\core\include\Webservices\ModuleTypes.php on line 93
Call Stack
# Time Memory Function Location
1 0.0000 269696 {main}( ) ..\index.php:0
2 0.2808 16464624 include( 'C:\wamp\www\autogetionarcore\modules\Contacts\index.php' ) ..\index.php:679
3 0.2808 16465352 include_once( 'C:\wamp\www\core\modules\Contacts\ListView.php' ) ..\index.php:13
4 0.2808 16518616 include_once( 'C:\wamp\www\core\modules\Vtiger\ListView.php' ) ..\ListView.php:10
5 0.3120 16802728 QueryGenerator->__construct( ) ..\ListView.php:100
6 0.3120 16803576 VtigerCRMObjectMeta->getReferenceFieldDetails( ) ..\QueryGenerator.php:72
7 0.3588 16961960 EntityMeta->getReferenceFieldDetails( ) ..\VtigerCRMObjectMeta.php:301
8 0.3588 17027304 WebserviceField->getReferenceList( ) ..\EntityMeta.php:86
9 0.3588 17027088 vtws_listtypes( ) ..\WebserviceField.php:299

( ! ) Fatal error: require_once(): Failed opening required 'include/Webservices/LineItem/VtigerLineItemOperation.php' (include_path='C:\wamp\www\core\include\htmlpurifier\library;.;C:\php\pear') in C:\wamp\www\core\include\Webservices\ModuleTypes.php on line 93
Call Stack
# Time Memory Function Location
1 0.0000 269696 {main}( ) ..\index.php:0
2 0.2808 16464624 include( 'C:\wamp\www\core\modules\Contacts\index.php' ) ..\index.php:679
3 0.2808 16465352 include_once( 'C:\wamp\www\core\modules\Contacts\ListView.php' ) ..\index.php:13
4 0.2808 16518616 include_once( 'C:\wamp\www\core\modules\Vtiger\ListView.php' ) ..\ListView.php:10
5 0.3120 16802728 QueryGenerator->__construct( ) ..\ListView.php:100
6 0.3120 16803576 VtigerCRMObjectMeta->getReferenceFieldDetails( ) ..\QueryGenerator.php:72
7 0.3588 16961960 EntityMeta->getReferenceFieldDetails( ) ..\VtigerCRMObjectMeta.php:301
8 0.3588 17027304 WebserviceField->getReferenceList( ) ..\EntityMeta.php:86
9 0.3588 17027088 vtws_listtypes( ) ..\WebserviceField.php:299


This is the contents of vtiger_ws_entity table:

# id, name, handler_path, handler_class, ismodule
'11', 'Accounts', 'include/Webservices/VtigerModuleOperation.php', 'VtigerModuleOperation', '1'
'37', 'Alert', 'include/Webservices/VtigerModuleOperation.php', 'VtigerModuleOperation', '1'
'39', 'AlertTriggers', 'include/Webservices/VtigerModuleOperation.php', 'VtigerModuleOperation', '1'
'32', 'Assets', 'include/Webservices/VtigerModuleOperation.php', 'VtigerModuleOperation', '1'
'9', 'Calendar', 'include/Webservices/VtigerModuleOperation.php', 'VtigerModuleOperation', '1'
'1', 'Campaigns', 'include/Webservices/VtigerModuleOperation.php', 'VtigerModuleOperation', '1'
'23', 'CompanyDetails', 'include/Webservices/VtigerCompanyDetails.php', 'VtigerCompanyDetails', '0'
'12', 'Contacts', 'include/Webservices/VtigerModuleOperation.php', 'VtigerModuleOperation', '1'
'21', 'Currency', 'include/Webservices/VtigerActorOperation.php', 'VtigerActorOperation', '0'
'22', 'DocumentFolders', 'include/Webservices/VtigerActorOperation.php', 'VtigerActorOperation', '0'
'15', 'Documents', 'include/Webservices/VtigerModuleOperation.php', 'VtigerModuleOperation', '1'
'16', 'Emails', 'include/Webservices/VtigerModuleOperation.php', 'VtigerModuleOperation', '1'
'18', 'Events', 'include/Webservices/VtigerModuleOperation.php', 'VtigerModuleOperation', '1'
'3', 'Faq', 'include/Webservices/VtigerModuleOperation.php', 'VtigerModuleOperation', '1'
'20', 'Groups', 'include/Webservices/VtigerActorOperation.php', 'VtigerActorOperation', '0'
'17', 'HelpDesk', 'include/Webservices/VtigerModuleOperation.php', 'VtigerModuleOperation', '1'
'7', 'Invoice', 'include/Webservices/LineItem/VtigerInventoryOperation.php', 'VtigerInventoryOperation', '1'
'10', 'Leads', 'include/Webservices/VtigerModuleOperation.php', 'VtigerModuleOperation', '1'
'33', 'LineItem', 'include/Webservices/LineItem/VtigerLineItemOperation.php', 'VtigerLineItemOperation', '0'
'27', 'ModComments', 'include/Webservices/VtigerModuleOperation.php', 'VtigerModuleOperation', '1'
'13', 'Potentials', 'include/Webservices/VtigerModuleOperation.php', 'VtigerModuleOperation', '1'
'8', 'PriceBooks', 'include/Webservices/VtigerModuleOperation.php', 'VtigerModuleOperation', '1'
'14', 'Products', 'include/Webservices/VtigerModuleOperation.php', 'VtigerModuleOperation', '1'
'35', 'ProductTaxes', 'include/Webservices/LineItem/VtigerProductTaxesOperation.php', 'VtigerProductTaxesOperation', '0'
'38', 'ProgMant', 'include/Webservices/VtigerModuleOperation.php', 'VtigerModuleOperation', '1'
'40', 'ProgMantDet', 'include/Webservices/VtigerModuleOperation.php', 'VtigerModuleOperation', '1'
'31', 'Project', 'include/Webservices/VtigerModuleOperation.php', 'VtigerModuleOperation', '1'
'29', 'ProjectMilestone', 'include/Webservices/VtigerModuleOperation.php', 'VtigerModuleOperation', '1'
'30', 'ProjectTask', 'include/Webservices/VtigerModuleOperation.php', 'VtigerModuleOperation', '1'
'5', 'PurchaseOrder', 'include/Webservices/LineItem/VtigerInventoryOperation.php', 'VtigerInventoryOperation', '1'
'4', 'Quotes', 'include/Webservices/LineItem/VtigerInventoryOperation.php', 'VtigerInventoryOperation', '1'
'6', 'SalesOrder', 'include/Webservices/LineItem/VtigerInventoryOperation.php', 'VtigerInventoryOperation', '1'
'25', 'ServiceContracts', 'include/Webservices/VtigerModuleOperation.php', 'VtigerModuleOperation', '1'
'24', 'Services', 'include/Webservices/VtigerModuleOperation.php', 'VtigerModuleOperation', '1'
'28', 'SMSNotifier', 'include/Webservices/VtigerModuleOperation.php', 'VtigerModuleOperation', '1'
'36', 'SQLReports', 'include/Webservices/VtigerModuleOperation.php', 'VtigerModuleOperation', '1'
'34', 'Tax', 'include/Webservices/LineItem/VtigerTaxOperation.php', 'VtigerTaxOperation', '0'
'19', 'Users', 'include/Webservices/VtigerModuleOperation.php', 'VtigerModuleOperation', '1'
'2', 'Vendors', 'include/Webservices/VtigerModuleOperation.php', 'VtigerModuleOperation', '1'

[joebordes]

LineItem is VT6 specific that reference must be eliminated

[joebordes]

It looks like we are trying to do that here:

https://github.com/tsolucio/corebos/blob/master/build/migrate6/migrate_from_vt60.php#L217

that foreach loop should have eliminated your lines 33, 34 and 35, so there has been some mistake there

Try manually executing the SQL in the loop for the three IDs

There are a few others that you will need to create new: Alert*, ProgMant*

[pmax]

Great, I did it manually and now works. I also had to update SalesOrder, Invoices, Quotes... to point to include/Webservices/VtigerModuleOperation.php

What works: Contacts, Accounts, etc...

What doesn't so far:

1. Almost all the entries in Configuration show: Action name is missing. Please check the action name.
2. If I try to access the user preferences:

( ! ) Fatal error: Uncaught exception 'Exception' with message 'unsupported dbtype "mysqli"' in C:\wamp\www\core\include\database\PearDatabase.php on line 781
( ! ) Exception: unsupported dbtype "mysqli" in C:\wamp\www\core\include\database\PearDatabase.php on line 781
Call Stack
# Time Memory Function Location
1 0.0000 270368 {main}( ) ..\index.php:0
2 0.1872 15417376 CRMEntity->track_view( ) ..\index.php:545
3 0.1872 15418728 Tracker->track_view( ) ..\CRMEntity.php:1050
4 0.1872 15423304 PearDatabase->sql_concat( ) ..\Tracker.php:91


Thanks again!
PM

[joebordes]

change your config.inc.php

Code:

$dbconfig['db_type'] = 'mysql';