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

David Carlson david.carlson.417 at gmail.com
Fri Aug 27 10:32:09 EDT 2021 

Sorry, I didn't have the bug number handy when I posted.
https://bugs.gnucash.org/show_bug.cgi?id=105334.

On Fri, Aug 27, 2021 at 9:16 AM <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>> 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>
> >     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/>' 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>>,
> >     > 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>>.
> >     >
> >     > Best regards,
> >     >
> >     >      —Jim DeLaHunt
> >     >
> >     > _______________________________________________
> >     > 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.
> >     _______________________________________________
> >     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.
> >
> _______________________________________________
> 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.
>


-- 
David Carlson

More information about the gnucash-user mailing list