summaryrefslogtreecommitdiffstats
path: root/format-weekly-calendar.py
blob: 6cc44de6dd033d4035e7ee16439d2a6321ad1d9a (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
#!/usr/bin/python


# created by James Laska <jlaska@redhat.com>

# modified by John Poelstra <poelstra@redhat.com>


# This script parses csv files created with a custom report by TaskJuggler 

# It is used to send reminders of upcoming tasks to the team lists


import os
import sys

if len(sys.argv) == 2:
    fname = sys.argv[1]
else:
    print "Usage: %s <filename>" % sys.argv[0]
    sys.exit(1)

#print "   Start               End                        Name"

fd = open(fname, "r")
for line in fd.readlines():
    #line.strip()

    (start, end, name) = line[:-1].split(";")

    # remove quotes

    name = name.replace('"', '')
    start = start.replace('"', '')
    end = end.replace('"', '')
    print "%-11s %-11s %s" % (start, end, name )
fd.close()