Nicolas,
Your screenshot didn't come through, likely because you pasted it
'inline' in the message, rather than explicitly attaching it. (inline
gets stripped from the message by the mailman software)
While I don't do imports regularly myself from other exported data, from
what I gather reading related threads on this list, CSV is likely your
better option than QIF unless you have some really good reason for using
QIF.
I'm sure there is a more direct approach to your immediate issue with
formatting, but a temporary solution would be to edit the CSV before
importing to change the comma to a decimal.
There are myriad tools to accomplish this, but an easy one would be to
open the CSV in your favorite spreadsheet app, select the column with
amounts, and do a Find & Replace on the Comma to a Decimal.
If you wanted to learn or already know awk or sed, you might save a few
keystrokes and mouse clicks each import by setting up a simple script to
accomplish the task. Someone may already have done this and maybe shared
it somewhere.
Then, proceed with your import.
Regards,
Adrien
On 8/31/23 4:07 PM, Nicolas de La Chaise via gnucash-user wrote:
My bank only offers 2 formats when exporting transactions: either QIF or
CSV.
If I choose to import in QIF, there is no way to see the amount of the
transaction that is being imported. I find it quite useful as some
online shopping transactions can fall into many different accounts.
Would it be possible to see it added in an upcoming version?
Now, to go around this I was hoping to use the csv format. Only to hit a
different problem. The CSV I import has French number formatting
(decimal separator is ','). And when the import tool runs it seems to
get awfully confused by it. In the screenshot below, amounts should be
(for UK/US readers) -50.8 / -40.0 / -5.7 / -1.6
I already poked around with encoding and currency format to no avail.
The amount is split in two and cannot be glued back together.
Do anyone has a workaround?
Note:
GNC 4.4
Debian 10
_______________________________________________
gnucash-user mailing list
[email protected]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
