Easy populate and HTML

[XtremeCarAudio]

Ok, I tried to search, and found nothing, but the Easy populate post are like 27 pages long...

 

 

I am running in to a HTML problem with my Imports,

 

it seems to be converting the " in to something else, when i import

 

 

anyway to fix it,

 

like on this page

http://test.shop4sound.com/catalog/product...&products_id=60

 

the Table for the product desc has a ovrall "blue" tint to it, the text should be black (with the heading white) and the background should be alternating white and "yellow/orage" with the heading black

 

any clue on what this could be???

[David 1cog]

If I understand the problem correctly, the solution is to use two ' (single quotes) in place of " (double quote).

[David 1cog]

Sorry - please disregard that. I've just discovered that EP doesn't like two single quotes either in products_name. If you use double quote or single quotes in products_name it gets truncated after up load. Using single quotes in products_description seems to be OK.

 

Anyone know a solution to this?

[XtremeCarAudio]

yea I tried that

 

to give you a better idea what I am talking about

 

This product has the exact same HTML (or suppose to)

 

http://test.shop4sound.com/catalog/product...&products_id=63

 

as this one

 

http://test.shop4sound.com/catalog/product...&products_id=62

 

See the differance

 

When every I import with Easy populate the tags have garbage added in to them,

[David 1cog]

I recommend:

 

* emptying your database of products

* add one product using Admin

* 'Download Complete tab-delimited .txt file to edit' from Easy Populate

* empty database again

* upload using the file you just downloaded

 

If the problem does not appear you've got a problem in your Easy Populate file (quotes, invalid chars, too long field(s), missing EOREOR at end of record, etc.).

 

If the problem remains I guess you've got a problem in your installtion of EP.

 

Good luck.

[XtremeCarAudio]

it is DEFINALTLY a probally with EP,

 

 

the file is fine, I opened it up in notepad to double check,

 

 

Where should I start looking, this is not my first OSC store, infact it is my 5th, so I am not new to the code,

 

I have not had this problem with any other store i set up, but this one is baffling me......

[dreamscape]

Easy Populate replaces quotes (double & single) with their HTML equivalents to avoid messing up the import.

 

If you have extensive HTML, you could either not use quotes in the HTML, ie: <font color=#fffff size=3>, etc...

 

OR you can just turn off the quote replacement. Reading docs helps.

[David 1cog]

I read the docs several times. As per previous post - using two single quotes in products_name truncates it after import. I think the same applies to using double quotes.

[Guest]

David 1cog

 

Try this

Open: easypopulate.php

 

global $replace_quotes;

$replace_quotes = false;

 

Change to:

 

global $replace_quotes;

$replace_quotes = true;

 

aprox line 240

 

Cheers Lee

[David 1cog]

Hi Lee

 

I had tried that a few days ago and got an error, but tried again and it's working now. Problem seems to be solved. Thanks.

[David 1cog]

I take that back - using single quotes and double quotes in products_name and products_description and $replace_quotes = false; gives an error:

 

1064 - You have an error in your SQL syntax near '(1500mm) x 8' (2500mm) 1.5m Projection Car Port', products_description='' at line 2

 

UPDATE products_description SET products_name='5' (1500mm) x 8' (2500mm) 1.5m Projection Car Port', products_description='Quality car ports. Select Polycarb colour (Clear, Bronze, Opal) and Frame Colour (White, Brown) before adding to basket. Note: all canopies are supplied with 7" (2145mm) upright posts as standard. Please specify if you require longer uprights.', products_url='' WHERE products_id = '14' AND language_id = '1'

 

The only solution seems to be set $replace_quotes = true; and not use double quotes or two single quotes together.