The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

syedfasiullah's avatar
syedfasiullah
New Contributor II
1 year 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
7 months 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
7 months 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
    7 months 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.