Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only

  • 1.  CSV Not Producing Comma Delimited Files After Parameter Change

    Posted Mon April 25, 2022 12:47 PM
    We are trying to change Cognos from producing tab delimited files to comma delimited files when running reports as csv. 

    We had updated batchreportservices and reportservices to include the following parameters and restarted Cognos. 

    Parameter

    Value

    RSVP.FILE.EXTENSION.XLS

    TRUE

    RSVP.CSV.DELIMITER

    ,

    RSVP.EXCEL.EXCEL_2007_LARGE_WORKSHEET

    TRUE

    RSVP.CSV.TERMINATOR

    CRLF

    RSVP.CSV.ENCODING

    Windows-1255

    RSVP.CSV.MIMETYPE

    Application/csv

    After the restart, run as csv is still producing tab delimited files. Has anyone else expired this?

    We are on Cognos 11.1.7.

    ------------------------------
    Elizabeth Johnson
    ------------------------------


    #CognosAnalyticswithWatson


  • 2.  RE: CSV Not Producing Comma Delimited Files After Parameter Change

    Posted Tue April 26, 2022 01:05 PM

    Hi Elizabeth,

    Your parameters look like what we've had for years too!

    We're still on 11.1.5 BUT, I noticed with the RSVP.CSV.MIMETYPE, ours is set to:

    applicaton/csv

    Notice the incorrectly spelled "applicaton" and that it's all lowercase.  As far as we know IBM has never fixed the parameter spelling (maybe they accept both now?) so we have to still spell it incorrectly for it to work.  Also for the large worksheet, at least for us we had to specify the Max rows or the large worksheet setting didn't work.  These are our settings (and yes both in BatchReportService & ReportService):

    RSVP.FILE.EXTENSION.XLS TRUE
    RSVP.CSV.MIMETYPE applicaton/csv
    RSVP.CSV.DELIMITER ,
    RSVP.CSV.ENCODING utf-8
    RSVP.EXCEL.EXCEL_2007_LARGE_WORKSHEET TRUE
    RSVP.EXCEL.EXCEL_2007_WORKSHEET_MAXIMUM_ROWS 1000000


    Let me know if that helps.


    Wayne



    ------------------------------
    Wayne Westlake
    ------------------------------

    Original Message


  • 3.  RE: CSV Not Producing Comma Delimited Files After Parameter Change

    Posted Wed May 11, 2022 09:24 AM
    We changed to the incorrect spelling of application, but that did not seem to solve the issue. These are the parameters we have set for agentservices, batchreportservices, and reportservices. 

    RSVP.FILE.EXTENSION.XLS TRUE
    RSVP.CSV.DELIMETER ,
    RSVP.CSV.TERMINATOR CRLF
    RSVP.CSV.MIMETYPE applicaton/csv
    RSVP.CSV.ENCODING utf-8
    RSVP.CSV.QUALIFER "


    ------------------------------
    Elizabeth Johnson
    ------------------------------

    Original Message


  • 4.  RE: CSV Not Producing Comma Delimited Files After Parameter Change

    Posted Wed May 11, 2022 11:40 AM
    What IF/FixPack are you on with 11.1.7?  Have you opened a support ticket?

    I'm curious if it's a new bug or maybe one that has already been patched.  Either way IBM support should be able to direct you.

    Please let me/us know what you find out.

    Thanks!


    Wayne

    ------------------------------
    Wayne Westlake
    ------------------------------

    Original Message


  • 5.  RE: CSV Not Producing Comma Delimited Files After Parameter Change

    Posted Wed May 11, 2022 12:00 PM
    Hi,

    Did you try for RSVP.CSV.MIMETYPE, the default value from the documentation: application/vnd.ms-excel?

    Best regards,



    ------------------------------
    Patrick Neveu
    Positive Thinking Company
    ------------------------------

    Original Message