Generate Orderables.csv file

In referencedata service generate the .csv file with structure:

Mapping:

1. productCode -> referencedata.orderables.code

2. name -> referencedata.orderables.fullProductName

3. description -> referencedata.orderables.description

4. packRoundingThreshold -> referencedata.orderables.packroundingthreshold

5. packSize -> referencedata.orderables.netcontent

6. roundToZero -> referencedata.orderables.roundtozero

7. dispensable -> referencedata.dispensable_attributes

Export

• Create a service class containing a methods that
  - creates a csv file(s) with specific name(s).
  - creates a zip archive containing csv files.

• The csv generating method returns an ByteArrayOutputStream with processed data.
  The method retrieves the Orderable data from the database and, using specific formatter implementation, processes them to bytes
  - create an additional method that returns a Map where the keys are filenames and the values are the corresponding byte data

• The zip generating method returns array of bytes and uses java.util.zip library to create archive.

Formatting

The data will be processed into the csv format using the solutions already available on the service. The writer implementation uses a super-csv lib.

This solution was introduced for exporting IdealStockAmount objects data to csv format. Check the ticket.

• create base interface for formatters (DataFormatterService) with process method

• create implementation of the base interface (CsvFormatterService) that uses already implemented writer

In case of need to extend the functionality of data export to other formats, it will only be necessary to add a new implementation without modifying the code.

Appropriate formatter implementations will be set dynamically using the BeanFactory.

Retrieving data

Generated files will not always be just entities, so another layer of data retrieval is needed.

• create base interface to find data to be exported (ExportableDataService) with findAll method

• OrderableService should implement that interface

Appropriate repository implementations will be set dynamically using the BeanFactory.

Knowledge base:

http://super-csv.github.io/super-csv/index.html

https://openlmis.atlassian.net/browse/OLMIS-3227