Announcement

Collapse
No announcement yet.

[SOLVED] Exporting more than 1000 records to Excel - Screens and Reports

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [SOLVED] Exporting more than 1000 records to Excel - Screens and Reports

    Hello,

    There is an issue with OTM, where you can't export more than 1000 records from a finder screen to Excel, or from an HTML report to Excel. This is limited via a property on the OTM Web Server's glog.properties file.

    The issue is that the property listed in the properties file is incorrectly named, so that changing it won't update the behavior. The old property is:
    Code:
    glog.webserver.finderresults.maxexportcount
    Instead, you need to add and set the following property:
    Code:
    glog.webserver.finder.export_limit
    Keep in mind that Oracle gives the following suggestions:
    • We do not suggest you use the UI to export large amounts of data (for example, any more than 1000 records)
    • We have identified this as a problem and in version 5.5 have added a property to limit the user to the amount of data that can be exported. (the default is 1000)
    • You should limit the export to smaller data sets and then combine them manually.
    • If you need to export larger volumes than this, we suggest that you use the CSV export functionality.
    This is slated to be fixed in OTM v5.5 CU4 (bug 6319538 and 631952

    Thanks,
    Chris
    Chris Plough
    twitter.com/chrisplough
    MavenWire

  • #2
    Re: [SOLVED] Exporting more than 1000 records to Excel - Screens and Reports

    Hi Chris,

    This is old post but still relevent. Based on you post and suggestion you have listed from oracle, it seems that there would be performance impact if we increase this value to number higher than 1000. Currently in our solution we have set it to 4000 and business is requesting to increase that value as well.

    If possible can you provide some poitner on Performance impact of this change.

    Thank you,
    cshah8
    Thank You,
    cshah8

    Oracle Certified OTM 6 Implementation Specialist
    ------------------------------------------------------------------
    If my post was useful please click Thanks!

    Comment

    Working...
    X