Import Excel having _x000D_ string
I had migrate one of my OpenCart store from 22.214.171.124 to 126.96.36.199. There are a major upgrade between the data structure. I do have to export the database and manually match the few and import back to the latest version.
After I successfully import to the system. I found that the new line / line break / paragraph show up the funny string which is “_x000D_”. I have no idea where is this character came from. I checked the Excel File, there is no such character there. I try to reimport again. The problem still occurs. Hence, I try Google with this issue.
This is what the author of the extension reply on this issue:
Please try our new version 2.3 which should fix the issue with the missing product option values.As regards the file size: XLSX tends to be larger than the old XLS format. However, you can export in smaller batches, edit, and then re-import.
As regards the
This might be a bug with MS Excel. Do you have the same problem when using OpenOffice or LibreOffice?
He claimed that it is might be a bug of the MS Excel that means I don’t think he will take time to fix it. So the problem is from MS Excel. So I try to solve it with MS Excel.
Previously the extension for 188.8.131.52 is exported with xls extension. However, the latest version is export to xlsx extension.
What I do is I open the xlsx exported file and save it to xls again. I try to import again. Voilà the _x000D_ funny string no more.
If you have the similar problem try to save in to old version of the Excel. It might solve your problem.
Background for the Import / Export Tools
The Import/Export Tool allows the admin user to do a bulk export of all the categories, products, and product options to an Excel spreadsheet file. The spreadsheet file can be edited offline and then be re-imported to the OpenCart database.
It is very useful extension for you to manage your products.