Hi JWT007,
Are you seeing this behavior on standard ItemTypes? If so, could you specify which one(s), so I can take a look at this in a more current version to see if this is still present?
Chris
Hi Christopher, thanks for the quick response.
Unfortunately (if I am not mistaken) the only OOTB FormattedText property in the Aras InnovatorSolutions database is on the "Help" ItemType - which is empty by default.
So while I am sure I could fudge some broken data :) I am not sure that would prove anything.
In our customer project we have some item types that rely heavily on the FormattedText fields - but all in custom item-types.
I see. I set up a custom ItemType with a formatted text property then and tested this in a local 12.0 SP4 instance. While I'm not seeing anything unexpected, I'm also testing it with relatively simple data.
Are you able to elaborate on how the formatted text field is being used and what kind of data you're trying to retrieve? Are you trying to access a list of values stored inside of an HTML table for instance?
Chris
Nothing special some fields have a bold header .. few are more than a few lines long.
Here an example (have to obfuscate a bit to not get in trouble with the customer :P)
To be implemented by FOO BAR team for FOO-XYZ (ref. ABC_CFG_001-PTF Configuration management throught MMI).
To be implemented by FOO L2 team for FOO-AAA.
FOO-AAA is not operational yet and not handed over to OPS, but must be kept aligned to FOO-XYZ.
In the database is the following:
<html> <head></head> <body > <span lang="EN-GB" style="mso-ansi-language:EN-GB">To be implemented by <span style="mso-spacerun:yes"> </span>FOO BAR team for FOO-XYZ (ref. ABC_CFG_001-PTF Configuration management throught MMI).<br />To be implemented by FOO L2 team for FOO-AAA.<br />FOO-AAA is not operational yet and not handed over to OPS, but must be kept aligned to FOO-XYZ. <o:p></o:p></span></body> </html>
In this case, the problem is the undefined namespace prefix 'o' ("<o:p></o:p>")
Thanks for the clarification. The trailing <o:p></o:p> at the end looks like a empty paragraph. I tried reproducing this in my 12.0 SP4 instance also trying to add the empty paragraph at the end, and I'm not seeing the same behavior. The HTML itself looks more condensed though this could be because I don't have multiple languages enabled in my environment. Additionally, it seems any trailing whitespace is trimmed from the field before being saved.
I'd argue your intuition was correct that this has already been addressed in more recent versions. It's difficult to say though. As you're more familiar with the exact data causing the issue, I'd be interested to see if you could reproduce this in a newer instance if you get the chance.
As a separate matter, I feel there might be better ways to store this data than a formatted text field. If the FOO BAR team or FOO-XYZ are actual items in the database, using a formatted text field limits the ability to actually link these Items where they're being referenced. Would it make more sense to store this data as a relationship? I could see this being a relationship called Implemented By that has an item property to store the Team doing the implementation, an item property to store who the implementation is being done for, and a text property to store any additional comments. As a customer project with existing data, I understand this might be out of your hands, but I could see it making life easier down the line. :)
Chris
