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...
FredLucas's avatar
FredLucas
Icon for OneStream Employee rankOneStream Employee
1 year ago

Hi syedfasiullah,

In that case you might want to export the content of the table to .csv via a business rule.

You could do this by getting the data you want to export into a data table object like this:

Dim dtResult As DataTable
Using dbConnApp As DBConnInfo = BRApi.Database.CreateApplicationDbConnInfo(si) 
  Dim strSQL As New Text.StringBuilder
  strSQL.AppendLine("Select * from TableToExport")
  dtResult = BRApi.Database.ExecuteSqlUsingReader(dbConnApp, strSQL.ToString, False)
End Using

And then use the DataTableToFile function that I've shared on this post:

https://community.onestreamsoftware.com/t5/Workflow-and-Data-Integration/Export-data-using-a-Method-Query/m-p/35630

 

syedfasiullah's avatar
syedfasiullah
New Contributor II
1 year ago

Thank you for providing help, let me try this and get back to you.