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

[answer=42]

I just downloaded Database I/O Manager. I installed it on a fresh copy of ZC with the sample products.

I exported a test CSV file with the “products” handler and then imported it to an Excel file (easier to read).

I’m sure that this is a really stupid question but I still need to ask,

1) When creating the Excel file to convert to CSV when adding products, I use the exact headings like v_products_id, v_products_type, etc,etc?

2) In the “v_categories_name” all I have to do is use the “^” symbol to separate from sub-categories like
Main-cat^sub-cat1 or Main-cat^sub-cat1 ^sub-cat2?

3)Does this process have to be repeated for adding attributes(provided they already exist) using a different handler/separate CSV file?

[answer=42]

I just downloaded Database I/O Manager. I installed it on a fresh copy of ZC with the sample products.

I exported a test CSV file with the “products” handler and then imported it to an Excel file (easier to read).

I’m sure that this is a really stupid question but I still need to ask,

1) When creating the Excel file to convert to CSV when adding products, I use the exact headings like v_products_id, v_products_type, etc,etc?

2) In the “v_categories_name” all I have to do is use the “^” symbol to separate from sub-categories like
Main-cat^sub-cat1 or Main-cat^sub-cat1 ^sub-cat2?

3)Does this process have to be repeated for adding attributes(provided they already exist) using a different handler/separate CSV file?

Yes, it was a dumb question!

The program worked like a charm adding multiple products, once I figured out that the categories needed to be added to the store prior

to the file installation. The log files were a lifesaver.

Thank You Lat9

[lat9]

Yes, it was a dumb question!

The program worked like a charm adding multiple products, once I figured out that the categories needed to be added to the store prior

to the file installation. The log files were a lifesaver.

Thank You Lat9

Did you change Configuration->DbIo Manager Settings->Products: Auto-Create Categories on Import? The default's No.

[answer=42]

Did you change Configuration->DbIo Manager Settings->Products: Auto-Create Categories on Import? The default's No.

I have the setting changed now Thank you!

[GregWhite]

Hi,

Complete Zen Cart newbie here, using v1.5.1

Had to take over a ZC installation from an IT guy that died.

Trying to install Dblo.

The installation instructions seem to say that I can install from the Admin panel, i.e. ******.com/build. If so, I haven't been able to find where to do this.

Any help or correct info would be appreciated.

Greg

[lat9]

Hi,

Complete Zen Cart newbie here, using v1.5.1

Had to take over a ZC installation from an IT guy that died.

Trying to install Dblo.

The installation instructions seem to say that I can install from the Admin panel, i.e. ******.com/build. If so, I haven't been able to find where to do this.

Any help or correct info would be appreciated.

Greg

There are two steps to the DbIo installation:

1. Copying the files from the plugin's unzipped distribution to your site's /admin directory (which you'd do via FTP, preferably, or your site's cPanel File Manager).
2. Accessing your Zen Cart admin-panel, which then causes the uploaded code to add configuration values to your store's database.

Once it's installed and configured, it's ready to use.

[cloughc]

Vinos de Fruitas Tropicales web site says that the current version of dbio is 1.4.0, but the download link continues to download dbio-1.3.1.zip

[lat9]

Vinos de Fruitas Tropicales web site says that the current version of dbio is 1.4.0, but the download link continues to download dbio-1.3.1.zip

Thanks for the report; I've corrected the issue.

[lat9]

I've just submitted v1.4.1 of the DbIo to the Zen Cart plugins for review. This release includes changes associated with the following GitHub issues:

#110: Load jQuery if the Zen Cart version is less than 1.5.5a.
#111: Correct customized exports returning "too much information".
#112: Enable an export to return multiple .csv records for a database record.
#114: Enable nullable fields to be set to "NULL".
#115: Provide fall-back for hosted sites that don't include 'php-mbstring'.

I'll post back here once the update has been approved.

[lat9]

I've just submitted v1.4.1 of the DbIo to the Zen Cart plugins for review. This release includes changes associated with the following GitHub issues:

#110: Load jQuery if the Zen Cart version is less than 1.5.5a.
#111: Correct customized exports returning "too much information".
#112: Enable an export to return multiple .csv records for a database record.
#114: Enable nullable fields to be set to "NULL".
#115: Provide fall-back for hosted sites that don't include 'php-mbstring'.

I'll post back here once the update has been approved.

v1.4.1 is now available for download from the Zen Cart plugins: https://www.zen-cart.com/downloads.php?do=file&id=2091