Changeset 11737 for main/waeup.kofa/trunk/src/waeup/kofa/students

Timestamp:

6 Jul 2014, 16:15:52 (11 years ago)

Author:

Henrik Bettermann

Message:

Append hash '#' also to datetimes to circumvent unwanted excel automatic.

Location:

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

Files:

• sample_payment_data.csv (modified) (1 diff)
• test_export.py (modified) (12 diffs)

main/waeup.kofa/trunk/src/waeup/kofa/students/tests/sample_payment_data.csv

@@ -2 +2 @@
 ,paid,schoolfee,3816951290797973744#,1,2010,19500,BTECHBDT,19500,0942,00,2010/11/26 19:59:33.744 GMT+1,online,1
 100001,unpaid,schoolfee,3816951290712593757,,2010,0,BTECHBDT,19500.1,0942,Z0,2010-11-25 20:16:33.757 WAT,online,0
-,paid,schoolfee,p1266236341955,3,2009,19500,BTECHBDT,19500,0615,00,2010/02/15 13:19:01,online,1
-,paid,schoolfee,ABC-11-1234567890,3,2011,19500,BTECHBDT,19500.6,,SC,2010/02/15 13:19:01,sc,1
+,paid,schoolfee,p1266236341955,3,2009,19500,BTECHBDT,19500,0615,00,2010/02/15 13:19:01#,online,1
+,paid,schoolfee,ABC-11-1234567890,3,2011,19500,BTECHBDT,19500.6,,SC,2010/02/15 13:19:01#,sc,1

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

@@ -677 +677 @@
             'r_code,r_desc,student_id,state,current_session\r\n'
 
-            ',0.0,2012-04-01 13:12:01,,1,,,,,unpaid,,0.0,,,,,\r\n'
+            ',0.0,2012-04-01 13:12:01#,,1,,,,,unpaid,,0.0,,,,,\r\n'
             )
         return
@@ -695 +695 @@
             'r_code,r_desc,student_id,state,current_session\r\n'
 
-            '666,12.12,2012-04-01 13:12:01,schoolfee,1,my-id,'
-            'p-item,100,2012,paid,2012-04-01 14:12:01,12.12,'
+            '666,12.12,2012-04-01 13:12:01#,schoolfee,1,my-id,'
+            'p-item,100,2012,paid,2012-04-01 14:12:01#,12.12,'
             'r-code,,A111111,created,2012\r\n'
             )
@@ -714 +714 @@
             'r_code,r_desc,student_id,state,current_session\r\n'
 
-            '666,12.12,2012-04-01 13:12:01,schoolfee,1,my-id,'
-            'p-item,100,2012,paid,2012-04-01 14:12:01,12.12,'
+            '666,12.12,2012-04-01 13:12:01#,schoolfee,1,my-id,'
+            'p-item,100,2012,paid,2012-04-01 14:12:01#,12.12,'
             'r-code,,A111111,created,2012\r\n'
             )
@@ -733 +733 @@
             'r_code,r_desc,student_id,state,current_session\r\n'
 
-            '666,12.12,2012-04-01 13:12:01,schoolfee,1,my-id,'
-            'p-item,100,2012,paid,2012-04-01 14:12:01,12.12,'
+            '666,12.12,2012-04-01 13:12:01#,schoolfee,1,my-id,'
+            'p-item,100,2012,paid,2012-04-01 14:12:01#,12.12,'
             'r-code,,A111111,created,2012\r\n'
             )
@@ -755 +755 @@
             'r_code,r_desc,student_id,state,current_session\r\n'
 
-            '666,12.12,2012-04-01 13:12:01,schoolfee,1,my-id,'
-            'p-item,100,2012,paid,2012-04-01 14:12:01,12.12,'
+            '666,12.12,2012-04-01 13:12:01#,schoolfee,1,my-id,'
+            'p-item,100,2012,paid,2012-04-01 14:12:01#,12.12,'
             'r-code,,A111111,created,2012\r\n'
             )
@@ -790 +790 @@
             'r_code,r_desc,student_id,state,current_session\r\n'
 
-            '666,12.12,2012-04-01 13:12:01,schoolfee,1,my-id,'
-            'p-item,100,2012,paid,2012-04-01 14:12:01,12.12,'
+            '666,12.12,2012-04-01 13:12:01#,schoolfee,1,my-id,'
+            'p-item,100,2012,paid,2012-04-01 14:12:01#,12.12,'
             'r-code,,A111111,created,2012\r\n'
             )
@@ -842 +842 @@
             'state,current_session,entry_session,entry_mode,faccode,depcode,certcode\r\n'
 
-            '666,12.12,2012-04-01 13:12:01,schoolfee,1,my-id,p-item,100,2012,'
-            'paid,2012-04-01 14:12:01,12.12,r-code,,A111111,234,123,'
+            '666,12.12,2012-04-01 13:12:01#,schoolfee,1,my-id,p-item,100,2012,'
+            'paid,2012-04-01 14:12:01#,12.12,r-code,,A111111,234,123,'
             'Anna,M.,Tester,created,2012,2010,ug_ft,NA,NA,CERT1\r\n'
             )
@@ -882 +882 @@
             'bed,bed_coordinates,bed_type,booking_code,booking_date,'
             'booking_session,student_id,actual_bed_type\r\n'
-            'hall-1_A_101_A,,,,<YYYY-MM-DD hh:mm:ss>.<6-DIGITS>,,,regular_male_fr\r\n'
+            'hall-1_A_101_A,,,,<YYYY-MM-DD hh:mm:ss>.<6-DIGITS>#,,,regular_male_fr\r\n'
             )
         return
@@ -898 +898 @@
             'bed,bed_coordinates,bed_type,booking_code,booking_date,'
             'booking_session,student_id,actual_bed_type\r\n'
-            'hall-1_A_101_A,,any bed type,,<YYYY-MM-DD hh:mm:ss>.<6-DIGITS>,2004,'
+            'hall-1_A_101_A,,any bed type,,<YYYY-MM-DD hh:mm:ss>.<6-DIGITS>#,2004,'
             'A111111,regular_male_fr\r\n'
             )
@@ -914 +914 @@
             'bed,bed_coordinates,bed_type,booking_code,booking_date,'
             'booking_session,student_id,actual_bed_type\r\n'
-            'hall-1_A_101_A,,any bed type,,<YYYY-MM-DD hh:mm:ss>.<6-DIGITS>,2004,'
+            'hall-1_A_101_A,,any bed type,,<YYYY-MM-DD hh:mm:ss>.<6-DIGITS>#,2004,'
             'A111111,regular_male_fr\r\n'
             )
@@ -930 +930 @@
             'bed,bed_coordinates,bed_type,booking_code,booking_date,'
             'booking_session,student_id,actual_bed_type\r\n'
-            'hall-1_A_101_A,,any bed type,,<YYYY-MM-DD hh:mm:ss>.<6-DIGITS>,2004,'
+            'hall-1_A_101_A,,any bed type,,<YYYY-MM-DD hh:mm:ss>.<6-DIGITS>#,2004,'
             'A111111,regular_male_fr\r\n'
             )
@@ -949 +949 @@
             'bed,bed_coordinates,bed_type,booking_code,booking_date,'
             'booking_session,student_id,actual_bed_type\r\n'
-            'hall-1_A_101_A,,any bed type,,<YYYY-MM-DD hh:mm:ss>.<6-DIGITS>,'
+            'hall-1_A_101_A,,any bed type,,<YYYY-MM-DD hh:mm:ss>.<6-DIGITS>#,'
             '2004,A111111,regular_male_fr\r\n')
         return