Re: [GNC] Question about OFX imports
I do see a good reason to do so, at least in my use case. I am imagining case where if I were to download good number of transfers transactions (I do so for last three months in a moving window fashion through CSV, QIF and OFX imports), I could end up needing to touch many other accounts, possibly ones that were already reconciled after import would entail needless download again, and then re-imports again for those accounts, especially now that description can be appended from two sides of import of a transaction. Since CSV and QIF already permits reimport and reconciliation window, having the same capabilities on OFX/QFX would make the behavior consistent amongst three heavily used import methods in the States. I do not see any adverse effect from permitting it. If it finds same FITID, permit to update, update and reconcile existing one or just reconcile existing one. Just a thought -Original Message- From: Jean Laroche Sent: Monday, May 13, 2024 6:19 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] Question about OFX imports Also, you definitely would not want to double-import the same transaction, so there isn't a good reason to want to mock with the FITID. What *could* be useful (but in extremely rare cases) would be to force a re-import of the same transaction despite the fact that it's been imported previous, while avoiding a duplication (i.e. the second import would update the existing transaction instead of being skipped altogether). But I don't see a good reason to implement that at this point... Deleting the existing one achieves the same result for these rare cases. Jean On 5/13/24 3:12 PM, David Reiser via gnucash-user wrote: >> On May 13, 2024, at 17:50, David Carlson wrote: >> >> Now it is my turn to ask a question. >> >> My bank recently had an issue with the description text for a few >> transactions that resulted in the transactions being reposted with >> corrected descriptions. Now I am trying to import the corrected >> transactions but they do not appear in the OFX importer even though >> they are in the file generated by the bank. >> >> My question is: If I delete the previously imported transactions, can >> I import the corrected transactions? > yes. > >> A corollary; is there any way to check, edit or remove the FITID >> value of a transaction that prevents the duplicate import without >> doing tricks in the OFX file before importing? > only if you are willing to risk damaging your datafile editing it outside of > gnucash. The FITID values are stored as a key/value pair like: > > >online_id >20180906246910059666 > > > and finding specific transactions in the raw XML is harder than you might > imagine. The online_id is not available to the user anywhere in the gnucash > interface. > > I have never tried editing a gnucash SQL file outside of gnucash. > >> -- >> David Carlson >> ___ > > -- > Dave Reiser > dbrei...@icloud.com > > > > > > ___ > 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. ___ 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] Moving from GnuCash 4.8 to GnuCash 5.5 - any issues likely to bite me?
The Check & Repair used to be slow (minutes); somewhere along the way, there was a major improvement; it is so fast (less than a second) on my network file with 6+ years of data that I can barely see the progress bar. So, it may be running; just very, very quickly. On Mon, May 13, 2024 at 9:41 AM Phyllis Bruce wrote: > Just when you thought you were done with this….. > > I’m running 4.13 on a windows 10 computer. I have a big problem getting > any reports to run properly but today it is the check and repair function. > No option that I choose gives me a “working” indication. I’m trying to be > proactive before upgrading. Couldn’t find anything in the manual. > > > On May 12, 2024, at 3:30 AM, Chris Green wrote: > > > > On Sat, May 11, 2024 at 03:49:04PM -0500, Adrien Monteleone wrote: > >>> On 5/11/24 3:08 PM, Chris Green wrote: > >>> So, given that I'm going up just one major release I shouls be OK, but > >>> running "Check & Repair" before doing anything else is a good idea. > > > >> Correct. The Check & Repair should run silently automatically upon first > >> opening your file with 5.5, but it doesn't hurt to do it intentionally. > >> > >> The biggest change I recall between 4 & 5 is the new type-ahead search > >> method for the Description field. I personally prefer the change, but > >> some folks didn't like it by how they use that field and their unique > >> list of existing Descriptions. > >> > >> There is also an issue for some, but not others with respect to > >> registers not auto-filling memos from previous session transactions. > >> (I'm one so affected) Mileage may vary on that one. > >> > >> As always - keep a backup. > >> > >> And since you are not on the last 4.x release on the old machine, I > >> wouldn't go back and forth with the same file. Once you migrate, stick > >> to 5.5 or drop back to 4.8 and stay there until you decide to finally > >> make the upgrade should you notice any problems. > >> > > Thanks Adrien, that's just the sort of information/confirmation I > > wanted. :-) > > > ___ > 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. > -- _ Richard Losey rlo...@gmail.com Micah 6:8 ___ 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] Moving from GnuCash 4.8 to GnuCash 5.5 - any issues likely to bite me?
I think there were issues too with reports on Linux with NVIDIA graphics though there is a workaround and if I'm not mistaken, now also a fix. Regards, Adrien On 5/12/24 6:03 PM, Paul Kroitor wrote: You're on a Linux platform so it won't directly matter, but be aware that the Windows 5.5 version has a major bug (many reports don't work). It's fixed in 5.5.1 and 5.6, so if you ever share your data files into the Windows universe, it's unlikely it would be to 5.5. ___ 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] Question about OFX imports
Also, you definitely would not want to double-import the same transaction, so there isn't a good reason to want to mock with the FITID. What *could* be useful (but in extremely rare cases) would be to force a re-import of the same transaction despite the fact that it's been imported previous, while avoiding a duplication (i.e. the second import would update the existing transaction instead of being skipped altogether). But I don't see a good reason to implement that at this point... Deleting the existing one achieves the same result for these rare cases. Jean On 5/13/24 3:12 PM, David Reiser via gnucash-user wrote: On May 13, 2024, at 17:50, David Carlson wrote: Now it is my turn to ask a question. My bank recently had an issue with the description text for a few transactions that resulted in the transactions being reposted with corrected descriptions. Now I am trying to import the corrected transactions but they do not appear in the OFX importer even though they are in the file generated by the bank. My question is: If I delete the previously imported transactions, can I import the corrected transactions? yes. A corollary; is there any way to check, edit or remove the FITID value of a transaction that prevents the duplicate import without doing tricks in the OFX file before importing? only if you are willing to risk damaging your datafile editing it outside of gnucash. The FITID values are stored as a key/value pair like: online_id 20180906246910059666 and finding specific transactions in the raw XML is harder than you might imagine. The online_id is not available to the user anywhere in the gnucash interface. I have never tried editing a gnucash SQL file outside of gnucash. -- David Carlson ___ -- Dave Reiser dbrei...@icloud.com ___ 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. ___ 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] Question about OFX imports
> On May 13, 2024, at 17:50, David Carlson wrote: > > Now it is my turn to ask a question. > > My bank recently had an issue with the description text for a few > transactions that resulted in the transactions being reposted with > corrected descriptions. Now I am trying to import the corrected > transactions but they do not appear in the OFX importer even though they > are in the file generated by the bank. > > My question is: If I delete the previously imported transactions, can I > import the corrected transactions? yes. > A corollary; is there any way to check, edit or remove the FITID value of a > transaction that prevents the duplicate import without doing tricks in the > OFX file before importing? only if you are willing to risk damaging your datafile editing it outside of gnucash. The FITID values are stored as a key/value pair like: online_id 20180906246910059666 and finding specific transactions in the raw XML is harder than you might imagine. The online_id is not available to the user anywhere in the gnucash interface. I have never tried editing a gnucash SQL file outside of gnucash. > > -- > David Carlson > ___ -- Dave Reiser dbrei...@icloud.com ___ 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] Question about OFX imports
Yes, I believe that if you delete the previously imported transaction, the new one will be imported. For your 2nd question, there isn't a way to remove or edit that FITID value without hacking either the OFX or your database... I don't think GC ever shows you the FITID of transactions (even though they're saved in the database). Jean On 5/13/24 2:50 PM, David Carlson wrote: Now it is my turn to ask a question. My bank recently had an issue with the description text for a few transactions that resulted in the transactions being reposted with corrected descriptions. Now I am trying to import the corrected transactions but they do not appear in the OFX importer even though they are in the file generated by the bank. My question is: If I delete the previously imported transactions, can I import the corrected transactions? A corollary; is there any way to check, edit or remove the FITID value of a transaction that prevents the duplicate import without doing tricks in the OFX file before importing? ___ 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] Question about OFX imports
If it wasn’t many transactions cannot you just edit the cleared transactions? I’ m thinking Gnu won’t allow you to clear clear the nut ones as a feature to avoid duplicates. Alternatively, you might delete the cleared transactions and reimport. At least, that’s what I would do. > On May 13, 2024, at 4:51 PM, David Carlson > wrote: > > Now it is my turn to ask a question. > > My bank recently had an issue with the description text for a few > transactions that resulted in the transactions being reposted with > corrected descriptions. Now I am trying to import the corrected > transactions but they do not appear in the OFX importer even though they > are in the file generated by the bank. > > My question is: If I delete the previously imported transactions, can I > import the corrected transactions? > A corollary; is there any way to check, edit or remove the FITID value of a > transaction that prevents the duplicate import without doing tricks in the > OFX file before importing? > > -- > 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. ___ 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] Question about OFX imports
Now it is my turn to ask a question. My bank recently had an issue with the description text for a few transactions that resulted in the transactions being reposted with corrected descriptions. Now I am trying to import the corrected transactions but they do not appear in the OFX importer even though they are in the file generated by the bank. My question is: If I delete the previously imported transactions, can I import the corrected transactions? A corollary; is there any way to check, edit or remove the FITID value of a transaction that prevents the duplicate import without doing tricks in the OFX file before importing? -- 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] Moving from GnuCash 4.8 to GnuCash 5.5 - any issues likely to bite me?
Thanks David, you are always a great help. I have created a backup copy of the data file and have no scheduled transactions or business features to worry about. I’ll (ahem) assume the check and repair has run. And will proceed with my upgrade. However, this old brain would like to complain that running reports is NOT intuitive, and the manual does not have a reasonable search function for instructions. The volunteers are deserving of kudos for creating this program, I generally have few problems and I will continue to use it. It is as close to Microsoft Money as any I have found (I amend not a business owner.) And so are you user volunteers who give so much if your time to help other users like me. Po On May 13, 2024, at 2:56 PM, David Carlson wrote: Phyllis, I have noticed that it is important to select the best starting point for your purpose. I would also save the file before starting. If you start from an account rrgister and select check all, it only checks all the transactions in that register. To check the entire file, start from the Account tree register or the General Ledger. Then it is sometimes easy to miss the prigress bar in the lower right corner of the window. For a large file it could take several minutes, but if it has already run, I think it will silently fail to run a second time. I don't know if there is a way to force it to try again. Finally, it does not check scheduled transactions or other non-transactional data such as business features. From a fellow user, I hope that helps. On Mon, May 13, 2024, 9:41 AM Phyllis Bruce <[1]pobruc...@gmail.com> wrote: Just when you thought you were done with this….. I’m running 4.13 on a windows 10 computer. I have a big problem getting any reports to run properly but today it is the check and repair function. No option that I choose gives me a “working” indication. I’m trying to be proactive before upgrading. Couldn’t find anything in the manual. > On May 12, 2024, at 3:30 AM, Chris Green <[2]c...@isbd.net> wrote: > > On Sat, May 11, 2024 at 03:49:04PM -0500, Adrien Monteleone wrote: >>> On 5/11/24 3:08 PM, Chris Green wrote: >>> So, given that I'm going up just one major release I shouls be OK, but >>> running "Check & Repair" before doing anything else is a good idea. > >> Correct. The Check & Repair should run silently automatically upon first >> opening your file with 5.5, but it doesn't hurt to do it intentionally. >> >> The biggest change I recall between 4 & 5 is the new type-ahead search >> method for the Description field. I personally prefer the change, but >> some folks didn't like it by how they use that field and their unique >> list of existing Descriptions. >> >> There is also an issue for some, but not others with respect to >> registers not auto-filling memos from previous session transactions. >> (I'm one so affected) Mileage may vary on that one. >> >> As always - keep a backup. >> >> And since you are not on the last 4.x release on the old machine, I >> wouldn't go back and forth with the same file. Once you migrate, stick >> to 5.5 or drop back to 4.8 and stay there until you decide to finally >> make the upgrade should you notice any problems. >> > Thanks Adrien, that's just the sort of information/confirmation I > wanted. :-) > ___ gnucash-user mailing list [3]gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: [4]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. References 1. mailto:pobruc...@gmail.com 2. mailto:c...@isbd.net 3. mailto:gnucash-user@gnucash.org 4. https://lists.gnucash.org/mailman/listinfo/gnucash-user ___ 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] Moving from GnuCash 4.8 to GnuCash 5.5 - any issues likely to bite me?
Phyllis, I have noticed that it is important to select the best starting point for your purpose. I would also save the file before starting. If you start from an account rrgister and select check all, it only checks all the transactions in that register. To check the entire file, start from the Account tree register or the General Ledger. Then it is sometimes easy to miss the prigress bar in the lower right corner of the window. For a large file it could take several minutes, but if it has already run, I think it will silently fail to run a second time. I don't know if there is a way to force it to try again. Finally, it does not check scheduled transactions or other non-transactional data such as business features. From a fellow user, I hope that helps. On Mon, May 13, 2024, 9:41 AM Phyllis Bruce wrote: > Just when you thought you were done with this….. > > I’m running 4.13 on a windows 10 computer. I have a big problem getting > any reports to run properly but today it is the check and repair function. > No option that I choose gives me a “working” indication. I’m trying to be > proactive before upgrading. Couldn’t find anything in the manual. > > > On May 12, 2024, at 3:30 AM, Chris Green wrote: > > > > On Sat, May 11, 2024 at 03:49:04PM -0500, Adrien Monteleone wrote: > >>> On 5/11/24 3:08 PM, Chris Green wrote: > >>> So, given that I'm going up just one major release I shouls be OK, but > >>> running "Check & Repair" before doing anything else is a good idea. > > > >> Correct. The Check & Repair should run silently automatically upon first > >> opening your file with 5.5, but it doesn't hurt to do it intentionally. > >> > >> The biggest change I recall between 4 & 5 is the new type-ahead search > >> method for the Description field. I personally prefer the change, but > >> some folks didn't like it by how they use that field and their unique > >> list of existing Descriptions. > >> > >> There is also an issue for some, but not others with respect to > >> registers not auto-filling memos from previous session transactions. > >> (I'm one so affected) Mileage may vary on that one. > >> > >> As always - keep a backup. > >> > >> And since you are not on the last 4.x release on the old machine, I > >> wouldn't go back and forth with the same file. Once you migrate, stick > >> to 5.5 or drop back to 4.8 and stay there until you decide to finally > >> make the upgrade should you notice any problems. > >> > > Thanks Adrien, that's just the sort of information/confirmation I > > wanted. :-) > > > ___ > 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. > ___ 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] blank reports
Hi Scott, I am running a flatpak version and so launching through that. I added a 'shortcut' to my start-menu so that I could launch the program. The shortcut uses a script file at ~/bin/gnuchash.sh Here is the script file contents; 11:03 AM mark@nixhp:~/bin $ cat gnucash.sh WEBKIT_DISABLE_COMPOSITING_MODE=1 flatpak run org.gnucash.GnuCash That resolved my blank-report issue without mucking with the nvidia driver. ~mark petryk ~w:http://www.lorimarksolutions.com On 5/13/24 08:44, Scott Ellsworth wrote: Dear all, I had a problem of reports being blank after switching from Ubuntu to Linux Mint (to GC v5.6 thru Flatpak). I was able to see reports after switching the Nvidia driver from version 535 to version 470. I found this fix online, and it worked. But starting a few weeks ago reports were suddenly all blank again. In the meantime I understood that I can print reports to PDF in order to see them, but this is pretty cumbersome, especially because GnuCash's interface for saving them does not know about the folders I've bookmarked in Nemo, and doesn't remember where I saved a PDF last. Today I tried switching to Invidia’s driver version 545 (later than the recommended version, so apparently beta), and it failed to install. So I switched the Nvidia driver from Performance Mode to On-Demand Mode. This is working for now, but I don't prefer it because video movements on my screens are choppy this way. Is there any plan to resolve the blank-reports issue in an upcoming version? Or is there another fix or workaround that could help me? Be Well, Scott Scott Ellsworth || +1 (775) 386-2519 ___ 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. ___ 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] Moving from GnuCash 4.8 to GnuCash 5.5 - any issues likely to bite me?
Just when you thought you were done with this….. I’m running 4.13 on a windows 10 computer. I have a big problem getting any reports to run properly but today it is the check and repair function. No option that I choose gives me a “working” indication. I’m trying to be proactive before upgrading. Couldn’t find anything in the manual. > On May 12, 2024, at 3:30 AM, Chris Green wrote: > > On Sat, May 11, 2024 at 03:49:04PM -0500, Adrien Monteleone wrote: >>> On 5/11/24 3:08 PM, Chris Green wrote: >>> So, given that I'm going up just one major release I shouls be OK, but >>> running "Check & Repair" before doing anything else is a good idea. > >> Correct. The Check & Repair should run silently automatically upon first >> opening your file with 5.5, but it doesn't hurt to do it intentionally. >> >> The biggest change I recall between 4 & 5 is the new type-ahead search >> method for the Description field. I personally prefer the change, but >> some folks didn't like it by how they use that field and their unique >> list of existing Descriptions. >> >> There is also an issue for some, but not others with respect to >> registers not auto-filling memos from previous session transactions. >> (I'm one so affected) Mileage may vary on that one. >> >> As always - keep a backup. >> >> And since you are not on the last 4.x release on the old machine, I >> wouldn't go back and forth with the same file. Once you migrate, stick >> to 5.5 or drop back to 4.8 and stay there until you decide to finally >> make the upgrade should you notice any problems. >> > Thanks Adrien, that's just the sort of information/confirmation I > wanted. :-) > ___ 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] blank reports
Dear all, I had a problem of reports being blank after switching from Ubuntu to Linux Mint (to GC v5.6 thru Flatpak). I was able to see reports after switching the Nvidia driver from version 535 to version 470. I found this fix online, and it worked. But starting a few weeks ago reports were suddenly all blank again. In the meantime I understood that I can print reports to PDF in order to see them, but this is pretty cumbersome, especially because GnuCash's interface for saving them does not know about the folders I've bookmarked in Nemo, and doesn't remember where I saved a PDF last. Today I tried switching to Invidia’s driver version 545 (later than the recommended version, so apparently beta), and it failed to install. So I switched the Nvidia driver from Performance Mode to On-Demand Mode. This is working for now, but I don't prefer it because video movements on my screens are choppy this way. Is there any plan to resolve the blank-reports issue in an upcoming version? Or is there another fix or workaround that could help me? Be Well, Scott Scott Ellsworth || +1 (775) 386-2519 ___ 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.
