Changeset 8376 for main/waeup.kofa/trunk/src/waeup/kofa/applicants

Timestamp:

7 May 2012, 05:57:46 (13 years ago)

Author:

Henrik Bettermann

Message:

Add the hash symbol at the end of all dates.
This is to avoid annoying automatic date transformation
by Excel or Calc.

Location:

main/waeup.kofa/trunk/src/waeup/kofa/applicants

Files:

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

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

@@ -77 +77 @@
 
     def mangle_value(self, value, name, context=None):
+        # Add the hash symbol at the end of dates.
+        # This is to avoid annoying automatic date transformation
+        # by Excel or Calc.
+        if name in ('date_of_birth', 'emp_start', 'emp_end',
+            'emp2_start', 'emp2_end') and value is not None:
+            value = str(value) + '#'
         if name in (
             'course1', 'course2', 'course_admitted') and value is not None:

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

@@ -169 +169 @@
             'reg_number,screening_score,screening_venue,sex,state,'
             'student_id\r\n'
-            'dp2011_654321,,654321,CERT1,CERT1,CERT1,1981-02-04,'
+            'dp2011_654321,,654321,CERT1,CERT1,CERT1,1981-02-04#,'
             'Anna M. Tester,anna@sample.com,Anna,'
             in result)
@@ -193 +193 @@
             'reg_number,screening_score,screening_venue,sex,state,'
             'student_id\r\n'
-            'dp2011_654321,,654321,CERT1,CERT1,CERT1,1981-02-04,'
+            'dp2011_654321,,654321,CERT1,CERT1,CERT1,1981-02-04#,'
             'Anna M. Tester,anna@sample.com,Anna,'
             in result)