Quote:
|
Originally Posted by josebueso
Hello Todd.
I have to import inventory with a lot of html tags, I use MS Excel to clean my data you can install a plug in "ASAP UTILITY" It has a lot great features for that, or use find and replace feature on excel.
|
Thank you for the suggestion. But you are still having to search manually for each individual HTML tag and correct them, right? It would seem that this is quite exhaustive when you take into account the hundreds of possible tags which could be contained in a single file.
We have purchased the utility from xCart which is supposed to allow us to import/export using an excel file however I have not been able to get the import routine to work with an excel file without first still converting it to a CSV file. The exporting works great to an excel file but not the import.
I was hoping that by using the excel import it would help solve a problem such as this. I also tried to change the encoding during import, which also did not work.
Todd