Want to re import data

Hi,
I’ve used your migration pro plugin to transfer all the data from an M1 install. This seemed to go fine so we released the site and have had new customers and orders etc.
We have since found that some customer data (addresses mainly) has unknown property.
How can I fix this, I want to re-import the customer data but if I cancel this step will this delete all the ‘new’ customers. I’d have to delete step 8, 7 & 6. Again will this delete any new information?
Cheers,
John Emmett
 

9 answers

Profile photo of ubdev Staff 98590.00 $tone March 28, 2019
Public

Hi John Emmett, 
We’d like to answer your questions below: 

I’ve used your migration pro plugin to transfer all the data from an M1 install. This seemed to go fine so we released the site and have had new customers and orders etc.

We wonder if you did check the ‘Keep Original IDs’ setting in Step 6 -- Migrating Settings | Customers? 

We have since found that some customer data (addresses mainly) has unknown property.
How can I fix this, I want to re-import the customer data but if I cancel this step will this delete all the ‘new’ customers. I’d have to delete step 8, 7 & 6. Again will this delete any new information?

In this case you can run delta with the mode ‘update’ with step 6. Please refer to our Readme manual for the CLI on the delta migration with the mode update.
However, please note with the delta migration using the mode ‘update’, your M1 customer data will overwrite the migrated customer in your M2. Besides, if you did select ‘Keep Original IDs’ in Step 6, there might be conflict between new customer data in M1 vs. your new customer data in M2.
Regards,
Ubertheme team
 

#1
Profile photo of John Emmett 90.00 $tone March 28, 2019
Public

No, I didn’t have ‘keep the original ID’s’ selected. This was a new DB import and because it was going to be totally fresh it didn’t matter if I saved the original ID’s or so I thought.
I will have a look at this possible fix. I’ll back up the original DB anyway so if I run into issues then I’ll have to revert.
I’m quite disappointed, to be honest, as this is a very expensive plugin that I and a major client relied on and it’s not delivered because of a ‘missed option’ that had no warnings or anything like that included. It also didn’t explain this had happened, if it did I would have stopped the release of the new site and tried to re-import the data again. Now I’m stuck with an unhappy client and a client with hundreds of unhappy customers.
I would like to know what you propose to do about this.
Thank you,
John

#2
Profile photo of ubdev Staff 98590.00 $tone March 29, 2019
Public

Hi John, 
Since you did not select the ‘Keep the original IDs’, please run the delta migration with the mode ‘update’ in Step 6 as mentioned in our previous reply. 
In case you come across any new issue, please pause the process, and let us know the details of issue. We will work closely with you then. 
Regards,
Ubertheme team

#3
Profile photo of John Emmett 90.00 $tone April 1, 2019
Public

Hi,
I’m getting an error: 
PHP Error[2]: Creating default object from empty value
    in file /pub/ub-tool/protected/controllers/Step6Controller.php at line 555
What could this be?
Cheers,

#4
Profile photo of Mall Staff 184060.00 $tone April 1, 2019
Public

Hi there,

PHP Error[2]: Creating default object from empty value
    in file /pub/ub-tool/protected/controllers/Step6Controller.php at line 555

That issue because you or your customers was deleted at least one customer’s address after the first migration.
To continue you could try with steps below:
+ Run below SQL in your M2 database:

DELETE FROM ub_migrate_map_step_6 WHERE entity_name = 'customer_group' AND m2_id NOT IN (Select customer_group_id From customer_group);
DELETE FROM ub_migrate_map_step_6 WHERE entity_name = 'customer_entity' AND m2_id NOT IN (Select entity_id From customer_entity);
DELETE FROM ub_migrate_map_step_6_customer_address WHERE entity_name = 'customer_address_entity' AND m2_id NOT IN (Select entity_id From customer_address_entity);

+ Clean the cache of our migration tool by run command: rm -rf pub/ub-tool/protected/runtime/cache/
+ Once done, you could continue with data migration with our migration tool.
Regards,
Mall.

#5
Profile photo of John Emmett 90.00 $tone April 1, 2019
Public

OK, great that worked and I was able to re-import the data…
BUT…
None of the unknown address was overwritten and none (sorry most of, as international customers seem unaffected) of the proper shipping/delivery data is present in the DB…
I’ve got a workaround but this involves deleting all unknown addresses so customers basically start from scratch. We have a lot of old data that should have been brought over with this plugin. $400 for a plugin is a lot and for it not to work is ridiculous. I hope you have a workaround solution.

#6
Profile photo of ubdev Staff 98590.00 $tone April 2, 2019
Public

Hi John Emmett, 

None of the unknown address was overwritten and none (sorry most of, as international customers seem unaffected) of the proper shipping/delivery data is present in the DB…

For the customer addresses that are missing in your M1 (but required in Magento 2), our migration tool will mark it as unknown or N/A so that the data can be validated in accordance with Magento 2 database rules.

How can I fix this, I want to re-import the customer data but if I cancel this step will this delete all the ‘new’ customers. I’d have to delete step 8, 7 & 6. Again will this delete any new information?

You should not manually remove the unknown data item, otherwise it will lead to unexpected issue as mentioned in your question #4 when running delta migration.
Regards,
Ubertheme team

#7
Profile photo of John Emmett 90.00 $tone April 2, 2019
Public

I’m not looking to do any delta migrations again. 
I wanted the whole data to be moved in one go. It was moved (or so I thought) and we launched the new M2 website so we have new data on top of the old migrated data.
Was I want to do is basically add the customer address data again so that it overwrites the unknown data. Are you saying this unknown data is due to the fact its new data that isn’t present in M1? 
If I can’t re-import and OVERWRITE the unknown address data then I’ll edit the DB and remove all the unknown addresses because this is confusing customers when they get to the checkout.
Please reply ASAP so I can sort out today.
Thank you
John

#8
Profile photo of ubdev Staff 98590.00 $tone April 2, 2019
Public

Hi John, 

Are you saying this unknown data is due to the fact its new data that isn’t present in M1?

Yes. Since those data was missing in your M1 while they are required fields in M2.

then I’ll edit the DB and remove all the unknown addresses because this is confusing customers when they get to the checkout.

Yes, you can move forward by manually leaving the unknown addresses blank in your M2 db. Please note since this is required value field, removing such field is not possible.
Regards,
Ubertheme team
 

#9

Please login or Register to Submit Answer

Written By

Comments