[GNC] QIF imports fails in 5.6
Hi, QIF imports is failing in 5.6. I had to revert to 5.5 to be able to be able ro import as usual. The error message is "Missing QIF investment action for transaction dated 02.04.2024." Let me know how can I help, I'm unsure where to find more meaningful logs. /nodje ___ 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] getting Online_Quotes to work on MacOS
Cheers, this got me `gnc-fq-check` working. Now I found the doc dealing with this type of problem :) Sorry about it, one shouldn't ask for support for Friday night install attempts... Regards, -nodje On 11/02/2022 23:14, John Ralls wrote: On Feb 11, 2022, at 1:22 PM, coolnodje wrote: Hi, I was just following the Online_Quotes doc, installing Finance::Quote and trying to get some quotes. I've been doing: ➜ bin sudo ./gnc-fq-update [...] All tests successful. Files=56, Tests=82, 4 wallclock secs ( 0.06 usr 0.06 sys + 3.38 cusr 0.51 csys = 4.01 CPU) Result: PASS BPSCHUCK/Finance-Quote-1.51.tar.gz Tests succeeded but one dependency not OK (Test::Perl::Critic) BPSCHUCK/Finance-Quote-1.51.tar.gz [dependencies] -- NA ➜ bin ./gnc-fq-check You need to install the following Perl modules: Finance::Quote Use your system's package manager to install them, or run 'gnc-fq-update' as root. missing-lib ➜ bin I'm not too sure why Finance::Quote isn't found after an install. Relaunching my terminal trying in a fresh shell doesn't make any difference. I'm using zsh on latest MacOS, have setup ALPHAVANTAGE_API_KEYin Gnucash GUI preference and in .zshrc. Maybe because Finance::Quote's install failed, indicated by "Tests succeeded but one dependency not OK (Test::Perl::Critic)" The workaround is to run sudo cpan -f -i B::Keywords then run gnc-fq-update again. 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 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.
[GNC] getting Online_Quotes to work on MacOS
Hi, I was just following the Online_Quotes doc, installing Finance::Quote and trying to get some quotes. I've been doing: ➜ bin sudo ./gnc-fq-update [...] All tests successful. Files=56, Tests=82, 4 wallclock secs ( 0.06 usr 0.06 sys + 3.38 cusr 0.51 csys = 4.01 CPU) Result: PASS BPSCHUCK/Finance-Quote-1.51.tar.gz Tests succeeded but one dependency not OK (Test::Perl::Critic) BPSCHUCK/Finance-Quote-1.51.tar.gz [dependencies] -- NA ➜ bin ./gnc-fq-check You need to install the following Perl modules: Finance::Quote Use your system's package manager to install them, or run 'gnc-fq-update' as root. missing-lib ➜ bin I'm not too sure why Finance::Quote isn't found after an install. Relaunching my terminal trying in a fresh shell doesn't make any difference. I'm using zsh on latest MacOS, have setup ALPHAVANTAGE_API_KEYin Gnucash GUI preference and in .zshrc. -nodje ___ gnucash-user mailing list gnucash-user@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.
[GNC] Ways to account for monthly VAT declaration
Hi, I've been looking into the available reports to find a way to get an account summary of the VAT collected and spent for a given month. I haven't found anything satisfying unfortunately. My VAT accounts are setup as indicated in Gnucash documentation (All accounts are under Liability) What I want is an automated way to get the amount I need to declare (the tally of the different VAT spent minus the VAT collected with my invoices). Thanks for sharing your views on this. -nodje ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Invoice font size has changed
Thank you for your answer. I discover the menu entry Edit>Stylesheets, very neat. But anyhow, the Default style sheet still uses the default fonts, nothing has changed that could explain the difference in printing size (I only print to PDF) I tried to play with the Preferences>Printing>Default Font, but couldn't see any impact on the resulting PDF file. Best regards, -nodje On 27/07/2021 20:51, John Ralls wrote: > >> On Jul 27, 2021, at 10:01 AM, coolnodje wrote: >> >> Hi, >> >> the invoice I print from Gnucash have become printed smaller for some >> reason. >> I can't explain it, nor can I find any place to control this. (I >> switched from Default to CSS experimental which makes it slightly larger >> but still quite smaller than it used to be) >> >> I upgraded to 4.6 as soon as it was out (I'm using brew on MacOS ) and >> believe my last invoice was made with this same latest version. >> I rebooted my computer, which was on for a lot longer than when the new >> release was installed. (it's not supposed to explain anything, but as I >> keep Gnucash open all the time these days, switching book accounts, it >> feels like it's the most meaningful change I've made to my Gnucash ... sic) > Edit>Stylesheets. > > The CSS-based stylesheet uses CSS directly, so adjust the font-size > attributes in the elements you want to change. If you don't know CSS works > you might prefer to switch back to the stylesheet you were using before and > edit it instead. Go to the fonts tab and use the font chooser to select the > typeface and size you want for each element. > > 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 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.
[GNC] Invoice font size has changed
Hi, the invoice I print from Gnucash have become printed smaller for some reason. I can't explain it, nor can I find any place to control this. (I switched from Default to CSS experimental which makes it slightly larger but still quite smaller than it used to be) I upgraded to 4.6 as soon as it was out (I'm using brew on MacOS ) and believe my last invoice was made with this same latest version. I rebooted my computer, which was on for a lot longer than when the new release was installed. (it's not supposed to explain anything, but as I keep Gnucash open all the time these days, switching book accounts, it feels like it's the most meaningful change I've made to my Gnucash ... sic) thanks for any help -nodje ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Read-only transaction
Just found out how to find gnucash.trace from doc at [1]https://wiki.gnucash.org/wiki/Tracefile However, there's no logging happening when trying to delete or edit this RO Transaction. I'll give a try at increasing log level to DEBUG. On 20/05/2021 10:21, Christopher Lam wrote: Try right click and select "jump to associated invoice". If this doesn't work then attach the relevant tracefile. On Thu, 20 May 2021, 4:03 pm coolnodje, <[2]coolno...@gmail.com> wrote: Hi I have this odd transaction that I can't fix or delete. I'm met with the following error message when trying to delete it: This transaction is marked read-only with the comment: 'Generated from an invoice. Try unposting the invoice'. I've reviewed all invoices but I couldn't find a one with a reference to the transaction in question. Is there any way to bypass, or solve this read-only status? Best ___ 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 If you are using Nabble or Gmane, please see [5]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. References 1. https://wiki.gnucash.org/wiki/Tracefile 2. mailto:coolno...@gmail.com 3. mailto:gnucash-user@gnucash.org 4. https://lists.gnucash.org/mailman/listinfo/gnucash-user 5. https://wiki.gnucash.org/wiki/Mailing_Lists ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Read-only transaction
Unfortunately the "Jump to Invoice" option is grayed out. I'm not sure what could be the relevant tracefile here: could I possibly get log files for the delete transaction action? I haven't been able to find any relevant logs on Macos in Library/Application Support/Gnucash. On 20/05/2021 10:21, Christopher Lam wrote: Try right click and select "jump to associated invoice". If this doesn't work then attach the relevant tracefile. On Thu, 20 May 2021, 4:03 pm coolnodje, <[1]coolno...@gmail.com> wrote: Hi I have this odd transaction that I can't fix or delete. I'm met with the following error message when trying to delete it: This transaction is marked read-only with the comment: 'Generated from an invoice. Try unposting the invoice'. I've reviewed all invoices but I couldn't find a one with a reference to the transaction in question. Is there any way to bypass, or solve this read-only status? Best ___ gnucash-user mailing list [2]gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: [3]https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see [4]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. References 1. mailto:coolno...@gmail.com 2. mailto:gnucash-user@gnucash.org 3. https://lists.gnucash.org/mailman/listinfo/gnucash-user 4. https://wiki.gnucash.org/wiki/Mailing_Lists ___ gnucash-user mailing list gnucash-user@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.
[GNC] Read-only transaction
Hi I have this odd transaction that I can't fix or delete. I'm met with the following error message when trying to delete it: This transaction is marked read-only with the comment: 'Generated from an invoice. Try unposting the invoice'. I've reviewed all invoices but I couldn't find a one with a reference to the transaction in question. Is there any way to bypass, or solve this read-only status? Best ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] SQLite File crashes Gnucash on opening after upgrade to 4.1 on Macos
Hi, I was finally able to get back to a backup of this SQLlite file. Unfortunately trying to open a version older than the last update of Gnucash I got (19 August 2020, v4.1-4), which was working fine, Gnucash still crashes. I'll then open a bug for this. Regards, -nodje On 17/09/2020 17:58, John Ralls wrote: > >> On Sep 17, 2020, at 4:43 AM, coolnodje wrote: >> >> Just wanted to make sure this was already caught as a bug. >> >> I've had a bug like this in the past, though with another SQLite File. >> >> Everything was fine until the upgrade, hence i assume this is regression. > More likely a damaged file since there weren't any SQL backend changes > between 4.0 and 4.1. Please open a bug report and attach the crash report > from Console. > > 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 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.
[GNC] SQLite File crashes Gnucash on opening after upgrade to 4.1 on Macos
Just wanted to make sure this was already caught as a bug. I've had a bug like this in the past, though with another SQLite File. Everything was fine until the upgrade, hence i assume this is regression. Best ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] "No suitable backend" error for database backed gnucash file
Sorry for being unresponsive, this email ended up in my spam box for some reason. Thanks for pointing this bug to me. Sounds exactly like the problem I have. Adding the line to my environment file didn't help unfortunately. I've subscribed to the bug report, will see how it unfolds. Thanks On 10/04/2018 15:41, Geert Janssens wrote: > Op maandag 9 april 2018 11:13:16 CEST schreef coolnodje: >>sqlite is still installed and available on my machine. >>I can't make sure which version is used though, as there are several >>and I don't quite get which PATH Gnucash is using on MacOS. >> >>It's very likely that it uses the MacOS pre-installed version and that >>it hasn't changed. >> >>If Gnucash has access to the specific "brew" installed binaries then it >>may be that a newer version isn't compatible. >> >>-nodje > Did you try as suggested in the bug report to add a line to your environment > file ? > That advice was the first suggestion in comment one > https://bugzilla.gnome.org/show_bug.cgi?id=794933#c1 > and this fixed the backend issue for the other reporters. > > Geert > > ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] "No suitable backend" error for database backed gnucash file
All right, so that's one less reason to get the "No suitable backend" error. The sqlite backend shouldn't possibly be missing. Then I just have no lead anymore as for why I could possibly get this problem. Unless you have any advice to debug this I guess I'll just recreate the file with the logs. It's very small but I have a company, a customer and an invoice recorded in it, which I wish I could keep. -nodje On 09/04/2018 16:33, John Ralls wrote: > The Mac bundle has its own copy of sqlite3 along with almost everything else > it needs. It does use some frameworks from /System/Library/Frameworks > (notably AppKit and CoreFoundation) and one or two from /usr/lib. It does not > and cannot use anything from Homebrew; the Homebrew “recipe” for GnuCash just > retrieves and downloads one of our distribution dmgs. > > Regards, > John Ralls > > >> On Apr 9, 2018, at 2:13 AM, coolnodje <coolno...@gmail.com> wrote: >> >> sqlite is still installed and available on my machine. >> I can't make sure which version is used though, as there are several >> and I don't quite get which PATH Gnucash is using on MacOS. >> >> It's very likely that it uses the MacOS pre-installed version and that >> it hasn't changed. >> >> If Gnucash has access to the specific "brew" installed binaries then it >> may be that a newer version isn't compatible. >> >> -nodje >> >> On 08/04/2018 14:33, David Carlson wrote: >> >> Did you verify that you had the back end installed? see >> [1]https://wiki.gnucash.org/wiki/FAQ#SQL_Database >> David C >> >> On Sun, Apr 8, 2018 at 7:10 AM, coolnodje <[2]coolno...@gmail.com> >> wrote: >> >> Using Gnucash on MacOS, I got this error trying to open a recently >> created file which I think I based on a database back-end instead of >> the >> standard. >> I have upgraded to 3.0 in the meantime and thought it was the >> problem. >> But I realized when I finally was able to start a v2.6.20 on an >> older >> MacOS10.12 virtual machine that I still had the problem. >> Which means that this is all unrelated to the 3.0 upgrade. >> I've tried to revert the file to an older version (prior to the last >> modification, so prior to the last successful opening) but got the >> same >> error. >> This really confuses me: >> - the file as it was the last time it was successfully modified >> cannot >> be opened (which should exclude file corruption problem) >> - the latest version on latest MacOS can't open it because "No >> suitable >> backend", but 2.6.20 on MacOS10.12 also can't open it because "No >> suitable backend". >> So if the file itself is not the problem, and if version that used >> to be >> able to open it can't anymore, where could the problem come from? >> Only I wasn't able to reproduce the error with the exact same setup >> I >> had when last successfully modified: trying to reinstall 2.6.20 on >> MacOS10.13 I realized it can't be started anymore (Gnucash can't be >> opened because of a problem - DYLD, [0x4] Symbol missing) >> Is there anything I can do to try to save the file in question? >> - nodje >> ___ >> 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 >> If you are using Nabble or Gmane, please see >> [5]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. >> >> References >> >> 1. https://wiki.gnucash.org/wiki/FAQ#SQL_Database >> 2. mailto:coolno...@gmail.com >> 3. mailto:gnucash-user@gnucash.org >> 4. https://lists.gnucash.org/mailman/listinfo/gnucash-user >> 5. https://wiki.gnucash.org/wiki/Mailing_Lists >> ___ >> gnucash-user mailing list >> gnucash-user@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. ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] "No suitable backend" error for database backed gnucash file
sqlite is still installed and available on my machine. I can't make sure which version is used though, as there are several and I don't quite get which PATH Gnucash is using on MacOS. It's very likely that it uses the MacOS pre-installed version and that it hasn't changed. If Gnucash has access to the specific "brew" installed binaries then it may be that a newer version isn't compatible. -nodje On 08/04/2018 14:33, David Carlson wrote: Did you verify that you had the back end installed? see [1]https://wiki.gnucash.org/wiki/FAQ#SQL_Database David C On Sun, Apr 8, 2018 at 7:10 AM, coolnodje <[2]coolno...@gmail.com> wrote: Using Gnucash on MacOS, I got this error trying to open a recently created file which I think I based on a database back-end instead of the standard. I have upgraded to 3.0 in the meantime and thought it was the problem. But I realized when I finally was able to start a v2.6.20 on an older MacOS10.12 virtual machine that I still had the problem. Which means that this is all unrelated to the 3.0 upgrade. I've tried to revert the file to an older version (prior to the last modification, so prior to the last successful opening) but got the same error. This really confuses me: - the file as it was the last time it was successfully modified cannot be opened (which should exclude file corruption problem) - the latest version on latest MacOS can't open it because "No suitable backend", but 2.6.20 on MacOS10.12 also can't open it because "No suitable backend". So if the file itself is not the problem, and if version that used to be able to open it can't anymore, where could the problem come from? Only I wasn't able to reproduce the error with the exact same setup I had when last successfully modified: trying to reinstall 2.6.20 on MacOS10.13 I realized it can't be started anymore (Gnucash can't be opened because of a problem - DYLD, [0x4] Symbol missing) Is there anything I can do to try to save the file in question? - nodje ___ 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 If you are using Nabble or Gmane, please see [5]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. References 1. https://wiki.gnucash.org/wiki/FAQ#SQL_Database 2. mailto:coolno...@gmail.com 3. mailto:gnucash-user@gnucash.org 4. https://lists.gnucash.org/mailman/listinfo/gnucash-user 5. https://wiki.gnucash.org/wiki/Mailing_Lists ___ gnucash-user mailing list gnucash-user@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.
[GNC] "No suitable backend" error for database backed gnucash file
Using Gnucash on MacOS, I got this error trying to open a recently created file which I think I based on a database back-end instead of the standard. I have upgraded to 3.0 in the meantime and thought it was the problem. But I realized when I finally was able to start a v2.6.20 on an older MacOS10.12 virtual machine that I still had the problem. Which means that this is all unrelated to the 3.0 upgrade. I've tried to revert the file to an older version (prior to the last modification, so prior to the last successful opening) but got the same error. This really confuses me: - the file as it was the last time it was successfully modified cannot be opened (which should exclude file corruption problem) - the latest version on latest MacOS can't open it because "No suitable backend", but 2.6.20 on MacOS10.12 also can't open it because "No suitable backend". So if the file itself is not the problem, and if version that used to be able to open it can't anymore, where could the problem come from? Only I wasn't able to reproduce the error with the exact same setup I had when last successfully modified: trying to reinstall 2.6.20 on MacOS10.13 I realized it can't be started anymore (Gnucash can't be opened because of a problem - DYLD, [0x4] Symbol missing) Is there anything I can do to try to save the file in question? - nodje ___ gnucash-user mailing list gnucash-user@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.