Changeset 1050

Timestamp:

Nov 2, 2010, 4:48:11 PM (13 years ago)

Author:

t.w.abma@…

Message:

• initial "failed cells" logic figured out, now extracts cells from the datamatrix which were not able to be stored in an entity

Location:

trunk/grails-app

Files:

• controllers/dbnp/importer/ImporterController.groovy (modified) (2 diffs)
• services/dbnp/importer/ImporterService.groovy (modified) (3 diffs)

trunk/grails-app/controllers/dbnp/importer/ImporterController.groovy

@@ -44 +44 @@
         //session.import_referer = request.forwardURI
         // should do a check what is in the url, strip it?
-        session.import_referer = params.redirectTo
+        session.import_referer = params.redirectTo        
     }
 
@@ -269 +269 @@
 
         // First handle the "failed cells"
-        //ImporterService.getFailedCells(session.importer_importeddata)
-        
-        //render(view:"step2a_simple", model:[datamatrix:session.importer_importeddata])
+        //render(view:"step2a_simple", model:[datamatrix:ImporterService.getFailedCells(session.importer_importeddata)])
 
         if (params.layout=="horizontal")

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

@@ -230 +230 @@
         }
         return table    
+    }
+
+    /** Method to extract failed cells from the datamatrix. Failed cells are cell values
+     * which could not be stored in an entity (e.g. Humu Supiuns in an ontology field).
+     *
+     * @param datamatrix two dimensional array containing entities and possibly also failed cells
+     * @return array of failed cells
+     * */
+    def getFailedCells(datamatrix) {
+       def failedcells = []
+       
+       datamatrix.each { record ->
+            record.each { column ->
+                column.each {
+                    if (it.getClass().getName().equals('java.util.LinkedHashMap$Entry')) {
+                        println it.key
+                        println it.value
+                        failedcells.add(it)
+                    }
+                }
+            }
+        }
+
+        return failedcells
     }
    
@@ -424 +448 @@
                                     // leave the field empty and let the user choose the ontology manually in a later step
                                     failed.put(mc, value)
+                                    println "failed ("+mc.templatefieldtype+"`" + value + "`"
                                 }
                         } // end
@@ -431 +456 @@
         // a failed column means that using the entity.setFieldValue() threw an exception
         //record.add(failed)
-        
         return record
     }