Changeset 203 for trunk/grails-app/services

Timestamp:

Feb 18, 2010, 8:10:35 AM (11 years ago)

Author:

tabma

Message:

• rewrote to HashMap? based columns (columns are always unique, storing in array tricky/redundancy)
• entities can be chosen in the preview
• properties page shows columns grouped per entity
• properties page allows mapping of column to property (TODO: get all fields per entity)

File:

• trunk/grails-app/services/dbnp/importer/ImporterService.groovy (modified) (3 diffs)

trunk/grails-app/services/dbnp/importer/ImporterService.groovy

@@ -19 +19 @@
 import org.apache.poi.poifs.filesystem.POIFSFileSystem
 import org.apache.poi.ss.usermodel.DataFormatter
-
+import dbnp.importer.Column
 
 class ImporterService {
@@ -43 +43 @@
         def sheet = wb.getSheetAt(sheetindex)
         def datamatrix_start = sheet.getFirstRowNum() + 1
-        def header = []        
+        //def header = []
+        def header = [:]
         def df = new DataFormatter()
+
 
         for (HSSFCell c: sheet.getRow(sheet.getFirstRowNum())) {
@@ -54 +56 @@
             switch (c.getCellType()) {
                     case HSSFCell.CELL_TYPE_STRING:                     
-                        header.add (columnindex:c.getColumnIndex(), value:df.formatCellValue(c), celltype:datamatrix_celltype);
+                        header[c.getColumnIndex()] = new dbnp.importer.Column(value:df.formatCellValue(c), type:datamatrix_celltype);
                         break
                     case HSSFCell.CELL_TYPE_NUMERIC:
-                        header.add (columnindex:c.getColumnIndex(), value:df.formatCellValue(c), celltype:datamatrix_celltype);
+                        header[c.getColumnIndex()] = new dbnp.importer.Column(value:df.formatCellValue(c), type:datamatrix_celltype);
                         break
                     case HSSFCell.CELL_TYPE_BLANK:
-                        header.add (columnindex:c.getColumnIndex(), value:"-", celltype:datamatrix_celltype);
+                        header[c.getColumnIndex()] = new dbnp.importer.Column(value:df.formatCellValue(c), type:datamatrix_celltype);
                         break
                     default:
-                        header.add (columnindex:c.getColumnIndex(), value:df.formatCellValue(c), celltype:datamatrix_celltype);
+                        header[c.getColumnIndex()] = new dbnp.importer.Column(value:df.formatCellValue(c), type:datamatrix_celltype);
                         break
             }