Forum Discussion

Kai's avatar
Kai
New Contributor III
2 years ago
Solved

Application Database Folder and System Database Folder

I am wondering where are the files in the Application Database Folder and System Database Folder physically stored? I am able to find the files under FileShare in the directory where OneStream is ins...
Infrastructure
  • MarcusH's avatar
    MarcusH
    2 years ago

    These refer to the databases that OneStream maintains. If you go to the System tab and select Tools | Database you will see something like this:

    Expand Tables and then go to the table FileContents in either of the databases. That is where the data resides.

Kai's avatar
Kai
New Contributor III
2 years ago

Thank you Peter! I am able to find the Fileshare folders. Do you know where we can find the Application Database Folder and System Database Folder, as shown below (Not the Applications and System folder within FileShare Folder)? Thank you

 

MarcusH's avatar
MarcusH
Valued Contributor
2 years ago

These refer to the databases that OneStream maintains. If you go to the System tab and select Tools | Database you will see something like this:

Expand Tables and then go to the table FileContents in either of the databases. That is where the data resides.

  • Kai's avatar
    Kai
    New Contributor III
    2 years ago

    Hi Marcus, 

    Thank you for your response. This is what I am thinking as well. In the table structure, there are three relevant tables - FileContents, FileInfo and Folder. In the FileContents table, the ContentFileBytes column saved file data in Bytes. I guess OneStream stores files such as word, excel, pdf as Bytes. Do you think this is the case? Thank you

     

    • MarcusH's avatar
      MarcusH
      Valued Contributor
      2 years ago

      You are correct - they are stored as bytes. You use the XFFile and XFFileInfo functions to read and write the documents.

      • Kai's avatar
        Kai
        New Contributor III
        2 years ago

        This is wonderful. Thank you very much Marcus

        Kai