[GNC] Data load from CSV files - duplicates

Leo Vaccaneo leovplex at outlook.com
Tue Nov 23 01:27:29 EST 2021


Thanks again to all,

David T's response note below - " clarify things - not trying to assign the split to an account-- you're trying to tell the importer that the transaction already exists in the file, and you want to match up the new transaction with the existing old one.  - with the terminology statement. "

is on the button of what I am hoping it is possible to do.

When I did my second import from CSV, on the matching screen, I chose the credit account, but I didn't really look for any other options.

I will do it again and look for some way to get to a transaction.
---

I 've checked on my bank site, and I do have the other export options
[cid:b41464d8-75f6-4406-bedc-1ab19a00d389]

SO, I will also try the imports again, from a QIF file

Thanks again

Leo Vaccaneo


________________________________
From: D. <sunfish62 at yahoo.com>
Sent: Tuesday, 23 November 2021 1:37 PM
To: Leo Vaccaneo <leovplex at outlook.com>
Cc: David Carlson <david.carlson.417 at gmail.com>; D. via gnucash-user <gnucash-user at gnucash.org>
Subject: Re: Re: [GNC] Data load from CSV files - duplicates

Leo,

In case it helps clarify things, I'll note that in the second import, you're not trying to assign the split to an account-- you're trying to tell the importer that the transaction already exists in the file, and you want to match up the new transaction with the existing old one. That's what I was getting at with the terminology statement.

I don't do much importing any more, but I thought there was a spot in the process where you were given the opportunity to match incoming transactions with ones that are already in the file. But maybe that isn't the case with csv?

David T.
________________________________
From: Leo Vaccaneo
Sent: Mon Nov 22 20:46:16 EST 2021
To: "D." , David Carlson
Cc: Gnucash Users
Subject: Re: Re: [GNC] Data load from CSV files - duplicates

Thanks to David T and David Carlson -

to David T (and David Carlson) -
yes - I believe you have hit what I am looking for - so, trying to say it again in a hopefully helpful way -

being able to assign / match (the term in the CSV importer process) the second split of the transaction being loaded -

to an existing transaction in the 'destination' 'other side / end of the transaction' account -

instead of creating a replica of the trans being loaded - as the second split -in the 'destination' 'other side / end of the transaction' account
---

to David Carlson -

I will work my way through each of your suggestions, and give an update -

The GNU installer was downloaded yesterday.

The rest - I will need to work through.

Sounds like it will be well worth my while to try the QIF import if I can get that format export from my bank (have to check).

Thanks again to all

Leo Vaccaneo


________________________________
From: D. <sunfish62 at yahoo.com>
Sent: Monday, 22 November 2021 9:47 PM
To: David Carlson <david.carlson.417 at gmail.com>
Cc: Leo Vaccaneo <leovplex at outlook.com>; Gnucash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] Data load from CSV files - duplicates

...Fifth, I think Leo is using the term "match" to refer to the process of *assigning* the second split to an account. ISTR that there is a step in the process where the user can actually match imported transactions to existing ones, along with the option to use the existing description or replace it, which would eliminate that occurrence of a second transaction. Or perhaps I'm just getting senile.

David T.
________________________________
From: David Carlson
Sent: Mon Nov 22 05:21:16 EST 2021
To: Leo Vaccaneo
Cc: "gnucash-user at gnucash.org"
Subject: Re: [GNC] Data load from CSV files - duplicates


There are a number of things that may be impacting your results.

First, check Edit > Preferences > Online Banking to be sure that options
under Generic Importer are still checked and the values listed are
reasonable.

Second, the entire chapter 16 of the Help manual has details that come into
play.  Reread <
https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#trans-import-matcher







Third, there have been some issues with some parts of the CSV and Generic
importers that have been discussed here in the last several weeks.  The
exact release of your GnuCAsh program could make a difference.  Please tell
us which version and which OS you are using.

Fourth,  while the OFX/QFX and QIF importers have some issues as well, they
have the advantage of being more mature and their limitations are better
understood by users.  If your bank offers either of these types of exports,
try them.  The QIF seems to work well for initial imports, taken in fairly
small chunks, say a month's data at a time.

When you have distilled your results to more specific issues, users here
can give better advice to address your problems.

On Mon, Nov 22, 2021 at 3:20 AM Leo Vaccaneo <leovplex at outlook.com> wrote:




     Greetings from Cairns Qld Australia,



 I have my new accounts hierarchy data saved in a new file in the SQLite

 format.



 I have read the concepts guide & help docs.



 I have searched with our favourite search engine around the issue of

 imports from CSV etc files, and matching, and how to sort out duplicates



 I am somewhat aghast at the outcomes mentioned - deleting duplicates

 and/or doing reversals.



 I am therefore going to be more verbose than the mail list items

 questioners I found, to set out my frustration.

 ---



 I created a new file to do this test. I completely deleted all

 transactions from a previous file, the account balances all read zero, and

 saved this as my new test file.



 In my accounts, I have an assets, savings acct.   I have a csv file of

 savings account transactions export from my bank.



 In my accounts, I have a liabilities, credit card acct.   I have a csv

 file of credit card transactions export from my bank.



 These are my first 2 imports.



 I imported the credit card transactions first, from CSV.



 In the matching stage, for payments into the credit card from the savings,

 GnuCash did not offer any matches

 I set the match to be the savings account.

 Loaded, no errors, -



 And it created transactions in the savings account (presumably the second

 split of the credit card account transactions)

 ---



 I then imported the savings account transactions from CSV.



 In the matching stage, for payments from the savings into the credit card,

 GnuCash did not offer any matches

 I set the match to be the credit card account.

 Loaded, no errors, -



 And it created transactions in the credit card account (presumably the

 second split of the savings account transactions)



 NOW, - I have 2 versions of each of these transactions, - which are in

 fact the same transaction, - in each of the savings, and, the credit card

 accounts!! completely fouling up balances.

 ---



 Have I done something wrong?



 I don't want to be manually trying to delete some transaction splits, or

 trying to delete or reverse some transactions -

   .  it would be just another manual tedious process

   .  I would likely do it wrong and break the transaction(s) completely.

 ---



 If I don't provide manual matching, the transactions all end up listed in

 the Imbalance acct.

 ---



 If I were to import the credit card transactions - without providing

 manual matching -



  When I then import the savings account transactions -



 How to I tell it that -

 This transaction - x - being loaded into this savings account should be

 matched to that existing transaction - y - in that credit card account

     AND - remove that transaction - y - from the Imbalance acct



 I find it quite frustrating that it appears that I have to match during

 both imports, and then do more manual jiggery pokery to sort out the

 duplicates!



 There has to be a better way.

 ---



 I have not tried it - BUT -

 Could I import the credit card transactions, with no matching - second

 splits will be in Imbalance -

 THEN, when I do savings import, - is it possible to do the matching to the

 credit card second split in the imbalance account - and end up without

 duplicates, and the transaction cleared from Imbalance??



 Hoping for enlightenment



 Leo Vaccaneo





________________________________


 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

 If you are using Nabble or Gmane, please see


    https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

 -----

 Please remember to CC this list on all your replies.

 You can do this by using Reply-To-List or Reply-All.



-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 5757 bytes
Desc: image.png
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20211123/9b6b5330/attachment.png>


More information about the gnucash-user mailing list