Details about this thread
  • State Verified Answer
  • Replies 11 replies
  • Subscribers 309 subscribers
  • Views 5006 views
  • Users 0 members are here
Related content from around SugarClub

How to make linebreaks in an import - i.e. text for the "Description" field (TinyMCS)?

Kristjan Geir Mathiesen

Hi good people.

How can I format my text for the "Description" field in my csv file so that I get a nice text with line breaks once I´m done importing into Sugar?

Here is my attempt in the csv file:

that produces this results:

As you can see, the <br> was stripped out but did not produce a new line. Get the same result with <p>, i.e. no new line.

Thanks,

KGM

Parents Reply Children
  • 0 in reply to Kristjan Geir Mathiesen

    Most likely there is some code that automatically escapes the \r\n during the import. Can you query what you see in the database in emails_text for this record?
    Query should be:

    SELECT description FROM emails_text WHERE email_id IN (SELECT id FROM emails WHERE id = 'id here');

    Replace id here with the actual uuid of the email you are viewing. I.e. http://sugar_ip/sugar_installation_folder/index.php#Emails/the_id_is_a_long_string_of_numbers_and_letters_here