Spring Batch reading csv columns in different order

Question

I am using spring batch to automatically read csv files and map each row into an object. There is code below. The columns in the csv file are ID, field1, field2, field3. And this is the order I wrote in the lineTokenizer. However, the FlatFileItemReader is not reading the file in this order. Rather, it seemingly reads in a random order, reading field2 first, then ID, then field3, then field1. But I want it to read ID first because I'm trying to write a map that maps ID to each field. Is there a way to change the order in which the FlatFileItemReader reads the columns in csv?

<bean id="mappedPosition" class="com.jpmorgan.ib.colopt.input.MappedPosition" scope="prototype" />
<bean id="positionFileItemReader" class="org.springframework.batch.item.file.FlatFileItemReader">
      <property name="resource" value="position.csv" />
      <property name="lineMapper">
           <bean class="org.springframework.batch.item.file.mapping.DefaultLineMapper">
                 <property name="lineTokenizer">
                       <bean class="org.springframework.batch.item.file.transform.DelimitedLineTokenizer">
                             <property name="names" value="ID, field1, field2, field3" />
                       </bean>
                  </property>
                  <property name="fieldSetMapper">
                        <bean class="org.springframework.batch.item.file.mapping.BeanWrapperFieldSetMapper">
                              <property name="prototypeBeanName" value="mappedPosition"/>
                        </bean>
                  </property>
                 </bean>
      </property>
</bean>

Luca Basso Ricci · Accepted Answer · 2013-08-21 14:15:15Z

1

Spring-batch reads and tokenize fields from CSV in sequence, as expected.
The problem is in BeanWrapperFieldSetMapper: to inject FieldSet values into bean's properties mapper pass from an String[] (ordered with your field names) to a Properties (look FieldSet.getProperties()) to match property-value.
I think you can achieve your goal using a StepExecutionListener and intercept item after reading (you will get your mappedPosition fully popolated)

answered Aug 21, 2013 at 14:15

Luca Basso Ricci

18.5k2 gold badges51 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Spring Batch reading csv columns in different order

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related