06-20-2024 08:25 AM
If one is not a coder and one is not a SQL expert; is there any possible way to export the entire staged data set from the Import stage to a text or csv file?
I need to be able to extract the resulting table after the source data goes through the Data Source process and sits at the import stage, but as we know, the export command does not extract more than the first page of data and it would be unfeasible to manually export each of say 95 pages.
Surely there must be some easy way to do this? Would be grateful for any advice, tips, examples,
Thanks
06-20-2024 09:14 AM
kmd,
I am not aware of a way to do this without using a business rule/ sql code; however, have you set your "Grid Rows Per Page" in your user security to 1000? This is the max rows you will see on a grid and may decrease the number of pages you need to export. If you don't have access to the security (on the sytstem tab), when you export the grid, see how many rows show up. if it is 50 (by default), ask your administrator to increase this to 1000 (the max setting).
06-20-2024 09:48 AM
Hi @kmd,
Unfortunately, if you have over 1000 rows the only way is going to be via a business rule.
This post should help you with the required code / steps: