Migration of Sales Data failing

Hi,

i’m facing the same problem (on update data, so the first time this has worked).

Table quote_address does not exist on M1.

M1 table could be : sales_flat_order_quote_address instead.

as it is a quote table, and migrating 100% of the columns is not the most important thing, i decided to NULL all the telephone entries..?

Import then worked.

Hope this will not drive me in pitfall when the store will be live.

instead i would reccomend do to the following on the magento 1 database ( general— see below for a more detailed step ) .

update sales_flat_quote_address set telephone  = replace(replace ( telephone,unhex("E280AD"),''),unhex("E280AC"),'');

Changing the encoding will not sort anything out or if you change in mysql my.cnf the datails.. that will also not sort anything out.
 
replacing the unhexed data from the error would be the correct way to sort it out. and if you want to see more details about how it looks ( perform the following modifications so that you get the row where the error is: )
in

pub/ub-tool/yii-1.1.22/db/schema/CDbCommandBuilder.php

at the function

createInsertCommand

update

$sql="INSERT INTO {$table->rawName} (".implode(', ',$fields).') VALUES ('.implode(', ',$placeholders).')';

to look something like
 

       echo $sql="INSERT INTO {$table->rawName} (".implode(', ',$fields).') VALUES ('.implode(', ',$placeholders).')';
echo "\n\n\n"; print_r($data);
       echo "\n\n\n";

then run the step 7 again to get the error and view the data
and then you can do the following command in SQL:

SELECT  telephone,hex(telephone) from sales_flat_quote_address where quote_id =  [Quote id generated by the error]

then execute the update

update sales_flat_quote_address set telephone  = replace(replace ( telephone,unhex("E280AD"),''),unhex("E280AC"),'') where quote_id= [QUOTE ID FROM ABOVE ERROR / QUERY]

then run the step 7 again and see the miracle happen
 
Oh. And remember to revert the

pub/ub-tool/yii-1.1.22/db/schema/CDbCommandBuilder.php 

back to it’s original state.