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"
|