The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

BenStuart's avatar
BenStuart
New Contributor III
3 years ago
Solved

Move File from Application Database to External Shared Drive

I currently have a metadata file being created by an Extender BR and saved down to the Application Database:   Case Is = ExtenderFunctionType.ExecuteDataMgmtBusinessRuleStep 'Export File Dim f...
Admin
Extenders
System
  • OS_Pizza's avatar
    OS_Pizza
    3 years ago

    You can move any file from onestream to external shared drive.

    '1. Create your session here
Dim sessionOptions As New SessionOptions
		        With sessionOptions
		            .Protocol = WinSCP.Protocol.Sftp
					.Portnumber = 22
		            .HostName = ""
				   .UserName = ""
				   .PrivateKeyPassphrase = ""
		            .SshHostKeyFingerprint = ""
		            .SshPrivateKeyPath = ""
					
				  End With
				  
				  
'2. Send file using the session

				FileName = "FileName.csv"
			    Using session As New Session
		            ' Connect
		            session.Open(sessionOptions)
					Dim LocalDirectory As String = BRApi.FileSystem.GetFileShareFolder(si, FileShareFolderTypes.BatchHarvest, api)
					Dim Dest_folder As String =""
					session.PutFiles(LocalDirectory & FileName, Dest_folder & FileName)
					
		        End Using
BenStuart's avatar
BenStuart
New Contributor III
3 years ago

Hi OS_Pizza,

Does this require me to import any Namespaces? I tried adding the above to my existing Extender rule but it said that SessionOptions was not defined.

Many thanks

OS_Pizza's avatar
OS_Pizza
Contributor III
3 years ago

Absolutely ! Forgot to mention

Imports WinSCP
  • fellow_Ones's avatar
    fellow_Ones
    New Contributor III
    9 months ago

    Hi -

    I am running into below error on sessions even after importing namespaces and included dll in the reference assembly's section.

    I am trying to move/copy multiple files from one stream file share path onto external Azure storage folder.

    Thanks,

     

    • RobbSalzmann's avatar
      RobbSalzmann
      Valued Contributor II
      9 months ago

      Please start a new thread for this.  This thread is three years old and has a solution.
      Also, your code screenshot is unreadable.