Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Not able to use drivvo nor generic CSV for import #86

Closed
stomko11 opened this issue Dec 2, 2023 · 1 comment
Closed

Not able to use drivvo nor generic CSV for import #86

stomko11 opened this issue Dec 2, 2023 · 1 comment

Comments

@stomko11
Copy link

stomko11 commented Dec 2, 2023

As title says, I am not able to import my fillups using neither drivvo nor generic CSV import option. I even have tried modifying csv output, left only 2 lines in it, changed decimal point from . to , but I always get generic error saying to check logs. Seeing these errors in docker:

2023/12/02 04:11:32 /api/service/userService.go:29
[0.752ms] [rows:2] SELECT * FROM `user_vehicles` WHERE `user_vehicles`.`user_id` = "21c16e1e-d186-49a4-adc7-495538da4493"

2023/12/02 04:11:32 /api/service/userService.go:29
[0.833ms] [rows:2] SELECT * FROM `vehicles` WHERE `vehicles`.`id` IN ("33d6cc9c-102f-4296-b99b-6b3a8e5c9a89","6cd88aff-dfca-455e-836e-daf39b1276b0")

2023/12/02 04:11:32 /api/service/userService.go:29
[2.590ms] [rows:1] SELECT * FROM `users` WHERE `ID` = "21c16e1e-d186-49a4-adc7-495538da4493" ORDER BY `users`.`id` LIMIT 1


2023/12/02 04:11:32 [Recovery] 2023/12/02 - 04:11:32 panic recovered:
time: missing Location in call to Date
/usr/local/go/src/time/time.go:1469 (0x4cea48)
/usr/local/go/src/time/format.go:1398 (0x4c896b)
/usr/local/go/src/time/format.go:1029 (0x4c672a)
/api/service/genericImportService.go:15 (0x97621e)
/api/service/importService.go:125 (0x977536)
/api/controllers/import.go:68 (0x97dbe9)
/go/pkg/mod/github.com/gin-gonic/gin@v1.7.1/context.go:165 (0x953aa1)
/go/pkg/mod/github.com/gin-gonic/gin@v1.7.1/recovery.go:99 (0x953a8c)
/go/pkg/mod/github.com/gin-gonic/gin@v1.7.1/context.go:165 (0x98ac63)
/api/main.go:69 (0x98ac4a)
/go/pkg/mod/github.com/gin-gonic/gin@v1.7.1/context.go:165 (0x953aa1)
/go/pkg/mod/github.com/gin-gonic/gin@v1.7.1/recovery.go:99 (0x953a8c)
/go/pkg/mod/github.com/gin-gonic/gin@v1.7.1/context.go:165 (0x952c06)
/go/pkg/mod/github.com/gin-gonic/gin@v1.7.1/logger.go:241 (0x952be9)
/go/pkg/mod/github.com/gin-gonic/gin@v1.7.1/context.go:165 (0x951cbd)
/go/pkg/mod/github.com/gin-gonic/gin@v1.7.1/gin.go:489 (0x95196b)
/go/pkg/mod/github.com/gin-gonic/gin@v1.7.1/gin.go:445 (0x9514a4)
/usr/local/go/src/net/http/server.go:2936 (0x6bdb75)
/usr/local/go/src/net/http/server.go:1995 (0x6b9091)
/usr/local/go/src/runtime/asm_amd64.s:1598 (0x46f120)

[GIN] 2023/12/02 - 04:11:32 | 500 |   10.389503ms |  192.168.X.X | POST     "/api/import/generic"

My CSV is pretty basic, for instance just 2 lines:

"Tachometer (km)","Dátum","Palivo","Cena / L","Celková cena","Objem","Plná nádrž","Druhé palivo","Cena / L","Celková cena","Objem","Plná nádrž" 2,"Tretie palivo","Cena / L","Celková cena","Objem","Plná nádrž" 3,"Účinnosť paliva","Vzdialenosť","Čerpacia stanica","Vodič","Dôvod","Spôsob platby","Poznámky"
"79785.0","2023-11-27 14:08:51","Benzín","1.569","44.983","28.67","Áno","","0","0","0","Nie","","0","0","0","Nie","0 L/100km","","INE","Name Name","","",""
"79377.0","2023-11-15 23:41:38","Benzín","1.599","43.797","27.39","Áno","","0","0","0","Nie","","0","0","0","Nie","7,027 L/100km","408.0","INE","Name Name","","",""

And here the error:
image

@vKnmnn
Copy link

vKnmnn commented Dec 17, 2023

probably what i'm facing too #80

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants