Re: CSV and SQL Component for Batch Processing

[Christian Müller <ch...@gmail.com>]

Add a processor in between and remove the entries you don't need.

Best,
Christian

Christian
-----------------

Software Integration Specialist

Apache Member
V.P. Apache Camel | Apache Camel PMC Member | Apache Camel committer
Apache Incubator PMC Member

https://www.linkedin.com/pub/christian-mueller/11/551/642

On Wed, Apr 29, 2015 at 11:36 AM, imranrazakhan <im...@gmail.com>
wrote:

> Hi,
>
> I am doing batch insertion into db from CSV file like
>
>         from("file:mycsv")
>         .unmarshal().csv()
>        .to("sql:insert into mytable (value1, value2) Values (#,
> #)?batch=true")
>        .end();
>
> It works fine if CSV columns and Table columns are same, but my CSV has 10
> column and Table has 7.
>
> Is there any way to skip last 3 columns from CSV before insertion?
>
> I can use bindy component but i am looking for option in CSV
>
> Regards,
>
>
>
> --
> View this message in context:
> http://camel.465427.n5.nabble.com/CSV-and-SQL-Component-for-Batch-Processing-tp5766475.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
>