Changeset 666

Timestamp:

Jul 19, 2010, 7:46:04 PM (13 years ago)

Author:

tabma

Message:

• unparsable values from Excel will be ignored

File:

• trunk/grails-app/services/dbnp/importer/ImporterService.groovy (modified) (1 diff)

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

@@ -330 +330 @@
         for (HSSFCell cell: excelrow) {     
             def mc = mcmap[cell.getColumnIndex()]
-            def value = formatValue(df.formatCellValue(cell), mc.templatefieldtype)
+            def value
+
+            try {
+                 value = formatValue(df.formatCellValue(cell), mc.templatefieldtype)
+            } catch (NumberFormatException nfe) {
+                 value = ""
+            }
 
             switch(mc.entity) {