Changeset 7973

Timestamp:

23 Mar 2012, 08:15:58 (13 years ago)

Author:

Henrik Bettermann

Message:

Add the hash symbol at the end of date_of_birth.

This is to avoid annoying automatic date transformation by Excel or Calc.

Location:

main/waeup.kofa/trunk/src/waeup/kofa/students

Files:

• export.py (modified) (1 diff)
• tests/test_export.py (modified) (2 diffs)

main/waeup.kofa/trunk/src/waeup/kofa/students/export.py

@@ -22 +22 @@
     title = _(u'Students')
 
+    def mangle_value(self, value, name, context=None):
+        """Add the hash symbol at the end of date_of_birth.
+
+        This is to avoid annoying automatic date transformation
+        by Excel or Calc.
+        """
+        if name == 'date_of_birth':
+            value = str(value) + '#'
+        return super(
+            StudentsExporter, self).mangle_value(
+            value, name, context=context)
+
     def export(self, students, filepath=None):
         """Export `students`, an iterable, as CSV file.

main/waeup.kofa/trunk/src/waeup/kofa/students/tests/test_export.py

@@ -70 +70 @@
             'perm_address,phone,reg_number,sex,student_id\r\n'
 
-            'my adm code,0,my clr code,1981-02-04,anna@sample.com,Anna,'
+            'my adm code,0,my clr code,1981-02-04#,anna@sample.com,Anna,'
             'Tester,M123456,M.,nigeria,"Studentroad 21\nLagos 123456\n",'
             '+234-123-12345,123456,f,A111111\r\n'
@@ -89 +89 @@
             'perm_address,phone,reg_number,sex,student_id\r\n'
 
-            'my adm code,0,my clr code,1981-02-04,anna@sample.com,Anna,'
+            'my adm code,0,my clr code,1981-02-04#,anna@sample.com,Anna,'
             'Tester,M123456,M.,nigeria,"Studentroad 21\nLagos 123456\n",'
             '+234-123-12345,123456,f,A111111\r\n'