Zip Binary File and Word File and downloading the zipped file

Question

Replies

2556

Views

RayanA32

Member since 2018

8 posts

Murex Systems Sal

Posted: Apr 3, 2018

Last activity: Apr 20, 2018

Closed

Solved

Zip Binary File and Word File and downloading the zipped file

Report

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

Like (0)

Accepted Solution

Posted: 7 years ago

RayanA32

Murex Systems Sal

replied to RayanA32

Report

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):

Hello,

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;

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;

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

View reply inline

To see attachments, please log in.

Posted: 7 years ago

Shekhar_Shubham replied to RayanA32

Report

Hi,

Please refer the below discussion
https://collaborate.pega.com/question/download-multiple-files-external-system-zip-file

Thank You

To see attachments, please log in.

Like (0)

Posted: 7 years ago

RayanA32

Murex Systems Sal

replied to Shekhar_Shubham

Report

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.

Like (0)

Accepted Solution

Posted: 7 years ago

RayanA32

Murex Systems Sal

replied to RayanA32

Report

Hello,

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

Hello,

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;

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;

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.

Like (0)

Question

Zip Binary File and Word File and downloading the zipped file

Need help or want to help others?

Experience the benefits of Support Center when you log in.

Question

Zip Binary File and Word File and downloading the zipped file

Related content:

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