How to Zip Excel files using File Adapter?

Advertisement

Hi,
We have tried to ZIP the Excel file with  PayloadZipBean in File adapter. But we faced some issue while zipping.
We have seen some zunk data in excel file after zipping with PayloadZipBean. Someone please help how to zip Excel files in PI with File Adapter.
Regards,
Sreeramulu Konjeti.

Advertisement

Hi Sree,
If you are facing any issue with PayloadZipBean then you can use java mapping to Zip the files.
Please find the complete Java mapping code to zipt the file
http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/50ce0433-4309-2b10-4bb4-d421e78463f7?quicklink=index&overridelayout=true

October 11, 2015

How to Zip Excel files using File Adapter?

Hi, We have tried to ZIP the Excel file with  PayloadZipBean in File adapter. But we faced some issue while zipping. We have seen some zunk data in excel file after zipping with PayloadZipBean. Someone please help how to zip Excel files in PI with Fi

Creating PDF files using file adapter

Hi, Is it possible to create a pdf file using, File/FTP adapter? If yes can someone please suggest how to do it. Thanks, PhaniHi Phani, I would say pdf files are binary files with a specialized format. You can move pdf files through BPEL or ESB (i.e.

Export the Form Data to Excel File using FILE EXPORT

One problem i am getting... I want to export printers page to some excel file using FILE > EXPORT option. I login into System Administrator Responsibility > printers > register... I want to export this printers data to flat file(EXCEL File) using

Polling xml file using file adapter

Hi, when i am polling xml file using file adapter, xml file received properly. After receiving activity i am using assign activity to copy values to another variables, here i am getting error the values are not updated. My xml comes with out namespac

Reading encrypted file using file adapter...

Is it possible to read and write encrypted file using file adapter or if the file adapter is capable to encryption and decryption?what is the soa version you are currently running?Read other 2 answers

How to Write a PDF using File Adapter

Hi All, Can anyone please let me know how to create a PDF file at the receiving end using a File Receiver Adapter. The source is an XML file. The scenario is as follows. XML-File ---> XI --->PDF-File. Any help would be highly appreciated. Thanks in

How o place Flat file Using JMS Adapter.

Hi Frnds, I have one scenario , Sender side i am having IDOC, i want convet the IDOC into Flat file. But my receiver side i have to use only JMS Adapter, Flat file i have to place in FTP Server using JMS Adapter. Can ne share your thoughts.. Regards,

Unable to read File using File Adapter

Hi, I am using File adapter to read XML file. I able to write payload contents to file. but using same schema, path i am unable to read the file. receive process is not initiating. what could be the possible issue? ThanksCould you please give more in

Multiple BPEL/ Mediator payloads how to store in DB using DB adapter.

I have huge XML which is XSD define for the same and have complex types which required around > 50 DB tables to store the entire XML. Have one parent table which has reference ID to child tables. Now first I want store the parent table and get the ID

How to define Excel function using BEx formula

Hi experts, May I know how to define the following Excel function using BEx formula? IF(AND(Revenue<0,Cost<0),"N/A",(Profit/Lost/ABS(Revenue))) Thanks!for me its easy to implament logic with * and + rather than  AND and OR respectively ((R

How to write nested queries using DB Adapter?

I want to write following nested query using DB Adapter can any one help... SELECT INVOICE_ID,FILE_NAME FROM  BILLING_INVOICE_PDF_V where FILE_ID =( (SELECT MAX(FILE_ID) FROM  BILLING_INVOICE_PDF_V WHERE  (INVOICE_ID = '12345'))); Thanks, Ram.Hi Ram,

How to operate multiple querys using DB Adapter and 'Execute Custom SQL'

I have a requirment that I need to create database adapter in your BPEL process with 'Execute Custom SQL' to operate multiple query in DB in one atomic here are the details: inbound request: <ns1:Query_bpelProcessRequest> <ns1:input> <ns1:I

Reading .ZIP files using File Adapter

Hi, I am using BPEL File Adapter to read files. The files to be read are XML files which are in zipped format. so how should I read these .zip files and extract the XML files from that. Thanks /Kiran.If the xml files are all in the same directory (no

How To split large message using File Adapter

Hello everyone, Here is my scenario FTP > XI > BI. I got 2 questions: (1) I am getting large message around 70 MB file.     How we can split the message into multiple files 10 MB each before processing the file into XI? (2) Is there is any way we ca

How to post multiple message using file adapter in XI2.0

We have to post multiple IDOCS.We have scenario as below. We will have file structure like as shown below. VKORG,VTWEG,SPART,BSART,PARVW,PARTNER,BSTDK,MATNR,MENGE,VSART,BSTZD,POLINE,BSARK BE10;10;10;OR;SP;1000033;;M184-ISS01;2;G;131;0002; BE10;10;10;

How to fetch Excel sheet through File adapter and Mapping to IDOC in SAP PI?

Dear all Help me with this scenario? Thanks Regards karan kanotraDear  sir  This is a  new  scenario . I got an requirement to activate Forward Error Handling in SRM. I have searched on SDN but didn't find appropriate answer on it. Even I found some

How to fetch Excel sheet through File adapter in SAP PI?

Dear all Can u help me  with this? Regards karan kanotraDear  sir  This is a  new  scenario . I got an requirement to activate Forward Error Handling in SRM. I have searched on SDN but didn't find appropriate answer on it. Even I found some link: PI/

How to uplad file using file uplaod utility

Dear all, I want to upload excel files in oracle forms 10g , i made search about this subject but i found that there is a library called fileupload.pll in oracle forms demos but i didn't find it can any one help me how to use fileuplad utility in ora

Reading file using File Adapter in BPEL

Hi, I am using JDeveloper 11g. I am trying to Read XML file and write content to Text file. I created XML Schema, XML file. I created Asynchronous BPEL process (Auto Generated) I took one File adapter which will have Read operation and one more File

Read File using File adapter from remote server

I need put poll on remote directory for files. Can some one tell where to put the remote connection details? Thanks KKSorry dumb question!!!! We can use GetFile operation in FTP adapter..... Thanks KKRead other 2 answers