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

[lat9]

I found a bug.

when importing products if your text has a characteristics it does not like it still will import. But when you go to export file it looks or distorted within the excel sheet.


The issue is 'product_desc' table

If you open in excel and trim / clean formula in the description it will solve the issue and everything import/export fine.

This can really mess things up if people forgot to clean there html during the import process.

Without further information, it sounds like a "Garbage in, garbage out" scenario.

That "characteristics" are you referring to and what is "it" that doesn't like them?

Are you using Microsoft Excel? If so, what is your setting for Configuration / Database I/O Manager Settings / CSV: Encoding? Note that for Microsoft Excel, that should be set to 'latin1'.

[chadlly2003]

Without further information, it sounds like a "Garbage in, garbage out" scenario.

That "characteristics" are you referring to and what is "it" that doesn't like them?

Are you using Microsoft Excel? If so, what is your setting for Configuration / Database I/O Manager Settings / CSV: Encoding? Note that for Microsoft Excel, that should be set to 'latin1'.

I had it set to utf8

change it to

latin1

thank you

[chuckrey]

Yep, as noted in our discussion above, the current implementation of the handler for the importing of options' values is quite messed up.

I should have an update (essentially a total rewrite) available within a couple of days.

Just an update in effort to have DBIo working for me.. I checked the table products_options_values_to_products_options on another site then extracted the data (the products are the same) I then went to the website where I have DBIo installed for testing purposes and imported the table (this table was empty even after I initially uploaded Option values via DBIo). After the table import via phpMyadmin the fields are displaying within admin. Is there another file within DBIo I am suppose to upload for the products_options_values_to_products_options table to be populated?

[lat9]

Just an update in effort to have DBIo working for me.. I checked the table products_options_values_to_products_options on another site then extracted the data (the products are the same) I then went to the website where I have DBIo installed for testing purposes and imported the table (this table was empty even after I initially uploaded Option values via DBIo). After the table import via phpMyadmin the fields are displaying within admin. Is there another file within DBIo I am suppose to upload for the products_options_values_to_products_options table to be populated?

Nope, it'll happen 'organically' in the correct DbIoProductsOptionsValuesHandler.

[chuckrey]

Nope, it'll happen 'organically' in the correct DbIoProductsOptionsValuesHandler.

Started fresh once again and downloaded the DBIo plugin w/ the recent changes made in GitHub and so far so good. My final update will be prices to attributes.
Just wanted to provide an update in case anyone else is having a similar issue. The latest GitHub files seemed to help resolve my issue. Thanks!

[lat9]

Started fresh once again and downloaded the DBIo plugin w/ the recent changes made in GitHub and so far so good. My final update will be prices to attributes.
Just wanted to provide an update in case anyone else is having a similar issue. The latest GitHub files seemed to help resolve my issue. Thanks!

Thanks for the update! I'll get that updated version packaged up and released.

[lat9]

v2.0.2 of the Database I/O Manager (DbIo) is now available for download: https://www.zen-cart.com/downloads.php?do=file&id=2091

This release contains changes associated with these GitHub issues:

#221: E_USER_ERROR is deprecated in PHP 8.4.
#222: Can't remove a DbIo template, once created.
#223: Remove zc1.3.x-era boxes file and subdirectory.
#224: Initialize inserted categories' sort-order to 0 (was null).
#225: Correct DbIoOptionsValuesHandler, was creating uneditable option-values.
#226: Pre-define all class properties in the DbIoHandler class.
#238: Remove unwanted centered-text styling from the customization tool.
#239: Add links to the GitHub wiki in the main admin tools' instructions.