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

[lat9]

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

[lankeeyankee]

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?

[lat9]

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).

[Zean]

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

[lat9]

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.

[lat9]

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.

[GearStudios]

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?

[lat9]

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

define ('DB_CHARSET', 'utf8');

instead of

define ('DB_CHARSET', 'utf-8');

There's no intervening minus-sign (-) in that definition.

[GearStudios]

That's awesome! Fixed the issue! Thank you! +10

[icecold]

Great plugin however when I exported my products it added the source code of my Admin page at the end! Weird ...