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, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000032479
Applies ToRSA Product Set: Archer
RSA Version/Condition:
  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 ARCHCE-3318
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. 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.