version 9 of stylesheet

1 files changed, 19 insertions, 0 deletions

diff --git a/app/income/parser.py b/app/income/parser.py
new file mode 100644
index 0000000..9524902
--- /dev/null
+++ b/app/income/parser.py
@@ -0,0 +1,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"