Printable View
With a little "shackling", it's certainly possible. You can mimic the interface used by the /admin/dbio_manager.php module.Quote:
Originally Posted by swguy
The main sequencing is done by the /admin/includes/classes/dbio/DbIo.php class, with two main methods: dbioExport and dbioImport.
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.Quote:
Originally Posted by lat9
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?Quote:
Originally Posted by dwchamb
This is tab delimited.Quote:
Originally Posted by lat9
Code:"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
This may be a better sample.
ThanksCode: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 />
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.Quote:
Originally Posted by 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=2091Quote:
Originally Posted by lat9
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