000032479 - Colon is appended to report output for cross-reference field when exported to XLS or CSV in RSA Archer

Document created by RSA Customer Support Employee on Jun 14, 2016•Last modified by RSA Customer Support on Sep 19, 2019
Version 3Show Document
  • Comment • 0
  • View in full screen mode

Article Content

Article Number000032479
Applies ToRSA Product Set:  Archer
RSA Version/Condition: 5.5.3.1 through 6.2
Issue

A colon is appended to report output for cross-reference field when exported to XLS or CSV in RSA Archer in the following scenario:



  1. Link a record to any record at the top level of a related application. (Where the related application is leveled, and the cross-reference field is configured to link to all levels.)
  2. Create a report for the primary application that includes only the key field and the and cross reference field used in step 1.
  3. Export the results to XLS.
  4. The value in the cross-reference field column will have a colon appended to the end.
CauseThis has been reported as software defect ARCHERSOL-2567 (CSV and XLS export from a leveled application produces occasional trailing colon).

 
ResolutionARCHERSOL-2567 (CSV and XLS export from a leveled application produces occasional trailing colon) is fixed in Solution Master 6.3.
WorkaroundIf you export the report to XML, the colons are not added to the cross-reference field. You can then create a blank Excel document and import the XML file into it, and it will not have the colons. To do that,
  1. Save the report output as an XML file.
  2. Open a new, blank Excel document.
  3. On the ribbon, click the Data tab.
  4. Click From Other Sources.
  5. Select From XML Data Import.
  6. Browse to the XML file and follow the instructions in the wizard.

Attachments

    Outcomes