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

Quote:

---

Originally Posted by 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.
Attachment 20943

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)

Quote:

---

Originally Posted by 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.
Attachment 20943

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

Quote:

---

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.

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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