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

[lat9]

@HeathenMagic, I don't understand why no log was generated for that error. That said, you could try enabling the DbIo debug, rerunning that OrdersProducts report and then sending me (it'll be a big file) the resultant log (it'll be the newest file with a name similar to /YOUR_ADMIN/dbio/logs/dbio-OrdersProducts-*.log).

Slight update: The OrdersProducts report was being run with filters on the "Orders ID" and, unfortunately, that resulted in the error:

PHP Fatal error:  1052:Column 'orders_id' in where clause is ambiguous

The correction is to properly "alias" that orders_id field. Along the way, I also found that the OrdersProducts report wasn't passing its output information through the encoding process (so that non-ASCII characters could get "mangled" in the output file), so that's been corrected as well.

I've got the update staged for DbIo's next version (most likely in early January): https://raw.githubusercontent.com/la...ctsHandler.php

[lat9]

Slight update: The OrdersProducts report was being run with filters on the "Orders ID" and, unfortunately, that resulted in the error:

PHP Fatal error:  1052:Column 'orders_id' in where clause is ambiguous

The correction is to properly "alias" that orders_id field. Along the way, I also found that the OrdersProducts report wasn't passing its output information through the encoding process (so that non-ASCII characters could get "mangled" in the output file), so that's been corrected as well.

I've got the update staged for DbIo's next version (most likely in early January): https://raw.githubusercontent.com/la...ctsHandler.php

I've just submitted v1.1.1 of the DbIo to the Zen Cart plugins for review; I'll post back when it's available.

[lat9]

I've just submitted v1.1.1 of the DbIo to the Zen Cart plugins for review; I'll post back when it's available.

It's now available for download.

[lat9]

I've just submitted v1.2.0 of the DbIo to the plugins' area and will post back here when it's available for download.

This version contains a major restructuring of the Tools->Database I/O Manager layout to reduce clutter and make currently-selected handler the "focus" of all actions. It also includes a new concept: export customization. The export-customization, currently available for the Orders and Products handlers, allows you to select only the fields that you "want to see" and the order in which those fields are exported.

The following changes are included, identified by their GitHub repository issue number:

#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

[lat9]

v1.2.0 is now available for download from the Zen Cart plugins.

[lat9]

I've just submitted v1.2.1 to the plugins for review. 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

[lat9]

The update is now available for download.