[GNC] Import question

Nicolas de La Chaise nicolas at delachaise.net
Sat Sep 2 16:49:58 EDT 2023


Good evening all,

Apologies for wasting everyone's time and thanks again for those who 
responded.
After looking at the csv import dialog with a fresh head, I realise I 
had both comma AND semicolon ticked as separators. The software was 
doing exactly as instructed to do.
Another instance of "problem between chair and keyboard".

Now I'm going to find a deep hole to bury myself in...

Regards,
Nicolas

On 31/08/2023 23:07, Nicolas de La Chaise via gnucash-user wrote:
> Hello all,
>
> First of all, I want to take this opportunity to thank all the posters 
> and developers who dedicate so much of their time to help the 
> ungrateful mass I belong to. You guys rock.
>
> Now, my silly problem...
>
> 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
>
>
>
> Thanks a lot!
> N.
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> 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.



More information about the gnucash-user mailing list