Need physical path to file

[HRunyon]

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?

[HRunyon · Accepted solution]

Actually I got it. I was uploading the file to the application DB folder vs. the File Share folder. I was able to get everything to work.

[KKGamer]

Hi HRunyon - Can you share sample BR rules for PGP decryption/encryption? We have a similar requirement for this.

Thanks

[HRunyon]

Hi KKGamer,

OneStream does not include the ability to do the PGP decryption/encryption out of the box, that I know of anyway. We have a third party component called DidiSoft that we use for other apps. We simply leveraged this same component by sending the DLL's to OneStream support and asking that they place them in the integrations folder. DidiSoft requires a license but if you purchase it then I'm happy to send the BR rule that will do the decryption. Their component is very easy to use so my guess is that you would not need a sample, it's literally a few lines of code to do the work. Happy to provide nonetheless.

Thanks

[KKGamer]

Hi HRunyon,

OneStream support recommended us to using DidiSoft for the process, so if you can share more details for the process and provide the BR rules.It will be helpful.

Thanks

[HRunyon]

Hi KKGamer,

Not sure why but I'm unable to reply to this thread. Send an email to hrunyon@compintelligence.com and I'll send you what you need.

Thanks,

[KKGamer]

Hi HRunyon - I have got the information in the private message, thanks very much. 

[HRunyon]

My pleasure