topic Re: Best way to download files from Windchill Server to client in Windchill Customization

Best way to download files from Windchill Server to client

MV_10441462 — Fri, 15 Mar 2024 14:02:00 GMT

I'm looking to download a zip from my windchill server(temp location) to the client machine.

The zip was actually created as a result of an custom action.

So basically, when I click on the action a zip should get downloaded, that's my requirement.

Please suggest me your ideas or share me any existing solution.

Many thanks in advance.

Re: Best way to download files from Windchill Server to client

avillanueva — Tue, 28 Feb 2023 15:28:58 GMT

I did this with a JSP tied to that custom action:

BOMExportExcelUtility excelUtil=BOMExportExcelUtilityImpl.createBOMExportExcelUtility(); //7. Sub-module create Excel File for user download response.reset(); excelUtil.createExcelFile(response.getOutputStream(),sheet1,sheet2); ServletOutputStream outs = response.getOutputStream(); response.setHeader("Content-type","application/ms-excel"); String version=VersionControlHelper.getVersionIdentifier((Versioned)bom).getValue(); if (version.indexOf('.')!=-1) version=version.substring(0, version.indexOf('.')); //just get first part String filename=bom.getNumber()+version; response.setHeader("Content-disposition","attachment; filename="+filename+".XLS");//should prompt for download excelUtil.writeFile(); //8. Return response to user's browser session. outs.flush(); outs.close();

This is the section where my code creates an XLS file and streams it back to the client. User downloads the file.

Re: Best way to download files from Windchill Server to client

HelesicPetr — Wed, 01 Mar 2023 06:30:14 GMT

Hi @MV_10441462

example from @avillanueva is very good one how to download file.

I would add that you need to write own sollution.

Create zip in java

Collect files from Windchill

Add files to the zip

push the zip stream to the client user

PetrH

Re: Best way to download files from Windchill Server to client

MV_10441462 — Wed, 01 Mar 2023 06:33:35 GMT

Hi @HelesicPetr

Can you please help me with the snippet to push the zip stream to client user?

Re: Best way to download files from Windchill Server to client

HelesicPetr — Wed, 01 Mar 2023 08:07:58 GMT

Hi @MV_10441462

depends how do you start your function.

usually you get request and get the outputstream from it and flush (send) the data to the client as @avillanueva's example shows you. .

here is short snip with a zipStream but you need to learn how to add files to the zip stream

HTTPResponse resp; // you need to get respons from commandBean or whereever HttpServletResponse response = nmCommandBean.getResponse(); ByteArrayOutputStream zipOut = new ByteArrayOutputStream(); CheckedOutputStream checksum = new CheckedOutputStream(zipOut, new Adler32()); ZipOutputStream zipOutputStream = new ZipOutputStream(new BufferedOutputStream(checksum)); InputStream contentStream = ContentServerHelper.service.findContentStream(appDatatToZip); // definice filename s cestou v zip String fileZipEntry = appDatatToZip.getFileName(); addStreamToZip(fileZipEntry, zipOutputStream, contentStream); // annother sub method where the content is writen to zip zipOutputStream.close(); OutputStream output = resp.getOutputStream(); resp.setHeader("Content-disposition", "attachment; filename=zipDownloadFile.zip"); resp.setHeader("Content-Type", "application/zip"); output.write(zipOut.toByteArray()); // zip stream written to the respons outputStream output.flush(); output.close();

PetrH

Re: Best way to download files from Windchill Server to client

mprotas — Mon, 15 Apr 2024 11:14:49 GMT

@HelesicPetr- how can I overwrite the HttpServletResponse from NmCommandBean::getResponse() when whenever I try to use this method I retrieve IllegalStateException - Already using writer?

I want to perform downloading .zip file generated on the server-side from Wizard's FormProcessor. Is there any solution for that? Here is my example code of custom FormProcessor:

