Changeset 163 for trunk/aeres

Timestamp:

04/05/12 14:30:04 (12 years ago)

Author:

pinsard

Message:

time in excel file

File:

• trunk/aeres/scripts/aeresrh.py (modified) (9 diffs)

trunk/aeres/scripts/aeresrh.py

@@ -34 +34 @@
                color=blue,
                  URL="http://forge.ipsl.jussieu.fr/pulsation/browser//branches/aeresrh/scripts/aeresrh.py",
-           label="${PROJECT}/++/aeresrh.py"];
+           label="${PROJECT}/aeres/scripts/aeresrh.py"];
              }
 
@@ -52 +52 @@
 test with real file (encoding, francais, etc)
 
-gestion des temps (anne de naissance , arrivée , depard)
+missing values
 
 remove hard coded number of columns for surname, firstname, ...
@@ -66 +66 @@
 
 - fplod 20120405
-
+ 
+  * gestion des temps (arrivée, départ) (to be cont.)
   * creation draft
     thanks to http://www.portailsig.org/content/python-lire-et-ecrire-des-fichiers-microsoft-excel-application-quantum-gis
@@ -77 +78 @@
 import glob
 from optparse import OptionParser
+
+import datetime
 
 try:
@@ -136 +139 @@
             print('values of in col %d : %s' % (colnum, sh.col_values(colnum)))
 
-    colsurname = 2
-    colfirstname = 4
-    colarrival = 26
-    coldeparture = 28
-    colpubli = 32 
+    colsurname = 1
+    colfirstname = 2
+    colarrival = 13
+    coldeparture = 14
+    colpubli = 16 
+
+    datemode = 0 
 
     surname = sh.col_values(colsurname)
@@ -151 +156 @@
        print(' surname %s' % surname)
 
-    firstname = []
     firstname = sh.col_values(colfirstname)
     # remove the first element because it is the title
@@ -161 +165 @@
        print(' firstname %s' % firstname)
 
+    temp = sh.col_values(colarrival)
+    # remove the first element because it is the title
+    temp[0] = ''
+    temp = filter(lambda temp: temp != '', temp)
+    # transform to datetime
     arrival = []
-    arrival = sh.col_values(colarrival)
-    # remove the first element because it is the title
-    arrival[0] = ''
-    arrival = filter(lambda arrival: arrival != '', arrival)
+    for rownum in range(len(temp)):
+        #++ pb sh.datemodearrival = datetime.datetime(*xlrd.xldate_as_tuple(temp[rownum],sh.datemode))
+        arrival.append(datetime.datetime(*xlrd.xldate_as_tuple(temp[rownum],datemode)))
 
     if is_verbose == True:
@@ -171 +179 @@
        print(' arrival %s' % arrival)
 
+    temp = sh.col_values(coldeparture)
+    # remove the first element because it is the title
+    temp[0] = ''
+    temp = filter(lambda temp: temp != '', temp)
+    # transform to datetime
     departure = []
-    departure = sh.col_values(coldeparture)
-    # remove the first element because it is the title
-    departure[0] = ''
-    departure = filter(lambda departure: departure != '', departure)
+    for rownum in range(len(temp)):
+        #++ pb sh.datemodedeparture = datetime.datetime(*xlrd.xldate_as_tuple(temp[rownum],sh.datemode))
+        departure.append(datetime.datetime(*xlrd.xldate_as_tuple(temp[rownum],datemode)))
 
     if is_verbose == True:
@@ -181 +193 @@
        print(' departure %s' % departure)
 
-    publi = []
     publi = sh.col_values(colpubli)
     # remove the first element because it is the title