Announcement
ABC
Recent Activity
Issue Loading multiple CSV files into custom table using LoadCustomTableUsingDelimitedFile
Hello Fellow OneStream team - I have multiple csv file in a file share folder, using BRApi.Utilities.LoadCustomTableUsingDelimitedFile to do the job, but it's loading only single csv file into the custom table. Below is extender BR , not sure what am I missing in the For loop, guidance is appreciated. Namespace OneStream.BusinessRule.Extender.Load_Table_Data Public Class MainClass Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As ExtenderArgs) As Object Try Select Case args.FunctionType Case Is = ExtenderFunctionType.Unknown 'Select Load options Dim loadMethod As String = "Replace" '<-- Select file load method (Replace, Merge) Dim dbLocation As String = "App" '<-- Specify db type Dim tableName As String = "XFC_OStoSF_BudgetData" '<-- Specify table name to load Dim blnSkipHeader As Boolean = True '<-- Specify if the first row should be skipped (True/False) Dim configSettings As AppServerConfigSettings = AppServerConfig.GetSettings(si) 'Note: file path must be accessible from all application servers Dim xfolderPath As String = FileShareFolderHelper.GetDataManagementExportUsernameFolderForApp(si,True, configsettings.fileShareRootFolder,si.AppToken.AppName) & "\20251014" ' Dim filesToLoad As String = "*_CubeData.csv" Dim fileList = System.IO.Directory.GetFiles(xfolderPath, filesToLoad) ' 'Get list of files to copy For Each file As String In fileList 'Get the file name Dim fileName As String = file.Substring(xfolderPath.Length + 1) BRApi.ErrorLog.LogMessage(si, "FileName:" & fileName) ' Dim fileList = System.IO.Directory.GetFiles() For Each fName As String In fileName 'Define columns that are in the table (this must match the fields in the deminted file) 'Update the fields with the column names/types to match the table being loaded Dim fieldTokens As New List(Of String) fieldTokens.Add("xfText#:[Cube]") fieldTokens.Add("xfText#:[Entity]::NewGuid") fieldTokens.Add("xfText#:[Parent]") fieldTokens.Add("xfText#:[Cons]") fieldTokens.Add("xfText#:[Scenario]") fieldTokens.Add("xfText#:[Time]") fieldTokens.Add("xfText#:[View]") fieldTokens.Add("xfText#:[Account]") fieldTokens.Add("xfText#:[Flow]") fieldTokens.Add("xfText#:[Origin]") fieldTokens.Add("xfText#:[IC]") fieldTokens.Add("xfText#:[UD1]") fieldTokens.Add("xfText#:[UD2]") fieldTokens.Add("xfText#:[UD3]") fieldTokens.Add("xfText#:[UD4]") fieldTokens.Add("xfText#:[UD5]") fieldTokens.Add("xfText#:[UD6]") fieldTokens.Add("xfText#:[UD7]") fieldTokens.Add("xfText#:[UD8]") fieldTokens.Add("xfDec#:[Amount]") fieldTokens.Add("xfText#:[HasData]") fieldTokens.Add("xfText#:[Annotation]") fieldTokens.Add("xfText#:[Assumptions]") fieldTokens.Add("xfText#:[AuditComment]") fieldTokens.Add("xfText#:[Footnote]") fieldTokens.Add("xfText#:[VarianceExplanation]") 'Execute file load ' BRApi.Utilities.LoadCustomTableUsingDelimitedFile(si, SourceDataOriginTypes.FromFileShare, filePath & fileName, Nothing, ",", dbLocation, tableName, loadMethod, fieldTokens, blnSkipHeader) BRApi.Utilities.LoadCustomTableUsingDelimitedFile(si, SourceDataOriginTypes.FromFileShare, xfolderPath & "\" & fileName , Nothing, ",", dbLocation, tableName, loadMethod, fieldTokens, blnSkipHeader) Next Next End Select Return Nothing Catch ex As Exception Throw ErrorHandler.LogWrite(si, New XFException(si, ex)) End Try End Function End Class End Namespace
Extract Related components for Dashboard
Hi OneStream experts, Lets say a dashboard has 10 components in DEV and in PROD. Added 11th component in DEV and want to move it to PROD by Extract and Load. Is there any easy way to collect all related components of a dashboard? Manually collecting components is painful. What is the best secured way to collecting objects to move it to PROD? Thanks //Suresh
The OneStream Podcast Season 4 Finale is now Available!
1 MIN READ On the Season 4 finale of The OneStream Podcast, Craig Colby, Co-founder and Chief Success Officer at OneStream, joins Peter Fugere to discuss how advancements in AI and faster deployments are helping OneStream customers work smarter and Take Finance Further. Listen now!
Page Breaks in Excel add-in
We are having an issue with users and page breaks in the excel add-in. Example 1: A user creates a cube view connection and pulls said cube view into an excel worksheet. The result, however, does not render all the rows. There is a page break and they are forced to page through to see the rest of the rows. If I replicate these actions, I do not get the same page break, my results render all the rows on a single page. No page breaks. We went through preferences and other excel settings together to make sure our settings matched. What is causing this to happen? What other things can we try to resolve? The user must have all the rows displayed at once (no page breaks). Example 2: A user creates a quickview only to have the results get cut off with a page break. If I replicate the quickview, the return does not cut off the rows. I get everything on the sheet. Any hints, tips, etc would be most appreciated. We are trying to determine if this is a OneStream issue? Microsoft Issue? Excel Settings? For reference, we are on OS 9.0.1. thank you in advance
Want to report on Workflow Profile Workflow Name (a property on the WF profile step setup)
I'm looking for a way to report on our workflow profile set up - specifically want to be able to pull the workflow profile (the forms step added to the WF) and the associated "Workflow Name" (which is an awful name for this). Workflow Name refers to the tasks on the step: The point is to make sure certain steps are all set up the same way with the same step tasks but I can't determine the best way to do this right now. Looks like the WorkflowProfileAttributes table may possibly show me but I don't know where I can find a listing of what the AttributeIndex equates to on the actual WF set up (design doc shows zero results when searching either of those terms). Any direction or guidance would be very much appreciated!!
Always start in first dashboard/Block
Hi I am trying to make a welcome homepage using Genesis. I would like that the user always arrives at the news block (Green with blue underline) when logging into the system. But if the last time the user was in Reporting then the dashboard starts up in reporting. See red box. As I understand it, it is not a possibility. I think an extra setting below in Property Editor: Startpage Yes/No
