Database I/O Manager (DbIo)

Description
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).
+ Download Latest

Forum Support Thread

Submit An Updated Version


Github Repository
Zen Cart® Versions v1.3.9, v1.5.0, v1.5.1, v1.5.2, v1.5.3, v1.5.4, v1.5.5, v1.5.6
Original Author lat9
Last Updated by lat9 - 22 Sep 2019
Downloads 1,474

Version History

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.
  + Download
Zen Cart® Versions v1.3.9, v1.5.0, v1.5.1, v1.5.2, v1.5.3, v1.5.4, v1.5.5, v1.5.6
Date Added 22 Sep 2019
Author lat9
File Size 531.5 KB
PHP 5.3 Safe? No
Downloads 23
 
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.
  + Download
Zen Cart® Versions v1.3.9, v1.5.0, v1.5.1, v1.5.2, v1.5.3, v1.5.4, v1.5.5, v1.5.6
Date Added 10 Aug 2019
Author lat9
File Size 531.0 KB
PHP 5.3 Safe? No
Downloads 54
 
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.
  + Download
Zen Cart® Versions v1.3.9, v1.5.0, v1.5.1, v1.5.2, v1.5.3, v1.5.4, v1.5.5, v1.5.6
Date Added 24 Jul 2019
Author lat9
File Size 530.8 KB
PHP 5.3 Safe? No
Downloads 19
 
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.
  + Download
Zen Cart® Versions v1.3.9, v1.5.0, v1.5.1, v1.5.2, v1.5.3, v1.5.4, v1.5.5, v1.5.6
Date Added 30 Apr 2019
Author lat9
File Size 530.3 KB
PHP 5.3 Safe? No
Downloads 91
 
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.
  + Download
Zen Cart® Versions v1.3.9, v1.5.0, v1.5.1, v1.5.2, v1.5.3, v1.5.4, v1.5.5, v1.5.6
Date Added 22 Apr 2019
Author lat9
File Size 528.2 KB
PHP 5.3 Safe? No
Downloads 20
 
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.
  + Download
Zen Cart® Versions v1.3.9, v1.5.0, v1.5.1, v1.5.2, v1.5.3, v1.5.4, v1.5.5, v1.5.6
Date Added 5 Mar 2019
Author lat9
File Size 528.1 KB
PHP 5.3 Safe? No
Downloads 74
 
Database I/O Manager (DbIo)   -   Version: 1.5.1
This version corrects the GitHub issue #123 ("Products" export can't be imported).   + Download
Zen Cart® Versions v1.3.9, v1.5.0, v1.5.1, v1.5.2, v1.5.3, v1.5.4, v1.5.5
Date Added 13 Sep 2018
Author lat9
File Size 528.0 KB
PHP 5.3 Safe? No
Downloads 121
 
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'.
  + Download
Zen Cart® Versions v1.3.9, v1.5.0, v1.5.1, v1.5.2, v1.5.3, v1.5.4, v1.5.5
Date Added 21 Jul 2018
Author lat9
File Size 527.7 KB
PHP 5.3 Safe? No
Downloads 54
 
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'.
  + Download
Zen Cart® Versions v1.3.9, v1.5.0, v1.5.1, v1.5.2, v1.5.3, v1.5.4, v1.5.5
Date Added 5 Apr 2018
Author lat9
File Size 522.9 KB
PHP 5.3 Safe? No
Downloads 115
 
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.   + Download
Zen Cart® Versions v1.3.9, v1.5.0, v1.5.1, v1.5.2, v1.5.3, v1.5.4, v1.5.5
Date Added 28 Nov 2017
Author lat9
File Size 520.8 KB
PHP 5.3 Safe? No
Downloads 143
 
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.
  + Download
Zen Cart® Versions v1.3.9, v1.5.0, v1.5.1, v1.5.2, v1.5.3, v1.5.4, v1.5.5
Date Added 4 Oct 2017
Author lat9
File Size 520.5 KB
PHP 5.3 Safe? No
Downloads 79
 
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
  + Download
Zen Cart® Versions v1.3.9, v1.5.0, v1.5.1, v1.5.2, v1.5.3, v1.5.4, v1.5.5
Date Added 25 Apr 2017
Author lat9
File Size 519.5 KB
PHP 5.3 Safe? Yes
Downloads 152
 
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
  + Download
Zen Cart® Versions v1.3.9, v1.5.0, v1.5.1, v1.5.2, v1.5.3, v1.5.4, v1.5.5
Date Added 1 Mar 2017
Author lat9
File Size 517.9 KB
PHP 5.3 Safe? Yes
Downloads 111
 
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
  + Download
Zen Cart® Versions v1.3.9, v1.5.0, v1.5.1, v1.5.2, v1.5.3, v1.5.4, v1.5.5
Date Added 6 Feb 2017
Author lat9
File Size 517.5 KB
PHP 5.3 Safe? Yes
Downloads 59
 
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.
  + Download
Zen Cart® Versions v1.3.9, v1.5.0, v1.5.1, v1.5.2, v1.5.3, v1.5.4, v1.5.5
Date Added 4 Jan 2017
Author lat9
File Size 465.3 KB
PHP 5.3 Safe? Yes
Downloads 70
 
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.
  + Download
Zen Cart® Versions v1.3.9, v1.5.0, v1.5.1, v1.5.2, v1.5.3, v1.5.4, v1.5.5
Date Added 19 Dec 2016
Author lat9
File Size 465.2 KB
PHP 5.3 Safe? Yes
Downloads 56
 
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.
  + Download
Zen Cart® Versions v1.3.9, v1.5.0, v1.5.1, v1.5.2, v1.5.3, v1.5.4, v1.5.5
Date Added 24 Oct 2016
Author lat9
File Size 460.5 KB
PHP 5.3 Safe? Yes
Downloads 74
 
Database I/O Manager (DbIo)   -   Version: v1.0.0
  + Download
Zen Cart® Versions v1.3.9, v1.5.0, v1.5.1, v1.5.2, v1.5.3, v1.5.4, v1.5.5
Date Added 1 Jul 2016
Author lat9
File Size 447.0 KB
PHP 5.3 Safe? Yes
Downloads 159
 


disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR