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

[lat9]

Yes, I set it to "yes"

PM sent.

[badarac]

PM sent.

Reply email sent

[badarac]

Creating a category named Rich, with parent_category_id 34

Amazing what a difference saying "Yes" makes

[lat9]

Creating a category named Rich, with parent_category_id 34

Amazing what a difference saying "Yes" makes

... Yes!

The issue that @badarac found was that I had the wrong value in the conditional checking to see whether (Yes) or not (elsewise) the categories are to be auto-created. Its correction has been posted to the GitHub repository but is not included in the -beta1 version.

[MrRogue]

In the DbIo exported dB header..... Where would I put "dealer Pricing"? the MSRP retail price is going into the "v_products_price" column.
Do I need to or better yet, CAN I make another column for the Dealer pricing?

I have TWO picture FOLDERS to FTP/upload to the site. (/large_/001-00122.jpg) and (/small_/001-00122.jpg)

What SHOULD I do for the two different size photos for each product...? How do I set that up ?

Thanks,
MrRogue
)

[lat9]

In the DbIo exported dB header..... Where would I put "dealer Pricing"? the MSRP retail price is going into the "v_products_price" column.
Do I need to or better yet, CAN I make another column for the Dealer pricing?

I have TWO picture FOLDERS to FTP/upload to the site. (/large_/001-00122.jpg) and (/small_/001-00122.jpg)

What SHOULD I do for the two different size photos for each product...? How do I set that up ?

Thanks,
MrRogue
)

The DbIo gives you the opportunity to import and export all database fields for a product. If you've installed the MSRP plugin, for example, any additional fields defined by that plugin will automatically be available for export (and import).

If you create a database field for the dealer pricing, you can manipulate the value using the DbIo but you'll need other code modifications to actually use that value for any display or processing.

Regarding the images, you'll need Image Handler 4 to manage the various sizing of those images. Zen Cart uses a base image name (recorded in the database) and then looks for that name in the various folders; IH4 extends that processing.

[lat9]

I've just submitted v1.3.0 to the Plugins for review, providing changes for the following issues (identified by their GitHub issue number):

#94: Enable a handler to totally control an import
#98: Add (optional) category-creation during a "Products" import
#99: Correct the plugin's initialization for "early adopters".
#100: Manage date_added/last_modified fields during a "Products" import
#102: Display all DbIo option settings on the Database I/O Manager page

I'll post back when it's available for download there.

[lat9]

I've just submitted v1.3.0 to the Plugins for review, providing changes for the following issues (identified by their GitHub issue number):

#94: Enable a handler to totally control an import
#98: Add (optional) category-creation during a "Products" import
#99: Correct the plugin's initialization for "early adopters".
#100: Manage date_added/last_modified fields during a "Products" import
#102: Display all DbIo option settings on the Database I/O Manager page

I'll post back when it's available for download there.

DbIo v1.3.0 is now available for download: https://www.zen-cart.com/downloads.php?do=file&id=2091

[frank18]

And yet another great plugin by lat9 !!

Found one little snag when testing on a local dev install (1.5.5e): I omitted to make the YOUR_ADMIN/dbio folder writable and of course my test export file was not created.

In case the YOUR_ADMIN/dbio folder is not writable then DbIo should give a warning in the admin when attempting to export to that folder, would avoid some raising of the eyebrows.

I guess that test could be done during the install process of DbIo.

[lat9]

And yet another great plugin by lat9 !!

Found one little snag when testing on a local dev install (1.5.5e): I omitted to make the YOUR_ADMIN/dbio folder writable and of course my test export file was not created.

In case the YOUR_ADMIN/dbio folder is not writable then DbIo should give a warning in the admin when attempting to export to that folder, would avoid some raising of the eyebrows.

I guess that test could be done during the install process of DbIo.

Thanks for the report, @frank18, I'll get that logged and included in the next release.