[GNC] Can I Prevent OFX/QFX Import Overwriting Notes?

gcul209 at mynym.us gcul209 at mynym.us
Fri Aug 27 10:43:26 EDT 2021


Neat!  I used to have that issue, but then that particular bank 
discontinued one of the account types AND stopped offering OFX 
downloads.  Never thought to consider it a bug or even a feature request.

I also had issues where two identical transfers wouldn't match properly 
(as described early in that comment thread), but I just manually copied 
the description from one to the other and manually marked it cleared as 
well.  That issue is also gone because the bills from one provider are 
paid off and I've managed to get the other provider to accept a single 
transaction instead of two identical ones.  I guess I never thought 
about a bug report or feature request on that one, either.

Maybe this particular import function is subconsciously more important 
to me than I realize.

On 8/27/21 10:32 AM, David Carlson wrote:
> Sorry, I didn't have the bug number handy when I posted. 
> https://bugs.gnucash.org/show_bug.cgi?id=105334 
> <https://bugs.gnucash.org/show_bug.cgi?id=105334>.
>
> On Fri, Aug 27, 2021 at 9:16 AM <gcul209 at mynym.us 
> <mailto:gcul209 at mynym.us>> wrote:
>
>     Thanks for the suggestion.  I'd be interested in seeing that bug
>     if you
>     want to drop a link / bug number.  I filed a new bug (798296) for the
>     regression I'm experiencing since the previously mentioned bug was
>     for a
>     different field.  In my case, I think NOT importing the files at
>     all and
>     just reconciling manually would be easier.  When the data doesn't
>     match,
>     I could start an import to compare / find the difference, but then
>     not
>     complete it.  I'd like my data to match the statement, but it's not
>     necessary enough for me to manually transfer every note one at a
>     time on
>     a monthly basis. If that's where I land, I'll start using the
>     Description field instead of the Notes field. One account will
>     have the
>     metadata for one month because I didn't want to lose changes made
>     prior
>     to that import, and all accounts will be descriptionless for some
>     period
>     of time thereafter, but I'll still have all the numbers.
>
>     On 8/27/21 9:57 AM, David Carlson wrote:
>     > I know it is an extra step, but for a work-around I manually adjust
>     > the existing transaction during the import so I know which new
>     one(s)
>     > match it.  Then I accept the incoming transaction as new. 
>     Finally, as
>     > a post processing step i manually merge the text that i want to
>     keep
>     > into one and delete the other(s).
>     >
>     > In my case I am merging two "duplicate" transfers between accounts
>     > with an existing transaction containing additional text to retain
>     > incoming notes from both sides of the transfers. Luckily, there is
>     > usually only one or two in a given month.   There is another bug
>     > report in process to catch duplicate transfer transactions from an
>     > import so that should soon change.
>     >
>     > On Fri, Aug 27, 2021, 7:31 AM <gcul209 at mynym.us
>     <mailto:gcul209 at mynym.us>
>     > <mailto:gcul209 at mynym.us <mailto:gcul209 at mynym.us>>> wrote:
>     >
>     >     Big thanks! All three of your points were direct and clear.
>     >
>     >     You are right, I am choosing U+C because I want the date to
>     update
>     >     and
>     >     the description to populate.  As I stated, this is what I
>     used to
>     >     get.
>     >     I will definitely be checking that issue out and likely
>     commenting.
>     >
>     >     On 8/27/21 4:46 AM, Jim DeLaHunt wrote:
>     >     >
>     >     > On 2021-08-26 13:55, gcul209 at mynym.us
>     <mailto:gcul209 at mynym.us> <mailto:gcul209 at mynym.us
>     <mailto:gcul209 at mynym.us>>
>     >     wrote:
>     >     >> I wouldn't be surprised if this has been asked in the
>     past, but I
>     >     >> don't know of a good way to search the archives for these
>     mailing
>     >     >> lists...
>     >     >
>     >     > Most web search tools respect
>     >     > 'https://lists.gnucash.org/pipermail/gnucash-user/
>     <https://lists.gnucash.org/pipermail/gnucash-user/>
>     >     <https://lists.gnucash.org/pipermail/gnucash-user/
>     <https://lists.gnucash.org/pipermail/gnucash-user/>>' as a way of
>     >     > restricting the search to the gnucash-user mailing list
>     >     archives. That
>     >     > might help you search the archives.
>     >     >
>     >     >
>     >     >> … Previously, on the PC, my manually entered notes were NOT
>     >     >> overwritten.  Now that I'm on the Mac, the notes are being
>     >     >> overwritten by that arcane data, but I don't know if that
>     is a
>     >     PC vs
>     >     >> Mac thing or a version change thing.…
>     >     >
>     >     > It might also be a "you are using the software
>     differently" thing.
>     >     > Check in the transaction matcher window, which appears
>     during the
>     >     > transaction import. If the status column reads "C", then
>     your notes
>     >     > and memo field should stay unchanged. If it reads "U+C",
>     then the
>     >     > notes and memo fields from the imported file should
>     replace your
>     >     notes
>     >     > and memo fields. See documentation at
>     >     >
>     <https://www.gnucash.org/viewdoc.phtml?rev=4&lang=C&doc=help
>     <https://www.gnucash.org/viewdoc.phtml?rev=4&lang=C&doc=help>
>     >     <https://www.gnucash.org/viewdoc.phtml?rev=4&lang=C&doc=help
>     <https://www.gnucash.org/viewdoc.phtml?rev=4&lang=C&doc=help>>>,
>     >     > especially "Table 6.1. Import Status of Transactions".
>     >     >
>     >     >
>     >     >> …I don't really want to lose my manually entered data,
>     but I would
>     >     >> like to have the bank data imported an synchronized as
>     well.  Is
>     >     >> there anything I can do so that the generic transaction
>     >     information
>     >     >> doesn't overwrite my previously entered notes?
>     >     >
>     >     > GnuCash does not offer that option, as far as I know. I
>     wish it
>     >     would.
>     >     > Maybe you have thoughts to add to Bug 797678 - "OFX
>     importer should
>     >     > supplement, not replace, existing Notes (and Description
>     and Memo)
>     >     > fields" at
>     <https://bugs.gnucash.org/show_bug.cgi?id=797678
>     <https://bugs.gnucash.org/show_bug.cgi?id=797678>
>     >     <https://bugs.gnucash.org/show_bug.cgi?id=797678
>     <https://bugs.gnucash.org/show_bug.cgi?id=797678>>>.
>     >     >
>     >     > Best regards,
>     >     >
>     >     >      —Jim DeLaHunt
>     >     >
>     >     > _______________________________________________
>     >     > gnucash-user mailing list
>     >     > gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
>     <mailto:gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>>
>     >     > To update your subscription preferences or to unsubscribe:
>     >     > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>     <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>     >     <https://lists.gnucash.org/mailman/listinfo/gnucash-user
>     <https://lists.gnucash.org/mailman/listinfo/gnucash-user>>
>     >     > If you are using Nabble or Gmane, please see
>     >     > https://wiki.gnucash.org/wiki/Mailing_Lists
>     <https://wiki.gnucash.org/wiki/Mailing_Lists>
>     >     <https://wiki.gnucash.org/wiki/Mailing_Lists
>     <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.
>     >     _______________________________________________
>     >     gnucash-user mailing list
>     > gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
>     <mailto:gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>>
>     >     To update your subscription preferences or to unsubscribe:
>     > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>     <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>     >     <https://lists.gnucash.org/mailman/listinfo/gnucash-user
>     <https://lists.gnucash.org/mailman/listinfo/gnucash-user>>
>     >     If you are using Nabble or Gmane, please see
>     > https://wiki.gnucash.org/wiki/Mailing_Lists
>     <https://wiki.gnucash.org/wiki/Mailing_Lists>
>     >     <https://wiki.gnucash.org/wiki/Mailing_Lists
>     <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.
>     >
>     _______________________________________________
>     gnucash-user mailing list
>     gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
>     To update your subscription preferences or to unsubscribe:
>     https://lists.gnucash.org/mailman/listinfo/gnucash-user
>     <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>     If you are using Nabble or Gmane, please see
>     https://wiki.gnucash.org/wiki/Mailing_Lists
>     <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.
>
>
>
> -- 
> David Carlson


More information about the gnucash-user mailing list