Changeset 669 for trunk/grails-app/services/dbnp/importer

Timestamp:

Jul 20, 2010, 4:21:50 PM (12 years ago)

Author:

tabma

Message:

• added "Don' t import" functionality which ignores columns

File:

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

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

@@ -171 +171 @@
             
             (0..header.size()-1).each { columnindex ->
-                def c = sheet.getRow(rowindex).getCell(columnindex, org.apache.poi.ss.usermodel.Row.CREATE_NULL_AS_BLANK)
-                println "DAS " + columnindex + ":" + c
+                def c = sheet.getRow(rowindex).getCell(columnindex, org.apache.poi.ss.usermodel.Row.CREATE_NULL_AS_BLANK)               
                 row.add(c)
+                //if (c.getCellType() == c.CELL_TYPE_STRING) println "STR"+c.getStringCellValue()
+                //if (c.getCellType() == c.CELL_TYPE_NUMERIC) println "INT" +c.getNumericCellValue()
             }
                 //row.add(df.formatCellValue(c))
@@ -224 +225 @@
         def sheet = wb.getSheetAt(sheetindex)
         def table = []
-
         
         // walk through all rows        
@@ -242 +242 @@
         return table    
     }
-    
-     /**
-                     // start transaction
-                        def transaction = sessionFactory.getCurrentSession().beginTransaction()
-                              // persist data to the database
-                                try {
-                                   // commit transaction
-                                        println "commit"
-                                        transaction.commit()
-                                        success()
-                                } catch (Exception e) {
-                                        // rollback
-                                        // stacktrace in flash scope
-                                        flash.debug = e.getStackTrace()
-
-                                        println "rollback"
-                                        transaction.rollback()
-                                        error()
-                                }
-      */
-
+   
     /**
      * Method to store a matrix containing the entities in a record like structure. Every row in the table
@@ -332 +312 @@
             def value
 
-            try {
-                 value = formatValue(df.formatCellValue(cell), mc.templatefieldtype)
-            } catch (NumberFormatException nfe) {
-                 value = ""
-            }
+            if (!mc.dontimport) {
+                /*try {
+                 value = formatValue(df.formatCellValue(cell), mc.templatefieldtype)
+                } catch (NumberFormatException nfe) {
+                 value = ""
+                }*/
+            value = df.formatCellValue(cell)
 
             switch(mc.entity) {
@@ -354 +336 @@
                                     break
             } // end switch
-        } // end for
+        } // end 
+    } // end for
 
         return record