Hi All,
I have to export data from Creatio. the largest table has 1.1 million records and obviously 150 K records that have attachments and objects in rich text control (Notes and attachments).
I am hoping you may point me in the right direction if you have or encounter such a need.
Thank you in advance.
Like
Greetings,
Unfortunately, it is currently not possible to export records from the Attachments detail using the bulk export function. Please be assured that our R&D team is aware of this limitation and is already working on implementing such functionality in future system releases.
Regarding the bulk export of records, let us provide a bit more detail on how the export process works. Records are exported in batches, and the size of each batch is determined by the system setting “ExcelExportBatchSize.”
For example, if you export 100,000 records and the system setting “ExcelExportBatchSize” is set to 10,000, the system will export 10 batches of 10,000 records each. In the end, you will receive one file containing all 100,000 records, so there is no difference for the end user.
Also, you can add a new system setting with code "ExportToExcelTimeout" to control the amount of time the system will try to complete the Excel request. This system setting should be created in the "System settings" section, with the following configuration: The time specified is in milliseconds. We recommend setting the value to 30 minutes (1,800,000 milliseconds), and if this is not enough increase slightly. Please note that system settings can only be created from system administrator user or Supervisor.
Hope this helps.
Have a nice day!