public String execute() throws Exception { statementManager.initialise(); ExportReport exportReport = exportReportService.getExportReport(exportReportId); for (String itemId : itemIds) { ImportItem importItem = importReportService.getImportItem(Integer.parseInt(itemId)); ExportItem newExportItem = new ExportItem(); newExportItem.setName(importItem.getName()); newExportItem.setItemType(itemType); newExportItem.setPeriodType(periodType); newExportItem.setExpression(importItem.getExpression()); newExportItem.setRow(importItem.getRow()); newExportItem.setColumn(importItem.getColumn()); newExportItem.setSheetNo(sheetNo); newExportItem.setExportReport(exportReport); exportReportService.addExportItem(newExportItem); } message = i18n.getString("success"); statementManager.destroy(); return SUCCESS; }
public String execute() throws Exception { // --------------------------------------------------------------------- // Get File Excel // --------------------------------------------------------------------- String path = selectionManager.getUploadFilePath(); if (path != null && path != "") { fileExcel = new File(path); } // --------------------------------------------------------------------- // Validate selected OrganisationUnit // --------------------------------------------------------------------- organisationUnit = organisationUnitSelectionManager.getSelectedOrganisationUnit(); if (organisationUnit == null) { return SUCCESS; } // --------------------------------------------------------------------- // Load and sort ImportReports // --------------------------------------------------------------------- importReports = new ArrayList<ImportReport>(importReportService.getImportReports(organisationUnit)); return SUCCESS; }