Page 1 of 10 123 ... LastLast
Results 1 to 10 of 94
  1. #1
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    6,735
    Plugin Contributions
    59

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

    The Database I/O Manager (DbIO) enables you to input (or import) and output (or export) information to and from your database using a .csv file as the "transport method".

    It seems like I spent a significant portion of time this year providing clients with "import/export" scripts and DbIo is the culmination of my effort to create an extendable I/O script. Yes, there are other I/O scripts (like EZ-Populate and Apsona) but I wanted a script that holds to these principles:
    1. Use Zen Cart's built-in processing, especially the database interfaces.
    2. Use a class-based approach, enabling a higher degree of code reuse.
    3. Let the database drive the data; use the database settings to guide "proper" input processing.
    4. Keep the data-pool consistent; broadly define the character-encoding of the .CSV repositories.
    5. Keep to, where possible, the EP-4 interface described in its wiki.
    6. Multi-language awareness.
    7. Be data-driven. If you've installed a plugin that simply adds a field to an existing table (like products or orders), that field is a candidate for any I/O operation on that database table without additional coding.

    Like any process that changes information in your database: Make a backup of your database prior to performing a "full-import" (which actually changes your database)!

    Check out the readme for operational details, but my goal is to make the on-screen instructions "good enough" for most users.

    I'll post the plugin's download link once I receive it.

  2. #2
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    6,735
    Plugin Contributions
    59

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

    Once reviewed, the plugin can be downloaded from https://www.zen-cart.com/downloads.php?do=file&id=2091.

  3. #3
    Join Date
    Jan 2007
    Posts
    1,323
    Plugin Contributions
    10

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

    Sounds great. In EP it will list all products in every instance of it when it's been linked to multiple categories which can be inconvenient when making changes. Will this only list the product in the master category or have a setting for that?

    Zen Cart and it's community are the best!!

  4. #4
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    6,735
    Plugin Contributions
    59

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

    Quote Originally Posted by lankeeyankee View Post
    Sounds great. In EP it will list all products in every instance of it when it's been linked to multiple categories which can be inconvenient when making changes. Will this only list the product in the master category or have a setting for that?
    For a products' import/export, each product is listed one time ... and associated to its master-category-id by a caret (^) separated list of category names (specified in the site's default language).

  5. #5
    Join Date
    May 2009
    Posts
    167
    Plugin Contributions
    0

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

    I'm excited the work might be able to help me with this.
    https://www.zen-cart.com/showthread....54#post1312654

  6. #6
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    6,735
    Plugin Contributions
    59

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

    Quote Originally Posted by Zean View Post
    I'm excited the work might be able to help me with this.
    https://www.zen-cart.com/showthread....54#post1312654
    You've got three (3) requests in that post:
    1. Include, and process, the categories' sort-order in a products' export. DbIo doesn't export that value either for its products' report (it would actually be a set of values, right, since each category has its own sort-order). What bearing does a categories' sort-order have on a product's definition? I can see including the categories' sort-order with a categories I/O handler, but for products?
    2. Include sort-orders in the basic attributes' export. DbIo's "basic" products-attributes I/O report does not include those fields, either. For this report, the idea is to keep the processed fields to a minimum.
    3. Include sort-orders in the detailed attributes' export. DbIo, like EP-4, includes only the attribute-specific sort order (the v_products_options_sort_order) since that report is dealing with the products_attributes table. The option-specific sort order is included in the ProductsOptions handler's processing and the option-value-specific sort order is included in the ProductsOptionsValues handler.

  7. #7
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    6,735
    Plugin Contributions
    59

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

    Quote Originally Posted by lat9 View Post
    Once reviewed, the plugin can be downloaded from https://www.zen-cart.com/downloads.php?do=file&id=2091.
    v1.0.0 is now available for download.

  8. #8
    Join Date
    Sep 2005
    Posts
    95
    Plugin Contributions
    0

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

    Not sure which way to go to correct my issue. I have this error when I navigate to the plug in.
    The DbIo Manager does not support your installation, due to a mismatch between your DB_CHARSET (utf-8) and CHARSET (utf-8) value.
    What would be the best way to resolve my mismatch issue to allow me to use the plugin?
    Zen-Cart, The Greatest Shopping Cart!

  9. #9
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    6,735
    Plugin Contributions
    59

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

    Quote Originally Posted by GearStudios View Post
    Not sure which way to go to correct my issue. I have this error when I navigate to the plug in.
    The DbIo Manager does not support your installation, due to a mismatch between your DB_CHARSET (utf-8) and CHARSET (utf-8) value.
    What would be the best way to resolve my mismatch issue to allow me to use the plugin?
    You can correct the setting (in your configure.php files) for DB_CHARSET to read
    Code:
    define ('DB_CHARSET', 'utf8');
    instead of
    Code:
    define ('DB_CHARSET', 'utf-8');
    There's no intervening minus-sign (-) in that definition.

  10. #10
    Join Date
    Sep 2005
    Posts
    95
    Plugin Contributions
    0

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

    That's awesome! Fixed the issue! Thank you! +10
    Zen-Cart, The Greatest Shopping Cart!

 

 
Page 1 of 10 123 ... LastLast

Similar Threads

  1. Support Thread for CKEditor Plugin
    By DivaVocals in forum All Other Contributions/Addons
    Replies: 118
    Last Post: 1 Jun 2017, 03:17 AM
  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