Database I/O Manager (DbIo) Plugin [Support Thread]

[OopsIbrickedIT]

It sounds like (from the first referenced post) that you're importing those products. You'll need to add a column named v_dbio_command and fill each column with the DbIo command ADD to force the import of those products.

For the second referenced post, you've run into the same issue as @lynbor; see post #213 for the correction.

I installed the github upgrade but I still have import problems. Now I get:

 dbio.Products.test24_1_500.csv" was completed with 0 errors and 1071 warnings. 0 records were inserted or updated.

So are also warnings preventing the upgrade?

[lat9]

Apparently! What were the warnings?

[OopsIbrickedIT]

Apparently! What were the warnings?

Here, I have made the subcategories like :: Vanteet :: 19 tuumaa but I still get this:

[lat9]

Would you post (between CODE tags) one line of that import CSV?

[OopsIbrickedIT]

Here is first part of it:

v_products_id;v_products_type;v_products_quantity;v_products_model;v_products_image;v_products_price;v_products_virtual;v_products_date_added;v_products_last_modified;v_products_date_available;v_products_weight;v_products_status;v_products_ordered;v_products_quantity_order_min;v_products_quantity_order_units;v_products_priced_by_attribute;v_product_is_free;v_product_is_call;v_products_quantity_mixed;v_product_is_always_free_shipping;v_products_qty_box_status;v_products_quantity_order_max;v_products_sort_order;v_products_discount_type;v_products_discount_type_from;v_products_price_sorter;v_products_mixed_discount_quantity;v_metatags_title_status;v_metatags_products_name_status;v_metatags_model_status;v_metatags_price_status;v_metatags_title_tagline_status;v_products_name_fi;v_products_description_fi;v_products_short_desc_fi;v_products_url_fi;v_products_viewed_fi;v_manufacturers_name;v_tax_class_title;v_categories_name;v_dbio_command
0;1;0;RHPRO295947R/MGM/3000(1169);art_1011159.jpg;553.9;0;12.4.2019 22:56;12.4.2019 22:58;;10;1;0;1;1;0;0;0;1;0;1;0;0;0;0;553.9;1;0;1;1;1;0;BARRACUDA PROJECT 2.0 Mattgunmetal/ undercut Colour Trim punaine;BARRACUDA PROJECT 2.0 Mattgunmetal/ undercut Colour Trim punainen Vanne 9.5x19 - 19 tuumaa 5x112 Pulttijako;;;0;;;:: Vanteet ::^Barracuda^19 tuumaa^5x112;ADD
0;1;0;RHPRO285945R/MGM220293000(1173);art_1011157.jpg;569.65;0;12.4.2019 22:56;12.4.2019 22:58;;10;1;0;1;1;0;0;0;1;0;1;0;0;0;0;569.65;1;0;1;1;1;0;BARRACUDA PROJECT 2.0 Mattgunmetal/ undercut Colour Trim punaine;BARRACUDA PROJECT 2.0 Mattgunmetal/ undercut Colour Trim punainen Vanne 8.5x19 - 19 tuumaa 5x112 Pulttijako;;;0;;;:: Vanteet ::^Barracuda^19 tuumaa^5x112;ADD
0;1;0;RHPRO295947R/MGM220283000(1171);art_1011137.jpg;588.55;0;12.4.2019 22:56;12.4.2019 22:58;;10;1;0;1;1;0;0;0;1;0;1;0;0;0;0;588.55;1;0;1;1;1;0;BARRACUDA PROJECT 2.0 Mattgunmetal/ undercut Colour Trim punaine;BARRACUDA PROJECT 2.0 Mattgunmetal/ undercut Colour Trim punainen Vanne 9.5x19 - 19 tuumaa 5x112 Pulttijako;;;0;;;:: Vanteet ::^Barracuda^19 tuumaa^5x112;ADD
0;1;0;RHPRO285945R/MGM/3000(1151);art_1011072.jpg;532.9;0;12.4.2019 22:56;12.4.2019 22:58;;10;1;0;1;1;0;0;0;1;0;1;0;0;0;0;532.9;1;0;1;1;1;0;BARRACUDA PROJECT 2.0 Mattgunmetal/ undercut Colour Trim punaine;BARRACUDA PROJECT 2.0 Mattgunmetal/ undercut Colour Trim punainen Vanne 8.5x19 - 19 tuumaa 5x112 Pulttijako;;;0;;;:: Vanteet ::^Barracuda^19 tuumaa^5x112;ADD
0;1;0;RHPRO285945R/MGM22029(1086);art_1011075.jpg;539.2;0;12.4.2019 22:56;12.4.2019 22:58;;10;1;0;1;1;0;0;0;1;0;1;0;0;0;0;539.2;1;0;1;1;1;0;BARRACUDA PROJECT 2.0 Mattgunmetal vanne 8.5x19 - 19 tuumaa 5x11;BARRACUDA PROJECT 2.0 Mattgunmetal Vanne 8.5x19 - 19 tuumaa 5x112 Pulttijako;;;0;;;:: Vanteet ::^Barracuda^19 tuumaa^5x112;ADD
0;1;0;RHPRO290035T/MGM12124(1089);art_1011121.jpg;640;0;12.4.2019 22:56;12.4.2019 22:58;;10;1;0;1;1;0;0;0;1;0;1;0;0;0;0;640;1;0;1;1;1;0;BARRACUDA PROJECT 2.0 Mattgunmetal vanne 9x20 - 20 tuumaa 5x120;BARRACUDA PROJECT 2.0 Mattgunmetal Vanne 9x20 - 20 tuumaa 5x120 Pulttijako;;;0;;;:: Vanteet ::^Barracuda^20 tuumaa^5x120;ADD

[lat9]

Is Finnish the default language for your store? I've taken the CSV sample that you provided (changing the language-based fields from _fi to _en), creating the associated categories and had no issue with the import.

[OopsIbrickedIT]

Hi,

yes finnish is the default language and old shop does not seem to have even an option to change language. I just started working with this shop. I will try to change to _en

[OopsIbrickedIT]

Is Finnish the default language for your store? I've taken the CSV sample that you provided (changing the language-based fields from _fi to _en), creating the associated categories and had no issue with the import.

If I remember right I had to copy some files to english side to finnish side when installing to get the GUI visible & working. It could be perhaps something related to that.

I tried changing language related categories to _en and I got same results aka warning can not insert to subgategories because they don't exists.

[IATIA]

Correction found for the issue reported by @lynbor; see https://github.com/lat9/dbio/commit/...7bb295aebedbea for details.

Seems to have fixed it for me. Just tried importing yesterday and got 3 zillion integer errors. Added the GitHub fixes and all seems good now. Fixing to install and fire up a fresh copy of zencart and try again.

[OopsIbrickedIT]

Thank you Lat9. I also installed latest Github version and got rid of Integer errors.

Main reason I could not make exports to subcategories was that I had 2 same named categories the old one without subcategories was BARRACUDA and the new which had right subcategories was named Barracuda. The db-connection query does not see any difference between them and because I had "make categories from csv" turned off it could not make categories to old BARRACUDA folder either. Lat9 spotted that. Thank you to her very much! I have now bulk imported over 1500 products to ZC with DbIo without any problems.