Forum Discussion
MarcusH
3 days agoValued Contributor
Books are not exported by Load/Extract; they are text files that can be stored anywhere and might not even be in OneStream. If you are sure all the Books are held in the OneStream database somewhere you can write a Business Rule that queries the FileInfo table to get a list of books that are stored in the database:
SELECT Name, FolderFullName, Description, ContentFileExtension FROM FileInfo WHERE (Name LIKE '%.xfdoc.%')
Process the returned rows and concatenate the FolderFullName and Name fields. Pass that through to BRApi.FileSystem.GetFile and read the file contents to pick out the Cube Views.
You could skip the GetFile step and read the file contents directly from the database:
SELECT FI.Name, FI.FolderFullName, FI.Description, FI.ContentFileExtension, FC.ContentFileBytes
FROM FileInfo AS FI INNER JOIN
FileContents AS FC ON FI.Name = FC.Name AND FI.FolderFullName = FC.FolderFullName
WHERE (FI.Name LIKE '%.xfdoc.%')
Related Content
- 9 months ago