Printable View
I installed the github upgrade but I still have import problems. Now I get:Quote:
Originally Posted by lat9
So are also warnings preventing the upgrade?Code:dbio.Products.test24_1_500.csv" was completed with 0 errors and 1071 warnings. 0 records were inserted or updated.
Apparently! What were the warnings?
Here, I have made the subcategories like :: Vanteet :: 19 tuumaa but I still get this:Quote:
Originally Posted by lat9
Attachment 18415
Would you post (between CODE tags) one line of that import CSV?
Here is first part of it:Code: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
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.
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
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.Quote:
Originally Posted by lat9
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.
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.Quote:
Originally Posted by lat9
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.