Database I/O Manager (DbIo)
|
The Database I/O Manager (DbIo) provides an interface for your Zen Cart admin to import and export information from your database, using .CSV files as the interface. Its processing - Uses the built-in Zen Cart methods to access your database - Is multi-language aware - Validates the character-encoding used in the database <-> CSV-file transfers - Is redesigned from the ground-up, using a class-hierarchy to define its I/O handlers (which enables a higher degree of code reuse). |
 Zen Cart® Versions |
v1.5.7, v1.5.8, v2.0.0, v2.1.0 |
 Original Author |
lat9 |
| Last Updated by |
lat9 - 23 Apr 2025 |
 Downloads |
4,357 |
Version History
| Database I/O Manager (DbIo) - Version: v2.0.2 | |||||||||||||
|
This release contains changes associated with these GitHub issues: #221: E_USER_ERROR is deprecated in PHP 8.4. #222: Can't remove a DbIo template, once created. #223: Remove zc1.3.x-era boxes file and subdirectory. #224: Initialize inserted categories' sort-order to 0 (was null). #225: Correct DbIoOptionsValuesHandler, was creating uneditable option-values. #226: Pre-define all class properties in the DbIoHandler class. #238: Remove unwanted centered-text styling from the customization tool. #239: Add links to the GitHub wiki in the main admin tools' instructions. |
|||||||||||||
|
|||||||||||||
| Database I/O Manager (DbIo) - Version: v2.0.1 | |||||||||||||
|
This release contains changes associated with the following GitHub issues: #212: Correct sprintf messages for split-file message. #215: Use different names for different forms, correcting HTML validation issue. #217: Correct PHP error when exporting via the DbIoProductsAttribsBasicHandler. #218: Correct DbIoProductsAttribsBasicHandler import processing. |
|||||||||||||
|
|||||||||||||
| Database I/O Manager (DbIo) - Version: v2.0.0 | |||||||||||||
|
NOTE: This release drops support support for Zen Cart versions prior to 1.5.7! This release contains for the following GitHub issues: #209: DbIo manager, checkboxes can't be selected via labels #207: Product Export: debug for empty trim on metatags #206: Remove duplicate language constants for dbio_customize tool #205: Unable to resize select windows in Safari #203: PHP notice/warning when there's an error or it's not "ok to proceed" #202: Drop support for Zen Cart versions prior to zc157 #201: PHP 8.2: explicitly declaring variables #199: Use zen_cfg_read_only for the DbIo version 'setting' #198: PHP 8.16: PHP deprecated, auto_detect_line_endings is deprecated #197: Add shipping cost value to DbIoOrders output |
|||||||||||||
|
|||||||||||||
| Database I/O Manager (DbIo) - Version: v1.6.7 | |||||||||||||
|
This release contains changes associated with the following GitHub issues: #189: ProductsHandler, select all sub-categories when a higher-level category is selected for export. #190: Correct initial installation error for databases using a utf8mb4 collation. #191: Correct PHP warning for product-addition and specified category is non-existant. #192: Adding longtext as a possible text-type field. #194: Updating language files to use HTML5 <br>'s #195: Correctly disallow Products' import of duplicate models if disallowed via configuration. #196: Disallow Products' import if an empty category/sub-category is specified. |
|||||||||||||
|
|||||||||||||
| Database I/O Manager (DbIo) - Version: v1.6.6 | |||||||||||||
|
This release contains changes associated with the following GitHub issues: #184: PHP 8.1+ preparation. #185: Correcting PHP Fatal error (Uncaught ArgumentCountError) for DbIoProductsHandler. #186: Add 'v_products_link' (storefront link) to the DbIoProductsHandler. |
|||||||||||||
|
|||||||||||||
| Database I/O Manager (DbIo) - Version: v1.6.5 | |||||||||||||
|
This release contains changes associated with the following GitHub issues: #182: Properly handle 'enum' type database fields on import. #183: Correctly handle 'nullable' fields on import. |
|||||||||||||
|
|||||||||||||
| Database I/O Manager (DbIo) - Version: v1.6.4 | |||||||||||||
|
This release contains changes associated with the following GitHub issues: #175: Correct CSV 'split' function processing. #176: 'Products': Multi-lingual customized-template export columns can 'go off'. #177: No admin message when multiple `v_dbio_command` columns are found. #178: 'Products' import, enable a product to be 'unlinked' from a linked category. #179: Valid dates that don't start with a year are being indicated as invalid. #180: Additional configuration setting for `Products` to require an 'ADD' command to insert a new product. #181: ProductsAttribsRaw: Unwanted download record added for empty download name. |
|||||||||||||
|
|||||||||||||
| Database I/O Manager (DbIo) - Version: v1.6.3 | |||||||||||||
|
This release contains changes associated with the following GitHub issues: #171: ProductsAttribsRaw: MySQL error on attribute creation #172: Correct partial whitescreen on zc157 stores (interoperation). |
|||||||||||||
|
|||||||||||||
| Database I/O Manager (DbIo) - Version: v1.6.2 | |||||||||||||
|
This release contains changes associated with the following GitHub issues: #164: Correct duplicate records generated by the Products handler on multi-lingual stores. #166: ProductsAttribsRaw: Correct MySQL error on 'Import (check)' adding new download. #167: ProductsAttribsBasic: Correct MySQL error. #169: Correct PHP 7.4 deprecated use of curly brackets for array functions. |
|||||||||||||
|
|||||||||||||
| Database I/O Manager (DbIo) - Version: v1.6.1 | |||||||||||||
|
This release contains changes associated with the following GitHub issues: #161: Hide import "Check Report" pop-up title. #162: Correct MySQL error on initial install, introduced in v1.6.0. #137: Add a handler to import/export product specials (SpecialsHandler). #144: Products/Orders: Correctly export customized templates, maintaining fields' positions. #149: Give an option to automatically download an export, after the file's created. #150: Correct PHP notice on copying template for multi-lingual stores when a language-record is missing. #151: Products: Correct export/import of product-related meta-tag values. #152: ProductsAttribsRaw: Ensure that download max-count and max-days are set to numeric values. #153: Manufacturers: Correct multi-lingual stores' export, was only in the default language. #154: Enhance some of the handlers' on-screen instructions. #155: Correct PHP notice when an export has no fields to be exported. #156: Products: Ensure sufficient information supplied for a to-be-added product. #157: Install/upgrade, numeric database fields' defaults changed to be numeric. #158: StatsHandler, truncate (i.e. empty) dbio_stats table on export. |
|||||||||||||
|
|||||||||||||
| Database I/O Manager (DbIo) - Version: 1.5.7a | |||||||||||||
|
This release contains changes associated with the following GitHub issues: #136: ProductsAttribsRaw: Include manufacturer's name in the export. #147: Enable resizing of multi-select dropdowns. #148: ProductsAttribsRaw: Correct MySQL error when adding a download attribute. ... and properly updates the plugin's version and release date. |
|||||||||||||
|
|||||||||||||
| Database I/O Manager (DbIo) - Version: v1.5.6 | |||||||||||||
|
This release contains changes associated with the following GitHub issues: #142: Correct split when fields contain embedded spaces. #143: Correct PHP notice when imported CSV contains blank lines. #141: Add select/unselect all for file delete operation. |
|||||||||||||
|
|||||||||||||
| Database I/O Manager (DbIo) - Version: v1.5.5 | |||||||||||||
|
This release contains changes associated with the following GitHub issues: #138: Double record-header included in first chunk of a split file. #139: Don't record generated SQL when performing a full import (for performance). #140: Disregard empty records during CSV import operations. |
|||||||||||||
|
|||||||||||||
| Database I/O Manager (DbIo) - Version: v1.5.4 | |||||||||||||
|
This release contains the changes associated with the following GitHub issues: #122: Update ProductsAttribsRaw to support a "REMOVE" command. #131: ProductsOptions/ProductsOptionsValues: Insert error. #132: Correct various PHP "Notice" issues. #133: ProductsAttribsRaw throws error for strict MySQL installations. #134: ProductsDiscountQuantity throws error for strict MySQL installations. |
|||||||||||||
|
|||||||||||||
| Database I/O Manager (DbIo) - Version: v1.5.3 | |||||||||||||
|
This release contains corrections for the following GitHub issues: #127: Auto-create categories error on more recent/strict versions of MySQL. #128: Fatal error adding a product #129: Incorrect detection of invalid integer fields. #130: Unwanted PHP Notice when creating a product. |
|||||||||||||
|
|||||||||||||
| Database I/O Manager (DbIo) - Version: v1.5.2 | |||||||||||||
|
This release contains changes associated with the following GitHub issues: #124: Recognize utf8mb4 DB_CHARSET as a valid match to a CHARSET of utf-8 (needed for Zen Cart 1.5.6) #125: Recognize a field-type of `double`. #126: Accept negative integer values. |
|||||||||||||
|
|||||||||||||
| Database I/O Manager (DbIo) - Version: 1.5.1 | |||||||||||||
| This version corrects the GitHub issue #123 ("Products" export can't be imported). | |||||||||||||
|
|||||||||||||
| Database I/O Manager (DbIo) - Version: v1.5.0 | |||||||||||||
|
This release contains changes associated with the following GitHub issues: #117: Correct multi-language customized "Products" export field-ordering. #118: Add customers' default address information to the "Customers" export. #119: Add a handler to import/export the "Products Discount Quantity" information. #120: Correct exports for handlers that support a 'dbio_command'. |
|||||||||||||
|
|||||||||||||
| Database I/O Manager (DbIo) - Version: v1.4.1 | |||||||||||||
|
This release includes changes associated with the following GitHub issues: #110: Load jQuery if the Zen Cart version is less than 1.5.5a. #111: Correct customized exports returning "too much information". #112: Enable an export to return multiple .csv records for a database record. #114: Enable nullable fields to be set to "NULL". #115: Provide fall-back for hosted sites that don't include 'php-mbstring'. |
|||||||||||||
|
|||||||||||||
| Database I/O Manager (DbIo) - Version: v1.4.0 | |||||||||||||
| This version updates the "Products" handler, enabling an import to force a product to be added to the database ... even if the product's model number is already present. | |||||||||||||
|
|||||||||||||
| Database I/O Manager (DbIo) - Version: v1.3.1 | |||||||||||||
|
This version contains the corrections for the following issues, identified by their GitHub issue number: #103: Ensure writability of DbIo output directories #105: (Products) Duplicate records on initial import result in debug log. #106: (Products/Orders) Customized export can result in incorrect field values. #107: (Products) Import/update doesn't update master-categories id. #108: Initialization error on export doesn't display reason to admin. |
|||||||||||||
|
|||||||||||||
| Database I/O Manager (DbIo) - Version: v1.3.0 | |||||||||||||
|
This version includes changes for the following issues (identified by their GitHub issue number): #94: Enable a handler to totally control an import #98: Add (optional) category-creation during a "Products" import #99: Correct the plugin's initialization for "early adopters". #100: Manage date_added/last_modified fields during a "Products" import #102: Display all DbIo option settings on the Database I/O Manager page |
|||||||||||||
|
|||||||||||||
| Database I/O Manager (DbIo) - Version: v1.2.1 | |||||||||||||
|
This version contains the changes associated with the following issues (identified by their GitHub issue number): #91: Back-ticks required around database field names. #92: Enable special handling for handlers with fixed-field headers. #93: Check for the php-mbstring extension; message if not installed. Once approved, you can download the update here: https://www.zen-cart.com/downloads.php?do=file&id=2091 |
|||||||||||||
|
|||||||||||||
| Database I/O Manager (DbIo) - Version: v1.2.0 | |||||||||||||
|
This version reflects a major restructuring of the Tools->Database I/O Manager tool and introduces the concept of export templates, allowing exports to be customized. The following changes are included: #59: Enable custom exports #76: Restructure Database I/O Manager layout #83: Maintain last-selected file's location #84: Don't automatically render a handler's filters (performance) #85: Enable download or removal of DbIo-generated logs #86: Add a handler to support manufacturers' import/export #87: Ensure that character fields' defined length is enforced #88: Use a text-link instead of an icon to identify that import results are available #89: Reduce "nuisance" DbIo logs |
|||||||||||||
|
|||||||||||||
| Database I/O Manager (DbIo) - Version: v1.1.1 | |||||||||||||
|
This release corrects a couple of issues with the _DbIoOrdersProductsHandler_ processing, see the plugin's GitHub repository for details: #80: Record-count not updated; data needs encoding. #79: Database error on order's filtering. |
|||||||||||||
|
|||||||||||||
| Database I/O Manager (DbIo) - Version: v1.1.0 | |||||||||||||
|
This version of DbIo adds the capability to REMOVE a product's database record and to use either the product's ID or its model-number as a "key" on import. Changes for the following issues (identified by GitHub issue numbers) are included: #7: Enable handlers to support "commands" (like REMOVE); the "Products" import now recognizes the REMOVE command. #70: Fixed-header import misses "special import" fields. #71: An incomplete import record was not being flagged. #72: Don't post-process imports that have previously failed. #73: Enable a handler to specify an alternate key; supports the "Products" import to key to either the product's ID or model-number. #74: Enable a handler to specify a minimum base-class version. #75: Don't gather export filters until needed; a performance enhancement for store's with a large number of categories and/or manufacturers. #78: Correct PHP Notice issues. |
|||||||||||||
|
|||||||||||||
| Database I/O Manager (DbIo) - Version: v1.0.1 | |||||||||||||
|
This version provides the following updates (identified by their GitHub issue number): #69: Enable a handler to perform some post-processing for the record-set just imported. #63: Clarify some of the handlers' instructions. #68: Missing function importGetFieldValue. #67: Unwanted HTML included in CSV-download in some configurations. #60: Missing "Customers" handler's language file. #62: Only default language exported by "Products" handler on multi-lingual stores. #64: v_categories_name field not properly encoded by the "Products" export. #65: Empty dates should be allowed when a date/datetime field is nullable. #53: Allow a handler to be conditionally enabled. |
|||||||||||||
|
|||||||||||||
| Database I/O Manager (DbIo) - Version: v1.0.0 | |||||||||||||
|
|||||||||||||
Date Added
File Size
Encapsulated?
