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

[Ryk]

This may well be a daft question, but I've read the docs and this thread and have either missed the obvious or it isn't there.

How to import/export Specials data to/from the Specials table?

[lat9]

This may well be a daft question, but I've read the docs and this thread and have either missed the obvious or it isn't there.

How to import/export Specials data to/from the Specials table?

Not a daft question, nor did you miss the description in the documentation. There's not (currently) a ProductSpecials handler, but I've created a GitHub issue to identify and track the request.

[Ryk]

Thanks. Looking forward to seeing it.

[Ryk]

Another possibly silly question. I can see that v_dbio_command can include ADD or REMOVE, but what should be the command for just updating? Leaving the column blank throws a fatal error.

All I've found in the readme is

DbIo introduces a new column (v_dbio_command) that a handler can conditionally enable to support record-removal and/or other commands. Starting with v1.1.0, the Products handling supports this field; set that column's value to REMOVE for a particular product and, if the product exists, it will be removed.

[lat9]

Another possibly silly question. I can see that v_dbio_command can include ADD or REMOVE, but what should be the command for just updating? Leaving the column blank throws a fatal error.

All I've found in the readme is

You've not given me much to work with! What version of DbIo, which import handler, what is the fatal error thrown?

[Ryk]

Thanks for getting back to me.

Version 1.5.4

Products

Unrecognized command (0) found at line #2; the operation was not performed.

(This was because file had 0 under v_dbio_command - changing it to ADD removed the error)

But my question should probably have been - is there a specific entry required in the v_dbio_command column when just updating a product

[lat9]

Thanks for getting back to me.

Version 1.5.4

Products

Unrecognized command (0) found at line #2; the operation was not performed.

(This was because file had 0 under v_dbio_command - changing it to ADD removed the error)

But my question should probably have been - is there a specific entry required in the v_dbio_command column when just updating a product

When simply updating a product, the v_dbio_command column should be left blank (i.e. an empty string).

[Ryk]

Hi Cindy.

Zen Cart 1.5.6a
PHP: 7.2.18
MySQL 5.6.44
DBIO Version 1.5.4
Handler - Products

If we leave products_id blank, we get

zen_products.products_id, line #2: Value () is not an integer

Entering a products_id of 0 seems counter-intuitive but that then gives a successful import. Just want to check if this is expected behaviour?

[lat9]

Hi Cindy.

Zen Cart 1.5.6a
PHP: 7.2.18
MySQL 5.6.44
DBIO Version 1.5.4
Handler - Products

If we leave products_id blank, we get

zen_products.products_id, line #2: Value () is not an integer

Entering a products_id of 0 seems counter-intuitive but that then gives a successful import. Just want to check if this is expected behaviour?

Ryk, that's the expected behavior, albeit counter-intuitive, since the products_id value is (in the database) an integer.

Are you inserting or modifying products?

[Ryk]

Thanks. I'm testing with one of those clients who has a little bit of knowledge of the dangerous kind, doesn't like change (been a long time user of EasyPop) and generates his csv file from Access so the waters keep getting a little muddied!

We're adding, modifying and removing.

I found I had to download his file and change the format of his model number from "number" to "text" (he has alpha-numeric model numbers) , then re-upload it to get a successful import. This doesn't make sense to me as I thought that formatting was irrelevant in a csv file.

But your module is excellent and I'm gradually getting him to believe it! LOL