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

I just installed this addon to 2.1.0

I don't get this. When I click on "Manage Option's Stock" I did everything no products to show. What am I missing here?

wmorris:

I just installed this addon to 2.1.0

I don't get this. When I click on "Manage Option's Stock" I did everything no products to show. What am I missing here?

You're confusing Products' Options' Stock Manager (POSM) with DBIO. Instructional info for DBIO can be found at https://htmlpreview.github.io/?https://github.com/lat9/dbio/blob/master/docs/dbio/readme.html

dbltoe:

You're confusing Products' Options' Stock Manager (POSM) with DBIO. Instructional info for DBIO can be found at https://htmlpreview.github.io/?https://github.com/lat9/dbio/blob/master/docs/dbio/readme.html

I have read everything on there and I don't see anything about POSM? Then this addon will not work for me.

Manage Option's Stock is an operation of POSM, not DBIO. The wiki for POSM can be folujnd at https://github.com/lat9/options_stock_support/wiki.

wmorris:

I just installed this addon to 2.1.0

I don't get this. When I click on "Manage Option's Stock" I did everything no products to show. What am I missing here?
Like others have mentioned in this thread, the tool you're referencing has to do with Products' Options' Stock Manager (POSM), not DbIo. That said, POSM manages the stock of products' options ... do any of your products have attributes?

P.S. This discussion should be moved to its own thread.

Using ZC 2.1.0 w/ php 8.3. Responsive Classic

I am new to using DBIO plugin and all has been working very well, until I ran into an issue when importing Attributes Basic. I imported Names and Values without an issue, but when attempting to import attribute basic I receive an error which states: "Attributes not inserted at line number 2; one or more option-values (option value name) were either not present in the default language or are not associated with the products_options_id of 7."

Has anyone ran into this issue? Thanks!

chuckrey:

Using ZC 2.1.0 w/ php 8.3. Responsive Classic

I am new to using DBIO plugin and all has been working very well, until I ran into an issue when importing Attributes Basic. I imported Names and Values without an issue, but when attempting to import attribute basic I receive an error which states: "Attributes not inserted at line number 2; one or more option-values (option value name) were either not present in the default language or are not associated with the products_options_id of 7."

Has anyone ran into this issue? Thanks!
For an attribute to be imported, each option-value needs to be created via either separate DbIo import or the admin's Catalog / Options Names Manager. The message you're receiving indicates that the option value doesn't exist or that the option-name its 'associated with' doesn't have an options_id of 7 (which is what's specified in the DbIo input record).

Okay, I see. I just had a look and it appears as though options id 7 is not associated with any option values whereas option id 0 is associated with all the values I need, so I just need to go about the best way to move em over. If I have any trouble, I may be back... Thank you.:smile:

lat9:

For an attribute to be imported, each option-value needs to be created via either separate DbIo import or the admin's Catalog / Options Names Manager. The message you're receiving indicates that the option value doesn't exist or that the option-name its 'associated with' doesn't have an options_id of 7 (which is what's specified in the DbIo input record).

So I believe I understand the issue, I am not sure how to resolve it.

I took a smaller sample of the basic attributes values and attempted to import, but received a similar response as follows:

✗ Attributes not inserted at line number 2; no match for option name::option_type::default_language_id (Bedroom::0::1).
✗ Attributes not inserted at line number 3; no match for option name::option_type::default_language_id (Bedroom::0::1).
✗ Attributes not inserted at line number 4; no match for option name::option_type::default_language_id (Bedroom::0::1).

The import of product options and product options values processed without an issue, however the basic attributes is still giving me trouble. I am also including a screenshot of the option values with names for reference. Any suggestion to resolve? Thanks again.

How about posting the 3 lines from the CSV input that resulted in the error messages indicated above?

lat9:

How about posting the 3 lines from the CSV input that resulted in the error messages indicated above?

Sure, here is what I have on the csv files. I actually had a few more lines, but I used the first 3 as the others said the same exact thing. Thank you.

In case it's hard to zoom, here is copy and paste.
v_products_model v_products_options_type v_products_options_name v_products_options_values_name
cm4850BLK 0 Bedroom Inventory (click here)^Mirror^Base^Top Glass^Stool^Vanity with Stool^Inventory (click here)
cm4850WHT 0 Bedroom Inventory (click here)^Mirror^Base^Top Glass^Stool^Vanity with Stool^Inventory (click here)
cm5264-charcoal 0 Bedroom Queen Bed^King Bed^King/Queen Rails^Queen Headboard / Footboard^King Headboard / Footboard^Inventory (click here)

chuckrey:

Sure, here is what I have on the csv files. I actually had a few more lines, but I used the first 3 as the others said the same exact thing. Thank you.

In case it's hard to zoom, here is copy and paste.
v_products_model v_products_options_type v_products_options_name v_products_options_values_name
cm4850BLK 0 Bedroom Inventory (click here)^Mirror^Base^Top Glass^Stool^Vanity with Stool^Inventory (click here)
cm4850WHT 0 Bedroom Inventory (click here)^Mirror^Base^Top Glass^Stool^Vanity with Stool^Inventory (click here)
cm5264-charcoal 0 Bedroom Queen Bed^King Bed^King/Queen Rails^Queen Headboard / Footboard^King Headboard / Footboard^Inventory (click here)
I'm not seeing the "Inventory (click here)" option value listed in the screenshot you'd posted in post 549.

I have multiple pages of Bedroom. It's on page 2. See pic.

The current import-file is missing these (v_products_id) required columns; the import is disallowed.

I have an odd problem. I have a CSV that has this column. It is NOT duplicated. But yet I cannot get this import file validated.

I seem to have fixed the issue. I am not sure WHY. It was an Excel spreadsheet saved as a UTF-8 csv. Then opened in Open Office and resaved each time. That last try got it working. Go figure.

>It was an Excel spreadsheet

Excel is total crap for import/export of third-party data/character encodings: just use Libre/Openoffice for this work.

torvista:

>It was an Excel spreadsheet

Excel is total crap for import/export of third-party data/character encodings: just use Libre/Openoffice for this work.

I have experienced issues with Excel in the past. But I always ran the sheet back through Open Office before importing. Not sure what happened.

Let me start by saying I love this feature. Hats off to all involved.

I made an error in creating my csv file. I inadvertently tried to copy a cell (products_types) and instead of copying a 1 to all cells in the column, it autoincremented from 1 to 28 and I did not noticed it until my debug logs started filling up.

I understand that this is totally on ME period. Possible suggestion: Would it be practical to only allow existing product types to be imported? Or could this be by design?

When you import a product that creates a new category there seems to be a minor issue.

When category is created using Database I/O import the SORT ORDER is being imported as a value of "null".

It needs to be "0" so the category stays in the alphabetical format

chadlly2003:

When you import a product that creates a new category there seems to be a minor issue.

When category is created using Database I/O import the SORT ORDER is being imported as a value of "null".

It needs to be "0" so the category stays in the alphabetical format
Thanks for the report. See this GitHub issue for tracking: https://github.com/lat9/dbio/issues/224