General
Start Topic
default userpic

Convert line breaks all entries (imported entries)

By Squegie on Feb 7, 2010 at 12:00 PM 4 Vote 0 Votes

Hi,

I imported entries from a Wordpress blog into movable type. Everything worked out really well, except all the paragraphs run together. If I edit an entry, change format from Rich Text to "Convert Line Breaks", then convert it back to Rich Text, the entry is fixed.

Is there a method to do this against all of the entries/pages through MovableType, or would I need to manipulate the database directly?

Reported on Movable Type 5

4 Replies

| Add a Reply
  • user-pic
    Author Profile Page Mihai Bocsaru | February 7, 2010 1:56 PM | Reply

    What I would recommend is that you connect to the database using a tool like phpmyadmin and you change the 'entry_convert_breaks' column values from "Rich Text" to "Convert Line Breaks".

    You would first play with an entry and see which value is assigned to "Rich Text" and which one to "Convert Line Breaks".

    Then you would write an SQL command which to update the 'entry_convert_breaks' column from inside the 'mt_entry' table where the 'entry_convert_breaks' is set to something, and the blog id is something, the 'entry_convert_breaks' column' will be something else...

  • default userpic
    Author Profile Page Squegie | February 7, 2010 2:36 PM | Reply

    Thanks for the reply Mihai.

    I was under the impression that selecting "Convert Line Breaks" performed a browser/client-side conversion to convert line breaks into

    tags. The change only takes place in the browser until you press the Update button.

    If that is the case, then a database edit would require retrieving the entry content from the database, using a regex to parse the text, and then updating the database.

    If it turns out I just have to change one column (and publish), that sounds much simpler. I can try updating it for 1-2 entries, publishing and seeing what happens.

  • user-pic
    Author Profile Page Mihai Bocsaru | February 7, 2010 3:00 PM | Reply

    You're welcome!

    I'm an experienced developer, so just trust my judgement and you would solve the problem in an effective manner ;)

    • default userpic
      Author Profile Page Squegie replied to Mihai Bocsaru | February 7, 2010 7:32 PM | Reply

      Well this worked. Thanks for the great suggestion. 

      mysql> select entry_id, entry_basename, entry_convert_breaks from mt_entry where entry_convert_breaks IS NOT NULL;
+----------+-----------------------------+----------------------+
| entry_id | entry_basename              | entry_convert_breaks |
+----------+-----------------------------+----------------------+
|      470 | allaboutjohn                | richtext             |
|      471 | site-history                | __default__          |
|      478 | material-things             | __default__          |
|      534 | lentils                     | __default__          |
|      538 | scattered                   | richtext             |
|      539 | floor-fan                   | __default__          |
|      548 | honeymoon-pictures          | 0                    |
|      550 | website_maintenance         | richtext             |
|      549 | basement-junk-and-treasures | __default__          |
+----------+-----------------------------+----------------------+
9 rows in set (0.00 sec)


      mysql>  update mt_entry set entry_convert_breaks = "__default__" where entry_convert_breaks IS NOT NULL;

Add a Reply

If you need to share template code, replace all the "<" signs with "&lt;" or use this utility.

Forum Groups

1773 6162

Last Topic: Excluding categories from blog by kholechek on Feb 9, 2012

86 302

Last Topic: website entries by masoud on Oct 26, 2011

1429 5077

Last Topic: What apocalypse hit this community in the middle of 2011? by 75th on Feb 10, 2012

695 2910

Last Topic: Insert Image / File Fails by Russ Miller on Feb 10, 2012

84 291

Last Topic: How to have some other characters in entry basename automatically written by Afshin Haghighatnia on Dec 22, 2011

173 737

Last Topic: About the MT version stated in HTML source by Alex E. Schneider on Feb 7, 2012

190 567

Last Topic: Analytics Reporting by michael webster on Feb 5, 2012

26 95

Last Topic: How do ProNet Licensees Get Current Versions of Movable Type? by Bill on Aug 28, 2011

48 210

Last Topic: An idea and also a request by Afshin Haghighatnia on Jun 29, 2011

64 246

Last Topic: jQuery in MT 5.1 still at 1.4 - why? by perlmonkey on May 25, 2011

code.sixapart.com

137 478

Last Topic: Getting a thumbnail with xpath by Peter on Mar 13, 2011

222 720

Last Topic: Custom Field for Asset Not Appearing by android on Feb 9, 2012