On Thu, Aug 31, 2023 at 10:15 PM Nicolas de La Chaise via gnucash-user < gnucash-user@gnucash.org> 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? > > Hi. The issue may be with the CSV (which stands for COMMA separated values)... if the currency contains commas, it will confuse anything that thinks it is separated by commas. If you open the CSV in a spreadsheet, is it confused? Can you use something other than a comma to separate the values? Perhaps bring the file into a spreadsheet, fix any problems, and then export with a different separator? I don't know if GnuCash will work on content separated by something other than a comma. -- _________________________________ Richard Losey rlo...@gmail.com Micah 6:8 _______________________________________________ gnucash-user mailing list gnucash-user@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.