Magento 2 Data Migrattion Tools ignores map.xmlData migration problems 1.9.2.2 to 2.0Magento2 Data migration getting stuck at Step Customer AttributeMagento 2 Data migration for only customers, categories and couponsMagento Data Migrate tool error “Attribute vat_id does not exist in the type customer_address”Magento m1 to m2 ce-to-ce Data migration issuesExtending Magento 2 Data Migration Toolsmagento 1 to magento 2 data migration issueUndefined offset: 150 in /vendor/magento/data-migration-tool/src/Migration/Step/Eav/Data.php on line 813Magento 2 : How can I reset the Data Migration Tool?Getting error while migrating data from magento 1 to magento 2
Tabulated absorption spectra of greenhouse gases?
Is this resistor leaking? If so, is it a concern?
How long does it take to crack RSA 1024 with a PC?
Can a wire having a 610-670 THz (frequency of blue light) AC frequency supply, generate blue light?
Where is the encrypted mask value?
Does this degree 12 genus 1 curve have only one point over infinitely many finite fields?
When did God say "let all the angels of God worship him" as stated in Hebrews 1:6?
Is there a way to make it so the cursor is included when I prtscr key?
Smart people send dumb people to a new planet on a space craft that crashes into a body of water
Tic-Tac-Toe for the terminal
Would the Geas spell work in a dead magic zone once you enter it?
What is the difference between nullifying your vote and not going to vote at all?
Riley Rebuses that Share a Common Theme
How to prevent bad sectors?
What is the most important source of natural gas? coal, oil or other?
How to plot an unstable attractor?
How can I find where certain bash function is defined?
If a person had control of every single cell of their body, would they be able to transform into another creature?
What does it mean when you think without speaking?
PETG layer adhesion
Why does the 6502 have the BIT instruction?
Are there situations when self-assignment is useful?
Why colon to denote that a value belongs to a type?
Logarithm of dependent variable is uniformly distributed. How to calculate a confidence interval for the mean?
Magento 2 Data Migrattion Tools ignores map.xml
Data migration problems 1.9.2.2 to 2.0Magento2 Data migration getting stuck at Step Customer AttributeMagento 2 Data migration for only customers, categories and couponsMagento Data Migrate tool error “Attribute vat_id does not exist in the type customer_address”Magento m1 to m2 ce-to-ce Data migration issuesExtending Magento 2 Data Migration Toolsmagento 1 to magento 2 data migration issueUndefined offset: 150 in /vendor/magento/data-migration-tool/src/Migration/Step/Eav/Data.php on line 813Magento 2 : How can I reset the Data Migration Tool?Getting error while migrating data from magento 1 to magento 2
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
0
I have installed migration tool and it is running, but I want to ignore some tables. So I set some to map.xml but something is wrong - ignore list is beeing ignored
<config xmlns:xs="http://www.w3.org/2001/XMLSchema-instance" xs:noNamespaceSchemaLocation="../../config.xsd">
<steps mode="settings">
<step title="Settings Step">
<integrity>MigrationStepSettingsIntegrity</integrity>
<data>MigrationStepSettingsData</data>
</step>
<step title="Stores Step">
<integrity>MigrationStepStoresIntegrity</integrity>
<data>MigrationStepStoresData</data>
<volume>MigrationStepStoresVolume</volume>
</step>
</steps>
<steps mode="data">
<step title="Data Integrity Step">
<integrity>MigrationStepDataIntegrityIntegrity</integrity>
</step>
<step title="EAV Step">
<integrity>MigrationStepEavIntegrity</integrity>
<data>MigrationStepEavData</data>
<volume>MigrationStepEavVolume</volume>
</step>
<step title="Customer Attributes Step">
<integrity>MigrationStepCustomerIntegrity</integrity>
<data>MigrationStepCustomerData</data>
<volume>MigrationStepCustomerVolume</volume>
</step>
<step title="Map Step">
<integrity>MigrationStepMapIntegrity</integrity>
<data>MigrationStepMapData</data>
<volume>MigrationStepMapVolume</volume>
</step>
<step title="Url Rewrite Step">
<integrity>MigrationStepUrlRewriteVersion191to2000</integrity>
<data>MigrationStepUrlRewriteVersion191to2000</data>
<volume>MigrationStepUrlRewriteVersion191to2000</volume>
</step>
<step title="Log Step">
<integrity>MigrationStepLogIntegrity</integrity>
<data>MigrationStepLogData</data>
<volume>MigrationStepLogVolume</volume>
</step>
<step title="Ratings Step">
<integrity>MigrationStepRatingsIntegrity</integrity>
<data>MigrationStepRatingsData</data>
<volume>MigrationStepRatingsVolume</volume>
</step>
<step title="ConfigurablePrices step">
<integrity>MigrationStepConfigurablePricesIntegrity</integrity>
<data>MigrationStepConfigurablePricesData</data>
<volume>MigrationStepConfigurablePricesVolume</volume>
</step>
<step title="OrderGrids Step">
<integrity>MigrationStepOrderGridsIntegrity</integrity>
<data>MigrationStepOrderGridsData</data>
<volume>MigrationStepOrderGridsVolume</volume>
</step>
<step title="Tier Price Step">
<integrity>MigrationStepTierPriceIntegrity</integrity>
<data>MigrationStepTierPriceData</data>
<volume>MigrationStepTierPriceVolume</volume>
</step>
<step title="SalesIncrement Step">
<integrity>MigrationStepSalesIncrementIntegrity</integrity>
<data>MigrationStepSalesIncrementData</data>
<volume>MigrationStepSalesIncrementVolume</volume>
</step>
<step title="Inventory Step">
<integrity>MigrationStepInventoryIntegrity</integrity>
<data>MigrationStepInventoryData</data>
<volume>MigrationStepInventoryVolume</volume>
</step>
<step title="PostProcessing Step">
<data>MigrationStepPostProcessingData</data>
</step>
</steps>
<steps mode="delta">
<step title="Customer Attributes Step">
<delta>MigrationStepCustomerDelta</delta>
<volume>MigrationStepCustomerVolume</volume>
</step>
<step title="Map Step">
<delta>MigrationStepMapDelta</delta>
<volume>MigrationStepMapVolume</volume>
</step>
<step title="Log Step">
<delta>MigrationStepLogDelta</delta>
<volume>MigrationStepLogVolume</volume>
</step>
<step title="OrderGrids Step">
<delta>MigrationStepOrderGridsDelta</delta>
<volume>MigrationStepOrderGridsVolume</volume>
</step>
<step title="SalesIncrement Step">
<delta>MigrationStepSalesIncrementDelta</delta>
<volume>MigrationStepSalesIncrementVolume</volume>
</step>
<step title="Inventory Step">
<delta>MigrationStepInventoryDelta</delta>
<volume>MigrationStepInventoryVolume</volume>
</step>
</steps>
<source>
<database host="localhost" name="aa" user="bb" password="cc" />
</source>
<destination>
<database host="localhost" name="xx" user="yyy" password="zz" />
</destination>
<options>
<map_file>etc/opensource-to-opensource/1.8.1.0/map.xml</map_file>
<eav_map_file>etc/opensource-to-opensource/map-eav.xml.dist</eav_map_file>
<eav_document_groups_file>etc/opensource-to-opensource/eav-document-groups.xml.dist</eav_document_groups_file>
<eav_attribute_groups_file>etc/opensource-to-opensource/eav-attribute-groups.xml.dist</eav_attribute_groups_file>
<log_map_file>etc/opensource-to-opensource/map-log.xml.dist</log_map_file>
<log_document_groups_file>etc/opensource-to-opensource/log-document-groups.xml.dist</log_document_groups_file>
<settings_map_file>etc/opensource-to-opensource/settings.xml.dist</settings_map_file>
<customer_map_file>etc/opensource-to-opensource/map-customer.xml.dist</customer_map_file>
<customer_document_groups_file>etc/opensource-to-opensource/customer-document-groups.xml.dist</customer_document_groups_file>
<customer_attribute_groups_file>etc/opensource-to-opensource/customer-attribute-groups.xml.dist</customer_attribute_groups_file>
<delta_document_groups_file>etc/opensource-to-opensource/deltalog.xml.dist</delta_document_groups_file>
<order_grids_document_groups_file>etc/opensource-to-opensource/order-grids-document-groups.xml.dist</order_grids_document_groups_file>
<map_document_groups>etc/opensource-to-opensource/map-document-groups.xml.dist</map_document_groups>
<class_map>etc/opensource-to-opensource/class-map.xml.dist</class_map>
<tier_price_map_file>etc/opensource-to-opensource/map-tier-price.xml.dist</tier_price_map_file>
<stores_map_file>etc/opensource-to-opensource/map-stores.xml.dist</stores_map_file>
<!--
In case bulk_size=0 it will be auto-detected for every document.
-->
<bulk_size>0</bulk_size>
<!--
Set direct_document_copy = 1 for better performance.
NOTE: 'source' and 'destination' databases MUST be placed on the same MySQL instance
and 'destination' user MUST be granted with 'SELECT' permissions on 'source' database
-->
<direct_document_copy>1</direct_document_copy>
<source_prefix />
<dest_prefix />
<auto_resolve_urlrewrite_duplicates>0</auto_resolve_urlrewrite_duplicates>
<log_file>migration.log</log_file>
<progress_bar_format>%percent%% [%bar%] Remaining Time: %remaining%</progress_bar_format>
<upgrade_customer_password_hash>1</upgrade_customer_password_hash>
<edition_migrate>opensource-to-opensource</edition_migrate>
<edition_number>1.8.1.0</edition_number>
<init_statements_source>SET NAMES utf8;</init_statements_source>
<init_statements_destination>SET NAMES utf8;</init_statements_destination>
<crypt_key>cccccccccccccccccccc</crypt_key>
</options>
and map.xml
<map xmlns:xs="http://www.w3.org/2001/XMLSchema-instance" xs:noNamespaceSchemaLocation="../../map.xsd">
<source>
<document_rules>
<ignore>
<document>cms_block</document>
</ignore>
<ignore>
<document>cms_block_store</document>
</ignore>
<ignore>
<document>cms_page</document>
</ignore>
<ignore>
<document>cms_page_store</document>
</ignore>
<ignore>
<document>core_config_data</document>
</ignore>
</document_rules>
</source>
<destination>
<document_rules>
<ignore>
<document>cms_block</document>
</ignore>
<ignore>
<document>cms_block_store</document>
</ignore>
<ignore>
<document>cms_page</document>
</ignore>
<ignore>
<document>cms_page_store</document>
</ignore>
<ignore>
<document>core_config_data</document>
</ignore>
</document_rules>
</destination>
hope somebody can help to make it work, thanks!
Martin
magento2 magento2-migration-tool
asked May 21 at 18:07
matinmatin
84110
|
show 1 more comment
0
I have installed migration tool and it is running, but I want to ignore some tables. So I set some to map.xml but something is wrong - ignore list is beeing ignored
<config xmlns:xs="http://www.w3.org/2001/XMLSchema-instance" xs:noNamespaceSchemaLocation="../../config.xsd">
<steps mode="settings">
<step title="Settings Step">
<integrity>MigrationStepSettingsIntegrity</integrity>
<data>MigrationStepSettingsData</data>
</step>
<step title="Stores Step">
<integrity>MigrationStepStoresIntegrity</integrity>
<data>MigrationStepStoresData</data>
<volume>MigrationStepStoresVolume</volume>
</step>
</steps>
<steps mode="data">
<step title="Data Integrity Step">
<integrity>MigrationStepDataIntegrityIntegrity</integrity>
</step>
<step title="EAV Step">
<integrity>MigrationStepEavIntegrity</integrity>
<data>MigrationStepEavData</data>
<volume>MigrationStepEavVolume</volume>
</step>
<step title="Customer Attributes Step">
<integrity>MigrationStepCustomerIntegrity</integrity>
<data>MigrationStepCustomerData</data>
<volume>MigrationStepCustomerVolume</volume>
</step>
<step title="Map Step">
<integrity>MigrationStepMapIntegrity</integrity>
<data>MigrationStepMapData</data>
<volume>MigrationStepMapVolume</volume>
</step>
<step title="Url Rewrite Step">
<integrity>MigrationStepUrlRewriteVersion191to2000</integrity>
<data>MigrationStepUrlRewriteVersion191to2000</data>
<volume>MigrationStepUrlRewriteVersion191to2000</volume>
</step>
<step title="Log Step">
<integrity>MigrationStepLogIntegrity</integrity>
<data>MigrationStepLogData</data>
<volume>MigrationStepLogVolume</volume>
</step>
<step title="Ratings Step">
<integrity>MigrationStepRatingsIntegrity</integrity>
<data>MigrationStepRatingsData</data>
<volume>MigrationStepRatingsVolume</volume>
</step>
<step title="ConfigurablePrices step">
<integrity>MigrationStepConfigurablePricesIntegrity</integrity>
<data>MigrationStepConfigurablePricesData</data>
<volume>MigrationStepConfigurablePricesVolume</volume>
</step>
<step title="OrderGrids Step">
<integrity>MigrationStepOrderGridsIntegrity</integrity>
<data>MigrationStepOrderGridsData</data>
<volume>MigrationStepOrderGridsVolume</volume>
</step>
<step title="Tier Price Step">
<integrity>MigrationStepTierPriceIntegrity</integrity>
<data>MigrationStepTierPriceData</data>
<volume>MigrationStepTierPriceVolume</volume>
</step>
<step title="SalesIncrement Step">
<integrity>MigrationStepSalesIncrementIntegrity</integrity>
<data>MigrationStepSalesIncrementData</data>
<volume>MigrationStepSalesIncrementVolume</volume>
</step>
<step title="Inventory Step">
<integrity>MigrationStepInventoryIntegrity</integrity>
<data>MigrationStepInventoryData</data>
<volume>MigrationStepInventoryVolume</volume>
</step>
<step title="PostProcessing Step">
<data>MigrationStepPostProcessingData</data>
</step>
</steps>
<steps mode="delta">
<step title="Customer Attributes Step">
<delta>MigrationStepCustomerDelta</delta>
<volume>MigrationStepCustomerVolume</volume>
</step>
<step title="Map Step">
<delta>MigrationStepMapDelta</delta>
<volume>MigrationStepMapVolume</volume>
</step>
<step title="Log Step">
<delta>MigrationStepLogDelta</delta>
<volume>MigrationStepLogVolume</volume>
</step>
<step title="OrderGrids Step">
<delta>MigrationStepOrderGridsDelta</delta>
<volume>MigrationStepOrderGridsVolume</volume>
</step>
<step title="SalesIncrement Step">
<delta>MigrationStepSalesIncrementDelta</delta>
<volume>MigrationStepSalesIncrementVolume</volume>
</step>
<step title="Inventory Step">
<delta>MigrationStepInventoryDelta</delta>
<volume>MigrationStepInventoryVolume</volume>
</step>
</steps>
<source>
<database host="localhost" name="aa" user="bb" password="cc" />
</source>
<destination>
<database host="localhost" name="xx" user="yyy" password="zz" />
</destination>
<options>
<map_file>etc/opensource-to-opensource/1.8.1.0/map.xml</map_file>
<eav_map_file>etc/opensource-to-opensource/map-eav.xml.dist</eav_map_file>
<eav_document_groups_file>etc/opensource-to-opensource/eav-document-groups.xml.dist</eav_document_groups_file>
<eav_attribute_groups_file>etc/opensource-to-opensource/eav-attribute-groups.xml.dist</eav_attribute_groups_file>
<log_map_file>etc/opensource-to-opensource/map-log.xml.dist</log_map_file>
<log_document_groups_file>etc/opensource-to-opensource/log-document-groups.xml.dist</log_document_groups_file>
<settings_map_file>etc/opensource-to-opensource/settings.xml.dist</settings_map_file>
<customer_map_file>etc/opensource-to-opensource/map-customer.xml.dist</customer_map_file>
<customer_document_groups_file>etc/opensource-to-opensource/customer-document-groups.xml.dist</customer_document_groups_file>
<customer_attribute_groups_file>etc/opensource-to-opensource/customer-attribute-groups.xml.dist</customer_attribute_groups_file>
<delta_document_groups_file>etc/opensource-to-opensource/deltalog.xml.dist</delta_document_groups_file>
<order_grids_document_groups_file>etc/opensource-to-opensource/order-grids-document-groups.xml.dist</order_grids_document_groups_file>
<map_document_groups>etc/opensource-to-opensource/map-document-groups.xml.dist</map_document_groups>
<class_map>etc/opensource-to-opensource/class-map.xml.dist</class_map>
<tier_price_map_file>etc/opensource-to-opensource/map-tier-price.xml.dist</tier_price_map_file>
<stores_map_file>etc/opensource-to-opensource/map-stores.xml.dist</stores_map_file>
<!--
In case bulk_size=0 it will be auto-detected for every document.
-->
<bulk_size>0</bulk_size>
<!--
Set direct_document_copy = 1 for better performance.
NOTE: 'source' and 'destination' databases MUST be placed on the same MySQL instance
and 'destination' user MUST be granted with 'SELECT' permissions on 'source' database
-->
<direct_document_copy>1</direct_document_copy>
<source_prefix />
<dest_prefix />
<auto_resolve_urlrewrite_duplicates>0</auto_resolve_urlrewrite_duplicates>
<log_file>migration.log</log_file>
<progress_bar_format>%percent%% [%bar%] Remaining Time: %remaining%</progress_bar_format>
<upgrade_customer_password_hash>1</upgrade_customer_password_hash>
<edition_migrate>opensource-to-opensource</edition_migrate>
<edition_number>1.8.1.0</edition_number>
<init_statements_source>SET NAMES utf8;</init_statements_source>
<init_statements_destination>SET NAMES utf8;</init_statements_destination>
<crypt_key>cccccccccccccccccccc</crypt_key>
</options>
and map.xml
<map xmlns:xs="http://www.w3.org/2001/XMLSchema-instance" xs:noNamespaceSchemaLocation="../../map.xsd">
<source>
<document_rules>
<ignore>
<document>cms_block</document>
</ignore>
<ignore>
<document>cms_block_store</document>
</ignore>
<ignore>
<document>cms_page</document>
</ignore>
<ignore>
<document>cms_page_store</document>
</ignore>
<ignore>
<document>core_config_data</document>
</ignore>
</document_rules>
</source>
<destination>
<document_rules>
<ignore>
<document>cms_block</document>
</ignore>
<ignore>
<document>cms_block_store</document>
</ignore>
<ignore>
<document>cms_page</document>
</ignore>
<ignore>
<document>cms_page_store</document>
</ignore>
<ignore>
<document>core_config_data</document>
</ignore>
</document_rules>
</destination>
hope somebody can help to make it work, thanks!
Martin
magento2 magento2-migration-tool
asked May 21 at 18:07
matinmatin
84110
have you mapped map.xml?
– Saphal Jha
May 21 at 19:07
how do I map the map.xml - I only addes <map_file>etc/opensource-to-opensource/1.8.1.0/map.xml</map_file> to config.xml to <options> section? Is there something else to do?
– matin
May 22 at 5:57
let me know the commands you are using in cli
– Saphal Jha
May 22 at 6:30
php bin/magento migrate:settings -r vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.8.1.0/config.xml and php bin/magento migrate:data -r -a vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.8.1.0/config.xml
– matin
May 22 at 6:34
Can you please check with removing the core table skiping code?
– Saphal Jha
May 22 at 6:45
|
show 1 more comment
0
0
0
I have installed migration tool and it is running, but I want to ignore some tables. So I set some to map.xml but something is wrong - ignore list is beeing ignored
<config xmlns:xs="http://www.w3.org/2001/XMLSchema-instance" xs:noNamespaceSchemaLocation="../../config.xsd">
<steps mode="settings">
<step title="Settings Step">
<integrity>MigrationStepSettingsIntegrity</integrity>
<data>MigrationStepSettingsData</data>
</step>
<step title="Stores Step">
<integrity>MigrationStepStoresIntegrity</integrity>
<data>MigrationStepStoresData</data>
<volume>MigrationStepStoresVolume</volume>
</step>
</steps>
<steps mode="data">
<step title="Data Integrity Step">
<integrity>MigrationStepDataIntegrityIntegrity</integrity>
</step>
<step title="EAV Step">
<integrity>MigrationStepEavIntegrity</integrity>
<data>MigrationStepEavData</data>
<volume>MigrationStepEavVolume</volume>
</step>
<step title="Customer Attributes Step">
<integrity>MigrationStepCustomerIntegrity</integrity>
<data>MigrationStepCustomerData</data>
<volume>MigrationStepCustomerVolume</volume>
</step>
<step title="Map Step">
<integrity>MigrationStepMapIntegrity</integrity>
<data>MigrationStepMapData</data>
<volume>MigrationStepMapVolume</volume>
</step>
<step title="Url Rewrite Step">
<integrity>MigrationStepUrlRewriteVersion191to2000</integrity>
<data>MigrationStepUrlRewriteVersion191to2000</data>
<volume>MigrationStepUrlRewriteVersion191to2000</volume>
</step>
<step title="Log Step">
<integrity>MigrationStepLogIntegrity</integrity>
<data>MigrationStepLogData</data>
<volume>MigrationStepLogVolume</volume>
</step>
<step title="Ratings Step">
<integrity>MigrationStepRatingsIntegrity</integrity>
<data>MigrationStepRatingsData</data>
<volume>MigrationStepRatingsVolume</volume>
</step>
<step title="ConfigurablePrices step">
<integrity>MigrationStepConfigurablePricesIntegrity</integrity>
<data>MigrationStepConfigurablePricesData</data>
<volume>MigrationStepConfigurablePricesVolume</volume>
</step>
<step title="OrderGrids Step">
<integrity>MigrationStepOrderGridsIntegrity</integrity>
<data>MigrationStepOrderGridsData</data>
<volume>MigrationStepOrderGridsVolume</volume>
</step>
<step title="Tier Price Step">
<integrity>MigrationStepTierPriceIntegrity</integrity>
<data>MigrationStepTierPriceData</data>
<volume>MigrationStepTierPriceVolume</volume>
</step>
<step title="SalesIncrement Step">
<integrity>MigrationStepSalesIncrementIntegrity</integrity>
<data>MigrationStepSalesIncrementData</data>
<volume>MigrationStepSalesIncrementVolume</volume>
</step>
<step title="Inventory Step">
<integrity>MigrationStepInventoryIntegrity</integrity>
<data>MigrationStepInventoryData</data>
<volume>MigrationStepInventoryVolume</volume>
</step>
<step title="PostProcessing Step">
<data>MigrationStepPostProcessingData</data>
</step>
</steps>
<steps mode="delta">
<step title="Customer Attributes Step">
<delta>MigrationStepCustomerDelta</delta>
<volume>MigrationStepCustomerVolume</volume>
</step>
<step title="Map Step">
<delta>MigrationStepMapDelta</delta>
<volume>MigrationStepMapVolume</volume>
</step>
<step title="Log Step">
<delta>MigrationStepLogDelta</delta>
<volume>MigrationStepLogVolume</volume>
</step>
<step title="OrderGrids Step">
<delta>MigrationStepOrderGridsDelta</delta>
<volume>MigrationStepOrderGridsVolume</volume>
</step>
<step title="SalesIncrement Step">
<delta>MigrationStepSalesIncrementDelta</delta>
<volume>MigrationStepSalesIncrementVolume</volume>
</step>
<step title="Inventory Step">
<delta>MigrationStepInventoryDelta</delta>
<volume>MigrationStepInventoryVolume</volume>
</step>
</steps>
<source>
<database host="localhost" name="aa" user="bb" password="cc" />
</source>
<destination>
<database host="localhost" name="xx" user="yyy" password="zz" />
</destination>
<options>
<map_file>etc/opensource-to-opensource/1.8.1.0/map.xml</map_file>
<eav_map_file>etc/opensource-to-opensource/map-eav.xml.dist</eav_map_file>
<eav_document_groups_file>etc/opensource-to-opensource/eav-document-groups.xml.dist</eav_document_groups_file>
<eav_attribute_groups_file>etc/opensource-to-opensource/eav-attribute-groups.xml.dist</eav_attribute_groups_file>
<log_map_file>etc/opensource-to-opensource/map-log.xml.dist</log_map_file>
<log_document_groups_file>etc/opensource-to-opensource/log-document-groups.xml.dist</log_document_groups_file>
<settings_map_file>etc/opensource-to-opensource/settings.xml.dist</settings_map_file>
<customer_map_file>etc/opensource-to-opensource/map-customer.xml.dist</customer_map_file>
<customer_document_groups_file>etc/opensource-to-opensource/customer-document-groups.xml.dist</customer_document_groups_file>
<customer_attribute_groups_file>etc/opensource-to-opensource/customer-attribute-groups.xml.dist</customer_attribute_groups_file>
<delta_document_groups_file>etc/opensource-to-opensource/deltalog.xml.dist</delta_document_groups_file>
<order_grids_document_groups_file>etc/opensource-to-opensource/order-grids-document-groups.xml.dist</order_grids_document_groups_file>
<map_document_groups>etc/opensource-to-opensource/map-document-groups.xml.dist</map_document_groups>
<class_map>etc/opensource-to-opensource/class-map.xml.dist</class_map>
<tier_price_map_file>etc/opensource-to-opensource/map-tier-price.xml.dist</tier_price_map_file>
<stores_map_file>etc/opensource-to-opensource/map-stores.xml.dist</stores_map_file>
<!--
In case bulk_size=0 it will be auto-detected for every document.
-->
<bulk_size>0</bulk_size>
<!--
Set direct_document_copy = 1 for better performance.
NOTE: 'source' and 'destination' databases MUST be placed on the same MySQL instance
and 'destination' user MUST be granted with 'SELECT' permissions on 'source' database
-->
<direct_document_copy>1</direct_document_copy>
<source_prefix />
<dest_prefix />
<auto_resolve_urlrewrite_duplicates>0</auto_resolve_urlrewrite_duplicates>
<log_file>migration.log</log_file>
<progress_bar_format>%percent%% [%bar%] Remaining Time: %remaining%</progress_bar_format>
<upgrade_customer_password_hash>1</upgrade_customer_password_hash>
<edition_migrate>opensource-to-opensource</edition_migrate>
<edition_number>1.8.1.0</edition_number>
<init_statements_source>SET NAMES utf8;</init_statements_source>
<init_statements_destination>SET NAMES utf8;</init_statements_destination>
<crypt_key>cccccccccccccccccccc</crypt_key>
</options>
and map.xml
<map xmlns:xs="http://www.w3.org/2001/XMLSchema-instance" xs:noNamespaceSchemaLocation="../../map.xsd">
<source>
<document_rules>
<ignore>
<document>cms_block</document>
</ignore>
<ignore>
<document>cms_block_store</document>
</ignore>
<ignore>
<document>cms_page</document>
</ignore>
<ignore>
<document>cms_page_store</document>
</ignore>
<ignore>
<document>core_config_data</document>
</ignore>
</document_rules>
</source>
<destination>
<document_rules>
<ignore>
<document>cms_block</document>
</ignore>
<ignore>
<document>cms_block_store</document>
</ignore>
<ignore>
<document>cms_page</document>
</ignore>
<ignore>
<document>cms_page_store</document>
</ignore>
<ignore>
<document>core_config_data</document>
</ignore>
</document_rules>
</destination>
hope somebody can help to make it work, thanks!
Martin
magento2 magento2-migration-tool
asked May 21 at 18:07
matinmatin
84110
I have installed migration tool and it is running, but I want to ignore some tables. So I set some to map.xml but something is wrong - ignore list is beeing ignored
<config xmlns:xs="http://www.w3.org/2001/XMLSchema-instance" xs:noNamespaceSchemaLocation="../../config.xsd">
<steps mode="settings">
<step title="Settings Step">
<integrity>MigrationStepSettingsIntegrity</integrity>
<data>MigrationStepSettingsData</data>
</step>
<step title="Stores Step">
<integrity>MigrationStepStoresIntegrity</integrity>
<data>MigrationStepStoresData</data>
<volume>MigrationStepStoresVolume</volume>
</step>
</steps>
<steps mode="data">
<step title="Data Integrity Step">
<integrity>MigrationStepDataIntegrityIntegrity</integrity>
</step>
<step title="EAV Step">
<integrity>MigrationStepEavIntegrity</integrity>
<data>MigrationStepEavData</data>
<volume>MigrationStepEavVolume</volume>
</step>
<step title="Customer Attributes Step">
<integrity>MigrationStepCustomerIntegrity</integrity>
<data>MigrationStepCustomerData</data>
<volume>MigrationStepCustomerVolume</volume>
</step>
<step title="Map Step">
<integrity>MigrationStepMapIntegrity</integrity>
<data>MigrationStepMapData</data>
<volume>MigrationStepMapVolume</volume>
</step>
<step title="Url Rewrite Step">
<integrity>MigrationStepUrlRewriteVersion191to2000</integrity>
<data>MigrationStepUrlRewriteVersion191to2000</data>
<volume>MigrationStepUrlRewriteVersion191to2000</volume>
</step>
<step title="Log Step">
<integrity>MigrationStepLogIntegrity</integrity>
<data>MigrationStepLogData</data>
<volume>MigrationStepLogVolume</volume>
</step>
<step title="Ratings Step">
<integrity>MigrationStepRatingsIntegrity</integrity>
<data>MigrationStepRatingsData</data>
<volume>MigrationStepRatingsVolume</volume>
</step>
<step title="ConfigurablePrices step">
<integrity>MigrationStepConfigurablePricesIntegrity</integrity>
<data>MigrationStepConfigurablePricesData</data>
<volume>MigrationStepConfigurablePricesVolume</volume>
</step>
<step title="OrderGrids Step">
<integrity>MigrationStepOrderGridsIntegrity</integrity>
<data>MigrationStepOrderGridsData</data>
<volume>MigrationStepOrderGridsVolume</volume>
</step>
<step title="Tier Price Step">
<integrity>MigrationStepTierPriceIntegrity</integrity>
<data>MigrationStepTierPriceData</data>
<volume>MigrationStepTierPriceVolume</volume>
</step>
<step title="SalesIncrement Step">
<integrity>MigrationStepSalesIncrementIntegrity</integrity>
<data>MigrationStepSalesIncrementData</data>
<volume>MigrationStepSalesIncrementVolume</volume>
</step>
<step title="Inventory Step">
<integrity>MigrationStepInventoryIntegrity</integrity>
<data>MigrationStepInventoryData</data>
<volume>MigrationStepInventoryVolume</volume>
</step>
<step title="PostProcessing Step">
<data>MigrationStepPostProcessingData</data>
</step>
</steps>
<steps mode="delta">
<step title="Customer Attributes Step">
<delta>MigrationStepCustomerDelta</delta>
<volume>MigrationStepCustomerVolume</volume>
</step>
<step title="Map Step">
<delta>MigrationStepMapDelta</delta>
<volume>MigrationStepMapVolume</volume>
</step>
<step title="Log Step">
<delta>MigrationStepLogDelta</delta>
<volume>MigrationStepLogVolume</volume>
</step>
<step title="OrderGrids Step">
<delta>MigrationStepOrderGridsDelta</delta>
<volume>MigrationStepOrderGridsVolume</volume>
</step>
<step title="SalesIncrement Step">
<delta>MigrationStepSalesIncrementDelta</delta>
<volume>MigrationStepSalesIncrementVolume</volume>
</step>
<step title="Inventory Step">
<delta>MigrationStepInventoryDelta</delta>
<volume>MigrationStepInventoryVolume</volume>
</step>
</steps>
<source>
<database host="localhost" name="aa" user="bb" password="cc" />
</source>
<destination>
<database host="localhost" name="xx" user="yyy" password="zz" />
</destination>
<options>
<map_file>etc/opensource-to-opensource/1.8.1.0/map.xml</map_file>
<eav_map_file>etc/opensource-to-opensource/map-eav.xml.dist</eav_map_file>
<eav_document_groups_file>etc/opensource-to-opensource/eav-document-groups.xml.dist</eav_document_groups_file>
<eav_attribute_groups_file>etc/opensource-to-opensource/eav-attribute-groups.xml.dist</eav_attribute_groups_file>
<log_map_file>etc/opensource-to-opensource/map-log.xml.dist</log_map_file>
<log_document_groups_file>etc/opensource-to-opensource/log-document-groups.xml.dist</log_document_groups_file>
<settings_map_file>etc/opensource-to-opensource/settings.xml.dist</settings_map_file>
<customer_map_file>etc/opensource-to-opensource/map-customer.xml.dist</customer_map_file>
<customer_document_groups_file>etc/opensource-to-opensource/customer-document-groups.xml.dist</customer_document_groups_file>
<customer_attribute_groups_file>etc/opensource-to-opensource/customer-attribute-groups.xml.dist</customer_attribute_groups_file>
<delta_document_groups_file>etc/opensource-to-opensource/deltalog.xml.dist</delta_document_groups_file>
<order_grids_document_groups_file>etc/opensource-to-opensource/order-grids-document-groups.xml.dist</order_grids_document_groups_file>
<map_document_groups>etc/opensource-to-opensource/map-document-groups.xml.dist</map_document_groups>
<class_map>etc/opensource-to-opensource/class-map.xml.dist</class_map>
<tier_price_map_file>etc/opensource-to-opensource/map-tier-price.xml.dist</tier_price_map_file>
<stores_map_file>etc/opensource-to-opensource/map-stores.xml.dist</stores_map_file>
<!--
In case bulk_size=0 it will be auto-detected for every document.
-->
<bulk_size>0</bulk_size>
<!--
Set direct_document_copy = 1 for better performance.
NOTE: 'source' and 'destination' databases MUST be placed on the same MySQL instance
and 'destination' user MUST be granted with 'SELECT' permissions on 'source' database
-->
<direct_document_copy>1</direct_document_copy>
<source_prefix />
<dest_prefix />
<auto_resolve_urlrewrite_duplicates>0</auto_resolve_urlrewrite_duplicates>
<log_file>migration.log</log_file>
<progress_bar_format>%percent%% [%bar%] Remaining Time: %remaining%</progress_bar_format>
<upgrade_customer_password_hash>1</upgrade_customer_password_hash>
<edition_migrate>opensource-to-opensource</edition_migrate>
<edition_number>1.8.1.0</edition_number>
<init_statements_source>SET NAMES utf8;</init_statements_source>
<init_statements_destination>SET NAMES utf8;</init_statements_destination>
<crypt_key>cccccccccccccccccccc</crypt_key>
</options>
and map.xml
<map xmlns:xs="http://www.w3.org/2001/XMLSchema-instance" xs:noNamespaceSchemaLocation="../../map.xsd">
<source>
<document_rules>
<ignore>
<document>cms_block</document>
</ignore>
<ignore>
<document>cms_block_store</document>
</ignore>
<ignore>
<document>cms_page</document>
</ignore>
<ignore>
<document>cms_page_store</document>
</ignore>
<ignore>
<document>core_config_data</document>
</ignore>
</document_rules>
</source>
<destination>
<document_rules>
<ignore>
<document>cms_block</document>
</ignore>
<ignore>
<document>cms_block_store</document>
</ignore>
<ignore>
<document>cms_page</document>
</ignore>
<ignore>
<document>cms_page_store</document>
</ignore>
<ignore>
<document>core_config_data</document>
</ignore>
</document_rules>
</destination>
hope somebody can help to make it work, thanks!
Martin
magento2 magento2-migration-tool
magento2 magento2-migration-tool
asked May 21 at 18:07
matinmatin
84110
asked May 21 at 18:07
matinmatin
84110
asked May 21 at 18:07
matinmatin
84110
asked May 21 at 18:07
matinmatin
84110
asked May 21 at 18:07
matinmatin
84110
84110
have you mapped map.xml?
– Saphal Jha
May 21 at 19:07
how do I map the map.xml - I only addes <map_file>etc/opensource-to-opensource/1.8.1.0/map.xml</map_file> to config.xml to <options> section? Is there something else to do?
– matin
May 22 at 5:57
let me know the commands you are using in cli
– Saphal Jha
May 22 at 6:30
php bin/magento migrate:settings -r vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.8.1.0/config.xml and php bin/magento migrate:data -r -a vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.8.1.0/config.xml
– matin
May 22 at 6:34
Can you please check with removing the core table skiping code?
– Saphal Jha
May 22 at 6:45
|
show 1 more comment
have you mapped map.xml?
– Saphal Jha
May 21 at 19:07
how do I map the map.xml - I only addes <map_file>etc/opensource-to-opensource/1.8.1.0/map.xml</map_file> to config.xml to <options> section? Is there something else to do?
– matin
May 22 at 5:57
let me know the commands you are using in cli
– Saphal Jha
May 22 at 6:30
php bin/magento migrate:settings -r vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.8.1.0/config.xml and php bin/magento migrate:data -r -a vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.8.1.0/config.xml
– matin
May 22 at 6:34
Can you please check with removing the core table skiping code?
– Saphal Jha
May 22 at 6:45
have you mapped map.xml?
– Saphal Jha
May 21 at 19:07
have you mapped map.xml?
– Saphal Jha
May 21 at 19:07
how do I map the map.xml - I only addes <map_file>etc/opensource-to-opensource/1.8.1.0/map.xml</map_file> to config.xml to <options> section? Is there something else to do?
– matin
May 22 at 5:57
how do I map the map.xml - I only addes <map_file>etc/opensource-to-opensource/1.8.1.0/map.xml</map_file> to config.xml to <options> section? Is there something else to do?
– matin
May 22 at 5:57
let me know the commands you are using in cli
– Saphal Jha
May 22 at 6:30
let me know the commands you are using in cli
– Saphal Jha
May 22 at 6:30
php bin/magento migrate:settings -r vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.8.1.0/config.xml and php bin/magento migrate:data -r -a vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.8.1.0/config.xml
– matin
May 22 at 6:34
php bin/magento migrate:settings -r vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.8.1.0/config.xml and php bin/magento migrate:data -r -a vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.8.1.0/config.xml
– matin
May 22 at 6:34
Can you please check with removing the core table skiping code?
– Saphal Jha
May 22 at 6:45
Can you please check with removing the core table skiping code?
– Saphal Jha
May 22 at 6:45
|
show 1 more comment
2 Answers
2
active
oldest
votes
0
data-migration-tool/etc/opensource-to-opensource/1.9.3.2/map.xml.dist
Rename This File To map.xml
In Your config.xml file Chnage this :-
From :-
<map_file>etc/opensource-to-opensource/1.9.3.2/map.xml.dist</map_file>
To :-
<map_file>etc/opensource-to-opensource/1.9.3.2/map.xml</map_file>
In Your map.xml File Just Add Table Which You Want to Ignore under the source document_rules Tag
<source>
<document_rules>
<ignore>
<document>cms_block</document>
</ignore>
<ignore>
<document>cms_block_store</document>
</ignore>
<ignore>
<document>cms_page</document>
</ignore>
<ignore>
<document>cms_page_store</document>
</ignore>
<ignore>
<document>core_config_data</document>
</ignore>
</document_rules>
</source>
No Other Changes In Map.xml File Just Add Your Table
answered May 22 at 7:33
Rk RathodRk Rathod
2,039214
add a comment |
0
Try to change the config.xml and map.xml with default migration file.
answered May 22 at 8:28
Saphal JhaSaphal Jha
1,167616
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f275522%2fmagento-2-data-migrattion-tools-ignores-map-xml%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
data-migration-tool/etc/opensource-to-opensource/1.9.3.2/map.xml.dist
Rename This File To map.xml
In Your config.xml file Chnage this :-
From :-
<map_file>etc/opensource-to-opensource/1.9.3.2/map.xml.dist</map_file>
To :-
<map_file>etc/opensource-to-opensource/1.9.3.2/map.xml</map_file>
In Your map.xml File Just Add Table Which You Want to Ignore under the source document_rules Tag
<source>
<document_rules>
<ignore>
<document>cms_block</document>
</ignore>
<ignore>
<document>cms_block_store</document>
</ignore>
<ignore>
<document>cms_page</document>
</ignore>
<ignore>
<document>cms_page_store</document>
</ignore>
<ignore>
<document>core_config_data</document>
</ignore>
</document_rules>
</source>
No Other Changes In Map.xml File Just Add Your Table
answered May 22 at 7:33
Rk RathodRk Rathod
2,039214
add a comment |
0
data-migration-tool/etc/opensource-to-opensource/1.9.3.2/map.xml.dist
Rename This File To map.xml
In Your config.xml file Chnage this :-
From :-
<map_file>etc/opensource-to-opensource/1.9.3.2/map.xml.dist</map_file>
To :-
<map_file>etc/opensource-to-opensource/1.9.3.2/map.xml</map_file>
In Your map.xml File Just Add Table Which You Want to Ignore under the source document_rules Tag
<source>
<document_rules>
<ignore>
<document>cms_block</document>
</ignore>
<ignore>
<document>cms_block_store</document>
</ignore>
<ignore>
<document>cms_page</document>
</ignore>
<ignore>
<document>cms_page_store</document>
</ignore>
<ignore>
<document>core_config_data</document>
</ignore>
</document_rules>
</source>
No Other Changes In Map.xml File Just Add Your Table
answered May 22 at 7:33
Rk RathodRk Rathod
2,039214
add a comment |
0
0
0
data-migration-tool/etc/opensource-to-opensource/1.9.3.2/map.xml.dist
Rename This File To map.xml
In Your config.xml file Chnage this :-
From :-
<map_file>etc/opensource-to-opensource/1.9.3.2/map.xml.dist</map_file>
To :-
<map_file>etc/opensource-to-opensource/1.9.3.2/map.xml</map_file>
In Your map.xml File Just Add Table Which You Want to Ignore under the source document_rules Tag
<source>
<document_rules>
<ignore>
<document>cms_block</document>
</ignore>
<ignore>
<document>cms_block_store</document>
</ignore>
<ignore>
<document>cms_page</document>
</ignore>
<ignore>
<document>cms_page_store</document>
</ignore>
<ignore>
<document>core_config_data</document>
</ignore>
</document_rules>
</source>
No Other Changes In Map.xml File Just Add Your Table
answered May 22 at 7:33
Rk RathodRk Rathod
2,039214
data-migration-tool/etc/opensource-to-opensource/1.9.3.2/map.xml.dist
Rename This File To map.xml
In Your config.xml file Chnage this :-
From :-
<map_file>etc/opensource-to-opensource/1.9.3.2/map.xml.dist</map_file>
To :-
<map_file>etc/opensource-to-opensource/1.9.3.2/map.xml</map_file>
In Your map.xml File Just Add Table Which You Want to Ignore under the source document_rules Tag
<source>
<document_rules>
<ignore>
<document>cms_block</document>
</ignore>
<ignore>
<document>cms_block_store</document>
</ignore>
<ignore>
<document>cms_page</document>
</ignore>
<ignore>
<document>cms_page_store</document>
</ignore>
<ignore>
<document>core_config_data</document>
</ignore>
</document_rules>
</source>
No Other Changes In Map.xml File Just Add Your Table
answered May 22 at 7:33
Rk RathodRk Rathod
2,039214
answered May 22 at 7:33
Rk RathodRk Rathod
2,039214
answered May 22 at 7:33
Rk RathodRk Rathod
2,039214
answered May 22 at 7:33
Rk RathodRk Rathod
2,039214
2,039214
add a comment |
add a comment |
0
Try to change the config.xml and map.xml with default migration file.
answered May 22 at 8:28
Saphal JhaSaphal Jha
1,167616
add a comment |
0
Try to change the config.xml and map.xml with default migration file.
answered May 22 at 8:28
Saphal JhaSaphal Jha
1,167616
add a comment |
0
0
0
Try to change the config.xml and map.xml with default migration file.
answered May 22 at 8:28
Saphal JhaSaphal Jha
1,167616
Try to change the config.xml and map.xml with default migration file.
answered May 22 at 8:28
Saphal JhaSaphal Jha
1,167616
answered May 22 at 8:28
Saphal JhaSaphal Jha
1,167616
answered May 22 at 8:28
Saphal JhaSaphal Jha
1,167616
answered May 22 at 8:28
Saphal JhaSaphal Jha
1,167616
1,167616
add a comment |
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f275522%2fmagento-2-data-migrattion-tools-ignores-map-xml%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
have you mapped map.xml?
– Saphal Jha
May 21 at 19:07
how do I map the map.xml - I only addes <map_file>etc/opensource-to-opensource/1.8.1.0/map.xml</map_file> to config.xml to <options> section? Is there something else to do?
– matin
May 22 at 5:57
let me know the commands you are using in cli
– Saphal Jha
May 22 at 6:30
php bin/magento migrate:settings -r vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.8.1.0/config.xml and php bin/magento migrate:data -r -a vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.8.1.0/config.xml
– matin
May 22 at 6:34
Can you please check with removing the core table skiping code?
– Saphal Jha
May 22 at 6:45