rarfell
feat: Improve import flow datetime conversion
Prerequisites
- [x] I have searched for existing issues that already include this feature request, without success.
Describe the Feature Request
Currently the import flow is as follows:
- Select file
- Choose columns
- Link categories (can take a little while to do manually as it doesn't match them automatically)
- Set datetime format
Fail datetime format with no error message.
This makes it really frustrating to import data to Dime and I'd imagine most of the new users would start exactly here.
Describe the Use Case
Importing new data from another app.
Additional Information
No response
Hi, thanks for opening this issue.
Could you show me what CSV you tried to import?
Hey, sure.
Example input file:
Date,Amount,Source Currency,Target Currency,Exchange Rate,Budget Book,Account,Folder,Category,Payee,Tags,Notes
2023-09-25T23:00:00,-44.97,EUR,EUR,1.0,"Main Book","Default Account","Needs","Healthcare","","","Healthcare"
2023-09-29T08:59:43,-40.0,EUR,EUR,1.0,"Main Book","Default Account","Needs","Healthcare","","","Healthcare"
2023-09-29T20:00:05,-25.0,EUR,EUR,1.0,"Main Book","Default Account","Wants","Food & Drinks","","","Food & Drinks"
2023-09-29T20:00:51,-4.5,EUR,EUR,1.0,"Main Book","Default Account","Wants","Cigs","","","Cigs"
2023-10-01T19:54:22,-23.29,EUR,EUR,1.0,"Main Book","Default Account","Wants","Gifts","","","Humble Bundle software eng"
2023-10-01T19:54:46,-12.5,EUR,EUR,1.0,"Main Book","Default Account","Wants","Food & Drinks","","","Pequeno almoço espinho"
2023-10-01T20:25:21,-15.0,EUR,EUR,1.0,"Main Book","Default Account","Wants","Food & Drinks","","","Almoço espinho"
2023-10-01T21:57:48,-38.0,EUR,EUR,1.0,"Main Book","Default Account","Needs","Household Items","","","Coco and eve"
2023-10-02T11:52:48,-4.5,EUR,EUR,1.0,"Main Book","Default Account","Wants","Cigs","","","Cigs"
2023-10-02T11:52:55,-12.99,EUR,EUR,1.0,"Main Book","Default Account","Needs","Transport","","","Transport"
2023-10-02T18:52:46,-20.0,EUR,EUR,1.0,"Main Book","Default Account","Needs","Healthcare","","","Healthcare"
2023-10-02T18:54:21,-13.0,EUR,EUR,1.0,"Main Book","Default Account","Wants","Personal Care","","","Personal Care"
2023-10-02T22:40:53,-39.0,EUR,EUR,1.0,"Main Book","Default Account","Wants","Fashion","","","Calças"
2023-10-03T22:23:03,-2.0,EUR,EUR,1.0,"Main Book","Default Account","Wants","Food & Drinks","","","Food & Drinks"
Date format: yyyy-MM-ddTHH:mm:ss
Well, it would be both:
-
Bug report: date time column is not parsed when provided the correct date time format
-
Feature: parse all date time values when the format is requested and provide the user with feedback, allowing them to change the format until they get it right. As of now, you need to finish the importing process only to find out it failed (and thus have to redo all the category linking process, which is very tedious).
@rodrigogonegit Hey, I'm curious why you're switching from Budget Flow (I presume) to Dime. I'm actually considering the opposite switch, moving from Dime to Budget Flow. There are a decent number of features I need that aren't available with Dime, and almost all of them are open issues (having been opened for more than a month). It seems to me that the rate of development is quite slow; critical bugs haven't been fixed, important feature requests haven't been added, but then again I understand that it's an open source project and I don't hold that against anyone. (I really want to use Dime though, if bugs can be fixed and features built then i'd absolutely love to stay)
