Forum Discussion

Nikpowar97's avatar
Nikpowar97
Contributor
3 years ago
Solved

Pick a .csv file stored in the DM Export in Filestore and covert to a .zip file

I am storing a csv file in everyone path in filestore> Data Managemanet>Export> User folder. I want an BR that reads the file and compress (Create new .zip/ Override the .csv to .zip) and store in th...
Admin
Extenders
  • JackLacava's avatar
    JackLacava
    3 years ago

    Never done it myself but a quick googling and StackOverflowing shows you should be able to use the libraries System.IO.Compression.Filesystem and System.IO.Compression, which have a ZipFile class. You might have to reference the necessary DLLs in the rule properties though.

JackLacava's avatar
JackLacava
Honored Contributor
3 years ago

Never done it myself but a quick googling and StackOverflowing shows you should be able to use the libraries System.IO.Compression.Filesystem and System.IO.Compression, which have a ZipFile class. You might have to reference the necessary DLLs in the rule properties though.

  • Nikpowar97's avatar
    Nikpowar97
    Contributor
    3 years ago

    Hi JackLacava ,

     

    You are correct we were missing the dlls  (XF\WinSCPnet.dll; C:\Windows\Microsoft.NET\Framework64\v4.0.30319\System.IO.Compression.dll; System.IO.Compression.FileSystem.dll) to include the Zip file class. We have used the library System.IO.Compression only. Zipfile class won't give you suggestions but will work as expected, 

    Dim ZipFileName As String = "Test.zip"
    Dim ZipFilePath As String = BRApi.FileSystem.GetFileShareFolder(si, FileShareFolderTypes.ApplicationRoot, Nothing) & "\" & si.AppName.Replace(" ", String.Empty) & "\Groups\" & ZipFileName

    ZipFile.CreateFromDirectory(exportFolderPath, ZipFilePath). this will store the the files under the folder path, exportFolderPath on the filepath, ZipFilePath.