Re: Need help in processing comma seperated text file

2016-10-19 Thread raghavender.anth...@gmail.com
Thanks a lot for the response. Initially I thought of using BeanIO itself but my data format is not exactly delimited format. As per my understanding, to use BeanIO we should specify the format in the mapping xml. Since I've the below elements in my text file, am not sure which one to go with. Als

Re: Need help in processing comma seperated text file

2016-10-14 Thread Ranx
You can use Bindy though I've had better luck with the mapping in Beanio. Start with that first and then look at using a splitter/tokenizer to process your files or write them out in the new format you require. Just create a mapping file and a sample with a few records in it and run a unit test t

Re: Need help in processing comma seperated text file

2016-10-14 Thread raghavender.anth...@gmail.com
Can someone guide me on this? Thank you. -- View this message in context: http://camel.465427.n5.nabble.com/Need-help-in-processing-comma-seperated-text-file-tp5787930p5788783.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: Need help in processing comma seperated text file

2016-09-23 Thread raghavender.anth...@gmail.com
Am not sure whether I've understood your question correctly, am looking for an approach/solution that is efficient, quick with minimal code. Right now, I'm planning to do below steps: 1. Read the source file line by line 2. Process the data line by line and collect the data in several collections

Re: Need help in processing comma seperated text file

2016-09-23 Thread raghavender.anth...@gmail.com
Thanks Steve. I am sending you the source and target file formats as mentioned below. The source file can contain 100,000 - 10,00,000 records. *Source delimited text file:* [Runtime] Date=ASAP Time= AllowErrors=FALSE [Task.1] Server=Item Master Module=ItemPOSIdentity Operation=*addupdate* [Data

Re: Need help in processing comma seperated text file

2016-09-23 Thread Steve973
It might help to show us an example of the data that you are trying to transform. If the files are not too large, then simply using the file component and then invoking a CSV library (such as http://opencsv.sourceforge.net/) from within a processor should give you what you want. Depending on your

Re: Need help in processing comma seperated text file

2016-09-22 Thread raghavender.anth...@gmail.com
Thanks for the response. I would like to use Camel to read the file, process it and generate a new CSV file to send it to a different system. I get this file from a different system X and I need to process and transform it to CSV file in a different format which can be understood by system Y. I c

Re: Need help in processing comma seperated text file

2016-09-22 Thread DariusX
It isn't clear how you want to use Camel in this picture. if it is simply to poll for files, and if the file is not huge, a simple/naive approach would be to read in the whole file and do all the steps you need. All as a single Processor following the "from:file" consumer. The the Data/Task secti