[GNC] Import question

[Adrien Monteleone]

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