Not a integer exception when trying to import on a fresh install #1774
Comments
|
Could you share a few example lines (anonymised if necessary) and the config you're using? |
|
Thanks for the quick turnaround, I will try to use the commits and check. For now here's two examples of the few I have attempted: And something resembling my actual data: Also, here's my config: Note: Removed comments for brevity. Also, for completeness, here's the logs, when EDIT: Your commit 2ec310d fixed the uploading, part. Now only the understanding of the Expense account thing, and why the dates are wrong. |
|
What date format are you using when uploading? Looking at your CSV file, it should be I am not really sure what you mean with the expense account thing. Once the file has uploaded and imported, are they linked to a tag? What exactly is wrong there? |
|
And could you share the role you give each column? |
Shoot, I was using One minor quip, based on the roles: Right now for me this works: {
"file-type": "csv",
"date-format": "d\/m\/y",
"has-headers": true,
"delimiter": ",",
"apply-rules": false,
"specifics": [],
"import-account": 1,
"column-count": 7,
"column-roles": [
"date-transaction",
"description",
"_ignore",
"amount_negated",
"amount",
"external-id",
"_ignore"
],
"column-do-mapping": [
false,
false,
false,
false,
false,
false,
false
]
}Where the Debit Amount is a {
"file-type": "csv",
"date-format": "d\/m\/y",
"has-headers": true,
"delimiter": ",",
"apply-rules": false,
"specifics": [],
"import-account": 1,
"column-count": 7,
"column-roles": [
"date-transaction",
"description",
"_ignore",
"amount_debit",
"amount_credit",
"external-id",
"_ignore"
],
"column-do-mapping": [
false,
false,
false,
false,
false,
false,
false
]
}Also, what does Thanks for quick work, love what you have done, I was looking for something like this for ages. |
|
Glad to hear you like it. Always nice to get compliments 😁 For the amounts: Firefly III expects either one when you use the debit/credit types. This is useful when banks provide something like this: If this doesn't seem to work properly, make sure you turn on The "map these values" option is useful for fields like the "opposing account". Often you see stuff like this in CSV files: If you do nothing, Firefly III will create three expense accounts for just the one |
Ah yes, this worked perfectly fine. Debit and credit, worked great, Although, I might stick to the
This sort of makes sense, but not something I will be able to use, oh well, thanks for the info! Closing this issue now, you have been a great help in sort this out. |
I am running Firefly III version 4.7.7 on Raspberry Pi 3B
Description
When I try to import a csv, whenever I try to import a csv (tried multiple ones, including really simple ones such as those with just date and amount), I define the structure, and then I get a
Job could not be startederror, and then it goes to theApplying rulesstage, even though, I never ticked it in the first place.I keep getting the following error on the fpm log:
From some digging, the transactions are imported into an Expense Account, but they do not have the current date, and don't show up in expenses. This is weird as hell.
Also, to note, my transactions are in the past week, and the initial balance has been added on 7th October.
Any suggestions?
Steps to reproduce
Extra info
Bonus points
https://screenshotscdn.firefoxusercontent.com/images/61e5782f-10d2-4a34-9c05-f5283fd9364a.png
The text was updated successfully, but these errors were encountered: