Re: Excelfile import in java and transfer in a Database

Hey Richard, Can we use camel file component to write to an Excel file or we will have to use some stream writer for this purpose. Regards, Sanjeev -- View this message in context: http://camel.465427.n5.nabble.com/Excelfile-import-in-java-and-transfer-in-a-Database-tp5746612p5

How to print blank for decimals and long datatype with null value

Hi everyone, I have a decimal data type billingFxRate defined in a pojo class and mapped to a BeanIo file like When the value of this field is null it prints it as 0.000 in the outbound file.I want when it is blank it should print a space or nothing.I tried to use required=f

using field as key+value on the BeanIo

Hi All, I am using BeanIO for defining the file format while marshal/writing my output stream.Here each field of a particular record is some sort of a key/Value and separated by a delimiter. Here key is the Tag code(e.g. AC) and value is tag description either blank or represent a database f

Re: Consuming Excel File with consumer template

For those who have the same issue I like to share the information that : I get rid of this bug by using this line InputStream body =consumer.receiveBody(endPointUri,2000,InputStream.class); and changing correspondingly on the ExcelParser class. thanks, -- View this message in context: http

Consuming Excel File with consumer template

Hi All, Can some one help me in using excel file with consumer template. I am trying it with a simple route for testing: file:${properties:inbound_home}/pgsl?include=SOCGEN_2Records.xls and loc

Re: Unable to use move,movefailed and donefilename with consumer template endpoint Uri

Thanks,Claus.I was able to get rid of this bug by placing the endpoint Uri on the camel context inside tags and then get this from the camel header on the java class. Eg. file:${in.header.clientFileDir}?include=.*_BNYM_.*txt &move=${properties:data_home}/${file:onlyname.noext}-${date:now:MMddH

Re: Unable to use move,movefailed and donefilename with consumer template endpoint Uri

Claus, I have gone through the section "Timer based polling consumer" at http://camel.apache.org/polling-consumer.html as I am using a timer in my route defnition. I try to follow it but still getting the same error.It seems some thing is wrong with the endpoint itself String endPointUri="

Unable to use move,movefailed and donefilename with consumer template endpoint Uri

Hi, I have gone through lots of regarding the issue and came to know if I use consumer.receiveBody() I can move the file but when I am using it I am getting error like: Exception while consuming the locates file:null :Failed to resolve endpoint: file:///home/... Failed to resolve endpoint: Ch

Re: combining the existing content with a file having dynamic uri then moving the file

Hi Claus, I am using consumer template to for the same work in the thread as I want a pattern based reading of file and then move the file after renaming it with current date some thing like : file:{{inbound_home}}/bony?include=.*_BNYM_.*txt&move={{data_home}}/${file:onlyname.noext}_${dat

Re: combining the existing content with a file having dynamic uri then moving the file

Thanks,Claus.It is working fine.But I have still one question.Can I use it for reading the pattern based file and moving the file to a archive directory.Something like this: include=.*.*xls*& move={{data_home}}/${file:onlyname.noext}_${date:now:MMdd}.XLS& moveFailed={{data_home}}/errorfile&do

combining the existing content with a file having dynamic uri then moving the file

Hi All, I am a camel newbie and searching for more than 3 days but couldn't get an appropiate answer. Actually I have to process lot of files one by one using the same route based on some criteria.I get the criteria value and the uri of the file from the database,spitted it using a splitter a