Migration Issue

[visualwebtechnologies]

Hi

Hope you all well today

My concern is 

When i migrate blesta during whmcs to blesta i shown error 

 

please explain how to solve 

 

decrypted 29 values using WHMCS' custom algorithm
decrypt took: 0.0041 seconds
total time took: 33.5875 seconds
Array
(
    [error] => Array
        (
            [0] => The import completed but the following errors ocurred:
            [1] => importPackageOptions: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\x96 24x7...' for column 'name' at row 1 on line 196
            [2] => importServices: There is already an active transaction on line 231
            [3] => importSupportDepartments: There is already an active transaction on line 231
            [4] => importSupportTickets: There is already an active transaction on line 231
            [5] => importMisc: There is already an active transaction on line 231
        )

)

[Jono]

Yea, WHMCS uses different character encoding then Blesta and that can cause issues for names with special   (e.g. accented) characters.  We have already updated a number of places to resolve this, but it looks like this still needs to be updated.  If you're comfortable editing the files you can edit a few lines in plugins/import_manager_components/migrators/whmcs/whmcs_migrator.php. 

Change line 1146 from:

                'name' => $option_group->name,

to:

                'name' => $this->decode($option_group->name),

 

Change line 1147 from:

                'description' => $option_group->description,

to:

                'description' => $this->decode($option_group->description),

 

Change 1164 from:

                        'name' => $value->optionname,

to:

                        'name' => $this->decode($value->optionname),

 

Change 1165 from:

                        'value' => $is_qty ? null : $value->optionname,

to:

                        'value' => $is_qty ? null : $this->decode($value->optionname),

 

Change 1178 from:

                        'label' => $option->optionname,

to:

                        'label' => $this->decode($option->optionname),

 

Change 1179 from:

                        'name' => $option->optionname,

to:

                        'name' => $this->decode($option->optionname),

 

That should cover all the potential issue areas in that function.

[Paul]

On 4/27/2020 at 8:29 AM, Jono said:

That should cover all the potential issue areas in that function.

Did we also update the importer for the next release?

[Jono]

CORE-3604