CODEWITHSUNDEEP
spring-batchitemwriter
Nikhil Nadkar
Nikhil Nadkar

Reputation: 43

Spring Batch FlatFileItemWriter write Object with List

I have a Pojo Partner: Partner Id List

Address Pojo : AddressId, Address, City, Country, Pin

I want to create a Flat file in Spring Batch - File will be : PartnerId;AddressId;Address;City;Country;Pin

I am getting Partner Pojo with Id and List of Addresses

How can I use the FlatFileItemWriter with the PartnerPojo My FlatFileItemWriterConfiguration configuration:

<?xml version="1.0" encoding="UTF-8"?>
<bean id="itemWriter" class="org.springframework.batch.item.file.FlatFileItemWriter">
   <property name="resource" value="file:outputFile.txt" />
   <property name="lineAggregator">
      <bean class="org.springframework.batch.item.file.transform.DelimitedLineAggregator">
         <property name="delimiter" value=";" />
         <property name="fieldExtractor">
            <bean class="org.springframework.batch.item.file.transform.BeanWrapperFieldExtractor">
               <property name="names" value="partnerId, addressId, address,city,country,pin " />
            </bean>
         </property>
      </bean>
   </property>
   <property name="headerCallback" ref="headerCallback" />
</bean>

I get an error on addressId

Upvotes: 1

Views: 3267

Answers (1)

Mahmoud Ben Hassine
Mahmoud Ben Hassine

Reputation: 31600

You need to flatten your data and pass the list of flat items as expected in the output file to the writer. For example:

class Partner {
   int id;
   List<Address> addresses;
}

class Address {
   int addressId;
   String address,city,country,pin;
}

// create this Pojo to encapsulate flat data (as in the expected csv)
class PartnerAddress {
   int partnerId, addressId;
   String address,city,country,pin;
}

An item processor would prepare the data:

class PartnerItemProcessor implements ItemProcessor<Partner, List<PartnerAddress>> {

    @Override
    public List<PartnerAddress> process(Partner partner) {
        List<PartnerAddress> partnerAddresses = new ArrayList<>();
        for (Address address : partner.getAddresses()) {
            PartnerAddress partnerAddress = new PartnerAddress();
            partnerAddress.setPartnerId(partner.getId());
            partnerAddress.setAddressId(address.getAddressId());
            partnerAddress.setAddress(address.getAddress());
            partnerAddress.setCity(address.getCity());
            partnerAddress.setCountry(address.getCountry());
            partnerAddress.setPin(address.getPin());
            partnerAddresses.add(partnerAddress);
        }
        return partnerAddresses;
    }
}

Then the writer receives the list of PartnerAddress and write them to the flat file.

Hope this helps.

Upvotes: 1

Related Questions