Skip to Content
0
Feb 20, 2008 at 07:00 PM

WebTools 2007 -- Activity Notes -- CR & LF Issues

14 Views

I have a quick and hopefully simple question.

Business Partner Activities such as Emails (via Outlook Integration), Notes (user typed) and other text(s) are stored in B1 and have an issue when viewed within WebTools 07.

The Notes field stored in B1 uses a sequence of chr(13) + char(10) as the carriage return & linefeed <cr><lf>. WebTools simply ignores these control characters and jumbles all the text together as a continuous string not preserving any separation of text. This looks rather ugly.

However, Netpoint tends to recognize </br> (HTML formatting). Any notes typed within Netpoint seem to preserve this formatting just fine.

That leads me to my workaround. My workaround is to put an Insert trigger on the Activity table which Replaces char(13)+char(10) in the ActivityContent field with </br>

Obviously the following workaround wouldn't be supported, but is there a reasonable supported workaround or fix for this issue?

Thanks,

Jason Walters