Clarity

  • Private Community

  • 1.  Is there a way to increase limit on number of rows exported to csv from Clarity?

    Posted Mar 11, 2019 09:26 AM

    Hi Experts,

     

    I have a 50k limit for exporting to excel (data only) in the memory.properties file.

     

    I understand this limit is for excel (data only) and not csv. 

    On exporting to csv, i get 25k records in the csv file. Wondering if there is a way to increase the limit for csv exports as well.

     

    regards,
    D



  • 2.  Re: Is there a way to increase limit on number of rows exported to csv from Clarity?

    Posted Mar 11, 2019 11:35 AM

    If you look at

    Excel Export query 

    there does not seem to be an option for that.



  • 3.  Re: Is there a way to increase limit on number of rows exported to csv from Clarity?

    Broadcom Employee
    Posted Mar 11, 2019 11:39 AM

    Hi Martii

     

    These are the flags in the governor.property file 

     

    #Maximum records allowed for CSV export
    E2CSV_MAX_ROWS=25000
    #Timer for Export to CSV.
    E2CSV_TIMER=1800



  • 4.  Re: Is there a way to increase limit on number of rows exported to csv from Clarity?

    Posted Mar 11, 2019 11:52 AM

    Sorry, just looked at the other post.



  • 5.  Re: Is there a way to increase limit on number of rows exported to csv from Clarity?

    Posted Mar 11, 2019 10:23 PM

    Thank you for passing on, as we are also very interested in increasing this.  My observation with exporting large volumes of data via Export to Excel, it looks like this is undertaking using XML, and Excel then takes a very long time to read the XML data.  Using CSV the import is significantly faster.