Forum Discussion

Wei's avatar
Wei
New Contributor III
4 years ago

Import Data Extracted via data Management using Extensibility Business Rule

Hello - we would like to move specific Forms and Adj data from one application to another - data are extracted via Data Export in DM, does anyone have an example of the Extensibility Rule (BRApi.Fina...
Data Integration
  • NickKroppe's avatar
    NickKroppe
    4 years ago

    Hi,

     

    Below is an example snippet of using the SetDataCellsUsingCsvFile BRApi. As always, please test in a Development application first!

     

     

     

    'get app config settings
Dim configSettings As AppServerConfigSettings = AppServerConfig.GetSettings(si)
'retrieve exported cube data file from a path on the current application's fileshare
Dim folderPath As String = FileShareFolderHelper.GetDataManagementExportUsernameFolderForApp(si, True, configSettings.FileShareRootFolder, si.AppName)
'define the full path including the file name
Dim filePath As String = folderPath & "\SomeFileNameFormsData.csv"
'next check if the file exists on the file share...
If File.Exists(filePath) Then
	'define the source origin members
	Dim sourceOrigins As New List(Of String)
	sourceOrigins.Add("Forms")
	'define target origin member
	Dim targetOrigin As String = "Forms"
	'process the file and load the data - do not load zeros
	BRApi.Finance.Data.SetDataCellsUsingUsingCsvFile(si, filePath, ",", sourceOrigins, targetOrigin, False)
End If

     

     

     

    Nick Kroppe

    OneStream Software

DanielWillis's avatar
DanielWillis
Valued Contributor

Hey Nick,

Not sure what the etiquette is in digging up old posts but I had another question in regards to this. Where should this data be landing once the SetDataCellsUsingUsingCsvFile function is run? Design & Ref says Stage. I couldn't see anything in stage or in the cube however. Tried getting some feedback from the returned XFResult to confirm its working but all I get is BoolValue = True.

 

A small paragraph in the Design & Ref guide is the only place in OneStream documentation I can find this mentioned although it mentions it as SetDataCellsUsingCsvFile rather than SetDataCellsUsingUsingCsvFile so it is hard to find. Am I missing anything?

 

NidhiMangtani's avatar
NidhiMangtani
Contributor III
3 years ago

Hi Daniel,

I had tried setting the target origin member as "Import" and using the SetDataCellsUsingUsingCsvFile function, but it did not work.