Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Rayan Al Hassanieh (RayanA32)
Murex Systems Sal

Murex Systems Sal
LB
RayanA32 Member since 2018 8 posts
Murex Systems Sal
Posted: Apr 3, 2018
Last activity: Apr 20, 2018
Posted: 3 Apr 2018 7:24 EDT
Last activity: 20 Apr 2018 1:28 EDT
Closed
Solved

Zip Binary File and Word File and downloading the zipped file

Hello,

I need to zip several file and then download the zipped file on a click of a button.

How to create a zip file and how to download it using activity?

***Updated by moderator: Lochan to add Categories***

To see attachments, please log in.
Java and Activities
Data Integration
User Experience

Accepted Solution

Posted: 6 years ago
Posted: 20 Apr 2018 1:28 EDT
Rayan Al Hassanieh (RayanA32)
Murex Systems Sal

Murex Systems Sal
LB

Hello,

 I have solved my issue using custom java code. I the code reads the excel generated from MSOGenerateExcelFile (that is in the ServiceExport folder) and the word template. Zipped both files and downloaded the zip file.

Here is the code (Note: It takes the word file as step page):

Show More

Hello,

 I have solved my issue using custom java code. I the code reads the excel generated from MSOGenerateExcelFile (that is in the ServiceExport folder) and the word template. Zipped both files and downloaded the zip file.

Here is the code (Note: It takes the word file as step page):

String sep = PRFile.separator;
String strOutputDirectory = tools.findPage("pxProcess").getString("pxServiceExportPath");
String strFullPath = strOutputDirectory + sep + FileName;
byte[] tempBytes;
byte[] WordData;
String strFilePath;
///////Getting file data from Service Export
java.net.URLConnection m_client;
java.net.URL url;
java.io.InputStream is;
byte[] buf;
java.io.ByteArrayOutputStream buffer;
{  
try{
     m_client = null;
        is = null;
        is = null;
        buf = null;
        buffer = null;
      //exceptionDescription = "";
      
PRFile file=new PRFile(strFullPath);
      url=file.toURL();
m_client = url.openConnection();
        m_client.setConnectTimeout(15000);
        m_client.setReadTimeout(15000);
is = m_client.getInputStream();
      
buf = new byte[512];
buffer = new java.io.ByteArrayOutputStream();
 
        int timeOutTest = 0;
int n; 
      
while ((n = is.read(buf)) >= 0){
            buffer.write(buf, 0, n);
            timeOutTest = timeOutTest + 1;
}
      
  
        try{
            is.close();
          buffer.close();
            }
        catch(Exception ex){}
      tempBytes=buffer.toByteArray();
 
      
        m_client = null;
        is = null;
        is = null;
        buf = null;
        buffer = null;
 
///Getting the word file
 
// get key to file attachment record
ClipboardPage objRefPage = myStepPage;
 
  
  /// Getting word data
  String strFileName = objRefPage.getString("pyPurpose");
String strFileType = objRefPage.getString("pyFileType");
String wordFilePath = strFileName + (strFileType.startsWith(".") ? strFileType : "." + strFileType);
  
  //String wordFileData = pega_processengine_workutilities.pxGetFileAttachmentContent(objRefPage);
//WordData = new com.pega.pegarules.pub.util.Base64Util().decodeToByteArray(wordFileData);
      
      //
      
 
  WordData=new com.pega.pegarules.pub.util.Base64Util().decodeToByteArray(tools.findPage("Word").getString("pyFileSource"));
  ///Zip Code
  byte[] data=tempBytes;
  java.io.ByteArrayOutputStream baos = new java.io.ByteArrayOutputStream();
  java.util.zip.ZipOutputStream zos = new java.util.zip.ZipOutputStream(baos);
  java.util.zip.ZipEntry entry = new java.util.zip.ZipEntry(FileName);
  entry.setSize(data.length);
  zos.putNextEntry(entry);
  zos.write(data);
      
  java.util.zip.ZipEntry WordEntry = new java.util.zip.ZipEntry(strFileName+"."+strFileType);
  entry.setSize(WordData.length);
  zos.putNextEntry(WordEntry);
  zos.write(WordData);
  zos.closeEntry();
  zos.close();
  
  String result=tools.sendFile((byte[])baos.toByteArray(),FileNameWithoutExt+".zip",false,null,true);
 
 
 
      
      
}catch(java.io.IOException e){
  
}
  
catch(Exception ex){
      oLog.error("Error occured " + ex.getLocalizedMessage());
     // exceptionDescription = "Attachment Base64 generation Failed: " + ex.getLocalizedMessage();
}
 
}
Hope it helps.
 

