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
Zen Cart® Versions v1.3.9, v1.5.0, v1.5.1, v1.5.2, v1.5.3, v1.5.4, v1.5.5
Original Author lat9
Last Updated by lat9 - 25 Apr 2017
Downloads 496

Version History

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 117
 
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 82
 
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 32
 
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 49
 
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 31
 
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 53
 
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 132
 


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