Error Data Too long tax_vat

Hi there,

http://vvcap.com/nvHVOjghCnU

That issue because your database has some records with bad data in the value of the customer attribute code taxvat . To handle that, you could do following steps:
-- Open the php file at path: ub-tool/protected/controllers/Step6Controller.php
and find to the code line:

$customer2->$attributeCode1 = $model->value;

and replace it by code lines:

$customer2->$attributeCode1 = $model->value;
if ($attributeCode1 == 'taxvat' AND strlen(trim($customer2->$attributeCode1)) > 50) {
    $customer2->$attributeCode1 = substr(trim($customer2->$attributeCode1), 0, 50);
}

-- Once done, you can continue with data migration in the step #6.
Regards,
Mall.

Hi there,

but now some registers don´t working.
You can see  the snap.
http://vvcap.com/tzWKqWqYMED 

That because your database has some records which has value with utf8 encoded but seem you have created your magento1 database with other collation (maybe is latin1). To handle that, let’s try do following steps:
Step 1: Run bellow sql in your Magento1 database:

Update customer_entity_varchar set value = convert(binary convert(value using latin1) using utf8);

Step 2: Once done, let’s continue with data migration in the step #6.
And tell me know how it goes.
Regards,
Mall.
 

Hi there,
Yeah, let’s contact me if you need further assistance.
Regards,
Mall.

Hi there,

http://vvcap.com/6IJJchpYhNq
We think that the problem is a record with cyrillic character because our database is utf-8
How can I display in log error the incorrect register to be able to modify it?

That because your database has some records with bad data in the the value of the ‘firstname‘ field in the table ‘sales_flat_quote_address‘.
To detect the entity id with that bad data, you can do following steps:
Open the php file at the path: pub/ub-tool/protected/controllers/Step7Controller.php
and find to the code lines:

/**
 * Table: sales_flat_quote_address
 */
$models = Mage1SalesQuoteAddress::model()->findAll("quote_id = {$quoteId1}");
if ($models) {
    foreach ($models as $model) {

and replace it by code lines:

/**
 * Table: sales_flat_quote_address
 */
$models = Mage1SalesQuoteAddress::model()->findAll("quote_id = {$quoteId1}");
if ($models) {
    foreach ($models as $model) {
     echo "M1 ID: {$model->address_id}\n"; // this code line help you see the ID in M1

Once done, let continue data migration in the step #7 with cli command:
php -f bin/ubdatamigration run --step=7
And then, you can see the ID of the record with bad data as you want.
Hope this help.
Regards,
Mall.
 
 
 

Hi there, 
We have the ticket closed for now. Should you have additional question, kindly reach us here or submit a new ticket. 
Regards,
Ubertheme team