Changeset 12810 for main/waeup.kofa/trunk/src/waeup/kofa/utils/batching.py

Timestamp:

23 Mar 2015, 10:40:18 (10 years ago)

Author:

Henrik Bettermann

Message:

Skip empty rows produced by spreadsheet software.

File:

• main/waeup.kofa/trunk/src/waeup/kofa/utils/batching.py (modified) (2 diffs)

main/waeup.kofa/trunk/src/waeup/kofa/utils/batching.py

@@ -273 +273 @@
         return errs, inv_errs, conv_dict
 
+
+    def emptyRow(self, row):
+        """Detect empty rows.
+        """
+        for value in row.values():
+            if value:
+                return False
+        return True
+
     def doImport(self, path, headerfields, mode='create', user='Unknown',
                  logger=None, ignore_empty=True):
@@ -307 +316 @@
         for raw_row in reader:
             num += 1
+            # Skip row if empty
+            if self.emptyRow(raw_row):
+                continue
             string_row = self.applyMapping(raw_row, mapping)
             if ignore_empty and mode in ('update',):
-                # replace empty strings with ignore-markers
+                # Replace empty strings with ignore-markers
                 for key, val in string_row.items():
                     if val == '':