Importing multiline

SuiteCRM Forum - English Language SuiteCRM General Discussion
#1

Hi Everybody,

I am not sure what I am missing.
I thought that when nl2br is set to true in SugarFieldText.php linebreaks would appear after importing csv. with
/n ?

So my question is what I have to do to import text with line breaks =)

Greetings,

Bogomil

#2

Could anyone help me?

I have tried to import to html field type (as it is importable) but nothing happens.
Also I cant find fields with this data type in mysql…

I need to import very long text to many contacts and need linebreaks!

Thank you in advance

#3

If anyone is interested I have found the solution.

go to custom/include/SugarFields/Fields/Text/SugarFieldText.php

find:

public function getDetailViewSmarty($parentFieldArray, $vardef, $displayParams, $tabindex)  
{ 
    $displayParams['nl2br'] = true; 
    $displayParams['htmlescape'] = true; 
    $displayParams['url2html'] = true; 
    return SugarFieldBase::getDetailViewSmarty($parentFieldArray, $vardef, $displayParams, $tabindex); 
}

Change:

 public function getDetailViewSmarty($parentFieldArray, $vardef, $displayParams, $tabindex)  
{ 
    $displayParams['nl2br'] = true; 
    $displayParams['htmlescape'] = false; 
    $displayParams['url2html'] = true;

Than use in your text for breaks
and do not import via suitecrm but directly to mysql table.

This way every text area displays linebreaks…