How to create RSA ACE/Server custom reports in a .CSV format for import into a spreadsheet
Originally Published: 2000-10-17
Article Number
Applies To
RSA ACE/Server Reports
TFS Technology's Keon Security Server (KSS) 4.5
Microsoft Excel
Microsoft Windows
Report Creation Utility
Issue
All custom reports made from the RSA ACE/Server are currently created using a '|' (pipe), the Table delimiter. It is possible to reconfigure a spreadsheet application such as Microsoft Excel to use this character when importing tables (with Excel you need only rename the file to have a .XLS extension). However, most spreadsheets and other applications, including TFS Technology's Keon Security Server, are able to import from a CSV (Comma Separated Values) file. These will have a .CSV file extension and use the ',' (comma) as the delimiter.
Resolution
Find the lines:
IF rpt-format = 2 THEN DO:
dir-name = dir-name + "/" + "mytest" + ".xls".
OUTPUT TO VALUE(dir-name).
PUT "LocalDate| LocalTOD| ShortMessage| UserName| Login| AffectedUserName| TokenSerialNum| ClientName| GroupName| SiteName| GMTDate| GMTOD" SKIP.
and change the ".xls" to ".csv", to look like this:
IF rpt-format = 2 THEN DO:
dir-name = dir-name + "/" + "mytest" + ".csv".
OUTPUT TO VALUE(dir-name).
PUT "LocalDate, LocalTOD, ShortMessage, UserName, Login, AffectedUserName, TokenSerialNum, ClientName, GroupName, SiteName, GMTDate, GMTOD" SKIP.
Save the file. Open logpipe.i with an editor, and replace all instances of "|" (pipe) with ","(comma).
Run the report again. This will create the required .CSV file. This procedure only works with custom reports.
Related Articles
CSV Data Collectors of Data Source Type Database do not populate all fields with data when joining multiple CSV files in R… Number of Views Getting a Request could not be handled error when trying to change the certificate store on RSA Via Lifecycle & Governance… Number of Views Authentication Manager Bulk Admin (AMBA) script fails to run with “Invalid header field name” error Number of Views Is there a way to enforce passphrase to certificates requested by user with RCM ? Number of Views Creating a custom attribute and reporting on it in RSA Authentication Manager 8.2 SP1 or later Number of Views
Trending Articles
Downloading RSA Authentication Manager license files or RSA Software token seed records RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory Mandatory Certificate Upgrade Required by 6th October 2025 for RSA MFA Agent for PAM, RSA MFA Agent for Apache, and Third … RSA Authentication Manager 8.9 Release Notes (January 2026)
Don't see what you're looking for?
