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

[LadyoftheCave]

You'll need to keep the v_products_id column (set that value for new products to 0) and supply a unique v_products_model value for a new product to be created.

When creating a new product, you'll also want to make sure that you have the v_categories_name column set to identify the category "tree" associated with the to-be-added product's master-category.

When you're performing any kind of import, I suggest that you first perform an Import (Check-only) first. That processing will do every step of the import ... except that the database is not updated. You can then see what will happen before actually committing the information to your database.

Once the import is finished, a link shows next to the action-selection dropdown that reads View import details; click that link and a popup will display showing you the status of that import.

After you've verified your import-csv using Import (Check-only), that's the time to use Import (Full) which will actually write the requested information to your database.

Hi lat9,

I have tried that out:



But I still receive the same error message about the missing columns..

Foutmelding The current import-file is missing these (v_products_id, v_products_model) required columns; the import is disallowed.

[lat9]

PM sent.

[lat9]

It turns out that the message that @LadyoftheCave was receiving was because the import CSV file was using a semi-colon (;) instead of the more traditional comma (,) as the field delimiter.

Updating the DbIo's Configuration->DbIo Manager Settings->CSV Delimiter to ; allows the import to proceed without error.