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

[lat9]

I've just submitted DbIo v.4.0 to the Zen Cart plugins for review, implementing this feature as described above. I'll post back here once it's available for download.

DbIo v1.4.0 is now available for download from the Zen Cart plugins!

[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!