Error when migrating products

Hi there,

Mage2CatalogProductEntityVarchar: Value is too long (maximum is 255 characters)
Any idea on the cause and how to fix it?

That issue was because your database has some records that have bad data in the value of of the catalog_category_entity_varchar.value field.
To solve that, you could do steps as follows:
+ Open the php file at: pub/ub-tool/protected/controllers/Step5Controller.php
and find the lines:

} else if ($className2 == 'Mage2CatalogProductEntityVarchar' AND $attribute1->attribute_code == 'url_path') {
    if (preg_match("/.html/i", $model2->value)) {
        $model2->value = str_replace('.html', '', $model2->value);
    }
}

and replace it with the following lines:

} else if ($className2 == 'Mage2CatalogProductEntityVarchar') {
    if ($attribute1->attribute_code == 'url_path' && preg_match("/.html/i", $model2->value)) {
        $model2->value = str_replace('.html', '', $model2->value);
    }
    //Tuning to handle for case: https://www.ubertheme.com/question/error-when-migrating-products/
    if (strlen(trim($model2->value)) > 255) {
        $model2->value = substr(trim($model2->value), 0, 12);
    }
}

Once done, you can continue data migration in the step #5

Also, ideally I would like to just migrate sales/customer data as I am going to integrate products and categories myself later.

As the sales data sections have relationship with catalog data and customers data, the feature you mentioned was not supported by our tool. Anyway, you can disable or delete the un-used data after complete data migration.
Also please note that, you shouldn’t delete the migrated items if you wish to proceed delta migration with our tool later on.
Regards,
Mall.

Hi there,

 I’ve implemented these changes however I’m still getting the same error -- even after re-compiling, clearing caches etc. Any ideas why?

So, that is strange. Let’s provide me the information about your working as followings:
+ Admin credentials and site URL
+ SSH credentials and web root path of your M2 instance.
I will check further in your instance and help you out.
Regards,
Mall.

Hi there,

String data, right truncated: 1406 Data too long for column ‘firstname’ at row 1. The SQL statement executed was: INSERT INTO 

That issue because your M1’s database has bad data in the value of the sales_flat_quote_address.firstname field.
You could use below SQL to check again your records which has bad data:
Select * from sales_flat_quote_address Where LENGTH(firstname) > 255;
And then, re-correct your data manual.
Once done, you could continue with data migration with our tool.
Regards,
Mall.

Hi there,

I’m having a new problem now when I import order. Here’s the error:2018/01/18 11:10:00 [error] [ub_data_migration] CDbCommand failed to execute the SQL statement: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘firstname’ at row 1. The SQL statement executed was: INSERT INTO `quote_address` (`quote_id`, `updated_at`, `save_in_address_book`, 

You should consider to upgrade to Magento2.1.9 or later version now. Because that M1’s data will be accepts in Magento2.1.9 and later version of Magento2 database.
You could see more these screenshots: 
http://i.prntscr.com/d7JhWhcKS6SirmhYAUFeDQ.png
http://i.prntscr.com/1H9pdLjcRd_unXzJT_pTGA.png

Regards,
Mall.