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

[slitter]

When will the new 1.5.2 version be available for download?

[lat9]

When will the new 1.5.2 version be available for download?

Thanks for the reminder!

I'll get that packaged up and report back.

[lat9]

Thanks for the reminder!

I'll get that packaged up and report back.

I've just submitted v1.5.2 of the DbIo to the Zen Cart plugins for review; I'll post back here once it's available for download (https://www.zen-cart.com/downloads.php?do=file&id=2091).

This release contains changes associated with the following GitHub issues:


#124: Recognize utf8mb4 DB_CHARSET as a valid match to a CHARSET of utf-8
#125: Recognize a field-type of double.
#126: Accept negative integer values.

[lat9]

I've just submitted v1.5.2 of the DbIo to the Zen Cart plugins for review; I'll post back here once it's available for download (https://www.zen-cart.com/downloads.php?do=file&id=2091).

This release contains changes associated with the following GitHub issues:


#124: Recognize utf8mb4 DB_CHARSET as a valid match to a CHARSET of utf-8
#125: Recognize a field-type of double.
#126: Accept negative integer values.

That was fast! DbIo 1.5.2 is now available for download.

[slitter]

Thanks for the update.. just wondering if it is possible to combine Order information from Orders, Orders Products, Orders Attributes, Order Total, Order history tables and combine them with Customer information such as Customer name, Customer address ##etc etc ##into ONE CSV file ?

[lat9]

Thanks for the update.. just wondering if it is possible to combine Order information from Orders, Orders Products, Orders Attributes, Order Total, Order history tables and combine them with Customer information such as Customer name, Customer address ##etc etc ##into ONE CSV file ?

That's a tall order as there are (as you've identified) a significant number of tables to pull together. I'll give it some consideration, but will caution you not to expect anything soon.

[lynbor]

Just installed ZC 1.56a. a nice clean new install and then added DbIo. I'm attempting to merge to product databases into one. I used DbIo to export products from the other 2 ZC installations, both of which are v1.5.5b. Using excel on the two exported CSV files I changed the product_ID column to have unique numbers so there wouldn't be any conflict. It all looks good in the CSV file, but when I attempt to import I get a bazillion errors of "Value (1) is not an integer" (the number in the parenthesis changes with the number in the field it identifies. It looks like there are about 7 columns that generate this error message even though, there is definitely and "integer" in those fields. And the CSV appears to be correctly formated as far as numbers NOT having quotes around them and no extra spaces etc.. So how to I get DbIo or MySql to stop rejecting my integers?

[lynbor]

Just installed ZC 1.56a. a nice clean new install and then added DbIo. I'm attempting to merge to product databases into one. I used DbIo to export products from the other 2 ZC installations, both of which are v1.5.5b. Using excel on the two exported CSV files I changed the product_ID column to have unique numbers so there wouldn't be any conflict. It all looks good in the CSV file, but when I attempt to import I get a bazillion errors of "Value (1) is not an integer" (the number in the parenthesis changes with the number in the field it identifies. It looks like there are about 7 columns that generate this error message even though, there is definitely and "integer" in those fields. And the CSV appears to be correctly formated as far as numbers NOT having quotes around them and no extra spaces etc.. So how to I get DbIo or MySql to stop rejecting my integers?

Here is the displayed error message after attempting the import
.
The DbIo import from file "/hm//public_html/zc/chnk-Dd-fsH/dbio/dbio.Products.upload2.csv" was completed with 6707 errors and 518 warnings. 0 records were inserted or updated.

And here is a portion of the log

2019-04-03 16:43:42:[*] products.products_type, line #2: Value (1) is not an integer
2019-04-03 16:43:42:[*] products.products_virtual, line #2: Value (0) is not an integer
2019-04-03 16:43:42:[*] products.products_date_added, line #2: Value (0000-00-00 00:00:00) is not a recognized date value; the default value for the field will be used.
2019-04-03 16:43:42:[*] products.products_status, line #2: Value (1) is not an integer
2019-04-03 16:43:42:[*] products.products_priced_by_attribute, line #2: Value (0) is not an integer
2019-04-03 16:43:42:[*] products.product_is_free, line #2: Value (0) is not an integer
2019-04-03 16:43:42:[*] products.product_is_call, line #2: Value (0) is not an integer
2019-04-03 16:43:42:[*] products.products_quantity_mixed, line #2: Value (1) is not an integer
2019-04-03 16:43:42:[*] products.product_is_always_free_shipping, line #2: Value (0) is not an integer
2019-04-03 16:43:42:[*] products.products_qty_box_status, line #2: Value (1) is not an integer
2019-04-03 16:43:42:[*] products.products_sort_order, line #2: Value (10) is not an integer
2019-04-03 16:43:42:[*] products.products_discount_type, line #2: Value (2) is not an integer
2019-04-03 16:43:42:[*] products.products_discount_type_from, line #2: Value (0) is not an integer
2019-04-03 16:43:42:[*] products.products_mixed_discount_quantity, line #2: Value (1) is not an integer


And here is a portion of the CSV data I'm trying to import.

v_products_id,v_products_type,v_products_quantity,v_products_model,v_products_im age,v_products_price,v_products_virtual,v_products_date_added,v_products_last_mo dified,v_products_date_available,v_products_weight,v_products_status,v_products_ ordered,v_products_quantity_order_min,v_products_quantity_order_units,v_products _priced_by_attribute,v_product_is_free,v_product_is_call,v_products_quantity_mix ed,v_product_is_always_free_shipping,v_products_qty_box_status,v_products_quanti ty_order_max,v_products_sort_order,v_products_discount_type,v_products_discount_ type_from,v_products_price_sorter,v_products_mixed_discount_quantity,v_metatags_ title_status,v_metatags_products_name_status,v_metatags_model_status,v_metatags_ price_status,v_metatags_title_tagline_status,v_products_name_en,v_products_descr iption_en,v_products_url_en,v_products_viewed_en,v_manufacturers_name,v_tax_clas s_title,v_categories_name,v_dbio_command
1,1,8968,468-9120-16,468-9120-16.jpg,20.51,0,0000-00-00 00:00:00,6/25/2018 8:35,,2,1,1037,1,1,0,0,0,1,0,1,0,10,2,0,20.51,1,1,1,1,1,1

AS you can see, line 2, the first two items are in fact integers. Arugh!

[lat9]

PM sent.

[lat9]

@lynbor, thanks for a copy of that product-import CSV. I took the first line, stripping all others, and added the DbIo command ADD as the last column, so that the added product won't overwrite my test setup.

I did receive:

✗ products.products_date_added, line #2: Value (0000-00-00 00:00:00) is not a recognized date value; the default value for the field will be used.
✗ Product not inserted at line number 2; category id (0) has categories.
✗ products.products_date_added, line #3: Value (0000-00-00 00:00:00) is not a recognized date value; the default value for the field will be used.
✗ Product not inserted at line number 3; category id (0) has categories.
✗ products.products_date_added, line #4: Value (0000-00-00 00:00:00) is not a recognized date value; the default value for the field will be used.
✗ Product not inserted at line number 4, no match found for categories_name (Irontite).

Where the category-related issues are due to differences between my categories and yours, but I'm not seeing the "Value is not an integer". Are you using the same version of DbIo and its parameters (set in Configuration->DbIo Manager Settings) for both the store from which you're exporting and the store to which you're importing?