Need physical path to file
I am implementing a BR that pulls a file from FTP. The file is encrypted so I need to decrypt it using a third party library. In order to decrypt it, I need to pass in a physical path to the PGP key provided. I uploaded the key to the Public folder share for now but cannot seem to find a way to get the actual physical file. Does anyone know if uploading a file to the share folder results in an actual file being created on the server or is it just stored as a BLOB in the database?
Business Rule for SFTP
Hi - we're trying to PULL files from an SFTP server. These will be used for our OneStream load. Are there any sample BRs that we can reference to facilitate the file transfer from the SFTP server to OneStream? Are there libraries readily available in OS for this? So far, we have completed the following. 1. Whitelisting of OS IP from SFTP Server 2. Received SFTP server and credentials needed Thanks!
Importing a CSV file from from Documents/Public/xyz folder to OneStream Cube
Hi, I have a requirement to import a Cell Details CSV file into OS. My questions are as below: 1. Can we import a CSV file fromDocuments/Public/xyz folder to OneStream Cube? I tried it but it didn't worked. However, I was able to import the CSV from File Share folder. 2. To achieve above, I was trying to copy the CSV file fromDocuments/Public/xyz folder to File Share folder but I am getting an error "Part of the path cannot be found" (SRC Path: Documents/Public/xyz folder). Error: Here is the code to copy a CSV file fromDocuments/Public/xyz folder to File Share folder: If args.CustomCalculateArgs.FunctionName.XFEqualsIgnoreCase("Move_File_from_Public_to_FS_Folder") Dim configSettings As AppServerConfigSettings = AppServerConfig.GetSettings(si) Dim xfolderPath As String = FileShareFolderHelper.GetDataManagementExportUsernameFolderForApp( _ si,True, configsettings.fileShareRootFolder,si.AppToken.AppName) Dim DestinationPath As String = "Cell_Details" Dim ParentPath As String = "Documents/Public" Dim fileToMove As String = "Cell_Details.csv" Dim folderPath As String = BRApi.FileSystem.GetFolder( _ si, FileSystemLocation.ApplicationDatabase, ParentPath & "/" & DestinationPath).XFFolder.FullName brapi.ErrorLog.LogMessage(si, "folderPath:" & folderPath) 'File.Copy(Path.Combine(folderPath & "/" & "Cell_Details.csv"), _ ' Path.Combine(xfolderPath & "/" & "Cell_Details.csv"), True) <--- TRIED THIS COMMAND AS WELL BUT GOT THE SAME ERROR Dim fileBytes As Byte() = File.ReadAllBytes(folderPath & "/" & fileToMove) Using dbConnApp As DBConnInfo = BRApi.Database.CreateApplicationDbConnInfo(si) Dim dbFileInfo As New XFFileInfo( _ FileSystemLocation.ApplicationDatabase, fileToMove, xfolderPath, XFFileType.Unknown) dbFileInfo.ContentFileContainsData = True dbFileInfo.ContentFileExtension = dbFileInfo.Extension Dim dbFile As New XFFile(dbFileInfo, String.Empty, fileBytes) BRApi.FileSystem.InsertOrUpdateFile(si, dbFile) End Using End If Below code is working which copies CSV file from File Share folder to Public folder: If args.CustomCalculateArgs.FunctionName.XFEqualsIgnoreCase("Move_File_from_FS_to_Public_Folder") Dim configSettings As AppServerConfigSettings = AppServerConfig.GetSettings(si) Dim xfolderPath As String = FileShareFolderHelper.GetDataManagementExportUsernameFolderForApp( _ si,True, configsettings.fileShareRootFolder,si.AppToken.AppName) Dim DestinationPath As String = "Cell_Details" Dim ParentPath As String = "Documents/Public" Dim fileToMove As String = "Cell_Details.csv" Dim fileBytes As Byte() = File.ReadAllBytes(xfolderPath & "/" & fileToMove) Dim targetDir As String = BRApi.FileSystem.GetFolder(si, _ FileSystemLocation.ApplicationDatabase, ParentPath & "/" & DestinationPath).XFFolder.FullName Using dbConnApp As DBConnInfo = BRApi.Database.CreateApplicationDbConnInfo(si) Dim dbFileInfo As New XFFileInfo( _ FileSystemLocation.ApplicationDatabase, fileToMove, targetDir, XFFileType.Unknown) dbFileInfo.ContentFileContainsData = True dbFileInfo.ContentFileExtension = dbFileInfo.Extension Dim dbFile As New XFFile(dbFileInfo, String.Empty, fileBytes) BRApi.FileSystem.InsertOrUpdateFile(si, dbFile) End Using End If Appreciate any help. Thanks, Sid
Onestream 6.2.1 Socket Error 10054
Hi All, One of client is facing strange issue while downloading certain files from file share folder. Apparently it is getting timed out while downloading the forecast file. File size is around 550 MB ( I checked the same file from another date which is around 515 MB and there is no issue for the same file) There is no issue for any other files at the moment ( like Actual data or FX data etc ) Questions here are - Is there any limit in terms of size for download from file share folder ? Is there any time-out settings where we can investigate for these errors ? Would deleting temp files from server help here ? ( considering error 10054 is about deleting junk files / temp files ) Just checking if any one seen these errors before for other clients. Thank you. Regards AJFileExplorer - error when accessing FileShare
Hello, I am getting this error when trying to access FileShare under FileExplorer: The path is not of a legal form. . Source code: WcfRetryManager.cs, line 299, method ExecuteRetries. . Source code: WcfRetryManager.cs, line 369, method ExecuteRetriesStartingWithPreferredAppServerIndex. . Source code: WcfRetryManager.cs, line 497, method TryExecuteAction. . Source code: FileSystemWcf.cs, line 198, method EnumFoldersInFolder. . Source code: FileSystemWcf.cs, line 853, method GetFolder. . Source code: FileSystemOS.cs, line 185, method GetFolder. The path is not of a legal form. Has anyone encountered this error previously? To me it seems like an application error but I am not sure where I can check further. Thank you.
Problem with Harvest Directory
Hi everyone, I'm having a problem with the Harvest directory. Indeed, I have two batches running at the same time and which retrieve files from an SFTP to put them in the Harvest directory in order to load them into the WF corresponding to each file, for this I use this line coded : Dim batchInfo As WorkflowBatchFileCollection = BRApi.Utilities.ExecuteFileHarvestBatch(si, fixedScenario, systemTime, valTransform, valIntersect, loadCube, processCube, confirm, autoCertify, False) But with this line I do not filter the files present in Harvest. Is there a way to filter by file name inside Harvest which seems to be common and mandatory? Thank you for your help
Combine data extracts
Does anyone know if it is possible to combine multiple data extracts into one file in OneStream? We have several DM jobs that we want to extract information about what contributes up to parents. We have found no way to do this in one DM job as the filters needed for each just won’t work for multiple rollup points. So alternatively we thought if we could combine those files it would work. Or perhaps a business rule that could somehow loop through the hierarchy we need and ‘build’ the larger file to save to the file explorer?In File Explorer what is the File Share "Contents" folder used for?
Of all the File Share types, the one I least understand is the "Contents" folder. What is it used for? There are even three System Security Roles controlling its use, but no clue in the Design and Reference guide as to what we are meant to use that folder for. Can someone please educate me?
