Attribute Set Importer doesn't fill attribute_group

[QuAzI]

Current version of magmi doesn't fill eav_attribute_group and as result eav_entity_attribute.attribute_group_id = 0

After that all records missed from UI.

Log contains

Attribute Set Importer v0.0.2 - Exception in update/insert loop for entity 'attribute association' in record no 29: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0-92' for key 'UNQ_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_GROUP_ID_ATTRIBUTE_ID',see trace log!
Attribute Set Importer v0.0.2 - Exception in update/insert loop for entity 'attribute association' in record no 54: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0-71' for key 'UNQ_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_GROUP_ID_ATTRIBUTE_ID',see trace log!
Attribute Set Importer v0.0.2 - Exception in update/insert loop for entity 'attribute association' in record no 55: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0-72' for key 'UNQ_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_GROUP_ID_ATTRIBUTE_ID',see trace log!
Attribute Set Importer v0.0.2 - Exception in update/insert loop for entity 'attribute association' in record no 56: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0-73' for key 'UNQ_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_GROUP_ID_ATTRIBUTE_ID',see trace log!

Files with attributes in attach

magmi_AttributeSet_sample_files-missed_eav_attribute_group.zip

[QuAzI]

Temporary solution:

1. Attribute group (and Attribute set as parent) must exist before import
2. frontend_input must be "text". Will not shown in frontend if null.
3. backend_type must be "varchar" instead "static" by default to prevent use attributes as columns. MAGMI can't create columns and Magento can't save values to "static" attributes with message like

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.aon_v_sluchae_podderzhki_ats' in 'field list', query was: SELECT STRAIGHT_JOIN e.entity_id, e.type_id, e.aon_v_sluchae_podderzhki_ats, e.avtodozvon, e.avtomaticheskij_obrez_bumagi, e.avtootvetchik, e.bluetooth, e.budilnik, e.chislo_adresatov_rassylki_nomerov, e.cvet, e.cvet_podsvetki_displeya, e.cvet_podsvetki_klaviatury, e.cvet_radiotelefona, e.cvet_telefona, e.dect, e.dect_radiotrubka, e.displej, e.dlina, e.dlina_dokumenta, e.dlitelnost_raboty_v_rezhime_razgovora, e.dopolnitelnye_knopki, e.element_pitaniya, e.funkciya_kopirovaniya, e.funkciya_otlozhennoj_peredachi, e.gromkaya_svyaz, e.identifikaciya_vyzyvayushhego_abonenta_caller_id, e.indikator_urovnya_signala, e.individualnye_melodii_zvonka, e.knopka_otvetit_zakonchit_razgovor, e.knopki_pryamogo_dostupa, e.kolichestvo_ottenkov_serogo, e.kolichestvo_podklyuchaemyx_baz, e.kolichestvo_v_upakovke, e.kol_vo_linij, e.kol_vo_radio_trubok_v_komplekte, e.komplektuetsya, e.kreplenie, e.maksimalnoe_kol_vo_sip_telefonov, e.maksimalnoe_kol_vo_trubok_na_1_bazu, e.maksimalnoe_vremya_raboty_v_rezhime_razgovora, e.modeli_sovmestimyx_telefonov, e.nachalnaya_emkost_vneshnix_linij, e.nachalnaya_emkost_vnutrennix_linij, e.nochnoj_rezhim, e.odnoknopochnyj_nabor, e.odnoknopochnyj_nabor_nomerov, e.opisanie, e.osnovnoj_lotok_dlya_bumagi_listov, e.osnovnye_programmiruemye_knopki_linij_s_indikaciej, e.osobennosti, e.osobennosti_dop_informaciya, e.pamyat_nabrannyx_nomerov, e.pamyat_nabrannyx_nomerov_kol_vo, e.pamyat_stranic, e.pamyat_stranic_na_otpravku, e.pamyat_stranic_na_priem, e.pitanie, e.podderzhka_bluetooth, e.podderzhka_gap, e.podderzhka_sms, e.podklyuchenie_garnitury, e.podsvetka_knopok_na_trubke, e.polifoniya, e.port_dlya_dop_ustrojstv, e.predelnaya_emkost_vneshnix_linij, e.predelnaya_emkost_vnutrennix_linij, e.predelnoe_kol_vo_vneshnix_ip_linij, e.princip_pechati, e.radius_dejstviya, e.rasshiryaemaya, e.razem_1, e.razem_2, e.razem_dlya_garnitury, e.razem_rj_11, e.razem_rj_45, e.razem_usb, e.razmery, e.razmery_bazy, e.razmery_trubki, e.razreshenie_faksa, e.regulirovka_gromkosti, e.regulirovka_naklona, e.regulirovka_ugla_naklona, e.shirina_dokumenta, e.shirina_pechati, e.shirina_skanirovaniya, e.skorost_pechati, e.sku, e.sovmestima_s_sistemnymi_telefonami, e.spikerfon, e.spikerfon_na_baze, e.spikerfon_na_trubke, e.telefonnyj_spravochnik_nomerov, e.tip_akkumulyatora, e.tip_displeya_trubki, e.tip_ispolzuemoj_bumagi, e.tip_podklyucheniya, e.ustrojstvo_avtopodachi_listov, e.ves, e.vibrozvonok, e.vnutrennyaya_svyaz, e.vozmozhnost_ustanovki_na_stene, e.vremya_data_na_displee, e.vremya_ozhidaniya, e.vremya_razgovora, e.zhk_displej_kolichestvo_strok, e.zvuk, stock_status.stock_statusASin_stockFROMcatalog_product_entityASeINNER JOINcatalog_product_websiteASwebsiteON website.product_id=e.entity_id AND website.website_id='1' INNER JOINcataloginventory_stock_statusASstock_statusON stock_status.product_id=e.entity_id AND stock_status.website_id='1' INNER JOINcataloginventory_stock_statusAScissON ciss.product_id = e.entity_id AND ciss.website_id = website.website_id WHERE (e.entity_id IN('21102')) AND (e.entity_id>0) AND (ciss.stock_status = 1) ORDER BYe.entity_id ASC LIMIT 100

[lawko]

In 2_attribute_set.csv you must add column magmi:groups and not existing group name will be created. Example: "attribute_set_name","sort_order","magmi:groups" "clSet","0","Attributes"