Changeset 12812 for main/waeup.ikoba/trunk/src/waeup/ikoba/utils

Timestamp:

23 Mar 2015, 11:32:12 (10 years ago)

Author:

Henrik Bettermann

Message:

Skip empty rows produced by spreadsheet software.

File:

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

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

@@ -274 +274 @@
         return errs, inv_errs, conv_dict
 
+    def emptyRow(self, row):
+        """Detect empty rows.
+        """
+        for value in row.values():
+            if value.strip() and not value in (None, IGNORE_MARKER):
+                return False
+        return True
+
     def doImport(self, path, headerfields, mode='create', user='Unknown',
                  logger=None, ignore_empty=True):
@@ -308 +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',):