How to add Pipe delimiter to Column delimiter options while exporting or scheduling webi report to CSV format ?

How to add Pipe delimiter to Column delimiter options while exporting or scheduling webi report to CSV format ?

Symptom

How to add Pipe (|) delimiter to Column delimiter options while exporting or scheduling webi report to CSV format ?

Environment

  • SAP BusinessObjects Business Intelligence platform 4.2
  • Web Intelligence
  • Tomcat

Resolution

  1. Stop SIA and Tomcat
  2. Navigate to <Tomcat Installation folder>\webapps
  3. Take a backup of the whole folder
  4. Search for “webiviewer.properties”
  5. Open all of the webiviewer.properties files found
  6. Look for the lines:

#CSV Options
#Use space character as separator to insert more values
CSV_CharDelimiter=” ‘
CSV_ColumnSeparator=, ; Tab
CSV_Charset=UTF-8

  1. Add pipe (|) to the “CSV_ColumnSeparator” :   CSV_ColumnSeparator=, ; | Tab
  2. Apply this change to all webiviewer.properties files
  3. Save all  files
  4. Delete Tomcat cache (content of “Tomcat/work/Catalina/localhost” directory)
  5. Start SIA and Tomcat.

Be the first to comment

Leave a Reply

Your email address will not be published.


*