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

[lat9]

I've just submitted v1.6.4 of DbIo for the Zen Cart moderators' review; I'll post back here when it's available for download.

This release contains changes associated with the following GitHub issues:

#175: Correct CSV 'split' function processing.
#176: 'Products': Multi-lingual customized-template export columns can 'go off'.
#177: No admin message when multiple v_dbio_command columns are found.
#178: 'Products' import, enable a product to be 'unlinked' from a linked category.
#179: Valid dates that don't start with a year are being indicated as invalid.
#180: Additional configuration setting for Products to require an 'ADD' command to insert a new product.
#181: ProductsAttribsRaw: Unwanted download record added for empty download name.

Now available for download: https://www.zen-cart.com/downloads.php?do=file&id=2091

[Ryk]

Hi Cindy

A user says

The 'DBIO Split File: Record Count' is being ignored. It is set at 60000 which usually produces 6 files, it is currently producing 22!

I have had him confirm that the file itself is correct and not malformed (ie. it's not suddenly over 3 times larger than before), but although he's set it to split at 60000 records per file, it is splitting to around 3000 records per file.

Can you offer any suggestions as to why this might be?

[lat9]

Hi Cindy

A user says



I have had him confirm that the file itself is correct and not malformed (ie. it's not suddenly over 3 times larger than before), but although he's set it to split at 60000 records per file, it is splitting to around 3000 records per file.

Can you offer any suggestions as to why this might be?

Is the user, perhaps, using a version of DbIo prior to v1.6.4? There were corrections for the 'Split' processing in that version.

[Ryk]

Thanks - looks like he's still on 1.6.3 - will try the upgrade

[jeking]

I've tried to find my answer because I'm sure it's here but I cannot find it.

My client is/was using Apsona (which no longer works for us) and needs to add products. I'm getting:

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

DBIO 1.6.3
ZC 1.536c

I have ADD in v_dbio_command and v_products_id is blank.

What formatting do I need to insert new products?

[lat9]

I've tried to find my answer because I'm sure it's here but I cannot find it.

My client is/was using Apsona (which no longer works for us) and needs to add products. I'm getting:

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

DBIO 1.6.3
ZC 1.536c

I have ADD in v_dbio_command and v_products_id is blank.

What formatting do I need to insert new products?

You can simply set the v_products_id field to 0 (not an empty string).

[jeking]

You can simply set the v_products_id field to 0 (not an empty string).

To an old Staples add, "that was easy". THanks!

[lat9]

To an old Staples add, "that was easy". THanks!

Easy is good!

[DannyVarley]

I'm having a small issue that's driving me crazy, I'm using dbio to bring products onto a new Zencart site. However, when uploading new products with a specific ID i would like to keep it seems that dbio is ignoring v_products_id and instead using a generated auto-increment value.

I have looked through the settings and don't believe this is something that can be controlled?

Feel like I'm missing something obvious...

[lat9]

I'm having a small issue that's driving me crazy, I'm using dbio to bring products onto a new Zencart site. However, when uploading new products with a specific ID i would like to keep it seems that dbio is ignoring v_products_id and instead using a generated auto-increment value.

I have looked through the settings and don't believe this is something that can be controlled?

Feel like I'm missing something obvious...

You're not missing anything obvious (I'll update the documentation to make it more clear).

If a products_id isn't already present in the database for a Products import, then it's a new product and, to keep the database integrity, a new auto-increment value is assigned. The same holds true for any import: If the auto-incremented 'id' for the to-be-imported table doesn't already exist, the next auto-increment value is assigned on the import.