ShipScript has been an eBay Community volunteer since 2003, specializing in HTML, CSS, Scripts, Photos, Active Content, Technical Solutions, and online Seller Tools.
I agree with @Anonymous about the 32K limit on cell size because I have that issue with my older version of Excel. If I download a file that has cell data larger than 32K, it wraps onto a new line when displaying in Excel, but remains fine in the file itself if I don't edit further in Excel.
However, that is not your problem. I downloaded your CSV and the truncated portion is at the beginning and is only a few hundred characters at most. And the breaks are occurring where the commas appear in the HTML code.
I don't know how you are adding the description. I'm guessing this might happen when the content is pasted directly in a cell on the spreadsheet. So, instead of pasting into the cell, click the cell and paste the code into the text line at the top of the spreadsheet to see if that will solve the problem.
I would recommend taking a closer look at your Javascript.
These are the first three cells of your split description
<font rwr='1' style='font-family: Arial' size='4'><meta charset='utf-8' /><meta name='viewport' content='width=device-width initial-scale=1 shrink-to-fit=no' /><title>Free eBay listing template designed by dewiso.com</title><link href='https://dewiso.com/css/bootstrap.min.css' rel='stylesheet' /><style type='text/css'>.element{background-image:url('https://dewiso.com/images/f0f0f0_background.png');background-size:cover}</style><div style='background Notice that there would have been a comma after device-width in the first cell and after scale=1 in the second cell. I don't know what character follows background in the third cell, but that character has split the row, so I suspect there was a line-end at that location.
When scripting a CSV file, rather than when typing directly into a spreadsheet, the description text must be quoted and any embedded quotes must be doubled. So your script should first look for line-ends (\r\n and \r and \n) and remove or convert to a space (I prefer converting to a space), then look for internal quotes (") and double each one (""), and finally, wrap the entire description in quotes. The quoted description can then be added to the other data in that row or array.
File Exchange will accept data that is comma-delimited, semicolon-delimited, or tab-delimited, but make sure the script is using the same delimiter throughout, particularly if using a premade CSV conversion function.
I think the problem may be with the script that creates the spreadsheet. Can you provide one record (one row of data) from the CSV file that is created from your data?
Hello shipscript,
I have removed all color codes that start with #, that was the problem regarding HTML, but now I get this response when I try to upload
I wanted to see the file with the broken HTML in it. Can you change your spreadsheet file suffix from "CSV" to "TXT" and share that one with the original HTML?
Your current BAF.error.7 is due to quotes not surrounding some of your data. I suspect that is the general problem with your HTML file, but I would like to see that file as txt to confirm. In your earlier post, I did see a problem with the color codes in your HTML and I would like to see those in the original format as well.
