Export/Import Tool -- Undefined option_value_name

OC 2.0.3.1 (717 products), Export/Import 2.28, Theme: Default

Everything has been working great during the long development of a new site, scheduled to go live on Friday, Dec 18 at 12 Noon U.S. CDT.

Due to an oversight, the SEO Keyword was missing the .html at the end of the keywords, so I exported the product list, picked up the XLSX file in Open Office Calc, a few minutes later all of the SEO Keywords have their .html appended and then tried to import the ODS file back for an update. While they vary, all 17 of the problematic products exhibited this error:

2015-12-17 15:39:25 - Export/Import: Undefined option_value_name 'CPI-6554P -- 65 / 54 358cc' for option_name 'Cylinders - Cheetah Cub' used in worksheet 'ProductOptionValues'!

The errors involved option_id 40, 42 and 43. They were all edited yesterday. I checked the Catalog>Options lists for these option lists and everything looks the same. I double-checked for trailing spaces and fixed a few, repeated the whole process form the beginning and got the same result in the end.

I cannot find anything wrong in the MySQL tables, so this error has me stumped. If anyone has any thoughts or suggestions, I can surely use them.

I have attached the error log file in case it is helpful.

In Export/Import Tool v2.27, successful import was via Open Office Calc .ODS file import. In the latest v2.28, it seems as though XLSX works but ODS is problematic.

My solution was to to the import of the XLSX version and it went perfectly.

I have the same problem. The reason was in <p></p> tags in option fields. I just remove any tags from option field in admin panel and export/import works witout any errors.