Easy Populate CSV: problem when open Complete File in excel

[henryvuong]

Yeah, I tried the old version and the same thing happened, so I guess the missing of unique model number is the reason. I'll add them now. Thanks for the info.

[henryvuong]

I'm pulling my hair here. I assigned unique product model number for each item and it's still doesn't work.

I uninstalled and reinstalled the tool and there's a difference this time, the Full file set when opened in excel does show all the information, but all in ONE single column, with all the header (v_products_model, v_products_image, v_products_name_1, etc.) in one single cell on the top.

I notice that when I open the text file with Excel, the Import Wizard does not pop up, like it should when you open a text delimited file.

And again, the four other files (PriceQty, Category, etc.) are fine, they appear in the excel format the way they should be.

[henryvuong]

If anyone wants to look at my full tab-delimited file to help me out, you can download it here:

http://shockingprice.com/external/Full-EasyPopulate.txt

Save the file in text format and open it in excel, you'll see what I said.

[misty]

deleted..see post below

[misty]

File is correct EXCEPT there is NO unique model number
for EACH and EVERY product...also use Open Office...
works better with EP than Excel

[henryvuong]

I figured it out, it's the HTML tags "<TABLE> <TR> <TD>" that cause Excel to format the file incorrectly. I removed them and it works fine now.

Now I have another problem: the product description is truncated when opened with Excel. The maximum number of characters in each cell is 255. Most of my product description has longer length than that. How do I lift this limit? With this limit, the whole purpose of using Easy Populate is defeated because I cannot update product information with truncated description!

(I know my file lacks the product model, but I can work on it later.)

[henryvuong]

Well after wandering online for a few hours, I figure out Excel always has this problem when importing a text field longer the 255 characters, even though each cell can contain up to 32,767 characters.

But I found a simple solution for all the problems: use MS Access to import the file, then export it back to Excel (or I can just use Access to edit the info). With Access, I don't even have to remove the HTML tags.

Thank you all for your help.