Easy Populate and double quotes -- any way to use them?

[gheffron]

I'm wanting to add a simple javascript popup window to several hundred product descriptions. But EasyPopulate gives an error because of the use of quotation marks in my code.


Specifically, the HTML/javascript description I've tried to paste into the fields in my EP file is as follows:

<p>Look to the Black & White photos for the <strong>SHAPE</strong> of the bead. To view the color note the <strong>COLOR NUMBER</strong> beside the color name and <a onclick=/"window.open('http://www.bellinghambeadbazaar.com/images/guatemalanclaycolors.jpg','popup','toolbar=0,scrol lbars=1,location=0,statusbar=0,menubar=0,resizable =1,width=82
5,height=500,left = 400,top = -468'); return false/" href=/"../../../images/guatemalanclaycolors.jpg/">click to see the color guide</a>. The colors are arranged by number.</p>


The error that EasyPopulate spits out is:

1064 - You have an error in your SQL syntax near 'http://www.bellinghambeadbazaar.com/images/guatemalanclaycolors.jpg','popup','to' at line 3
UPDATE products_description SET products_name='2-Pink Stamped Round Tube-Lrg/24-30x10-12mm/Qty 10', products_description='
Look to the Black & White photos for the SHAPE of the bead. To view the color note the COLOR NUMBER beside the color name and click to see the color guide. The colors are arranged by number.
', products_url='
Look to the Black & White photos for the SHAPE of the bead. To view the color note the COLOR NUMBER beside the color name and click to see the color guide. The colors are arranged by number.
' WHERE products_id = '72' AND language_id = '1'
[TEP STOP]



Anyone have any ideas for getting the double quotes in there?

Thanks ahead of time,
Gheffron

[ALElder]

All you should have to do is update you EP you can download:

http://www.oscmax.com/project/easypopulate_attributes

Are you trying to add this in the Description filed?

Adam

[gheffron]

I downloaded the update and installed it, but I wasn't able to get it to work. In fact, I wasn't able to upload any changes at all, as EP told me (upon upload of the modified CSV file) that there wasn't a product model number for the products, and so no changes were made. (I've been using EP successfully for awhile, and I know the model numbers were there.)

Any other ideas?

[ALElder]

Did you try downloading a new export from EP?

Please also post the 1st 2 lines of your EP file so I can see what you are trying to import?

Did you maybe add new fields in the old EP?

Adam

[gheffron]

I figured out how to get it uploading -- I'm on a Mac, so I had to save the CSV from Excel as "CSV (Windows)". Victory on that front.

And I figured out the other problem as well. I'd had escaped characters in my code (since I was trying to get them into the system via the old version of EasyPopulate). Once I removed them -- i.e. replaced them with the standard code -- everything worked perfectly.

Thanks so much!