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

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,:blush:

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?

Quote:

---

Originally Posted by 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,:blush:

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

Quote:

---

Originally Posted by answer=42

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.

Quote:

---

Originally Posted by lat9

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

---

I have the setting changed now:blush: Thank you!

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

Quote:

---

Originally Posted by 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

---

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.

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

Quote:

---

Originally Posted by 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

---

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

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.

Quote:

---

Originally Posted by 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