Extra spacing with SQL export/import

[fairestcape]

Try this with a TEST selection of products:-

1. Use EasyPop to EXPORT your product data (standard EP export - to your temp folder, which you then FTP back to your local drive).

2. Open up MS Excel (or OpenOffice equivalent if you use it).

3. IMPORT the EasyPop .txt file into the spreadsheet.

4. Now you have your easypop file nicely displayed in the spreadsheet.

5. Delete ALL but 5 rows of product data (choose to keep product data that typically represents your <P> and <BR> problem).

6. Open up MS Word... (yes... MS Word !)

7. Go back to spreadsheet.

8. Highlight the column - v_products_description_1 (probably column D) and "copy" it to clipboard.

9. Toggle to MS Word and "paste" - you now have your column in MS Word, and can use its superior "replace" function.

10. Using search + replace, find instances of <P> that you can replace with "nothing" (you're basically deleting them).

11. When you've gotten rid of the excess <P> and <BR>, HIGLIGHT the whole column in MS Word, copy, then toggle to Excel and "paste" over the original column of the same name.

12. Save as tab-delimited TXT.

13. Make a NOTE of the products that will be changed when you EasyPop this test file back to the dbase.

14. EasyPop upload and insert into dbase in the usual EasyPop manner.

15. Call up the products you changed in this test run to see if the layout is better now.

If this works, then it's one way of getting rid of the excessive tags. Excel "replace" function doesn't work well - thats why I "port" the affected column over to Word, edit it there, then port back to Excel.

[Get Em Fast]

Wow! Sounds like a lot, but I'll sure give it a shot. Anything at this point. I'll let you know how it went.

[fairestcape]

I can't see any logical reason why additional <P> and <BR> tags would be inserted as a consequence an easypop upload (or a SQL query for that matter) - afterall, the dbase does not know it's html - it's just data, for goodness sakes!

I do scores of EP uploads each month - all of them with product description data that's full of HTML tags...

... admittedly, I keep these tags very simple - usually restricting them to BOLD <b>, Bulleted Lists <ul> <li>, Italic <em>, Line break <br> and Paragraph <p>.

How "complex" is the HTML in your product descriptions? There is an "outside" chance that if it's overly-complex or detailed, ZC "re-writes" some of it, but we'd need DrByte to confirm if that's true!

[Get Em Fast]

Well, I never used Easy Populate to do anything. I just use phpMyAdmin and mySQL to do everything, because I've heard a lot of bad stuff about EZP. Everything was exported/imported in SQL form (and every other way, but came back around to this), gzipped, and NEVER extracted or opened. That's why I can't understand where this extra space is coming from. I just don't make since.

[Get Em Fast]

Well, Fairestcape, I think I found the problem. Seems that everywhere that there's a problem, I'm finding (in the product description) this "mso-spacerun", which in turn, is also giving me css validation errors. If you search for "mso-spacerun", you'll find NOTHING but sites with this in their html. I finally searched for "mso properties" and found that this is coming from Microsoft Office (should have known), which I think my client uses to write his product descriptions with.

Now, in knowing all this, is there a way to get rid of all that at one time, or will all the "offending" product descriptions have to be re-written to straighten all this out?

[fairestcape]

Aha ! I too have a client who insists on writing the product descriptions in MSWord, then saving it as "html", then grabbing the code and pastes that into HTMLArea.

It wreaks havoc!

I don't know of any rapid way of removing the unwanted MS tags. If it think of one, I'll let you know.

[Get Em Fast]

Ahhhh, thank you for confirming that that IS INDEED the problem. I'll just have to talk to him and find out what he wants to do, as I think they are all gonna need to be re-wrote (WITHOUT MSO) to make everything look right. Oh, Boy! There's 1200 products. Fun, Fun...................

Well, thanks again, Fairestcape. You've been a BIG help.


Yea, I might have mentioned earlier (a LOT earlier) that I'm currently in the process of updating his site to 1.3.8, which is where I ran into this problem. It seems to work just fine on his old site, but EVERY Product description seems to be different, such as fonts, font sizes, and such. And if some pages looks good, then the rest are messed up. If I get them to look good, then the ones that DID look good, are now messed up. Just one of those things that drives you crazy, ya' know?