Skip to main content
K
Kevin_Werner
Newcomer
February 10, 2023
Solved

WINSCP .filepart extension on SFTP files sent from OneStream

  • February 10, 2023
  • 5 replies
  • 0 views

We created Extensibility BRs that leverage WIN SCP commands to send data from OneStream to an internal directory using an SFTP connection setup with OneStream.  The data files are being received with a .filepart extension.  We were able to get the .filepart feature disabled in our OneStream environment; however, the csv files are continuing to be received with the additional .filepart extension.  Any suggestions on how to eliminate .filepart extension when files are sent / received?

Best answer by mtejjini

 

Hello, use this and you won't have the .filepart extension. Thanksimage.png

5 replies

J
OneStream Employee
JackLacavaOneStream Employee
OneStream Employee
February 10, 2023

This seems more of a winscp question than a OneStream question... In any case, I don't think anyone will be able to help unless you post the actual rule.

S
seburn
Newcomer
February 12, 2023

This worked for me using WINSCP PutFiles command...

Dim sessionOptions As New SessionOptions

With sessionOptions

    .Protocol = Protocol.Sftp

    .HostName = "example.com"

    .UserName = "username"

    .UserName = "password"

    .SshHostKeyFingerprint = "ssh-rsa 2048 ..."

End With

Using session As New Session

    session.Open(sessionOptions)

 

    session.PutFiles("C:\local\path\*.csv", "/remote/path/*").Check()

End Using

S
seburn
Newcomer
February 12, 2023

Snippet sourced from stackoverflow 

https://stackoverflow.com/questions/48556236/upload-file-to-sftp-server-using-vb-net

M
mtejjiniAnswer
Newcomer
February 28, 2023

 

Hello, use this and you won't have the .filepart extension. Thanksimage.png

M
mtejjini
Newcomer
February 28, 2023

mtejjini_0-1677581378382.png

 

K
Kevin_WernerAuthor
Newcomer
March 1, 2023

Thanks for the suggestions.  We did receive a recommendation from OneStream to add the one line of code to the SFTP Business Rule that mtejjini mentioned above.

 -->  transferOptions.ResumeSupport.State = TransferResumeSupportState.Off

Adding this line of code has resolved the issue and we are now able to provide the required data to the SFTP site.

Thanks for the support!!

Terms & ConditionsAccessibility statement