summaryrefslogtreecommitdiff
path: root/app/income/parser.py
blob: 9524902fa5a364e57b05576efbffdfab0032291a (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
with open('timesheet.csv', newline='') as csvfile:
    reader = csv.reader(csvfile, delimiter=';')
    counter = 0
    f = "%Y-%m-%d %H:%M:%S"               
    for row in reader:
        if counter > 0:
            timer = row[0]+' '+row[1]
            timerer = row[0]+' '+row[2]
            time_start = datetime.datetime.strptime(timer, f)
            time_end = datetime.datetime.strptime(timerer, f)
            print(row[4])
            print(timerer, time_end)
            InvoiceItem.objects.get_or_create(
                time_start=time_start,
                time_end=time_end,
                work_done=row[4]
            )
        counter = counter +1
f = "%Y-%m-%d %H:%M:%S"