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

[lat9]

File Sent - Versions are ZC 1.5.8a and DbIo 2.0.2.

The CSV file you sent is missing the (required) v_products_id column, which DbIo properly complains about when trying to import.

[swguy]

This seems to be a 1.5.8 related issue; a stock 1.5.8 cart also downloads a Featured csv starting with products_model rather than products_id.

[swguy]

Unless the issue is obvious, please don't spend a bunch of time on this. I have told the client they'll have to upgrade after Christmas.

[lat9]

v2.1.0 of DbIo is now available for download: https://www.zen-cart.com/downloads.php?do=file&id=2091

This release contains changes associated with these GitHub issues:


#135: Adding LINK and MOVE commands to DbIoProductsHandler.
#216: Add REMOVE command to DbIoFeaturedHandler; export format also changed, now includes products_id.
#241: Allow MySQL-formatted dates to be accepted on import, regardless of the 'CSV: Import Date Format' setting.

P.S. The change for #216 also corrects the issue that @swguy reported above.

[swguy]

Wonderful - thank you!

[GoldBuckle]

I just installed Dbio on 2.0.1. I have exported ProductsAttribsRaw and gave it a look over. I have an Excel spreadsheet which I use to price attributes. In order to import a csv file of my price spreadsheet I am thinking I need to add "v_products_attributes_id", "v_products_model" and "v_options_values_price"...should that be all I need or will it create new duplicate entries if I don't have all the values in it to match the Dbio export exactly?

[lat9]

I just installed Dbio on 2.0.1. I have exported ProductsAttribsRaw and gave it a look over. I have an Excel spreadsheet which I use to price attributes. In order to import a csv file of my price spreadsheet I am thinking I need to add "v_products_attributes_id", "v_products_model" and "v_options_values_price"...should that be all I need or will it create new duplicate entries if I don't have all the values in it to match the Dbio export exactly?

Using a v_products_attributes_id would be very problematic, that's why the handler uses v_products_id, v_options_id and v_options_values_id to locate the attributes-id.

If you haven't already, you might consult the DbIo wiki for that handler's usage notes: https://github.com/lat9/dbio/wiki/Ha...ribsrawhandler

[GoldBuckle]

I have read through the wiki but I'm still not clear on which option in the DBIO would be best for what I am trying to accomplish. I want to update db values in the following field:

v_options_values_price

1. As a test I created a csv file with values in the v_options_values_price field that I wanted to update.

2. I added the required fields (v_products_id, v_options_id, v_options_values_id) listed in the Wiki's ProductsAttribsRawHandler along with it.

3. I got a successful upload message at the top of the DB Manager Page but none of the values updated on the products when I checked. I'm not sure what I did wrong, even looked in the tables and there were no new values created.

Eventually when I get the upload right I would also like to update these fields as well:
v_products_attributes_weight
v_attributes_price_onetime

Thanks in advance!

Best,
Goldbuckle

Using a v_products_attributes_id would be very problematic, that's why the handler uses v_products_id, v_options_id and v_options_values_id to locate the attributes-id.

If you haven't already, you might consult the DbIo wiki for that handler's usage notes: https://github.com/lat9/dbio/wiki/Ha...ribsrawhandler

[lat9]

I have read through the wiki but I'm still not clear on which option in the DBIO would be best for what I am trying to accomplish. I want to update db values in the following field:

v_options_values_price

1. As a test I created a csv file with values in the v_options_values_price field that I wanted to update.

2. I added the required fields (v_products_id, v_options_id, v_options_values_id) listed in the Wiki's ProductsAttribsRawHandler along with it.

3. I got a successful upload message at the top of the DB Manager Page but none of the values updated on the products when I checked. I'm not sure what I did wrong, even looked in the tables and there were no new values created.

Eventually when I get the upload right I would also like to update these fields as well:
v_products_attributes_weight
v_attributes_price_onetime

Thanks in advance!

Best,
Goldbuckle

Are you trying to add a new attribute price or update an existing one? Perhaps if you'd post the contents of the CSV you're using, that would help as I've successfully updated an attribute's price using the method you described.

[GoldBuckle]

Update existing ones. Double checking my csv, will post a sample if the issue persists.

Are you trying to add a new attribute price or update an existing one? Perhaps if you'd post the contents of the CSV you're using, that would help as I've successfully updated an attribute's price using the method you described.