Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Change CSV Separator

  1. #1

    Default Change CSV Separator

    Hi all,

    In internalization forum I reply a post about change CSV separator in pentaho reporting.

    I think will be interesting to move this post here.

    I don't know if it's possible. Anybody can help me?

    the post http://forums.pentaho.org/showthread.php?t=62240

    Thanks all.

    The finally repply at post:

    You can modify these parameters (CSV separators) in jar of Pentaho-reporting that you were finding in the directory /lib of your pentaho reporting's installation.
    (for example pentaho-reporting-engine-classic-0.8.9-pre10.jar)
    You must modify in the files configuration.properties the follow property
    Org.jfree.report.modules.output.table.csv. Separato r =, putting org.jfree.report.modules.output.table.csv. Separato r = || (or your desired separator)

    Modify it in the following directories:

    \org\jfree\report\modules\output\table\csv\configuration.properties \org\jfree\report\modules\output\csv\configuration .properties

    It's all
    Enric Biosca
    Project Director at ICA

  2. #2
    Join Date
    Mar 2003
    Posts
    8,085

    Default

    Hmm .. modifying the internal fall-back configuration is never a good idea. Updating the jars later will become a minefield, you probably dont want to go that way.

    You can achive the same effect of setting a global default for the CSV separator by creating a "jfreereport.properties" file in the root of the classpath (in case of a WEB-Appliction, put this file into the "WEB-INF/classes" directory) and add the configuration setting there. The user-configuration defined in this file overrides the built-in defaults.
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

  3. #3

    Default

    Hi Taqua

    This solution is BETTER than modify internal jar.

    I tried and it's work very fine.

    Only need puts this line at jfreereport.properties

    Org.jfree.report.modules.output.table.csv. Separator=||


    Soory all an thank you very much Taqua. I think about the properties file but not the correct file.
    Enric Biosca
    Project Director at ICA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.