Changeset 1612 for trunk/grails-app/services/dbnp/importer/ImporterService.groovy

Timestamp:

Mar 10, 2011, 9:54:52 AM (11 years ago)

Author:

robert@…

Message:

Update simple wizard to import subject without a name correctly and import date values in the right way

File:

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

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

@@ -413 +413 @@
                                 if (mc != null && !mc.dontimport && mc.entityclass == entity) {
                                         try {
-                                                value = formatValue(df.formatCellValue(cell), mc.templatefieldtype)
+                                                if( cell.getCellType() == Cell.CELL_TYPE_NUMERIC && DateUtil.isCellDateFormatted(cell) ) {
+                                                        // The format for date template fields is dd/mm/yyyy
+                                                        def date = cell.getDateCellValue();
+                                                        value = date.format( "dd/MM/yyyy" )
+                                                        println "Date value: " + value + " - " + formatValue(df.formatCellValue(cell), mc.templatefieldtype);
+                                                } else {
+                                                        value = formatValue(df.formatCellValue(cell), mc.templatefieldtype)
+                                                }
                                         } catch (NumberFormatException nfe) {
                                                 value = ""