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

[RixStix]

Sorry, it looks ugly. I hope I got the commas inserted to help things

v_products_name_en
,v_products_id
,v_products_model
,v_products_description_en
,v_products_sort_order
,v_categories_name
,v_products_image,
v_products_weight
,v_products_quantity
,v_products_type
,v_products_price
,v_products_status
,v_tax_class_title
,v_dbio_command

Sterling Clasp Assortment 1,,
SSast1,
This is a test description,
10
,OOPS!!!!,
12ss.jpg,
0.2,
3,
1,
100,
1
,Taxable Goods,
ADD

[RixStix]

Cindy,

FWIW,
I took the full dbio.Product export
Deleted all but the first product & header line
Edited the data in the first line with new product info
Left v_product_id blank
Left dates blank
v_products_ordered blank since the product is new and none ordered/sold
Left all metatag fields blank
v_product_description blank

v_dbio_command ADD

Nothing inserted into v_categories_name ie: category ID 229

Note: This is the first time ever for me to attempt product addition so it is extremely possible for me neglecting a required column

[Ryk]

Hi Cindy

Different problem now with the same set up - ZC157, DBIO 165, products handler

On Export, I'm seeing a blank line in the csv, then

<style>.block .notice.invalid{display:none;}</style>

on the next line, and the last line of data stops partway through the final product description so on that last product, there is no category info.

Happy to provide csv and log file if you wish.

[lat9]

@rixstix, would you send me a copy of the DbIo log associated with that errant import to my direct email address?

[lat9]

Sure, Ryk. Send those on over the pond via direct email.

[RixStix]

@rixstix, would you send me a copy of the DbIo log associated with that errant import to my direct email address?

PM. Outlook crashes must have lost it.

[RixStix]

email address, that is. We're going to be out and about for a few hours, so it will be late this afternoon.

[lat9]

@Ryk, would you use the site's Tools :: Developers Tool Kit to search all admin files for the string <style>.block .notice.invalid{display:none;}</style>?

It's looking like there's a .php file (?) that has a blank line after its closing ?> that is causing premature output to be generated.

[Ryk]

Thank you for the pointer - looks like something related to the template.

If that's NOT the problem, I'll get back to you.

[lat9]

Another import question.

dbio 1.6.5
zc 156c

Trying to import new products and call myself reading the entire readme several times but the answer might be a snake.

Thus far, I have not been able to add the test product.
using handler
dbio.Products.ProdIDIMPORT.xxx
downloaded the handler, removed columns that are not important "to me"

v_dbio_command either blank or ADD

Excerpt from one of the dbio logs, but no new product to be found in category 229

2021-03-08 12:14:48: Forcing ADD of product at line #3, via DbIo command
2021-03-08 12:14:48: importBuildSqlQuery for products_description:
INSERT INTO products_description (`products_name`, `products_description`, `language_id`, `products_id`)
VALUES ('Sterling Clasp Assortment 1', 'This is a test description', 1, 0)
2021-03-08 12:14:48: importBuildSqlQuery for products:
INSERT INTO products (`products_model`, `products_sort_order`, `products_image`, `products_weight`, `products_quantity`, `products_type`, `products_price`, `products_status`, `master_categories_id`, `products_tax_class_id`, `products_date_added`)
VALUES ('SSast1', 10, '12ss.jpg', 0.2, 3, 1, 100, 1, 229, 1, now())

Rick, got the files via email (thanks). Was the OOPS!!!! category pre-existing when you performed the import, or was it auto-created when this product was imported?