public class ExportCashboxService extends AbstractService implements IExportCashboxService {

  @Override
  public ExportCashboxFormData create(ExportCashboxFormData formData) throws ProcessingException {

    ISqlService service = SERVICES.getService(ISqlService.class);
    String sql = "SELECT FILENAME FROM FILES";
    service.select("SELECT FILENAME FROM FILES", formData);

    CsvSqlAdapter exp = new CsvSqlAdapter(service);
    CsvSqlSettings s = new CsvSqlSettings();

    File file = new File("/home/user/reports/testreport1.txt");
    file.setWritable(true);
    
    // for testing 
    //System.out.println(file.getName());

    s.getBindBase();
    s.setColSeparator(',');
    Locale locale = Locale.getDefault();
    s.setContentLocale(locale);
    // There is only one field, you can add other
    List<String> CNames = Arrays.asList("FILENAME");
    s.setCsvColumnNames(CNames);
    // There is only one type, you can add other
    List<String> CTypes = Arrays.asList("VARCHAR");
    s.setCsvColumnTypes(CTypes);
    s.setEncoding("UTF-8");
    s.setFile(file);
    s.setSqlSelect(sql);
    s.setTextDelimiter('"');
    //if you want write to file with columns name and types change below to true.
    s.setWriteColumnNames(false);
    s.setWriteColumnTypes(false);

    exp.exportData(s);

    return formData;
  }