private ExportPackageFileManager fileManager; @Override public FormResult doOperation(NmCommandBean nmCommandBean, List<ObjectBean> list) throws WTException { FormResult result = super.doOperation(nmCommandBean, list); WTPart contextPart = (WTPart) WizardUtils.getContextObject(nmCommandBean); setFileManager(contextPart); HttpServletResponse response = nmCommandBean.getResponse(); Path path = fileManager.getZipFilePath(); String fileName = path.getFileName().toString(); response.reset(); try(ServletOutputStream outputStream = response.getOutputStream()) { response.setStatus(200); response.setHeader("X-Content-Type-Options", null); response.setHeader("Content-Type", "application/zip"); response.setHeader("Content-disposition", "attachment; filename=" + fileName); response.setContentLength((int) path.toFile().length()); Files.copy(path, outputStream); result.addDynamicRefreshInfo(new DynamicRefreshInfo(contextPart, contextPart, DynamicRefreshInfo.Action.UPDATE)); return result; } catch (IOException | IllegalStateException e) { throw new WTException("Could not send file!"); } }

Whole logic for fetching files, zipping them works just fine. Whenever I click "Submit" button on my Wizard - window freezes and won't close automatically.

response.reset() is being used to avoid getting IllegalStateException but on the other hand it causes the window to freeze.

Thanks in advance.

Re: Best way to download files from Windchill Server to client

HelesicPetr — Mon, 15 Apr 2024 11:57:40 GMT

HI @mprotas

Why do you use the file.copy?

try to use the output.write() with transferred file to the byte.

PetrH

Re: Best way to download files from Windchill Server to client

mprotas — Mon, 15 Apr 2024 12:24:01 GMT

Hi @HelesicPetr,

Changing from Files.copy() to more extensive writing to OutputStream object do not change anything in the freezing of Wizard's window after performing download of .zip file.

It looks like this:

Here is the current version of code:

@Override public FormResult doOperation(NmCommandBean nmCommandBean, List<ObjectBean> list) throws WTException { FormResult result = super.doOperation(nmCommandBean, list); WTPart contextPart = (WTPart) WizardUtils.getContextObject(nmCommandBean); setFileManager(contextPart); HttpServletResponseWrapper response = new HttpServletResponseWrapper(nmCommandBean.getResponse()); Path path = fileManager.getZipFilePath(); String fileName = path.getFileName().toString(); response.reset(); try(ServletOutputStream outputStream = response.getOutputStream()) { response.setStatus(200); response.setHeader("X-Content-Type-Options", null); response.setHeader("Content-Type", "application/zip"); response.setHeader("Content-disposition", "attachment; filename=" + fileName); response.setContentLength((int) path.toFile().length()); //Files.copy(path, outputStream); File file = new File(fileManager.getZipFilePath().toString()); ByteArrayOutputStream bos = new ByteArrayOutputStream(); try(FileInputStream fis = new FileInputStream(file)) { byte[] buf = new byte[1024]; for (int readNum; (readNum = fis.read(buf)) != -1;) { bos.write(buf, 0, readNum); } } catch (IOException e) { System.out.println("Test"); } outputStream.write(bos.toByteArray()); outputStream.flush(); outputStream.close(); result.addDynamicRefreshInfo(new DynamicRefreshInfo(contextPart, contextPart, DynamicRefreshInfo.Action.UPDATE)); return result; } catch (IOException | IllegalStateException e) { throw new WTException("Could not send file!"); } }

Re: Best way to download files from Windchill Server to client

HelesicPetr — Mon, 15 Apr 2024 12:27:54 GMT

Hi @mprotas

The point is that you can not use the reset method to reset the response.

If you use the reset, then you lost the connection to your wizard window.

Remove it.

You need to solve the IllegalStateException issue, and .reset method is not the solution.

PetrH

Re: Best way to download files from Windchill Server to client

mprotas — Mon, 15 Apr 2024 12:29:16 GMT

Yeah, but without this reset() method I receive that IllegalStateException mentioned above. Is there any workaround to perform downloading file from FormProcessor Wizard's window?

Re: Best way to download files from Windchill Server to client

HelesicPetr — Mon, 15 Apr 2024 12:40:35 GMT

@mprotas

Yes, the export mechanism used for downloading a WTDocument objects to a zip file.

PetrH

Re: Best way to download files from Windchill Server to client

@_1647 — Mon, 09 Dec 2024 12:38:06 GMT

Hi HelesicPetr,

I am using same and executing from one of action. On click of action excel file is getting created on defined location and DoOperation() form processor method also executing well without any errors but created file not getting downloaded on client browser as well as Feedback MSG also not reflecting on UI only page getting refreshed.

Need assistance for this scenario.