Export to .csv file limit

Hello experts,
Does anyone know what is limitation for Export to .csv?
It seams that for FTQ is 350 rows, and RTQ is 1000?
Can anyone confirm that?

Thanks,
Ela

Comments

  • The actual number of rows varies based on the columns and amount of data that is getting exported. If you have large string cols (eg char 1024), the number of rows will be less. With limited amount of columns, we are able to export 3000 rows.

  • Thanks Guru!

  • FYI - this seems to be a limitation on the memory allocated for the library xcp uses to Export CSV. We submitted a ticket to Opentext to see if we can adjust these limits and were told - No. If you have requirement to support larger number of rows exported, please submit ticket/enhancement request as well. The more customers ask for same enhancement request, the higher visibility the request get for product team to see.

  • Hi Johnny,
    thank you for response, we will see what we can do about it.

  • I think limits FTQ 350 (FTQ = Full Text Query?) and RTQ 1000 (RTQ = Relational Table Query?) are not related to the CSV export function.

    They should come from search engine settings: https://msroth.wordpress.com/2010/07/05/query-results-truncated

    (..)discussing whether Content Server truncated result sets for large queries (..) 1000 rows or 350 rows from any single source (the default values for dfc.search.max_results and dfc.search.max_results_per_source in the dfc.properties file).

  • We bumped up the max search results to 5000 and got errors. After submitting ticket with Opentext, they acknowledge that it has to do with how much data is sent to the library. We saw that we could get about 3000 rows with about dozen columns exported with no issue.