Skip to main content
Question

Line Feed on FSM Import

  • March 8, 2023
  • 3 replies
  • 88 views
D
Sidekick (Partner)
Forum|alt.badge.img+6

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

3 replies

H
Do Gooder (Employee)
Forum|alt.badge.img+5
  • HelenS
  • Do Gooder (Employee)
  • March 27, 2023

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>
D
Sidekick (Partner)
Forum|alt.badge.img+6
  • Damodaran
  • Author
  • Sidekick (Partner)
  • March 28, 2023

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

H
Do Gooder (Employee)
Forum|alt.badge.img+5
  • HelenS
  • Do Gooder (Employee)
  • March 28, 2023

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

3 Attachments
Terms & ConditionsCookie settingsAccessibility statement