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

[chuckrey]

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)

[lat9]

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.

[chuckrey]

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

[g2ktcf]

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.

[g2ktcf]

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.

[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.

[g2ktcf]

>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.

[g2ktcf]

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?

[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

[lat9]

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