Skip to main content
Question

Line Feed on FSM Import

D
Do Gooder (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+4
  • HelenS
  • Do Gooder (Employee)
  • 11 replies
  • 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
Do Gooder (Partner)
Forum|alt.badge.img+6
  • Damodaran
  • Author
  • Do Gooder (Partner)
  • 12 replies
  • 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+4
  • HelenS
  • Do Gooder (Employee)
  • 11 replies
  • 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

Reply


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings