Extra spacing with SQL export/import

[Get Em Fast]

I've got a problem that I hope somebody can help me with. I've got to restore product listings with an SQL backup. Everything works fine, except in the product descriptions, where every line break or paragraph break should be, there's like double to triple the normal space. Is there a quick and easy way to fix this? I've exported/imported the table in every format that phpMyAdmin lets me do it in, also zipped and gzipped, and it's the same every time.
Any ideas?

[Get Em Fast]

Hmmm. Nobody? DrByte, you have any idea how to solve this?

[fairestcape]

Product descriptions are stored as HTML in the database, so whatever is HTML formatted there will render on your browser.

What you may care to do is "clip" a copy of a particular product description HTML off one of those data dumps you did - and then "paste" it into a HTML Editor to see how the browser is interpreting it.

If you're getting too many line / paragraph breaks, it could be an excessive quantity of <BR /> tags, or <P> tags.

You may also have some settings in your stylesheet that affect body text, so check your CSS too.

[Get Em Fast]

Fairestcape, Thanks for the reply. Yes, there IS an exceptional number of <br>'s and <p>'s in there, as stated in my original post (where every line break or paragraph break should be, there's like double to triple the normal space). That's the problem. I was just needing to know why they're being inserted in there, and how to stop this from happening. I've done this countless times, and have NEVER had this problem. But this one has got me pulling hair, and I'm 40 this year............I don't have the hair to spare............

You know, in the css, I CAN put ".biggerText p{font-size: 0.2em;}", and that DOES seem to take the extra space away, but then on other pages, the text is "microscopic", which is ALL controlled by the same div. I just don't get it.

Anybody wanna take a look, please pm me for the URL, as this is for a client, and I really don't feel comfortable posting it in an "open" forum.

Thanks.

[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.