Re: [GNC] How to reimport an ofx file?

[john]

If the OFX files are made correctly then that means the transactions are 
already recorded in the account.

Each transaction in an OFX import has an FITID that is supposed to be unique 
for the source institution. When creating a new transaction or matching an 
existing one GnuCash records the FITID as the transaction's online-id after 
first searching all transactions in the account for that FITID and finding no 
match.

A few users have reported that their banks' software screws up the FITIDs so 
that they're unique within the downloaded file but are repeated across multiple 
files and that breaks GnuCash's duplicate detection. Check your OFX files 
(they're plain text) and see if the FITIDs are being reused. If they are you 
can write a simple program in your favorite scripting language to add something 
uniique--maybe the file's date as MMDD or a serial number--to every FITID. 
Keep the script around, you'll need to apply it to all future imports from that 
bank until they fix their OFX export software.

Regards,
John Ralls


> On Feb 19, 2024, at 22:25, jeffrey black  wrote:
> 
> I'll give it a try. The last time I tried it I was told that all transactions 
> had ben imported.
> 

___
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] How to reimport an ofx file?

[jeffrey black]

I'll give it a try. The last time I tried it I was told that all transactions 
had ben imported.

Get Outlook for Android<https://aka.ms/AAb9ysg>

From: David Carlson 
Sent: Monday, February 19, 2024 11:53:50 PM
To: jeffrey black 
Cc: GnuCash-User@GnuCash.Org 
Subject: Re: [GNC] How to reimport an ofx file?

Jeffrey,

My regular procedure involves intentionally deleting some OFX imported 
transactions after I have replaced them with transactions that have more 
detailed descriptions and I have found that if I re-run an old OFX import file, 
those transactions will import again.  So in your case, I would expect missing 
transactions to re-appear without any special editing of the import files.  
Because I have the room on my backup devices, I never delete old OFX files, I 
just move them to different folders.

On Mon, Feb 19, 2024 at 11:23 PM jeffrey black 
mailto:beastmaster...@hotmail.com>> wrote:
I'm not going into great detail here but I had a surge suppressor  strip 
explode when I turned it off.  It is way out of its warranty period so no help 
there. It fried my server, laptop, printer, 3 external drives, 3 USB Backuo 
drives, and 2 SSD drives ( which i just found out are non-recoverable , 
period).  But thankfully not the drives my GNC datafiles were on.

Anyways, my question to the GNC community is that I imported an account via OFX 
and forgot to reconcile it.  Know I find out that there are several hundred 
transactions that were never imported.

How can I convince  GNC to import the missing transactions via OFX?  And do not 
ask me which version of GNC I was running because I do not remember and cannot 
access that drive.  98% of the time I was running GNC under Ubuntu (I hate  
WindoZe and very seldom use it).

--  Jeffrey  Black, M.B.A.

(Forgive my poor spelling and explanation. These little keyboards on a phone 
are too small for my fumble fingers.  And spell check cannot spelll any better 
than I can.  I'm still trying to setup a new server and a new network.)

-- Jeffrey Black, M.B.A.


Get Outlook for Android<https://aka.ms/AAb9ysg>
___
gnucash-user mailing list
gnucash-user@gnucash.org<mailto: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.


--
David Carlson
___
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] How to reimport an ofx file?

[David Carlson]

Jeffrey,

My regular procedure involves intentionally deleting some OFX imported
transactions after I have replaced them with transactions that have more
detailed descriptions and I have found that if I re-run an old OFX import
file, those transactions will import again.  So in your case, I would
expect missing transactions to re-appear without any special editing of the
import files.  Because I have the room on my backup devices, I never delete
old OFX files, I just move them to different folders.

On Mon, Feb 19, 2024 at 11:23 PM jeffrey black 
wrote:

> I'm not going into great detail here but I had a surge suppressor  strip
> explode when I turned it off.  It is way out of its warranty period so no
> help there. It fried my server, laptop, printer, 3 external drives, 3 USB
> Backuo drives, and 2 SSD drives ( which i just found out are
> non-recoverable , period).  But thankfully not the drives my GNC datafiles
> were on.
>
> Anyways, my question to the GNC community is that I imported an account
> via OFX and forgot to reconcile it.  Know I find out that there are several
> hundred transactions that were never imported.
>
> How can I convince  GNC to import the missing transactions via OFX?  And
> do not ask me which version of GNC I was running because I do not remember
> and cannot access that drive.  98% of the time I was running GNC under
> Ubuntu (I hate  WindoZe and very seldom use it).
>
> --  Jeffrey  Black, M.B.A.
>
> (Forgive my poor spelling and explanation. These little keyboards on a
> phone are too small for my fumble fingers.  And spell check cannot spelll
> any better than I can.  I'm still trying to setup a new server and a new
> network.)
>
> -- Jeffrey Black, M.B.A.
>
>
> Get Outlook for Android
> ___
> 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.
>


-- 
David Carlson
___
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.

[GNC] How to reimport an ofx file?

[jeffrey black]

I'm not going into great detail here but I had a surge suppressor  strip 
explode when I turned it off.  It is way out of its warranty period so no help 
there. It fried my server, laptop, printer, 3 external drives, 3 USB Backuo 
drives, and 2 SSD drives ( which i just found out are non-recoverable , 
period).  But thankfully not the drives my GNC datafiles were on.

Anyways, my question to the GNC community is that I imported an account via OFX 
and forgot to reconcile it.  Know I find out that there are several hundred 
transactions that were never imported.

How can I convince  GNC to import the missing transactions via OFX?  And do not 
ask me which version of GNC I was running because I do not remember and cannot 
access that drive.  98% of the time I was running GNC under Ubuntu (I hate  
WindoZe and very seldom use it).

--  Jeffrey  Black, M.B.A.

(Forgive my poor spelling and explanation. These little keyboards on a phone 
are too small for my fumble fingers.  And spell check cannot spelll any better 
than I can.  I'm still trying to setup a new server and a new network.)

-- Jeffrey Black, M.B.A.


Get Outlook for Android
___
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.