Forum Discussion

syedfasiullah's avatar
syedfasiullah
New Contributor II
2 years ago

How to download the database table contents to the Excel file .CSV format in OneStream

Hi all, How to download the table contents from the System --> database --> Tables or Views, when I tried to download, it is allowing to download the 50 rows only - I'm not sure where is a restrict...
Goodwin1's avatar
Goodwin1
New Contributor
4 days ago

If you are just trying to get the contents out of the OS table into a csv file, you can create a SQL data adapter and hook it to a grid view component and dashboard. After that, all you have to do is right click on the grid view and export to a csv. 

Alvaro's avatar
Alvaro
New Contributor III
3 days ago

Hi!

In a grid view, you can't download millions of records; each page has a maximum of 1000 records. This method wouldn't be possible for tables with millions of records.

  • Goodwin1's avatar
    Goodwin1
    New Contributor
    3 days ago

    I agree that, if the tables happen to have millions of rows, then grid view probably isn't a viable option. Having said that, I have exported files from the grid view that was far in excess of 1000 records. In fact, I just did one with a tad under 40,000 rows and it worked fine.