How to Ignore Column Table in data migration


Ignore Column Table :- 

We need to ignore these values in the map.xml  file in document rule tag , as per requirement for example

            <ignore>
                < document>pricespider</document>
            </ignore>

Where pricespider is ignore value, after the changes in map.xml  save it and again execute the data migration command

How to add the ignore column in map.xml file. Please See Some Example :-


 How To Deal With Magento 2 Data Migration Errors?

Ex :- 1


    Error 1: Source documents aren’t mapped: mohit_restorecancelled_order
    • Solution: You need to add the following code snippet to the source <document_rules> tag in the map.xml file:

      <ignore>
<document>mohit_restorecancelled_order</document>
</ignore>
    Ex :- 2
    Error 2: Source fields aren’t mapped. Document: sales_flat_quote_item. Fields: orderspro_is_temporary?
    • Solution: You need to add the following code snippet inside the source’s <field_rules> tag in the map.xml file:

      <ignore>
<field>sales_flat_quote_item.orderspro_is_temporary</field>
</ignore>
    Ex :- 3
    Error 3 : Destination fields are not mapped. Document: quote. Fields: shipping_delivery_date
    <destination>
        <field_rules>
                <ignore>
                    <field>quote.shipping_delivery_date</field>
                </ignore>
        </field_rules>
    </destination>

    For more discription for xml files used in data migration tool in magento , you can look here

    1. class-map.xml.dist :- Dictionary of class mappings between Magento 1 and Magento 2
    2. config.xml.dist :- Main configuration file that specifies the Magento 1 and Magento 2 database configurations, step configuration, and links to mapping files
    3. EE only. customer-attr-document-groups.xml.dist :- List of tables used in the custom customer attributes step.
    4. EE only. customer-attr-map.xml.dist :- Map file that is used in Custom Customer Attributes Step.
    5. deltalog.xml.dist :- Contains the list of tables required for database routines setup.
    6. eav-document-groups.xml.dist :- Contains list of tables that are used in Eav Step.
    7. log-document-groups.xml.dist :- Contains list of tables that are used in Log Step.
    8. map-eav.xml.dist :- Map file that is used in EAV Step.
    9. map-log.xml.dist :- Log mapping file.
    10. EE only. map-sales.xml.dist :- Map file that is used in SalesOrder step.
    11. map.xml.dist :- Mapping file required for the map step.
    12. settings.xml.dist :- Setting migration configuration file that specifies rules required for migrating thecore_config_data table.
    13. customer-attribute-groups.xml :- Contains list of attributes that are used in Customer Attributes Step.
    14. customer-document-groups.xml :- Contains list of tables that are used in Customer Attributes Step.
    15. map-customer.xml :- Map file that is used in Customer Attributes Step.
    16. order-grids-document-groups.xml :- Contains list of tables that are used in OrderGrids Step.



      Thanks.

    Comments

    Post a Comment