000039451 - Importing a table into a text area field via data feed or data import into Archer

Document created by RSA Customer Support Employee on Dec 18, 2020
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000039451
Applies ToProduct Set: Archer
Version/Condition: 6.x
Product Description: Archer Platform
IssueAttempts to import a full table into a text area field via data feed or data import causes the table to be formatted incorrectly within the Archer record.
While the table looks like this within a web page:
User-added image
Within the Archer record, the field looks like this:
User-added image
ResolutionThe standard html code does build in a web browser if you were to use it to create an .htm file and put it on any website. However, this html does not conform to the TinyEMC rich text editor formatting that the Archer text area field uses.

That means that Archer is doing what it is supposed to do going by the technology being used via the TinyEMC rich text editor.

Here is a sample of the html the field would recognize:
 

<table style="width: 100%; border-collapse: collapse;" border="1">
<tbody>
<tr>
<td style="width: 10%;">table_cat</td>
<td style="width: 10%;">table_schem</td>
<td style="width: 10%;">table_name</td>
<td style="width: 10%;"> </td>
<td style="width: 10%;"> </td>
<td style="width: 10%;"> </td>
<td style="width: 10%;"> </td>
<td style="width: 10%;"> </td>
<td style="width: 10%;"> </td>
<td style="width: 10%;"> </td>
</tr>
<tr>
<td style="width: 10%;">DB2INST1</td>
<td style="width: 10%;">Advise_index</td>
<td style="width: 10%;"> </td>



In conclusion, you will not be able to import the html via data feed or data import without it being converted to the proper html format that can be read and formatted properly by the TinyEMC rich text editor.

Attachments

    Outcomes