• State Verified Answer
  • Replies 2 replies
  • Subscribers 93 subscribers
  • Views 1332 views
  • Users 0 members are here
Options
Related

How to generate comma separeted csv report.

dnyandev garad
over 3 years ago

Hi All,

I created simple report and subscribed to that report as CSV file but when I receive report it is semicolon separeted.

I want report should be generated and seperated must be comma.

Is there any way to configure this in.

Could yyou please provide your inputs.

Thank you in advance.

Kind Regards,

DG

Parents
  • +1 over 3 years ago

    For performance reasons, we are handling the CSV exports of simple list reports using the CSVExportSingle task of the script component instead of the report component.

    Thing is, that the script that generates the line definitions is using the semicolon as a fixed separation character.

    But you can override the script that generates the line definitions for the simple list reports and replace the semicolon with a comma.

    The method you need to override is called RPS_ParseReportDefinitionXML.

Reply
  • +1 over 3 years ago

    For performance reasons, we are handling the CSV exports of simple list reports using the CSVExportSingle task of the script component instead of the report component.

    Thing is, that the script that generates the line definitions is using the semicolon as a fixed separation character.

    But you can override the script that generates the line definitions for the simple list reports and replace the semicolon with a comma.

    The method you need to override is called RPS_ParseReportDefinitionXML.

Children