Show Less
To see attachments, please log in.
Posted: 6 years ago
Posted: 4 Apr 2018 4:27 EDT
Rayan Al Hassanieh (RayanA32)
Murex Systems Sal

Murex Systems Sal
LB

Hi,

All the codes that are in the post are getting the data from the attachments.

But in my case I have a generated excel file with a word file that are not in the clipboard.

The only code that worked for my case is the one with several activities(CreateZipOutputStream,AddZipEntry,CloseZipOutputStream,DownloadZIP) that are in this post: https://collaborate.pega.com/question/how-create-zip-archive-and-attach-case

But the problem is that the zip is still being corrupted even after fixing some part of the code.

What I need is a code that can be inserted inside an activity and just give it the resulted file from MSOGenerateExcelFile with another file and download the zip.

Thank you.

To see attachments, please log in.

Accepted Solution

Posted: 6 years ago
Posted: 20 Apr 2018 1:28 EDT
Rayan Al Hassanieh (RayanA32)
Murex Systems Sal

Murex Systems Sal
LB

Hello,

 I have solved my issue using custom java code. I the code reads the excel generated from MSOGenerateExcelFile (that is in the ServiceExport folder) and the word template. Zipped both files and downloaded the zip file.

Here is the code (Note: It takes the word file as step page):

Show More

Hello,

 I have solved my issue using custom java code. I the code reads the excel generated from MSOGenerateExcelFile (that is in the ServiceExport folder) and the word template. Zipped both files and downloaded the zip file.

Here is the code (Note: It takes the word file as step page):

String sep = PRFile.separator;
String strOutputDirectory = tools.findPage("pxProcess").getString("pxServiceExportPath");
String strFullPath = strOutputDirectory + sep + FileName;
byte[] tempBytes;
byte[] WordData;
String strFilePath;
///////Getting file data from Service Export
java.net.URLConnection m_client;
java.net.URL url;
java.io.InputStream is;
byte[] buf;
java.io.ByteArrayOutputStream buffer;
{  
try{
     m_client = null;
        is = null;
        is = null;
        buf = null;
        buffer = null;
      //exceptionDescription = "";
      
PRFile file=new PRFile(strFullPath);
      url=file.toURL();
m_client = url.openConnection();
        m_client.setConnectTimeout(15000);
        m_client.setReadTimeout(15000);
is = m_client.getInputStream();
      
buf = new byte[512];
buffer = new java.io.ByteArrayOutputStream();
 
        int timeOutTest = 0;
int n; 
      
while ((n = is.read(buf)) >= 0){
            buffer.write(buf, 0, n);
            timeOutTest = timeOutTest + 1;
}
      
  
        try{
            is.close();
          buffer.close();
            }
        catch(Exception ex){}
      tempBytes=buffer.toByteArray();
 
      
        m_client = null;
        is = null;
        is = null;
        buf = null;
        buffer = null;
 
///Getting the word file
 
// get key to file attachment record
ClipboardPage objRefPage = myStepPage;
 
  
  /// Getting word data
  String strFileName = objRefPage.getString("pyPurpose");
String strFileType = objRefPage.getString("pyFileType");
String wordFilePath = strFileName + (strFileType.startsWith(".") ? strFileType : "." + strFileType);
  
  //String wordFileData = pega_processengine_workutilities.pxGetFileAttachmentContent(objRefPage);
//WordData = new com.pega.pegarules.pub.util.Base64Util().decodeToByteArray(wordFileData);
      
      //
      
 
  WordData=new com.pega.pegarules.pub.util.Base64Util().decodeToByteArray(tools.findPage("Word").getString("pyFileSource"));
  ///Zip Code
  byte[] data=tempBytes;
  java.io.ByteArrayOutputStream baos = new java.io.ByteArrayOutputStream();
  java.util.zip.ZipOutputStream zos = new java.util.zip.ZipOutputStream(baos);
  java.util.zip.ZipEntry entry = new java.util.zip.ZipEntry(FileName);
  entry.setSize(data.length);
  zos.putNextEntry(entry);
  zos.write(data);
      
  java.util.zip.ZipEntry WordEntry = new java.util.zip.ZipEntry(strFileName+"."+strFileType);
  entry.setSize(WordData.length);
  zos.putNextEntry(WordEntry);
  zos.write(WordData);
  zos.closeEntry();
  zos.close();
  
  String result=tools.sendFile((byte[])baos.toByteArray(),FileNameWithoutExt+".zip",false,null,true);
 
 
 
      
      
}catch(java.io.IOException e){
  
}
  
catch(Exception ex){
      oLog.error("Error occured " + ex.getLocalizedMessage());
     // exceptionDescription = "Attachment Base64 generation Failed: " + ex.getLocalizedMessage();
}
 
}
Hope it helps.
 

Show Less
To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice