Re: [GNC] help with Gnu Job report
Will do, thanks! On Thu, Nov 18, 2021, 4:04 PM Derek Atkins wrote: > Hi Joe, > > Please do not email people directly; you should ask all gnucash questions > on the gnucash-user mailing list. > > -derek > > On Sun, November 14, 2021 5:34 pm, joe rwabu wrote: > > Hello > > could you please help make a Job report (Gnu Job report) not for a > > specific > > job but all jobs > > > > thanks. > > > > > -- >Derek Atkins 617-623-3745 >de...@ihtfp.com www.ihtfp.com >Computer and Internet Security Consultant > > ___ 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] Price in Register Account report not decimal
Interestingly I opened the html report in Libreoffice Calc directly and it had the decimal not the fraction. Didn't even need to put the "=" in front of it. So thanks John for your suggestion. I'll use it as a work around. Bit of formatting to do but minor issue. Should this be reported as a bug or just leave it as is.? JoeCanuck On 12/08/2019 1:56 am, John Ralls wrote: That preference is for the GUI. I don't think that it has any affect on reports. I can reproduce this, where a price for 5712 shares has a value of 85,505.78 and is represented as 14.9695 in the register but as 14 + 276889/285600 on the Account Report. I don't think that there's an immediate solution for that other than to paste the report into a spreadsheet and stick an '=' in front of the price to make it a formula. Regards, John Ralls On Aug 11, 2019, at 3:24 AM, Joe Normandeau wrote: Colin Yep Build ID: 3.6 + (2019-06-29) JoeCanuck On 11/08/2019 5:36 pm, Colin Law wrote: On Sun, 11 Aug 2019 at 07:00, Joe Normandeau wrote: Apologies Adrien I should have stated that flag is already turned on and I've cycled it number of times and it makes no difference to the Register Account Report. Have you tried that again since you upgraded to 3.6? Also are you sure it is definitely running 3.6? Check in Help > About. Colin JoeCanuck On 10/08/2019 11:58 pm, Adrien Monteleone wrote: Preferences > General > Numbers > Force prices to display as numbers Regards, Adrien On Aug 10, 2019, at 4:09 AM, Joe Normandeau wrote: On 10/08/2019 5:37 pm, Colin Law wrote: On Sat, 10 Aug 2019 at 06:19, Joe Normandeau wrote: I'm just new to this mail list so if I get something wrong be gentle. I've just upgraded to GnuCash 3.3 from 2.6.13 and I can't get the price in the register account report to be decimal. It always comes out as 2 + a fraction ie. 2 + 6227/6779. I must be missing a configuration setting but I can't seem to get the right one. Can someone assist please? I think that may have been a bug in 3.3. Why are you not using the latest available for Windows, which is 3.6 I think? https://gnucash.org/download.phtml Colin Thanks for your comments Collin. I've loaded 3.6 and the same thing happens. Don't know where to go from here as I need these reports for my auditor. JoeCanuck ___ 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. --- This email has been checked for viruses by AVG. https://www.avg.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 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. ___ 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] Price in Register Account report not decimal
Colin Yep Build ID: 3.6 + (2019-06-29) JoeCanuck On 11/08/2019 5:36 pm, Colin Law wrote: On Sun, 11 Aug 2019 at 07:00, Joe Normandeau wrote: Apologies Adrien I should have stated that flag is already turned on and I've cycled it number of times and it makes no difference to the Register Account Report. Have you tried that again since you upgraded to 3.6? Also are you sure it is definitely running 3.6? Check in Help > About. Colin JoeCanuck On 10/08/2019 11:58 pm, Adrien Monteleone wrote: Preferences > General > Numbers > Force prices to display as numbers Regards, Adrien On Aug 10, 2019, at 4:09 AM, Joe Normandeau wrote: On 10/08/2019 5:37 pm, Colin Law wrote: On Sat, 10 Aug 2019 at 06:19, Joe Normandeau wrote: I'm just new to this mail list so if I get something wrong be gentle. I've just upgraded to GnuCash 3.3 from 2.6.13 and I can't get the price in the register account report to be decimal. It always comes out as 2 + a fraction ie. 2 + 6227/6779. I must be missing a configuration setting but I can't seem to get the right one. Can someone assist please? I think that may have been a bug in 3.3. Why are you not using the latest available for Windows, which is 3.6 I think? https://gnucash.org/download.phtml Colin Thanks for your comments Collin. I've loaded 3.6 and the same thing happens. Don't know where to go from here as I need these reports for my auditor. JoeCanuck ___ 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. --- This email has been checked for viruses by AVG. https://www.avg.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 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. ___ 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] Price in Register Account report not decimal
Apologies Adrien I should have stated that flag is already turned on and I've cycled it number of times and it makes no difference to the Register Account Report. JoeCanuck On 10/08/2019 11:58 pm, Adrien Monteleone wrote: Preferences > General > Numbers > Force prices to display as numbers Regards, Adrien On Aug 10, 2019, at 4:09 AM, Joe Normandeau wrote: On 10/08/2019 5:37 pm, Colin Law wrote: On Sat, 10 Aug 2019 at 06:19, Joe Normandeau wrote: I'm just new to this mail list so if I get something wrong be gentle. I've just upgraded to GnuCash 3.3 from 2.6.13 and I can't get the price in the register account report to be decimal. It always comes out as 2 + a fraction ie. 2 + 6227/6779. I must be missing a configuration setting but I can't seem to get the right one. Can someone assist please? I think that may have been a bug in 3.3. Why are you not using the latest available for Windows, which is 3.6 I think? https://gnucash.org/download.phtml Colin Thanks for your comments Collin. I've loaded 3.6 and the same thing happens. Don't know where to go from here as I need these reports for my auditor. JoeCanuck ___ 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. --- This email has been checked for viruses by AVG. https://www.avg.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 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] Price in Register Account report not decimal
On 10/08/2019 5:37 pm, Colin Law wrote: On Sat, 10 Aug 2019 at 06:19, Joe Normandeau wrote: I'm just new to this mail list so if I get something wrong be gentle. I've just upgraded to GnuCash 3.3 from 2.6.13 and I can't get the price in the register account report to be decimal. It always comes out as 2 + a fraction ie. 2 + 6227/6779. I must be missing a configuration setting but I can't seem to get the right one. Can someone assist please? I think that may have been a bug in 3.3. Why are you not using the latest available for Windows, which is 3.6 I think? https://gnucash.org/download.phtml Colin Thanks for your comments Collin. I've loaded 3.6 and the same thing happens. Don't know where to go from here as I need these reports for my auditor. JoeCanuck --- This email has been checked for viruses by AVG. https://www.avg.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 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] Trouble finding executable after build
Luckily I self identified as noob. That was exactly the problem. Thank you both for the help. After running; * sudo make * sudo make install The listing of my /usr/local is below. Which one do I use. I expected it to be in /usr/local/bin michelle@michelle-Lenovo-IdeaPad-Y570:~/Applications/gnucash-3.3/build$ ls /usr/local/* /usr/local/bin: apt dm_date dm_zdump gnc-fq-check gnc-fq-dump gnc-fq-helper gnc-fq-update gnome-help gnucash gnucash-valgrind highlight mint-sha256sum search yelp /usr/local/etc: gnucash /usr/local/games: /usr/local/include: gnucash /usr/local/lib: gnucash libgnc-backend-sql.so libgnc-backend-xml-utils.so libgnc-core-utils.so libgnc-gnome.so libgnc-module.so libgwengui-gtk3.so python2.7 python3 python3.6 x86_64-linux-gnu /usr/local/man: man1 man3 /usr/local/sbin: /usr/local/share: appdata applications ca-certificates doc emacs fonts glib-2.0 gnucash icons locale man perl sgml texmf xml /usr/local/src: Best regard, Joe From: gnucash-user on behalf of Geert Janssens Sent: November 20, 2018 2:55 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] Trouble finding executable after build This is the right question. I don't see a run of make sudo make install If you don't run these successfully, nothing will appear in /usr/local. Note make install is run via sudo. On a typical linux system ordinary users are not allowed to write into /usr/local unless they have administrator privileges and invoke those. That's what "sudo" does. Regards, Geert Op dinsdag 20 november 2018 19:54:03 CET schreef Maf. King: > Hi, > > daft question - did you do a make install? > > I've never compiled GC, and I'm not up with cmake so maybe you don't have > to, but make uninstall failed and I didn't see make install? > > sorry if I'm up the wrong path... > > Maf. > > On Tuesday, 20 November 2018 18:38:26 GMT Joe Peters wrote: > > Hi; > > I am a bit of a noob so hopefully this is an easy answer. I was having > > trouble getting online quotes to work in gnucash so I decided to try and > > build it from source and see if that fixed the issue. Going through the > > guides I believe I managed to do so but I cannot find the program in my > > /usr/local as shown below. My initial compile did not work (shown below) > > but I fixed the missing library (libsecret-1-dev) and then got a build > > with > > no apparent errors. > > > > For reference, below is the listing of; > > > > * Failed attempt to build gnucash > > * My attempt to uninstall > > * Successful build of gnucash? > > * Listing of /usr/local > > > > So my question, I hope someone can answer, is did I build the application > > properly and where is the application? > > > > michelle@michelle-Lenovo-IdeaPad-Y570:~/Applications/gnucash-3.3/build$ > > cmake -DCMAKE_INSTALL_PREFIX=/usr/local -DWITH_PYTHON=ON ../ -- The C > > compiler identification is GNU 7.3.0 > > -- The CXX compiler identification is GNU 7.3.0 > > -- Check for working C compiler: /usr/bin/cc > > -- Check for working C compiler: /usr/bin/cc -- works > > -- Detecting C compiler ABI info > > -- Detecting C compiler ABI info - done > > -- Detecting C compile features > > -- Detecting C compile features - done > > -- Check for working CXX compiler: /usr/bin/c++ > > -- Check for working CXX compiler: /usr/bin/c++ -- works > > -- Detecting CXX compiler ABI info > > -- Detecting CXX compiler ABI info - done > > -- Detecting CXX compile features > > -- Detecting CXX compile features - done > > -- Found PkgConfig: /usr/bin/pkg-config (found version "0.29.1") > > -- Checking for module 'glib-2.0>=2.40' > > -- Found glib-2.0, version 2.56.3 > > -- Checking for module 'gio-2.0' > > -- Found gio-2.0, version 2.56.3 > > -- Checking for module 'gobject-2.0>=2.20' > > -- Found gobject-2.0, version 2.56.3 > > -- Checking for module 'gmodule-2.0>=2.20' > > -- Found gmodule-2.0, version 2.56.3 > > -- Checking for module 'gthread-2.0>=2.20' > > -- Found gthread-2.0, version 2.56.3 > > -- Checking for module 'libxml-2.0>=2.7.0' > > -- Found libxml-2.0, version 2.9.4 > > -- Checking for module 'libxslt' > > -- Found libxslt, version 1.1.29 > > -- Checking for module 'webkit2gtk-4.0' > > -- Found webkit2gtk-4.0, version 2.22.2 > > -- Checking for module 'gtk+-3.0>=3.10.0' > > -- Found gtk+-3.0, version 3.22.30 > > -- Checking for module 'zlib' > > -- Found zlib, version 1.2.11 > > -- Found Gettext: /usr/bin/msgmerge (found suitable version "0.19.8.1&q
[GNC] Trouble finding executable after build
Hi; I am a bit of a noob so hopefully this is an easy answer. I was having trouble getting online quotes to work in gnucash so I decided to try and build it from source and see if that fixed the issue. Going through the guides I believe I managed to do so but I cannot find the program in my /usr/local as shown below. My initial compile did not work (shown below) but I fixed the missing library (libsecret-1-dev) and then got a build with no apparent errors. For reference, below is the listing of; * Failed attempt to build gnucash * My attempt to uninstall * Successful build of gnucash? * Listing of /usr/local So my question, I hope someone can answer, is did I build the application properly and where is the application? michelle@michelle-Lenovo-IdeaPad-Y570:~/Applications/gnucash-3.3/build$ cmake -DCMAKE_INSTALL_PREFIX=/usr/local -DWITH_PYTHON=ON ../ -- The C compiler identification is GNU 7.3.0 -- The CXX compiler identification is GNU 7.3.0 -- Check for working C compiler: /usr/bin/cc -- Check for working C compiler: /usr/bin/cc -- works -- Detecting C compiler ABI info -- Detecting C compiler ABI info - done -- Detecting C compile features -- Detecting C compile features - done -- Check for working CXX compiler: /usr/bin/c++ -- Check for working CXX compiler: /usr/bin/c++ -- works -- Detecting CXX compiler ABI info -- Detecting CXX compiler ABI info - done -- Detecting CXX compile features -- Detecting CXX compile features - done -- Found PkgConfig: /usr/bin/pkg-config (found version "0.29.1") -- Checking for module 'glib-2.0>=2.40' -- Found glib-2.0, version 2.56.3 -- Checking for module 'gio-2.0' -- Found gio-2.0, version 2.56.3 -- Checking for module 'gobject-2.0>=2.20' -- Found gobject-2.0, version 2.56.3 -- Checking for module 'gmodule-2.0>=2.20' -- Found gmodule-2.0, version 2.56.3 -- Checking for module 'gthread-2.0>=2.20' -- Found gthread-2.0, version 2.56.3 -- Checking for module 'libxml-2.0>=2.7.0' -- Found libxml-2.0, version 2.9.4 -- Checking for module 'libxslt' -- Found libxslt, version 1.1.29 -- Checking for module 'webkit2gtk-4.0' -- Found webkit2gtk-4.0, version 2.22.2 -- Checking for module 'gtk+-3.0>=3.10.0' -- Found gtk+-3.0, version 3.22.30 -- Checking for module 'zlib' -- Found zlib, version 1.2.11 -- Found Gettext: /usr/bin/msgmerge (found suitable version "0.19.8.1", minimum required is "0.19.6") -- Using guile-2.0.x -- Using guile SRFI-64 -- Checking for module 'gwenhywfar' -- Found gwenhywfar, version 4.20.0 -- Checking for module 'aqbanking' -- Found aqbanking, version 5.7.8 -- Checking for module 'ktoblzcheck' -- Found ktoblzcheck, version 1.49 -- Checking for module 'gwengui-gtk3' -- Found gwengui-gtk3, version 4.20.0 -- Checking for module 'libofx' -- Found libofx, version 0.9.12 -- Performing Test HAVE_OFX_BUG_39 -- Performing Test HAVE_OFX_BUG_39 - Failed -- Found LibXslt: xslt;xml2 (found version "1.1.29") -- Found PythonInterp: /usr/bin/python3 (found suitable version "3.6.7", minimum required is "3") -- Found PythonLibs: /usr/lib/x86_64-linux-gnu/libpython3.6m.so (found suitable version "3.6.7", minimum required is "3") -- Found Perl: /usr/bin/perl (found version "5.26.1") -- Checking for module 'icu-uc' -- Found icu-uc, version 60.2 -- Checking for module 'icu-i18n' -- Found icu-i18n, version 60.2 -- Checking for module 'libsecret-1>=0.18' -- No package 'libsecret-1' found -- Performing Test have_stringop_truncation -- Performing Test have_stringop_truncation - Failed -- Checking for GTEST -- Looking for pthread.h -- Looking for pthread.h - found -- Looking for pthread_create -- Looking for pthread_create - not found -- Check if compiler accepts -pthread -- Check if compiler accepts -pthread - no -- Looking for pthread_create in pthreads -- Looking for pthread_create in pthreads - not found -- Looking for pthread_create in pthread -- Looking for pthread_create in pthread - found -- Found Threads: TRUE -- Checking for GMOCK -- Looking for include file dirent.h -- Looking for include file dirent.h - found -- Looking for include file dlfcn.h -- Looking for include file dlfcn.h - found -- Looking for include file glob.h -- Looking for include file glob.h - found -- Looking for include file inttypes.h -- Looking for include file inttypes.h - found -- Looking for include file limits.h -- Looking for include file limits.h - found -- Looking for include file locale.h -- Looking for include file locale.h - found -- Looking for include file memory.h -- Looking for include file memory.h - found -- Looking for include file stdint.h -- Looking for include file stdint.h - found -- Looking for include file stdlib.h -- Looking for include file stdlib.h - found -- Looking for include file string.h -- Looking for include file string.h - found -- Looking for include file strings.h -- Looking for include file strings.h - found -- Looking for include file sys/stat.h -- Looking for include file sys/stat.h - found --
Re: [GNC] gnucash: Not able to get Online Quotes to work
Hello, Doing some further digging, trying to figure this problem out; why online quotes will not work for me. I ran gnucash --debug. This is the .trace file contents. Would anyone know if these warning may be causing the issue? * 13:52:54 INFO [main] System locale returned en_CA.UTF-8 * 13:52:54 INFO [main] Effective locale set to en_CA.UTF-8. * 13:52:54 INFO [gnc_hook_lookup] no hook lists * 13:52:54 WARN Could not locate module gnucash/app-utils interface v.0 * 13:52:54 WARN Could not locate module gnucash/engine interface v.0 * 13:52:54 WARN Could not locate module gnucash/register/ledger-core interface v.0 * 13:52:54 WARN Could not locate module gnucash/register/register-core interface v.0 * 13:52:54 WARN Could not locate module gnucash/register/register-gnome interface v.0 * 13:52:54 WARN Could not locate module gnucash/import-export/qif-import interface v.0 * 13:52:54 MESSG Could not locate optional module gnucash/import-export/ofx interface v.0 * 13:52:54 MESSG Could not locate optional module gnucash/import-export/csv-import interface v.0 * 13:52:54 MESSG Could not locate optional module gnucash/import-export/csv-export interface v.0 * 13:52:54 MESSG Could not locate optional module gnucash/import-export/log-replay interface v.0 * 13:52:54 MESSG Could not locate optional module gnucash/import-export/aqbanking interface v.0 * 13:52:54 WARN Could not locate module gnucash/report/report-system interface v.0 * 13:52:54 WARN Could not locate module gnucash/report/stylesheets interface v.0 * 13:52:54 WARN Could not locate module gnucash/report/standard-reports interface v.0 * 13:52:54 WARN Could not locate module gnucash/report/utility-reports interface v.0 * 13:52:54 WARN Could not locate module gnucash/report/locale-specific/us interface v.0 * 13:52:54 WARN Could not locate module gnucash/report/report-gnome interface v.0 * 13:52:54 MESSG Could not locate optional module gnucash/business-gnome interface v.0 * 13:52:54 MESSG Could not locate optional module gnucash/gtkmm interface v.0 * 13:52:54 MESSG Could not locate optional module gnucash/python interface v.0 * 13:52:54 MESSG Could not locate optional module gnucash/plugins/bi_import interface v.0 * 13:52:54 MESSG Could not locate optional module gnucash/plugins/customer_import interface v.0 * 13:52:54 WARN GnuCash engine failed to initialize. Exiting. Also, when I run gnucash --debug --add-price-quotes HomeFinance.gnucash In terminal these are the msg's I get (not sure I ran it correctly?). I have no idea what this means? Backtrace: In ice-9/boot-9.scm: 160: 8 [catch #t # ...] In unknown file: ?: 7 [apply-smob/1 #] ?: 6 [call-with-input-string "(gnc:price-quotes-install-sources)" ...] In ice-9/boot-9.scm: 2404: 5 [save-module-excursion #] In ice-9/eval-string.scm: 44: 4 [read-and-eval # #:lang ...] 37: 3 [lp (gnc:price-quotes-install-sources)] In ice-9/eval.scm: 386: 2 [eval # ()] 393: 1 [eval # ()] In unknown file: ?: 0 [memoize-variable-access! # #] ERROR: In procedure memoize-variable-access!: ERROR: Unbound variable: gnc:price-quotes-install-sources Any suggestions or help would be great. Best regards, Joe From: gnucash-user on behalf of Joe Peters Sent: November 4, 2018 3:24 PM To: gnucash-user@gnucash.org Subject: [GNC] gnucash: Not able to get Online Quotes to work When trying to edit a security, in the 'Edit Security' window, under 'Quote Source Information', everything is grayed out and there is a warning: '> Warning: Finance::Quote not installed properly. <. GnuCash Help|About Version: 3.2 Build ID: 3.2+ (2018-06-24) Finance::Quote: - * I am running linux mint 19 cinnamon * I have set ALPHAVANTAGE_API_KEY=*## in /etc/gnucash/environment. Where ### is my actual key number.* * I have the same key number entered in the preferences tab of gnucash. * I can run (in terminal window) (i exported the ALPHAVANTAGE_API_KEY in the .bashrc file) gnc-fq-dump alphavantage msft Finance::Quote fields Gnucash uses: symbol: msft <=== required date: 11/01/2018 <=== recommended currency: USD <=== required last: 106.3700 <=\ nav: <=== one of these price: <=/ timezone: <=== optional Any help would be greatly appreciated. I have run out of ideas to solve this problem. Thanks, Joe ___ 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
[GNC] gnucash: Not able to get Online Quotes to work
When trying to edit a security, in the 'Edit Security' window, under 'Quote Source Information', everything is grayed out and there is a warning: '> Warning: Finance::Quote not installed properly. <. GnuCash Help|About Version: 3.2 Build ID: 3.2+ (2018-06-24) Finance::Quote: - * I am running linux mint 19 cinnamon * I have set ALPHAVANTAGE_API_KEY=*## in /etc/gnucash/environment. Where ### is my actual key number.* * I have the same key number entered in the preferences tab of gnucash. * I can run (in terminal window) (i exported the ALPHAVANTAGE_API_KEY in the .bashrc file) gnc-fq-dump alphavantage msft Finance::Quote fields Gnucash uses: symbol: msft <=== required date: 11/01/2018 <=== recommended currency: USD <=== required last: 106.3700 <=\ nav: <=== one of these price: <=/ timezone: <=== optional Any help would be greatly appreciated. I have run out of ideas to solve this problem. Thanks, Joe ___ 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: Dealing with a large QIF file
This is also my plan. I'm working on a cross reference plan before I try to import anything. I have a Quicken data file with complete transactions for all bank accounts, credit cards, and loans since Jan 1 1990. I want to get it all into gnucash so I can archive the entire quicken system, but still be able to research the entire period. I'm setting up chart of account pre-import to include many banks and cards with closed accounts. Probably 80% of the accounts in the file are closed. Joe On 2017-12-24 20:23, D via gnucash-user wrote: Gnucash creates the accounts because you and the transactions used those accounts. Personally, I prefer having all that "clutter," since it represents what happened. Accounting is supposed to track what happened, after all. Two points: first, you can hide accounts in the Chart of Accounts, which would allow these accounts to exist without disturbing your daily accounting work. Second, you can delete accounts, if that really is your goal; when you delete an account with transactions in it, you get a chance to move them all to an account of your choosing. (I propose that this would be easier than editing the QIF, as another suggests). Personally, I'd keep the transactions and hide the accounts. David On December 25, 2017, at 5:47 AM, cliffhan...@gardener.com wrote: Thanks. Yes one can import one at a time but this cheque ac from Quicken is huge and has references to other card accounts as categories within it. These accounts don't exist anymore and gnucash is trying to create them as part of the import. This is something I'd like to avoid. Hope this makes sense. Cliff Original Message Subject: Re: Dealing with a large QIF file From: Colin Law To: Cliff McDiarmid CC: gnucash-user@gnucash.org You should be able to export one account at a time from Quicken, I think. Then import them one at a time. Colin On 24 December 2017 at 19:02, Cliff McDiarmid wrote: > Hi > > I'm importing a large QIF file(a current a/c)about 6000 entries. > There are about a dozen other a/c's from Quicken, now closed, > associated with this large file. When importing, Gnucash seems to > want to create these defunct a/c's to 'balance the books'. I assume > there isn't any way of avoiding this. The whole thing looks like it > will be horrendous. I've imported some small credit card a/c's already > with success, but they were not any of these other closed accounts. > > Any advice please. > thanks > > Cliff > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > 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 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 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 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.
MariaDB error 2003: Can't connect to MySQL server on x.x.x.x
Server and client are each on machines connected to different local networks. gnucash version 2.6.18 (3a9fbb8) and MariaDB 10.1.26 (xampp v.7.1.9-0-VC14) all machines running Windows 10 trying to open db using external address of server network. server is bound to 0.0.0.0 user has full privilege with ip address of x.x.x.x where x.x.x.x is local ip address of client machine and external address of client network and local address of gateway on server network gateway on server network is configured to forward port 3306 to ip of server on local network. I tried all combinations that made any sense to me and all return same error. I CAN open db running gnucash on same machine as server using 'localhost' and on a different machine on the same local network using local address of server. User has privilege with local ip of 2nd machine and local address of server. What do I try next? ___ gnucash-user mailing list gnucash-user@gnucash.org 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: Help
Thank you. On Sunday, July 9, 2017, 5:14:40 PM GMT+10, Liz <ed...@billiau.net> wrote: On Sun, 9 Jul 2017 08:03:33 +0100 Colin Law <clan...@gmail.com> wrote: > On 9 July 2017 at 02:48, Joe Farrell via gnucash-user > <gnucash-user@gnucash.org> wrote: > > I have just downloaded GNUCash and want to open my Quicken to > > import, but, I cannot find a Qif file in all of my documents.Any > > ideas? > > You have to export a QIF file from within quicken. > > Colin > someone has kindly provided a quick version in the FAQ https://wiki.gnucash.org/wiki/FAQ#Q:_Which_is_the_best_way_to_import_data_from_Quicken.28TM.29.3F ___ gnucash-user mailing list gnucash-user@gnucash.org 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 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.
Help
I have just downloaded GNUCash and want to open my Quicken to import, but, I cannot find a Qif file in all of my documents.Any ideas? ___ gnucash-user mailing list gnucash-user@gnucash.org 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.