Forum Discussion

kmd's avatar
kmd
Contributor
6 months ago

Export ALL import stage data - is this possible?

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

Data Integration
Import
  • Steven's avatar
    Steven
    Contributor II
    6 months ago

    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).