eBay Turbo Lister 2.0 Exporter Support Thread

[dwessell]

Well.. I've run the file at 1 item two items, and then 3.. And on the third item the issues begin, so we're making progress!!

[dwessell]

Almost there!! On that third entry there is the funny square character..

I already have:

if(strtolower(CHARSET) != 'utf-8')
				$output_buffer .= utf8_encode($output);
			else
				$output_buffer .= $output;

It wasn't commented out in the version of ebay.php that I uploaded.

thanks
david

[dwessell]

Well I have to admit to having run into a wall.. So far I can't a method for ensuring the output is liked by Turbo LIster... I'll keep trying though!!!

dw

[BlessIsaacola]

Almost there!! On that third entry there is the funny square character..

I already have:

if(strtolower(CHARSET) != 'utf-8')
				$output_buffer .= utf8_encode($output);
			else
				$output_buffer .= $output;

It wasn't commented out in the version of ebay.php that I uploaded.

thanks
david

The problem is definitely with the encoding/character set. For some reason, when the file is generated it doesn't appear that everything is fully sanitized. Look at a few of the products that have a square box and view the source code for them when you're on the ZC Admin side. You will notice some strange things are exactly the spots where you're seeing the square boxes in excel. Sometimes it's just extra white spaces and sometimes it's some funky code that you need to change to a different character set.

Take a look at the source code on the admin section and report back what you see behind the scene for the product descriptions with the square boxes.

[dwessell]

Well that tells me what the problem is.. In the admin area, if someone hit enter while typing a description, and began on a new line that causes the issue.

Is there a way to sanitize this while generating the feed? Or do I need to go through all of the products and remove it?

Thanks
David

[dwessell]

I tried:

[code]
$order = array("\r\n", "\n", "\r");
str_replace($order,"",$output);
[\code]

but to no avail..

I went directly into the DB, and this is what I found:

All the razors we sell come honed and Shave ready. This service is if you want to send us your razor to hone.


<p>The most important aspect of enjoying straight razor shaving is having a blade that has been sharpened to it’s maximum potential. This is what provides that completely clean, close and comfortable shave that we straight razor users enjoy so much. Most new razors do not come ready to shave when initially purchased. In addition a razor will normally become dull and need to be re-sharpened several times a year depending on daily use and on beard type.<p>

It's that space between the two paragraphs that I can't seem to get rid of.

[dwessell]

I went into phpmyadmin and viewed the source that they show, and I find these little characters wherever there is a problem: <p>

Now I know that should convert into <p> when outputted.. But the csv file doesn't have them.. So I tried stripping them out with str_replace.. To no avail.. Then tried stripping out the <p> tags with the same function, to no avail :)

[dwessell]

Got it..

$output = str_replace("\r","",$output);

That fixed everything.. Thanks for everyones suggetions.

dw

[BlessIsaacola]

Got it..

$output = str_replace("\r","",$output);

That fixed everything.. Thanks for everyones suggetions.

dw

Can you please clarify where you made that change? When you said it fixed everything...are you saying it removed the square boxes or all html formatting (which would be bad)?

[BlessIsaacola]

Can you please clarify where you made that change? When you said it fixed everything...are you saying it removed the square boxes or all html formatting (which would be bad)?

Well, hoping someone will see this and respond.....