[IMP] base_import: date-parsing patterns

* expand auto-detected date and time patterns (e.g. %b, %I, ...)
* try to make date-pattern-detection clearer
* add a select2 dropdown for date patterns (with a bunch of
  preselected patterns) rather than just an input
* also try to improve other column-matching bits (e.g. less reliance
  on exceptions, attempts to avoid redundant work)

1 files changed, 6 insertions, 0 deletions

diff --git a/addons/base_import/tests/test_csv_magic.py b/addons/base_import/tests/test_csv_magic.py
index 92724ec360b..0a35a4731c1 100644
--- a/addons/base_import/tests/test_csv_magic.py
+++ b/addons/base_import/tests/test_csv_magic.py
@@ -29,6 +29,7 @@ class TestEncoding(ImportCase):
             preview = self._make_import(
                 test_text.encode(encoding)).parse_preview(dict(options))
 
+            self.assertIsNone(preview.get('error'))
             guessed = preview['options']['encoding']
             self.assertIsNotNone(guessed, encoding)
             self.assertEqual(codecs.lookup(guessed).name, codecs.lookup(encoding).name)
@@ -54,6 +55,7 @@ class TestEncoding(ImportCase):
             'separator': '\t',
             'encoding': 'iso-8859-1',
         })
+        self.assertIsNone(r.get('error'))
         self.assertEqual(r['options']['encoding'], 'iso-8859-1')
         self.assertEqual(r['preview'], [['text'], [s.decode('iso-8859-1')]])
 
@@ -75,6 +77,7 @@ d|4
             'headers': True,
             'quoting': '"',
         })
+        self.assertIsNone(r.get('error'))
         self.assertEqual(r['headers'], ['c', 'f'])
         self.assertEqual(r['preview'], [
             ['a', '1'],
@@ -92,6 +95,7 @@ d|4
             'headers': True,
             'quoting': '"',
         })
+        self.assertIsNone(r.get('error'))
         self.assertEqual(r['headers'], ['c|f'])
         self.assertEqual(r['preview'], [
             ['a|1'],
@@ -107,6 +111,7 @@ d|4
             'headers': True,
             'quoting': '"',
         })
+        self.assertIsNone(r.get('error'))
         self.assertEqual(r['headers'], ['c', 'f'])
         self.assertEqual(r['preview'], [
             ['a', '1'],
@@ -126,6 +131,7 @@ d|4
             'headers': True,
             'quoting': '"',
         })
+        self.assertIsNone(r.get('error'))
         self.assertEqual(r['headers'], ['c'])
         self.assertEqual(r['preview'], [
             ['a'],