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

[lat9]

Is it possible for me to call dbio from another program? "Hey, DBIO: Import this products file" is what I'd like to do, without the user having to go dbio, select products, and use the import form.

With a little "shackling", it's certainly possible. You can mimic the interface used by the /admin/dbio_manager.php module.

The main sequencing is done by the /admin/includes/classes/dbio/DbIo.php class, with two main methods: dbioExport and dbioImport.

[dwchamb]

That message implies that your import-CSV file identifies 43 columns in the header row (the first row) but only 42 rows in data.

I am having this same problem with Zencart 1.5.5f and dbio 1.4.1. I found where this person was having this problem but I can find no fix for it. How can this be fixed? I export my products and get the error even when I try to import it back into my original database.

Thanks

[lat9]

I am having this same problem with Zencart 1.5.5f and dbio 1.4.1. I found where this person was having this problem but I can find no fix for it. How can this be fixed? I export my products and get the error even when I try to import it back into my original database.

Thanks

Could you post (between "CODE" tags, that big # in the post-writing menu) the first two lines of the .csv file you're trying to import?

[dwchamb]

Could you post (between "CODE" tags, that big # in the post-writing menu) the first two lines of the .csv file you're trying to import?

This is tab delimited.

"v_products_id"t"v_products_type"t"v_products_quantity"t"v_products_model"t"v_products_image"t"v_products_price"t"v_products_virtual"t"v_products_date_added"t"v_products_last_modified"t"v_products_date_available"t"v_products_weight"t"v_products_status"t"v_products_ordered"t"v_products_quantity_order_min"t"v_products_quantity_order_units"t"v_products_priced_by_attribute"t"v_product_is_free"t"v_product_is_call"t"v_products_quantity_mixed"t"v_product_is_always_free_shipping"t"v_products_qty_box_status"t"v_products_quantity_order_max"t"v_products_sort_order"t"v_products_discount_type"t"v_products_discount_type_from"t"v_products_price_sorter"t"v_products_mixed_discount_quantity"t"v_metatags_title_status"t"v_metatags_products_name_status"t"v_metatags_model_status"t"v_metatags_price_status"t"v_metatags_title_tagline_status"t"v_products_name_en"t"v_products_description_en"t"v_products_url_en"t"v_products_viewed_en"t"v_manufacturers_name"t"v_tax_class_title"t"v_categories_name"tv_dbio_command
1t1t10tAS08thydroforce/as08_lg.jpgt169.00t0t"2012-05-19 20:24:27"t"2015-05-13 19:33:31"t"0001-01-01 00:00:00"t10t1t0t1t1t0t0t0t1t0t1t0t0t0t0t169.00t0t0t0t0t0t0t"HydroForce Sprayer"t"The Original HydroForce High-Pressure (100-1000 psi) Injection Sprayer!<br /><br />

Over 20,000 professional carpet cleaners can't be wrong. The amazing 
HydroForce connects to your pressure line and automatically draws 
concentrate from the 5-quart container to achieve your desired dilution 
ratio. Use for carpet pre-sprays, deodorizers, protectors, dying, etc.<br /><br />

HEAVY-DUTY STAINLESS STEEL EXTENSION AND GUN -
VIRTUALLY INDESTRUCTIBLE!<br /><br />Benefits:<ul style=""margin-top: 0px;""><li>NEW, patent-pending container design makes the Hydro-Force sprayer the most convenient sprayer on the market.</li><li>Large side-fill port - refill without removing the injector assembly</li><li>Wand holder to keep your wand off your customer's floor</li><li>Recessed handle - no more annoying velcro straps</li><li>Operating pressure range of 100-1,000 PSI</li><li>Eliminates annoying mixing required by pump up sprayers</li><li>High-quality quick connects allow your gun to swivel and permits quick removal</li></ul><br />"tt1382tHydro-Forcet"Taxable Goods"tAccessories

[dwchamb]

This may be a better sample.

v_products_id	v_products_type	v_products_quantity	v_products_model	v_products_image	v_products_price	v_products_virtual	v_products_date_added	v_products_last_modified	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_mixed	v_product_is_always_free_shipping	v_products_qty_box_status	v_products_quantity_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_description_en	v_products_url_en	v_products_viewed_en	v_manufacturers_name	v_tax_class_title	v_categories_name	v_dbio_command

1	1	10	AS08	hydroforce/as08_lg.jpg	169.00	0	"2012-05-19 20:24:27"	"2015-05-13 19:33:31"	"0001-01-01 00:00:00"	10	1	0	1	1	0	0	0	1	0	1	0	0	0	0	169.00	0	0	0	0	0	0	"HydroForce Sprayer"	"The Original HydroForce High-Pressure (100-1000 psi) Injection Sprayer!<br /><br />

Thanks

[lat9]

Hmm, try deleting the header-column named v_dbio_command; I'm guessing that that's the extra column.

What program do you use to edit those CSV files for import?

[dwchamb]

Hmm, try deleting the header-column named v_dbio_command; I'm guessing that that's the extra column.

What program do you use to edit those CSV files for import?

I use Apache Open Office Calc. Deleting the header-column named v_dbio_command fixed that error. Thanks for the quick reply.

[lat9]

I've just submitted v1.5.0 of the Database I/O Manager to the Zen Cart plugins for review and will post back here once it's available.

This release contains the changes associated with the following GitHub issues:

#117: Correct multi-language customized "Products" export field-ordering.
#118: Add customers' default address information to the "Customers" export.
#119: Add a handler to import/export the "Products Discount Quantity" information.
#120: Correct exports for handlers that support a 'dbio_command'.

[lat9]

I've just submitted v1.5.0 of the Database I/O Manager to the Zen Cart plugins for review and will post back here once it's available.

This release contains the changes associated with the following GitHub issues:

#117: Correct multi-language customized "Products" export field-ordering.
#118: Add customers' default address information to the "Customers" export.
#119: Add a handler to import/export the "Products Discount Quantity" information.
#120: Correct exports for handlers that support a 'dbio_command'.

v1.5.0 is now available for download from the Zen Cart plugins: https://www.zen-cart.com/downloads.php?do=file&id=2091

[dbltoe]

1.5.5e PHP 5.6 -- More of a procedural question.

Scenario: Site sells bottles of vinegar. Available in singles, three-, six-, and twelve-packs. Naturally, the Option Name is set to Bottle 1 thru Bottle 12 and the appropriate number added to the respective product. The vinegar names are the Option Values for each Bottle so the Values are listed a total of twelve times.

All is well until two flavors are discontinued and six flavors are added.

I assume (I know) that simply deleting the discontinued flavors could munge the order history. Leaving them there is no problem.

The fun comes in getting the extra values into the options since the options and values tables are not directly tied to each other.

Do you have a suggested process order to accomplish this?

THANX