Magento: Daten migrieren von 1.9.2 auf 2.0

1. DB Dump machen
2. Download Magento 2.0
3. Installieren von Magento 2.0
   Sicherstellen, dass alle Bedingungen / Anforderungen erfüllt sind
   php.ini: mod_intl (?) und always_send_raw_post_data = -1

Data Migration Tool (http://devdocs.magento.com/guides/v2.0/migration/migration-tool-install.html)

1. composer
2. Dowload Git for Windows (https://git-scm.com/download/win)

3. sebastian@Ultrabook /cygdrive/c/apache/htdocs/anno_2.0 $ composer config repositories.magento composer https://repo.magento.com 
   sebastian@Ultrabook /cygdrive/c/apache/htdocs/anno_2.0 $ composer require magento/data-migration-tool:2.0.0 
   ./composer.json has been updated Loading composer repositories with package information                                
   Updating dependencies (including require-dev)
              - Installing magento/data-migration-tool (2.0.0)
        Downloading: 100% Writing lock file Generating autoload files

4. Konfiguration
   http://devdocs.magento.com/guides/v2.0/migration/migration-tool-configure.html

   sebastian@Ultrabook /cygdrive/c/apache/htdocs/anno_2.0/vendor/magento/data-migration-tool/etc/ce-to-ce/1.9.2.1
   $ cp config.xml.dist config.xml
   

   Ändern der config.xml:
   source, destination (password=“xx“ hinzufügen) und crypt_key

5. PATH um magento2/bin erweitern
6. bin/magento migrate:settings /cygdrive/c/apache/htdocs/anno_2.0/vendor/magento/data-migration-tool/etc/ce-to-ce/1.9.2.1/config.xml
   …ging nicht mit Cygwin – mal mit DOS versuchen….
   …das ging:

   C:\apache\htdocs\anno_2.0>php .\bin\magento migrate:settings C:\apache\htdocs\anno_2.0\vendor\magento\data-migration-tool\etc\ce-to-ce\1.9.2.1\config.xml
   
   [2015-12-23 09:16:52][INFO][mode: settings][stage: integrity check][step: Settings Step]: started
   100% [============================] Remaining Time: 1 sec
   [2015-12-23 09:16:52][INFO][mode: settings][stage: integrity check][step: Stores Step]: started
   100% [============================] Remaining Time: 1 sec
   [2015-12-23 09:16:53][INFO][mode: settings][stage: data migration][step: Settings Step]: started
   100% [============================] Remaining Time: 1 sec
   [2015-12-23 09:16:58][INFO][mode: settings][stage: data migration][step: Stores Step]: started
   100% [============================] Remaining Time: 1 sec
   [2015-12-23 09:16:58][INFO][mode: settings][stage: volume check][step: Stores Step]: started
   100% [============================] Remaining Time: 1 sec
   [2015-12-23 09:16:58][INFO][mode: settings][stage: volume check][step: Stores Step]: Migration completed

7. Daten migrieren:

   C:\apache\htdocs\anno_2.0>php .\bin\magento migrate:data -r C:\apache\htdocs\anno_2.0\vendor\magento\data-migration-tool\etc\ce-to-ce\1.9.2.1\config.xml
   Reset the current position of migration to start from the beginning
   
   [2015-12-23 09:30:51][INFO][mode: data][stage: integrity check][step: EAV Step]: started
   100% [============================] Remaining Time: 1 sec
   [2015-12-23 09:30:51][ERROR]: Source fields are missing or not mapped. Document: catalog_eav_attribute. Fields: is_visible_on_checkout
   [2015-12-23 09:30:51][INFO][mode: data][stage: integrity check][step: Customer Attributes Step]: started
   100% [============================] Remaining Time: 1 sec
   [2015-12-23 09:30:52][INFO][mode: data][stage: integrity check][step: Map Step]: started
   100% [============================] Remaining Time: 1 sec
   [2015-12-23 09:31:06][ERROR]: Source documents are missing or not mapped: activated_banner,activated_reference,activated_slider,atlas_bannerslider,atlas_bannerslidergroup,atlas_bannerslidergroup_relation,ereactor_slider_slide,ereactor_slider_slideshow,f_slideshow_trace_flag,flagbit_factfinder_scic_queue,m_attribute,m_db,m_db_log,m_edit_session,m_filter,m_filter2,m_filter2_store,m_filter2_value,m_filter2_value_store,m_filter_datetime,m_filter_decimal,m_filter_int,m_filter_text,m_filter_varchar,mksresponsivebannerslider,nbanners,newsletter_subscriber_status,payone_config_payment_method,payone_protocol_api,payone_protocol_transactionstatus,payone_transaction,slideshow,smtppro_email_log,symmetrics_cashticket,symmetrics_trustedrating_emails,webforms,webforms_fields,webforms_fieldsets,webforms_logic,webforms_message,webforms_quickresponse,webforms_results,webforms_results_values,webforms_store,xmlconnect_application,xmlconnect_config_data,xmlconnect_history,xmlconnect_images,xmlconnect_notification_template,xmlconnect_queue
   [2015-12-23 09:31:06][ERROR]: Source fields are missing or not mapped. Document: checkout_agreement. Fields: is_required
   [2015-12-23 09:31:06][ERROR]: Source fields are missing or not mapped. Document: sales_flat_invoice. Fields: cod_fee,base_cod_fee,cod_tax_amount,base_cod_tax_amount,payone_sequencenumber
   [2015-12-23 09:31:06][ERROR]: Source fields are missing or not mapped. Document: sales_flat_order. Fields: cod_fee,base_cod_fee,cod_fee_invoiced,base_cod_fee_invoiced,cod_tax_amount,base_cod_tax_amount,cod_tax_amount_invoiced,base_cod_tax_amount_invoiced,payone_transaction_status,payone_dunning_status,payone_payment_method_type
   [2015-12-23 09:31:06][ERROR]: Source fields are missing or not mapped. Document: sales_flat_order_payment. Fields: payone_config_payment_method_id,payone_payment_method_type,payone_payment_method_name,payone_onlinebanktransfer_type,payone_bank_country,payone_account_number,payone_account_owner,payone_bank_code,payone_bank_group,payone_pseudocardpan,payone_clearing_bank_accountholder,payone_clearing_bank_country,payone_clearing_bank_account,payone_clearing_bank_code,payone_clearing_bank_iban,payone_clearing_bank_bic,payone_clearing_bank_city,payone_clearing_bank_name,payone_financing_type,payone_safe_invoice_type,payone_clearing_legalnote,payone_clearing_duedate,payone_clearing_reference,payone_clearing_instructionnote
   [2015-12-23 09:31:06][ERROR]: Source fields are missing or not mapped. Document: sales_flat_quote. Fields: cod_fee,base_cod_fee,cod_tax_amount,base_cod_tax_amount,invoicepdf_add_totals
   [2015-12-23 09:31:06][ERROR]: Source fields are missing or not mapped. Document: sales_flat_quote_address. Fields: cod_fee,base_cod_fee,cod_tax_amount,base_cod_tax_amount,payone_addresscheck_score,payone_addresscheck_date,payone_addresscheck_hash,payone_protect_score,payone_protect_date,payone_protect_hash
   [2015-12-23 09:31:06][ERROR]: Source fields are missing or not mapped. Document: sales_flat_quote_payment. Fields: payone_config_payment_method_id,payone_onlinebanktransfer_type,payone_bank_country,payone_account_number,payone_account_owner,payone_bank_code,payone_bank_group,payone_pseudocardpan,payone_financing_type,payone_safe_invoice_type
   [2015-12-23 09:31:06][INFO][mode: data][stage: integrity check][step: Url Rewrite Step]: started
   100% [============================] Remaining Time: 1 sec
   [2015-12-23 09:31:06][INFO][mode: data][stage: integrity check][step: Log Step]: started
   100% [============================] Remaining Time: 1 sec
   [2015-12-23 09:31:06][INFO][mode: data][stage: integrity check][step: Ratings Step]: started
   100% [============================] Remaining Time: 1 sec
   [2015-12-23 09:31:06][INFO][mode: data][stage: integrity check][step: ConfigurablePrices step]: started
   100% [============================] Remaining Time: 1 sec
   [2015-12-23 09:31:06][INFO][mode: data][stage: integrity check][step: OrderGrids Step]: started
   100% [============================] Remaining Time: 1 sec
   [2015-12-23 09:31:06][INFO][mode: data][stage: integrity check][step: Tier Price Step]: started
   100% [============================] Remaining Time: 1 sec
   [2015-12-23 09:31:06][INFO][mode: data][stage: integrity check][step: SalesIncrement Step]: started
   100% [============================] Remaining Time: 1 sec
   
   
   [Migration\Exception]
   Integrity Check failed
   
   

8. Mapping der gemeldeten Tabellen und Felder manuell herstellen:

   <source>
   <document_rules/>
   <field_rules>
   <!--My custom ignored fields-->
   <ignore>
   <field>catalog_eav_attribute.is_visible_on_checkout</field>
   </ignore>
   <!--END: My custom ignored fields-->

   in der Datei „C:\apache\htdocs\anno_2.0\vendor\magento\data-migration-tool\etc\ce-to-ce\map-eav.xml“ geändert.

9. map-eav.xml in Kofiguration aktivieren:
   In Datei „config.xml“ die Zeile

   <eav_map_file>etc/ce-to-ce/map-eav.xml.dist</eav_map_file>

   ändern in:

   <eav_map_file>etc/ce-to-ce/map-eav.xml</eav_map_file>

10. Datei „map.xml.dist“ in „map.xml“ umbenennen und entsprechend in config.xml referenzieren.
11. Restliche „Source documents are missing…“ Fehler in der Datei „map.xml“ fach folgendem Shema hinzufügen:

    <source>
    <document_rules>
    <ignore>
    <document>activated_banner</document>
    </ignore>
    
    

12. Weitere Fehler:

    ....
    [2016-01-03 14:22:38][INFO][mode: data][stage: volume check][step: EAV Step]: started
    100% [============================] Remaining Time: 1 sec
    [2016-01-03 14:22:38][ERROR]: Incorrect value: mana_filters/source_filterable in: eav_attribute.source_model for attribute_code=is_enabled
    [2016-01-03 14:22:38][ERROR]: Incorrect value: mana_filters/source_filterable in: eav_attribute.source_model for attribute_code=is_enabled_in_search
    [2016-01-03 14:22:38][ERROR]: Incorrect value: mana_filters/source_display in: eav_attribute.source_model for attribute_code=display
    [2016-01-03 14:22:38][INFO][mode: data][stage: volume check][step: EAV Step]: Error occurred. Rollback.
    [2016-01-03 14:22:38][INFO][mode: data][stage: volume check][step: EAV Step]: EAV Step: rollback
    [2016-01-03 14:22:38][INFO][mode: data][stage: volume check][step: EAV Step]: Please fix errors and run Migration Tool again
    
    
    [Migration\Exception]
    Volume Check failed
    ....

    gelöst mit folgenden Einträgen in der Datei „C:\apache\htdocs\anno_2.0\vendor\magento\data-migration-tool\etc\ce-to-ce\class-map.xml„:

    <rename>
    <from>mana_filters/source_filterable</from>
    <to />
    </rename>
    <rename>
    <from>mana_filters/source_display</from>
    <to />
    </rename>

am Ende: der erfolgreiche Aufruf:

C:\apache\htdocs\anno_2.0>php .\bin\magento migrate:data C:\apache\htdocs\anno_2.0\vendor\magento\data-migration-tool\etc\ce-to-ce\1.9.2.1\config.xml

[2016-01-03 14:38:47][INFO][mode: data][stage: integrity check][step: EAV Step]: started
[2016-01-03 14:38:47][INFO][mode: data][stage: integrity check][step: Customer Attributes Step]: started
[2016-01-03 14:38:47][INFO][mode: data][stage: integrity check][step: Map Step]: started
[2016-01-03 14:38:47][INFO][mode: data][stage: integrity check][step: Url Rewrite Step]: started
[2016-01-03 14:38:47][INFO][mode: data][stage: integrity check][step: Log Step]: started
[2016-01-03 14:38:47][INFO][mode: data][stage: integrity check][step: Ratings Step]: started
[2016-01-03 14:38:47][INFO][mode: data][stage: integrity check][step: ConfigurablePrices step]: started
[2016-01-03 14:38:47][INFO][mode: data][stage: integrity check][step: OrderGrids Step]: started
[2016-01-03 14:38:47][INFO][mode: data][stage: integrity check][step: Tier Price Step]: started
[2016-01-03 14:38:47][INFO][mode: data][stage: integrity check][step: SalesIncrement Step]: started
[2016-01-03 14:38:47][INFO][mode: data][stage: setup triggers][step: Stage]: started
[2016-01-03 14:38:47][INFO][mode: data][stage: data migration][step: EAV Step]: started
100% [============================] Remaining Time: 1 sec
[2016-01-03 14:38:50][INFO][mode: data][stage: volume check][step: EAV Step]: started
100% [============================] Remaining Time: 1 sec
[2016-01-03 14:38:51][INFO][mode: data][stage: data migration][step: Customer Attributes Step]: started
100% [============================] Remaining Time: 1 sec
[2016-01-03 14:38:52][INFO][mode: data][stage: volume check][step: Customer Attributes Step]: started
100% [============================] Remaining Time: 1 sec
[2016-01-03 14:38:52][INFO][mode: data][stage: data migration][step: Map Step]: started
100% [============================] Remaining Time: 1 sec
[2016-01-03 14:39:25][INFO][mode: data][stage: volume check][step: Map Step]: started
100% [============================] Remaining Time: 1 sec
[2016-01-03 14:39:27][INFO][mode: data][stage: data migration][step: Url Rewrite Step]: started
100% [============================] Remaining Time: 1 sec
[2016-01-03 14:39:59][INFO][mode: data][stage: volume check][step: Url Rewrite Step]: started
100% [============================] Remaining Time: 1 sec
[2016-01-03 14:39:59][INFO][mode: data][stage: data migration][step: Log Step]: started
100% [============================] Remaining Time: 1 sec
[2016-01-03 14:42:26][INFO][mode: data][stage: volume check][step: Log Step]: started
100% [============================] Remaining Time: 1 sec
[2016-01-03 14:42:26][INFO][mode: data][stage: data migration][step: Ratings Step]: started
100% [============================] Remaining Time: 1 sec
[2016-01-03 14:42:26][INFO][mode: data][stage: volume check][step: Ratings Step]: started
100% [============================] Remaining Time: 1 sec
[2016-01-03 14:42:26][INFO][mode: data][stage: data migration][step: ConfigurablePrices step]: started
100% [============================] Remaining Time: 1 sec
[2016-01-03 14:42:26][INFO][mode: data][stage: volume check][step: ConfigurablePrices step]: started
100% [============================] Remaining Time: 1 sec
[2016-01-03 14:42:26][INFO][mode: data][stage: data migration][step: OrderGrids Step]: started
100% [============================] Remaining Time: 1 sec
[2016-01-03 14:42:27][INFO][mode: data][stage: volume check][step: OrderGrids Step]: started
100% [============================] Remaining Time: 1 sec
[2016-01-03 14:42:27][INFO][mode: data][stage: data migration][step: Tier Price Step]: started
100% [============================] Remaining Time: 1 sec
[2016-01-03 14:42:27][INFO][mode: data][stage: volume check][step: Tier Price Step]: started
100% [============================] Remaining Time: 1 sec
[2016-01-03 14:42:27][INFO][mode: data][stage: data migration][step: SalesIncrement Step]: started
100% [============================] Remaining Time: 1 sec
[2016-01-03 14:42:28][INFO][mode: data][stage: volume check][step: SalesIncrement Step]: started
100% [============================] Remaining Time: 1 sec
[2016-01-03 14:42:28][INFO][mode: data][stage: volume check][step: SalesIncrement Step]: Migration completed