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

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.

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

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

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

The update is now available for download.

I guess I've just missed the "Install Instructions" link and or txt file.
There IS a "README.MD" but I'm not sure how to open that or What program to use to open the ".MD" readme file.

help?

Within the zip-file, there's a /docs/dbio directory that has a readme.html ... that's what you're looking for!

You've positioned this as a better option to easy populate. I've installed this as part of an upgrade of a clients site because of that. One feature of easy populate that appears to be missing is the ability to add products. Did I miss this? I see the REMOVE function. Is this only planned to update existing products?

Oh and I really like the templates and the ability to create new ones. A suggestion is to add v_dbio_command to the pull down so it can be added to a template

badarac:

You've positioned this as a better option to easy populate. I've installed this as part of an upgrade of a clients site because of that. One feature of easy populate that appears to be missing is the ability to add products. Did I miss this? I see the REMOVE function. Is this only planned to update existing products?

Huh? Not sure which version of EP to which you are referring, but if there is a version of EP that doesn't support adding a product, then it is definitely defunct. EP4 does this by providing a new line of data that has a new primary key (default is products_model, but also has the ability to not identify a products_model or use a duplicate products_model and instead use the products_id or whatever is decided to be the primary key).

mc12345678:

Huh? Not sure which version of EP to which you are referring, but if there is a version of EP that doesn't support adding a product, then it is definitely defunct. EP4 does this by providing a new line of data that has a new primary key (default is products_model, but also has the ability to not identify a products_model or use a duplicate products_model and instead use the products_id or whatever is decided to be the primary key).

You misunderstood. What I'm saying is that this function is IN EP but not DBIO. I'm asking if that was intentionally left out, if I missed the function in DBIO that's already there, or if it's planned and not yet implemented.

@badarac, there's a ***Products ***handler that enables you to import/export any fields present in the products/products_descriptions tables.

badarac:

Oh and I really like the templates and the ability to create new ones. A suggestion is to add v_dbio_command to the pull down so it can be added to a template
Good suggestion; let me see what's up with that.

lat9:

@badarac, there's a ***Products ***handler that enables you to import/export any fields present in the products/products_descriptions tables.

The way it seems to work though is it needs an existing product id and/or model. That would seem to indicate that it can only update information for existing products. Am I wrong?

If the product is not found (by id or model), it's added during any import processing. You just need a unique model number to identify the product.

lat9:

If the product is not found (by id or model), it's added during any import processing. You just need a unique model number to identify the product.

I exported the products, deleted all but one row (and the headers), deleted the product id, and made a unique model number. When I import the csv file with the single record it gives an error [*] products.products_id, line #2: Value () is not an integer. Is there a unique integer value that must be entered in the products_id column? Bug?

Installed on 1.5.5e btw. Site is installed in a subdirectory for testing so I can make changes without harming anything if you want me to test a change.

badarac:

You misunderstood. What I'm saying is that this function is IN EP but not DBIO. I'm asking if that was intentionally left out, if I missed the function in DBIO that's already there, or if it's planned and not yet implemented.
Yes, I did misread the statement placing the wrong emPHAsis on something missing from EP instead of something in EP considered missing from DbIO as a variant of EP.

badarac:

Installed on 1.5.5e btw. Site is installed in a subdirectory for testing so I can make changes without harming anything if you want me to test a change.

My guess would be that the products_id column would need to be removed to support adding such a new product or a value of 0 maybe. Otherwise it identifies that there is nothing present as reported.

mc12345678:

My guess would be that the products_id column would need to be removed to support adding such a new product or a value of 0 maybe. Otherwise it identifies that there is nothing present as reported.
One of those was a good guess!:D

To insert a product via import, you'll need to have both the v_products_id and v_products_model fields present in the to-be-imported CSV. Set the products_id value to 0 (not blank) and the products_model to the new product's unique model number.