Re: [GNC] Import question
Thank you for the clarification/education. On Sat, Sep 2, 2023 at 1:35 PM Fred Bone wrote: > On 02 September 2023 at 11:07, R Losey said: > > [...] > > 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. > > No. A field in a .CSV file that contains a comma will be enclosed in > (single or double) quote marks, so the program reading it will not have > any such problem. > > Otherwise it isn't a .CSV file but a text file that happens to have been > given a .CSV filetype. > > ___ > 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. > -- _ 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.
Re: [GNC] Import question
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@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. ___ 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.
Re: [GNC] Import question
On 02 September 2023 at 11:07, R Losey said: [...] > 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. No. A field in a .CSV file that contains a comma will be enclosed in (single or double) quote marks, so the program reading it will not have any such problem. Otherwise it isn't a .CSV file but a text file that happens to have been given a .CSV filetype. ___ 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.
Re: [GNC] Import question
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.
Re: [GNC] Import question
Did you try toggling the currency format you wanted to input. also check if your csv is reflecting the right format Saludos Cordiales Murugan From: gnucash-user on behalf of Nicolas de La Chaise via gnucash-user Sent: Thursday, August 31, 2023 5:07 PM To: gnucash-user@gnucash.org Subject: [GNC] Import question 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@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. ___ 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.
Re: [GNC] Import question
Hello Nicolas, I'm on GnuCash 5.3 already. Here you can freely choose the currency format in the import dialogue, i.e. the decimal separator can be changed from comma to point or vice versa. So updating your GnuCash could be very easy solution to your issue. Greetings Carsten Am 31.08.2023 um 23:07 schrieb Nicolas de La Chaise via gnucash-user: 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@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. ___ 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.
Re: [GNC] Import question
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 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.
Re: [GNC] Import question
Nicolas, You do not tell us what is your default currency. Gnucash is reasonably good with any of the major currencies and releaae 4.4 has a feature where it can save the csv import configuration for each variation that you may see. Others here can help you get the details correct. On Thu, Aug 31, 2023, 9: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? > > Note: > GNC 4.4 > Debian 10 > > > > Thanks a lot! > N. > ___ > 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. > ___ 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.