Page 4 of 48 FirstFirst ... 2345614 ... LastLast
Results 31 to 40 of 476
  1. #31
    Join Date
    Aug 2009
    Location
    Longs, SC
    Posts
    626
    Plugin Contributions
    2

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

    Quote Originally Posted by mc12345678 View Post
    Huh? Not sure which version of EP to which you are referring, but if there is a version of EP that *doesn't* support adding a product, then it is definitely defunct. EP4 does this by providing a new line of data that has a new primary key (default is products_model, but also has the ability to not identify a products_model or use a duplicate products_model and instead use the products_id or whatever is decided to be the primary key).
    You misunderstood. What I'm saying is that this function is IN EP but not DBIO. I'm asking if that was intentionally left out, if I missed the function in DBIO that's already there, or if it's planned and not yet implemented.

  2. #32
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,399
    Plugin Contributions
    87

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

    @badarac, there's a Products handler that enables you to import/export any fields present in the products/products_descriptions tables.

  3. #33
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,399
    Plugin Contributions
    87

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

    Quote Originally Posted by badarac View Post
    Oh and I really like the templates and the ability to create new ones. A suggestion is to add v_dbio_command to the pull down so it can be added to a template
    Good suggestion; let me see what's up with that.

  4. #34
    Join Date
    Aug 2009
    Location
    Longs, SC
    Posts
    626
    Plugin Contributions
    2

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

    Quote Originally Posted by lat9 View Post
    @badarac, there's a Products handler that enables you to import/export any fields present in the products/products_descriptions tables.
    The way it seems to work though is it needs an existing product id and/or model. That would seem to indicate that it can only update information for existing products. Am I wrong?

  5. #35
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,399
    Plugin Contributions
    87

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

    If the product is not found (by id or model), it's added during any import processing. You just need a unique model number to identify the product.

  6. #36
    Join Date
    Aug 2009
    Location
    Longs, SC
    Posts
    626
    Plugin Contributions
    2

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

    Quote Originally Posted by lat9 View Post
    If the product is not found (by id or model), it's added during any import processing. You just need a unique model number to identify the product.
    I exported the products, deleted all but one row (and the headers), deleted the product id, and made a unique model number. When I import the csv file with the single record it gives an error[*] products.products_id, line #2: Value () is not an integer. Is there a unique integer value that must be entered in the products_id column? Bug?

  7. #37
    Join Date
    Aug 2009
    Location
    Longs, SC
    Posts
    626
    Plugin Contributions
    2

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

    Installed on 1.5.5e btw. Site is installed in a subdirectory for testing so I can make changes without harming anything if you want me to test a change.

  8. #38
    Join Date
    Jul 2012
    Posts
    16,718
    Plugin Contributions
    17

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

    Quote Originally Posted by badarac View Post
    You misunderstood. What I'm saying is that this function is IN EP but not DBIO. I'm asking if that was intentionally left out, if I missed the function in DBIO that's already there, or if it's planned and not yet implemented.
    Yes, I did misread the statement placing the wrong emPHAsis on something missing from EP instead of something in EP considered missing from DbIO as a variant of EP.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  9. #39
    Join Date
    Jul 2012
    Posts
    16,718
    Plugin Contributions
    17

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

    Quote Originally Posted by badarac View Post
    Installed on 1.5.5e btw. Site is installed in a subdirectory for testing so I can make changes without harming anything if you want me to test a change.
    My guess would be that the products_id column would need to be removed to support adding such a new product or a value of 0 maybe. Otherwise it identifies that there is nothing present as reported.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  10. #40
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,399
    Plugin Contributions
    87

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

    Quote Originally Posted by mc12345678 View Post
    My guess would be that the products_id column would need to be removed to support adding such a new product or a value of 0 maybe. Otherwise it identifies that there is nothing present as reported.
    One of those was a good guess!

    To insert a product via import, you'll need to have both the v_products_id and v_products_model fields present in the to-be-imported CSV. Set the products_id value to 0 (not blank) and the products_model to the new product's unique model number.

 

 
Page 4 of 48 FirstFirst ... 2345614 ... LastLast

Similar Threads

  1. Support Thread for CKEditor Plugin
    By DivaVocals in forum Addon Admin Tools
    Replies: 201
    Last Post: 31 Aug 2021, 05:14 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