Revision cb992c06
Export CSV : valeurs de temps sous forme texte : Annee/Mois/Jour Heure:Minutes:Secondes pour nom fichier et colonne timestamp dans fichier
git-svn-id: https://vigilo-dev.si.c-s.fr/svn@2321 b22e2e97-25c9-44ff-b637-2e5ceca36478
| vigigraph/controllers/rpc.py | ||
|---|---|---|
| 24 | 24 |
from pylons.i18n import ugettext as _ |
| 25 | 25 |
|
| 26 | 26 |
import time |
| 27 |
import datetime |
|
| 27 | 28 |
import random |
| 28 | 29 |
import urllib |
| 29 | 30 |
import urllib2 |
| ... | ... | |
| 33 | 34 |
import string |
| 34 | 35 |
|
| 35 | 36 |
from time import gmtime, strftime |
| 37 |
from datetime import datetime |
|
| 36 | 38 |
|
| 37 | 39 |
from searchhostform import SearchHostForm |
| 38 | 40 |
|
| ... | ... | |
| 490 | 492 |
break |
| 491 | 493 |
|
| 492 | 494 |
if b_export: |
| 495 |
# plage temps sous forme texte |
|
| 496 |
format = '%Y%m%d-%H%M%S' |
|
| 497 |
|
|
| 498 |
dt = datetime.utcfromtimestamp(int(start)) |
|
| 499 |
str_start = dt.strftime(format) |
|
| 500 |
|
|
| 501 |
dt = datetime.utcfromtimestamp(int(end)) |
|
| 502 |
str_end = dt.strftime(format) |
|
| 503 |
|
|
| 493 | 504 |
# nom fichier |
| 494 | 505 |
filename = host |
| 495 | 506 |
filename += "_" |
| 496 | 507 |
filename += indicator_f |
| 497 | 508 |
filename += "_" |
| 498 |
filename += str(start)
|
|
| 509 |
filename += str_start
|
|
| 499 | 510 |
filename += "_" |
| 500 |
filename += str(end)
|
|
| 511 |
filename += str_end
|
|
| 501 | 512 |
|
| 502 | 513 |
# nom fichier final |
| 503 | 514 |
lc = [' ', '|', '/', '\\', ':', '?', '*', '<', '>', '"'] |
| ... | ... | |
| 566 | 577 |
''' |
| 567 | 578 |
|
| 568 | 579 |
# valeurs |
| 580 |
format = '%Y/%m/%d %H:%M:%S' |
|
| 569 | 581 |
if dict_values is not None or \ |
| 570 | 582 |
dict_values != "{}":
|
| 571 | 583 |
for key_tv in dict_values: |
| ... | ... | |
| 573 | 585 |
dict_data = {}
|
| 574 | 586 |
for key_i in dict_indicators: |
| 575 | 587 |
iv = dict_indicators[key_i] |
| 576 |
# remplacement . par , |
|
| 577 | 588 |
v = str(tv[key_i]) |
| 589 |
|
|
| 590 |
# temps sous forme texte |
|
| 591 |
if iv == 'TimeStamp': |
|
| 592 |
dt = datetime.utcfromtimestamp(int(v)) |
|
| 593 |
v = dt.strftime(format) |
|
| 594 |
|
|
| 595 |
# remplacement . par , |
|
| 578 | 596 |
v = v.replace(".", sep_value)
|
| 597 |
|
|
| 579 | 598 |
dict_data[iv] = v |
| 580 | 599 |
writer.writerow(dict_data) |
| 581 | 600 |
finally: |
Also available in: Unified diff