Re: [GNC] ANNOUNCE: GnuCash 5.4 Released
I'll second that. I hope you guys go to the blood bank because your blood is definitely worth bottling!! On 25/9/23 07:47, Jediator wrote: Thanks John and the GC team for all your hard work and dedication! On 9/24/23 5:26 PM, John Ralls wrote: The GnuCash development team announces GnuCash 5.4, the fifth release in the stable 5.x series Between 5.3 and 5.4, the following bugfixes were accomplished: Bug 728875 - Back button does not work in QIF import assistant Bug 797507 - GnuCash Splash screen may disappear before the main window appears Bug 798709 - Total(Period) column does not refresh period's value after update of the period in settings.a> Bug 798904 - GnuCash on Windows opens a CMD window at startup. Bug 798925 - Python bindings: "invalid unclassed pointer in cast to 'QofInstance'". Bug 798944 - Program crashes when matching transactions Bug 798950 - Bug Report: Incorrect Currency Conversion and Provider Invoice Payment Recording When balancing lots use the split amount, not the value Recalculate the values using deduced exchange rates after adjusting split amounts. Be conservative when recalculating values after breaking up a split to avoid imbalances caused by rounding. Bug 798958 - gncScrubLotLinks will infinite loop in some conditions Bug 798982 - GetQuotes crashes if Finance::Quote returns an empty date. Bug 798983 - Empty Orphan account appears after entering transactions in 5.3 Bug 798990 - Notes No Longer Autofills Bug 798991 - Incorrect Account Name Order in Transaction Report Bug 798995 - Keystrokes ignored during ledger entry Bug 798998 - Job Report Not Working Bug 799004 - Update of Prices attaches incorrect Date Bug 799010 - gnc-register-account-sel-limited-option errors doesn't work Bug 799020 - widget of gnc-register-list-option disregards user's clicks Bug 799021 - Saved report renders default of gnc-register-list-option Bug 799036 - Import prices from a CSV date problem Bug 799039 - gnc:strify produces unusual results or crashes GnuCash when fed an option from gnc-lookup-option Bug 799048 - Hover on tab not correct Bug 799051 - Shortcut Ctrl + Tab not working in 5.3 Bug 799054 - Stock Assist not functioning Bug 799060 - Consistent Crash in Invoices Bug 799068 - csv export active register not working Bug 799069 - Multicurrency Invoice Payment Bug 799075 - Saving display tab changes in Report Options does not work. Bug 799084 - Unable to create new scheduled transaction The following fixes and improvements were not associated with bug reports: [import-main-matcher.cpp] After clicking/toggling A/U+C/C checkbox, reselect the row because it'll be much faster to use keyboard navigation -- use up/down/left/right to target desired checkbox, hit repeatedly to repeat the same action over several consecutive rows. Implement support for !Type:Prices records in the QIF importer. Modernize construction of GObjects using G_DECLARE_DERIVABLE, G_DECLARE_FINAL, etc. Fix yet more leaks. [DBI backend] Change DBI test URLs to environment variables from cmake configuration definitions. Restore the Stock Transaction Assistant to full operation. Fix the Fancy Date file property so that it saves. Fix formatting error in po files project-id line. [simple-business-create.py] Overwrite an existing file instead of crashing. Update github action package versions. Add parsing mixed number and fraction (e.g. 10 1/2) to the gnc_numeric string constructor. Bump minimum cmake version to 3.14 and drop some conditionals for older versions Major speedup in the SQLBackend by replacing C++ exceptions with std::optional for null values. Refresh the GUI on completion of the import matcher so that the imports are immediately reflected in the register. Improve online quote retrieval error reporting. Test loading and saving XML files with and without compression [import-main-matcher] always defer_bal_computation during import to speed up both importing new transactions, and destroying existing ones. GncGtkListUIItem::set_option_from_ui_item: Iterate over selected items Instead of all possible items. Convert gnc-ofx-import.c, import-parse.c, import-utilities.c, import-format-dialog.c, import-account-matcher.c, import-commodity-matcher.c, import-settings.c, import-pending-matches.c, import-match-picker.c,
Re: [GNC] ANNOUNCE: GnuCash 5.4 Released
Thanks John and the GC team for all your hard work and dedication! On 9/24/23 5:26 PM, John Ralls wrote: The GnuCash development team announces GnuCash 5.4, the fifth release in the stable 5.x series Between 5.3 and 5.4, the following bugfixes were accomplished: Bug 728875 - Back button does not work in QIF import assistant Bug 797507 - GnuCash Splash screen may disappear before the main window appears Bug 798709 - Total(Period) column does not refresh period's value after update of the period in settings.a> Bug 798904 - GnuCash on Windows opens a CMD window at startup. Bug 798925 - Python bindings: "invalid unclassed pointer in cast to 'QofInstance'". Bug 798944 - Program crashes when matching transactions Bug 798950 - Bug Report: Incorrect Currency Conversion and Provider Invoice Payment Recording When balancing lots use the split amount, not the value Recalculate the values using deduced exchange rates after adjusting split amounts. Be conservative when recalculating values after breaking up a split to avoid imbalances caused by rounding. Bug 798958 - gncScrubLotLinks will infinite loop in some conditions Bug 798982 - GetQuotes crashes if Finance::Quote returns an empty date. Bug 798983 - Empty Orphan account appears after entering transactions in 5.3 Bug 798990 - Notes No Longer Autofills Bug 798991 - Incorrect Account Name Order in Transaction Report Bug 798995 - Keystrokes ignored during ledger entry Bug 798998 - Job Report Not Working Bug 799004 - Update of Prices attaches incorrect Date Bug 799010 - gnc-register-account-sel-limited-option errors doesn't work Bug 799020 - widget of gnc-register-list-option disregards user's clicks Bug 799021 - Saved report renders default of gnc-register-list-option Bug 799036 - Import prices from a CSV date problem Bug 799039 - gnc:strify produces unusual results or crashes GnuCash when fed an option from gnc-lookup-option Bug 799048 - Hover on tab not correct Bug 799051 - Shortcut Ctrl + Tab not working in 5.3 Bug 799054 - Stock Assist not functioning Bug 799060 - Consistent Crash in Invoices Bug 799068 - csv export active register not working Bug 799069 - Multicurrency Invoice Payment Bug 799075 - Saving display tab changes in Report Options does not work. Bug 799084 - Unable to create new scheduled transaction The following fixes and improvements were not associated with bug reports: [import-main-matcher.cpp] After clicking/toggling A/U+C/C checkbox, reselect the row because it'll be much faster to use keyboard navigation -- use up/down/left/right to target desired checkbox, hit repeatedly to repeat the same action over several consecutive rows. Implement support for !Type:Prices records in the QIF importer. Modernize construction of GObjects using G_DECLARE_DERIVABLE, G_DECLARE_FINAL, etc. Fix yet more leaks. [DBI backend] Change DBI test URLs to environment variables from cmake configuration definitions. Restore the Stock Transaction Assistant to full operation. Fix the Fancy Date file property so that it saves. Fix formatting error in po files project-id line. [simple-business-create.py] Overwrite an existing file instead of crashing. Update github action package versions. Add parsing mixed number and fraction (e.g. 10 1/2) to the gnc_numeric string constructor. Bump minimum cmake version to 3.14 and drop some conditionals for older versions Major speedup in the SQLBackend by replacing C++ exceptions with std::optional for null values. Refresh the GUI on completion of the import matcher so that the imports are immediately reflected in the register. Improve online quote retrieval error reporting. Test loading and saving XML files with and without compression [import-main-matcher] always defer_bal_computation during import to speed up both importing new transactions, and destroying existing ones. GncGtkListUIItem::set_option_from_ui_item: Iterate over selected items Instead of all possible items. Convert gnc-ofx-import.c, import-parse.c, import-utilities.c, import-format-dialog.c, import-account-matcher.c, import-commodity-matcher.c, import-settings.c, import-pending-matches.c, import-match-picker.c, import-main-matcher.c, and gnc-pricedb.c to .cpp By default, filter out online_wiggle in test-gnc-quotes. Running ./bin/test-gnc-quotes from the command line will still include online_wiggle Replace yahoo_json with alphavantage in test-gnc-quotes. yahoo_json is too unstable. Include timezone in price-quote date diagnostic messages. New and Updated Translations: Arabic, Chinese (Traditional), Croatian, Dutch, English (Australia), English (New Zealand), English (United Kingdom), French, German, Greek, Hebrew, Hungarian, Indonesian, Italian, Polish,
Re: [GNC] Have code run when a new invoice is posted.
I am facing the same problem. My solution is to leverage the Import Invoices/Bills function in GC (using version 5.3 now) and transfer the invoices and bills in CSV to GC. It may require some manual steps, but it should be easy to create a python script to generate your invoices and bills in CSV automatically. GC's Python binding is nowhere documented except looking at the source code on github, as far as I knew. The bindings are not too complicated to comprehend, but you still need invest sometime to dig through and try them out. Not really an option for average users. Hope this helps. Cheers! -- JC On 9/24/23 10:55 AM, fly...@gmail.com wrote: Hi, I started using gnucash 2 months ago and I'm currently using it in parallel with another accounting software. In general gnucash does what I want (VAT accounting, accrual accounting of other taxes). However, currently when I post an invoice I also have to post a bill for some percentage of its net value as my income tax (I'm in a scheme where income tax is just a percentage of income, no expenses are taken into account etc). I'm looking for some method to automate this. Ideally I'd love to be able to run some code (guile/python) when a new invoice is posted. That code could then create and post a bill to be paid before the 20th of next month for the taxman. Another option is, to create a bill every month on the 1st, to be paid next month on the 20th and the amount to be a percentage of net value of sales invoiced this month. I don't know if any of this is possible in gnucash. I know about the offline python and scheme APIs (offline as it can manipulate the accounts when gnucash is not). I could write a python script that runs with some regularity and creates/updates the income bills based on the invoices present, but this doesn't seem such a "nice" solution as to have some code run at the moment an invoice is posted, or have some formula in the bill value that takes into account this month's sales. If anyone has an idea how to do the above, please let me know, Luk ___ 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] ANNOUNCE: GnuCash 5.4 Released
The GnuCash development team announces GnuCash 5.4, the fifth release in the stable 5.x series Between 5.3 and 5.4, the following bugfixes were accomplished: Bug 728875 - Back button does not work in QIF import assistant Bug 797507 - GnuCash Splash screen may disappear before the main window appears Bug 798709 - Total(Period) column does not refresh period's value after update of the period in settings.a> Bug 798904 - GnuCash on Windows opens a CMD window at startup. Bug 798925 - Python bindings: "invalid unclassed pointer in cast to 'QofInstance'". Bug 798944 - Program crashes when matching transactions Bug 798950 - Bug Report: Incorrect Currency Conversion and Provider Invoice Payment Recording When balancing lots use the split amount, not the value Recalculate the values using deduced exchange rates after adjusting split amounts. Be conservative when recalculating values after breaking up a split to avoid imbalances caused by rounding. Bug 798958 - gncScrubLotLinks will infinite loop in some conditions Bug 798982 - GetQuotes crashes if Finance::Quote returns an empty date. Bug 798983 - Empty Orphan account appears after entering transactions in 5.3 Bug 798990 - Notes No Longer Autofills Bug 798991 - Incorrect Account Name Order in Transaction Report Bug 798995 - Keystrokes ignored during ledger entry Bug 798998 - Job Report Not Working Bug 799004 - Update of Prices attaches incorrect Date Bug 799010 - gnc-register-account-sel-limited-option errors doesn't work Bug 799020 - widget of gnc-register-list-option disregards user's clicks Bug 799021 - Saved report renders default of gnc-register-list-option Bug 799036 - Import prices from a CSV date problem Bug 799039 - gnc:strify produces unusual results or crashes GnuCash when fed an option from gnc-lookup-option Bug 799048 - Hover on tab not correct Bug 799051 - Shortcut Ctrl + Tab not working in 5.3 Bug 799054 - Stock Assist not functioning Bug 799060 - Consistent Crash in Invoices Bug 799068 - csv export active register not working Bug 799069 - Multicurrency Invoice Payment Bug 799075 - Saving display tab changes in Report Options does not work. Bug 799084 - Unable to create new scheduled transaction The following fixes and improvements were not associated with bug reports: [import-main-matcher.cpp] After clicking/toggling A/U+C/C checkbox, reselect the row because it'll be much faster to use keyboard navigation -- use up/down/left/right to target desired checkbox, hit repeatedly to repeat the same action over several consecutive rows. Implement support for !Type:Prices records in the QIF importer. Modernize construction of GObjects using G_DECLARE_DERIVABLE, G_DECLARE_FINAL, etc. Fix yet more leaks. [DBI backend] Change DBI test URLs to environment variables from cmake configuration definitions. Restore the Stock Transaction Assistant to full operation. Fix the Fancy Date file property so that it saves. Fix formatting error in po files project-id line. [simple-business-create.py] Overwrite an existing file instead of crashing. Update github action package versions. Add parsing mixed number and fraction (e.g. 10 1/2) to the gnc_numeric string constructor. Bump minimum cmake version to 3.14 and drop some conditionals for older versions Major speedup in the SQLBackend by replacing C++ exceptions with std::optional for null values. Refresh the GUI on completion of the import matcher so that the imports are immediately reflected in the register. Improve online quote retrieval error reporting. Test loading and saving XML files with and without compression [import-main-matcher] always defer_bal_computation during import to speed up both importing new transactions, and destroying existing ones. GncGtkListUIItem::set_option_from_ui_item: Iterate over selected items Instead of all possible items. Convert gnc-ofx-import.c, import-parse.c, import-utilities.c, import-format-dialog.c, import-account-matcher.c, import-commodity-matcher.c, import-settings.c, import-pending-matches.c, import-match-picker.c, import-main-matcher.c, and gnc-pricedb.c to .cpp By default, filter out online_wiggle in test-gnc-quotes. Running ./bin/test-gnc-quotes from the command line will still include online_wiggle Replace yahoo_json with alphavantage in test-gnc-quotes. yahoo_json is too unstable. Include timezone in price-quote date diagnostic messages. New and Updated Translations: Arabic, Chinese (Traditional), Croatian, Dutch, English (Australia), English (New Zealand), English (United Kingdom), French, German, Greek, Hebrew, Hungarian, Indonesian, Italian, Polish, Portuguese, Portuguese (Brazil), Romanian, Slovak, Spanish, Swedish, Ukrainian Help translate GnuCash on Weblate: https://hosted.weblate.org/engage/gnucash/ Known
[GNC] Have code run when a new invoice is posted.
I don't use that part of GnuCash but I couldn't imagine it being done directly. Seems the options are either to rewrite the C++ code or process it offline with a different workflow. For example, https://bugs.gnucash.org/show_bug.cgi?id=798987 creates splits from bank statements and https://github.com/flywire/ETF-Annual-Statement from tax statements, both for csv import. Given Python bindings are not available in a binary they are really a fake feature and https://piecash.readthedocs.io is not genuine GnuCash so you'd have to get support from that project. ___ 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] No longer able to import OFX
I opened one of the OFX files and every transactions have a FITID of "unknown" That's certainly what's causing the issue. Seems like the bank is not even using the FITID appropriately though. Thank you for the help. On Sun, Sep 24, 2023 at 12:50 PM Jean Laroche wrote: > > I think many people have run into that problem, and some wrote some > python scripts that modify the bank FITID for example by adding part of > the date, so it becomes unique. It's a kludge of course, but it works. > > You could look for such scripts on github for example, or write your own > from the available python based ofx libraries > > Jean > > On 9/24/23 9:18 AM, john wrote: > > > >> On Sep 24, 2023, at 07:15, Mike St. Germaine wrote: > >> > >> Hello, > >> At some point earlier in the year I started receiving the attached > >> message when attempting to import an OFX from Citizens bank (the > >> message is "found 1 previously imported transactions, no new > >> transactions" -- the number always matches the number of transactions > >> i'm trying to import). These are transactions that have definitely not > >> been imported before. I've been manually entering all transactions for > >> a while now and that's getting pretty old. > >> This change seemed to coincide with a major change the bank made to > >> their website though that could very well be a coincidence. > >> If I create a new Gnucash file and import the OFX, it works just fine. > >> It just won't allow me to import to the file I've been using for the > >> past year or so. Also worth mentioning I'm still able to import OFX > >> files from other banks with no issue. > >> I deleted the account assignment through the import map editor but > >> that didn't work either. It did ask for a new account assignment when > >> importing but then I just received the same message described above. > > This problem is usually because your bank is reusing FITID values. Those > > are supposed to be unique to enable software reading the OFX to identify > > duplicate transactions. > > > > Regards, > > John Ralls > > > > > > ___ > > 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. ___ 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] Gnu Cash stopped working 2 days ago.
David, Having a 25-1-22.gnucash.LCK.gcm suggests that you might have tried to open 25-1-22.gnucash.LCK instead of 25-1-22.gnucash at some point. That obviously won't work as there's nothing in a lock file. You might also have a 25-1-22.gnucash.LCK.LCK in the folder with your book file. You should delete that as well. Regards, John Ralls > On Sep 24, 2023, at 11:53 AM, (Alan) David Smith > wrote: > > Hello John, > > I have spotted 2 files named: David Smith Money Final 25-1-22.gnucash.LCK.gcm > David Smith Money Final 25-1-22.gnucash.gcm > > I have transferred both to bin. One is a LCK file. > > Gnucash is now opening as normal. Does it matter that one is a LCK file? > > Thank you for this. > > Regards, > > David > > On 24/09/2023, 19:16, "John Ralls" wrote: > >David, > >> On Sep 17, 2023, at 6:32 AM, (Alan) David Smith >> wrote: >> >> Exception Type:EXC_BAD_ACCESS (SIGSEGV) >> Exception Codes: KERN_INVALID_ADDRESS at 0x0039 >> Exception Codes: 0x0001, 0x0039 >> >[snip] >> Thread 0 Crashed:: Dispatch queue: com.apple.main-thread >> 0 libglib-2.0.0.dylib 0x10dbebb44 >> g_hash_table_lookup + 36 >> 1 libgnc-engine.dylib 0x10d6a2335 >> gncTaxTableGetTables + 21 >> 2 libgnc-gnome.dylib 0x109dd90b2 >> gnc_simple_combo_generate_liststore + 50 >> 3 libgnc-gnome-utils.dylib 0x10a26099e >> gnc_gui_refresh_internal + 222 >> > >That seems to point to an invalid hash table in the book object, though I > don't see in the code where that would happen. Regardless, try this: >* Open a Finder window and select Go>Go to folder from the menu or press > shift-command-g. >* In the dialog type ~/Library/Application Support/Gnucash/books. >* Find the file corresponding to your data file name with a .gcm > extension, e.g. "my_file.gcm" and move it to Trash. >* Start GnuCash > >I think you have an invoice tab open and something about its Tax Table > listbox is causing GnuCash to crash. Removing the .gcm file will start > GnuCash with only the Accounts tab and if I'm right will avoid the crash. > >Regards, >John Ralls > > > > ___ 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] Gnu Cash stopped working 2 days ago.
Hello John, I have spotted 2 files named: David Smith Money Final 25-1-22.gnucash.LCK.gcm David Smith Money Final 25-1-22.gnucash.gcm I have transferred both to bin. One is a LCK file. Gnucash is now opening as normal. Does it matter that one is a LCK file? Thank you for this. Regards, David On 24/09/2023, 19:16, "John Ralls" wrote: David, > On Sep 17, 2023, at 6:32 AM, (Alan) David Smith wrote: > > Exception Type:EXC_BAD_ACCESS (SIGSEGV) > Exception Codes: KERN_INVALID_ADDRESS at 0x0039 > Exception Codes: 0x0001, 0x0039 > [snip] > Thread 0 Crashed:: Dispatch queue: com.apple.main-thread > 0 libglib-2.0.0.dylib 0x10dbebb44 g_hash_table_lookup + 36 > 1 libgnc-engine.dylib 0x10d6a2335 gncTaxTableGetTables + 21 > 2 libgnc-gnome.dylib 0x109dd90b2 gnc_simple_combo_generate_liststore + 50 > 3 libgnc-gnome-utils.dylib 0x10a26099e gnc_gui_refresh_internal + 222 > That seems to point to an invalid hash table in the book object, though I don't see in the code where that would happen. Regardless, try this: * Open a Finder window and select Go>Go to folder from the menu or press shift-command-g. * In the dialog type ~/Library/Application Support/Gnucash/books. * Find the file corresponding to your data file name with a .gcm extension, e.g. "my_file.gcm" and move it to Trash. * Start GnuCash I think you have an invoice tab open and something about its Tax Table listbox is causing GnuCash to crash. Removing the .gcm file will start GnuCash with only the Accounts tab and if I'm right will avoid the crash. Regards, John Ralls ___ 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] Gnu Cash stopped working 2 days ago.
David, > On Sep 17, 2023, at 6:32 AM, (Alan) David Smith > wrote: > > Exception Type:EXC_BAD_ACCESS (SIGSEGV) > Exception Codes: KERN_INVALID_ADDRESS at 0x0039 > Exception Codes: 0x0001, 0x0039 > [snip] > Thread 0 Crashed:: Dispatch queue: com.apple.main-thread > 0 libglib-2.0.0.dylib 0x10dbebb44 > g_hash_table_lookup + 36 > 1 libgnc-engine.dylib 0x10d6a2335 > gncTaxTableGetTables + 21 > 2 libgnc-gnome.dylib 0x109dd90b2 > gnc_simple_combo_generate_liststore + 50 > 3 libgnc-gnome-utils.dylib 0x10a26099e > gnc_gui_refresh_internal + 222 > That seems to point to an invalid hash table in the book object, though I don't see in the code where that would happen. Regardless, try this: * Open a Finder window and select Go>Go to folder from the menu or press shift-command-g. * In the dialog type ~/Library/Application Support/Gnucash/books. * Find the file corresponding to your data file name with a .gcm extension, e.g. "my_file.gcm" and move it to Trash. * Start GnuCash I think you have an invoice tab open and something about its Tax Table listbox is causing GnuCash to crash. Removing the .gcm file will start GnuCash with only the Accounts tab and if I'm right will avoid the crash. Regards, John Ralls ___ 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] Gnu Cash stopped working 2 days ago.
log.conf is not necessary to generate trace files. If it was GnuCash would automatically create a default. David may still be misled by the typos in my earlier message. Ken Farley corrected them. The tracefile can be found via Terminal with $TMPDIR/gnucash.trace. One can redirect it to somewhere else with the --logto option, e.g. /Applications/Gnucash.app/Contents/MacOS/Gnucash --logto $HOME/gnucash_errors will write it to a file named "gnucash_errors" in the user's home directory. The original error message David posted, > > (process:46072): gnc.gui-WARNING **: 20:54:04.010: [mac_set_languages()] > Language list: en:en_GB:C > Backtrace: > 3 (apply-smob/1 #) > In ice-9/boot-9.scm: > 2312:4 2 (save-module-excursion #) > In ice-9/eval-string.scm: > 36:6 1 (read-and-eval # #:lang _) > In unknown file: > 0 (read #) > > ERROR: In procedure read: > In procedure string->number: Value out of range: 9739 > is a scheme backtrace. It has nothing at all to do with the backend nor could it be emitted by a SQL server or SQLite3. Regards, John Ralls > On Sep 24, 2023, at 9:59 AM, Jediator wrote: > > David, You need to create the log.conf file manually first on your Mac to > enable tracing. Please see this thread for details > (https://lists.gnucash.org/pipermail/gnucash-user/2023-September/108759.html). > > Are you using the default sqlite as the GC database? The error message of > "procedure value out of range" you posted indicates this might be a database > problem. If you are on a Mac, your can just run /sqlite3 your_db.gnucash /to > see if this would spit out any errors. Once you are in the sqlite shell, run > the /analyze/ command to check the table/index consistency. > > Good luck! -- JC > > > On 9/24/23 8:25 AM, (Alan) David Smith wrote: >> I have tried this. Thank you very much for your help but there is still no >> trace file visible anywhere. >> >> May be version 5.4 will work on my Apple when available, otherwise it looks >> as though GNUCash has permanently stopped working on my apple computer. >> >> Regards, >> >> David >> >> On 17/09/2023, 17:13, "(Alan) David Smith" >> wrote: >> >> There is still no trace file. But you now have crash report. >> >> On 17/09/2023, 15:13, "gnucash-user on behalf of Ken >> Farley"> behalf of farle...@gmail.com> wrote: >> >> I think you might be missing some of the steps you were asked to >> perform, so here they are: >> >> (1) Run Gnucash while telling it to save a trace file. This file >> lists >> all the actions of the program. This is done with the command (on >> MacOS): >> >> /Applications/Gnucash.app/Contents/MacOS/Gnucash --debug >> >> This will run Gnucash, presumably until it crashes, while writing a >> trace file in the directory specified by the environment variable >> TMPDIR >> on your system. >> >> (2) To make the trace file more accessible, you copy it to your user >> directory. To be sure it's in this location, perform the following >> two >> commands: >> >> cd >> >> cp $TMPDIR/gnucash.trace . >> >> (3) Now that you have this tracefile, you want to provide it to the >> folks on the mailing list who can interpret such things. Since it's >> likely a very long file, it is not a good idea to copy and paste it's >> contents into a message. Instead, when you reply to the mailing list, >> you attach the file to the message, usually by dragging and dropping >> the >> file in Outlook, or using the "Attach File" button, etc. >> >> >> Hopefully, if you do these things, someone will be able to figure out >> where your installation is going wrong. >> ___ >> 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. > ___ > 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
Re: [GNC] Gnu Cash stopped working 2 days ago.
David, You need to create the log.conf file manually first on your Mac to enable tracing. Please see this thread for details (https://lists.gnucash.org/pipermail/gnucash-user/2023-September/108759.html). Are you using the default sqlite as the GC database? The error message of "procedure value out of range" you posted indicates this might be a database problem. If you are on a Mac, your can just run /sqlite3 your_db.gnucash /to see if this would spit out any errors. Once you are in the sqlite shell, run the /analyze/ command to check the table/index consistency. Good luck! -- JC On 9/24/23 8:25 AM, (Alan) David Smith wrote: I have tried this. Thank you very much for your help but there is still no trace file visible anywhere. May be version 5.4 will work on my Apple when available, otherwise it looks as though GNUCash has permanently stopped working on my apple computer. Regards, David On 17/09/2023, 17:13, "(Alan) David Smith" wrote: There is still no trace file. But you now have crash report. On 17/09/2023, 15:13, "gnucash-user on behalf of Ken Farley"behalf of farle...@gmail.com> wrote: I think you might be missing some of the steps you were asked to perform, so here they are: (1) Run Gnucash while telling it to save a trace file. This file lists all the actions of the program. This is done with the command (on MacOS): /Applications/Gnucash.app/Contents/MacOS/Gnucash --debug This will run Gnucash, presumably until it crashes, while writing a trace file in the directory specified by the environment variable TMPDIR on your system. (2) To make the trace file more accessible, you copy it to your user directory. To be sure it's in this location, perform the following two commands: cd cp $TMPDIR/gnucash.trace . (3) Now that you have this tracefile, you want to provide it to the folks on the mailing list who can interpret such things. Since it's likely a very long file, it is not a good idea to copy and paste it's contents into a message. Instead, when you reply to the mailing list, you attach the file to the message, usually by dragging and dropping the file in Outlook, or using the "Attach File" button, etc. Hopefully, if you do these things, someone will be able to figure out where your installation is going wrong. ___ 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. ___ 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] No longer able to import OFX
I think many people have run into that problem, and some wrote some python scripts that modify the bank FITID for example by adding part of the date, so it becomes unique. It's a kludge of course, but it works. You could look for such scripts on github for example, or write your own from the available python based ofx libraries Jean On 9/24/23 9:18 AM, john wrote: On Sep 24, 2023, at 07:15, Mike St. Germaine wrote: Hello, At some point earlier in the year I started receiving the attached message when attempting to import an OFX from Citizens bank (the message is "found 1 previously imported transactions, no new transactions" -- the number always matches the number of transactions i'm trying to import). These are transactions that have definitely not been imported before. I've been manually entering all transactions for a while now and that's getting pretty old. This change seemed to coincide with a major change the bank made to their website though that could very well be a coincidence. If I create a new Gnucash file and import the OFX, it works just fine. It just won't allow me to import to the file I've been using for the past year or so. Also worth mentioning I'm still able to import OFX files from other banks with no issue. I deleted the account assignment through the import map editor but that didn't work either. It did ask for a new account assignment when importing but then I just received the same message described above. This problem is usually because your bank is reusing FITID values. Those are supposed to be unique to enable software reading the OFX to identify duplicate transactions. Regards, John Ralls ___ 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] No longer able to import OFX
> On Sep 24, 2023, at 07:15, Mike St. Germaine wrote: > > Hello, > At some point earlier in the year I started receiving the attached > message when attempting to import an OFX from Citizens bank (the > message is "found 1 previously imported transactions, no new > transactions" -- the number always matches the number of transactions > i'm trying to import). These are transactions that have definitely not > been imported before. I've been manually entering all transactions for > a while now and that's getting pretty old. > This change seemed to coincide with a major change the bank made to > their website though that could very well be a coincidence. > If I create a new Gnucash file and import the OFX, it works just fine. > It just won't allow me to import to the file I've been using for the > past year or so. Also worth mentioning I'm still able to import OFX > files from other banks with no issue. > I deleted the account assignment through the import map editor but > that didn't work either. It did ask for a new account assignment when > importing but then I just received the same message described above. This problem is usually because your bank is reusing FITID values. Those are supposed to be unique to enable software reading the OFX to identify duplicate transactions. Regards, John Ralls ___ 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] No longer able to import OFX
On 24 September 2023 at 10:15, Mike St. Germaine said: > Hello, > At some point earlier in the year I started receiving the attached > message when attempting to import an OFX from Citizens bank (the > message is "found 1 previously imported transactions, no new > transactions" -- the number always matches the number of transactions i'm > trying to import). These are transactions that have definitely not been > imported before. I've been manually entering all transactions for a while > now and that's getting pretty old. This change seemed to coincide with a > major change the bank made to their website though that could very well be > a coincidence. If I create a new Gnucash file and import the OFX, it works > just fine. It just won't allow me to import to the file I've been using > for the past year or so. Also worth mentioning I'm still able to import > OFX files from other banks with no issue. I deleted the account assignment > through the import map editor but that didn't work either. It did ask for > a new account assignment when importing but then I just received the same > message described above. Thank you. Mike S. That suggests that the bank is reusing the "unique" transaction numbers. Not a lot you can do about that except go through the file changing them. ___ 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] Have code run when a new invoice is posted.
Hi, I started using gnucash 2 months ago and I'm currently using it in parallel with another accounting software. In general gnucash does what I want (VAT accounting, accrual accounting of other taxes). However, currently when I post an invoice I also have to post a bill for some percentage of its net value as my income tax (I'm in a scheme where income tax is just a percentage of income, no expenses are taken into account etc). I'm looking for some method to automate this. Ideally I'd love to be able to run some code (guile/python) when a new invoice is posted. That code could then create and post a bill to be paid before the 20th of next month for the taxman. Another option is, to create a bill every month on the 1st, to be paid next month on the 20th and the amount to be a percentage of net value of sales invoiced this month. I don't know if any of this is possible in gnucash. I know about the offline python and scheme APIs (offline as it can manipulate the accounts when gnucash is not). I could write a python script that runs with some regularity and creates/updates the income bills based on the invoices present, but this doesn't seem such a "nice" solution as to have some code run at the moment an invoice is posted, or have some formula in the bill value that takes into account this month's sales. If anyone has an idea how to do the above, please let me know, Luk ___ 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] No longer able to import OFX
Hello, At some point earlier in the year I started receiving the attached message when attempting to import an OFX from Citizens bank (the message is "found 1 previously imported transactions, no new transactions" -- the number always matches the number of transactions i'm trying to import). These are transactions that have definitely not been imported before. I've been manually entering all transactions for a while now and that's getting pretty old. This change seemed to coincide with a major change the bank made to their website though that could very well be a coincidence. If I create a new Gnucash file and import the OFX, it works just fine. It just won't allow me to import to the file I've been using for the past year or so. Also worth mentioning I'm still able to import OFX files from other banks with no issue. I deleted the account assignment through the import map editor but that didn't work either. It did ask for a new account assignment when importing but then I just received the same message described above. Thank you. Mike S. ___ 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] gnucash tab shortcut remap
There was some recent discussion on the list about accelerator keys. Users can't change them in 4.14, but they can in 5.x. 5.4 is due out later today, so upgrading is the solution. Stan Brown Tehachapi, CA, USA https://BrownMath.com On 2023-09-22 11:01, User Foss wrote: > New user > > Can anyone point me towards the relevant resource to get firefox tab like > shortcuts, alt+(tab number) for jumping directly to a tab and Contr+Tab for > toggling through tabs , working in gnucash 4.14 running on fedora 36 with > gtk3 and i3wm? So far I have tried looking through the accelerator-map file > but could not find the right command. I also tried the gtk3 remapping example > here: https://wiki.gnucash.org/wiki/GTK3#Via_settings.ini but did not > succeed. Any help is welcomed. ___ 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] Gnu Cash stopped working 2 days ago.
I have tried this. Thank you very much for your help but there is still no trace file visible anywhere. May be version 5.4 will work on my Apple when available, otherwise it looks as though GNUCash has permanently stopped working on my apple computer. Regards, David On 17/09/2023, 17:13, "(Alan) David Smith" wrote: There is still no trace file. But you now have crash report. On 17/09/2023, 15:13, "gnucash-user on behalf of Ken Farley" wrote: I think you might be missing some of the steps you were asked to perform, so here they are: (1) Run Gnucash while telling it to save a trace file. This file lists all the actions of the program. This is done with the command (on MacOS): /Applications/Gnucash.app/Contents/MacOS/Gnucash --debug This will run Gnucash, presumably until it crashes, while writing a trace file in the directory specified by the environment variable TMPDIR on your system. (2) To make the trace file more accessible, you copy it to your user directory. To be sure it's in this location, perform the following two commands: cd cp $TMPDIR/gnucash.trace . (3) Now that you have this tracefile, you want to provide it to the folks on the mailing list who can interpret such things. Since it's likely a very long file, it is not a good idea to copy and paste it's contents into a message. Instead, when you reply to the mailing list, you attach the file to the message, usually by dragging and dropping the file in Outlook, or using the "Attach File" button, etc. Hopefully, if you do these things, someone will be able to figure out where your installation is going wrong. ___ 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] gnucash tab shortcut remap
New user Can anyone point me towards the relevant resource to get firefox tab like shortcuts, alt+(tab number) for jumping directly to a tab and Contr+Tab for toggling through tabs , working in gnucash 4.14 running on fedora 36 with gtk3 and i3wm? So far I have tried looking through the accelerator-map file but could not find the right command. I also tried the gtk3 remapping example here: https://wiki.gnucash.org/wiki/GTK3#Via_settings.ini but did not succeed. Any help is welcomed. Thanks. ___ 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.
