Skip to main content

How to add the line feed to the text field (REQUEST_TEXT.TEXT) while importing to FSM through Import/export feature from spreadsheet?

for eg:

in spreadsheet i have data without alignments

“ReasonDesc - 'INSTALLATION                  '; WorkNeededDesc - 'N2/30H/BULK/Monitor “

 

but in FSM under Notes, it should show as below
“ReasonDesc - 'INSTALLATION                    ‘,

WorkNeededDesc - 'N2/30H/BULK/Monitor”

 

is there a way to format the notes while importing to request_text?

 

Thanks & Regards,

Damo

Please also include the text_rft column in you import. 

request_id text text_rtf
  ReasonDesc - 'INSTALLATION                    ‘,
WorkNeededDesc - 'N2/30H/BULK/Monitor		 <p>
ReasonDesc - &#39;INSTALLATION &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;‘,<br>WorkNeededDesc - &#39;N2/30H/BULK/Monitor
</p>

@HelenS - Actually, I tried that too. but it got overridden by text field. when i query the table. i can't see what i imported via spreadsheet for field text_rtf instead it automatically picks html formatting based on the value on text field.

@Damodaran - what type of Note are you adding? I have attached the import file used, exported data once added and screenshots of both Smart & Web client. This is in FSM6 U23 although also tested in U17. 

Reply


Terms & ConditionsCookie settings