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

Go to security, select your user. Go to preferences and change the Grid Rows Per Page.

 

HC

syedfasiullah's avatar
syedfasiullah
New Contributor II
1 year ago

Thanks Hector - what if I have more than 1000 rows, then how would I do it? I tried that option, it has maximum of only 1000 rows. 

Thanks 

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

  • RobbSalzmann's avatar
    RobbSalzmann
    Valued Contributor II
    7 months ago

    .