Re: [GNC] CSV Importer - Debit vs Credit

2024-07-05 Thread Paul Kroitor
: Thursday, July 4, 2024 1:45 PM To: CWheeler Cc: gnucash-user@gnucash.org Subject: Re: [GNC] CSV Importer - Debit vs Credit Yes, sadly. Only CSV and XLS remain. Sent from my iPad > On Jul 4, 2024, at 1:19 PM, CWheeler wrote: > > I'm in Ontario; maybe they haven't rolled tha

Re: [GNC] CSV Importer - Debit vs Credit

2024-07-05 Thread Kalpesh Patel
: Thursday, July 04, 2024 1:17 PM To: 'Kalpesh Patel' ; gnucash-user@gnucash.org Subject: Re: [GNC] CSV Importer - Debit vs Credit I can easily write a little Python thingie and put it in my right-click menu, but it's just an added annoyance in this increasingly annoying world.

Re: [GNC] CSV Importer - Debit vs Credit

2024-07-04 Thread Patrick James
Paul, It has been my personal experience that importing double quotes can be problematic for GNUCash, so I always remove all the double quotes during my pre-processing of the data. The bug report is here: https://bugs.gnucash.org/show_bug.cgi?id=798479 > On 07/04/2024 12:40 PM PDT Paul Kroi

Re: [GNC] CSV Importer - Debit vs Credit

2024-07-04 Thread Paul Kroitor
nded. NB: since " is used in the actual data, I'm using ' above as a delimiter and " as a character in the string. -Original Message- From: Kalpesh Patel Sent: Thursday, July 4, 2024 1:20 PM To: 'Paul Kroitor' ; gnucash-user@gnucash.org Subject: RE: [GNC] CSV Importe

Re: [GNC] CSV Importer - Debit vs Credit

2024-07-04 Thread Paul Kroitor
ption somewhere to use the old site, but I thought I would get out >> ahead of this. >> >> -Original Message- >> From: gnucash-user On >> Behalf Of wheelercsg-lists--- via gnucash-user >> Sent: Thursday, July 4, 2024 1:00 PM >> To: gnucash-user@g

Re: [GNC] CSV Importer - Debit vs Credit

2024-07-04 Thread Kalpesh Patel
ied how it imports, you can save that as a template to use it next time in the future so you don't have to figure it out again. -Original Message- From: Kalpesh Patel Sent: Thursday, July 04, 2024 12:59 PM To: 'Paul Kroitor' ; 'gnucash-user@gnucash.org' Subject: RE: [

Re: [GNC] CSV Importer - Debit vs Credit

2024-07-04 Thread CWheeler via gnucash-user
because that results in a QFX download, which GnuCash can import. On 2024-07-04 12:00 p.m., gnucash-user-requ...@gnucash.org wrote: Date: Thu, 4 Jul 2024 11:30:29 -0400 From: "Paul Kroitor" To: Subject: [GNC] CSV Importer - Debit vs Credit Message-ID:<02c201dace27$1a8f5b60$4fae1220$@kr

Re: [GNC] CSV Importer - Debit vs Credit

2024-07-04 Thread Paul Kroitor
org Subject: RE: [GNC] CSV Importer - Debit vs Credit Sadly, you will have to do some pre-processing before import. Put minus sign in front of debits or credits, depending upon how the book is setup. GNUCash does not have a conditional way of importing data in CSV by looking at a column. CSV files can b

Re: [GNC] CSV Importer - Debit vs Credit

2024-07-04 Thread Paul Kroitor
ash-user Sent: Thursday, July 4, 2024 1:00 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] CSV Importer - Debit vs Credit Hi, Paul, I have a TD Bank account, so I looked at the available options. If you choose "Microsoft Money", that appears to result in an OFX download. I usually

Re: [GNC] CSV Importer - Debit vs Credit

2024-07-04 Thread wheelercsg-lists--- via gnucash-user
0 p.m., gnucash-user-requ...@gnucash.org wrote: Date: Thu, 4 Jul 2024 11:30:29 -0400 From: "Paul Kroitor" To: Subject: [GNC] CSV Importer - Debit vs Credit Message-ID:<02c201dace27$1a8f5b60$4fae1220$@kroitor.ca> Content-Type: text/plain; charset="us-ascii" I&#

Re: [GNC] CSV Importer - Debit vs Credit

2024-07-04 Thread Kalpesh Patel
Message- From: Paul Kroitor Sent: Thursday, July 04, 2024 11:30 AM To: gnucash-user@gnucash.org Subject: [GNC] CSV Importer - Debit vs Credit I'm sure this has been asked in a dozen different variations over the years but I'm now faced with the issue myself since I now need to u

Re: [GNC] CSV Importer - Debit vs Credit

2024-07-04 Thread Paul Kroitor
be a fairly common request though -- maybe the importer could be enhanced to deal with this situation. -Original Message- From: gnucash-user On Behalf Of Deva via gnucash-user Sent: Thursday, July 4, 2024 12:15 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] CSV Importer - Debit vs C

Re: [GNC] CSV Importer - Debit vs Credit

2024-07-04 Thread Deva via gnucash-user
oitor" To: Subject: [GNC] CSV Importer - Debit vs Credit Message-ID: <02c201dace27$1a8f5b60$4fae1220$@kroitor.ca> Content-Type: text/plain; charset="us-ascii" I'm sure this has been asked in a dozen different variations over the years but I'm now faced with the

[GNC] CSV Importer - Debit vs Credit

2024-07-04 Thread Paul Kroitor
I'm sure this has been asked in a dozen different variations over the years but I'm now faced with the issue myself since I now need to use CSV for downloading (I hate TD Bank, who have removed the OFX download option). I can't immediately find any old messages describing this particular issue, so