Database I/O Manager (DbIo) Plugin [Support Thread]
The Database I/O Manager (DbIO) enables you to input (or import) and output (or export) information to and from your database using a .csv file as the "transport method".
It seems like I spent a significant portion of time this year providing clients with "import/export" scripts and DbIo is the culmination of my effort to create an extendable I/O script. Yes, there are other I/O scripts (like EZ-Populate and Apsona) but I wanted a script that holds to these principles:
- Use Zen Cart's built-in processing, especially the database interfaces.
- Use a class-based approach, enabling a higher degree of code reuse.
- Let the database drive the data; use the database settings to guide "proper" input processing.
- Keep the data-pool consistent; broadly define the character-encoding of the .CSV repositories.
- Keep to, where possible, the EP-4 interface described in its wiki.
- Multi-language awareness.
- Be data-driven. If you've installed a plugin that simply adds a field to an existing table (like products or orders), that field is a candidate for any I/O operation on that database table without additional coding.
Like any process that changes information in your database: Make a backup of your database prior to performing a "full-import" (which actually changes your database)!
Check out the readme for operational details, but my goal is to make the on-screen instructions "good enough" for most users.
I'll post the plugin's download link once I receive it.
Re: Database I/O Manager (DbIo) Plugin [Support Thread]
Re: Database I/O Manager (DbIo) Plugin [Support Thread]
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?
Re: Database I/O Manager (DbIo) Plugin [Support Thread]
Quote:
Originally Posted by
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?
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).
Re: Database I/O Manager (DbIo) Plugin [Support Thread]
Re: Database I/O Manager (DbIo) Plugin [Support Thread]
Quote:
Originally Posted by
Zean
You've got three (3) requests in that post:
- 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?
- 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.
- 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.
Re: Database I/O Manager (DbIo) Plugin [Support Thread]
Quote:
Originally Posted by
lat9
v1.0.0 is now available for download.
Re: Database I/O Manager (DbIo) Plugin [Support Thread]
Not sure which way to go to correct my issue. I have this error when I navigate to the plug in.
Quote:
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?
Re: Database I/O Manager (DbIo) Plugin [Support Thread]
Quote:
Originally Posted by
GearStudios
Not sure which way to go to correct my issue. I have this error when I navigate to the plug in.
Quote:
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
Code:
define ('DB_CHARSET', 'utf8');
instead of
Code:
define ('DB_CHARSET', 'utf-8');
There's no intervening minus-sign (-) in that definition.
Re: Database I/O Manager (DbIo) Plugin [Support Thread]
That's awesome! Fixed the issue! Thank you! +10