Re: [GNC] Automatic Price Retrieval
> On Apr 29, 2020, at 3:08 AM, rsbrux via gnucash-user > wrote: > > I would like GnuCah to retrieve prices automatically each time I open it. > > The documentation describes the "Get Quotes" feature as "automatic", but I > still have to remember to open the Price Editor and click "Get Quotes". > > Is there a way to make price retrieval fully automatic? Use a cron job/scheduled task to run GnuCash with the --add-price-quotes=FILE argument, FILE being the path to your gnucash data file. 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.
Re: [GNC] Working with dates in Postgresql DB
> On Apr 29, 2020, at 2:18 AM, finf...@gmail.com wrote: > > Dear John, > > Thank you for your response. > > > I have collected some statistics from my DB. > > My DB has 1724 records - transactions. > > This is my SQL query, it is pretty simple and shows all the combinations of > times in posted_date timestamps in transactions table, number of repetitions > for that time value, min enter_date, max enter_date: > > SELECT > t.post_date::TIME as "POST TIME", > COUNT(t.post_date::TIME) as "REPS", > min(t.enter_date) as "MIN ENTER DATE", > max(t.enter_date) as "MAX ENTER DATE" > FROM transactions t > GROUP BY t.post_date::TIME > ORDER BY t.post_date::TIME > > Here are the results: > > > > POST TIME REPS MIN ENTER DATE MAX ENTER DATE > > "00:00:00"18"2020-01-26 18:07:14""2020-01-28 19:11:07" > "10:59:00"1177"2019-12-23 17:55:29""2020-04-23 11:24:24" > "21:00:00"251 "2020-01-08 17:43:54""2020-04-23 10:36:33" > "22:00:00"256 "2020-01-08 17:06:59""2020-04-23 11:24:08" > "23:00:00"22"2020-01-27 19:16:04""2020-01-28 19:39:49" > > > > I live in Cyprus, here is UTC +2 and summer time UTC +3, as I know. > > I started to study Gnucash in December 2019 and have entered my data of > 2016-2020. > > I never changed my place and time zone in the period of working with Gnucash. > > > 1. Most of the records have time in date_posted 10:59:00 for all the period > of data entering. > > 2. Only 2 days of entering have the results of 00:00:00 - 18 records. > > 3. Only 2 days of entering have the results of 23:00:00 - 22 records. > > 4. 21:00:00 and 22:00:00 - 500+ records - 30% of transactions for all the > period of data entering. > > > Can you please explain that? > > Why I have so many different time stamps? When and why the system decides to > write time different from 10:59:00? > > I understand that the system writes real ENTERING date and time and it is > reasonable to use the time zone somehow. > > When I POST the document with exact date in it I suppose to see this POST > DATE the same wherever in Cyprus or UK or USA. But entering the same date I > can have 5 different results. How it works and what is the reason - I have no > idea... > > Maybe you can give some examples and the algorithm to convert these dates? > Where else I have to convert dates? As those are all posted dates you've found a bug or two as posted date should always have a 10:59:00 timestamp. The 21:00 and 22:00 times are clearly midnight local, and which one is used *should* be determined by whether DST is in effect for the posted date in your locale. It seems that 40 transactions somehow used UK time instead of Cypress time. Did you enter all of the transactions from the GnuCash UI or did you import some of them? If you imported some is there any way to tell which were imported (and from where and by what method), perhaps by the accounts their splits are in or because you still have some of the import files? Were any of them created by scheduled 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 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] Working with dates in Postgresql DB
> On Apr 28, 2020, at 3:43 PM, finf...@gmail.com wrote: > > Hi, > > I have found a strange thing trying to create my report with SQL queries from > Postgresql Gnucash database. > > The column post_date in transactions table stores values in timestamp format > (-MM-DD hh:mm:ss). > > If I compare the post date in the transaction inside Gnucash program and in > Postgresql database, I see this: > > Gnucash programPostgresql DB > > 31/12/20172017-12-31 00:00:00 > > 31/12/20172017-12-31 10:59:00 > > 01/01/20182017-12-31 22:00:00 > > --- > > 02/01/20182018-01-01 22:00:00 > > 02/01/20182018-01-02 10:59:00 > > -- > > 31/12/20182018-12-30 22:00:00 > > 31/12/20182018-12-31 10:59:00 > > So, the same dates in DB can be different dates in Gnucash program and vise > versa. > > There are only 00:00:00, 10:59:00, 21:00:00, 22:00:00 values of time. > > Please explain how this mystics work and what is the reason to save dates > like this... > > I cannot make my reports without correct converting of dates. All date-times in GnuCash are stored in UTC but displayed in local time. Transaction posted_dates and a few others are stored at 10:59:00 UTC to produce the same date across most timezones (there are 27 hours of timezones so it's not possible for all of them. If you live along the international date line then the time is adjusted so that it matches the date in your time zone, but it will still change date on you if you go to a timezone more than 23 hours away). Some other date-times are forced to midnight local. I suppose from what you've posted that you're in a +2 with 1 hour DST so that the recorded time for those midnight dates in 2200 UTC in winter and 2100 in summer. I didn't think that it forced anything to midnight UTC though. Might you have entered data while visiting somewhere with a UTC (aka GMT) timezone? 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] GnuCash 3.902 released
The GnuCash development team announces GnuCash 3.902, the first testing release for what will soon be GnuCash 4.0. Changes Baseline requirements Operating Systems: • Linux: Ubuntu 18.04LTS • MacOS: 10.13 • Windows: 8.1 Software Dependencies: • C++ standard is now C++17, requires gcc 8.0 or clang 6.0. • Cmake 3.10 • boost 1.67.0 • gettext 0.19.6 for general use, 0.20 to generate gnucash.pot. • glib-2.0 2.56.1, gtk 3.22.30 • googletest 1.8.0 • ICU, any version. • libdbi 0.8.3 • libxml2 2.9.4 • swig 3.0.12 Now required for building from tarballs as well as from git. • Webkit 2.4.11 Mac & Win32, 2.14.1 Linux/BSD New Features • The matcher window columns are changed from R to C and from U+R to U+C, reflecting that the matcher marks transactions cleared but doesn't reconcile them. (Bug 797338) • OFX imports having balance information will now offer to immediately reconcile, passing the balance information in the file to the reconcile info. • Improve quickfill in the account pickers to filter the choices based on any part of the name. • The GnuCash widget hierarchy for CSS has been revised to be more consistent with Gtk practice. You may need to spend some time with the GtkInspector to get your custom CSS back the way you like it. • When creating a new account hierarchy it's now possible to load account templates from locales other than the one set for the user interface. (Bug 797472) • New Account - Online Account match list to the Import Map Editor. • New invalid maps dialog in the Import Map Editor. (Bug 797612) • Optionally include the account code option in budget view. • Account matcher will decline to match accounts with a different commodity from the imported split if the import information includes the commodity. • Ellipsize the Description and Memo fields in the account matcher. • Enable adding notes to budgets. (Bug 693180) • Support for AQBanking Version 6. This is required to support new FinTS protocols and the European Privacy Directive. • GnuCash 4.x will not migrate old gconf settings from GnuCash 2.4.x. • Reversing transactions will now pop a dialog box to request a posting date. (Bug 782455) • The Accounts page has a new optional column for the hidden property to make it easier to toggle it. Note that in order to see hidden accounts you must still enable that in the Filter by... dialog. (Bug 797486) • The Customer, Vender, and Employee overviews have a process-payment toolbar. (Bug 797605). • Account codes may now optionally be displayed in the Budget Tree View. (Bug 797489). New/Revised Reports • Owner Report Significant Code Changes • The source directories have been rearranged and most of the loadable modules (e.g. libgncmod-engine.so) are now normal dynamic libraries (libgnc-engine.so), shorn of their gnc-module adapters. Make sure that you clean and rebuild your build directory. • All functions marked as deprecated in 3.x are now removed. If you have custom reports be sure to examine gnucash.trace for deprecation warnings and update your reports before trying them in GnuCash 3.91. • libgncmod-generic-import is now libgnc-generic-import. • Scheme no longer uses libgncmodule, always do (use-modules (gnucash foo)) • Autocompletion improvements for the transfer-account field. • New test for invalid mappings for online accounts and a dialog to fix them. • jqplot is replaced by chartjs. • Separate most Guile binding code from the code that it wraps. It's now located in bindings/guile. • Improve Google test integration in cmake. CMake now requires only GTEST_ROOT and only when cmake isn't able to find Google test without help.Unit tests for Scheme code with SRFI64. Deprecations (will be removed in GnuCash 5.0 • gnc:substring-replace-from-to Between 3.10 and 3.902, the following bugfixes were accomplished. Some of these will also be fixed in GnuCash 3.11, some are for 4.0 only. • Bug 693180 - Add notes to budgeting values • Bug 773198 - Move several reports to Example directory/menu • Bug 773199 - Rename and rebuild Welcome to GnuCash Report • Bug 773200 - Rename Sample & Custom Report Group • Bug 782455 - Modify Add Reversing Transaction feature • Bug 797114 - Fixing an SX due to deleted account stuck in an error loop • Bug 797270 - Budget Chart report - translation of header and dates • Bug 797338 - Change "U+R" and "R" labels to "U+C" and "C" in Import matcher • Bug 797351 - General ledger register transaction becomes "zombie" after deletion • Bug 797415 - cannot build without libsecret-1-dev • Bug 797472 - Add option to choose account te
Re: [GNC] Net Worth Linechart report error
> On Apr 27, 2020, at 11:40 AM, Nelson wrote: > > Environment: Version: 3.10 > Build ID: 3.10+(2020-04-11) > Finance::Quote: 1.49 > Windows 10 > > How do I troubleshoot this? TIA. Start with the trace file (https://wiki.gnucash.org/wiki/Tracefile). There should be error messages and maybe a scheme stack trace with more details about the error. 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.
Re: [GNC] Rule based bank account transaction allocation
> On Apr 26, 2020, at 7:39 PM, partha wrote: > > Hi, > > I have imported last financial year txn of my bank account. > > Is there a facility to write rules on the basis of the strings that are in > the description to automate posting of the transaction from suspense account > to the releveant account. > > It looks like it is possibel when you are importing transaction. But > practically it might not be possible to create rules for the all bank > transaction before starting the import. > It's not a built in capability. The built in version uses trainable matching: Import a month or two, assign the new transactions in the match window, repeat. After the first time the matcher will start to suggest matches. After 3 or 4 imports it is usually matching most imported transactions pretty accurately--though you should in general check the matches every time to make sure that it hasn't gone astray. 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.
Re: [GNC] Trying to set up online banking
Jean, Not exactly. There's two "wizards" at play here, the outer Online Banking Setup Assistant and the inner AQBanking setup dialog. That inner one has two tabs, Users and Accounts. The User one, when setting up an OFX DirectConnect user (and maybe for the HBCI/FinTS one, I don't know) includes the ability to download accounts once one has successfully set up the OFX DirectConnect parameters, but not all banks support it; it might also fail for other reasons. When it does work it populates the accounts for that bank and you can quit the AQBanking setup dialog and click next in the Online Banking Setup Assistant. If it doesn't work then no accounts are set up and you have to do so manually, and that's what the Accounts tab in the AQBanking setup dialog is for. Regards, John Ralls > On Apr 26, 2020, at 10:55 AM, jean laroche wrote: > > John, are you saying there's a way to setup the aqbanking without using the > wizard? I completely missed that :( > > > On 4/26/2020 10:44 AM, John Ralls wrote: >> Probably because nobody had the same experience. If the automagic account >> download didn't work then you have to set up the accounts manually in the >> AQBanking setup window using the Accounts tab. >> >> Regards, >> John Ralls >> >> >>> On Apr 26, 2020, at 10:38 AM, jean laroche wrote: >>> >>> Oh absolutely! I'm very familiar with how to setup the OFX stuff (I use >>> ofxclient.py since I can't get aqbanking to work and I customized it for my >>> needs). >>> It's definitely not an issue with the setup, it's a programming issue! >>> Everything starts well with the GC online banking setup wizard, I retrieve >>> the account list, successfully (according to the UI) then when I want to >>> continue with the >>> wizard, the "next" button is grayed out, and I'm stuck there. >>> This is with windows 8, and the latest GC (actually all recent versions of >>> GC). >>> >>> Where do I open a bug on this? I started a thread on the Dev list, asking >>> if anybody else on windows had the same experience and got nowhere with it. >>> Jean >>> >>> >>> On 4/26/2020 2:12 AM, Frank H. Ellenberger wrote: >>>> Hi Jean >>>> >>>> Am 26.04.20 um 03:19 schrieb jean laroche: >>>>> Are you on windows? >>>> Gnucash & Aqbanking version? >>>> >>>>> I have to say, I have not been able to setup the >>>>> online banking thing in GC in windows. >>>> Which Bank? >>>> Did you follow John's instructions? >>>> >>>> Frank >>> ___ >>> 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] Trying to set up online banking
Probably because nobody had the same experience. If the automagic account download didn't work then you have to set up the accounts manually in the AQBanking setup window using the Accounts tab. Regards, John Ralls > On Apr 26, 2020, at 10:38 AM, jean laroche wrote: > > Oh absolutely! I'm very familiar with how to setup the OFX stuff (I use > ofxclient.py since I can't get aqbanking to work and I customized it for my > needs). > It's definitely not an issue with the setup, it's a programming issue! > Everything starts well with the GC online banking setup wizard, I retrieve > the account list, successfully (according to the UI) then when I want to > continue with the > wizard, the "next" button is grayed out, and I'm stuck there. > This is with windows 8, and the latest GC (actually all recent versions of > GC). > > Where do I open a bug on this? I started a thread on the Dev list, asking if > anybody else on windows had the same experience and got nowhere with it. > Jean > > > On 4/26/2020 2:12 AM, Frank H. Ellenberger wrote: >> Hi Jean >> >> Am 26.04.20 um 03:19 schrieb jean laroche: >>> Are you on windows? >> Gnucash & Aqbanking version? >> >>> I have to say, I have not been able to setup the >>> online banking thing in GC in windows. >> Which Bank? >> Did you follow John's instructions? >> >> Frank > > ___ > 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] How to install Gnucash 3.8 on Debian 10 "buster"?
GnuCash doesn't care what python it's linked against as long as it's >= 3.2.0. The Debian packager linked GnuCash 3.10 against python 3.8 and set it as a requirement in the .deb because that's what's on a fully up to date Debian testing. If you're fearful of updates breaking your system you should use only Debian stable. The whole point of testing is to try out version upgrades to see what breaks. Regards, John Ralls > On Apr 26, 2020, at 7:33 AM, km22 wrote: > > As a follow up I have been running Gnucash 3.8 from the Debian testing > repo for a few months now. I recently tried to update but get these > results: > > [Quote1] > > $ sudo apt list --upgradable > > ... > > gnucash-common/testing 1:3.10-1 all [upgradable from: 1:3.8b-1] > gnucash/testing 1:3.10-1 amd64 [upgradable from: 1:3.8b-1+b1] > ... > > [/Quote1] > > > [Quote2] > > $ sudo apt install gnucash > Reading package lists... Done > Building dependency tree > Reading state information... Done > Some packages could not be installed. This may mean that you have > requested an impossible situation or if you are using the unstable > distribution that some required packages have not yet been created > or been moved out of Incoming. > The following information may help to resolve the situation: > > The following packages have unmet dependencies: > gnucash : Depends: libpython3.8 (>= 3.8.2) but it is not going to be > installed > E: Unable to correct problems, you have held broken packages. > > [/Quote2] > > > Question: Is it normal for gnucash to change its Python version (here to > version 3.8) within a maintenance update (here to gnucash version 3.10)? > > I ask because I am hesitant to update my python version for fear of > breaking my system - but just wanted to highlight whether this increase > in Python version is expected within the Gnucash version guidelines? > > Thanks, > Ken > > > On 12/3/2020 10:48 pm, km22 wrote: >> >> As a follow up, what I did is the following to update to 3.8 on my >> Debian 10 system: >> >> 1) Created a file /etc/apt/apt.conf with the line: >> APT::Default-Release "buster"; >> >> 2) Ran sudo apt update. Then ran apt -t testing install gnucash >> >> From the /var/log/apt/history.log file these were the packages that >> were installed/updated: >> >> Start-Date: 2020-03-10 00:14:47 >> Commandline: apt -t testing install gnucash >> Requested-By: ken (1000) >> Install: libgwenhywfar79:amd64 (5.1.3-1, automatic), gcc-10-base:amd64 >> (10-20200222-1, automatic), libhogweed5:amd64 (3.5.1+really3.5.1-2, >> automatic), libgcc-s1:amd64 (10-20200222-1, automatic), >> libnettle7:amd64 (3.5.1+really3.5.1-2, automatic), libffi7:amd64 >> (3.3-3, automatic), libaqbanking44:amd64 (6.0.1-2, automatic), >> libgwengui-gtk3-0:amd64 (5.1.3-1, automatic) >> Upgrade: cryptsetup-initramfs:amd64 (2:2.1.0-5+deb10u2, 2:2.2.2-3), >> libgwenhywfar-data:amd64 (4.20.0-9, 5.1.3-1), cryptsetup-run:amd64 >> (2:2.1.0-5+deb10u2, 2:2.2.2-3), p11-kit-modules:amd64 (0.23.15-2, >> 0.23.20-1), gnucash:amd64 (1:3.4-1+b10, 1:3.8b-1+b1), >> libboost-regex1.67.0:amd64 (1.67.0-13+deb10u1, 1.67.0-17), >> libaqbanking-data:amd64 (5.7.8-3, 6.0.1-2), libgnutls30:amd64 >> (3.6.7-4+deb10u2, 3.6.12-2), libp11-kit0:amd64 (0.23.15-2, 0.23.20-1), >> gnucash-common:amd64 (1:3.4-1, 1:3.8b-1), libtasn1-6:amd64 (4.13-3, >> 4.16.0-2), libstdc++6:amd64 (8.3.0-6, 10-20200222-1), cryptsetup:amd64 >> (2:2.1.0-5+deb10u2, 2:2.2.2-3), libxmlsec1:amd64 (1.2.27-2, 1.2.28-2) >> End-Date: 2020-03-10 00:15:13 >> >> Question I have is why was it necessary for gnucash to install >> packages from the testing repo for packages such as cryptsetup >> (various) or gcc-10-base? Are these really necessary for gnucash? I >> want to maintain a system as close to the base Debian 10 as possible >> so curious to understand why these other packages were required? >> >> Thanks, >> >> Ken >> >> >> >> On 8/3/2020 11:09 pm, km22 wrote: >>> Hi all, >>> >>> Can anyone advise a very simple and safe way of install gnucash 3.8 >>> in Debian 10? >>> >>> I've read posts like this: >>> https://unix.stackexchange.com/questions/107689/how-do-i-install-a-single-package-from-debian-testing-or-unstable-on-stable >>> >>> But I am very reluctant to start messing with things like pinning or >>> temporarily enabling testing repo entirely for fear of breaking my >>> system. >>> >>> Is there a si
Re: [GNC] Trying to set up online banking
> On Apr 25, 2020, at 6:11 PM, Janet Shelby wrote: > > Hello, I am a new user migrating from many years of Quicken. I would like > to use Gnucash if it will download banking transactions, especially credit > card transactions. The tool provided does not get successful results with > no instruction on what to do upon failure. I am an accountant but not an IT > specialist! Can I get assistance here? Thanks. Check your bank's online banking setup page and make sure that it supports OFX DirectConnect. The alternative is OFX WebConnect which uses an Intuit-proprietary authentication mechanism that GnuCash's online banking library is unable to use. If it says that it does, go to https://www.ofxhome.com and search for the bank. If it's there just go to the page for it and check that it has validated recently. If it has then you should be able to use the bank selection in the AQBanking setup. If not then you'll have to try to set it up by hand using whatever information you can glean from the bank's website, which may not be much: It may just say that you need a certain version of Quicken and to go to the online banking tab in that program and select the bank. 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.
Re: [GNC] A Milk Run
> On Apr 25, 2020, at 1:00 AM, flywire wrote: > > Do you realise you are commenting on a personal email sent to David Cousens > who cc'd the mailing list into the reply? I may not have made the point > about rapid changes in communication technology in the last few years > that way on a public forum. Except that you did, on https://github.com/Gnucash/gnucash-docs/pull/128. That comment is now deleted, but it wasn't exactly courteous, nor was it enlightening. Perhaps you realized that and deleted it yourself, but don't try to pretend that you didn't do it. 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.
Re: [GNC] bug or bad feature: entries future-dated
> On Apr 20, 2020, at 7:06 AM, Eric Beversluis > wrote: > > Using GnuCash 3.7 on Mac 10.12.6 > > When I enter a future-dated transaction (eg, On April 15, I enter a VISA card > payment for May1, and type "5/1” into the date cell, GnuCash makes that > 5/1/19 rather than 5/1/20. This creates obvious confusion in the records. I > haven’t had this behavior problem in the past. Is that a bug? > Check the date completion window in Preferences > Date & Time. 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.
Re: [GNC] Balance sheet unusable for LANG="de..."; was: Bad account setup in Guide §12
> On Apr 17, 2020, at 7:26 AM, Frank H. Ellenberger > wrote: > > David > > Am 17.04.20 um 13:00 schrieb David Cousens: >> Frank >> >> In that case you should be concerned as the trading account balances are >> currently reported under equity in the Balance sheet. >> >> The attached is a Balance sheet run on a dummy book I created >> Trading_Test_BalSheet.png >> <http://gnucash.1415818.n4.nabble.com/file/t375329/Trading_Test_BalSheet.png> >> > > Oh, that makes the balance sheet useless for german and probably other > users. Unrealized gains/losses do not belong in the balance. The user > has to manually enter value adjustments in the closing book process > according local law to reflect them, if applicable. > > That was also the reason, why the trading accounts were not implemented > over a decade. If you don't want unrealized gains change the price source to Average Cost. 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.
Re: [GNC] Editing SCM quesion
> On Apr 15, 2020, at 10:57 AM, bob_summers wrote: > > Hi > > Ubuntu, gnucash 3.7 > > I need to generate invoices (I use the easy invoice template) in an > unsupported language (Basque/Euskera) so I can't just open Gnucash using the > locale options. > > Previously I've been doing this by hand editing the easy-invoice.scm file, > easy enough to find and replace words like Total, Tax, etc (although it's in > /Usr/Share it gets overwritten with each update, but I just keep a backup). > > With v3.7, the easy-invoice.scm does not work in the same way and I cannot > find where these variables are kept. You can see below the part I used to > change, and I can't find these expressions anywhere now. > > Wondering if in >3.7 it is even possible to change these expressions. > > >> (let* ((col-vector (make-vector columns-used-size #f)) >> (set-col (make-set-col col-vector))) >>(set-col (opt-val "Display Columns" "Date") 0) >>(set-col (opt-val "Display Columns" "Description") 1) >>(set-col (opt-val "Display Columns" "Charge Type") 2) >>(set-col (opt-val "Display Columns" "Quantity") 3) >>(set-col (opt-val "Display Columns" "Price") 4) >>(set-col (opt-val "Display Columns" "Discount") 5) >>(set-col (opt-val "Display Columns" "Taxable") 6) >>(set-col (opt-val "Display Columns" "Tax Amount") 7) >>(set-col (opt-val "Display Columns" "Total") 8) >>col-vector)) >> >> (define (make-heading-list column-vector) >> >> (let ((heading-list '())) >>(if (date-col column-vector) >>(addto! heading-list (_ "Data/Fecha"))) >>(if (description-col column-vector) >>(addto! heading-list (_ "Azalpena/Descripción"))) >>(if (action-col column-vector) >> (addto! heading-list (_ "Charge Type"))) >>(if (quantity-col column-vector) >> (addto! heading-list (_ "Kop./Cant."))) >>(if (price-col column-vector) >> (addto! heading-list (_ "Prezioa/Precio"))) >>(if (discount-col column-vector) >> (addto! heading-list (_ "Dtua./Dto."))) >>(if (tax-col column-vector) >> (addto! heading-list (_ "Taxable"))) >>(if (taxvalue-col column-vector) >> (addto! heading-list (_ "Tax Amount"))) >>(if (value-col column-vector) >> (addto! heading-list (_ "Zenbat./Importe"))) >>(reverse heading-list))) > We do have a Basque translation, it just hasn't been updated in 15 years: > msgfmt --statistics po/eu.po > 1527 translated messages, 2545 fuzzy translations, 1351 untranslated messages. > It's vastly easier and more robust to fix any missing or fuzzy translations, recompile it, and install it into share/locale/eu/LC_MESSAGES than to mess with the report or stylesheet code. Detailed instructions at https://wiki.gnucash.org/wiki/Translation. We'd love it if you'd share your updated translation with us. 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.
Re: [GNC] Would like to use, but ....
> On Apr 15, 2020, at 7:27 AM, Geert Janssens > wrote: > > Op woensdag 15 april 2020 15:31:35 CEST schreef Fred Bone: >> On 15 April 2020 at 9:02, Derek Atkins said: >>> Hi Andrew, >>> >>> First, please remember to CC gnucash-user on your replies so that others >>> may benefit from the conversation and chime in. You can do this by using >>> the Reply-To-List or Reply-All functionality in your mailer. >>> >>> If you could supply us with the URL of the page that points to WinXP, >>> there is a chance that we might be able to fix it. BUt of course it >>> depends if it is on a page that we can control or not. No way for us to >>> tell without knowing the specific page ;) >> >> The "XP/Vista" text in the "Download Gnucash 3.10" box at the top of the >> main gnucash.org page links to >> https://downloads.sourceforge.net/sourceforge/gnucash/gnucash-2.6.21.setup >> .exe > > Right, this turns out to be a typo in the link. I have fixed it now; If you > reload the gnucash home > page it should now properly download the correct package. That solves the problem of the link on our page but there's still a SourceForge problem: When you visit any of the GnuCash pages on SF there's a big green download button. What download it points to is determined by the user agent string from your browser, and if that says you're running Windows it points to the latest gnucash-xxx-setup.exe. There's no reliable way for it to know what version of Windows you have. The same is true of MacOS: Someone connecting with a PPC Mac running 10.5 will get pointed to the latest Mac bundle, which won't work. 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.
Re: [GNC] Online price updating
> On Apr 13, 2020, at 11:37 AM, Mohamed Omar wrote: > > Dear All, > I am testing GnuCash personal finance program ability to update our UAE > Finantial Stock Market (Abu Dhabi – ADX & Dubai DFM) . > I followed the steps of using Finance::Qoute by downloading the file and > ActivePerl software. I become upset due to unfortunately my lack of > understand some process. > Can you advise me if I could obtain of market stock prices after complete the > installing the the patch file on my PC. AFAICT there is no module in Finance::Quote for retrieving data from either of those exchanges, but the stock quotes might be available through Yahoo. You can test that by trying to get quotes from the Yahoo finance web site. If you can figure out the right symbols to look up then you can set up your securities in GnuCash with those symbols and set the price quote source to yahoo-json. 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.
Re: [GNC] Which file contains the account name map for the CSV import tool?
> On Apr 12, 2020, at 9:31 AM, Patrick wrote: > > I'd like to work on a gnucash file on a new machine. I'd like to transfer > the account name map that is used by the CSV import tool (see the bullet > "Match Import and GnuCash accounts") from the old machine to the new > machine. Is this mapping stored in a file that I can transfer to the new > machine? > > I have looked in the "Configuration Locations" section of the wiki, but it > wasn't clear to me if this contained the answer I was looking for. Those mappings are stored in your book (i.e. .gnucash) file. https://wiki.gnucash.org/wiki/Backup lists all of the files that you'll need to copy to the new machine. 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.
Re: [GNC] cMakeError.log errors - building Gnucash 3.10
> On Apr 12, 2020, at 4:25 AM, finf...@gmail.com wrote:
>
> I have these errors in cMakeError.log after cmake:
>
> Can anybody explain how to fix that?
>
>
>
> Performing C++ SOURCE FILE Test HAVE_OFX_BUG_39 failed with the following
> output:
> Change Dir: /home/dfg/Applications/build-gnucash-3.10/CMakeFiles/CMakeTmp
>
> Run Build Command:"/usr/bin/ninja" "cmTC_5918e"
> [1/2] Building CXX object CMakeFiles/cmTC_5918e.dir/src.cxx.o
> [2/2] Linking CXX executable cmTC_5918e
> FAILED: cmTC_5918e
> : && /usr/bin/c++ -DHAVE_OFX_BUG_39 CMakeFiles/cmTC_5918e.dir/src.cxx.o -o
> cmTC_5918e -lofx && :
> /usr/bin/ld: CMakeFiles/cmTC_5918e.dir/src.cxx.o: in function `main':
> src.cxx:(.text+0xb5): undefined reference to
> `ofxdate_to_time_t(std::__cxx11::basic_string,
> std::allocator >)'
> collect2: error: ld returned 1 exit status
> ninja: build stopped: subcommand failed.
>
> Return value: 1
> Source file was:
>
> #include
> #include
> #include
> extern time_t ofxdate_to_time_t(const std::string ofxdate);
>
> int main(int argc, char** argv)
> {
> const std::string timestr = "2016031900";
> struct tm ts;
> ts.tm_year = 116;
> ts.tm_mon = 2;
> ts.tm_mday = 19;
> #ifdef _WIN32
> putenv("TZ=PST-8PDT-7,M 4.1.0/0,M 10.6.0/0");
> #else
> setenv("TZ", "PST 08P DT 07 M 4.1.0, M 10.6.0", 1);
> #endif
> time_t t = ofxdate_to_time_t(timestr);
> if (t == mktime(&ts))
> exit(1);
> exit(0);
> }
>
> Determining if the pthread_create exist failed with the following output:
> Change Dir: /home/dfg/Applications/build-gnucash-3.10/CMakeFiles/CMakeTmp
>
> Run Build Command:"/usr/bin/ninja" "cmTC_2d065"
> [1/2] Building C object CMakeFiles/cmTC_2d065.dir/CheckSymbolExists.c.o
> [2/2] Linking C executable cmTC_2d065
> FAILED: cmTC_2d065
> : && /usr/bin/cc -Wno-error=deprecated-declarations -std=gnu11
> -Wno-error=parentheses -Werror -Wdeclaration-after-statement
> -Wno-pointer-sign -Wall -Wmissing-prototypes -Wmissing-declarations
> -Wno-unused CMakeFiles/cmTC_2d065.dir/CheckSymbolExists.c.o -o cmTC_2d065 &&
> :
> /usr/bin/ld: CMakeFiles/cmTC_2d065.dir/CheckSymbolExists.c.o: in function
> `main':
> CheckSymbolExists.c:(.text+0x1f): undefined reference to `pthread_create'
> collect2: error: ld returned 1 exit status
> ninja: build stopped: subcommand failed.
>
> File
> /home/dfg/Applications/build-gnucash-3.10/CMakeFiles/CMakeTmp/CheckSymbolExists.c:
> /* */
> #include
>
> int main(int argc, char** argv)
> {
> (void)argv;
> #ifndef pthread_create
> return ((int*)(&pthread_create))[argc];
> #else
> (void)argc;
> return 0;
> #endif
> }
>
> Determining if compiler accepts -pthread failed with the following output:
> Change Dir: /home/dfg/Applications/build-gnucash-3.10/CMakeFiles/CMakeTmp
>
> Run Build Command:"/usr/bin/ninja" "cmTC_12d58"
> [1/2] Building C object CMakeFiles/cmTC_12d58.dir/CheckForPthreads.c.o
> FAILED: CMakeFiles/cmTC_12d58.dir/CheckForPthreads.c.o
> /usr/bin/cc -Wno-error=deprecated-declarations -std=gnu11
> -Wno-error=parentheses -Werror -Wdeclaration-after-statement
> -Wno-pointer-sign -Wall -Wmissing-prototypes -Wmissing-declarations
> -Wno-unused -o CMakeFiles/cmTC_12d58.dir/CheckForPthreads.c.o -c
> /usr/share/cmake-3.13/Modules/CheckForPthreads.c
> /usr/share/cmake-3.13/Modules/CheckForPthreads.c:3:7: error: no previous
> prototype for ‘start_routine’ [-Werror=missing-prototypes]
> 3 | void* start_routine(void* args)
> | ^
> cc1: all warnings being treated as errors
> ninja: build stopped: subcommand failed.
>
>
> Determining if the function pthread_create exists in the pthreads failed with
> the following output:
> Change Dir: /home/dfg/Applications/build-gnucash-3.10/CMakeFiles/CMakeTmp
>
> Run Build Command:"/usr/bin/ninja" "cmTC_59318"
> [1/2] Building C object CMakeFiles/cmTC_59318.dir/CheckFunctionExists.c.o
> [2/2] Linking C executable cmTC_59318
> FAILED: cmTC_59318
> : && /usr/bin/cc -Wno-error=deprecated-declarations -std=gnu11
> -Wno-error=parentheses -Werror -Wdeclaration-after-statement
> -Wno-pointer-sign -Wall -Wmissing-prototypes -Wmissing-declarations
> -Wno-unused -DCHECK_FUNCTION_EXISTS=pthread_create
> CMakeFiles/cmTC_59318.dir/CheckFunctionExists.c.o -o cmTC_59318 -lpthreads
> && :
> /usr/bin/ld: cannot find -lpthreads
> collect2: error: ld returned 1 exit status
> ninja: build stop
Re: [GNC] Gnucash and Windows 10 Aero snap feature
There's no config for that. AeroSnap isn't fully supported by Gtk. For a somewhat technical discussion of why and whether it will change in Gtk4, see https://gitlab.gnome.org/GNOME/gtk/issues/105. Regards, John Ralls > On Apr 11, 2020, at 2:41 PM, wrote: > > Hi All, > > > > Is there a property in a gnucash config that I can edit to allow aero snap > control handed to windows 10? It seems gnucash 3.x series doesn't get along > with this feature. > > > > I have an ultrawide monitor. In default mode, if I snap gnucash to left or > right side, it snaps perfectly fine and allows me to select tiles to snap to > the opposing side. However, if I snap another window first, then gnucash > will disappear. There is no gnucash tile to select. I have to bring gnucash > back to the visible screen by clicking its icon the toolbar and then > manually moving and sizing gnucash into place. > > > > The problem is more pronounced when I chop my display into 3 or 4 splits. In > this mode, gnucash will not snap to either side or middle splits. If I snap > other apps first, gnucash will again just disappear. If I change the order > of my splits, gnucash will not follow. It just floats in its spot or it ends > up disappearing behind other apps. > > > > Cheers, > > Ameet > > > > > > > > ___ > 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.
[GNC] GnuCash 3.10 Released
The GnuCash development team announces GnuCash 3.10, the eleventh release of the 3.x stable release series. Changes This is a snap release to reverse the changes to the reconcile window's filtering reconciled transactions with a reconcile date after the current statement date when computing the starting balance. It seems that many users' books have accounts with reconcile dates in the future that were suddenly filtered out, creating an incorrect starting balance and making it impossible to reconcile the book. Between 3.9 and 3.10, the following bugfixes were accomplished: Bug 620848 - Transfer Funds window - add Notes field Bug 797006 - Balance is misleading in open subaccounts when different currencies are involved Bug 797318 - Amounts ending in zero displayed as fractions Bug 797666 - libgnucash/engine/test/test-recurrence.c: In function 'check_valid': 'result' may be used uninitialized Bug 797676 - Register displays amount in transaction currency instead of register currency. Bug 797674 - 3.9: "test-gnc-path-util" failed on Debian amd64 The following fixes and improvements were not associated with bug reports: Update latest translation from the Translation project. [window-reconcile] when reconciling, warn on splits having a reconcile date > statement_date [window-reconcile] when inputing statement_date, warn if it's after today [find-transactions] add search for reconciled date Show transaction value, not amount, for registers with subaccounts. If the register has subaccounts in different currencies and a transaction has splits in more than one, the transaction will incorrectly appear to be unbalanced if we total amounts because the balancing logic works on split values. Add instance argument to Session constructor Enables a python console to connect to the running GnuCash's session. Make python console less noisy without --debug. Provide locals and globals of calling context to the python console's shell on shell init Merge Jean Laroche's '797006_subaccounts' into maint. Add check to display warning dialog for mismatched commodities Replicate changes in *2 files Apply astyle to modified files Merge Chris Mayo's iPython-fixes into maint. Make pycons/ishell.py compatible with Python 3 and current IPython [eguile-utilities] Prevent crash in balsheet-eg.scm [eguile] escape-html -> gnc:html-string-sanitize [qif-to-gnc] Properly mark intra-QIF internal transfers. We have a revised Ukrainian translation. Known Issues The following are open bug reports to the 3.x series considered significant by the development team: Bug 795383 - Gnucash crashes on import of a 1400-transaction (or more) CSV file Bug 796955 - Import CSV - Single-line two-currency transactions can't be imported Bug 796992 - gnucash --add-price-quotes can't parse drive letters on Windows. Bug 796997 - Currency Conversion Dialog appears when recording transactions between same currency accounts. Bug 797037 - Counter formats not saving Bug 797064 - crash when try print report Bug 797083 - Gnucash crashes when trying to rename budget Bug 797092 - Save As fails: tries to save to reserved directory if path contains spaces Bug 797113 - Scrubbing crashes when creating small splits that round to value 0. Bug 797114 - Fixing an SX due to deleted account stuck in an error loop Bug 797115 - Can't 're-activate' an expired SX Bug 797211 - Very slow UI - dependent on window size Bug 797220 - delete account allows move of all transactions to account having non-matching currency Bug 797236 - Regression: Reconcile window transaction list resets to top when new transaction created in account Bug 797264 - 3.5 can't use Chinese IME input Bug 797283 - Permanent hang on clicking on report tabs Bug 797285 - QIF import fails and then crashes Bug 797293 - Crash when import "U+R" or "R" Bug 797294 - Billing functions freezing Bug 797325 - [Windows 7] Reports with charts will not load Bug 797329 - Using Japanese IME to enter transactions results in unexpected field jumps Bug 797334 - Crash on attempting to change account separator character Bug 797335 - Crash on subsequent Open after accidentally Opening the current file Bug 797336 - CSV Accounts import fails on UTF-8 e-acute in account name Bug 797345 - Selecting item in tax table causes gnucash to crash Bug 797348 - Wrong column order for RTL writing in GUI elements Bug 797351 - General ledger register transaction becomes "zombie" after deletion Bug 797363 - Consistent Silent Crash on Converting Saved Reports from 2.6 to 3.6 Bug 797368 - Cannot download Quantity information from a CSV to a mutual Bug 797384 - Gnucash doesn't handle commodity prices with big numerator/denominator properly Bug 797385 - Report html files NOT opening in Reports tab or window due to
Re: [GNC] Canadian Sales Tax Questions and/or "Canadian Version" of GnuCash
Yes, you can use Homebrew, but they just wrap the Gnucash.app that I build and distribute via https://www.gnucash.org so I don't see why you'd want to. Regards, John Ralls > On Apr 9, 2020, at 12:14 PM, jess wrote: > >> Is there an "Update" software function in the program somewhere, as I > have not been able to see any obvious place to do this? > > macOS has homebrew which can be used to update. > >> I see there is GnuCash 3.9 version offered on the website, but will I >> lose all existing > data in my existing GnuCash 3.4+ > > No, your data is held in a .gnucash (or equivalent). You can open that same > file in GNUCash. > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > 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] Help!
> On Apr 9, 2020, at 5:24 AM, Adrien Monteleone > wrote: > > If I’m not mistaken, 2.6.21 is 64bit. Nope. It's 32-bit. Not a problem of Evelyn, who's only going to 10.13. 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.
Re: [GNC] Canadian Sales Tax Questions and/or "Canadian Version" of GnuCash
> On Apr 8, 2020, at 11:55 AM, Patrick Farrell wrote:
>
> Is there a "Canadian Version" of GnuCash as all the documentation in the
> current version of GnuCash 3.4+ (Build 2018-12-30) that I have read relates
> to the USA Tax System?
>
> I immediately need to know how to set up automatically calculating how to add
> Canadian Harmonized Sales Tax ("HST") @ 13% to any Invoices I make up and
> send out to Clients/Customers, and then how to separately account for HST
> that I pay on any invoices that I receive from our vendors and subsequently
> pay. I then need to offset the HST received from Client/Customers versus the
> HST I have paid out to Vendors and do an official Government HST filing at
> least Quarterly, and pay them the difference if any!
>
> Is there an "Update" software function in the program somewhere, as I have
> not been able to see any obvious place to do this? I see there is GnuCash 3.9
> version offered on the website, but will I lose all existing data in my
> existing GnuCash 3.4+ if I download 3.9 on top of it or have to delete 3.4+
> before I install version 3.9?
There are no national versions, and in any case even US residents would be
foolish indeed to rely on GnuCash's documentation for tax information. The
Tutorial and Concept Guide presents a very basic overview of accounting to help
new users understand how GnuCash is different from programs like KMyMoney or
Quicken. Beyond that any examples are intended to illustrate how to do tasks in
GnuCash.
No, GnuCash has no "check for updates" function. MacOS and Microsoft Windows
users can install new all-in-one packages. Linux users can either install the
flatpak or rely on their distro's package manager though most of those tend to
lag behind releases. Installing an upgrade in the same major release shouldn't
affect your data.
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.
Re: [GNC] Price of gold
> On Apr 8, 2020, at 7:31 AM, Eric Coates via gnucash-user > wrote: > > Good Afternoon > > On 08/04/2020 10:08, Frank H. Ellenberger wrote: > >> The quotes are not from ISO-4217:XAU (troy ounce Gold), but from >> NASDAQ:XAU an share index of gold and silver producers. > > So, is there a relationship between this NASDAQ:XAU figure and (what might be > termed) the real price of gold (ie the mid-value retail price of a gram of > gold, using grams to avoid the confusion between troy ounces and the other > ounce)? > > Just out of interest really > It's https://en.wikipedia.org/wiki/Philadelphia_Gold_and_Silver_Index. It has a relationship to the spot price of gold but probably not close enough to be of much use. To get the current USD spot price of Gold in the Zurich Forex markets look for the XAU:USD exchange rate; that's what GnuCash will do if you have an account denominated in the XAU currency and your book currency is USD. The gold amount is Troy ounces, about 40 grams. (The "other ounce" is avoirdupois, about 28 grams each.) 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.
Re: [GNC] CRIT [gnc_price_unref()] last unref while price in database
Excellent that you're back in business. What was wrong with the transaction? Regards, John Ralls > On Apr 7, 2020, at 12:15 PM, wrote: > > Many thanks for that, John. > > I'd already got the same error when I opened the last backup file, which is > why I assumed it was more than just a corrupt data file. > > I had to go back 3 versions before I found the one that loaded, but I've > then been able to import all the subsequent log files. > > There was one transaction causing the problem, a foreign currency > transaction. > > All now looks good. > > Thanks again for your help. > > Kind regards, > Rob > > -Original Message- > From: John Ralls > Sent: 07 April 2020 18:34 > To: RobBruce > Cc: gnucash-user@gnucash.org > Subject: Re: [GNC] CRIT [gnc_price_unref()] last unref while > price in database > > > >> On Apr 7, 2020, at 9:56 AM, RobBruce wrote: >> >> I'm running 3.4 on Windows 10. >> >> Until this afternoon, it's been running very smoothly. >> >> On trying to load GnuCash, I got a message that there was an error >> parsing the file E:\Documents\gnucash-rob\rob-gnucash.gnucash >> >> I did look for solutions, and opened the trace log, which contains: >> >> * 12:49:21 WARN Could not spawn perl: Failed to >> execute child process (No such file or directory) >> * 12:49:21 WARN Could not read from compressed file >> 'E:\Documents\gnucash-rob\rob-gnucash.gnucash'. The error is: >> 'E:\Documents\gnucash-rob\rob-gnucash.gnucash: invalid block type' >> (-3) >> * 12:49:21 CRIT parse failed at: >> * 12:49:21 CRIT [gnc_price_unref()] last unref while >> price in database >> * 12:49:21 CRIT [gnc_price_unref()] last unref while >> price in database >> * 12:49:21 WARN [GncXmlBackend::load()] Syntax error in >> Xml File E:\Documents\gnucash-rob\rob-gnucash.gnucash >> >> I'm not aware of having made any change to the file structure - is >> this recoverable, please? > > It looks like you have a corrupted file. Try loading the last backup, which > should be named something like rob-gnucash.gnucash.20200405154732.gnucash; > the numbers in the middle are a date stamp, mmddhhmmss, for the > subsequent save. Depending on what work you did in the last session you may > be able to recover some of it by replaying the corresponding log file with > File>Import>Replay log file. > > You should also check the drive with `chkdsk` and `wmic diskdrive get > status` to make sure that the corruption was something random like a cosmic > ray and not the first sign of needing a new one. > > 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.
Re: [GNC] CRIT [gnc_price_unref()] last unref while price in database
> On Apr 7, 2020, at 9:56 AM, RobBruce wrote: > > I'm running 3.4 on Windows 10. > > Until this afternoon, it's been running very smoothly. > > On trying to load GnuCash, I got a message that there was an error parsing > the file E:\Documents\gnucash-rob\rob-gnucash.gnucash > > I did look for solutions, and opened the trace log, which contains: > > * 12:49:21 WARN Could not spawn perl: Failed to execute > child process (No such file or directory) > * 12:49:21 WARN Could not read from compressed file > 'E:\Documents\gnucash-rob\rob-gnucash.gnucash'. The error is: > 'E:\Documents\gnucash-rob\rob-gnucash.gnucash: invalid block type' (-3) > * 12:49:21 CRIT parse failed at: > * 12:49:21 CRIT [gnc_price_unref()] last unref while price in > database > * 12:49:21 CRIT [gnc_price_unref()] last unref while price in > database > > * 12:49:21 WARN [GncXmlBackend::load()] Syntax error in Xml > File E:\Documents\gnucash-rob\rob-gnucash.gnucash > > I'm not aware of having made any change to the file structure - is this > recoverable, please? It looks like you have a corrupted file. Try loading the last backup, which should be named something like rob-gnucash.gnucash.20200405154732.gnucash; the numbers in the middle are a date stamp, mmddhhmmss, for the subsequent save. Depending on what work you did in the last session you may be able to recover some of it by replaying the corresponding log file with File>Import>Replay log file. You should also check the drive with `chkdsk` and `wmic diskdrive get status` to make sure that the corruption was something random like a cosmic ray and not the first sign of needing a new one. 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.
Re: [GNC] GNU 3.9 WIn 10 menus completely disconnected from app in dual monitor mode
Could you try https://code.gnucash.org/builds/win32/maint/gnucash-3.9-2020-04-03-git-3.9-5-gbedc9631f+.setup.exe? MinGW64 upgraded gtk from 3.24.14 to 3.24.16 two days after the 3.9 release. Regards, John Ralls > On Apr 4, 2020, at 9:33 AM, wrote: > > I have an update - the menu items appear normal when the application is on > my primary monitor. However, if the main app is on my secondary monitor, > the menu items appear on the primary monitor. > > > > So there is an issue with the use of dual monitors. > > > > Frank > > > > From: fci...@gmail.com > Sent: Saturday, April 4, 2020 12:25 PM > To: 'gnucash-de...@gnucash.org' > Subject: GNU 3.9 WIn 10 menus completely disconnected from app > > > > Hi > > > > I upgraded to 3.9 on Wins 10. The app menu items do not appear in a > drop-down. They are totally disconnected from the app off to the side. > > > > Not sure how this happened. > > > > Thanks > > Frank > > ___ > 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] aqbanking not working for me in 3.9 on mac
I found that not to work when I was working on AQBanking a couple of weeks ago.
It wrote the log file to /tmp/ofx.log no matter what I set AQOFX_LOG_COMM to. I
also found it necessary to set AQOFXCONNECT_LOGLEVEL=info (or debug) to get AQB
to write ofx.log.
Regards,
John Ralls
> On Mar 30, 2020, at 11:51 AM, Martin Preuss wrote:
>
> Dave,
>
> you could try "AQOFX_LOG_COMM=PATH_TO_LOGFILE" ("=1" should still create
> the default log file, but in newer versions of AqBanking you can also
> set the path and name of the log file to use).
>
>
> Martin
>
>
> Am 30.03.20 um 06:10 schrieb David Reiser via gnucash-user:
>> Giving Gnucash 3.9 full disk access in System Prefs allows the retrieval to
>> work correctly, but does not reenable ofx.log creation.
>>
>> Dave
>> --
>> Dave Reiser
>> dbrei...@icloud.com
>>
>>
>>
>>
>>
>>> On Mar 29, 2020, at 11:42 PM, David Reiser via gnucash-user
>>> wrote:
>>>
>>> Gnucash 3.9 on MacOS 10.15.4 is not successfully retrieving transactions
>>> for me.
>>>
>>> I ran a Get Transactions in 3.9 from one of my Chase credit card accounts
>>> and got a blank matcher window.
>>>
>>> Quit 3.9
>>> Launch 3.7, and run the Get Transaction process. One new and one
>>> to-be-added transactions are displayed in the matcher window.
>>> Cancel the import
>>> Quit 3.7
>>> Go back to 3.9, verify the transactions aren’t cleared or imported, rerun
>>> Get Transactions. Nothing appears in the matcher window.
>>>
>>> And I can’t tell if it’s aqbanking or gnucash.
>>> I used to be able to add AQOFX_LOG_COMM=1 to
>>> /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment and
>>> have the ofx data stream show up in /tmp/ofx.log.
>>> That log file isn’t updated from 3.9, even with the environment variable
>>> added.
>>>
>>> Dave
>>> --
>>> Dave Reiser
>>> dbrei...@icloud.com
>>>
>>>
>>>
>>>
>>>
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> 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.
>>
>
>
> --
> "Things are only impossible until they're not"
> ___
> 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] General Ledger
> On Mar 29, 2020, at 4:52 PM, Adrien Monteleone > wrote: > > Linux and Mac don’t generally care if a file has an extension. They determine > the file type independent of it. That's sadly no longer true of MacOS and hasn't been since IIRC 10.7. The pre-NeXTStep MacOS used a extended attribute to determine file type and the early versions of Mac OS X continued the practice. Support for that was deprecated in 10.6 and while not formally removed it seemed to stop working in 10.7. There is limited support for determining file type from the command line by looking at the file header, but Finder can't do that. File type displayed in Finder, application associations, and QuickLook display of files is all driven by the extension. 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] GnuCash 3.9 Released
The GnuCash development team announces GnuCash 3.9, the tenth release of the 3.x stable release series. Changes Between 3.8 and 3.9, the following bugfixes were accomplished: • Bug 685102 - Scheduled Transactions don't always respect weekends for first occurrence • Bug 794916 - Fails to find environment file at startup when installation prefix is '/opt' • Bug 796579 - Cannot go forward with empty duplicates screen • Bug 796911 - Minimum window width to large. To fix this the text labels used have been enabled to ellipsize at the end • Bug 796984 - Import Bills & Invoices: date of line item is not validated; can lead to unexpected results • Bug 796985 - Import Bills & Invoices: option 'open not yet posted docs in tab' does not open tab if invoice could not be posted • Bug 796986 - Import Bills & Invoices: in case of invalid posting date in import file, invoice is posted with unexpected date • Bug 796987 - Import Bills & Invoices: fixing import items only works in special case • Bug 797022 - Import Bills & Invoices: expense/income account is not validated - leads to one-sided posting if account is invalid • Bug 797023 - Import Bills & Invoices: no user confirmation requested for update of invoices, if new invoice is created first • Bug 797024 - Import Bills & Invoices: import matches csv data rows with too few separators, messing up the import data • Bug 797025 - Import Bills & Invoices: the type of the post to account is not validated - enabling A/P and A/R postings on regular accounts • Bug 797042 - OK button in OFX importer doesn't work if nothing is imported. • Bug 797133 - CSV Import of multicurrency transaction export in multiline form • Bug 797139 - test-report-utilities failure after 10-march in travis • Bug 797419 - equity-statement unrealized-gain calculator uses weighted-average • Bug 797481 - crash on close of unsaved tabs by pressing [X] • Bug 797522 - Focus after reconcile jumps to a different account • Bug 797536 - cmake errors out because it cannot find GncPkgConfig (cmake 3.5.2) • Bug 797540 - Mapping of aqbanking accounts to gnucash accounts doesn't work • Bug 797546 - Autocomplete not updated when account names changed • Bug 797548 - multicolumn income statement: some closing entries are not ignored when within reporting period • Bug 797549 - Reconcile window shows S_tatement Date rather than Statement Date • Bug 797550 - Crash when changing register tab position • Bug 797551 - Budget totals line missing in 3.8 Reinstate Income/Expense/Transfer/Total, but rename to: • Inflow from Income • Outflow to Expense • Outflow to Asset/Equity/Liability • Remaining to Budget • Bug 797566 - Crash on use of context menu in importer • Bug 797569 - Swedish account templates not accessible • Bug 797570 - Unable to import vendors. In the import of Customer/Vendor or Bill/Invoice, the dialog that lists rows that were not imported shows a scrollable view of only four rows. • Bug 797572 - Customer Report (beta): "Period Totals" includes total debit and credits outside the current period Previously Credits was rendered before Debits. Change to formal accounting convention. Can swap to informal headers if set by global preference. • Bug 797573 - Incorrect value of securities in the Asset Chart • Bug 797576 - xaccAccountOrder shouldn't sort account codes as base-36 • Bug 797584 - New-owner - bill amount field links to wrong account • Bug 797588 - Gnucash segfaults when using mysql backend with empty password • Bug 797591 - multiperiod b/s and PnL reports: add style sheet 'easy' • Bug 797609 - Backtraces for eguile report errors strips wrong part of stack • Bug 797613 - Due Invoices Reminder shows Job Name instead of Company Name • Bug 797624 - At some point Vietnam Dong seemed to drop xu (decimals) • Bug 797631 - Superfluous account selection dialog on first online retrieval The online id, which is needed to find a GnuCash account for a transaction or the balance retrieved from an online account, is already assigned to each matched GnuCash account within the Online Banking Setup tool. The online id is removed from the GnuCash account if it is no longer matched with an AqBanking account. • Bug 797636 - Incorrect Online account matches cannot be deleted A push button with text "Delete selected matches" is added to the "Match Online accounts with GnuCash accounts" page of the "Online Banking Setup" tool. Additionally, the underlying tree view is set to multiple selection mode from single selection mode. Pushing the button will remove the matched GnuCash account from all selected AqBanking (Online) accounts.
Re: [GNC] Stock Entry Issue with Version 3.8
> On Mar 25, 2020, at 11:21 AM, Dr. Timothy B. Jones > wrote: > > Greetings: > > On 12/13 I entered a stock trade on a new stock added to the database without > incident. On 12/31 I upgraded to Version 3.8Windows Version. Today I > have been trying to enter additional buys over the past two months and the > software is adding a decimal to my shares (no matter how I enter) calculating > the correct price, but since it changes the share decimal, it calculates the > wrong total and share balance. I have tried it every possible way and no > matter what...the software changes the share decimal incorrectly and gives me > an incorrect entry. Here is a screen shot: > Note...the system forced calculation is incorrect. It was > entered 10.0 shares at a cost of $915. No matter which variable I leave off > I get this result and if I enter all three I get the error that the math is > wrong, which variable would I like to have calculated. Errplease > help! Sounds like you have automatic decimal turned on in Preferences>General. If you have the default 2 places then 100 turns into 1.00. 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.
Re: [GNC] gnucash v.3.8 Reconciliation
> On Mar 21, 2020, at 6:35 PM, Alan Auerbach wrote: > > I just started using gnucash. My reconciliations are working properly, but > the report is peculiar. My latest reconciliation of a bank account is for > the period 02/15/2020 - 03/18/2020. The header shows those dates. However, > there are entries in the report that pre-date 02/15/2020 and so the totals > are incorrect. (I do not know if you will be able to see an image so I have > reproduced the report as text and as an image: > > > > From 02/15/2020 to 03/18/2020 > > > > Date Reconciled DateNum Description Account > Funds In Funds Out > > Reconciled > > 01/22/202002/17/2020DebitCapitalOneMLA - First > Bank Checking $112.98 > > 01/28/202002/17/2020DebitUS Bank MLA - First > Bank Checking $336.97 > > 01/29/202002/17/2020DEP Douglas Dieker - HonorHealth > MLA - First Bank Checking $3,108.42 > > 02/03/202002/17/2020DEP Social Security Administration > MLA - First Bank Checking $795.00 > > 02/04/202002/17/2020Marcie Auerbach > MLA - First Bank Checking $1,000.00 > > 02/05/202002/17/2020DebitNormandie Village, LLC MLA - > First Bank Checking $1,410.77 > > 02/05/202002/17/2020DebitSynchrony Bank/Amazon > MLA - First Bank Checking $135.75 > > 02/09/202002/17/2020DebitBarclaycard 1941 MLA > - First Bank Checking $189.61 > > 02/12/202002/17/2020DebitBarclaycard 9209 MLA > - First Bank Checking $196.16 > > 02/14/202002/17/2020Marcie Auerbach > MLA - First Bank Checking $750.00 > > 02/14/202002/17/2020First Bank MLA - > First Bank Checking $0.20 > > 02/17/202003/17/2020DebitDesert Schools Credit Union > VISA MLA - First Bank Checking $81.30 > > 02/28/202003/17/2020DebitUS Bank MLA - First > Bank Checking $226.88 > > 03/02/202003/17/2020DebitDiscover Card MLA - First > Bank Checking $70.68 > > 03/02/202003/17/2020DebitMerrick Bank MLA - First > Bank Checking $151.08 > > 03/03/202003/17/2020DEP Social Security Administration > MLA - First Bank Checking $795.00 > > 03/05/202003/17/2020TXFRMarcie Auerbach MLA - > First Bank Checking $1,000.00 > > 03/05/202003/17/2020DebitSynchrony Bank/Amazon > MLA - First Bank Checking $155.23 > > 03/06/202003/17/2020DebitNormandie Village, LLC MLA - > First Bank Checking $1,410.77 > > 03/09/202003/17/2020DebitBarclaycard 1941 MLA > - First Bank Checking $187.52 > > 03/12/202003/17/2020Marcie Auerbach > MLA - First Bank Checking $700.00 > > 03/12/202003/17/2020Barclaycard 9209 > MLA - First Bank Checking $145.00 > > 03/13/202003/17/2020TXFRMarcie Auerbach MLA - > First Bank Checking $125.00 > > 03/16/202003/17/2020DebitCapitalOneMLA - First > Bank Checking $117.63 > > 03/17/202003/17/2020DebitDesert Schools Credit Union > VISA 8206 MLA - First Bank Checking $80.08 > > 03/18/202003/17/2020First Bank MLA - > First Bank Checking $0.14 > > Total For Reconciled $4,698.76 $8,583.41 > > Grand Total $4,698.76 $8,583.41 > > > > > > > > All the entries in the register have a "y" in the "R" column. There are no > entries after 03/18/2020. The date range applies to the reconcile date rather than the posted date. 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.
Re: [GNC] Canceling QIF Import Erases ALL Transactions
> On Mar 21, 2020, at 12:53 AM, Eric H. Bowen via gnucash-user > wrote: > > Yesterday I ran into this...I was attempting a .QIF import of transactions > from my credit card company. The import seemed to progress normally, up until > the "Match Transactions" stage. When it got there, every single one of the > transactions which I had entered over the past 2+ years appeared in the list. > I hit the cancel button in the requester, got the "busy" icon...and when > Gnucash resumed, about ten minutes later, every one of my transactions in > every account had vanished (with the sole exceptions of customer invoices and > vendor bills)! > > I did have a fairly recent backup file available, so I restored to that and > tried the import again. The same thing happened a second time. > > My NAS keeps track of file history and automatically saves the most recent > versions every twenty minutes or so, so I do have versions from before and > after the failed import saved (to a new file under a new name) as well as all > of my log files. At the time of the import I was running Build ID: > 3.8b+(2019-12-29) on Ubuntu 18.04.4 LTS in a homebuilt machine with AMD > FX-4100 CPU, 8 GB RAM, and an ASUS M5A88-M motherboard and using the SQLite3 > backend. > > I opened a Bugzilla account and reported this (Bug 797651), but as > reconstructing this may mean sharing my personal financial data I restricted > the view access to the developer list. I have reconstructed my working > account file from my backup, so there's been no loss of critical data. I'm > sharing this for visibility and to ask if there is any additional information > I should provide in the bug report to facilitate a permanent resolution to > this problem. Thanks for any adviceEric. Chris has already responded to you on the bug report and will ask there for any additional information he needs. A general note: I wouldn't trust the view access settings to protect anything, it's at best security-by-obscurity. If one of us decides he needs to look at your book he'll provide a direct email address to send it to. 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.
Re: [GNC] GnuCash 3.8 crash
> On Mar 19, 2020, at 12:42 PM, John Ralls wrote: > > > >> On Mar 19, 2020, at 12:01 PM, Michael Hendry >> wrote: >> >>> On 19 Mar 2020, at 18:53, John Ralls wrote: >>> >>> Michael, >>> >>> Thanks, probably the same thing just a different chunk of freed memory got >>> overwritten so the actual crash happened in a different place. >>> >>> Regards, >>> John Ralls >> >> OK - any further useful action for me to take on this? > > Not at the moment. Michael, Found, fixed, and pushed. Thanks for reporting it. 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.
Re: [GNC] GnuCash 3.8 crash
> On Mar 19, 2020, at 12:01 PM, Michael Hendry wrote: > >> On 19 Mar 2020, at 18:53, John Ralls wrote: >> >> Michael, >> >> Thanks, probably the same thing just a different chunk of freed memory got >> overwritten so the actual crash happened in a different place. >> >> Regards, >> John Ralls > > OK - any further useful action for me to take on this? Not at the moment. 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.
Re: [GNC] GnuCash 3.8 crash
Michael, Thanks, probably the same thing just a different chunk of freed memory got overwritten so the actual crash happened in a different place. Regards, John Ralls > On Mar 19, 2020, at 11:47 AM, Michael Hendry wrote: > >> On 19 Mar 2020, at 18:33, John Ralls wrote: >> >> >> >>> On Mar 19, 2020, at 11:26 AM, Michael Hendry >>> wrote: >>> >>> PS I’ve confirmed that the crash is reproducible, albeit with some >>> differences in the crash report. >>> When I re-opened the second file I found that the Separator Character was >>> “das” (not blank as before). I was able to switch back to “colon” again. >> >> Michael, >> >> The first one looks like a use-after-free. What's the difference in the >> crash report on the second one? >> >> Regards, >> John Ralls > > Here’s a link to a screenshot of a MacVim Split-Diff on the beginnings of the > two crash logs: > > https://www.dropbox.com/s/ucie1hoiuo76p95/Screenshot%202020-03-19%2018.45.53.png?dl=0 > > Michael ___ 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] GnuCash 3.8 crash
> On Mar 19, 2020, at 11:26 AM, Michael Hendry wrote: > > PS I’ve confirmed that the crash is reproducible, albeit with some > differences in the crash report. > When I re-opened the second file I found that the Separator Character was > “das” (not blank as before). I was able to switch back to “colon” again. Michael, The first one looks like a use-after-free. What's the difference in the crash report on the second one? 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.
Re: [GNC] [GNC-dev] PDF Reports
> On Mar 19, 2020, at 8:59 AM, Adrien Monteleone > wrote: > > I still don’t understand why GnuCash has its own print (or file) dialog > instead of just using a system dialog. I’m sure there are past threads about > it and it was explained, I just don’t recall at the moment what the reason > is. Perhaps it has something to do with not being a native app. Got it in one. We barely have the resources to maintain a single GUI framework and it's Gtk so all dialogs are from Gtk. 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.
Re: [GNC] AQBanking OFX DirectConnect
Chris, I guess in your case it was having OFXHEADER:100 and VERSION:102. I think that's all that changed between your last failed run and the successful one. Regards, John Ralls > On Mar 18, 2020, at 5:21 PM, Chris Graves wrote: > > John, > > You are probably right, but here is an excerpt from the working ofx.log file, > so I guess I'm not sure what enabled this progress: > Sending: > - > OFXHEADER:100 > DATA:OFXSGML > VERSION:102 > SECURITY:NONE > ENCODING:USASCII > CHARSET:1252 > COMPRESSION:NONE > OLDFILEUID:NONE > NEWFILEUID:20200318152018.000 > > > > > 20200318152011.000 > xxx > xx > ENG > > KINECTA > 322278073 > > > On Wed, Mar 18, 2020 at 5:10 PM John Ralls wrote: > Chris, > > You have it backwards: Martin changed LANG -> LANGUAGE because that's what > AQB5 used. > > However, I just tested on a bank account at USAA and that worked, except that > it crashed GnuCash when trying to process the new transactions. That's > probably not AQBanking's doing and I'll look into that separately. > > Next I'll try Martin's command-line test. > > Regards, > John Ralls > > > > On Mar 18, 2020, at 4:57 PM, Chris Graves wrote: > > > > John, > > > > In your ofx.log file it still says LANGUAGE instead of LANG. Mine says > > LANG, which is what Martin just fixed. > > > > On Wed, Mar 18, 2020 at 4:54 PM John Ralls wrote: > > Progress indeed, though still not enough for USAA. :-( > > > > Regards, > > John Ralls > > > > > > > On Mar 18, 2020, at 4:48 PM, Chris Graves wrote: > > > > > > Wow! making serious progress now. I was requesting transactions from my > > > checking account. Looking at the ofx.log file, they were returned!!! > > > > > > However the import process indicated that there were no transactions to > > > be imported. > > > > > > On Wed, Mar 18, 2020 at 4:32 PM Martin Preuss wrote: > > > Hi, > > > > > > I just checked in another change... While comparing your logs I found > > > that aqb6 uses "LANG" while aqb5 used the correct name "LANGUAGE". > > > > > > Also, added "CLTCOOKIE" (was set by aqb5 but missing in aqb6). > > > > > > Also, I noticed that aqb5 included "BANKID" which you log from aqb6 > > > didn't contain that line... > > > > > > However, I think the unexpected element "LANG" (instead of "LANGUAGE") > > > was what made the server reject the request due to syntax error... > > > > > > Fixed in git. > > > > > > > > > Regards > > > Martin > > > > > > > > > Am 19.03.20 um 00:26 schrieb John Ralls: > > > > That's what mine says: > > > > char flags="forceSsl3", "sendShortDate" > > > > char bankName="USAA Federal Savings Bank" > > > > char org="USAA" > > > > char fid="24591" > > > > char serverAddr="https%3A%2F%2Fservice2.usaa.com%2Fofx%2FOFXServlet" > > > > char appId="QWIN" > > > > char appVer="2300" > > > > char headerVer="102" > > > > int httpVMajor="0" > > > > int httpVMinor="0" > > > > } > > > > > > > > Regards, > > > > John Ralls > > > > > > > > > > > >> On Mar 18, 2020, at 4:15 PM, Martin Preuss wrote: > > > >> > > > >> Hmm, maybe the server is picky about the HTTP version? Some servers > > > >> are... That can currently only be changed directly in the configuration > > > >> file: > > > >> > > > >> $HOME/.aqbanking/settings6/users/*.conf > > > >> > > > >> Some servers only accept httpVMinor="0"... > > > >> > > > >> > > > >> Regards > > > >> Martin > > > >> > > > >> > > > >> > > > >> Am 18.03.20 um 23:20 schrieb John Ralls: > > > >>> Sigh, that's not it either: > > > >>> Sending: > > > >>> - > > > >>> OFXHEADER:100 > > > >>> DATA:OFXSGML > > > >>> VERSION:102 > > > >>> SECURITY:NONE > > > >>> ENCODING:USASCII > > > >>> CHARSET:1252 > > > >>> COMPRESSION:NONE > > > >>> OLDFILEUID:NONE > > > >>> NEWFILEUID:20200318151247.000 > > > >> [...] > > > >> > > > >> -- > > > >> "Things are only impossible until they're not" > > > > > > > > > > > > > -- > > > "Things are only impossible until they're not" > > > ___ 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] AQBanking OFX DirectConnect
That did it! Now to that crash. Regards, John Ralls > On Mar 18, 2020, at 5:06 PM, Martin Preuss wrote: > > So the only remaining difference is the line "bankid" which wasn't in > the aqb5 log. > > Just applied a change to the git repository to change that... > > > Regards > Martin > > > Am 19.03.20 um 00:53 schrieb John Ralls: >> Nope: >> Connected. >> Sending message... >> Message sent. >> Waiting for response... >> Receiving response... >> HTTP-Status: 400 (Bad Request) >> Unlocking customer "8" >> >> Sending: >> - >> OFXHEADER:100 >> DATA:OFXSGML >> VERSION:102 >> SECURITY:NONE >> ENCODING:USASCII >> CHARSET:1252 >> COMPRESSION:NONE >> OLDFILEUID:NONE >> NEWFILEUID:20200318164314.000 >> >> >> >> >> 20200318164310 >> >> >> ENG >> >> USAA >> 24591 >> >> QWIN >> 2300 >> >> >> >> >> 20200318164314 >> 1 >> >> >> 24591 >> XX >> >> >> 2020030900 >> 2020031800 >> Y >> >> >> >> >> >> >> Taking out the \r\n's doesn't help either. >> >> Regards, >> John Ralls >> >>> On Mar 18, 2020, at 4:32 PM, Martin Preuss wrote: >>> >>> Hi, >>> >>> I just checked in another change... While comparing your logs I found >>> that aqb6 uses "LANG" while aqb5 used the correct name "LANGUAGE". >>> >>> Also, added "CLTCOOKIE" (was set by aqb5 but missing in aqb6). >>> >>> Also, I noticed that aqb5 included "BANKID" which you log from aqb6 >>> didn't contain that line... >>> >>> However, I think the unexpected element "LANG" (instead of "LANGUAGE") >>> was what made the server reject the request due to syntax error... >>> >>> Fixed in git. >>> >> > > > -- > "Things are only impossible until they're not" ___ 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] AQBanking OFX DirectConnect
Chris, You have it backwards: Martin changed LANG -> LANGUAGE because that's what AQB5 used. However, I just tested on a bank account at USAA and that worked, except that it crashed GnuCash when trying to process the new transactions. That's probably not AQBanking's doing and I'll look into that separately. Next I'll try Martin's command-line test. Regards, John Ralls > On Mar 18, 2020, at 4:57 PM, Chris Graves wrote: > > John, > > In your ofx.log file it still says LANGUAGE instead of LANG. Mine says LANG, > which is what Martin just fixed. > > On Wed, Mar 18, 2020 at 4:54 PM John Ralls wrote: > Progress indeed, though still not enough for USAA. :-( > > Regards, > John Ralls > > > > On Mar 18, 2020, at 4:48 PM, Chris Graves wrote: > > > > Wow! making serious progress now. I was requesting transactions from my > > checking account. Looking at the ofx.log file, they were returned!!! > > > > However the import process indicated that there were no transactions to be > > imported. > > > > On Wed, Mar 18, 2020 at 4:32 PM Martin Preuss wrote: > > Hi, > > > > I just checked in another change... While comparing your logs I found > > that aqb6 uses "LANG" while aqb5 used the correct name "LANGUAGE". > > > > Also, added "CLTCOOKIE" (was set by aqb5 but missing in aqb6). > > > > Also, I noticed that aqb5 included "BANKID" which you log from aqb6 > > didn't contain that line... > > > > However, I think the unexpected element "LANG" (instead of "LANGUAGE") > > was what made the server reject the request due to syntax error... > > > > Fixed in git. > > > > > > Regards > > Martin > > > > > > Am 19.03.20 um 00:26 schrieb John Ralls: > > > That's what mine says: > > > char flags="forceSsl3", "sendShortDate" > > > char bankName="USAA Federal Savings Bank" > > > char org="USAA" > > > char fid="24591" > > > char serverAddr="https%3A%2F%2Fservice2.usaa.com%2Fofx%2FOFXServlet" > > > char appId="QWIN" > > > char appVer="2300" > > > char headerVer="102" > > > int httpVMajor="0" > > > int httpVMinor="0" > > > } > > > > > > Regards, > > > John Ralls > > > > > > > > >> On Mar 18, 2020, at 4:15 PM, Martin Preuss wrote: > > >> > > >> Hmm, maybe the server is picky about the HTTP version? Some servers > > >> are... That can currently only be changed directly in the configuration > > >> file: > > >> > > >> $HOME/.aqbanking/settings6/users/*.conf > > >> > > >> Some servers only accept httpVMinor="0"... > > >> > > >> > > >> Regards > > >> Martin > > >> > > >> > > >> > > >> Am 18.03.20 um 23:20 schrieb John Ralls: > > >>> Sigh, that's not it either: > > >>> Sending: > > >>> - > > >>> OFXHEADER:100 > > >>> DATA:OFXSGML > > >>> VERSION:102 > > >>> SECURITY:NONE > > >>> ENCODING:USASCII > > >>> CHARSET:1252 > > >>> COMPRESSION:NONE > > >>> OLDFILEUID:NONE > > >>> NEWFILEUID:20200318151247.000 > > >> [...] > > >> > > >> -- > > >> "Things are only impossible until they're not" > > > > > > > > > -- > > "Things are only impossible until they're not" > ___ 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] AQBanking OFX DirectConnect
Progress indeed, though still not enough for USAA. :-( Regards, John Ralls > On Mar 18, 2020, at 4:48 PM, Chris Graves wrote: > > Wow! making serious progress now. I was requesting transactions from my > checking account. Looking at the ofx.log file, they were returned!!! > > However the import process indicated that there were no transactions to be > imported. > > On Wed, Mar 18, 2020 at 4:32 PM Martin Preuss wrote: > Hi, > > I just checked in another change... While comparing your logs I found > that aqb6 uses "LANG" while aqb5 used the correct name "LANGUAGE". > > Also, added "CLTCOOKIE" (was set by aqb5 but missing in aqb6). > > Also, I noticed that aqb5 included "BANKID" which you log from aqb6 > didn't contain that line... > > However, I think the unexpected element "LANG" (instead of "LANGUAGE") > was what made the server reject the request due to syntax error... > > Fixed in git. > > > Regards > Martin > > > Am 19.03.20 um 00:26 schrieb John Ralls: > > That's what mine says: > > char flags="forceSsl3", "sendShortDate" > > char bankName="USAA Federal Savings Bank" > > char org="USAA" > > char fid="24591" > > char serverAddr="https%3A%2F%2Fservice2.usaa.com%2Fofx%2FOFXServlet" > > char appId="QWIN" > > char appVer="2300" > > char headerVer="102" > > int httpVMajor="0" > > int httpVMinor="0" > > } > > > > Regards, > > John Ralls > > > > > >> On Mar 18, 2020, at 4:15 PM, Martin Preuss wrote: > >> > >> Hmm, maybe the server is picky about the HTTP version? Some servers > >> are... That can currently only be changed directly in the configuration > >> file: > >> > >> $HOME/.aqbanking/settings6/users/*.conf > >> > >> Some servers only accept httpVMinor="0"... > >> > >> > >> Regards > >> Martin > >> > >> > >> > >> Am 18.03.20 um 23:20 schrieb John Ralls: > >>> Sigh, that's not it either: > >>> Sending: > >>> - > >>> OFXHEADER:100 > >>> DATA:OFXSGML > >>> VERSION:102 > >>> SECURITY:NONE > >>> ENCODING:USASCII > >>> CHARSET:1252 > >>> COMPRESSION:NONE > >>> OLDFILEUID:NONE > >>> NEWFILEUID:20200318151247.000 > >> [...] > >> > >> -- > >> "Things are only impossible until they're not" > > > > > -- > "Things are only impossible until they're not" ___ 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] AQBanking OFX DirectConnect
Nope: Connected. Sending message... Message sent. Waiting for response... Receiving response... HTTP-Status: 400 (Bad Request) Unlocking customer "8" Sending: - OFXHEADER:100 DATA:OFXSGML VERSION:102 SECURITY:NONE ENCODING:USASCII CHARSET:1252 COMPRESSION:NONE OLDFILEUID:NONE NEWFILEUID:20200318164314.000 20200318164310 ENG USAA 24591 QWIN 2300 20200318164314 1 24591 XX 2020030900 2020031800 Y Taking out the \r\n's doesn't help either. Regards, John Ralls > On Mar 18, 2020, at 4:32 PM, Martin Preuss wrote: > > Hi, > > I just checked in another change... While comparing your logs I found > that aqb6 uses "LANG" while aqb5 used the correct name "LANGUAGE". > > Also, added "CLTCOOKIE" (was set by aqb5 but missing in aqb6). > > Also, I noticed that aqb5 included "BANKID" which you log from aqb6 > didn't contain that line... > > However, I think the unexpected element "LANG" (instead of "LANGUAGE") > was what made the server reject the request due to syntax error... > > Fixed in git. > ___ 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] AQBanking OFX DirectConnect
I did --- a/src/libs/plugins/backends/aqofxconnect/v1/r_statements.c +++ b/src/libs/plugins/backends/aqofxconnect/v1/r_statements.c @@ -77,7 +77,7 @@ int AO_V1_RequestStatements(AB_PROVIDER *pro, AB_USER *u, AB_ACCOUNT *a, AB_TRAN } GWEN_XMLNode_free(xmlRoot); -#if 0 +#if 1 DBG_ERROR(AQOFXCONNECT_LOGDOMAIN, "OFX request:"); fprintf(stderr, "%s\n", GWEN_Buffer_GetStart(bufRequest)); GWEN_Text_LogString(GWEN_Buffer_GetStart(bufRequest), @@ -99,7 +99,7 @@ int AO_V1_RequestStatements(AB_PROVIDER *pro, AB_USER *u, AB_ACCOUNT *a, AB_TRAN GWEN_Buffer_free(bufRequest); -#if 0 +#if 1 DBG_ERROR(AQOFXCONNECT_LOGDOMAIN, "OFX response:"); GWEN_Text_LogString(GWEN_Buffer_GetStart(bufResponse), GWEN_Buffer_GetUsedBytes(bufResponse), to get some more out of the logs. That inserted the exact same string as in ofx.log, which is good, but with GWEN_LOGLEVEL=debug the next bit of the log is * 15:22:21 ERROR io_network.c: 165: Saving OFX log to "/tmp/ofx.log" ... 7:2020/03/18 15-22-21:gwen(83151):/Users/john/Development/Gnucash-Build/Gnucash-3/src/gwenhywfar-5.2.0/src/parser/urlfns.c: 123: Server: [service2.usaa.com] 7:2020/03/18 15-22-21:gwen(83151):/Users/john/Development/Gnucash-Build/Gnucash-3/src/gwenhywfar-5.2.0/src/parser/urlfns.c: 176: Path: [/ofx/OFXServlet] 7:2020/03/18 15-22-21:gwen(83151):/Users/john/Development/Gnucash-Build/Gnucash-3/src/gwenhywfar-5.2.0/src/parser/urlfns.c: 123: Server: [service2.usaa.com] 7:2020/03/18 15-22-21:gwen(83151):/Users/john/Development/Gnucash-Build/Gnucash-3/src/gwenhywfar-5.2.0/src/parser/urlfns.c: 176: Path: [/ofx/OFXServlet] 7:2020/03/18 15-22-21:gwen(83151):String size is 31 7:2020/03/18 15-22-21:gwen(83151):: 50 4f 53 54 20 2f 6f 66 78 2f 4f 46 58 53 65 72 POST /ofx/OFXSer 7:2020/03/18 15-22-21:gwen(83151):0010: 76 6c 65 74 20 48 54 54 50 2f 31 2e 30 0d 0avlet HTTP/1.0.. 7:2020/03/18 15-22-21:gwen(83151):String size is 159 7:2020/03/18 15-22-21:gwen(83151):: 48 6f 73 74 3a 73 65 72 76 69 63 65 32 2e 75 73 Host:service2.us 7:2020/03/18 15-22-21:gwen(83151):0010: 61 61 2e 63 6f 6d 0d 0a 43 6f 6e 6e 65 63 74 69 aa.com..Connecti 7:2020/03/18 15-22-21:gwen(83151):0020: 6f 6e 3a 63 6c 6f 73 65 0d 0a 50 72 61 67 6d 61 on:close..Pragma 7:2020/03/18 15-22-21:gwen(83151):0030: 3a 6e 6f 2d 63 61 63 68 65 0d 0a 43 61 63 68 65 :no-cache..Cache 7:2020/03/18 15-22-21:gwen(83151):0040: 2d 63 6f 6e 74 72 6f 6c 3a 6e 6f 20 63 61 63 68 -control:no cach 7:2020/03/18 15-22-21:gwen(83151):0050: 65 0d 0a 43 6f 6e 74 65 6e 74 2d 74 79 70 65 3a e..Content-type: 7:2020/03/18 15-22-21:gwen(83151):0060: 61 70 70 6c 69 63 61 74 69 6f 6e 2f 78 2d 6f 66 application/x-of 7:2020/03/18 15-22-21:gwen(83151):0070: 78 0d 0a 55 73 65 72 2d 41 67 65 6e 74 3a 41 71 x..User-Agent:Aq 7:2020/03/18 15-22-21:gwen(83151):0080: 42 61 6e 6b 69 6e 67 0d 0a 43 6f 6e 74 65 6e 74 Banking..Content 7:2020/03/18 15-22-21:gwen(83151):0090: 2d 6c 65 6e 67 74 68 3a 35 37 35 0d 0a 0d 0a-length:575 7:2020/03/18 15-22-21:gwen(83151):String size is 25 7:2020/03/18 15-22-21:gwen(83151):: 48 54 54 50 2f 31 2e 30 20 34 30 30 20 42 61 64 HTTP/1.0 400 Bad 7:2020/03/18 15-22-21:gwen(83151):0010: 20 52 65 71 75 65 73 74 00 Request. : Should there be two \n\r after the length header and is it supposed to log the request content? Unfortunately Gwen4 doesn't emit anything useful for comparison. Regards, John Ralls > On Mar 18, 2020, at 3:20 PM, John Ralls wrote: > > Sigh, that's not it either: > Sending: > - > OFXHEADER:100 > DATA:OFXSGML > VERSION:102 > SECURITY:NONE > ENCODING:USASCII > CHARSET:1252 > COMPRESSION:NONE > OLDFILEUID:NONE > NEWFILEUID:20200318151247.000 > > 20200318151243XXENGUSAA24591QWIN23002020031815124724591XXX20200309002020031800Y > > and a 400. > > Regards, > John Ralls > > >> On Mar 18, 2020, at 3:08 PM, Martin Preuss wrote: >> >> Hi, >> >> hmm, so no linebreaks... >> >> Could either of you please try with the following lines commented out in >> v1/n_toofx.c: >> - 105: if (hasSubTags) >> - 106: GWEN_Buffer_AppendString(buf, "\r\n"); >> - 128: GWEN_Buffer_AppendString(buf, "\r\n"); >> >> Will be back in a few mins, have to watch an episode of "Bull" on my >> wifes request... ;-) >> >> >> Regards >> Martin >> >> >> Am 18.03.20 um 23:02 schrieb John Ralls: >>> Remember, the working ofx from AQB5 is >>> Sending: >>> - >>> OFXHEADER:100 >>> DATA:OFXSGML >>> VERSION:102 >>> SECURITY:NONE >>> ENCODING:USASCII >>> CHARSET:125
Re: [GNC] AQBanking OFX DirectConnect
That's what mine says:
char flags="forceSsl3", "sendShortDate"
char bankName="USAA Federal Savings Bank"
char org="USAA"
char fid="24591"
char serverAddr="https%3A%2F%2Fservice2.usaa.com%2Fofx%2FOFXServlet"
char appId="QWIN"
char appVer="2300"
char headerVer="102"
int httpVMajor="0"
int httpVMinor="0"
}
Regards,
John Ralls
> On Mar 18, 2020, at 4:15 PM, Martin Preuss wrote:
>
> Hmm, maybe the server is picky about the HTTP version? Some servers
> are... That can currently only be changed directly in the configuration
> file:
>
> $HOME/.aqbanking/settings6/users/*.conf
>
> Some servers only accept httpVMinor="0"...
>
>
> Regards
> Martin
>
>
>
> Am 18.03.20 um 23:20 schrieb John Ralls:
>> Sigh, that's not it either:
>> Sending:
>> -
>> OFXHEADER:100
>> DATA:OFXSGML
>> VERSION:102
>> SECURITY:NONE
>> ENCODING:USASCII
>> CHARSET:1252
>> COMPRESSION:NONE
>> OLDFILEUID:NONE
>> NEWFILEUID:20200318151247.000
> [...]
>
> --
> "Things are only impossible until they're not"
___
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] AQBanking OFX DirectConnect
Sigh, that's not it either: Sending: - OFXHEADER:100 DATA:OFXSGML VERSION:102 SECURITY:NONE ENCODING:USASCII CHARSET:1252 COMPRESSION:NONE OLDFILEUID:NONE NEWFILEUID:20200318151247.000 2020031815124318015524376ENGUSAA24591QWIN23002020031815124724591427082906539504520200309002020031800Y and a 400. Regards, John Ralls > On Mar 18, 2020, at 3:08 PM, Martin Preuss wrote: > > Hi, > > hmm, so no linebreaks... > > Could either of you please try with the following lines commented out in > v1/n_toofx.c: > - 105: if (hasSubTags) > - 106: GWEN_Buffer_AppendString(buf, "\r\n"); > - 128: GWEN_Buffer_AppendString(buf, "\r\n"); > > Will be back in a few mins, have to watch an episode of "Bull" on my > wifes request... ;-) > > > Regards > Martin > > > Am 18.03.20 um 23:02 schrieb John Ralls: >> Remember, the working ofx from AQB5 is >> Sending: >> - >> OFXHEADER:100 >> DATA:OFXSGML >> VERSION:102 >> SECURITY:NONE >> ENCODING:USASCII >> CHARSET:1252 >> COMPRESSION:NONE >> OLDFILEUID:NONE >> NEWFILEUID:20200315112517.000 >> >> 20200315112517 >> >> ENGUSAA24591QWIN2300202003151125171202003140020200315112517Y >> >> >> Regards, >> John Ralls >> >>> On Mar 18, 2020, at 2:54 PM, Martin Preuss wrote: >>> >>> Hi, >>> >>> please see my other mail (latest GIT). >>> >>> Maybe "103" then (I heard of some cases where "103" was necessary)? Or >>> perhaps "160"? >>> >>> Will fix the gui btw... >>> >>> >>> Regards >>> Martin >>> >>> Am 18.03.20 um 22:50 schrieb Chris Graves: >>>> Hi Martin, >>>> >>>> The GUI wouldn't let me leave that field blank, so I manually deleted >>>> the entry from the .conf file. Running again, it did use the defaults >>>> that you specified. However, still the http 400 error and no response. >>>> >>>> Sending: >>>> - >>>> OFXHEADER:100 >>>> DATA:OFXSGML >>>> VERSION:102 >>>> SECURITY:NONE >>>> ENCODING:USASCII >>>> CHARSET:1252 >>>> COMPRESSION:NONE >>>> OLDFILEUID:NONE >>>> NEWFILEUID:20200318144035.000 >>>> >>>> On Wed, Mar 18, 2020 at 2:34 PM Martin Preuss >>> <mailto:mar...@aqbanking.de>> wrote: >>>> >>>> Hi, >>>> >>>> not ATM, but that can be arranged. However, how about leaving that field >>>> empty in the settings dialog? That should default to 100 for OFXHEADER >>>> and 102 for VERSION (for - ahem - historic reasons, I'm sure I had >>>> good^H^H^H reasons for those mixed defaults... :-}) >>>> >>>> Regards >>>> Martin >>>> >>>> >>>> Am 18.03.20 um 22:26 schrieb Chris Graves: >>>>> Nice! I see that the change has been made, but still receive the HTTP >>>>> 400 error. >>>>> >>>>> In the AQB5 ofx.log file for a successful case, I see >>>>> OFXHEADER:100 >>>>> VERSION:102 >>>>> >>>>> In the AQB6 file, I see >>>>> OFXHEADER:102 >>>>> VERSION:102 >>>>> >>>>> Not sure if this could be the problem. Is there a way to set >>>> OFXHEADER >>>>> and VERSION independently? >>>>> >>>>> >>>>> On Wed, Mar 18, 2020 at 2:02 PM Martin Preuss >>> <mailto:mar...@aqbanking.de> >>>>> <mailto:mar...@aqbanking.de <mailto:mar...@aqbanking.de>>> wrote: >>>>> >>>>> Hi, >>>>> >>>>> you can change the header manually to 102/103 in the >>>> homebanking setup >>>>> dialog (select user, edit user, switch to app settings and type-in >>>>> header version 102). >>>>> >>>>> Regards >>>>> Martin >>>>> >>>>> >>>>> Am 18.03.20 um 21:57 schrieb Chris Graves: >>>>>> Hi Martin, >>>>>> >>>>>> Looking better! However, to my knowledge, my bank only >>>> suppor
Re: [GNC] AQBanking OFX DirectConnect
The only difference I see now in the ofx.logs is the newlines, and I still haven't figured out if they're correctly escaped in the http request. Regards, John Ralls > On Mar 18, 2020, at 2:59 PM, Martin Preuss wrote: > > Hi again, > > with the latest changes: Are there any probably important differences in > the generated OFX request compared to Aqb5's output (except dates etc.)? > > Regards > Martin > > > Am 18.03.20 um 22:50 schrieb Chris Graves: >> Hi Martin, >> >> The GUI wouldn't let me leave that field blank, so I manually deleted >> the entry from the .conf file. Running again, it did use the defaults >> that you specified. However, still the http 400 error and no response. >> >> Sending: >> - >> OFXHEADER:100 >> DATA:OFXSGML >> VERSION:102 >> SECURITY:NONE >> ENCODING:USASCII >> CHARSET:1252 >> COMPRESSION:NONE >> OLDFILEUID:NONE >> NEWFILEUID:20200318144035.000 >> >> On Wed, Mar 18, 2020 at 2:34 PM Martin Preuss > <mailto:mar...@aqbanking.de>> wrote: >> >>Hi, >> >>not ATM, but that can be arranged. However, how about leaving that field >>empty in the settings dialog? That should default to 100 for OFXHEADER >>and 102 for VERSION (for - ahem - historic reasons, I'm sure I had >>good^H^H^H reasons for those mixed defaults... :-}) >> >>Regards >>Martin >> >> >>Am 18.03.20 um 22:26 schrieb Chris Graves: >>> Nice! I see that the change has been made, but still receive the HTTP >>> 400 error. >>> >>> In the AQB5 ofx.log file for a successful case, I see >>> OFXHEADER:100 >>> VERSION:102 >>> >>> In the AQB6 file, I see >>> OFXHEADER:102 >>> VERSION:102 >>> >>> Not sure if this could be the problem. Is there a way to set >>OFXHEADER >>> and VERSION independently? >>> >>> >>> On Wed, Mar 18, 2020 at 2:02 PM Martin Preuss ><mailto:mar...@aqbanking.de> >>> <mailto:mar...@aqbanking.de <mailto:mar...@aqbanking.de>>> wrote: >>> >>> Hi, >>> >>> you can change the header manually to 102/103 in the >>homebanking setup >>> dialog (select user, edit user, switch to app settings and type-in >>> header version 102). >>> >>> Regards >>> Martin >>> >>> >>> Am 18.03.20 um 21:57 schrieb Chris Graves: >>> > Hi Martin, >>> > >>> > Looking better! However, to my knowledge, my bank only >>supports OFX >>> > version 102 or 103. I had been using 102. >>> > >>> > ofx.log: >>> > Sending: >>> > - >>> > OFXHEADER:220 >>> > DATA:OFXSGML >>> > VERSION:220 >>> > SECURITY:NONE >>> > ENCODING:USASCII >>> > CHARSET:1252 >>> > COMPRESSION:NONE >>> > OLDFILEUID:NONE >>> > NEWFILEUID:20200318135033.000 >>> > >>> > >>> > >>> > >>> > 20200318135025.000 >>> > >>> > On Wed, Mar 18, 2020 at 1:32 PM Martin Preuss >>mailto:mar...@aqbanking.de> >>> <mailto:mar...@aqbanking.de <mailto:mar...@aqbanking.de>> >>> > <mailto:mar...@aqbanking.de <mailto:mar...@aqbanking.de> >><mailto:mar...@aqbanking.de <mailto:mar...@aqbanking.de>>>> wrote: >>> > >>> > Hi Chris, >>> > >>> > could you please test the latest GIT version? It should >>create >>> valid >>> > OFXv1 requests now, however, I can't test it completely >>since >>> I only >>> > have access to an OFXv2 server... >>> > >>> > >>> > Regards >>> > Martin >>> > >>> > >>> > Am 18.03.20 um 16:31 schrieb chris graves: >>> > > An additional bit of information from /tmp/ofx.log: >>> > > AQB5: >>> > > Sending: >>> > > - >>> > > OFXHEADER:100 >>> > > DATA:OFXSGML >>> > > VERSION:102 >>> > > SECURITY:NONE >>> > > ENCODING:USASCII >>> > > CHARSET:1252 >>> > > COMPRESSION:NONE >>> > > OLDFILEUID:NONE >>> > > NEWFILEUID:20200318081757.000 >>> > > >>> > > ... >>> > [...] >>> > >>> > >>> > -- >>> > "Things are only impossible until they're not" >>> > >>> >>> >>> -- >>> "Things are only impossible until they're not" >>> >> >> >>-- >>"Things are only impossible until they're not" >> > > > -- > "Things are only impossible until they're not" ___ 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] AQBanking OFX DirectConnect
Remember, the working ofx from AQB5 is Sending: - OFXHEADER:100 DATA:OFXSGML VERSION:102 SECURITY:NONE ENCODING:USASCII CHARSET:1252 COMPRESSION:NONE OLDFILEUID:NONE NEWFILEUID:20200315112517.000 20200315112517 ENGUSAA24591QWIN2300202003151125171202003140020200315112517Y Regards, John Ralls > On Mar 18, 2020, at 2:54 PM, Martin Preuss wrote: > > Hi, > > please see my other mail (latest GIT). > > Maybe "103" then (I heard of some cases where "103" was necessary)? Or > perhaps "160"? > > Will fix the gui btw... > > > Regards > Martin > > Am 18.03.20 um 22:50 schrieb Chris Graves: >> Hi Martin, >> >> The GUI wouldn't let me leave that field blank, so I manually deleted >> the entry from the .conf file. Running again, it did use the defaults >> that you specified. However, still the http 400 error and no response. >> >> Sending: >> - >> OFXHEADER:100 >> DATA:OFXSGML >> VERSION:102 >> SECURITY:NONE >> ENCODING:USASCII >> CHARSET:1252 >> COMPRESSION:NONE >> OLDFILEUID:NONE >> NEWFILEUID:20200318144035.000 >> >> On Wed, Mar 18, 2020 at 2:34 PM Martin Preuss > <mailto:mar...@aqbanking.de>> wrote: >> >>Hi, >> >>not ATM, but that can be arranged. However, how about leaving that field >>empty in the settings dialog? That should default to 100 for OFXHEADER >>and 102 for VERSION (for - ahem - historic reasons, I'm sure I had >>good^H^H^H reasons for those mixed defaults... :-}) >> >>Regards >>Martin >> >> >>Am 18.03.20 um 22:26 schrieb Chris Graves: >>> Nice! I see that the change has been made, but still receive the HTTP >>> 400 error. >>> >>> In the AQB5 ofx.log file for a successful case, I see >>> OFXHEADER:100 >>> VERSION:102 >>> >>> In the AQB6 file, I see >>> OFXHEADER:102 >>> VERSION:102 >>> >>> Not sure if this could be the problem. Is there a way to set >>OFXHEADER >>> and VERSION independently? >>> >>> >>> On Wed, Mar 18, 2020 at 2:02 PM Martin Preuss ><mailto:mar...@aqbanking.de> >>> <mailto:mar...@aqbanking.de <mailto:mar...@aqbanking.de>>> wrote: >>> >>> Hi, >>> >>> you can change the header manually to 102/103 in the >>homebanking setup >>> dialog (select user, edit user, switch to app settings and type-in >>> header version 102). >>> >>> Regards >>> Martin >>> >>> >>> Am 18.03.20 um 21:57 schrieb Chris Graves: >>> > Hi Martin, >>> > >>> > Looking better! However, to my knowledge, my bank only >>supports OFX >>> > version 102 or 103. I had been using 102. >>> > >>> > ofx.log: >>> > Sending: >>> > - >>> > OFXHEADER:220 >>> > DATA:OFXSGML >>> > VERSION:220 >>> > SECURITY:NONE >>> > ENCODING:USASCII >>> > CHARSET:1252 >>> > COMPRESSION:NONE >>> > OLDFILEUID:NONE >>> > NEWFILEUID:20200318135033.000 >>> > >>> > >>> > >>> > >>> > 20200318135025.000 >>> > >>> > On Wed, Mar 18, 2020 at 1:32 PM Martin Preuss >>mailto:mar...@aqbanking.de> >>> <mailto:mar...@aqbanking.de <mailto:mar...@aqbanking.de>> >>> > <mailto:mar...@aqbanking.de <mailto:mar...@aqbanking.de> >><mailto:mar...@aqbanking.de <mailto:mar...@aqbanking.de>>>> wrote: >>> > >>> > Hi Chris, >>> > >>> > could you please test the latest GIT version? It should >>create >>> valid >>> > OFXv1 requests now, however, I can't test it completely >>since >>> I only >>> > have access to an OFXv2 server... >>> > >>> > >>> > Regards >>> > Martin >>> > >>> > >>> > Am 18.03.20 um 16:31 schrieb chris graves: >>> >
Re: [GNC] AQBanking OFX DirectConnect
It actually requires make uninstall && make clean && make && make install to ensure that the changed code is used. Regards, John Ralls > On Mar 18, 2020, at 2:52 PM, Martin Preuss wrote: > > Hi, > > okay now, the latest GIT version always sets "OFXHEADER:100" and uses > the given header version only for the "VERSION:" header. In that case > you can specify "102" and it should create the correct headers... > > Please note: For reasons not yet understood it might be necessary when > updating from git to first issue "make clean" before "make", otherwise > sometimes the resulting binaries might not be based on all the latest > code (I have no idea whether this happens for others as well, it's just > something I stumbled upon while working on AqBanking). > > > Regards > Martin > > > Am 18.03.20 um 22:47 schrieb John Ralls: >> It won't let you leave that blank, and even if it did it would put '100' in >> both fields: >> if (!(s && *s)) >>s="100"; >> >> GWEN_Buffer_AppendString(buf, "OFXHEADER:"); >> GWEN_Buffer_AppendString(buf, s); >> GWEN_Buffer_AppendString(buf, "\r\nDATA:OFXSGML\r\n"); >> >> GWEN_Buffer_AppendString(buf, "VERSION:"); >> s=AO_User_GetHeaderVer(u); >> if (!s || !*s) >>s="102"; >> GWEN_Buffer_AppendString(buf, s); >> GWEN_Buffer_AppendString(buf, "\r\n"); >> >> Because at the second test s has a value. >> >> The new code doesn't emit the trailing tags, so that may not have been the >> problem. The main difference other than the OFXHEADER: value now appears to >> be that there are newlines between the fields. Are those getting escaped in >> GWEN_SyncIo_Http_Write? >> >> Regards, >> John Ralls >>> On Mar 18, 2020, at 2:34 PM, Martin Preuss wrote: >>> >>> Hi, >>> >>> not ATM, but that can be arranged. However, how about leaving that field >>> empty in the settings dialog? That should default to 100 for OFXHEADER >>> and 102 for VERSION (for - ahem - historic reasons, I'm sure I had >>> good^H^H^H reasons for those mixed defaults... :-}) >>> >>> Regards >>> Martin >>> >>> >>> Am 18.03.20 um 22:26 schrieb Chris Graves: >>>> Nice! I see that the change has been made, but still receive the HTTP >>>> 400 error. >>>> >>>> In the AQB5 ofx.log file for a successful case, I see >>>> OFXHEADER:100 >>>> VERSION:102 >>>> >>>> In the AQB6 file, I see >>>> OFXHEADER:102 >>>> VERSION:102 >>>> >>>> Not sure if this could be the problem. Is there a way to set OFXHEADER >>>> and VERSION independently? >>>> >>>> >>>> On Wed, Mar 18, 2020 at 2:02 PM Martin Preuss >>> <mailto:mar...@aqbanking.de>> wrote: >>>> >>>> Hi, >>>> >>>> you can change the header manually to 102/103 in the homebanking setup >>>> dialog (select user, edit user, switch to app settings and type-in >>>> header version 102). >>>> >>>> Regards >>>> Martin >>>> >>>> >>>> Am 18.03.20 um 21:57 schrieb Chris Graves: >>>>> Hi Martin, >>>>> >>>>> Looking better! However, to my knowledge, my bank only supports OFX >>>>> version 102 or 103. I had been using 102. >>>>> >>>>> ofx.log: >>>>> Sending: >>>>> - >>>>> OFXHEADER:220 >>>>> DATA:OFXSGML >>>>> VERSION:220 >>>>> SECURITY:NONE >>>>> ENCODING:USASCII >>>>> CHARSET:1252 >>>>> COMPRESSION:NONE >>>>> OLDFILEUID:NONE >>>>> NEWFILEUID:20200318135033.000 >>>>> >>>>> >>>>> >>>>> >>>>> 20200318135025.000 >>>>> >>>>> On Wed, Mar 18, 2020 at 1:32 PM Martin Preuss >>> <mailto:mar...@aqbanking.de> >>>>> <mailto:mar...@aqbanking.de <mailto:mar...@aqbanking.de>>> wrote: >>>>> >>>>> Hi Chris, >>>>> >>>>> could you please test the latest GIT version? It should create >>>> valid &g
Re: [GNC] AQBanking OFX DirectConnect
I changed the line just below OFXHEADER to GWEN_Buffer_AppendString(buf, "100"); producing the following. No luck, it still returns a 400 error. Regards, John Ralls Sending: - OFXHEADER:100 DATA:OFXSGML VERSION:102 SECURITY:NONE ENCODING:USASCII CHARSET:1252 COMPRESSION:NONE OLDFILEUID:NONE NEWFILEUID:20200318144822.000 20200318144819 ENG USAA 24591 QWIN 2300 20200318144822 24591 2020030900 2020031800 Y > On Mar 18, 2020, at 2:47 PM, John Ralls wrote: > > It won't let you leave that blank, and even if it did it would put '100' in > both fields: > if (!(s && *s)) >s="100"; > > GWEN_Buffer_AppendString(buf, "OFXHEADER:"); > GWEN_Buffer_AppendString(buf, s); > GWEN_Buffer_AppendString(buf, "\r\nDATA:OFXSGML\r\n"); > > GWEN_Buffer_AppendString(buf, "VERSION:"); > s=AO_User_GetHeaderVer(u); > if (!s || !*s) >s="102"; > GWEN_Buffer_AppendString(buf, s); > GWEN_Buffer_AppendString(buf, "\r\n"); > > Because at the second test s has a value. > > The new code doesn't emit the trailing tags, so that may not have been the > problem. The main difference other than the OFXHEADER: value now appears to > be that there are newlines between the fields. Are those getting escaped in > GWEN_SyncIo_Http_Write? > > Regards, > John Ralls >> On Mar 18, 2020, at 2:34 PM, Martin Preuss wrote: >> >> Hi, >> >> not ATM, but that can be arranged. However, how about leaving that field >> empty in the settings dialog? That should default to 100 for OFXHEADER >> and 102 for VERSION (for - ahem - historic reasons, I'm sure I had >> good^H^H^H reasons for those mixed defaults... :-}) >> >> Regards >> Martin >> >> >> Am 18.03.20 um 22:26 schrieb Chris Graves: >>> Nice! I see that the change has been made, but still receive the HTTP >>> 400 error. >>> >>> In the AQB5 ofx.log file for a successful case, I see >>> OFXHEADER:100 >>> VERSION:102 >>> >>> In the AQB6 file, I see >>> OFXHEADER:102 >>> VERSION:102 >>> >>> Not sure if this could be the problem. Is there a way to set OFXHEADER >>> and VERSION independently? >>> >>> >>> On Wed, Mar 18, 2020 at 2:02 PM Martin Preuss >> <mailto:mar...@aqbanking.de>> wrote: >>> >>> Hi, >>> >>> you can change the header manually to 102/103 in the homebanking setup >>> dialog (select user, edit user, switch to app settings and type-in >>> header version 102). >>> >>> Regards >>> Martin >>> >>> >>> Am 18.03.20 um 21:57 schrieb Chris Graves: >>>> Hi Martin, >>>> >>>> Looking better! However, to my knowledge, my bank only supports OFX >>>> version 102 or 103. I had been using 102. >>>> >>>> ofx.log: >>>> Sending: >>>> - >>>> OFXHEADER:220 >>>> DATA:OFXSGML >>>> VERSION:220 >>>> SECURITY:NONE >>>> ENCODING:USASCII >>>> CHARSET:1252 >>>> COMPRESSION:NONE >>>> OLDFILEUID:NONE >>>> NEWFILEUID:20200318135033.000 >>>> >>>> >>>> >>>> >>>> 20200318135025.000 >>>> >>>> On Wed, Mar 18, 2020 at 1:32 PM Martin Preuss >> <mailto:mar...@aqbanking.de> >>>> <mailto:mar...@aqbanking.de <mailto:mar...@aqbanking.de>>> wrote: >>>> >>>> Hi Chris, >>>> >>>> could you please test the latest GIT version? It should create >>> valid >>>> OFXv1 requests now, however, I can't test it completely since >>> I only >>>> have access to an OFXv2 server... >>>> >>>> >>>> Regards >>>> Martin >>>> >>>> >>>> Am 18.03.20 um 16:31 schrieb chris graves: >>>>> An additional bit of information from /tmp/ofx.log: >>>>> AQB5: >>>>> Sending: >>>>> - >>>>> OFXHEADER:100 >>>>> DATA:OFXSGML >>>>> VERSION:102 >>>>> SECURITY:NONE >>>>> ENCODING:USASCII >>>>> CHARSET:1252 >>>>> COMPRESSION:NONE >>>>> OLDFILEUID:NONE >>>>> NEWFILEUID:20200318081757.000 >>>>> >>>>> ... >>>> [...] >>>> >>>> >>>> -- >>>> "Things are only impossible until they're not" >>>> >>> >>> >>> -- >>> "Things are only impossible until they're not" >>> >> >> >> -- >> "Things are only impossible until they're not" > ___ 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] AQBanking OFX DirectConnect
It won't let you leave that blank, and even if it did it would put '100' in both fields: if (!(s && *s)) s="100"; GWEN_Buffer_AppendString(buf, "OFXHEADER:"); GWEN_Buffer_AppendString(buf, s); GWEN_Buffer_AppendString(buf, "\r\nDATA:OFXSGML\r\n"); GWEN_Buffer_AppendString(buf, "VERSION:"); s=AO_User_GetHeaderVer(u); if (!s || !*s) s="102"; GWEN_Buffer_AppendString(buf, s); GWEN_Buffer_AppendString(buf, "\r\n"); Because at the second test s has a value. The new code doesn't emit the trailing tags, so that may not have been the problem. The main difference other than the OFXHEADER: value now appears to be that there are newlines between the fields. Are those getting escaped in GWEN_SyncIo_Http_Write? Regards, John Ralls > On Mar 18, 2020, at 2:34 PM, Martin Preuss wrote: > > Hi, > > not ATM, but that can be arranged. However, how about leaving that field > empty in the settings dialog? That should default to 100 for OFXHEADER > and 102 for VERSION (for - ahem - historic reasons, I'm sure I had > good^H^H^H reasons for those mixed defaults... :-}) > > Regards > Martin > > > Am 18.03.20 um 22:26 schrieb Chris Graves: >> Nice! I see that the change has been made, but still receive the HTTP >> 400 error. >> >> In the AQB5 ofx.log file for a successful case, I see >> OFXHEADER:100 >> VERSION:102 >> >> In the AQB6 file, I see >> OFXHEADER:102 >> VERSION:102 >> >> Not sure if this could be the problem. Is there a way to set OFXHEADER >> and VERSION independently? >> >> >> On Wed, Mar 18, 2020 at 2:02 PM Martin Preuss > <mailto:mar...@aqbanking.de>> wrote: >> >>Hi, >> >>you can change the header manually to 102/103 in the homebanking setup >>dialog (select user, edit user, switch to app settings and type-in >>header version 102). >> >>Regards >>Martin >> >> >>Am 18.03.20 um 21:57 schrieb Chris Graves: >>> Hi Martin, >>> >>> Looking better! However, to my knowledge, my bank only supports OFX >>> version 102 or 103. I had been using 102. >>> >>> ofx.log: >>> Sending: >>> - >>> OFXHEADER:220 >>> DATA:OFXSGML >>> VERSION:220 >>> SECURITY:NONE >>> ENCODING:USASCII >>> CHARSET:1252 >>> COMPRESSION:NONE >>> OLDFILEUID:NONE >>> NEWFILEUID:20200318135033.000 >>> >>> >>> >>> >>> 20200318135025.000 >>> >>> On Wed, Mar 18, 2020 at 1:32 PM Martin Preuss ><mailto:mar...@aqbanking.de> >>> <mailto:mar...@aqbanking.de <mailto:mar...@aqbanking.de>>> wrote: >>> >>> Hi Chris, >>> >>> could you please test the latest GIT version? It should create >>valid >>> OFXv1 requests now, however, I can't test it completely since >>I only >>> have access to an OFXv2 server... >>> >>> >>> Regards >>> Martin >>> >>> >>> Am 18.03.20 um 16:31 schrieb chris graves: >>> > An additional bit of information from /tmp/ofx.log: >>> > AQB5: >>> > Sending: >>> > - >>> > OFXHEADER:100 >>> > DATA:OFXSGML >>> > VERSION:102 >>> > SECURITY:NONE >>> > ENCODING:USASCII >>> > CHARSET:1252 >>> > COMPRESSION:NONE >>> > OLDFILEUID:NONE >>> > NEWFILEUID:20200318081757.000 >>> > >>> > ... >>> [...] >>> >>> >>> -- >>> "Things are only impossible until they're not" >>> >> >> >>-- >>"Things are only impossible until they're not" >> > > > -- > "Things are only impossible until they're not" ___ 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] AQBanking OFX DirectConnect
That would be because they are XML syntax. OFX V2 is XML. Regards, John Ralls > On Mar 18, 2020, at 1:15 PM, chris graves wrote: > > Because I don't see them in the AQB5 ofx.log file and to me they look like > XML syntax. Not being knowledgeable on the subject I can't say for sure. I > thought at v1.6, the syntax was pure SMGL. But again, I don't know what I > don't know. > >> On Mar 18, 2020, at 1:12 PM, John Ralls wrote: >> >> And why were you thinking that? >> >> Regards, >> John Ralls >> >> >>> On Mar 18, 2020, at 1:05 PM, chris graves wrote: >>> >>> I was thinking that it could be the first two lines of your file below. >>> >>>> On Mar 18, 2020, at 12:40 PM, John Ralls wrote: >>>> >>>> >>>> >>>>> On Mar 18, 2020, at 9:33 AM, Christopher Singley >>>>> wrote: >>>>> >>>>> You're sending VERSION="220", which USAA doesn't accept. You need to >>>>> send VERSION="200" or VERSION="202". Try that. >>>> >>>> No joy, I still get a 400 response, but it does occur to me that it isn't >>>> necessarily an OFX issue, it could be that the HTTP request itself is >>>> malformed. >>>> >>>> >>>> >>>> >>>> >>>> >>>> 20200318122832 >>>> >>>> >>>> ENG >>>> >>>> USAA >>>> 24591 >>>> >>>> QWIN >>>> 2300 >>>> >>>> >>>> >>>> >>>> 20200318122835 >>>> >>>> >>>> 24591 >>>> XX >>>> >>>> >>>> 2020031000 >>>> 2020031800 >>>> Y >>>> >>>> >>>> >>>> >>>> >>>> >>>> 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. >>> >> > ___ 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] AQBanking OFX DirectConnect
And why were you thinking that? Regards, John Ralls > On Mar 18, 2020, at 1:05 PM, chris graves wrote: > > I was thinking that it could be the first two lines of your file below. > >> On Mar 18, 2020, at 12:40 PM, John Ralls wrote: >> >> >> >>> On Mar 18, 2020, at 9:33 AM, Christopher Singley wrote: >>> >>> You're sending VERSION="220", which USAA doesn't accept. You need to send >>> VERSION="200" or VERSION="202". Try that. >> >> No joy, I still get a 400 response, but it does occur to me that it isn't >> necessarily an OFX issue, it could be that the HTTP request itself is >> malformed. >> >> >> >> >> >> >> 20200318122832 >> >> >> ENG >> >> USAA >> 24591 >> >> QWIN >> 2300 >> >> >> >> >> 20200318122835 >> >> >> 24591 >> XX >> >> >> 2020031000 >> 2020031800 >> Y >> >> >> >> >> >> >> 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. > ___ 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] [GNC-dev] Online Access to Bank of America
> On Mar 18, 2020, at 10:18 AM, Alan Auerbach wrote: > > Dear John, > > I am using Win10 Pro. If I go back to gnucash 3.6, will I lose valuable > updates in exchange for OFX Direct Connect? It seems to be a choice or wait > and see if it is working in the next update. Depends. If you're in the habit of keeping several graph reports open then you should go to 3.5, there was a webkit build problem in 3.6 and 3.7 that caused GnuCash to hang with that. There have been some new reports and some bug fixes, none of which I would consider deal-breaking but you can review the release notes at https://www.gnucash.org/news.phtml and decide for yourself. 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.
Re: [GNC] AQBanking OFX DirectConnect
> On Mar 18, 2020, at 9:33 AM, Christopher Singley wrote: > > You're sending VERSION="220", which USAA doesn't accept. You need to send > VERSION="200" or VERSION="202". Try that. No joy, I still get a 400 response, but it does occur to me that it isn't necessarily an OFX issue, it could be that the HTTP request itself is malformed. 20200318122832 ENG USAA 24591 QWIN 2300 20200318122835 24591 XXXXXX 2020031000 2020031800 Y 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.
Re: [GNC] AQBanking OFX DirectConnect
Interesting. USAA can't parse the OFXv2 that AQBanking 6.1.2 emits.
Unfortunately it just returns an HTTP 400 response, no details. Perhaps like v1
there are Intuit-induced quirks in the v2 parser as well and we'd need to
capture a v2 interaction with Quicken to figure them out.
Regards,
John Ralls
> On Mar 18, 2020, at 4:35 AM, csingley wrote:
>
>> Aside from the extra whitespace, which shouldn't matter, the git code has
> closing tags on every element while the AQB5 code has closing tags only on
> grouping elements.
>>
>> USERID is specified in the OFX 1.6 DTD as
>>
>> and according to
>> https://en.wikipedia.org/wiki/Standard_Generalized_Markup_Language#OMITTAG
>> the "- o" in the middle means that it should have an opening tag and no
>> closing tag.
>
> Sorry to butt in.. MAY have, not SHOULD have. Closing tags are optional
> for OFXv1 "elements" (i.e. data-bearing leaf nodes).
>
> But the spec doesn't really matter in the real world. The FIs code to
> Quicken, not to the spec... and Quicken sends OFXv1 with unclosed elements.
> Therefore, AqBanking really should do so as well in order to be useful.
>
> Contrary to the spec, USAA doesn't accept closing tags on elements.
> However, USAA does accept OFXv2, specifically versions 202 and 205. Just
> send them XML.
>
> Here's the result of scanning USAA's server:
>
> (ofxtools) 6:30:50 csingley@nous ofxtools sequences ? ofxget scan usaa
> [{"versions": [102, 151], "formats": [{"pretty": false, "unclosedelements":
> true}, {"pretty": true, "unclosedelements": true}]}, {"versions": [200,
> 202], "formats": [{"pretty": false}, {"pretty": true}]}, {"chgpinfirst":
> false, "clientuidreq": false, "authtokenfirst": false, "mfachallengefirst":
> false}]
>
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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] [GNC-dev] Online Access to Bank of America
> On Mar 17, 2020, at 5:19 PM, Alan Auerbach wrote: > > Dear John, > > Thank you for getting back to me so quickly. I apologize for being in the > wrong place. I thought that gnucash-user is for accounting questions rather > than technical issues. > > Thank you for referring me to > https://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect and > http://ofxhome.com/. I had read the wiki before and during my attempt to get > OFX Direct Connect working. Ofxhome.com is where I found the proper codes. > > I have since heard from Chris Graves who told me that OFX Direct Connect > access is broken in the 3.8 version of gnucash that I am using. That would > be too bad. > > Best wishes, > /s/ Alan > > -Original Message- > From: John Ralls > Sent: Tuesday, March 17, 2020 3:54 PM > To: aauerb...@poolthing.com > Cc: gnucash-user > Subject: Re: [GNC-dev] Online Access to Bank of America > > > >> On Mar 17, 2020, at 3:31 PM, Alan Auerbach > wrote: >> >> As a brand-new user, I am trying to setup online access to my Bank of >> America account. I have entered the requested information including >> correct URL (from the gnucash table), the routing number and SWIFT >> code. After that point, I cannot get further. The next button remains >> grayed out. What am I missing? >> > > As a brand-new user you're first of missing that gnucash-devel (this list) > is for developers to discuss GnuCash internals. Users should subscribe to > gnucash-user. For your convenience I've copied that list on this reply. > > The most likely answer to your question is that you haven't completed all of > the steps in the AQBanking Setup Wizard so that there are no accounts set > up. Some references: > https://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect for instructions > on setting up. > http://ofxhome.com/ for the best information on bank parameters. This is the > website that feeds the setup selection in the AQBanking Setup Wizard and it > tests them daily. It's worthwhile to check the setup that you intend to use > and make sure that it's still working: About 1/3 of them don't any more. > > Regards, > John Ralls > > Please remember to copy the list on all replies. What version of GnuCash will work with OFX depends on what OS you're using. It's true that with the Windows and MacOS bundles 3.8 won't work, but if you've installed 3.8 on Linux it will depend upon what version of AQBanking the distribution that you use provides. In the case of MacOS and Windows you can pretty simply install an older version (3.7 for MacOS, 3.6 for Windows) from our SourceForge or Github sites. 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.
Re: [GNC] Importing transactions problem
And is that the case when you finish the import matcher or only after you've saved your book, quit GnuCash, and restarted? Regards, John Ralls > On Mar 17, 2020, at 11:08 AM, Joseph Vernice wrote: > > No, one side is to the credit card (correct source acct) and the other > account to my checking account (incorrect) > > On 3/17/2020 1:48 PM, John Ralls wrote: >> >>> On Mar 17, 2020, at 10:18 AM, Joseph Vernice wrote: >>> >>> Hello John, >>> >>> The problem is the auto assigned account on the import. For some reason, >>> everything is being autoassigned to my checking account instead of an >>> expense or imbalance. >>> >>> Regards, >>> Joe Vernice >>> >>> On 3/17/2020 12:40 PM, John Ralls wrote: >>>>> On Mar 17, 2020, at 8:44 AM, Joseph Vernice wrote: >>>>> >>>>> There seems to be a problem with importing transactions. I am importing >>>>> a QFX file from my credit card company and all seems fine. When I close >>>>> and re-open the gnucash file, the transactions offsetting account all >>>>> change to my checking account. Is this s bug? How can I fix it? How >>>>> can it be prevented in the future? >>>> Meaning that both splits are in the same account? Before quitting GnuCash >>>> were all of the transfer accounts correctly set? >>>> >>>> What version of GnuCash? >> Is that "yes" to the first question, that both splits in every transaction >> are assigned to your checking account? >> >> What about the GnuCash version? >> >> 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.
Re: [GNC] [GNC-dev] Online Access to Bank of America
> On Mar 17, 2020, at 3:31 PM, Alan Auerbach wrote: > > As a brand-new user, I am trying to setup online access to my Bank of > America account. I have entered the requested information including correct > URL (from the gnucash table), the routing number and SWIFT code. After that > point, I cannot get further. The next button remains grayed out. What am I > missing? > As a brand-new user you're first of missing that gnucash-devel (this list) is for developers to discuss GnuCash internals. Users should subscribe to gnucash-user. For your convenience I've copied that list on this reply. The most likely answer to your question is that you haven't completed all of the steps in the AQBanking Setup Wizard so that there are no accounts set up. Some references: https://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect for instructions on setting up. http://ofxhome.com/ for the best information on bank parameters. This is the website that feeds the setup selection in the AQBanking Setup Wizard and it tests them daily. It's worthwhile to check the setup that you intend to use and make sure that it's still working: About 1/3 of them don't any more. 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.
Re: [GNC] Importing transactions problem
> On Mar 17, 2020, at 10:18 AM, Joseph Vernice wrote: > > Hello John, > > The problem is the auto assigned account on the import. For some reason, > everything is being autoassigned to my checking account instead of an expense > or imbalance. > > Regards, > Joe Vernice > > On 3/17/2020 12:40 PM, John Ralls wrote: >> >>> On Mar 17, 2020, at 8:44 AM, Joseph Vernice wrote: >>> >>> There seems to be a problem with importing transactions. I am importing a >>> QFX file from my credit card company and all seems fine. When I close and >>> re-open the gnucash file, the transactions offsetting account all change to >>> my checking account. Is this s bug? How can I fix it? How can it be >>> prevented in the future? >> Meaning that both splits are in the same account? Before quitting GnuCash >> were all of the transfer accounts correctly set? >> >> What version of GnuCash? Is that "yes" to the first question, that both splits in every transaction are assigned to your checking account? What about the GnuCash version? 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.
Re: [GNC] AQBanking OFX DirectConnect
> On Mar 17, 2020, at 9:45 AM, John Ralls wrote: > > > >> On Mar 15, 2020, at 1:21 PM, John Ralls wrote: >> >>> >>> On Mar 15, 2020, at 12:47 PM, Martin Preuss wrote: >>> >>> Hi, >>> >>> Am 15.03.20 um 20:17 schrieb John Ralls: >>>> I just made a MacOS build with the latest AQBanking so I could test it >>>> with my bank (USAA). No go, and a bit of troubleshooting reveals that it's >>>> because AQBanking now uses the XML-based OFX V2. AFAIK that's not >>>> supported by any US bank. >>> [...] >>> >>> OFX2 is the only version I could get access to a test server for, so >>> thats what I implemented so far. >>> >>> However, since the OFX spec state that banks should also accept XML like >>> OFX requests (i.e. OFX files with closing XML elements) the code might >>> be adjustable for this... >>> >>> I will try to add a mode in which the plugin sends the headers >>> previously used for OFX1 and still send requests with closing XML >>> elements, at least according to the specs I read that should work... >>> >>> Anyway, as I wrote before I can't test it myself. There is only person - >>> so far - I heard of from the US who tested the latest code with a real >>> server and I really appreciate his help, but he seems to be using the >>> prebuilt Windows version which makes the debug process... well... difficult. >>> >>> It would be extremely helpfull to have someone who could compile and >>> test a version from GIT, but given the different timezones the possible >>> OFX users and I live in that might be time consuming for both sides... >> >> Martin, >> >> As I said here and in my bug report, AQB 5's OFX backend works well and has >> done for many years. If you just update it for the new AQB6 and Gwen5 API it >> has a good chance of working. >> >> I can build from git and test. So far there's no need for debugging, simply >> comparing the OFX from 5.8 and 6.1 showed me the problem: OFX DirectConnect >> servers using V1 can't parse the XML you send in the request and 400, see >> the transcripts in the bug report. >> >> The current OFX spec doesn't matter if the bank is using software written >> for OFX V1 as nearly all in the US do. > > Martin, > > Frank noticed yesterday that you'd pushed a large OFX V1 change to AQBanking > master, so I pulled it and tested it. Unfortunately its a total fail because > the V1 code formats the OFX in XML. > > V1 servers cannot parse XML and return a 400 error. Martin, Sorry, that's not quite right. It's not XML, but it does still 400. The headers match those sent by AQB5, but the AQB5 request block is 20200315112517XX X ENGUSAA24591QWIN2300202003151125171202003140020200315112517Y unrolled and indented: 20200315112517 XX X ENG USAA 24591 QWIN 2300 20200315112517 1 2020031400 20200315112517 Y and git V1 sends 20200317095100 ENG USAA 24591 QWIN 2300 20200317095103 24591 2020031400 2020031700 Y Aside from the extra whitespace, which shouldn't matter, the git code has closing tags on every element while the AQB5 code has closing tags only on grouping elements. USERID is specified in the OFX 1.6 DTD as and according to https://en.wikipedia.org/wiki/Standard_Generalized_Markup_Language#OMITTAG the "- o" in the middle means that it should have an opening tag and no closing tag. 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.
Re: [GNC] AQBanking OFX DirectConnect
> On Mar 15, 2020, at 1:21 PM, John Ralls wrote: > >> >> On Mar 15, 2020, at 12:47 PM, Martin Preuss wrote: >> >> Hi, >> >> Am 15.03.20 um 20:17 schrieb John Ralls: >>> I just made a MacOS build with the latest AQBanking so I could test it with >>> my bank (USAA). No go, and a bit of troubleshooting reveals that it's >>> because AQBanking now uses the XML-based OFX V2. AFAIK that's not supported >>> by any US bank. >> [...] >> >> OFX2 is the only version I could get access to a test server for, so >> thats what I implemented so far. >> >> However, since the OFX spec state that banks should also accept XML like >> OFX requests (i.e. OFX files with closing XML elements) the code might >> be adjustable for this... >> >> I will try to add a mode in which the plugin sends the headers >> previously used for OFX1 and still send requests with closing XML >> elements, at least according to the specs I read that should work... >> >> Anyway, as I wrote before I can't test it myself. There is only person - >> so far - I heard of from the US who tested the latest code with a real >> server and I really appreciate his help, but he seems to be using the >> prebuilt Windows version which makes the debug process... well... difficult. >> >> It would be extremely helpfull to have someone who could compile and >> test a version from GIT, but given the different timezones the possible >> OFX users and I live in that might be time consuming for both sides... > > Martin, > > As I said here and in my bug report, AQB 5's OFX backend works well and has > done for many years. If you just update it for the new AQB6 and Gwen5 API it > has a good chance of working. > > I can build from git and test. So far there's no need for debugging, simply > comparing the OFX from 5.8 and 6.1 showed me the problem: OFX DirectConnect > servers using V1 can't parse the XML you send in the request and 400, see the > transcripts in the bug report. > > The current OFX spec doesn't matter if the bank is using software written for > OFX V1 as nearly all in the US do. Martin, Frank noticed yesterday that you'd pushed a large OFX V1 change to AQBanking master, so I pulled it and tested it. Unfortunately its a total fail because the V1 code formats the OFX in XML. V1 servers cannot parse XML and return a 400 error. 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.
Re: [GNC] Importing transactions problem
> On Mar 17, 2020, at 8:44 AM, Joseph Vernice wrote: > > There seems to be a problem with importing transactions. I am importing a > QFX file from my credit card company and all seems fine. When I close and > re-open the gnucash file, the transactions offsetting account all change to > my checking account. Is this s bug? How can I fix it? How can it be > prevented in the future? Meaning that both splits are in the same account? Before quitting GnuCash were all of the transfer accounts correctly set? What version of GnuCash? 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.
Re: [GNC] How to fix "Unable to Save to Database" error - Second Request
You're using a SQLite3 database, not and XML file, and SQLIte3 thinks that its file has gotten corrupted. If you have backups you should make sure that the one or two from just ´before the first time you encountered the error are safe and available. If you don't have backups then this is a message from your deity to start keeping regular ones. I think the simplest fix is to re-save to a new file using File>Save As... I suggest doing it twice, one XML and the other SQLite3. You pick which one with the list box on the top of the Save As dialog box. Regards, John Ralls > On Mar 15, 2020, at 4:53 PM, Eric H. Bowen via gnucash-user > wrote: > > I'm seeing the error on all three operating systems, although it first > appeared on the Windows 10 computer. The pop-up error message does appear > only when importing transactions, and only from one specific account (my > personal checking account) at that, and since it seemed as though the > transaction records were not affected I put up with it for several months as > just a nuisance. However, recently I've been trying to reconcile a loan > account for a vehicle which was totaled and paid off by insurance, and when I > try to balance the liability of the loan off against the asset for the value > of the vehicle it seems to post properly for that session...but when I > restart Gnucash for the next session, the amount has moved back to > "Imbalance". A couple of other transactions are doing this as well, but the > auto payoff is the big'un. I want to get the known error taken care of first, > and then when the imports are back to working properly I want to see if I'm > still having problems balancing out these transactions and, if I do, I'll > post a separate request to the listEric. > > On 3/15/20 6:30 PM, David H wrote: >> Hi Eric, >> >> Yep saw that. What OS are you seeing the error on, or is it on all of them >> ? Just saw your other post, so you are getting this when trying to import >> transactions NOT when saving your Gnucash data file. >> >> Cheers David. >> >> >> On Mon, 16 Mar 2020 at 09:19, Eric H. Bowen > <mailto:e...@ehbowen.net>> wrote: >> >>Hello, David. More info in the message I just posted. I do use ISO >>date format (-mm-dd) for all of my computer-related workEric >> >> >>On 3/15/20 4:22 PM, David H wrote: >>> >>> >>>On Mon, 16 Mar 2020 at 07:10, Frank H. Ellenberger >>>>><mailto:frank.h.ellenber...@gmail.com>> wrote: >>> >>>> * 15:01:20 WARN qif-parse:parse-date/format: >>>format is y-d-m >>>> but date is [2020/2/6]. >>> >>>That date is in the future. It seems, somebody changed the >>>date format >>>(order of day and month). >>> >>>Hmm transaction dates can be in the future, this looks like 6th >>>Feb 2020 to me in ccyy-m-d format ? >>> >>>Cheers David. >>> >> > > ___ > 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] AQBanking OFX DirectConnect
> On Mar 15, 2020, at 12:47 PM, Martin Preuss wrote: > > Hi, > > Am 15.03.20 um 20:17 schrieb John Ralls: >> I just made a MacOS build with the latest AQBanking so I could test it with >> my bank (USAA). No go, and a bit of troubleshooting reveals that it's >> because AQBanking now uses the XML-based OFX V2. AFAIK that's not supported >> by any US bank. > [...] > > OFX2 is the only version I could get access to a test server for, so > thats what I implemented so far. > > However, since the OFX spec state that banks should also accept XML like > OFX requests (i.e. OFX files with closing XML elements) the code might > be adjustable for this... > > I will try to add a mode in which the plugin sends the headers > previously used for OFX1 and still send requests with closing XML > elements, at least according to the specs I read that should work... > > Anyway, as I wrote before I can't test it myself. There is only person - > so far - I heard of from the US who tested the latest code with a real > server and I really appreciate his help, but he seems to be using the > prebuilt Windows version which makes the debug process... well... difficult. > > It would be extremely helpfull to have someone who could compile and > test a version from GIT, but given the different timezones the possible > OFX users and I live in that might be time consuming for both sides... Martin, As I said here and in my bug report, AQB 5's OFX backend works well and has done for many years. If you just update it for the new AQB6 and Gwen5 API it has a good chance of working. I can build from git and test. So far there's no need for debugging, simply comparing the OFX from 5.8 and 6.1 showed me the problem: OFX DirectConnect servers using V1 can't parse the XML you send in the request and 400, see the transcripts in the bug report. The current OFX spec doesn't matter if the bank is using software written for OFX V1 as nearly all in the US do. 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] AQBanking OFX DirectConnect
I just made a MacOS build with the latest AQBanking so I could test it with my bank (USAA). No go, and a bit of troubleshooting reveals that it's because AQBanking now uses the XML-based OFX V2. AFAIK that's not supported by any US bank. I've filed https://www.aquamaniac.de/rdm/issues/202. I suspect that Intuit doesn't support OFX V2 anywhere with OFX DirectConnect, so has anyone outside of the US who can use if tried with GnuCash 3.8 and AQBanking 5.99 or 6.x and been successful? 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.
Re: [GNC] General Journal Report - Error
It's coming from Guile's garbage collector, bdwgc, and might be related to building GnuCash for 32 bits on Windows. Regards, John Ralls > On Mar 15, 2020, at 4:42 AM, Christopher Lam > wrote: > > A heap error is not common. Please file a bug in bugzilla, and ideally > attach https://wiki.gnucash.org/wiki/Tracefile > Also try "gnucash.exe --debug" too > > On Fri, 13 Mar 2020 at 18:49, Gilberto Reis Filho < > gilberto.reis.fi...@gmail.com> wrote: > >> Good afternoon. >> >> I am trying to generate a General Journal report however I am getting >> a fatal error message followed by a crash in GnuCash. The error >> message is "too many heap sections". >> >> I am on Windows 10 (v1909) and using GnuCash 3.8. >> >> Does anyone know if there is a way to circumvent this error and get >> the General Journal report? >> >> Thanks in advance. >> Gilberto >> ___ >> 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] problems with Finance::Quote 1.49 and and gnucash Build ID: 3.8b+(2019-12-29) on windows 10 64 bit
That shouldn't matter at all, we're not linking libperl. prices.scm popens perl
to run gnc-fq-helper, hooking to its stdout to get scheme-formatted strings
that prices.scm parses.
Regards,
John Ralls
> On Mar 13, 2020, at 2:47 PM, Frank H. Ellenberger
> wrote:
>
> I would suspect the crash happens because of mixing 32-bit Gnucash with
> 64-bit perl, but I am no Windows user.
>
> ~Frank
>
> Weitergeleitete Nachricht
> Betreff: Re: [GNC] problems with Finance::Quote 1.49 and and gnucash
> Build ID: 3.8b+(2019-12-29) on windows 10 64 bit
> Datum: Fri, 13 Mar 2020 13:54:02 -0400
> Von: Mitchell Hausman
> An: Frank H. Ellenberger
>
> Hello Frank,
>
> I still think there's a windows f-q install problem when using GnuCash
> to invoke it
>
> Unfortunately,
>
> 1) because i'm such a muddler, it's hard to isolate variables and
> determine the actual correct path to a "normal" windows install of
> Finance::Quote for GnuCash use
>
> 2) i'm just beginning to understand how to use GnuCash, so some of the
> errors might be between the screen and the keyboard, (as they used to
> say), but i don't think so
>
>
> I have a 57 page LibreOffice document showing the steps to a successful
> install in windows (it's that many pages because i copied all the
> complete perl scripts into it)
>
> IMHO, it shouldn't require so many steps by the user
>
> The Windows install steps should be (again, IMHO):
>
> 1) install Gnucash
>
> 2) select install online price retrieval from windows start menu (image
> below)
>
> done!
>
> *those steps don't appear to work (f-q install fails, or, get quote call
> crashes GnuCash)!*
>
>
> *Bottom Line:*
>
> *Manjaro Linux 19.0 64 bit:*
>
> Using Octopi to install Gnucash, you have the option of adding
> dependencies, including Finance::Quote
>
> I previously thought "get quote" function wasn't working on Linux, but
> maybe i was setting up the security editor, or price database/price
> editor incorrectly
>
> rechecking today, get quote within GnuCash succeeds, with a normal install!
>
>
> *Win 10 64 bit:*
>
> from gnucash-guide (downloaded from https://gnucash.org/docs.phtml, for
> windows users), if you want online price retrieval for GnuCash, you do
> have to install F-Q separately as a gnucash sub menu from the windows
> start menu:
>
>
> *that did not work (Gnucash calls to F-Q caused crash)*
>
> **
>
> what worked for me (summarized from my install documentation mentioned
> above), is:
>
> 3/12/2020 6:11 pm
>
> after uninstalling straberryperl and gnucash (without registry cleanup)
>
> 1. installed strawberry perl 64 bit
>
>
> 2. used cpanm Module::Name to install finance::quote in admin cmd window:
>
> C:\WINDOWS\system32>cpanm Finance::Quote
>
> .
>
> .
>
> .
>
> *Successfully installed Finance-Quote-1.49*
>
> 9 distributions installed
>
> 3. install GnuCash 3.8
>
>
> 4. because it blew up (crashed) with "get quote" call, i installed F-Q
> from the windows start menu (see image above)
>
> it succeeded:
>
> .
>
> .
>
> .
>
> Appending installation info to C:\STRAWB~1\perl\lib/perllocal.pod
>
> SBECK/Date-Manip-6.81.tar.gz
>
> C:\STRAWB~1\c\bin\gmake.exe install UNINST=1 -- OK
>
> *Finance::Quote is up to date (1.49).*
>
>
> * Check environment variable ALPHAVANTAGE_API_KEY
>
>
> ***
>
> *** You need an API key (from https://www.alphavantage.co)
>
> *** to run the Perl module Finance::Quote.
>
> ***
>
> *** Make it available to GnuCash by
>
> *** - setting the environment variable ALPHAVANTAGE_API_KEY (done) or
>
> *** - starting GnuCash and adding the Alpha Vantage api key in
>
> *** Edit->Preferences->Online Quotes
>
> ***
>
>
> * Run gnc-fq-check //shows available quote sources
>
>
> ("1.49" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asx"
> "aufunds" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "bse"
> "bsero" "canada" "canadamutual" "citywire" "cominvest" "cse" "deka"
> "dutch" "dwsfunds" "europe" "fetch_live_currencies" "fidelity"
> "fidelity_direct" "fidelityfixed" "financecanada" "finanzpartner"
> "fin
Re: [GNC] Find or search all expenses in a certain account
Gio, No surprise, that's not exactly lucid. I just tried again with a more realistic test book. The problem is that "matches all accounts" means what it says: if you give it ten accounts then any transaction must have splits in all 10 of them to match. Experimenting around a bit more, I find that if you start from the Accounts page and use Accounts - Matches Any Account - Foo + Bar (where Foo and Bar are accounts selected in the account list box) you get all of the transactions with a split touching either Foo or Bar. If you use All Accounts - Matches Any Account - Foo + Bar you get transactions with at least one split in each of Foo and Bar. If you start from a register tab then the Accounts - Matches Any Account - XXX will return no transactions unless XXX is the account whose register you have focussed. Using All Accounts with a single account selected will return the transactions from that register with a split touching that one account. So the way to get what you want is to change the selector in the upper right from "all criteria are met" to "any criteria are met" and then enter a line All Accounts - Matches Any Account - XXX for each expense account that you want to include in the result. Regards, John Ralls > On Mar 8, 2020, at 8:00 PM, Gio Bacareza wrote: > > Hi John, > > I also actually tried that Find > All Accounts > Choose Accounts = > Expenses:(all children) and it's still blank. > > To be honest, I find this text in the documentation really hard to > understand: > "The Account option performs a search where the accounts selected in the > Choose Accounts dialog will both be searched individually for results. This > means that a match in any of the selected accounts will either be displayed > (matches any account) or discarded (matches no account). > > The All Accounts option performs a search where accounts selected in the > Choose Accounts dialog will only return results that match in both > accounts." > > Thanks > > On Sun, Mar 8, 2020 at 12:40 PM John Ralls wrote: > >> >> >>> On Mar 7, 2020, at 8:04 PM, Gio Bacareza wrote: >>> >>> Thanks John. I'm trying to run in from the register page. >>> >>> On Sun, Mar 8, 2020 at 1:52 AM John Ralls wrote: >>> >>>> >>>> >>>>> On Mar 7, 2020, at 1:20 AM, Gio Bacareza wrote: >>>>> >>>>> Hi I tried to search all expenses in a certain account by doing Find > >>>>> Account > Matches Any Account - Selected Expense Account and ALL child >>>>> accounts. >>>>> >>>>> Result: blank >>>>> >>>>> What am I doing wrong? >>>>> >>>> >>>> Did you run Find from the Accounts page or from a register page? >>>> >> >> When you run from a register page Find searches only that account and >> Account in find matches the current account rather than the transfer >> account. If I understand what you're trying to do, use All Accounts - >> matches all accounts - xxx where xxx means to select the accounts you want >> to search for in the selector dialog box. >> >> Regards, >> John Ralls >> >> >> >> >> > > -- > cheers, > > Gio > ___ > 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] Report Options was hiding expense and income accounts with zero balances
> On Mar 7, 2020, at 10:10 PM, Liz wrote: > > On Sat, 7 Mar 2020 23:30:59 -0600 > Adrien Monteleone wrote: > >> Curious... >> >> Where are you right-clicking to get Options? > > Not any more > I started about Gnucash 1.6, and it went away, to be replaced by the > current scheme. > Sometimes the history helps us understand how the next choice was made. I think that change happened in 2.4 when we switched from using GtkHTML (a no-longer-available type of widget, it's been subsumed by GtkTextBuffer with less markup capability) to GtkWebKitWebView for displaying reports. 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.
Re: [GNC] Find or search all expenses in a certain account
> On Mar 7, 2020, at 8:04 PM, Gio Bacareza wrote: > > Thanks John. I'm trying to run in from the register page. > > On Sun, Mar 8, 2020 at 1:52 AM John Ralls wrote: > >> >> >>> On Mar 7, 2020, at 1:20 AM, Gio Bacareza wrote: >>> >>> Hi I tried to search all expenses in a certain account by doing Find > >>> Account > Matches Any Account - Selected Expense Account and ALL child >>> accounts. >>> >>> Result: blank >>> >>> What am I doing wrong? >>> >> >> Did you run Find from the Accounts page or from a register page? >> When you run from a register page Find searches only that account and Account in find matches the current account rather than the transfer account. If I understand what you're trying to do, use All Accounts - matches all accounts - xxx where xxx means to select the accounts you want to search for in the selector dialog box. 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.
Re: [GNC] Find or search all expenses in a certain account
> On Mar 7, 2020, at 1:20 AM, Gio Bacareza wrote: > > Hi I tried to search all expenses in a certain account by doing Find > > Account > Matches Any Account - Selected Expense Account and ALL child > accounts. > > Result: blank > > What am I doing wrong? > Did you run Find from the Accounts page or from a register page? 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.
Re: [GNC] Recovering deleted transaction from log files
There's two sorts of logging. GnuCash emits varying levels of messages (error, warning, info, or debug) into the trace file (https://wiki.gnucash.org/wiki/Tracefile) depending on command-line arguments. The default is to emit only errors. The other logging, the one that Roland is talking about, is transaction logging. This writes to a log file that GnuCash knows how to import with File>Import>Replay Gnucash .log file, writing an entry every time a transaction object is locked or unlocked for editing. It's not configurable. Scheduled Transaction templates aren't locked so they're not logged, but when the SX creates a transaction that will be logged. The only way to not log an edit would be code that doesn't call xaccTransBeginEdit/xaccTransCommitEdit and any code that doesn't do that risks also that its changes won't be saved, particularly in the SQL backends. Regards, John Ralls > On Feb 24, 2020, at 3:23 AM, Greg Feneis wrote: > > I imagine logging is minimal by default to help keep GnuCash speedy. > Unless the user increases verbosity via CLI when launching GnuCash. Just a > guess. > > I'm also curious about controlling logging. I bet it's documented somewhere > > Kind regards, Greg Feneis > (Pixel 3) > > > On Sat, Feb 22, 2020, 15:00 Roland Roberts wrote: > >> On 2/21/2020 11:54 PM, Roland Roberts wrote: >>> [...] >>> So... I figured the log file(s) between those two should have the >>> missing transactions. But that file is nothing but a sequence of >>> >>> = START >>> = END >>> >>> after the header. Why wouldn't the log have my deleted transactions >>> in it? >> >> So I was able to track down the missing transaction. What had actually >> happened was that I had apparently edited it (obviously in error) and >> change the account on a payment to a credit card. That removed it's >> reconciled state in the bank account from which the payment had been >> made (naturally, it was no longer against that account). I did that the >> painful way by unpacking the two gnucash files and doing diff, that >> tracking through the diffs. >> >> I'm still puzzled by the log file. I read through some of the gnucash >> docs and realize that scheduled transactions are special beasts and that >> those don't show up in the logs, but an edit like this I thought would. >> My immediate problem is solved, but...I'd like to know what sort of >> things the logs can help me with since it wasn't as useful as I expected >> for this case. >> >> roland >> >> >> ___ >> 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] Register layout
> On Feb 20, 2020, at 12:52 PM, Ron wrote: > > How do I re-arrange the layout of the check register to my liking? > > How do I get auto-fill for the payee? The register layout is currently hard coded, so it's "our way or the highway", sorry. Auto fill works by repeating previous entries so once you've created a transaction for a particular payee in an account you'll get auto-fill for subsequent entries with the same description. You can fiddle that a bit by letting autocomplete fill in based on a partial entry, tabbing through to the debit or credit column and then tabbing back and editing the description to what you want for the current transaction. For example, I like the description of dividend reinvestments to include the number of units as a cross-check. I might have 10/11/2019 Reinvest FMAGX 23.11 Assets:Investments:Fidelity:Magellan Fund251.67 and when it's time to do the next dividend I'll start "Reinvest FMAGX" and let it fill in the 23.11 and tab through so that it fills in the account for me. I'll edit the new value and then back-tab to the description and change the number of units. When I hit enter the transfer dialog will pop up where I'll enter the number of units again. Then when I go to reconcile the FMAGX account if it doesn't reconcile I can check the amount against what I put in the description and if there's a discrepancy it's a good clue about why it doesn't reconcile. 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.
Re: [GNC] Precision in exchange rate conversion
That's not mangling the data, it's presenting the exact value of 11102.12/1975.10, a number that isn't representable as a decimal without rounding. As for the display being clever, of course it isn't, it's a computer. But it you enter the two values 11102.12 and 1975.10 GnuCash shouldn't change them, it should just calculate the ratio and present that as the price, either exactly as 5 + 61331/98755 or as 5.621041972558352 rounded to however many decimal places. When I test that, it's exactly what I get, see the attached screen shot. Note the exact exchange rate in the exchange rate box but the rounded decimal values to the right of it. Regards, John Ralls > On Feb 19, 2020, at 12:12 PM, Paul Abraham wrote: > > Hmm. That seems to work, but it certainly isn't what I want. The > exchange rate is now shown as "5 + 61331/98755" which is less than > helpful - it most certainly is not how real world exchange rates are > quoted, and it makes comparison almost impossible! > > Why does the display option mangle the data? That isn't very clever. I > think I'll just stick in a fudge factor as a separate split to correct > the total though it's a long way from ideal. > > Thanks very much for the answer, though. I can stop chasing moonbeams > now ;-) ___ 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] help
Sounds like https://bugs.gnucash.org/show_bug.cgi?id=797493. It has a screenshot. I have no idea what might cause that. Regards, John Ralls > On Feb 18, 2020, at 2:30 AM, Colin Law wrote: > > Can you post a screenshot showing the problem? > > Colin > > On Tue, 18 Feb 2020 at 10:09, Keith Miller wrote: >> >> How to get help? >> On Ubuntu the transfers dropdown is transparent so you can not read the >> items in the list. >> ___ >> 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] Reports have got broken with commit f66b7ed
> On Feb 14, 2020, at 7:00 AM, Peter Zimmerer wrote: > > Hi all, > > if I build gnucash from commit f66b7ed (or a newer commit in maint) any > report from the "Reports" menu will show up with an empty page. > If I keep the report open and close gnucash the report will be displayed > correctly after restart of gnucash. > If I open a new report or a report from the "Saved Report > Configurations" an empty page will show up again. > > A build from the previous commit 58ddb47 does not show this issue/behavior. > > Can anybody confirm this behavior? It worked OK for me on Arch Linux with a fresh maint build just now. On what platform are you testing? BTW, questions about builds from git are better directed to gnucash-devel than to here. 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.
Re: [GNC] Online Banking setup
> On Feb 12, 2020, at 9:47 AM, Keith Bellairs wrote: > > Just upgraded my Mac from GNC 3.5 to 3.8. Online banking setup was > apparently lost. Online actions for a couple of accounts now report as not > set up. Bummer. They had worked flawlessly before. > > So I went to the online banking tool to set them up again. When I get to > the Retrieve Accounts button, the wizard reports that it worked - > connection to my bank seems to be OK. But no accounts are visible. This was > dead simple in 3.5 so I don't know what I am missing. Along the way in the > wizard I didn't see any accounts in the Accounts tab. Also did not see a > configuration option "Supports Account List Downloads" check box that is > mentioned in the wiki > > I can go back to downloading an OFX so the problem is not critical. But > what happened? A new version of AQBanking that's necessary for German FinTS users but wasn't quite ready for OFX DirectConnect users. Install 3.7 for now, we hope that it will work again for 3.9. 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.
Re: [GNC] Account Currency Screwed Up Again!
The transaction currency in which the value field of every split is denominated is determined by the account in whose register one creates the transaction. If that account is in a non-currency commodity then the currency of first parent account denominated in a currency is used. So in rsbrux's case where he had a stock XYZ under a CHF parent and bought using AUD, the stock split will have an amount in XYZ and a value in CHF and the cash split will have an amount in AUD and a value in CHF. That's a three-way transaction with two prices: XYZ->CHF and AUD->CHF. Both should be recorded in the price database. If he used basic view or was careless about entering the price and values the AUD->CHF price might be 1 and the XYZ->CHF price might have the value of XYZ's price in AUD. Had he instead had the parent of the XYZ account in AUD as he should have or if had created the transaction starting in the cash account then the transaction currency would be AUD and only the stock split would have a price. Regards, John Ralls > On Feb 11, 2020, at 9:42 AM, Adrien Monteleone > wrote: > > My understanding is that the controlling factor is the currency of the > parent, not where you enter the transaction. But I could be mistaken. > > The tree organization is really user dependent. > > I think the Guide uses a slightly different organization where bank/brokerage > lies below with a separate per currency, that > would eliminate one nesting level, but may not be to your liking or use case. > So the result would be: > > Assets - - Investments - type> - - > > You could also do the following: > > Assets - - Investments - - > - > > But neither may feel or look as clean as using a currency level by itself. > > Regards, > Adrien > > > >> On Feb 11, 2020 w7d42, at 3:52 AM, rsbrux via gnucash-user >> wrote: >> >> It was probabably due to my placing the securities accounts under accounts >> in CHF and entering the first transactions in the securities accounts >> instead of in the associated accounts for purchase & sale (see my reply to >> John Rails). Stock quotes retrieved from Yahoo as json do show the correct >> currency, but my AUD investments have been in bonds and ETFs, for which I >> haven't found any online quote sources, The price editor does in fact have >> a currency settting, however, it doesn't have any effect on prices which >> were taken from transactions. I can edit such a price and change the >> currency in the dialog, but when I click "Apply" and "Close", nothing is >> changed. Going through the price database has uncovered several other cases >> where securities transactions were entered with incorrect currencies. To >> prevent future occurences I have now inserted additonal account levels for >> currencies where they were previously missing, even though the resulting >> account structure is even unwieldi e > r than before: >> >> Assets - Investments - - - - >> >> where > dispense with the level. >> >> I did find one price in CHF for a security under a GBP account, but it is >> possible that I had entered the purchase transaction before introducing the >> currency-specific subaccount structure. >> >> Our tax authorities insist on reporting produced by the banks (which costs >> us extra), so the mistakes in my accounting are irrelevant for tax purposes. >> We do have a well-versed Swiss tax accountant and don't have to worry about >> foreign taxes because they are reported in the bank data and generally >> deducted at the origin. >> >> Unfortunately for us, dividends are taxed as income in Switzerland, unless >> they are paid out of corporate reserves as "return of capital". >> > > > ___ > 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] Account Currency Screwed Up Again!
What is the parent account of the three stock accounts and what is the commodity of that parent account? Regards, John Ralls > On Feb 10, 2020, at 5:21 AM, rsbrux via gnucash-user > wrote: > > Many thanks to both of you for your suggestions! > > @Adrien, > > The accounts in question already had the correct currency (AUD) assigned. > The accounts in question are a foreign currency account in AUD, three > accounts for AUD-denominated securities (which I bought/sold in the > above-mentioned foreign currency account), various expense accounts in AUD > and an income account in AUD for interest. The transactions between the > foreign currency account and the expense accounts were recoreded in AUD as > expected. All other transactions were recorded with CHF exchange rates, > although no currency conversions were called for. The prices of two of the > three securities were also recorded in CHF. SInce the GC UI shows all > accounts in AUD (except for the securities accounts, which IIRC, do not have > a currency) it was unclear to me which account(s) I should duplicate. > > @David, > > My default currency is CHF; I live in Switzerland. Trading accounts are > turned on. I have tried to fix this in the XML based on the information you > provided. I tried to look up more information about the file structure, but > the guide <https://www.gnucash.org/viewdoc.phtml?rev=2.6&lang=C&doc=guide> > wasn't much help, and the wiki <https://wiki.gnucash.org/wiki/> appears to be > down. > > IAC, I edited the price records for the two securities which had incorrect > price currencies, as well as all transactions which refenenced any of the > three securities accounts, changing the currencies from CHF to AUD. This > appears to have fixed the problems, but I am keeping a couple of pre-edit > backups, as you recommend. > > Am I the only one to encounter problems like this? > > SInce the problem seems to have been with the (implicitly determined) > currencies of the prices and the transactions, would it be possible to add an > option to the price editor dialog for each price and to the exchange rate > editor for each transaction to change or select the currency? From what I > have learned about the data structure, this looks like the easiest way to > provide a less dangerous way to fix such problems. > >> Date: Mon, 3 Feb 2020 10:31:58 -0600 >> From: Adrien Monteleone >> To: Gnucash Users >> Subject: Re: [GNC] Account Currency Screwed Up Again! >> Message-ID: <821d9637-24ee-4c33-a1bf-792fe55e8...@lusfiber.net> >> Content-Type: text/plain;charset=utf-8 >> >> Would creating a new duplicate account with the proper assigned currency, >> then deleting the old account and choosing to transfer all transactions to >> the new currency work? >> >> That would be significantly easier than manual editing. >> >> I?m not sure how the use of Trading Accounts affects this, or if it should >> or should not be turned on. >> >> >> Regards, >> Adrien >> >>> On Feb 3, 2020 w6d34, at 4:45 AM, David Cousens >>> wrote: >>> >>> Have you checked the default currency used Edit->Preferences, Accounts tab, >>> Default Currency. It is normally set to locale. I guess you are in Australia >>> so it should be AUD. If not, diid you possibly create the book originally >>> while overseas or the locale on your computer was not set to Australia. >>> AFAIK it is not possible to edit the currency of an account once it is >>> created in the Edit Account dialog only in the New Account dialog. >>> >>> It should be possible to edit the file this but fraught with possible >>> problems. Work on a copy of your original file and don't save it over the >>> original until you are really sure that the problem is fixed and other >>> problems haven't been created. I would keep a copy of the original even >>> after you reach this point just to be sure. >>> >>> Your XML file will have to be uncompressed Edit ->Preferences General Tab >>> and uncheck the box which says compress files. You may then have to force a >>> Save. I did this by creating a dummy transaction in a register then hitting >>> the Save button in the toolbar, deleting the dummy transaction and clicking >>> Save again. >>> >>> The section of the XMLfile which contains the commodity information for an >>> account is reproduced below for a SGD account I have. >>> >>> TravelMoney_CC_SGD >>> *7db63ffa514d478191dea006748d7b
Re: [GNC] 3.8 and character set sizing
> On Feb 8, 2020, at 1:28 AM, Finbar Mahon wrote: > > Hello, > > Congrats on 3.8, downloaded and installed and 3.x removed! > > Small question, is there any way to increase the character set size? I cannot > seem to find any instructions, apart from printing. 3.x? For appearance adjustment see https://wiki.gnucash.org/wiki/GTK3. 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.
Re: [GNC] Automatic Retrieval of Quotes not working for Exchange Traded Funds (ETFs)
> On Feb 2, 2020, at 3:31 AM, Peter Marshall via gnucash-user > wrote: > > Automatic Retrieval of Quotes using the Finance::Quotes module is not working > for Exchange Traded Funds (ETFs). For example, I have setup a Security > record for an ETF with: > > Security Information > Full name: Vanguard Mega Cap Growth ETF > Symbol/abbreviation:MGK > Display symbol: MGK > Type: NYSE > ISIN, CUSIP or other code: > Fraction traded:1/1 > Quote Source Information > √ Get Online Quotes > √ Single: Alphavantage, US > Timezone: America/New_York > > I’ve also setup a Security record for a traditional stock with: > > Security Information > Full name: Tesla Inc. > Symbol/abbreviation:TSLA > Display symbol: TSLA > Type: NASDAQ > ISIN, CUSIP or other code: > Fraction traded:1/1 > Quote Source Information > √ Get Online Quotes > √ Single: Alphavantage, US > Timezone: America/New_York > > When I go to the Price Database interface and use the Get Quotes action, I > get an error message: > > Unable to retrieve quotes for these items: > NYSE:MGK > Continue using only the good quotes? > > The problem doesn’t seem to be with Alphavantage. I can use their API and > successfully pull a quote for any ETF. Any idea how to get ETF price quotes > in gnucash? Did you configure your Alphavantage API key into GnuCash's preferences according to https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F? 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.
Re: [GNC] Edit number of recently opened books
GnuCash pays no attention at all to that setting. Regards, John Ralls > On Jan 30, 2020, at 7:17 PM, D via gnucash-user > wrote: > > Have you tried this: > > https://www.howtogeek.com/231700/how-to-change-the-number-of-recent-items-in-os-x/ > > On Jan 31, 2020, 01:43, at 01:43, Greg W wrote: >> I've tried searching around and haven't found anywhere that seems to >> suggest how to edit then number of recently opened books that show up >> in >> the File menu on OSX: >> >> [image: Menubar.png] >> Can I change that 4 to a 6 or more somehow? >> >> Thanks, >> Greg >> >> >> >> >> ___ >> 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] since Catalina, unable to open gnucash
Not only that, while Darwin (the underlying unix core of all Apple operating systems) is BSD Unix, it is *not* Linux and doesn't subscribe to the Linux Foundation or Free Desktop standards. Not that that matters. I just created /opt on my Mac running Catalina, changed the privs to 777, and saved-as then loaded a book with GnuCash. I had at first set GnuCash to have full-disk access, but revoked it and was still able to load the file, so whatever the OP's problem is it isn't having the file in /opt, nor is it about SIP which I leave enabled. Disabling SIP is only needed as a last resort when doing something that requires changing the library load paths (e.g. using $DYLD_LIBRARY_PATH) with a system program (e.g. bash). It's vastly safer to copy the system program into a user directory (I use ~/.local/bin) so that SIP won't mess with it. Regardless, it has nothing at all to do with users running GnuCash. A far more likely cause of the OP's problem is that permissions on /opt have gotten changed so that he no longer can write to the directory. I would expect that if he knows how to create /opt he also knows how to fix that as well as to ensure that it's backed up with Time Machine and whatever cloud backup service he uses. Regards, John Ralls P.S. Bruce Schuck, when you reply to a digest please remember to change the subject back to the original for the particular message to which you're replying. > On Jan 26, 2020, at 9:58 AM, Adrien Monteleone > wrote: > > But /opt isn’t for user data files according to that standard. The user’s own > data should still be under their /users tree. > > For example, you could build LibreOffice and store it in /opt, but your > individual documents would be under /users. (/home in the linux tree) > > I’d say the simpler and safer solution (rather than disabling SIP) is to > relocate the data files to the /Users area where there are no permissions > issues. > > Regards, > Adrien > >> On Jan 26, 2020 w5d26, at 11:46 AM, Bruce Schuck >> wrote: >> >> On 1/26/20 09:00, D wrote: >> >>> And yet, still unanswered is why a user would put their data files into >>> /opt in the first place... >> >> Because OSX is under the hood is very similar to *Nix and BSD systems. >> Those who are putting their data files under /opt are probably doing so >> to follow the Linux Hierarchy Standard. As a long time *Nix geek (first >> introduced to Unix on Gould computers running Gould UTX and AT&T 3B2 >> systems running AT&T Sys V sometime around 1986/1987). Simple answer, >> because they can and they want to. :) >> >> See http://refspecs.linuxfoundation.org/FHS_3.0/fhs/index.html for >> reference. >> >> I mentioned trying "csrutil disable" because I have not yet updated to >> Catalina. Seems it breaks a few things at the office, mainly Cisco >> Anyconnect. Worth a shot I thought. But as someone else mentioned, Apple >> has added layer of filesystem complexity that could be affecting access >> to /opt. I found this: >> https://apple.stackexchange.com/questions/367158/whats-system-volumes-data/367159#367159 >> and https://nektony.com/duplicate-finder-free/folders-permission >> >> - Bruce 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 > 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] Broken QFX import in 3.8
> On Jan 19, 2020, at 5:01 AM, Tom Teixeira wrote: > > On 1/5/20 8:53 AM, Jon Schewe wrote: >> I just got version 3.8 using flatpak and it seems that the QFX import >> is broken. I download my QFX files as usual. Then use the import menu >> item to load the file. However GnuCash maps to one of my stock >> accounts rather than the correct bank account. Version 3.7 worked just >> fine. >> >> Has anyone else seen this? Is there a way around it? >> >> Jon >> > I also ran into this problem and rolled bacl to Version 3.7 > It's due to a change in the import matcher to accommodate AQBanking 6 which had an unintended affect on both file imports and on accounts with sub accounts. https://github.com/Gnucash/gnucash/pull/631 will fix it, we're waiting on testing with FinTS to make sure that it doesn't break that. 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.
Re: [GNC] 3.8 crash on Ubuntu 18.04
> On Jan 18, 2020, at 1:00 PM, Fred Smith wrote: > > Hi all! > > My wife just switched from Win7 to Ubunt 18.04. she has used GnuCash for many > years and is comfortable with what she uses it for. > > I built a 3.8 for here when I set up the system, built on that system, > and until today it has been working fine (built it about 1.5 weeks ago). > > All of a sudden today, when she opens an account and attempts to add a new > entry OR to modify an existing entry she gets an instant crash. > > Here are some of the pertinent entries from system logs: > > from syslog: > Jan 18 15:29:12 carolyn-ThinkCentre-M72e kernel: [189871.138663] > gnucash[20215]: segfault at f0 ip 7f6d11dca1f2 sp 7ffdbdec1418 error > 4 in libgdk-3.so.0.2200.30[7f6d11d83000+eb000] > Jan 18 15:29:12 carolyn-ThinkCentre-M72e kernel: [189871.138675] Code: fe ff > 48 83 c4 40 89 05 dc dc 2a 00 5b 5d 41 5c c3 0f 1f 80 00 00 00 00 48 8b 87 f0 > 00 00 00 c3 0f 1f 84 00 00 00 00 00 31 c0 <48> 39 bf f0 00 00 00 0f 94 c0 c3 > 0f 1f 00 41 55 41 54 55 53 48 89 > Jan 18 15:30:37 carolyn-ThinkCentre-M72e kernel: [189956.002039] > gnucash[20549]: segfault at f0 ip 7fa57dbda1f2 sp 7fff21b341c8 error > 4 in libgdk-3.so.0.2200.30[7fa57db93000+eb000] > Jan 18 15:30:37 carolyn-ThinkCentre-M72e kernel: [189956.002051] Code: fe ff > 48 83 c4 40 89 05 dc dc 2a 00 5b 5d 41 5c c3 0f 1f 80 00 00 00 00 48 8b 87 f0 > 00 00 00 c3 0f 1f 84 00 00 00 00 00 31 c0 <48> 39 bf f0 00 00 00 0f 94 c0 c3 > 0f 1f 00 41 55 41 54 55 53 48 89 > Jan 18 15:31:30 carolyn-ThinkCentre-M72e kernel: [190008.801728] > gnucash[20577]: segfault at f0 ip 7f233fa8a1f2 sp 7fff789f3c28 error > 4 in libgdk-3.so.0.2200.30[7f233fa43000+eb000] > Jan 18 15:31:30 carolyn-ThinkCentre-M72e kernel: [190008.801740] Code: fe ff > 48 83 c4 40 89 05 dc dc 2a 00 5b 5d 41 5c c3 0f 1f 80 00 00 00 00 48 8b 87 f0 > 00 00 00 c3 0f 1f 84 00 00 00 00 00 31 c0 <48> 39 bf f0 00 00 00 0f 94 c0 c3 > 0f 1f 00 41 55 41 54 55 53 48 89 > > from kern.log > Jan 18 15:29:12 carolyn-ThinkCentre-M72e kernel: [189871.138663] > gnucash[20215]: segfault at f0 ip 7f6d11dca1f2 sp 7ffdbdec1418 error > 4 in libgdk-3.so.0.2200.30[7f6d11d83000+eb000] > Jan 18 15:29:12 carolyn-ThinkCentre-M72e kernel: [189871.138675] Code: fe ff > 48 83 c4 40 89 05 dc dc 2a 00 5b 5d 41 5c c3 0f 1f 80 00 00 00 00 48 8b 87 f0 > 00 00 00 c3 0f 1f 84 00 00 00 00 00 31 c0 <48> 39 bf f0 00 00 00 0f 94 c0 c3 > 0f 1f 00 41 55 41 54 55 53 48 89 > Jan 18 15:30:37 carolyn-ThinkCentre-M72e kernel: [189956.002039] > gnucash[20549]: segfault at f0 ip 7fa57dbda1f2 sp 7fff21b341c8 error > 4 in libgdk-3.so.0.2200.30[7fa57db93000+eb000] > Jan 18 15:30:37 carolyn-ThinkCentre-M72e kernel: [189956.002051] Code: fe ff > 48 83 c4 40 89 05 dc dc 2a 00 5b 5d 41 5c c3 0f 1f 80 00 00 00 00 48 8b 87 f0 > 00 00 00 c3 0f 1f 84 00 00 00 00 00 31 c0 <48> 39 bf f0 00 00 00 0f 94 c0 c3 > 0f 1f 00 41 55 41 54 55 53 48 89 > Jan 18 15:31:30 carolyn-ThinkCentre-M72e kernel: [190008.801728] > gnucash[20577]: segfault at f0 ip 7f233fa8a1f2 sp 7fff789f3c28 error > 4 in libgdk-3.so.0.2200.30[7f233fa43000+eb000] > Jan 18 15:31:30 carolyn-ThinkCentre-M72e kernel: [190008.801740] Code: fe ff > 48 83 c4 40 89 05 dc dc 2a 00 5b 5d 41 5c c3 0f 1f 80 00 00 00 00 48 8b 87 f0 > 00 00 00 c3 0f 1f 84 00 00 00 00 00 31 c0 <48> 39 bf f0 00 00 00 0f 94 c0 c3 > 0f 1f 00 41 55 41 54 55 53 48 89h > > Can anyone help here? > > Is there any other info I can provide, or other steps I can do to help > diagnose this? > > Thanks in advance! It's probably https://gitlab.gnome.org/GNOME/gtk/issues/61. If you know how you can take a stack trace to be sure. The work-around is to set GTK_IM_MODULE=ibus in the environment. 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.
Re: [GNC] AQBanking wizard
> On Jan 12, 2020, at 10:10 AM, randix wrote: > > Can't believe I'm re-visiting this again, lol. Goes to show what happens > when you find extra time for a change (I haven't experienced this phenomenon > for many years) (triple sigh). I'm currently running Windows 10, GnuCash > Version: 3.8, Build ID: 3.8b+(2019-12-29), Finance::Quote: 1.49. Everything > works fine except aqbanking and yes, I do understand that the latest version > is not compatible with Gnucash 3, etc. I get that... *I'm taking from your > prior posts that one can get aqbanking to work w GnuCash 3.8 if one installs > an older version of Aqbanking.* From your last post, I believe you indicate > that's either 5.82 or 5.78. > > Ok, so per your earlier post, I was pulling what's left of my hair searching > hopelessly for Aqbanking 5.20, and then just noticed by accident that you > had made a further reply to the thread, correcting your prior post, > indicating that I should (???) be looking for either Aqbanking 5.8.2 or > 5.7.8, not 5.20. So: > > 1. First I did a search on my laptop, and found references to prior versions > of Aqbanking, including 5.7 and 5.8 (see the attachment to this message > post). Am I correct that my recent install of 3.8 does not include the > necessary aqbanking files to install prior versions of it? If I'm wrong, > how do I install those older versions from what's on my laptop; and if I'm > right, then I assume I need to download one of the older versions (see #2, > below). > > 2. Ok, so then I did a google search, and found a reference to aqbanking > 5.8.2-1 at the following link: > https://www.archlinux.org/packages/community/x86_64/aqbanking/ > <https://www.archlinux.org/packages/community/x86_64/aqbanking/> . From > the mirror site referenced at that site, it looks like I'd be downloading: > *aqbanking-5.8.2-1-x86_64.pkg.tar*. I assume once I extract the files I'll > find an install file to install the older version of aqbanking, and > thereafter the clouds will part, the birds will chirp, and I can stop > manually updating my accounts. For now, I'll sit on my hands. > > When you have a free moment, if you could tell me if I'm on the right path > or not, would be great, but in any event, enjoy the rest of your Sunday!!! > /(and thanks for all the help you've provided before in this forum, over the > years on so many subjects relating to GnuCash)/. > No, the Windows AIO has only the AQBanking 5.99 binaries. It's an installer, not a package manager. No, the files on acquamaniac.de are source files. They must be compiled before they can be used. I was mistaken about being able to fix it by copying in the AQBanking files from an older build: AQBanking 5.99 has a different API and the use of that API is determined at GnuCash build time so you'd need to rebuild GnuCash as well as copy in the files. At that point you might as well just do a build from source. Sorry. Note that this affects only OFX DirectConnect. You can still download OFX, QFX, or QIF files from your bank's website and use File>Import. I also mis-remembered about when we started with AQBanking 5.99 on Windows: It was immediately *after*, not before, releasing GnuCash 3.7. That's the version to reinstall if you really want AQBanking. 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.
Re: [GNC] Navigation in register window
Adrien, I suppose that you tested in a register. Does it behave the way you expect in a dialog box entry? I don't see any likely open bugs, but if it doesn't work in a dialog box entry either it's a Gtk problem rather than a GnuCash one. Regards, John Ralls > On Jan 10, 2020, at 11:26 AM, Adrien Monteleone > wrote: > > Thanks John, I think I had found those some moons ago but forgot them—glad to > know they are supposed to work with GnuCash. > > Ah, I spoke too soon. > > page-up/down work, but home/end do not. > > I can fn-shift-right/left and select the text then hit the same arrow again > to achieve the effect, but without `shift` nothing happens. > > I do have a non-Apple extended keyboard I just plugged in to test. It seems > home/end don’t work for it either. But shift-home/end appropriately selects > the entire text and then I can use the appropriate arrow key to get what I > want. (yes, I tested home/end in terminal.app as a test with both keyboards > and they worked as they should) > > Bug? Already filed? > > Regards, > Adrien > >> On Jan 10, 2020 w2d10, at 11:03 AM, John Ralls wrote: >> >> >> >>> On Jan 9, 2020, at 11:41 PM, Adrien Monteleone >>> wrote: >>> >>> I’d offer a shorter specific answer with the exact shortcut, but as I am >>> stuck without an extended keyboard, I don’t use those two. >> >> fn-up-arrow, fn-down-arrow, fn-left-arrow, and fn-right-arrow are page up, >> page down, home, and end respectively on the Mac keyboard without a keypad. >> >> 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. ___ 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] Sync with Mobile
> On Jan 10, 2020, at 7:54 AM, Don Ireland wrote: > > I just saw a link on the gnucash website about a book on using gnucash. I > have a quick question. The book description (at the link) says "Capture > expenses using your mobile phone." > > I was under the impression there wasn't a way to sync the desktop with > mobile. Am I misunderstanding something? > > Sync with mobile is one thing I've been waiting for. There is a separate application, GnuCash for Android, that has some ability to create transactions on an Android device and sync them with desktop GnuCash. It's a separate project and hasn't had any maintenance for about 18 months so it's hard to recommend it. 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.
Re: [GNC] Navigation in register window
> On Jan 9, 2020, at 11:41 PM, Adrien Monteleone > wrote: > > I’d offer a shorter specific answer with the exact shortcut, but as I am > stuck without an extended keyboard, I don’t use those two. fn-up-arrow, fn-down-arrow, fn-left-arrow, and fn-right-arrow are page up, page down, home, and end respectively on the Mac keyboard without a keypad. 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.
Re: [GNC] (no subject)
A# ? > On Jan 8, 2020, at 11:42 PM, D via gnucash-user > wrote: > > Bb > ___ > 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] v3.8 AQBanking in the US
> On Jan 8, 2020, at 8:41 AM, Derek Atkins wrote: > > John Ralls writes: > >> No. OFX Direct Connect is a way of connecting GnuCash directly to the >> bank and retrieving the account, balance, and transaction data >> directly into GnuCash. >> >> In addition to a working AQBanking it requires that your bank provide >> the service and that it reveals enough information that you can >> configure AQBanking to connect to it. > > There used to be an OFXHome website that had a database of all that > information. > > It's really too bad that we can't help support this work. But I don't > have/use OFX-DC myself. https://ofxhome.com is alive and well. 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.
Re: [GNC] AQBanking wizard
> On Jan 8, 2020, at 7:12 AM, Fred Smith wrote: > > On Wed, Jan 08, 2020 at 09:49:18AM -0500, Ken Schneider wrote: >> On 1/7/20 10:18 PM, John Ralls wrote: >>> >>> >>>> On Jan 7, 2020, at 5:11 PM, randix wrote: >>>> >>>> John Ralls-2 wrote >>>>> You need to revert to AQBanking 5.20 to use OFX. OFX is broken in 5.99. > > How about 5.7.8? Broken there too? Sorry, I scrambled the version number. The current AQBanking stable is 5.8.2 and the old-stable is 5.7.8. Both work fine with OFX. The current Gwenhywfar stable is 4.20.2. 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.
Re: [GNC] AQBanking wizard
> On Jan 7, 2020, at 5:11 PM, randix wrote: > > John Ralls-2 wrote >> You need to revert to AQBanking 5.20 to use OFX. OFX is broken in 5.99. >> >> Regards, >> John Ralls > > Where is the best and safest place to download AQBanking 5.20? I guess that depends on what you need. If you want source, the developer's website is https://aquamaniac.de. If you need binaries, your distro's package manager is the best place. If you want to do surgery on the GnuCash 3.8 bundles, get either Gnucash-Intel-3.7-1.dmg (Mac) or gnucash-3.6.setup.exe(Windows) from the usual places. You need libaqbanking, libgwenhywfar, and the contents of lib/aqbanking, lib/gwenhywfar, share/aqbanking, and share/gwenhywfar. 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.
Re: [GNC] Suggested source for LibOFX?
That would be my guess. Regards, John Ralls > On Jan 7, 2020, at 3:05 PM, Bennie wrote: > > John - thanks to your guidance. I think I'm on the right track. I assume the > ONLINE ACTIONS/GET TRANSACTIONS was actually grayed out as I had not yet set > up a userid/account. Working on that now. > > On 1/7/2020 4:59 PM, John Ralls wrote: >> Bennie, >> >> Thanks, I've removed that part and modernized the rest of the intro a bit. >> >> Regards, >> John Ralls >> >>> On Jan 7, 2020, at 1:36 PM, Bennie wrote: >>> >>> John - one other point of information to highlight how I would up where I >>> am. Looking at the URL: >>> https://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect >>> >>> I find the below - based on reading the below, I still come away thinking I >>> need to --enable-hbci. Based on your input, I'll trying installing >>> AQBanking, start GNUCash the usual way and see what happens. >>> >>> Thanks again for the input >>> >>> AqBanking >>> >>> GnuCash now uses AqBanking as a means to handle connections to financial >>> institutions. GnuCash must be configured using --enable-hbci and >>> --enable-ofx in order for OFXDirectConnect to be available. Note: >>> --enable-hbci is really two things at once. It means --enable-aqbanking and >>> --enable-hbci. Although there isn't an --enable-aqbanking per se. But you >>> need AqBanking for DirectConnect, which is why you need to --enable-hbci. >>> >>> AqBanking has its own setup wizard for the purpose of setting up account >>> identification and user login ID for your online connections. This page is >>> intended to document how to use this wizard to enable you to download data >>> directly from your bank or credit card company into the appropriate GnuCash >>> register. >>> >>> You must have Libofx 0.8.2 or higher and AqBanking 2.0.0 or higher to user >>> OFXDirectConnect in Gnucash >>> >>> On 1/7/2020 12:42 PM, John Ralls wrote: >>>> What you read is clearly obsolete because `--enable-hbci` is for the >>>> autotools build system that we don't use anymore. We now use cmake and >>>> AQBanking is enabled by default if AQBanking is found. >>>> >>>> Have you built GnuCash yourself from source? >>>> >>>> Have you checked with >>>> https://ofxhome.com >>>> to make sure that your banks even support OFX DirectConnect? Be sure to >>>> check the verification at the bottom, about 1/3 of the banks in there no >>>> longer support it. >>>> >>>> Regards, >>>> John Ralls >>>> >>>> >>>> >>>> >>>> >>>>> On Jan 7, 2020, at 9:29 AM, Bennie >>>>> wrote: >>>>> >>>>> Hi John, >>>>> >>>>> I'm trying to get direct downloads working from my bank/credit card >>>>> companies. In reading the info about GNUCash, I read that I need to >>>>> --enable-hbci which further indicated I need libofx and AQBanking. I'm >>>>> researching sources as I found multiple repositories with libofx in it >>>>> when I google libofx. >>>>> >>>>> On 1/7/2020 10:49 AM, John Ralls wrote: >>>>> >>>>>>> On Jan 7, 2020, at 8:43 AM, Bennie >>>>>>> wrote: >>>>>>> >>>>>>> John - thanks for the response. I was looking for libOFX as I thought >>>>>>> it was listed as a prerequisite (along with AQBanking) for direct >>>>>>> connection to bank accounts. Did I miss something on the pre-reqs? >>>>>>> >>>>>>> On 1/7/2020 10:42 AM, John Ralls wrote: >>>>>>> >>>>>>>>> On Jan 6, 2020, at 9:33 AM, Bennie Gibson >>>>>>>>> wrote: >>>>>>>>> >>>>>>>>> I'm a new GNUCash user and would like to get OFXDirect working. >>>>>>>>> Wondering where most folks get LibOFX. SourceForge seems the most >>>>>>>>> "official" looking but want to feel more comfortable about the source >>>>>>>>> of this library. >>>>>>>>> >>>>>>>> libofx doesn't support OFX DirectConnect. We use AQBanking for that. >>>>>>>> >>>>>>>> That aside, Benoit isn't using SourceForge any more, he's moved the >>>>>>>> project to Github: >>>>>>>> https://github.com/libofx/libofx >>>>>> It's a prerequisite for importing OFX files and unlike AQBanking it's >>>>>> not optional. >>>>>> >>>>>> What exactly do you want to do? Studying sources isn't normal user >>>>>> activity. >>>>>> >>>>>> 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.
Re: [GNC] Suggested source for LibOFX?
Bennie, Thanks, I've removed that part and modernized the rest of the intro a bit. Regards, John Ralls > On Jan 7, 2020, at 1:36 PM, Bennie wrote: > > John - one other point of information to highlight how I would up where I am. > Looking at the URL: https://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect > > I find the below - based on reading the below, I still come away thinking I > need to --enable-hbci. Based on your input, I'll trying installing > AQBanking, start GNUCash the usual way and see what happens. > > Thanks again for the input > > AqBanking > > GnuCash now uses AqBanking as a means to handle connections to financial > institutions. GnuCash must be configured using --enable-hbci and --enable-ofx > in order for OFXDirectConnect to be available. Note: --enable-hbci is really > two things at once. It means --enable-aqbanking and --enable-hbci. Although > there isn't an --enable-aqbanking per se. But you need AqBanking for > DirectConnect, which is why you need to --enable-hbci. > > AqBanking has its own setup wizard for the purpose of setting up account > identification and user login ID for your online connections. This page is > intended to document how to use this wizard to enable you to download data > directly from your bank or credit card company into the appropriate GnuCash > register. > > You must have Libofx 0.8.2 or higher and AqBanking 2.0.0 or higher to user > OFXDirectConnect in Gnucash > > On 1/7/2020 12:42 PM, John Ralls wrote: >> What you read is clearly obsolete because `--enable-hbci` is for the >> autotools build system that we don't use anymore. We now use cmake and >> AQBanking is enabled by default if AQBanking is found. >> >> Have you built GnuCash yourself from source? >> >> Have you checked with >> https://ofxhome.com >> to make sure that your banks even support OFX DirectConnect? Be sure to >> check the verification at the bottom, about 1/3 of the banks in there no >> longer support it. >> >> Regards, >> John Ralls >> >> >> >> >> >>> On Jan 7, 2020, at 9:29 AM, Bennie >>> wrote: >>> >>> Hi John, >>> >>> I'm trying to get direct downloads working from my bank/credit card >>> companies. In reading the info about GNUCash, I read that I need to >>> --enable-hbci which further indicated I need libofx and AQBanking. I'm >>> researching sources as I found multiple repositories with libofx in it when >>> I google libofx. >>> >>> On 1/7/2020 10:49 AM, John Ralls wrote: >>> >>>>> On Jan 7, 2020, at 8:43 AM, Bennie >>>>> wrote: >>>>> >>>>> John - thanks for the response. I was looking for libOFX as I thought it >>>>> was listed as a prerequisite (along with AQBanking) for direct connection >>>>> to bank accounts. Did I miss something on the pre-reqs? >>>>> >>>>> On 1/7/2020 10:42 AM, John Ralls wrote: >>>>> >>>>>>> On Jan 6, 2020, at 9:33 AM, Bennie Gibson >>>>>>> wrote: >>>>>>> >>>>>>> I'm a new GNUCash user and would like to get OFXDirect working. >>>>>>> Wondering where most folks get LibOFX. SourceForge seems the most >>>>>>> "official" looking but want to feel more comfortable about the source >>>>>>> of this library. >>>>>>> >>>>>> libofx doesn't support OFX DirectConnect. We use AQBanking for that. >>>>>> >>>>>> That aside, Benoit isn't using SourceForge any more, he's moved the >>>>>> project to Github: >>>>>> https://github.com/libofx/libofx >>>> It's a prerequisite for importing OFX files and unlike AQBanking it's not >>>> optional. >>>> >>>> What exactly do you want to do? Studying sources isn't normal user >>>> activity. >>>> >>>> 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.
Re: [GNC] AQBanking wizard
You need to revert to AQBanking 5.20 to use OFX. OFX is broken in 5.99. Regards, John Ralls > On Jan 7, 2020, at 9:22 AM, Kenneth Schneider > wrote: > > I have 5.99.44 installed. The same for AqBanking-ofx. > > Ken Schneider > >> On Jan 7, 2020, at 11:49 AM, Frank H. Ellenberger >> wrote: >> >> Hello Ken, >> >>> Am 07.01.20 um 15:59 schrieb Ken Schneider: >>> I'm currently using: >>> >>> GNUCash >>> Version: 3.7 >>> Build ID: 3.7+(2019-09-07) >>> Finance::Quote: 1.47 >> >>> When trying to launch the AQBanking wizard I get no response when I >>> click the button. Was this disabled (poor memory) recently due to issues >>> with online banking. >>> >>> Ken >>> openSUSE Tumbleweed, latest >> >> and which versions of the AqBanking family got installed? Most recent >> are aqbanking-5.99.44beta, gwenhywfar-4.99.25rc9, libchipcard-5.1.4rc1. >> >> Regards >> Frank >> > > ___ > 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] Suggested source for LibOFX?
What you read is clearly obsolete because `--enable-hbci` is for the autotools build system that we don't use anymore. We now use cmake and AQBanking is enabled by default if AQBanking is found. Have you built GnuCash yourself from source? Have you checked with https://ofxhome.com to make sure that your banks even support OFX DirectConnect? Be sure to check the verification at the bottom, about 1/3 of the banks in there no longer support it. Regards, John Ralls > On Jan 7, 2020, at 9:29 AM, Bennie wrote: > > Hi John, > > I'm trying to get direct downloads working from my bank/credit card > companies. In reading the info about GNUCash, I read that I need to > --enable-hbci which further indicated I need libofx and AQBanking. I'm > researching sources as I found multiple repositories with libofx in it when I > google libofx. > > On 1/7/2020 10:49 AM, John Ralls wrote: >> >>> On Jan 7, 2020, at 8:43 AM, Bennie wrote: >>> >>> John - thanks for the response. I was looking for libOFX as I thought it >>> was listed as a prerequisite (along with AQBanking) for direct connection >>> to bank accounts. Did I miss something on the pre-reqs? >>> >>> On 1/7/2020 10:42 AM, John Ralls wrote: >>>>> On Jan 6, 2020, at 9:33 AM, Bennie Gibson >>>>> wrote: >>>>> >>>>> I'm a new GNUCash user and would like to get OFXDirect working. >>>>> Wondering where most folks get LibOFX. SourceForge seems the most >>>>> "official" looking but want to feel more comfortable about the source of >>>>> this library. >>>> libofx doesn't support OFX DirectConnect. We use AQBanking for that. >>>> >>>> That aside, Benoit isn't using SourceForge any more, he's moved the >>>> project to Github: https://github.com/libofx/libofx >> It's a prerequisite for importing OFX files and unlike AQBanking it's not >> optional. >> >> What exactly do you want to do? Studying sources isn't normal user activity. >> >> 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.
Re: [GNC] Suggested source for LibOFX?
> On Jan 7, 2020, at 8:43 AM, Bennie wrote: > > John - thanks for the response. I was looking for libOFX as I thought it was > listed as a prerequisite (along with AQBanking) for direct connection to bank > accounts. Did I miss something on the pre-reqs? > > On 1/7/2020 10:42 AM, John Ralls wrote: >> >>> On Jan 6, 2020, at 9:33 AM, Bennie Gibson wrote: >>> >>> I'm a new GNUCash user and would like to get OFXDirect working. >>> Wondering where most folks get LibOFX. SourceForge seems the most >>> "official" looking but want to feel more comfortable about the source of >>> this library. >> libofx doesn't support OFX DirectConnect. We use AQBanking for that. >> >> That aside, Benoit isn't using SourceForge any more, he's moved the project >> to Github: https://github.com/libofx/libofx It's a prerequisite for importing OFX files and unlike AQBanking it's not optional. What exactly do you want to do? Studying sources isn't normal user activity. 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.
Re: [GNC] Download Intel 3.8-3 will start shortly
> On Jan 7, 2020, at 3:10 AM, Jack Whyte wrote: > > I'm currently using version 3.7 and trying to upgrade to 3.8-3 but when I > reach the download page on Source Forge, I get a message "Your download > will start shortly" but it does not do so? > > I'm on MAC OS Catalina 10.15.2 using Chrome browser - any advice or > guidance would be much appreciated. Try Github? https://github.com/Gnucash/gnucash/releases/download/3.8b/Gnucash-Intel-3.8-3.dmg 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.
