Processing CSV file

josef.bajada.go.com.mt's picture
I have the following use-case and I am wondering how I could achieve it with WSO2 ESB, WSO2 BPS and any other modules/products (maybe Data Services?): I have a CSV file which is generated periodically by System A. I need to detect the presence of this file (maybe by polling every 5 minutes or so), parse this CSV file (which has multiple records), and for each line (record), transform it into an XML request and feed it to a BPEL process which invokes System B and System C together with some business process logic. The file needs to be moved to another folder or deleted, so that it is not picked up with the next poll. The outcome of each BPEL process instance then needs to be saved to another CSV file, such that for each input file I have an output file with the results, with both files having an identical number of records. I was thinking of using the VFS to poll for new files and write to the output, but I am a bit lost how to do the whole chain to achieve the above. I am a bit new to WSO2 ESB and BPS, so please do not assume I know too much about how to do things.
indika's picture

Hi I believe that you can

Hi I believe that you can use 'Sample 254' (with modifications) as a base configuration. With it , you should be able to implement your basic scenario. In sample 254, the 'uri' address of the endpoint of the proxy should be the URI for the BEPL process. You have to change 'Content-Type', 'FileNamePattern' etc ... First, try to get the work your basic scenario based on sample 254. Thanks Indika
library project main code
Learn Cloud
Learn
Cloud

The WSO2 Application Server is a reliable application server that can host your enterprise web applications. The WSO2 Application Server as a Service is offered in StratosLive, the WSO2 Platform as a Service. This article explains how a simple web application can be developed and deployed from Carbon Studio to the WSO2 Application Server...

Latest Webinar
KeellsSuper is a leading supermarket chain with 50-plus outlets in Sri Lanka, and it offers the only online supermarket in the country. In 2005, JKH implemented SAP ERP across it’s 70 subsidiaries...
Thursday, February 16th 2012, 09.00 AM (PST)

Thursday, February 16th 2012, 10.00 AM (GMT)