Page 23 of 24 FirstFirst ... 1321222324 LastLast
Results 221 to 230 of 240
  1. #221
    Join Date
    Mar 2012
    Posts
    67
    Plugin Contributions
    0

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

    Quote Originally Posted by lat9 View Post
    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:
    Code:
     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?

  2. #222
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    8,464
    Plugin Contributions
    68

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

    Apparently! What were the warnings?

  3. #223
    Join Date
    Mar 2012
    Posts
    67
    Plugin Contributions
    0

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

    Quote Originally Posted by lat9 View Post
    Apparently! What were the warnings?
    Here, I have made the subcategories like :: Vanteet :: 19 tuumaa but I still get this:
    Name:  ioimporterror.jpg
Views: 20
Size:  45.4 KB

  4. #224
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    8,464
    Plugin Contributions
    68

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

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

  5. #225
    Join Date
    Mar 2012
    Posts
    67
    Plugin Contributions
    0

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

    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

  6. #226
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    8,464
    Plugin Contributions
    68

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

    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.

  7. #227
    Join Date
    Mar 2012
    Posts
    67
    Plugin Contributions
    0

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

    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

  8. #228
    Join Date
    Mar 2012
    Posts
    67
    Plugin Contributions
    0

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

    Quote Originally Posted by lat9 View Post
    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.

  9. #229
    Join Date
    Nov 2009
    Location
    Aransas Pass, TX
    Posts
    101
    Plugin Contributions
    1

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

    Quote Originally Posted by lat9 View Post
    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.
    Last edited by IATIA; 18 Apr 2019 at 10:59 PM. Reason: forgot quote

  10. #230
    Join Date
    Mar 2012
    Posts
    67
    Plugin Contributions
    0

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

    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.

 

 
Page 23 of 24 FirstFirst ... 1321222324 LastLast

Similar Threads

  1. Support Thread for CKEditor Plugin
    By DivaVocals in forum All Other Contributions/Addons
    Replies: 146
    Last Post: 31 Jan 2019, 06:43 PM
  2. Back to Top Plugin [Support Thread]
    By picaflor-azul in forum All Other Contributions/Addons
    Replies: 31
    Last Post: 6 Feb 2016, 10:52 PM
  3. v151 Plug 'n' Pay plugin [Support Thread]
    By KetchRescue in forum Addon Payment Modules
    Replies: 5
    Last Post: 28 Nov 2015, 04:56 AM
  4. Justuno Plugin [Support Thread]
    By JustunoApp in forum All Other Contributions/Addons
    Replies: 8
    Last Post: 24 May 2015, 11:00 PM
  5. VendingBox Plugin Support Thread
    By vb_support in forum All Other Contributions/Addons
    Replies: 31
    Last Post: 10 Feb 2013, 07:24 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR