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

Thanks once again Lat9 !!

Hi, I believe there is an issue with DbIo after upgrading from ZC 1.5.6c to 1.5.7. It has been a few days since I upgraded, but the first time trying this since the upgrade. Note, no issues with DbIo on 1.5.6c.

Anyone else having issues with DbIo after upgrading to 1.5.7?

Details:
ZC 1.5.7
PHP Version: 7.3.19 (Zend: 3.3.19)
DbIo Manager v1.6.2 (2020-06-07)

When executing, DbIo simply brings up the drop down to choose the handler, then shows the filters for the chosen handler. Nothing more shows up after the filter section. I would expect to see all the previous files as well as the option to import a file on the right.

Can anyone else check this is the case, or have I stuffed something else up during the upgrade? Apologies as I initially posted this to the Upgrading 1.5.x thread and it is likely more relevant here.

Thanks

Ah yes, apparently Zen Cart 1.5.7 has done away with the admin-side *language *class and, instead of simply loading the storefront version, does nothing. That DbIo issue is due to that missing class.

I've just submitted DbIo v1.6.3 to the plugin moderators for review; I'll post back here when it's available for download.

 This release contains changes associated with the following GitHub issues:

#171: ProductsAttribsRaw: MySQL error on attribute creation
#172: Correct partial whitescreen on zc157 stores (interoperation).

Hey Lat9

I wanted to change categories on products so I downloaded the product file , deleted the products and re-imported them . That worked well but now the first Product image is broken . I am using IH5 so I have 4 images of the product. First link is broken but the other 3 images are present. I have checked the DB and it looks correct . All 4 images are present on the website.

Any idea what I am missing ?

Thanks in advance!

Hey, Hasher! What's that first-image (the one that's broken) named?

Hey Lat9

I use this naming convention.
Product Model = A2067

Image Names
/images/products/A2067/A2067.jpg
/images/products/A2067/A2067_1.jpg
/images/products/A2067/A2067_2.jpg
/images/products/A2067/A2067_3.jpg

Hope this helps !

lat9:

I've just submitted DbIo v1.6.3 to the plugin moderators for review; I'll post back here when it's available for download.

 This release contains changes associated with the following GitHub issues:

#171: ProductsAttribsRaw: MySQL error on attribute creation
#172: Correct partial whitescreen on zc157 stores (interoperation).
... now available: https://www.zen-cart.com/downloads.php?do=file&id=2091

Hasher:

Hey Lat9

I use this naming convention.
Product Model = A2067

Image Names
/images/products/A2067/A2067.jpg
/images/products/A2067/A2067_1.jpg
/images/products/A2067/A2067_2.jpg
/images/products/A2067/A2067_3.jpg

Hope this helps !
PM sent.

lat9:

... now available: https://www.zen-cart.com/downloads.php?do=file&id=2091

Confirmed this has corrected both issues.

Thank you Lat9!

gohealth:

Confirmed this has corrected both issues.

Thank you Lat9!
... and thanks to you for the confirmation!

Have I missed something? I've been through the docs and worked through this thread, but cannot find how to **import **metatag data?

What is the correct Mapping to get these old EasyPopulate fields into Zen Cart via DBIO:

v_metatags_title_1
v_metatags_keywords_1
v_metatags_description_1

I can export the existing metatags but couldn't see how to import

Thanks in advance

There's a built-in *customized *Products export that will export the current products and their metatags for review/update.

Thanks for the quick reply and yes ... but that only includes the product id, model and the various metatag statuses - not the content of the title, keywords and description fields that are stored in the metatags tables. Do we need to customise further?

Ryk:

Thanks for the quick reply and yes ... but that only includes the product id, model and the various metatag statuses - not the content of the title, keywords and description fields that are stored in the metatags tables. Do we need to customise further?
What version of DbIo is in use? I'll note that versions prior to v1.6.1 had issues with the products' metatags.

If you're running v1.6.1 or later, you can simply adjust that metatags customized output to include the fields from the meta_tags_products_description table.

Thanks Cindy. The client has v155....I'll recommend he upgrades.

Yep, DbIo's current version is v1.6.3.

Regarding product categories

Previously

https://www.zen-cart.com/showthread.php?220569-Database-I-O-Manager-%28DbIo%29-Plugin-Support-Thread&p=1336509#post1336509

If you're asking how to create "linked products" ... you simply have a ***Products ***import that duplicates the product's definition, once for each *linked *category. The final record for the product will contain the category "path" to the product's master-category.

So the field

is always additive?

If a product already has multiple links and I want to delete those links so only the master category remains in p2c table...?
Is there a way with an import, or I should just use sql?

I would have thought a product should have a column for the master category and another column for additional categories (containing multiple categories) which would replace any already defined...so if empty, remove those defined...?

torvista:

Regarding product categories

Previously

https://www.zen-cart.com/showthread.php?220569-Database-I-O-Manager-%28DbIo%29-Plugin-Support-Thread&p=1336509#post1336509

So the field

v_categories_name |

is always additive?

If a product already has multiple links and I want to delete those links so only the master category remains in p2c table...?
Is there a way with an import, or I should just use sql?

I would have thought a product should have a column for the master category and another column for additional categories (containing multiple categories) which would replace any already defined...so if empty, remove those defined...?
@torvista, I'll revisit the products/categories options for a Products import ... as tracked via this GitHub issue: https://github.com/lat9/dbio/issues/178

lat9:

@torvista, I'll revisit the products/categories options for a Products import ... as tracked via this GitHub issue: https://github.com/lat9/dbio/issues/178
There's an update now available for pre-release testing of v1.6.4 on the DbIo GitHub repository. That release will contain corrections for a couple of issues as well as a change to address this request.

Starting with v1.6.4, the Products import supports an UNLINK 'v_dbio_command' that works in conjunction with the 'v_categories_name' field. Just include the product's ID (or unique products_model), the categories-name 'chain' and the **UNLINK **command. If the product and category both exist and the category isn't the product's master_categories_id, that unlink operation will succeed.