Re: [GNC] Scheduled Transactions status cannot be changed
That appears to be different behavior from what I'm seeing. I've opened https://bugs.gnucash.org/show_bug.cgi?id=799180 for the variable value issue. https://bugs.gnucash.org/show_bug.cgi?id=799179 is close, however I'm not getting a crash. On Thu, 2023-12-21 at 10:21 -0800, john wrote: > I think https://bugs.gnucash.org/show_bug.cgi?id=799179 covers it. > > Regards, > John Ralls > > > > On Dec 21, 2023, at 05:55, Jon Schewe wrote: > > > > Has anyone filed a bug for this problem of not being able to enter > > variables? I'll enter one, but didn't want to double up. When I did > > a > > search I didn't find one, but could be using poor keywords. > > > > On Tue, 2023-12-19 at 19:40 -0500, lj wrote: > > > I am also unable to change the SX status in the SLR dialog. > > > Using Linux (64 bit), Gnucash-5.5 built from source. > > > > > > Also unable to enter a value for a place-holder in the SX. Double- > > > click > > > on the placeholder, enter a value, press Enter and it reverts to > > > "(Need > > > Value)". Release notes indicate a change using the dialog's OK > > > button > > > but that doesn't seem to do anything either. > > > > > > On 12/19/23 12:31, Richard De Vriese wrote: > > > > I just installed GnuCash 5.5 yesterday (upgraded from 5.4.1) > > > > and > > > > noticed > > > > that I am not able to change the status of Scheduled > > > > Transactions > > > > from the > > > > Actions | Scheduled Transactions | Since Last Run dialog box. > > > > When > > > > I click > > > > on the status field of any of the transactions in the Since > > > > Last > > > > Run.. > > > > dialog I see the pop up menu listing (Ignored, Postponed, To > > > > Create, > > > > Reminder), but if I click on one any of them, the new status is > > > > not > > > > saved. > > > > > > > > I'm running GnuCash on Windows 11, latest patches, on an Intel > > > > Core > > > > i7-10700 CPU. > > > > > > > > I have had to downgrade to version 5.4.1 to get the scheduled > > > > Transaction > > > > functionality working. > > > > > > > > > ___ > > > gnucash-user mailing list > > > gnucash-user@gnucash.org > > > To update your subscription preferences or to unsubscribe: > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > > - > > > Please remember to CC this list on all your replies. > > > You can do this by using Reply-To-List or Reply-All. > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > - > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Scheduled Transactions status cannot be changed
Has anyone filed a bug for this problem of not being able to enter variables? I'll enter one, but didn't want to double up. When I did a search I didn't find one, but could be using poor keywords. On Tue, 2023-12-19 at 19:40 -0500, lj wrote: > I am also unable to change the SX status in the SLR dialog. > Using Linux (64 bit), Gnucash-5.5 built from source. > > Also unable to enter a value for a place-holder in the SX. Double- > click > on the placeholder, enter a value, press Enter and it reverts to > "(Need > Value)". Release notes indicate a change using the dialog's OK > button > but that doesn't seem to do anything either. > > On 12/19/23 12:31, Richard De Vriese wrote: > > I just installed GnuCash 5.5 yesterday (upgraded from 5.4.1) and > > noticed > > that I am not able to change the status of Scheduled Transactions > > from the > > Actions | Scheduled Transactions | Since Last Run dialog box. When > > I click > > on the status field of any of the transactions in the Since Last > > Run.. > > dialog I see the pop up menu listing (Ignored, Postponed, To > > Create, > > Reminder), but if I click on one any of them, the new status is not > > saved. > > > > I'm running GnuCash on Windows 11, latest patches, on an Intel Core > > i7-10700 CPU. > > > > I have had to downgrade to version 5.4.1 to get the scheduled > > Transaction > > functionality working. > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] USAA OFX Direct connect stopped working
I just tried going through the setup page again and I was able to retrieve my accounts from USAA during the setup. However after that when I try and download transactions I get the following: Status for signon request: General error (Code 2000, severity "ERROR") Error other than those specified by the remaining error codes. (Note: Servers should provide a more specific error whenever possible. Error code 2000 should be reserved for cases in which a more specific code is not available.) Status for transaction statement request: Signon invalid (Code 15500, severity "ERROR") The user cannot signon because he or she entered an invalid user ID or password. Unlocking customer "4" Any other suggestions? Jon On Tue, 2023-07-18 at 10:12 -0700, John Ralls wrote: > BTW, I also got the invalid signon from USAA this morning. I repeated > the drill at > https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#USAA a > nd got the exact same access id and pin. Once completed I was able to > retrieve my transactions. > > Regards, > John Ralls > > > > On Jul 18, 2023, at 9:15 AM, john wrote: > > > > Access id is configured in the AQBanking setup wizard accessed from > > Tools>Online Banking Setup. The PIN is collected every time you run > > Actions>Online>Get Transactions unless you told GnuCash to remember > > it. If you did you can tell it to forget from Preferences>Online > > Banking. > > > > Regards, > > John Ralls > > > > > > > On Jul 17, 2023, at 20:41, Daffy Duck > > > wrote: > > > > > > Ok, as of today, I can no longer use the online download again. > > > > > > 22:35:38 Status for signon request: General error (Code 2000, > > > severity "ERROR") > > > Error other than those specified by the remaining error codes. > > > (Note: Servers should provide a more specific error whenever > > > possible. Error code 2000 should be reserved for cases in which a > > > more specific code is not available.) > > > 22:35:38 Status for account info request: Signon invalid (Code > > > 15500, severity "ERROR") > > > The user cannot signon because he or she entered an invalid user > > > ID or password. > > > > > > And the problem is, I can't find the info on how to set ACCESS > > > ID: and ACCESS PIN: so I can do it over again. > > > > > > Any ideas? > > > > > > On Mon, 2022-08-22 at 09:18 -0700, John Ralls wrote: > > > > > > > > > On Aug 21, 2022, at 8:13 PM, john > > > > > mailto:jra...@ceridwen.us>> wrote: > > > > > > > > > > > > > > > > > > > > > On Aug 21, 2022, at 7:54 PM, Daffy Duck > > > > > > mailto:suffsuccot...@gmail.com>> > > > > > > wrote: > > > > > > > > > > > > Hello, > > > > > > > > > > > > A while back, USAA changed their OFX stuff and there had to > > > > > > be a > > > > > > workaround with a PIN, etc. > > > > > > > > > > > > I did that, without a problem, but I just noticed today it > > > > > > has broken > > > > > > again? > > > > > > > > > > > > This is the output: > > > > > > > > > > > > AqBanking v6.5.2.0stable > > > > > > Sending jobs to the bank(s) > > > > > > Sorting commands by account > > > > > > Sorting account queues by provider > > > > > > Send commands to providers > > > > > > Send commands to provider "aqofxconnect" > > > > > > Locking customer "1299" > > > > > > Sending request... > > > > > > Connecting to server... > > > > > > Resolving hostname "df3cx-services.1fsapi.com" ... > > > > > > IP address is "45.60.151.211" > > > > > > Connecting to "df3cx-services.1fsapi.com" > > > > > > Connected to "df3cx-services.1fsapi.com" > > > > > > Using GnuTLS default ciphers. > > > > > > TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-128- > > > > > > GCM:AEAD > > > > > > Connected. > > > > > > Sending message... > > > > > > Message sent. > > > > > > Waiting for response... > > > > > > Receiving response... > > > > > > HTTP-Status: 200 () > > > > > > Response received. > > > > > > Disconnecting from server... > > > > > > Disconnected. > > > > > > Parsing response... > > > > > > Status for signon request: Success (Code 0, severity > > > > > > "INFO") > > > > > > The server successfully processed the request. > > > > > > Status for transaction statement request: General error > > > > > > (Code 2000, > > > > > > severity "ERROR") > > > > > > Error other than those specified by the remaining error > > > > > > codes. (Note: > > > > > > Servers should provide a more specific error whenever > > > > > > possible. Error > > > > > > code 2000 should be reserved for cases in which a more > > > > > > specific code is > > > > > > not available.) > > > > > > Unlocking customer "1299" > > > > > > -- > > > > > > > > > > > > any ideas? > > > > > > > > > > First, try again tomorrow on the off chance USAA had a server > > > > > outage over the weekend. If it still fails, turn on OFX > > > > > logging (see > > > > > https://wiki.gnucash.org/wiki/AqBanking#Debugging) and > > > > > capture the actual OFX response. Edit it to remove your > > > > > actual account number and credentials then post
Re: [GNC] Problem with using Python with version 5.1
Bob, Did you install GnuCash using Flatpak or via a deb file? Also are you certain that you're executing "python3" and not "python", which may execute python2. This is what I see on Ubuntu 22. >apt list --installed '*gnucash*' Listing... Done gnucash-common/jammy,now 1:4.8-1build2 all [installed] gnucash-docs/jammy,now 4.8-1 all [installed,automatic] gnucash/jammy,now 1:4.8-1build2 amd64 [installed,automatic] python3-gnucash/jammy,now 1:4.8-1build2 amd64 [installed] >python3 Python 3.10.6 (main, Mar 10 2023, 10:55:28) [GCC 11.3.0] on linux Type "help", "copyright", "credits" or "license" for more information. >>> import gnucash >>> Note that I also have GnuCash installed via Flatpak and that's the GUI that I use. I need to figure out how to update my environment to execute python scripts against the flatpak as I expect that eventually the 4.8 libraries won't be able to read the 5.X files. Jon On Sun, 2023-05-28 at 12:55 -0400, Bob Reite wrote: > I am trying to run python scripts to import data from Quickbooks, but > I > get the following error: > > ImportError: No module named gnucash. > > Phthon3-guncash is installed. > > System is Linux Mint 20 Ulyana > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Account Total balance for stocks
I have my accounts page setup to show the "Total" and "Total (USD)" columns. I had thought that the "Total (USD)" column would take the number of shares times the current price and show that as the balance. It doesn't appear that's the case. The "Total (USD)" column has a different value than the "Total" column, but it's not correct. However when I look at a graph of my account balance over time, that graph is doing what appears to be the correct calculation and multiplying the current number of shares by the current share price. Am I missing something in the configuration of this column? Or this the design and I'm looking for a different column? Jon ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] defining key strokes
Both MacOS and Windows are case-preserving, case-insensitive filesystems. This means that when you create a file or directory, the case (upper or lower) of each character is preserved in the name. However when looking for a file or directory the case doesn't matter "GnuCash" and "Gnucash" are equivalent. One can create a case-sensitive filesystem on MacOs if desired, although the system volume should still be case-insensitive as there are many applications that assume the filesystem is case-insensitive. Linux has a case-sensitive filesystem which allows one to have a /home/user/GnuCash and /home/user/Gnucash as 2 different directories. On Sun, 2023-04-09 at 22:27 -0400, Ken Farley wrote: > Turns out MacOS shows directories with specific cases, but if you cd > down one with different case characters it kind of does an "alias on > the > fly". If I cd using "GNUCASH" or "GNUcash" or whatever mix of > characters > I chose (i.e. "GnUcAsH") it will cd into the directory just fine and > spit back the new character string if I issue a "pwd" command. MacOS > has > apparently changed what I considered normal behavior, likely to > accommodate someone, maybe Windows users? I don't know. Weird. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Fetching quotes with flatpak
When specifying the namespace it works. Good to know there is a bug report about this. I've subscribed to it so that I know when it's been fixed. On Sun, 2023-04-02 at 19:24 +, Murugan Muruganandam wrote: > Can you run this in debug mode and see what error you are getting > > gnucash-cli --debug --quotes get --namespace from securities editor> > > > > Saludos Cordiales > > Murugan > From: Jon Schewe > Sent: Sunday, April 2, 2023 2:48 PM > To: Murugan Muruganandam ; gnucash- > u...@gnucash.org > Subject: Re: [GNC] Fetching quotes with flatpak > > That works as expected > > > flatpak run --command=gnucash-cli org.gnucash.GnuCash --verbose -Q > dump yahoo_json acn > acn: > date => 03/31/2023 > pe => 26.31768 > type => EQUITY > isodate => 2023-03-31 > low => 282.61 > year_range => 242.8 - 345.3 > high => 285.96 > symbol => acn > open => 283.12 > eps => 10.86 > exchange => Sourced from Yahoo Finance (as JSON) > success => 1 > div_yield => 1.5318757 > name => acn (Accenture plc) > method => yahoo_json > volume => 3009370 > currency => USD > last => 285.81 > close => 282.66 > > > On Sun, 2023-04-02 at 18:05 +, Murugan Muruganandam wrote: > > can you try the following and check > > > > gnucash-cli --verbose -Q dump yahoo_json acn > > > > > > > > Saludos Cordiales > > > > Murugan > > > > From: gnucash-user > bounces+m.muruganandam=hotmail@gnucash.org> on behalf of Jon > > Schewe > > Sent: Sunday, April 2, 2023 10:53 AM > > To: gnucash-user@gnucash.org > > Subject: [GNC] Fetching quotes with flatpak > > > > I'm looking to use gnucash-cli to fetch quotes, however I'm told > > I'm > > missing a parameter. The commandline help documentation states to > > use > > "get" and then the datafile. I believe that I've done it correctly > > here, what am I missing? > > > > > flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes > > > get > > /home/jpschewe/Documents/banking/gnucash/accounts.gnucash > > Missing data file parameter > > > > Thank you, > > Jon > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > - > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Fetching quotes with flatpak
That works as expected >flatpak run --command=gnucash-cli org.gnucash.GnuCash --verbose -Q dump yahoo_json acn acn: date => 03/31/2023 pe => 26.31768 type => EQUITY isodate => 2023-03-31 low => 282.61 year_range =>242.8 - 345.3 high => 285.96 symbol => acn open => 283.12 eps => 10.86 exchange => Sourced from Yahoo Finance (as JSON) success => 1 div_yield => 1.5318757 name => acn (Accenture plc) method => yahoo_json volume => 3009370 currency => USD last => 285.81 close => 282.66 On Sun, 2023-04-02 at 18:05 +, Murugan Muruganandam wrote: > can you try the following and check > > gnucash-cli --verbose -Q dump yahoo_json acn > > > > Saludos Cordiales > > Murugan > > From: gnucash-user bounces+m.muruganandam=hotmail@gnucash.org> on behalf of Jon > Schewe > Sent: Sunday, April 2, 2023 10:53 AM > To: gnucash-user@gnucash.org > Subject: [GNC] Fetching quotes with flatpak > > I'm looking to use gnucash-cli to fetch quotes, however I'm told I'm > missing a parameter. The commandline help documentation states to use > "get" and then the datafile. I believe that I've done it correctly > here, what am I missing? > > > flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get > /home/jpschewe/Documents/banking/gnucash/accounts.gnucash > Missing data file parameter > > Thank you, > Jon > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Fetching quotes with flatpak
I'm looking to use gnucash-cli to fetch quotes, however I'm told I'm missing a parameter. The commandline help documentation states to use "get" and then the datafile. I believe that I've done it correctly here, what am I missing? >flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get /home/jpschewe/Documents/banking/gnucash/accounts.gnucash Missing data file parameter Thank you, Jon ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Flatpak ldconfig error
When I run flatpak to get quotes I get a warning about a scheme file not being an ELF file. Is this a bug in the packaging or expected based on how flatpak works? >flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get ~/Documents/banking/gnucash/accounts.gnucash ldconfig: /app/lib/libguile-2.2.so.1.3.0-gdb.scm is not an ELF file - it has the wrong magic bytes at the start. Thanks ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Example of importing Stock transactions from CSV
My accounts were created before GnuCash defaulted to setting the top level accounts as placeholders. So yes, my Expenses account will allow transactions to use it. When I get to the "Match Transactions" step, none of the transactions have transfer accounts. When click the Add column and then try and select an Asset account (ie. my retirement cash account for a purchase), I get the error: The account "401k" has a different commodity to the one required, 'Alight Equity Fund (S 500)'. Please choose a different account. On Wed, 2022-08-24 at 21:47 -0500, David Carlson wrote: > The GnuCash account structure is dictated by the program and it will > not > necessarily exactly match what your brokerage statement shows. As one > of > the previous comments noted, there are some bug reports indicating > that the > csv importer is not able to import some transactions . You may need > to > fudge your data or manually massage it after your import. > > On Wed, Aug 24, 2022, 8:55 PM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > > As for using the Expenses account, unless you intentionally made it > > *not* a placeholder account, you can't put transactions in it. I'll > > hazard a guess that is why the importer is not assigning it. > > > > Create a sub-account of Expenses for tracking the commissions/fees > > and > > try to assign that one in your CSV following the other tips David > > provided. (making the fee as a separate transaction with splits > > between > > an expense account and a brokerage account - *not* involving the > > security account.) I'm also going to hazard that the Brokerage and > > the > > expense sub-account might need to be in the same currency, else > > you'll > > need Trading Accounts turned on to handle conversion splits so > > things > > work out properly. > > > > As for why the security transaction alone won't import, I'm not > > sure. > > Did you try it all by itself in the CSV? (to eliminate variables) > > > > Regards, > > Adrien > > > > On 8/24/22 8:32 PM, Jon Schewe wrote: > > > I used the parent Expense account because I don't really need to > > > track > > > it separately. The fee is paid directly out of the stock account. > > > I > > > don't see how adding an additional account is going to fit the > > > commodity problem. The second line is a purchase from a specific > > > Asset > > > account and that transaction won't import either. > > > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > - > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Example of importing Stock transactions from CSV
I used the parent Expense account because I don't really need to track it separately. The fee is paid directly out of the stock account. I don't see how adding an additional account is going to fit the commodity problem. The second line is a purchase from a specific Asset account and that transaction won't import either. On Wed, 2022-08-24 at 09:41 -0500, David Carlson wrote: > Jon, > > My example that I gave earlier deliberately ignored commissions. I > assumed > the simpler method, as described somewhere in the help manual, that > net > prices were used instead. This will better match your broker's > statements > when you review the cost basis. If your first line is supposed to > indicate > a sale that is then applied to a (monthly?) fee, you should split it > into a > sale for cash, then use the cash to pay the fee. It would be > necessary to > import the fee expense payment into the brokerage account rather than > the > security account. > > > On Wed, Aug 24, 2022 at 8:35 AM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > > Unless I've confused something, purchasing or selling a > > stock/fund/etc. > > should be between 2 asset accounts. Considering a split for a > > commission > > or such, (like the first line of your CSV) it would be a *specific* > > expense account, not the parent and placeholder "Expenses" account. > > > > > > Regards, > > Adrien > > > > On 8/24/22 6:23 AM, Jon Schewe wrote: > > > > > Given the attached CSV file > > > The AMOUNT column is dollars. The FUND UNITS column is in shares. > > > > > > Skip 1 row, use m-d-y for Date format > > > > > > Column Name -> GnuCash field > > > POSTING DATE -> Date > > > ACTIVITY TYPE -> Description > > > FUND -> Account > > > FUND UNITS -> Deposit > > > FUND NAV/PRICE -> Price > > > Transfer Account -> Transfer Account > > > Fund Commodity -> Transaction Commodity > > > > > > When I use those mappings GnuCash has the correct amounts in the > > > "Match > > > transaction" view, however it doesn't have a transfer account > > > specified. When I try and specify an account I'm told that the > > > Transaction Commodity doesn't match the commodity of the selected > > > account, which is Expenses. > > > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > - > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Example of importing Stock transactions from CSV
On Sun, 2022-08-21 at 09:01 -0700, john wrote: > > > > On Aug 21, 2022, at 6:37 AM, Jon Schewe wrote: > > > > On Sat, 2022-08-20 at 12:20 -0400, Michael or Penny Novack wrote: > > > On 8/19/2022 10:33 PM, Jon Schewe wrote: > > > > So I didn't get the CSV import tool to work. > > > > > > Perhaps a reminder on what CSV is and is not. > > > > > > CSV stands for "common separated variables. That means the data > > > is in > > > the form of a record consisting of a number of fields delineated > > > by > > > commas. Which means two important things. The fields (individual > > > data > > > elements) cannot contain commas but even more important, ORDER > > > MATTERS. > > > > > > In other words, the record A,B,C,D is not the same a B,A,C,D << > > > A, B, > > > C, > > > and D being elements of data, names, amounts, etc. >> > > > > > > The CSV data you are importing must not only be in CSV format but > > > the > > > data must be in the right order AND any data that is null (not > > > present > > > still has its space in the record. > > > > > > Thus if a record was supposed to include A, C, and D (B is not > > > relevant > > > to this record) it would look like A,,C,D and not A,C,D > > > > > > > > > But even the "wrong" examples are in CSV format. > > > > > > > > Yes, I know what a CSV file is and how it should be formatted. The > > problem is not with the format of the file, that is handled by > > GnuCash > > just fine. The problem is the mapping of columns in the CSV file to > > fields in GnuCash. I cannot figure out the correct mapping to get > > the > > correct transactions. > > > > > > > > I have tried all of the following possible mappings between GnuCash > > fields and columns in my CSV file. In the end I finally wrote the > > python script out of frustration of the import CSV transactions not > > working. I'm hoping that someone on this list understands enough > > python > > and the import CSV transactions functionality enough to tell me how > > to > > get the mapping correct. > > > > # test 2 > > > > Transfer Account - FUND > > Withdrawal - FUND UNITS > > Account - Transfer Account > > Transaction Commodity - Currency > > > > Shares are correct. > > Close, need to get the dollars right now > > > > # test 3 > > > > Transfer Account - FUND > > Withdrawal - FUND UNITS > > Account - Transfer Account > > Transaction Commodity - Currency > > Deposit - AMOUNT > > > > None of the shares or cash lined up. > > > > # test 4 > > > > Try swapping withdrawal and deposit > > > > Transfer Account - FUND > > Deposit - FUND UNITS > > Account - Transfer Account > > Transaction Commodity - Currency > > Withdrawal - AMOUNT > > > > None of the shares or cash lined up. > > > > # test 5 > > > > Transfer Account - FUND > > Withdrawal - FUND UNITS > > Account - Transfer Account > > Transaction Commodity - Currency > > price - FUND UNITS > > > > Values don't line up with the price > > > > # test 6 > > > > Transfer Account - Transfer Account > > Deposit - AMOUNT > > Account - FUND > > Transaction Commodity - Currency > > > > Price is right, Shares are the dollars > > Shares times price equals dollars. > > > > > > # test 7 > > > > Transfer Account - Transfer Account > > Account - FUND > > Transaction Commodity - Fund Commodity > > Deposit - FUND UNITS > > > > Nothing is right, couldn't find the account to transfer from and > > price > > is 1. > > > > The CSV importer doesn't know how to calculate prices and there's no > way to tell it the value (in the ttransaction currency), only the > amount (in the account's commodity). You should supply the price > instead. Ideally that will be the fraction value/amount (multiply > both by the power of 10 needed to make them integers, so e.g you'd > write $497.65 for 57 shares as 49765/5700. > > The difference between a deposit column and a withdrawal column is > that the latter is sign-reversed. A positive deposit will increase > the balance of an asset account and reduce the value of a liability > or equity account; a positive withdrawal will do the opposite. Does the CSV import
Re: [GNC] Example of importing Stock transactions from CSV
David, I'm using GnuCash 4.11 from FlatPak. I have all of my transactions on single lines (I've posted samples in this thread). I would greatly appreciate someone explaining how to make this work and I'd be happy to help update the documentation on this. Jon On Sun, 2022-08-21 at 09:17 -0500, David Carlson wrote: > Jon, > > If you are not using some recent 4.x version of GnuCash you may not > have the latest improvements to the CSV transaction importer. > > A normal stock purchase or sale transaction has two parts, one, a > deposit or withdrawal of cash from a brokerage account, the other an > exchange of the cash for a security at some exchange rate, aka > price. For this discussion I will ignore commissions and fees. > > Thus you want to have two CSV lines per transaction. Also, when > importing the CSV file, you will need to check the Multi-split box to > tell GnuCash that is the type of file that you are importing. Then > you can assign one line to the security purchase or sale and the > other to the cash transfer. You can define fields in each line to > match the respective lines in a completed transaction as seen in the > security register. You only see the price and share details in the > security register and the cash transfer details can be seen in both > the security register and the brokerage register. > > I will admit that I have not done that myself, so I cannot provide an > example for you to follow. Perhaps another user can provide an > example. Good luck. > > On Sun, Aug 21, 2022 at 8:38 AM Jon Schewe wrote: > > On Sat, 2022-08-20 at 12:20 -0400, Michael or Penny Novack wrote: > > > On 8/19/2022 10:33 PM, Jon Schewe wrote: > > > > So I didn't get the CSV import tool to work. > > > > > > Perhaps a reminder on what CSV is and is not. > > > > > > CSV stands for "common separated variables. That means the data > > is in > > > the form of a record consisting of a number of fields delineated > > by > > > commas. Which means two important things. The fields (individual > > data > > > elements) cannot contain commas but even more important, ORDER > > > MATTERS. > > > > > > In other words, the record A,B,C,D is not the same a B,A,C,D << > > A, B, > > > C, > > > and D being elements of data, names, amounts, etc. >> > > > > > > The CSV data you are importing must not only be in CSV format but > > the > > > data must be in the right order AND any data that is null (not > > > present > > > still has its space in the record. > > > > > > Thus if a record was supposed to include A, C, and D (B is not > > > relevant > > > to this record) it would look like A,,C,D and not A,C,D > > > > > > > > > But even the "wrong" examples are in CSV format. > > > > > > > > Yes, I know what a CSV file is and how it should be formatted. The > > problem is not with the format of the file, that is handled by > > GnuCash > > just fine. The problem is the mapping of columns in the CSV file to > > fields in GnuCash. I cannot figure out the correct mapping to get > > the > > correct transactions. > > > > > > > > I have tried all of the following possible mappings between GnuCash > > fields and columns in my CSV file. In the end I finally wrote the > > python script out of frustration of the import CSV transactions not > > working. I'm hoping that someone on this list understands enough > > python > > and the import CSV transactions functionality enough to tell me how > > to > > get the mapping correct. > > > > # test 2 > > > > Transfer Account - FUND > > Withdrawal - FUND UNITS > > Account - Transfer Account > > Transaction Commodity - Currency > > > > Shares are correct. > > Close, need to get the dollars right now > > > > # test 3 > > > > Transfer Account - FUND > > Withdrawal - FUND UNITS > > Account - Transfer Account > > Transaction Commodity - Currency > > Deposit - AMOUNT > > > > None of the shares or cash lined up. > > > > # test 4 > > > > Try swapping withdrawal and deposit > > > > Transfer Account - FUND > > Deposit - FUND UNITS > > Account - Transfer Account > > Transaction Commodity - Currency > > Withdrawal - AMOUNT > > > > None of the shares or cash lined up. > > > > # test 5 > > > > Transfer Account - FUND > > Withdrawal - FUND UNITS > &g
Re: [GNC] Example of importing Stock transactions from CSV
On Sat, 2022-08-20 at 12:20 -0400, Michael or Penny Novack wrote: > On 8/19/2022 10:33 PM, Jon Schewe wrote: > > So I didn't get the CSV import tool to work. > > Perhaps a reminder on what CSV is and is not. > > CSV stands for "common separated variables. That means the data is in > the form of a record consisting of a number of fields delineated by > commas. Which means two important things. The fields (individual data > elements) cannot contain commas but even more important, ORDER > MATTERS. > > In other words, the record A,B,C,D is not the same a B,A,C,D << A, B, > C, > and D being elements of data, names, amounts, etc. >> > > The CSV data you are importing must not only be in CSV format but the > data must be in the right order AND any data that is null (not > present > still has its space in the record. > > Thus if a record was supposed to include A, C, and D (B is not > relevant > to this record) it would look like A,,C,D and not A,C,D > > > But even the "wrong" examples are in CSV format. > > Yes, I know what a CSV file is and how it should be formatted. The problem is not with the format of the file, that is handled by GnuCash just fine. The problem is the mapping of columns in the CSV file to fields in GnuCash. I cannot figure out the correct mapping to get the correct transactions. I have tried all of the following possible mappings between GnuCash fields and columns in my CSV file. In the end I finally wrote the python script out of frustration of the import CSV transactions not working. I'm hoping that someone on this list understands enough python and the import CSV transactions functionality enough to tell me how to get the mapping correct. # test 2 Transfer Account - FUND Withdrawal - FUND UNITS Account - Transfer Account Transaction Commodity - Currency Shares are correct. Close, need to get the dollars right now # test 3 Transfer Account - FUND Withdrawal - FUND UNITS Account - Transfer Account Transaction Commodity - Currency Deposit - AMOUNT None of the shares or cash lined up. # test 4 Try swapping withdrawal and deposit Transfer Account - FUND Deposit - FUND UNITS Account - Transfer Account Transaction Commodity - Currency Withdrawal - AMOUNT None of the shares or cash lined up. # test 5 Transfer Account - FUND Withdrawal - FUND UNITS Account - Transfer Account Transaction Commodity - Currency price - FUND UNITS Values don't line up with the price # test 6 Transfer Account - Transfer Account Deposit - AMOUNT Account - FUND Transaction Commodity - Currency Price is right, Shares are the dollars Shares times price equals dollars. # test 7 Transfer Account - Transfer Account Account - FUND Transaction Commodity - Fund Commodity Deposit - FUND UNITS Nothing is right, couldn't find the account to transfer from and price is 1. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Example of importing Stock transactions from CSV
Jack, I have tried using this configuration multiple times to get the import to work. I have a list of column assignments, none of which have worked correctly. Thus the python script that does in fact work. In your screenshot I see column options that don't exist for me. Are you importing transactions or prices? I'm trying to import transactions. Jon On Sat, 2022-08-20 at 11:54 -0400, Jack Frillman via gnucash-user wrote: > I use CSV import almost every day and it works just fine. > You do have to setup a configuration file that tells the importer how > to > interpret your CSV data. I suspect you did not do that. > Here is an example of my CSV data: > > ARSIX,14.82,Ray Jay,2022/08/20,USD > BAFGX,26.47,Ray Jay,2022/08/20,USD > BAGIX,10.07,Ray Jay,2022/08/20,USD > CISMX,16.75,Ray Jay,2022/08/20,USD > GSFTX,29.98,Ray Jay,2022/08/20,USD > > Each column of the separated values above are defined when you set > the > importer up. > I saved this in a file called "ira quotes" and it's selected in the > attached screen shot. The bottom window is the result of mapping of > the > "irs quotes" file to the CSV data above. > > As for your Python script I have no idea what it's supposed to do. > I have a much smaller Python script that scrapes the closing day > prices > off a web page and creates the CSV file I import. > > Jack > > On 8/19/22 10:33 PM, Jon Schewe wrote: > > So I didn't get the CSV import tool to work. However I was able to > > write a python script to do the import. I would think that this > > would > > be possible with the CSV import, but I can't seem to figure out how > > to > > do the right column assignments to make it work. I have attached > > the > > python script and a sample input CSV file. > > > > If someone that knows how the CSV import code works and can compare > > with my script and tell me how to use the CSV import tool for this, > > that would be great. > > > > Thanks, > > > > Jon > > > > > > On Tue, 2022-07-12 at 08:45 -0500, Jon Schewe wrote: > > > That looks similar to what I'm doing, except all of my data is on > > > a > > > single line in the CSV file. The biggest problem seems to be how > > > to > > > convince GnuCash to use 2 different commodities for the > > > transaction > > > when importing from CSV. > > > > > > > > > On Tue, 2022-07-12 at 13:04 +1000, Geoff wrote: > > > > Hi Jon > > > > > > > > This isn't exactly what you are asking for, but it may give you > > > > some > > > > clues. Importing Dividends from CSV:- > > > > > > > > https://lists.gnucash.org/pipermail/gnucash-user/2020-August/092768.html > > > > > > > > > > > > Good luck! > > > > > > > > Geoff > > > > = > > > > > > > > On 12/07/2022 12:35 pm, Jon Schewe wrote: > > > > > Does anyone have an example of importing stock transactions > > > > > from > > > > > CSV? > > > > > > > > > > I have matched columns to Date, Description, Account, Price, > > > > > Deposit, > > > > > Transfer Account. > > > > > The "Account" column is the mutual fund account. > > > > > The "Transfer Account" column is the currency account. > > > > > > > > > > When I start the import process all of my transactions need > > > > > an > > > > > account > > > > > to transfer from, despite specifying the Transfer Account. > > > > > When I > > > > > try > > > > > and select my currency account I'm told that it has the wrong > > > > > commodity. > > > > > > > > > > I have another column for the currency amount, but I don't > > > > > know > > > > > what to > > > > > map that to in the importer. > > > > > > > > > > I tried checkout out > > > > > https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#trans-import-csv > > > > > > > > > > but it doesn't seem to address this. > > > > > Suggestions on where I'm going wrong. > > > > > > > > > > Jon > > > > > > > > > > > > > > > ___ > > > > > gnucash-user mailing list > > > > > gn
Re: [GNC] Example of importing Stock transactions from CSV
So I didn't get the CSV import tool to work. However I was able to write a python script to do the import. I would think that this would be possible with the CSV import, but I can't seem to figure out how to do the right column assignments to make it work. I have attached the python script and a sample input CSV file. If someone that knows how the CSV import code works and can compare with my script and tell me how to use the CSV import tool for this, that would be great. Thanks, Jon On Tue, 2022-07-12 at 08:45 -0500, Jon Schewe wrote: > That looks similar to what I'm doing, except all of my data is on a > single line in the CSV file. The biggest problem seems to be how to > convince GnuCash to use 2 different commodities for the transaction > when importing from CSV. > > > On Tue, 2022-07-12 at 13:04 +1000, Geoff wrote: > > Hi Jon > > > > This isn't exactly what you are asking for, but it may give you > > some > > clues. Importing Dividends from CSV:- > > > > https://lists.gnucash.org/pipermail/gnucash-user/2020-August/092768.html > > > > > > Good luck! > > > > Geoff > > = > > > > On 12/07/2022 12:35 pm, Jon Schewe wrote: > > > Does anyone have an example of importing stock transactions from > > > CSV? > > > > > > I have matched columns to Date, Description, Account, Price, > > > Deposit, > > > Transfer Account. > > > The "Account" column is the mutual fund account. > > > The "Transfer Account" column is the currency account. > > > > > > When I start the import process all of my transactions need an > > > account > > > to transfer from, despite specifying the Transfer Account. When I > > > try > > > and select my currency account I'm told that it has the wrong > > > commodity. > > > > > > I have another column for the currency amount, but I don't know > > > what to > > > map that to in the importer. > > > > > > I tried checkout out > > > https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#trans-import-csv > > > > > > but it doesn't seem to address this. > > > Suggestions on where I'm going wrong. > > > > > > Jon > > > > > > > > > ___ > > > 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. #!/usr/bin/env python3 import warnings with warnings.catch_warnings(): import re import sys import argparse import os import logging import logging.config import json from pathlib import Path import gnucash import itertools import functools import csv import datetime SCRIPT_DIR=Path(__file__).parent.absolute() def get_logger(): return logging.getLogger(__name__) def setup_logging( default_path='logging.json', default_level=logging.INFO, env_key='LOG_CFG' ): """ Setup logging configuration """ try: path = Path(default_path) value = os.getenv(env_key, None) if value: path = Path(value) if path.exists(): with open(path, 'r') as f: config = json.load(f) logging.config.dictConfig(config) else: logging.basicConfig(level=default_level) except: print(f"Error configuring logging, using default configuration with level {default_level}") logging.basicConfig(level=default_level) @functools.cache def find_commodity(book, fund_name : str): """ Arguments: book: GnuCash book fund_name: name of fund to find as substring of commodity full name Returns: list
Re: [GNC] Opening balances for Stocks/Crypto
When you create a transaction between accounts with different commodities you will get a price column. That's the multiplier to convert from one commodity to the other. So you go into your stock account and create a new transaction that has Equity as the other account. Then put an appropriate value in the price column. On Thu, 2022-07-21 at 09:27 -0300, Esteban Maringolo wrote: > Hi, > > I've created different securities and trading accounts for a few > stocks and crypto I own. > > But I don't know how to create an "opening" balance for them. I > cannot > create an account under Equity with anything other than a currency. > > How should I proceed? > > Thanks. > > Esteban A. Maringolo > ___ > 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] Example of importing Stock transactions from CSV
That looks similar to what I'm doing, except all of my data is on a single line in the CSV file. The biggest problem seems to be how to convince GnuCash to use 2 different commodities for the transaction when importing from CSV. On Tue, 2022-07-12 at 13:04 +1000, Geoff wrote: > Hi Jon > > This isn't exactly what you are asking for, but it may give you some > clues. Importing Dividends from CSV:- > > https://lists.gnucash.org/pipermail/gnucash-user/2020-August/092768.html > > > Good luck! > > Geoff > ===== > > On 12/07/2022 12:35 pm, Jon Schewe wrote: > > Does anyone have an example of importing stock transactions from > > CSV? > > > > I have matched columns to Date, Description, Account, Price, > > Deposit, > > Transfer Account. > > The "Account" column is the mutual fund account. > > The "Transfer Account" column is the currency account. > > > > When I start the import process all of my transactions need an > > account > > to transfer from, despite specifying the Transfer Account. When I > > try > > and select my currency account I'm told that it has the wrong > > commodity. > > > > I have another column for the currency amount, but I don't know > > what to > > map that to in the importer. > > > > I tried checkout out > > https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#trans-import-csv > > > > but it doesn't seem to address this. > > Suggestions on where I'm going wrong. > > > > Jon > > > > > > ___ > > 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] Example of importing Stock transactions from CSV
Does anyone have an example of importing stock transactions from CSV? I have matched columns to Date, Description, Account, Price, Deposit, Transfer Account. The "Account" column is the mutual fund account. The "Transfer Account" column is the currency account. When I start the import process all of my transactions need an account to transfer from, despite specifying the Transfer Account. When I try and select my currency account I'm told that it has the wrong commodity. I have another column for the currency amount, but I don't know what to map that to in the importer. I tried checkout out https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#trans-import-csv but it doesn't seem to address this. Suggestions on where I'm going wrong. Jon ___ 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] Transaction Imports
Anyone have a how-to or tutorial on how to import stock transactions from a CSV file? I'm not finding anything in the documentation on how to handle the different commodities. On Sun, 2022-06-19 at 15:10 -0500, Jon Schewe wrote: > I'm trying to do a similar import and I'm finding that I can't > convince > GnuCash to enter the other account. I'm using import transactions > from > CSV.I have matched columns to Date, Description, Account, Price, > Deposit, Transfer Account.The "Account" column is the mutual fund > account.The "Transfer Account" column is the currency account. > When I start the import process all of my transactions need an > account > to transfer from, despite specifying the Transfer Account. When I try > and select my currency account I'm told that it has the wrong > commodity. > I have another column for the currency amount, but I don't know what > to > map that to in the importer. > I tried checkout out > https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#trans-import-csv > > but it doesn't seem to address this.Suggestions on where I'm going > wrong. > On Mon, 2022-04-11 at 22:36 -0400, David T. via gnucash-user wrote: > > Further to this: you care about how much money something cost (the > > amount you have spent), and how much you got for it (the amount of > > shares you purchased). The first affects how much money you have in > > your bank account, the second affects how many shares show in your > > mutual fund. > > On April 11, 2022 8:16:06 PM EDT, Stu Perlman < > > sgperl...@gmail.com > > > > > wrote: > > > Thank for the heads up. > > > On Mon, Apr 11, 2022 at 3:03 PM D < > > > sunfis...@yahoo.com > > > > wrote: > > > > Not going to go into great detail here, but you definitely > > > > DON'T > > > > want tohave gnucash calculate shares. Have it calculate > > > > price.On > > > > Apr 11, 2022, at 11:21, Stu Perlman < > > > > sgperl...@gmail.com > > > > > wrote: > > > > > Hello Everyone, > > > > > I am looking for some guidance on how to import a few hundred > > > > > transactionsfrom my 401(k) account.Unfortunately, the plan > > > > > administrator does not offer a good option forexporting the > > > > > transaction data but I am able to get what I need with > > > > > somebasic web scraping. > > > > > I have been experimenting with creating a multi-split CSV > > > > > import from thedata that I have captured.What I wanted to do > > > > > was a file layout such as: > > > > > *Date,Description,Account,Deposit,SharesAsMemo,Price*01/04/20 > > > > > 21 > > > > > ,Contribution,Cash,-299.26,,Vanguard Institutional Index > > > > > Institutional > > > > > Fund,299.26,0.916289038,326.601/19/2021,Contribution,Cash,- > > > > > 299.26,,Vanguard Institutional Index Institutional > > > > > Fund,299.26,0.892008703,335.49 > > > > > > > > > > My wishful thinking was that I could put the number of shares > > > > > into the memocolumn for reference (but that the system would > > > > > auto-calculate that numberusing the provided Price and > > > > > transaction amount ("Deposit")).I hit a blocker on the second > > > > > to last step of the import wizard with themessage: "*The > > > > > account 'Vanguard Institutional Index Fund' has a > > > > > differentcommodity to the one required, 'US Dollar'. Please > > > > > choose a differentaccount.*" > > > > > So I'm wondering if there are other ways I can go about what > > > > > I'm trying toaccomplish? I started with the CSV importer > > > > > because I figured it would bethe easiest record layout to > > > > > create but I'm not against using a differentformat if what I > > > > > want to accomplish can be done. > > > > > I have a backup plan which is that I will NOT do the multi- > > > > > split import andwill just select the Cash account for all > > > > > rows > > > > > in the Import Previewscreen. I could pack the memo field with > > > > > the ticker symbol, price,quantity, and total debit and let it > > > > > all dump into the Imbalance-USDaccount. I would then have to > > > > > either manually fix them one by one orpossibly script it > > > > > out. I have done this with success in the pas
Re: [GNC] Transaction Imports
I'm trying to do a similar import and I'm finding that I can't convince GnuCash to enter the other account. I'm using import transactions from CSV.I have matched columns to Date, Description, Account, Price, Deposit, Transfer Account.The "Account" column is the mutual fund account.The "Transfer Account" column is the currency account. When I start the import process all of my transactions need an account to transfer from, despite specifying the Transfer Account. When I try and select my currency account I'm told that it has the wrong commodity. I have another column for the currency amount, but I don't know what to map that to in the importer. I tried checkout out https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#trans-import-csv but it doesn't seem to address this.Suggestions on where I'm going wrong. On Mon, 2022-04-11 at 22:36 -0400, David T. via gnucash-user wrote: > Further to this: you care about how much money something cost (the > amount you have spent), and how much you got for it (the amount of > shares you purchased). The first affects how much money you have in > your bank account, the second affects how many shares show in your > mutual fund. > On April 11, 2022 8:16:06 PM EDT, Stu Perlman > wrote: > > Thank for the heads up. > > On Mon, Apr 11, 2022 at 3:03 PM D wrote: > > > Not going to go into great detail here, but you definitely DON'T > > > want tohave gnucash calculate shares. Have it calculate price.On > > > Apr 11, 2022, at 11:21, Stu Perlman wrote: > > > > Hello Everyone, > > > > I am looking for some guidance on how to import a few hundred > > > > transactionsfrom my 401(k) account.Unfortunately, the plan > > > > administrator does not offer a good option forexporting the > > > > transaction data but I am able to get what I need with > > > > somebasic web scraping. > > > > I have been experimenting with creating a multi-split CSV > > > > import from thedata that I have captured.What I wanted to do > > > > was a file layout such as: > > > > *Date,Description,Account,Deposit,SharesAsMemo,Price*01/04/2021 > > > > ,Contribution,Cash,-299.26,,Vanguard Institutional Index > > > > Institutional > > > > Fund,299.26,0.916289038,326.601/19/2021,Contribution,Cash,- > > > > 299.26,,Vanguard Institutional Index Institutional > > > > Fund,299.26,0.892008703,335.49 > > > > > > > > My wishful thinking was that I could put the number of shares > > > > into the memocolumn for reference (but that the system would > > > > auto-calculate that numberusing the provided Price and > > > > transaction amount ("Deposit")).I hit a blocker on the second > > > > to last step of the import wizard with themessage: "*The > > > > account 'Vanguard Institutional Index Fund' has a > > > > differentcommodity to the one required, 'US Dollar'. Please > > > > choose a differentaccount.*" > > > > So I'm wondering if there are other ways I can go about what > > > > I'm trying toaccomplish? I started with the CSV importer > > > > because I figured it would bethe easiest record layout to > > > > create but I'm not against using a differentformat if what I > > > > want to accomplish can be done. > > > > I have a backup plan which is that I will NOT do the multi- > > > > split import andwill just select the Cash account for all rows > > > > in the Import Previewscreen. I could pack the memo field with > > > > the ticker symbol, price,quantity, and total debit and let it > > > > all dump into the Imbalance-USDaccount. I would then have to > > > > either manually fix them one by one orpossibly script it > > > > out. I have done this with success in the past butwould rather > > > > just get it right at the data import step if that's in anyway > > > > possible. > > > > My thanks in advance for any advice offered. > > > > - Stu-- > > > > gnucash-user mailing listgnucash-u...@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 > listgnucash-u...@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
Re: [GNC] Download GnuCash issue
Maybe that's all that is available. Can you post the specific text of the dialog here? That may help in determining what the issue is. GnuCash does say it supports Windows 8. One possibility is that GnuCash is built as a 64-bit application and you have a 32-bit version of Windows. You can follow the instructions here to verify if you have a 32-bit or 64-bit version of Windows https://softwaregroup.zendesk.com/hc/en-us/articles/115012567728-How-to-check-if-Windows-8-and-8-1-is-32-bit-or-64-bit I'm not sure if GnuCash for Windows is built as 64-bit only. Can someone using Windows confirm this? On Sat, 2022-02-12 at 10:01 -0600, David Carlson wrote: > That sounds like you are trying to drive a Tesla on a cow path. Why > try? > On Sat, Feb 12, 2022 at 7:37 AM wrote: > > Hi, I downloaded the latest version of GnuCash (4.9) onto an older > > laptoprunning Windows 8.1 , but when I tried to run the setup got a > > message thatit could not run on this machine. Same thing with an > > older version ofGnuCash. I have about 11 GB of disk space remaining > > on this machine. Whatcould be the issue? > > Thanks > > David Long > > ___gnucash-user mailing > > listgnucash-u...@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] Crash getting online transactions
On Sun, 2022-01-30 at 12:56 -0500, David Reiser wrote: > > On Jan 30, 2022, at 12:52 PM, Jon Schewe < > > jpsch...@mtu.net > > > wrote: > > > > I've recently found that getting online transactions for my savings > > account crashes GnuCash. Getting the checking account and credit > > card > > accounts from the same bank work fine. I turned on the debug log > > and > > found this: > > > > * 11:50:01 INFO > > [xaccAccountGetBalanceInCurrency] baln=453392/100 > > * 11:50:05 ERROR <> provider_sendcmd.c: 355: Handling user > > "myusername" > > * 11:50:05 ERROR <> provider_sendcmd.c: 272: Handling account "14" > > * 11:50:10 ERROR gui_dialogs.c: 365: Progress by id > > 0002 not found > > * 11:50:10 ERROR transaction.c: 4916: List missing > > * 11:50:10 INFO [qof_event_generate_internal] id=16 > > hi=0x55abf7a45610 han=0x7f3ee5b5a790 data=(nil) > > > > Any suggestions? > > > > Using GnuCash 4.9-2 Flatpak on Ubuntu Linux. > > > > Jon > > > > 4.9 crashes on aqbanking ofxdirectconnects if there are no new > transactions to display in the matcher window. The choices are to go > back to 4.8 or wait for 4.10 Good to know. Now that I know what the issue is, I can wait for 4.10. As long as I save before I get transactions, I know that a crash means no new transactions :) ___ 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] Crash getting online transactions
I've recently found that getting online transactions for my savings account crashes GnuCash. Getting the checking account and credit card accounts from the same bank work fine. I turned on the debug log and found this: * 11:50:01 INFO [xaccAccountGetBalanceInCurrency] baln=453392/100 * 11:50:05 ERROR <> provider_sendcmd.c: 355: Handling user "myusername" * 11:50:05 ERROR <> provider_sendcmd.c: 272: Handling account "14" * 11:50:10 ERROR gui_dialogs.c: 365: Progress by id 0002 not found * 11:50:10 ERROR transaction.c: 4916: List missing * 11:50:10 INFO [qof_event_generate_internal] id=16 hi=0x55abf7a45610 han=0x7f3ee5b5a790 data=(nil) Any suggestions? Using GnuCash 4.9-2 Flatpak on Ubuntu Linux. Jon ___ 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 & Macros
On Fri, 2021-12-31 at 16:22 +0800, Kevin Buckley wrote: > On Wed, 26 May 2021 at 23:11, Jack Frillman via gnucash-user > < > gnucash-user@gnucash.org > > wrote: > > I have repetitive task I do every day and I would like to reduce > > the > > number of steps to do that task. > > > > More specifically I import stock/mutual fund and precious metal > > prices > > from a CSV file. Currently I go through the multi-step process the > > GUI > > walks you through. This is easy enough but I can be ultra lazy at > > times > > and would like to execute that import process using a macro if > > possible. > > > > Whilst I can't suggest a "macro" within Gnucash, I can suggest > another > way to achieve the same thing, assumimg you are happy doing a bit > of shell scripting, plain text editing, and store your GnuCash files > in > uncompressed XML format. If you are comfortable running a script and learning a little python, this may help you with some options https://github.com/jpschewe/gnucash-stock-portfolio It uses the gnucash API to write stock information. I second the lots of backups suggestion. ___ 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] clearing reconciled transactions
In the reconcile window, you can select multiple transactions by clicking on one and shift+clicking on another, this will select all in the range. Then right click and unreconcile. On Thu, 2021-12-02 at 08:36 -0500, Billie-Internet wrote: > Good Morning,My question seems simple but I am probably not searching > the right keywords. > Current gnucash 4.4 on windows 10. > When reconciling the checkbook, sometimes I need to clear all > thetransactions that are checked and start over. To this point , I > amunchecking one at a time.Does anyone know of a way to uncheck all > at once?Thanks, > Billie706-383- > 9057___gnucash-user > mailing listgnucash-u...@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] Budget Report Questions
Steve, In the report options I believe you will find the following settings useful. Under the display tab: I have Budget and Actual turned off and Difference turned on. This fits with my idea of envelope budgeting. You should experiment with which of these 3 columns you find the most useful. Under the general tab: Check "Use accumulated amounts" Check "Report for range of budget periods" Range Start: Current budget period Range End: Next budget period Check "Include collapsed periods before selected" Check "Include collapsed periods after selected" Jon On Sun, 2021-10-10 at 18:20 -0400, Steve Welch via gnucash-user wrote: > I apologize in advance if the answers to these questions are > painfully obvious. I have tried to read the resources provided but > no luck so far. > I set up my budget with 12 periods (months) - each item is simply > 1/12th of the annual total. > What I am used to using (Moneydance, Quicken) are two basic reports: > 1. Budget vs. Actual - year to date (YTD budget vs. YTD actuals) > 2. Budget vs. Actual - annual (full year budget vs. YTD actuals) > When I view the GNC “Budget Report” it looks like I’m seeing #2 > above. How can I view a report that shows #1 - YTD budget vs. YTD > actuals? > Also, is there a way to collapse or hide the monthly columns so that > I can see the totals (far right) next to the account names? With 12 > months displayed, I have to constantly scroll left - right to see the > name and then the totals. > Finally, is “Budget Report” the only one that shows budgeted figures > next to actuals? I haven’t found any others but wanted to be sure. > > Again, sorry if I’m missing something simple here. And thanks! > > Steve > ___ > 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] Newest version for Ubuntu 20.04 LTS
If you install from flatpak you will get the current version. However note that there is currently a bug with 4.7 that prevents it from opening, so you may want to wait on that. sudo apt install flatpak sudo flatpak install org.gnucash.GnuCash flatpak run org.gnucash.GnuCash On Wed, 2021-09-29 at 01:10 -0500, Jeff wrote: > Short of building from source, is there a link anywhere for upgrading > from 4.2 to the next compatible stable version on Ubuntu 20.04 LTS? The > Debian list is too far behind since I run multiple O.S.'s. I tried the > suggested PPA, I think it was sicklylife something or other for 4.3. > Totally screwed up a test set of books that I use just to test new > versions before I turn it loose on my multiple sets of books for > family. It would be nice to run the same working versions on my Ubuntu > Server (Micro$soft bricked my main server and had to replace it, so I am > migrating everything I can to Ubuntu) and my dual boot laptop. > > I have tried several times to build from source but; I am too old school > on my programming language list (i.e. Cobol, Pascal, forth) to get a > build to work. Every time I have tried it spits out in a foreign > language some error list and fails to build. My bad. > > You would think that someone who wrote over 100,000 lines of C++ code to > handle up to 2 billion inventory items for a POS and parts ordering > system at best cost could easily handle this, but the languages you use > are all too new to me. > > I would settle for a copy of "Building the Newest Version of GNC for > Dummies Course" book. > ___ 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 4.7 Problem
The flatpak apears to be broken as well. I run it and nothing appears. jpschewe@jon-2019:~ >flatpak run org.gnucash.GnuCash F: Ignoring D-Conf migrate-path setting /org/gnucash/GnuCash ~ jpschewe@jon-2019:~ >echo $? 133 On Mon, 2021-09-27 at 09:44 +0200, Geert Janssens wrote: > Unfortunately this is a bug. I missed a name change in the conversion > code for > gnucash preferences. > > The fix is in the patch attached. > > As this is a crasher we may have to do a hotfix release. What do you > think > John ? > > Regards, > > Geert > > Op maandag 27 september 2021 06:43:26 CEST schreef John Ralls: > > Please remember to copy the list on all replies. > > > > Removing /usr/local/lib/gnucash isn't enough. You'd also need to > > remove at > > least /usr/local/lib/libgnc* and /usr/local/share/gnucash. > > > > You don't need the whole build directory. There's a single file, > > install-manifest.txt, that contains all of the files that were > > installed. > > With that one file you can do `xargs rm < install-manifest.txt` to > > uninstall GnuCash. You might consider saving it off somewhere > > before you > > delete the build directory. > > > > Regards, > > John Ralls > > > > > On Sep 26, 2021, at 9:08 PM, Harry G McGavran Jr < > > > w5...@w5pny.com > > > > wrote: > > > > > > That did fix the problem! I guess I will have to be sure > > > to keep the old build directory around, so I can do a "make > > > uninstall" > > > before building the next release! Thanks for the fix -- but I > > > must > > > say it would be nice to not have to do the "make uninstall" on > > > the > > > old release. Many packages don't even have uninstall in their > > > Makefiles... (although it would be nice if every one did include > > > an > > > uninstall in their Makefiles). > > > > > > Thanks, John! > > > > > > Harry > > > > > > On 9/26/21 9:41 PM, Harry G McGavran Jr wrote: > > > > I think I figured out what you mean -- > > > > you must mean either do "make uninstall" or "ninja uninstall" > > > > with 4.6 > > > > before building 4.7 ... > > > > With I build gnucash and always remove /usr/local/lib/gnucash > > > > before doing "make install" which might be the same thing. > > > > If it does, then I'll still have the problem. I'll give > > > > it a try though and if it doesn't work, I'll post a tracefile > > > > to > > > > the bug reports... > > > > > > > > On 9/26/21 9:34 PM, Harry G McGavran Jr wrote: > > > > > I don't have the ninja package installed, so I'm not sure > > > > > what > > > > > "make/ninja uninstall" means...>>> > > > > > On 9/26/21 9:20 PM, john wrote: > > > > > > If you didn't already, run make/ninja uninstall in the 4.6 > > > > > > build > > > > > > directory. Configure and build GnuCash 4.7 in an empty > > > > > > directory, then > > > > > > install. > > > > > > > > > > > > If that doesn't correct the problem get a stack trace of > > > > > > the crash and > > > > > > attach it and the trracefile to a new bug report. > > > > > > > > > > > > Regards, > > > > > > John Ralls > > > > > > > > > > > > > On Sep 26, 2021, at 7:26 PM, Harry G McGavran Jr via > > > > > > > gnucash-user > > > > > > > < > > > > > > > gnucash-user@gnucash.org > > > > > > > > wrote: > > > > > > > > > > > > > > This was with Ubuntu 20.04... > > > > > > > > > > > > > > On 9/26/21 8:25 PM, Harry G McGavran Jr wrote: > > > > > > > > I just built Gnucash 4.7 from the release page. > > > > > > > > It built fine, and it runs fine from the build > > > > > > > > directory, > > > > > > > > but the installed gnucash binary in /usr/local/bin > > > > > > > > fails with: > > > > > > > > Trace/breakpoint trap (core dumped) > > > > > > > > It only seems to run without error when run from the > > > > > > > > bin > > > > > > > > directory where the build is actually done. > > > > > > > > So I rebuilt Gnucash 4.6 and it's installed binary in > > > > > > > > /usr/local/bin > > > > > > > > runs fine. > > > > > > > > There was no core file even though "core dumped" was > > > > > > > > displayed with > > > > > > > > 4.7 > > > > > > > > > > > > > > ___ > > > > > > > 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,
Re: [GNC] Creating Reports
John, The budget report is close to what you want here. However the spending there is based on the budget plan, so if your income varies from check to check, then it won't show what you are looking for. Another option to think about is to use separate accounts for all long term savings and then just look at the checking account balance. If you pay all of your bills out of the checking account and you make sure to move all money for long-term savings out of the checking account, then what is left is your discretionary.I have sub-accounts of my savings account setup in GnuCash that don't match real bank accounts. These are used to hold the money that I need for bills that are paid every 6 months or 12 months. Then the balance in my savings account is what isn't already allocated. Doing this for your checking account would likely work. Jon On Mon, 2021-08-09 at 11:43 -0500, John M Dennis wrote: > Good Day to yo all! > I have just set up my family finances with GnuCash (version4.6) and > am looking into the various reports. What I need, and have yet to > find, is a simply report my wife and I can access to see how well me > are doing with our budget each day. Specifically I am looking for the > following: > > Checking Acct #1Today's Balance+Checking Acct #2 > Today's Balance= Daily Balance Subtotal- Budgeted > Total amount budgeted for the current pay period. This would include > All Budgeted Expenses & Amounts Transferred to holding accounts for > later payments. This could also be expandable to the various sub > accounts I have set up+ PaidAmounts already paid out for > all expenses and transfers to Holding Accounts. These cold also be > expandable to include sub accounts.= Available Balance What is left > for discretionary spending. This is the big one that I would like to > see spelled out for us. > > Each of the reports I have seen and played with will do some of this > but i haven't seen any that will give me all of it. If there is > something out there or if I am missing something, I would really like > to know. > Anyone who could help me out with this, I would really appreciate. > Thank you very much. > John > > ___gnucash-user mailing > listgnucash-u...@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] budget report and scrolling
On Fri, 2021-08-06 at 17:24 -0500, Tommy Trussell wrote: > On Fri, Aug 6, 2021 at 9:25 AM Jon Schewe wrote: > > I am using the budget report and it's working quite well, except > > for > > > > one thing. When I am viewing a whole year I need to scroll left and > > > > right to see columns later in the year and when I do this I can't > > see > > > > the labels on the left for the accounts. Does anyone have a good > > way > > > > around this? > > This is a bit cumbersome, but you can export the report, open it in a > spreadsheet, and "freeze" the left column with the labels and scroll > easily. You can export it using the Export Report (on toolbar or File > menu). > I saw the export, but it's HTML and didn't think that the spreadsheet would take it. Turns out LibreOffice does quite well. > > > Just before I sent this I was thinking that I could limit the > > number of > > > > budget periods visible, while this isn't ideal those options are > > > > disabled in the report options. Is this expected? > > The design is a bit klunky -- the options appear if you tick the > checkbox "Report for range of budget periods." The other controls > activate when you choose Manual Period Selection. That does help. Jon ___ 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] budget report and scrolling
I am using the budget report and it's working quite well, except for one thing. When I am viewing a whole year I need to scroll left and right to see columns later in the year and when I do this I can't see the labels on the left for the accounts. Does anyone have a good way around this? Just before I sent this I was thinking that I could limit the number of budget periods visible, while this isn't ideal those options are disabled in the report options. Is this expected? I'm using GnuCash 4.6 on Linux. Thank you, Jon ___ 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] USAA FSB requires newer QWIN support
Answering my own questions after I got it to work. I picked a CLIENTUID that someone else posted and it worked. When prompted for a password, it's the one from https://www.usaa.com/accessid On Fri, 2021-02-12 at 21:18 -0600, Jon Schewe wrote: > When GnuCash prompts for a password, is it the one that was retrieved > from > https://www.usaa.com/accessid > ? > > Is it important that the CLIENTUID comes from Quicken? Or does it > just > need to match a particular format? > > On Fri, 2021-02-12 at 22:29 +, Bob White via gnucash-user wrote: > > I got new USAA OFX download working with GNC 4.4.1. > > > > It's mainly a configuration task. > > > > -- User config -- > > int uniqueId="" > > char backendName="aqofxconnect" > > char userName="" > > char userId="" > > char customerId="" > > char country="us" > > char bankCode="314074269" > > int lastSessionId="0" > > > > data { > > backend { > > char bankName="USAA Federal Savings Bank" > > char org="USAA Federal Savings Bank" > > char fid="67811" > > char serverAddr="https%3A%2F%2Fdf3cx- > > services.1fsapi.com%2Fcasm%2Fusaa%2Faccess.ofx" > > char appId="QMOFX" > > char appVer="2300" > > char headerVer="103" > > char clientUid="" > > int httpVMajor="0" > > int httpVMinor="0" > > char httpUserAgent="InetClntApp%2F3.0" > > } #backend > > } #data > > - > > > > Notes: > > -- 'httpUserAgent' is currently not configurable through GNC > > v4.4.1, but it works when included in the file. It has been added > > in > > newer AqBanking, look for support in next GNC release. > > -- 'CLIENTUID' can be found in OFXLog.txt generated by Quicken. > > Signup for trial and cancel within 30 days no charge. > > -- 'your new USAA access id' can be found at > > https://www.usaa.com/accessid > > > > > > > > You will need to disconnect accounts from within the AqBanking > > Wizard, download accounts with new user configuration, then > > reconnect > > accounts. In my case, the new credit card account numbers in the > > accounts list are not a 100% match to the number found on your > > credit > > card. There were enough common digits to know which was which, > > just > > be aware. I was able to successfully download and update 2 > > checking > > accounts, a savings account, and a credit card account. > > > > I hope this helps. > > > > Regards, > > > > Bob > > > > PS. I did clone the AqBanking repo and build and install the > > latest > > libraries on the same machine I am running GNC. I am not sure if > > the > > GNC used the libraries distributed with it or the ones I built so > > YMMV. > > ___ > > 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] USAA FSB requires newer QWIN support
When GnuCash prompts for a password, is it the one that was retrieved from https://www.usaa.com/accessid? Is it important that the CLIENTUID comes from Quicken? Or does it just need to match a particular format? On Fri, 2021-02-12 at 22:29 +, Bob White via gnucash-user wrote: > I got new USAA OFX download working with GNC 4.4.1. > > It's mainly a configuration task. > > -- User config -- > int uniqueId="" > char backendName="aqofxconnect" > char userName="" > char userId="" > char customerId="" > char country="us" > char bankCode="314074269" > int lastSessionId="0" > > data { > backend { > char bankName="USAA Federal Savings Bank" > char org="USAA Federal Savings Bank" > char fid="67811" > char serverAddr="https%3A%2F%2Fdf3cx- > services.1fsapi.com%2Fcasm%2Fusaa%2Faccess.ofx" > char appId="QMOFX" > char appVer="2300" > char headerVer="103" > char clientUid="" > int httpVMajor="0" > int httpVMinor="0" > char httpUserAgent="InetClntApp%2F3.0" > } #backend > } #data > - > > Notes: > -- 'httpUserAgent' is currently not configurable through GNC > v4.4.1, but it works when included in the file. It has been added in > newer AqBanking, look for support in next GNC release. > -- 'CLIENTUID' can be found in OFXLog.txt generated by Quicken. > Signup for trial and cancel within 30 days no charge. > -- 'your new USAA access id' can be found at > https://www.usaa.com/accessid > > > You will need to disconnect accounts from within the AqBanking > Wizard, download accounts with new user configuration, then reconnect > accounts. In my case, the new credit card account numbers in the > accounts list are not a 100% match to the number found on your credit > card. There were enough common digits to know which was which, just > be aware. I was able to successfully download and update 2 checking > accounts, a savings account, and a credit card account. > > I hope this helps. > > Regards, > > Bob > > PS. I did clone the AqBanking repo and build and install the latest > libraries on the same machine I am running GNC. I am not sure if the > GNC used the libraries distributed with it or the ones I built so > YMMV. > ___ > 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] USAA FSB requires newer QWIN support
Some additional data points. I was using appVer 2200 and got no transactions. I edited the aqbanking config file and changed the appVer to 2700, still no transactions. I changed the headerVer to 103, still no transactions. I tried adding a clientUid and that didn't help either. However I do not see any errors in the log window. According to the log I'm using AqBanking v6.2.1.0stable. On Thu, 2021-01-28 at 10:40 -0500, David Reiser via gnucash-user wrote: > The first thing to try is setting the appVer to 2700 (nine years > newer than 1800). > > If that doesn’t work on its own, try setting headerVer to 103 and > creating a clientUid > -- > Dave Reiser > dbrei...@icloud.com > > > > > > > > On Jan 28, 2021, at 10:30 AM, Bob White via gnucash-user < > > gnucash-user@gnucash.org > > > wrote: > > > > As of 27 Jan 2021 USAA has deprecated aqbanking QWIN v1800 > > support. Can connect, but transactions are no longer downloaded. > > > > I confirmed with USAA. I am trying to get details on newer > > requirements from USAA but it is difficult--they will only > > troubleshoot with the actual Quicken app, which I do not have. > > > > Waiting on a callback from USAA. > > > > Has anyone else experienced these issues or know of a resolution? > > > > Thanks, > > > > Bob > > > > > > ___ > > 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] USAA FSB requires newer QWIN support
I see that I have this issue as well. Is it possible to change the setup without running the online banking wizard? The last time I set this up I updated the wiki at https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#USAA and noted the the client ID should be empty. On Thu, 2021-01-28 at 10:40 -0500, David Reiser via gnucash-user wrote: > The first thing to try is setting the appVer to 2700 (nine years > newer than 1800). > > If that doesn’t work on its own, try setting headerVer to 103 and > creating a clientUid > -- > Dave Reiser > dbrei...@icloud.com > > > > > > > > On Jan 28, 2021, at 10:30 AM, Bob White via gnucash-user < > > gnucash-user@gnucash.org > > > wrote: > > > > As of 27 Jan 2021 USAA has deprecated aqbanking QWIN v1800 > > support. Can connect, but transactions are no longer downloaded. > > > > I confirmed with USAA. I am trying to get details on newer > > requirements from USAA but it is difficult--they will only > > troubleshoot with the actual Quicken app, which I do not have. > > > > Waiting on a callback from USAA. > > > > Has anyone else experienced these issues or know of a resolution? > > > > Thanks, > > > > Bob > > > > > > ___ > > 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] Where is the list?
Suzanne, If you are looking for information on setting up direct online banking, I believe this page will help https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings Jon On Sat, 2021-01-09 at 14:57 -0500, Suzanne Gruninger Frei wrote: > New to this Gnucash. Trying to find information about online banking > set upwith Citibank but can't find the lists to search for > information or askquestions..Thank you for your > help.Suzanne___gnucash- > user mailing listgnucash-u...@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] Decimal places in shares column
I believe this is controlled by the properties of the commodity. Menu:ToolsSecurity EditorSelect the stockChange fraction traded On Sat, 2020-12-19 at 09:27 -0500, Dennis Powless wrote: > How do I set the decimal to be at least 3 or more places in the > stockshares column? Currently it is at two.1.00 I'm looking > for 1.000or 1. > Thanks, > D___gnucash-user mailing > listgnucash-u...@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] Switching to/from Flatpak keeping Saved Reports
Tommy, Thank you for the tip about the symlink, I'll need to do that. Here's the menu entry file that I have in ~/.local/share/applications/personal-gnucash.desktop. I have similar desktop entry for each gnucash file. This allows me to press the "windows" key, then type "personal gnucash" and I get the icon and the right file is launched. [Desktop Entry]Version=1.0Name=Personal GnuCashExec=flatpak run org.gnucash.GnuCash "/home/jpschewe/Documents/banking/gnucash/accounts.gnucash"Icon=/usr/sh are/icons/hicolor/64x64/apps/gnucash- icon.pngTerminal=falseType=Application On Sun, 2020-11-08 at 18:17 -0600, Tommy Trussell wrote: > A couple of months ago I upgraded GnuCash 3.8 on my Ubuntu LTS system > tothe latest GnuCash using Flatpak. I wanted to keep my saved reports > and Ididn't want to have to worry about losing them again if I > switched fromFlatpak to a distribution version. Here's what I did to > keep them (\ lineendings and whitespace added for clarity): > # Close all running instances of GnuCash # Save any existing > Flatpak report configurations mv > \ ~/.var/app/org.gnucash.GnuCash/data/gnucash > \ ~/.var/app/org.gnucash.GnuCash/data/gnucash.orig # Create the > symlink ln -s \ ~/.local/share/gnucash > \ ~/.var/app/org.gnucash.GnuCash/data/gnucash > The paths above seem to be correct for any Debian derived > distribution, andI believe may be the same for any linux > distribution. (I hope someonecorrects me if I'm wrong.) > BACKGROUND: > I was putting off upgrading via Flatpak for a long time for two > reasons: > 1) My primary system running GnuCash didn't quite have the memory > orprocessor capacity to handle Flatpak applications. (It's impressive > howlittle RAM or CPU you need to run GnuCash. Or maybe it's > impressive howmuch of a cheapskate I am. Your pick.) > 2) I have books for eight organizations at this point and I would > hate tolose my custom reports and launcher shortcuts. > I upgraded the primary system earlier this year, so that addressed > itemone. Item two took a little digging amongst the FAQ entries. > I created a symlink as shown above and the saved reports have been > workingperfectly. I expected to have "sandbox" permission issues with > the Flatpakbut didn't. So why does the Flatpak have to use its own > directory insteadof looking in the same place the distribution > version uses...?) > I'm still not completely happy with my Gnome launcher shortcuts -- > I'm ableto get the right-click launcher menu to open my different > GnuCash books,but they do NOT share the "favorite" GnuCash icon in > the task bar as thedistribution application does. I figure I'm either > missing some Gnomelauncher secret sauce, or maybe Gnome doesn't know > how to handle > Flatpakinstances.___gnuca > sh-user mailing listgnucash-u...@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] Keep the Reconciliation Feature (was Re: Gnucash 4.0 Paper Clip and Link glyphs for file/web transaction associations)
Sorry for jumping in late on this, but are the developers seriously considering removing the reconciliation feature? If it's about space on the toolbar, I'd be happy if it was in a menu somewhere for those of us that use it. I find it quite useful as GNUCash treats reconciled splits differently than other splits. I like the fact that once something is reconciled I need to go through an extra warning dialog to change it. It tells me that I've double checked not only that the split has cleared, but the balance was correct up to some point in time. This is particularly important when the order of transactions in GNUCash is different from the bank due to when transactions were processed. I have cases where I enter the transaction and mark it as cleared, but it doesn't show up on the monthly statement yet, but a transaction that I entered after it does show up on the statement. So in this case I want to know that the bank and I agreed on the set of transactions that happened on that statement. On Sat, 2020-07-04 at 12:27 -0700, John Ralls wrote: > But all of those accounts should be periodically reconciled unless you never > post anything except by importing it. Regardless, that's a perfectly fine > use-case, but I don't think that it's a common one or even that GnuCash is > the best solution for it. > > Regards, > John Ralls > > On Jul 4, 2020, at 9:50 AM, wrote: > > John -- I understand your point and I agree -- but in GnuCash I have real > estate values, mortgages, brokerage accounts, 401K accounts, car payment > loans, etc. to track all accounts in one package. So while you are correct > in your description (I am not really keeping a separate book for my bank > account per se), I still need GnuCash to keep track of all assets and > liability accounts because these are all from different banks or brokerage > companies. > > So -- specific just to checking account reconciliations in my situation -- it > is really no longer needed. As long as I have online access to and can see > my online transactions and account balance, the bank's record is my record - > because I have instant access to the balance 24/7. It is analogous to my > mother-in-call who calls every week. I can log in daily and always know what > my balance is and what has cleared. As you said -- nothing really to > reconcile to. GnuCash is just keeping the record of what has transpired. > Now... if online banking goes away... that's a whole different story! > > Ken > > > -Original Message- > From: John Ralls > Sent: Saturday, July 4, 2020 9:17 AM > To: py...@cox.net > Cc: Michael Hendry ; Chris Good > ; Gnucash > Subject: Re: [GNC] Keep the Reconciliation Feature (was Re: Gnucash 4.0 Paper > Clip and Link glyphs for file/web transaction associations) > > You're confusing reconciliation with processing paper statements. Regardless > of how you get the information from the bank the fact remains that there are > two sets of books--yours in GnuCash and the bank's--and they need to be > reconciled periodically to ensure that they agree. One could, of course, keep > one's GnuCash book by downloading transactions from the bank. In that case > you're not keeping a separate book and there's no point to reconciliation. > But why bother with GnuCash if you're going to do that? > > Regards, > John Ralls > > > On Jul 4, 2020, at 5:38 AM, py...@cox.net wrote: > > Michael -- again - it is a matter of personal preference. Every instance you > talk about is absolutely true for banking in the old days. I, too, used to > think that bank rec's were absolutely necessary -- in fact, as an auditor for > 30 years - I recommended them as a must have! > > But, with easy, on-line, instant access to balances and statements, > all-electronic payments (I maybe wrote 3 checks all of last year), and better > and faster electronic payment systems, the need for monthly reconciliations > has gone the way of the horse and buggy - for many people (not all - and > certainly not for businesses who write hundreds of check). It does get you > where you absolutely need to go -- it just is an old and tired mode of > transportation that have been surpassed by better and faster ways to get to > the same place! > > Ken > > (PS -- my mother-in-law still uses bank by phone to call the bank for > her balance instead of going online to see her balance. She does not > get paper statements because all banks charge for them now. She still > keeps a paper register as well. She reconciles manually once a week. > See the analogy?) > > -Original Message- > From: gnucash-user On > Behalf Of Michael Hendry > Sent: Friday, July 3, 2020 11:53 PM > To: Chris Good ; Gnucash > > Subject: [GNC] Keep the Reconciliation Feature (was Re: Gnucash 4.0 > Paper Clip and Link glyphs for file/web transaction associations) > > On 4 Jul 2020, at 02:45, Chris Good wrote: > > Hi Ken, > > I'm afraid I'm in the group that
Re: [GNC] Using Quicken direct connect with USAA
Not only does the first account download not take, no account download takes until I have created a dummy account. It's as if creating the dummy account is creating some container, perhaps the directory, to store the downloaded account information. However the download doesn't create that container. On Mon, 2020-05-25 at 19:46 -0700, John Ralls wrote: > Ah, that would explain why the Next button was disabled: You had no > accounts to assign. > > So the issue would seem to be that the first account download didn't > take, though the > AQBanking dialog box indicated that it should have. > > Regards, > John Ralls > > > > On May 25, 2020, at 4:41 PM, Jon Schewe wrote: > > Yes, I checked the Accounts tab after downloading the accounts the > first time and the tab was empty. I even tried backing all the way > out > of the wizard and restarting GnuCash and the tab was still empty. > > On Mon, 2020-05-25 at 16:33 -0700, John Ralls wrote: > > When you first set up the User in the AQBanking Wizard did you check > the Accounts tab after downloading the accounts the first time? > > Regards, > John Ralls > > > > On May 25, 2020, at 11:47 AM, Jon Schewe wrote: > > It just started working "magically". I tried manually creating an > account and associating it with a GnuCash account. Then tried getting > the balance and got an error that I had the account number wrong. So > I > went back into the AQBanking Wizard and executed Retrieve Account > List > to get the full account number. Now when I went over to the accounts > tab my accounts are there! I was able to associate them with the > right > GnuCash accounts and it seems to be working. > > I went back through my setup and deleted my aqbanking user and wrote > up > the steps that worked. It seems there is something about needing a > dummy account created, otherwise aqbanking won't save the account > information that it retrieved. > > Here are the steps, note the bit about a dummy account. > > * Tools -> Online Banking Setup... > * Create User > * Next > * OFX-DirectConnect backend > * Run > * Next > * Select > * USAA > * Select bank and click OK > * Next > * Enter USAA number with zeros on the left to make the number 9 > digits for the User Name and the User Id > * Next > * Next > * Next > * Retrieve Account List > * Enter PIN > * Finish > * Click on the Accounts tab > * If it's empty, create a dummy account using the aqofxconnect > backend > * OK > * Leave everything blank > * OK > * Dismiss message about unable to update > * Users > * Edit User > * Bank Settings > * Retrieve Account List > * Close > * Click on Accounts tab and see the new accounts, delete the dummy > account > * Close > * Next > * Associate to GnuCash accounts, looking at the account number works > well > * Next > * Apply > * Test by opening a GnuCash account that was associated with USAA > * Actions -> Online Actions -> Get Balance > * See the balance show up in a dialog > > On Mon, 2020-05-25 at 13:21 -0500, Jon Schewe wrote: > > Thank you for your help thus far. > > I noticed that I had AQBanking and GnuCash installed both inside and > outside flatpak. I've removed the version outside flatpak, but that > didn't help. > > If there are some additional debugging steps that are suggested for > checking aqbanking, let me know and I can see where the integration > with GnuCash is breaking. > > On Mon, 2020-05-25 at 09:47 -0700, John Ralls wrote: > > Well, that's progress. The communication with USAA is clearly > working. > > Maybe the flatpak sandbox isn't letting GnuCash see the results from > AQBanking. Unfortunately I don't have time to investigate this > further today. > > Regards, > John Ralls > > > > On May 25, 2020, at 9:29 AM, Jon Schewe wrote: > > John, > > Using those settings got me different information in the dialog. > However I still don't have an option to associate the accounts. When > I close the dialogs I'm back to "Start Online Banking Wizard" and the > match step is still grey. > > 11:24:16 Saving communication log to 1 > 11:24:16 Sending request... > 11:24:16 Using GnuTLS default ciphers. > 11:24:16 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256- > GCM:AEAD > 11:24:16 Waiting for response... > 11:24:17 Saving communication log to 1 > 11:24:17 Parsing response... > 11:24:17 Status for signon request: Success (Code 0, severity "INFO") > The server successfully processed the request. > 11:24:17 Status for account info request: Success (Code 0, severity > "INFO&quo
Re: [GNC] Using Quicken direct connect with USAA
Yes, I checked the Accounts tab after downloading the accounts the first time and the tab was empty. I even tried backing all the way out of the wizard and restarting GnuCash and the tab was still empty. On Mon, 2020-05-25 at 16:33 -0700, John Ralls wrote: > When you first set up the User in the AQBanking Wizard did you check > the Accounts tab after downloading the accounts the first time? > > Regards, > John Ralls > > > > On May 25, 2020, at 11:47 AM, Jon Schewe wrote: > > It just started working "magically". I tried manually creating an > account and associating it with a GnuCash account. Then tried getting > the balance and got an error that I had the account number wrong. So > I > went back into the AQBanking Wizard and executed Retrieve Account > List > to get the full account number. Now when I went over to the accounts > tab my accounts are there! I was able to associate them with the > right > GnuCash accounts and it seems to be working. > > I went back through my setup and deleted my aqbanking user and wrote > up > the steps that worked. It seems there is something about needing a > dummy account created, otherwise aqbanking won't save the account > information that it retrieved. > > Here are the steps, note the bit about a dummy account. > > * Tools -> Online Banking Setup... > * Create User > * Next > * OFX-DirectConnect backend > * Run > * Next > * Select > * USAA > * Select bank and click OK > * Next > * Enter USAA number with zeros on the left to make the number 9 > digits for the User Name and the User Id > * Next > * Next > * Next > * Retrieve Account List > * Enter PIN > * Finish > * Click on the Accounts tab > * If it's empty, create a dummy account using the aqofxconnect > backend >* OK >* Leave everything blank >* OK >* Dismiss message about unable to update >* Users >* Edit User >* Bank Settings >* Retrieve Account List >* Close > * Click on Accounts tab and see the new accounts, delete the dummy > account > * Close > * Next > * Associate to GnuCash accounts, looking at the account number works > well > * Next > * Apply > * Test by opening a GnuCash account that was associated with USAA >* Actions -> Online Actions -> Get Balance >* See the balance show up in a dialog > > On Mon, 2020-05-25 at 13:21 -0500, Jon Schewe wrote: > > Thank you for your help thus far. > > I noticed that I had AQBanking and GnuCash installed both inside and > outside flatpak. I've removed the version outside flatpak, but that > didn't help. > > If there are some additional debugging steps that are suggested for > checking aqbanking, let me know and I can see where the integration > with GnuCash is breaking. > > On Mon, 2020-05-25 at 09:47 -0700, John Ralls wrote: > > Well, that's progress. The communication with USAA is clearly > working. > > Maybe the flatpak sandbox isn't letting GnuCash see the results from > AQBanking. Unfortunately I don't have time to investigate this > further today. > > Regards, > John Ralls > > > > On May 25, 2020, at 9:29 AM, Jon Schewe wrote: > > John, > > Using those settings got me different information in the dialog. > However I still don't have an option to associate the accounts. When > I close the dialogs I'm back to "Start Online Banking Wizard" and the > match step is still grey. > > 11:24:16 Saving communication log to 1 > 11:24:16 Sending request... > 11:24:16 Using GnuTLS default ciphers. > 11:24:16 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256- > GCM:AEAD > 11:24:16 Waiting for response... > 11:24:17 Saving communication log to 1 > 11:24:17 Parsing response... > 11:24:17 Status for signon request: Success (Code 0, severity "INFO") > The server successfully processed the request. > 11:24:17 Status for account info request: Success (Code 0, severity > "INFO") > The server successfully processed the request. > 11:24:17 Received account X/XX ((no bank > name)/ACCOUNT) > 11:24:17 Received account X/XX ((no bank > name)/ACCOUNT) > 11:24:17 Received account (no bank code)/ ((no bank > name)/ACCOUNT) > 11:24:17 Operation finished, you can now close this window. > > Jon > > On Mon, 2020-05-25 at 09:09 -0700, John Ralls wrote: > > Jon, > > The Application Settings I use for USAA are > Application ID: QWIN > Application Version: 2200 > Header Version: 102 > > In Special Settings: > HTTP Version, Client UID, and Security Type are blank, Force SSLv3 > and Send Sho
Re: [GNC] Using Quicken direct connect with USAA; Aqbanking versions
Sorry about that. I am using the stable release. GnuCash 3.10 Build ID: Flathub 3.10-1 Versions: AqBanking-CLI: 6.1.4 Gwenhywfar : 5.2.0.0 AqBanking: 6.1.4.0 On Mon, 2020-05-25 at 23:57 +0200, Frank H. Ellenberger wrote: > Jon, > > you did not write, which Flatpak you are using. > The nightlies > * Flatpak: https://code.gnucash.org/builds/flatpak/maint/?C=M;O=D > * Windows: https://code.gnucash.org/builds/win32/master/?C=M;O=D > are since last friday bundled with AqBanking 6.2.1 while previous > versions were shipping AqBanking 6.2.0beta. > > I don't know, if the dummy step is still required with the new > version- > > Regards > Frank > > Am 25.05.20 um 20:47 schrieb Jon Schewe: > > It just started working "magically". I tried manually creating an > account and associating it with a GnuCash account. Then tried getting > the balance and got an error that I had the account number wrong. So > I > went back into the AQBanking Wizard and executed Retrieve Account > List > to get the full account number. Now when I went over to the accounts > tab my accounts are there! I was able to associate them with the > right > GnuCash accounts and it seems to be working. > > I went back through my setup and deleted my aqbanking user and wrote > up > the steps that worked. It seems there is something about needing a > dummy account created, otherwise aqbanking won't save the account > information that it retrieved. > > Here are the steps, note the bit about a dummy account. > > * Tools -> Online Banking Setup... > * Create User > * Next > * OFX-DirectConnect backend > * Run > * Next > * Select > * USAA > * Select bank and click OK > * Next > * Enter USAA number with zeros on the left to make the number 9 > digits for the User Name and the User Id > * Next > * Next > * Next > * Retrieve Account List > * Enter PIN > * Finish > * Click on the Accounts tab > * If it's empty, create a dummy account using the aqofxconnect > backend > * OK > * Leave everything blank > * OK > * Dismiss message about unable to update > * Users > * Edit User > * Bank Settings > * Retrieve Account List > * Close > * Click on Accounts tab and see the new accounts, delete the dummy > account > * Close > * Next > * Associate to GnuCash accounts, looking at the account number > works > well > * Next > * Apply > * Test by opening a GnuCash account that was associated with USAA > * Actions -> Online Actions -> Get Balance > * See the balance show up in a dialog > > ___ 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] Using Quicken direct connect with USAA
It just started working "magically". I tried manually creating an account and associating it with a GnuCash account. Then tried getting the balance and got an error that I had the account number wrong. So I went back into the AQBanking Wizard and executed Retrieve Account List to get the full account number. Now when I went over to the accounts tab my accounts are there! I was able to associate them with the right GnuCash accounts and it seems to be working. I went back through my setup and deleted my aqbanking user and wrote up the steps that worked. It seems there is something about needing a dummy account created, otherwise aqbanking won't save the account information that it retrieved. Here are the steps, note the bit about a dummy account. * Tools -> Online Banking Setup... * Create User * Next * OFX-DirectConnect backend * Run * Next * Select * USAA * Select bank and click OK * Next * Enter USAA number with zeros on the left to make the number 9 digits for the User Name and the User Id * Next * Next * Next * Retrieve Account List * Enter PIN * Finish * Click on the Accounts tab * If it's empty, create a dummy account using the aqofxconnect backend * OK * Leave everything blank * OK * Dismiss message about unable to update * Users * Edit User * Bank Settings * Retrieve Account List * Close * Click on Accounts tab and see the new accounts, delete the dummy account * Close * Next * Associate to GnuCash accounts, looking at the account number works well * Next * Apply * Test by opening a GnuCash account that was associated with USAA * Actions -> Online Actions -> Get Balance * See the balance show up in a dialog On Mon, 2020-05-25 at 13:21 -0500, Jon Schewe wrote: > Thank you for your help thus far. > > I noticed that I had AQBanking and GnuCash installed both inside and > outside flatpak. I've removed the version outside flatpak, but that > didn't help. > > If there are some additional debugging steps that are suggested for > checking aqbanking, let me know and I can see where the integration > with GnuCash is breaking. > > On Mon, 2020-05-25 at 09:47 -0700, John Ralls wrote: > > Well, that's progress. The communication with USAA is clearly > working. > > Maybe the flatpak sandbox isn't letting GnuCash see the results from > AQBanking. Unfortunately I don't have time to investigate this > further today. > > Regards, > John Ralls > > > > On May 25, 2020, at 9:29 AM, Jon Schewe wrote: > > John, > > Using those settings got me different information in the dialog. > However I still don't have an option to associate the accounts. When > I close the dialogs I'm back to "Start Online Banking Wizard" and the > match step is still grey. > > 11:24:16 Saving communication log to 1 > 11:24:16 Sending request... > 11:24:16 Using GnuTLS default ciphers. > 11:24:16 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256- > GCM:AEAD > 11:24:16 Waiting for response... > 11:24:17 Saving communication log to 1 > 11:24:17 Parsing response... > 11:24:17 Status for signon request: Success (Code 0, severity "INFO") > The server successfully processed the request. > 11:24:17 Status for account info request: Success (Code 0, severity > "INFO") > The server successfully processed the request. > 11:24:17 Received account X/XX ((no bank > name)/ACCOUNT) > 11:24:17 Received account X/XX ((no bank > name)/ACCOUNT) > 11:24:17 Received account (no bank code)/ ((no bank > name)/ACCOUNT) > 11:24:17 Operation finished, you can now close this window. > > Jon > > On Mon, 2020-05-25 at 09:09 -0700, John Ralls wrote: > > Jon, > > The Application Settings I use for USAA are > Application ID: QWIN > Application Version: 2200 > Header Version: 102 > > In Special Settings: > HTTP Version, Client UID, and Security Type are blank, Force SSLv3 > and Send Short Date are checked, and Send Empty Bank ID and Send > Empty FID are unchecked. > > Another user had trouble with USAA because he had entered a Client > UID on the User Settings page, so make sure that's blank too. > > Yes, SSL v3 is less secure than TLS, but it's better than sending the > data in the clear, and yes, the authentication that USAA uses on OFX > DirectConnect is less than ideal. > > Regards, > John Ralls > > > On May 25, 2020, at 8:59 AM, Jon Schewe wrote: > > Alan, > > Thanks for the suggestion. I tried not setting any special settings > and > make sure the SSL v3 is unchecked. Still no change. > > As far as security goes, this method for getting my transactions > appears les
Re: [GNC] Using Quicken direct connect with USAA
Thank you for your help thus far. I noticed that I had AQBanking and GnuCash installed both inside and outside flatpak. I've removed the version outside flatpak, but that didn't help. If there are some additional debugging steps that are suggested for checking aqbanking, let me know and I can see where the integration with GnuCash is breaking. On Mon, 2020-05-25 at 09:47 -0700, John Ralls wrote: > Well, that's progress. The communication with USAA is clearly > working. > > Maybe the flatpak sandbox isn't letting GnuCash see the results from > AQBanking. Unfortunately I don't have time to investigate this > further today. > > Regards, > John Ralls > > > > On May 25, 2020, at 9:29 AM, Jon Schewe wrote: > > John, > > Using those settings got me different information in the dialog. > However I still don't have an option to associate the accounts. When > I close the dialogs I'm back to "Start Online Banking Wizard" and the > match step is still grey. > > 11:24:16 Saving communication log to 1 > 11:24:16 Sending request... > 11:24:16 Using GnuTLS default ciphers. > 11:24:16 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256- > GCM:AEAD > 11:24:16 Waiting for response... > 11:24:17 Saving communication log to 1 > 11:24:17 Parsing response... > 11:24:17 Status for signon request: Success (Code 0, severity "INFO") > The server successfully processed the request. > 11:24:17 Status for account info request: Success (Code 0, severity > "INFO") > The server successfully processed the request. > 11:24:17 Received account X/XX ((no bank > name)/ACCOUNT) > 11:24:17 Received account X/XX ((no bank > name)/ACCOUNT) > 11:24:17 Received account (no bank code)/ ((no bank > name)/ACCOUNT) > 11:24:17 Operation finished, you can now close this window. > > Jon > > On Mon, 2020-05-25 at 09:09 -0700, John Ralls wrote: > > Jon, > > The Application Settings I use for USAA are > Application ID: QWIN > Application Version: 2200 > Header Version: 102 > > In Special Settings: > HTTP Version, Client UID, and Security Type are blank, Force SSLv3 > and Send Short Date are checked, and Send Empty Bank ID and Send > Empty FID are unchecked. > > Another user had trouble with USAA because he had entered a Client > UID on the User Settings page, so make sure that's blank too. > > Yes, SSL v3 is less secure than TLS, but it's better than sending the > data in the clear, and yes, the authentication that USAA uses on OFX > DirectConnect is less than ideal. > > Regards, > John Ralls > > > On May 25, 2020, at 8:59 AM, Jon Schewe wrote: > > Alan, > > Thanks for the suggestion. I tried not setting any special settings > and > make sure the SSL v3 is unchecked. Still no change. > > As far as security goes, this method for getting my transactions > appears less secure than using Web Connect. When I login to get to > the > Web Connect download I need to enter a one time password from my > phone, > but for Direct Connect I only need my PIN. > > Jon > > On Mon, 2020-05-25 at 11:48 -0400, Alan wrote: > Jon, > > Disable SSL v3. Info at wiki.gnucash.org is wrong. It's not secure, > and no > reputable financial institution should be supporting it for financial > transactions. > > As of this moment, USAA is only supporting TLS 1.2 and 1.3, which are > secure. > Suggest not setting any of the "special settings" options, and never > enable SSL > v2 or v3 for any program, except for testing with non-sensitive data. > > -Original Message- > From: gnucash-user > [mailto:gnucash-user-bounces+alangnuc=bigtowers@gnucash.org] On > Behalf Of > Jon Schewe > Sent: Monday, May 25, 2020 10:36 AM > To: gnucash-user > Subject: [GNC] Using Quicken direct connect with USAA > > I have been using the Web Connect with USAA for years and that's > worked great. > However now I see that they are discontinuing support for this > feature. So I'm > trying to setup Direct Connect. I found the instructions for setting > up USAA at > https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#USAA, > however I'm not seeing the "Server Capabilities" tab to select the > account list > download options. > > I'm using GnuCash 3.10 from flatpak. > I'm on Linux. > > I have the following Settings: > "User Settings" > User Name, User id and Client UID all set to my USAA number. I have > tried both > with the 00 prefix and without. > > "Bank Settings" > Broker ID: 5874 > FID: 24591 > ORG: USAA > Server URL: https://service2.usaa.com/of
Re: [GNC] Using Quicken direct connect with USAA
John, Using those settings got me different information in the dialog. However I still don't have an option to associate the accounts. When I close the dialogs I'm back to "Start Online Banking Wizard" and the match step is still grey. 11:24:16 Saving communication log to 1 11:24:16 Sending request... 11:24:16 Using GnuTLS default ciphers. 11:24:16 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256-GCM:AEAD 11:24:16 Waiting for response... 11:24:17 Saving communication log to 1 11:24:17 Parsing response... 11:24:17 Status for signon request: Success (Code 0, severity "INFO") The server successfully processed the request. 11:24:17 Status for account info request: Success (Code 0, severity "INFO") The server successfully processed the request. 11:24:17 Received account X/XX ((no bank name)/ACCOUNT) 11:24:17 Received account X/XX ((no bank name)/ACCOUNT) 11:24:17 Received account (no bank code)/ ((no bank name)/ACCOUNT) 11:24:17 Operation finished, you can now close this window. Jon On Mon, 2020-05-25 at 09:09 -0700, John Ralls wrote: > Jon, > > The Application Settings I use for USAA are > Application ID: QWIN > Application Version: 2200 > Header Version: 102 > > In Special Settings: > HTTP Version, Client UID, and Security Type are blank, Force SSLv3 and Send > Short Date are checked, and Send Empty Bank ID and Send Empty FID are > unchecked. > > Another user had trouble with USAA because he had entered a Client UID on the > User Settings page, so make sure that's blank too. > > Yes, SSL v3 is less secure than TLS, but it's better than sending the data in > the clear, and yes, the authentication that USAA uses on OFX DirectConnect is > less than ideal. > > Regards, > John Ralls > > > > On May 25, 2020, at 8:59 AM, Jon Schewe wrote: > > Alan, > > Thanks for the suggestion. I tried not setting any special settings and > make sure the SSL v3 is unchecked. Still no change. > > As far as security goes, this method for getting my transactions > appears less secure than using Web Connect. When I login to get to the > Web Connect download I need to enter a one time password from my phone, > but for Direct Connect I only need my PIN. > > Jon > > On Mon, 2020-05-25 at 11:48 -0400, Alan wrote: > > Jon, > > Disable SSL v3. Info at wiki.gnucash.org is wrong. It's not secure, and no > reputable financial institution should be supporting it for financial > transactions. > > As of this moment, USAA is only supporting TLS 1.2 and 1.3, which are secure. > Suggest not setting any of the "special settings" options, and never enable > SSL > v2 or v3 for any program, except for testing with non-sensitive data. > > -Original Message- > From: gnucash-user > [mailto:gnucash-user-bounces+alangnuc=bigtowers@gnucash.org] On Behalf Of > Jon Schewe > Sent: Monday, May 25, 2020 10:36 AM > To: gnucash-user > Subject: [GNC] Using Quicken direct connect with USAA > > I have been using the Web Connect with USAA for years and that's worked great. > However now I see that they are discontinuing support for this feature. So I'm > trying to setup Direct Connect. I found the instructions for setting up USAA > at > https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#USAA, > however I'm not seeing the "Server Capabilities" tab to select the account > list > download options. > > I'm using GnuCash 3.10 from flatpak. > I'm on Linux. > > I have the following Settings: > "User Settings" > User Name, User id and Client UID all set to my USAA number. I have tried both > with the 00 prefix and without. > > "Bank Settings" > Broker ID: 5874 > FID: 24591 > ORG: USAA > Server URL: https://service2.usaa.com/ofx/OFXServlet > > "Application Settings" > I've tried the default application settings and the settings that should be > for > Quicken 2017: > Application ID: QWIN > Application Version: 2600 > Header Version: 102 > > Under "Special Settings" I've tried HTTP Version blank, 1.0 and 1.1. > I've checked "Force SSLv3". > > When I go back to the "Bank Settings" tab I see the following after clicking > on > "Retrieve Account List". > > 09:26:37 Sending request... > 09:26:37 Using GnuTLS default ciphers. > 09:26:37 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256-GCM:AEAD > 09:26:37 Waiting for response... > 09:26:37 Operation finished, you can now close this window. > > The AqBanking Setup never lets me get to the point of associating USAA > accounts > with GnuCash accounts. Can someone give me some pointers
Re: [GNC] Using Quicken direct connect with USAA
Alan, Thanks for the suggestion. I tried not setting any special settings and make sure the SSL v3 is unchecked. Still no change. As far as security goes, this method for getting my transactions appears less secure than using Web Connect. When I login to get to the Web Connect download I need to enter a one time password from my phone, but for Direct Connect I only need my PIN. Jon On Mon, 2020-05-25 at 11:48 -0400, Alan wrote: > Jon, > > Disable SSL v3. Info at wiki.gnucash.org is wrong. It's not secure, and no > reputable financial institution should be supporting it for financial > transactions. > > As of this moment, USAA is only supporting TLS 1.2 and 1.3, which are secure. > Suggest not setting any of the "special settings" options, and never enable > SSL > v2 or v3 for any program, except for testing with non-sensitive data. > > -Original Message- > From: gnucash-user > [mailto:gnucash-user-bounces+alangnuc=bigtowers@gnucash.org] On Behalf Of > Jon Schewe > Sent: Monday, May 25, 2020 10:36 AM > To: gnucash-user > Subject: [GNC] Using Quicken direct connect with USAA > > I have been using the Web Connect with USAA for years and that's worked great. > However now I see that they are discontinuing support for this feature. So I'm > trying to setup Direct Connect. I found the instructions for setting up USAA > at > https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#USAA, > however I'm not seeing the "Server Capabilities" tab to select the account > list > download options. > > I'm using GnuCash 3.10 from flatpak. > I'm on Linux. > > I have the following Settings: > "User Settings" > User Name, User id and Client UID all set to my USAA number. I have tried both > with the 00 prefix and without. > > "Bank Settings" > Broker ID: 5874 > FID: 24591 > ORG: USAA > Server URL: https://service2.usaa.com/ofx/OFXServlet > > "Application Settings" > I've tried the default application settings and the settings that should be > for > Quicken 2017: > Application ID: QWIN > Application Version: 2600 > Header Version: 102 > > Under "Special Settings" I've tried HTTP Version blank, 1.0 and 1.1. > I've checked "Force SSLv3". > > When I go back to the "Bank Settings" tab I see the following after clicking > on > "Retrieve Account List". > > 09:26:37 Sending request... > 09:26:37 Using GnuTLS default ciphers. > 09:26:37 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256-GCM:AEAD > 09:26:37 Waiting for response... > 09:26:37 Operation finished, you can now close this window. > > The AqBanking Setup never lets me get to the point of associating USAA > accounts > with GnuCash accounts. Can someone give me some pointers on what is wrong > here? > > Thank you, > Jon > > ___ 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] Using Quicken direct connect with USAA
I have been using the Web Connect with USAA for years and that's worked great. However now I see that they are discontinuing support for this feature. So I'm trying to setup Direct Connect. I found the instructions for setting up USAA at https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#USAA, however I'm not seeing the "Server Capabilities" tab to select the account list download options. I'm using GnuCash 3.10 from flatpak. I'm on Linux. I have the following Settings: "User Settings" User Name, User id and Client UID all set to my USAA number. I have tried both with the 00 prefix and without. "Bank Settings" Broker ID: 5874 FID: 24591 ORG: USAA Server URL: https://service2.usaa.com/ofx/OFXServlet "Application Settings" I've tried the default application settings and the settings that should be for Quicken 2017: Application ID: QWIN Application Version: 2600 Header Version: 102 Under "Special Settings" I've tried HTTP Version blank, 1.0 and 1.1. I've checked "Force SSLv3". When I go back to the "Bank Settings" tab I see the following after clicking on "Retrieve Account List". 09:26:37 Sending request... 09:26:37 Using GnuTLS default ciphers. 09:26:37 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256-GCM:AEAD 09:26:37 Waiting for response... 09:26:37 Operation finished, you can now close this window. The AqBanking Setup never lets me get to the point of associating USAA accounts with GnuCash accounts. Can someone give me some pointers on what is wrong here? Thank you, Jon ___ 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] Budget Report 3.10
Tom, Is the screenshot of the the account Expenses:Car:Car Petrol? So the actual for that row in the report should be 280.81, correct? Something else to check is the date range on the report. Make sure that it is overlapping the time period that the transactions are in. Jon On Fri, 2020-04-17 at 08:28 +, Thomas Salt wrote: > Hi, > I have checked the budget options and I only have a single budget that > is selected hence I see the Budget Values just not the Actual Values. > > Many Thanks > Tom S > > > -Original Message- > From: gnucash-user On > Behalf Of Adrien Monteleone > Sent: 16 April 2020 16:21 > To: Gnucash Users > Subject: Re: [GNC] Budget Report 3.10 > > I just ran a budget report and I’m seeing actual values, so it is not a > general bug. > > Double check that the right budget is selected in Options > General > Budget > > Regards, > Adrien > > On Apr 16, 2020 w16d107, at 4:16 AM, Thomas Salt wrote: > > Hi Guys, >I have just tried to run the standard Budget Report. It shows > my Budget Values, but no Actual values. If I click and open one of the > categories all the entries are shown. Please can you advise. > > [A screenshot of a cell phone Description automatically generated] > > > > > [A screenshot of a cell phone Description automatically generated] > > > Many Thanks > > Tom S > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://eur05.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-userdata=02%7C01%7C%7Ce942f9688bc8466223cf08d7e219ffbf%7C84df9e7fe9f640afb435%7C1%7C0%7C637226473603933577sdata=mezyiDl%2F9pRqDQIg1HTO8csplKroFwRZ6eaMNuIMfMc%3Dreserved=0 > If you are using Nabble or Gmane, please see > https://eur05.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Listsdata=02%7C01%7C%7Ce942f9688bc8466223cf08d7e219ffbf%7C84df9e7fe9f640afb435%7C1%7C0%7C637226473603933577sdata=vnTKjrgP7%2FSNT8kAYaZ0BZpcjXXmuB7fUazqpRQaDlQ%3Dreserved=0 > 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] Broken QFX import in 3.8
On Sun, 2020-01-19 at 09:06 -0800, John Ralls wrote: > > 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. > I've upgraded to 3.9 via flatpak and it's working 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] Scripted price editing and adding
On 1/14/20 10:28 PM, Raymond Smith wrote: Hi, Gnucash list. I'm interested in using a script to add and edit prices in my Gnucash file. For example, I'd like to (a) loop over a file containing historical price data and add prices for dates where the price is missing because I didn't do a quote retrieval in Gnucash that day (b) loop over the prices I have of one security and add prices for call options using max(0, security price - strike price). I would prefer working in Python if possible, and I'm looking for guidance on the right approach. I've seen there are some Python bindings and also the piecash library, but it's not clear to me how well maintained or supported either is right now. I found relatively little documentation on the Python bindings ( https://wiki.gnucash.org/wiki/Python_Bindings). Piecash looks very nice, and I was able to set up a simple example where I added a price using it. But, it currently has a very minor issue ( https://github.com/sdementen/piecash/issues/126) that prevented it from running on my recent gnucash save files without a simple fix. Not a big deal to do that, but I'd like to avoid tying myself to a library that stalls while Gnucash and my save files continue to evolve. Another option I've thought about is to parse xml files using something like Python's xml library. That seems reasonably straightforward at first glance, but perhaps there are some things I should be aware of that I'm missing that would make this a bad idea? One question that has already come up is how to manage guid's of the prices. Can they be any string of the appropriate length as long as each is unique within the file? I tried a super simple test file where I copied one block and changed the date, price, and guid, then re-opened the file, and it seemed to work, but I'm not sure if that's dangerous. Take a look at this post that I put up last month https://lists.gnucash.org/pipermail/gnucash-user/2019-December/088313.html This has a reference to a script that I wrote to get my price quotes on a regular basis when the normal mechanism wasn't working. The python bindings seem to work fine. Jon -- http://mtu.net/~jpschewe ___ 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] Broken QFX import in 3.8
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 -- http://mtu.net/~jpschewe ___ 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] update quotes hanging
I have built myself a solution for this. I'm not certain why asking gnucash to add the price quotes hangs for me. However I found that if I used Python to call the perl script for each individual stock and then the GNUCash Python API to write the information it all works. The script "get_quotes.py" in the repository https://github.com/jpschewe/gnucash-stock-portfolio implements this. It looks for stocks and mutual funds that have non-zero balances and have online quotes enabled. It respects the alphavantage API rate limit and has an automatic backoff. Note that this is a fork of a repository from Henning Jacobs. I found that repository to have a good start on this and a nice patch for ensuing that GncPrice objects are properly created. Jon Schewe On 9/24/19 5:43 AM, Jon Schewe wrote: I took my gnucash file and stripped out everything except the price database and the commodities and found the same behavior. Since this doesn't have any personal information, other than which commodities I'm watching, I'm comfortable sharing it. Perhaps someone else has a configuration that works and I can replicate it. I'm running "gnucash --add-price-quotes accounts.gnucash". On 9/24/19 5:09 AM, Jon Schewe wrote: According to gnc-fq-check I have 1.47. The 5 quotes/minute restriction would explain why when I ran the gnc-fq-dump commands manually I didn't get quotes for a lot of the commodities. However it doesn't explain the process hanging. I left it running all night last night in strace and it never finished. It was sitting here all night: 8835 write(2, "Use of uninitialized value $q[1]"..., 116) = 116 8835 write(2, "Use of uninitialized value $q[2]"..., 116) = 116 8835 write(2, "Use of uninitialized value $q[1]"..., 116 ...> 8826 <... poll resumed> ) = 0 (Timeout) 8826 poll([{fd=11, events=POLLIN}], 1, -1 On 9/23/19 10:25 PM, John Ralls wrote: Have you updated Finance::Quote to 1.49? It throttles the Alphavantage requests to comply with their 5 quotes/minute restriction. You might also consider using yahoo_json for as many non-currency commodities as you can. Yahoo! still supports the json API and doesn't require throttling. Regards, John Ralls On Sep 23, 2019, at 6:59 PM, Jon Schewe wrote: I just tried 3.7.0 from ppa:sicklylife/gnucash and the behavior hasn't changed. On 9/23/19 2:25 PM, Adrien Monteleone wrote: There are no updates to the 2.6 series any longer. 2.6.21 is the last one and nearly 18 months old. There have been eight 3.x releases so far. You can build from source, or there are debs floating around on the list for 3.7 that you should be able to install on 18.04. Regards, Adrien On Sep 23, 2019 w39d266, at 5:58 AM, Jon Schewe wrote: I'm using GnuCash 2.6.19 that ships with Ubuntu 18.04. I'm finding that the update price quotes process is hanging, both from within GnuCash and from the command line. I've created a CSV file of all of my commodities and tested them individual using gnc-fq-dump and they all return fairly quickly. Not all of them have valid prices, but none hang. Below is the script that I have used with cron in the past to update my quotes at regular intervals. When the process is running I can strace it and I find that the perl process is usually in a write call writing "use of uninitialized value". Does anyone have suggestions to determine why updating the quotes is hanging? Is this a problem with this version of gnucash? I would prefer to stick with the version of gnucash that comes with my distribution so that I get automatic updates, however I can build a custom version if that is what is needed. #!/bin/sh ALPHAVANTAGE_API_KEY=XXX export ALPHAVANTAGE_API_KEY env $(dbus-launch) sh -c 'trap "kill $DBUS_SESSION_BUS_PID" EXIT; /usr/bin/gnucash --add-price-quotes ${HOME}/Documents/banking/gnucash/accounts.gnucash' 2>&1 | grep -v "Found Finance::Quote" -- http://mtu.net/~jpschewe ___ 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. -- http://mtu.net/~jpschewe ___ 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] Backporting Gnucash 3.7 to Ubuntu "Bionic" (or Mint, etc.)
Note that you can also use flatpak to get it. sudo apt install flatpak flatpak install flathub org.gnucash.GnuCash On 10/18/19 10:47 AM, Tommy Trussell wrote: I requested an "official" backport of GnuCash 3.7. If it gets a sponsor it should quickly become available to Bionic as well as all the distros that use it (such as Mint). https://bugs.launchpad.net/bionic-backports/+bug/1847547 If you're registered on Launchpad and want to have an official backport, please click the "pencil" below the bug number at the top and indicate "This bug affects me" to vote for it. IN THE MEANTIME, if you urgently want 3.7 on your system, here's a procedure that worked for me. I apologize if I've omitted any steps. (Likely! Please let me know.) REQUIREMENTS An Ubuntu Bionic (or derived) installation with bionic-backports activated and the source code lines activated. To verify, open the Software and Updates tool, and look in the Ubuntu Software tab to activate "Source code" and the Updates tab to verify "bionic-backports" is active. Close the Software & Updates window and let it update the cache. PROCEDURE 1) Install the needed development files. $ sudo apt install build-essentials devscripts $ sudo apt build-dep gnucash $ sudo apt install debhelper/bionic-backports (The first command should pull in lots of packages needed for building sortware. The second should bring in lots more specific packages for building GnuCash. The last command pulls an upgraded version of debhelper from the backports repository.) 2) Create a source directory $ mkdir bionic37 $ cd bionic37 3) Get the latest Ubuntu package. $ dget http://archive.ubuntu.com/ubuntu/pool/universe/g/gnucash/gnucash_3.7-1ubuntu1.dsc If the link above "breaks" in this email, get the correct link from the "Download Gnucash" section here: https://packages.ubuntu.com/source/eoan/gnucash 3b) Move into the directory created by dget from the source package $ cd gnucash-3.7 4) Comment out a build flag line in debian/rules so the package will build in Bionic. $ sed -i 's/export DEB_CXXFLAGS/#export DEB_CXXFLAGS/' debian/rules 5) Make this your custom version (so any "official" release should supersede it). $ dch --nmu 5b) Edit the version at the top so it reads something like: gnucash (1:3.7-1ubuntu18.04~1) 5c) Add a comment under your name and email in the first comment saying something like: "Commented out DEB_CXXFLAGS instruction in debian/rules" 5d) Save and exit the editor. 6) Build the package. $ dpkg-buildpackage (NOTE: this takes many minutes. At the end there should be a line saying the build "completed.") 7) Once the build has completed, you will see the package files in the bionic37 directory, ready to install. $ cd .. [to the directory you created in step 2] $ sudo dpkg -i *.deb *.ddeb $ sudo apt install -f The dpkg -i command above attempts to install gnucash .deb files (and the optional .ddeb debugging files). In a fresh installation, "dpkg -i" may fail because of missing dependencies, so the "apt install -f" command will install the missing dependencies and finish installing gnucash. ___ 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. -- http://mtu.net/~jpschewe ___ 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.7 - Budget reports - accumulated accounts - can "envelope budgeting" logic be implemented?
I had written my own report for version 2.6 that does this. Now I see that it won't run in 3.7. This email prompted me to look at 3.7 and this report. I found that if I enable accumulated amounts and the diff column, then turn off the budget and actual columns the report works rather nicely for envelope budgeting. At this point you just see how much money is left in each budget per month. On 10/4/19 4:41 AM, Antonio07 wrote: Hi In version 3.7 accumulated accounts option was introduced in Budget reports However by using it I have found that logic is that Budget and Actual - simply summing all "period" amount For Example: 1. I have 24 month budget 2. For each month I budgeted 320$ in category 'Food' - now I'm in October - it's 22nd month of my Budget - if I use accumulated amount it shows that I have budget for October 7040$ for 'Food' (but in reality I have only 320$) 3. Each month I have spent from 300 to 330 as actuals and now have accumulated Actuals for October - 6500$ 4. So accumulated difference 540$ Can it be change report format to show "Rolling" accumulated amounts? For Example 1. Period 21 - we have budgeted for 'Food' +320$ 2. Period 21 - we have actuals for 'Food' -300$ 3. Period 21 - We have difference for 'Food' +20$ (positive) 4. Period 22 - we have budgeted for 'Food' +300$ 5. Period 22 - we have actuals for 'Food' -100$ (so far) 6. Period 22 - we have difference = (Difference amount from period 21 '+20$' ) + (Budgeted amount from period 22 '+300$') - (Actuals from period 22 '-100$') = 20$ + 300$ - 100$ = 220$ By using we can avoid confusing end-user with huge accumulated numbers - and also keep concept if accumulating budget for some Big Goal - like budget 100$ every month for 1200$ vacation in the end of the year -- 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. -- http://mtu.net/~jpschewe ___ 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] update quotes hanging
Isn't aqbanking used to get information directly out of banks rather than needing to download QFX files? If so, I don't see how that is related. This is getting commodity quotes out of alphavantage. I use QFX files for all of my online banking. On 9/23/19 11:04 PM, Adrien Monteleone wrote: I could be mistaken, but that PPA does not include the recent builds of aqbanking. Allegedly, those builds (with what applications?) seem to work. More than likely for now, if you are affected, you need to build aqbanking with the most recent version. *Then* all should be well. The next version of GnuCash is not due out till the end of year. Perhaps if there is enough demand, an interim update to 3.7 might happen with an updated aqbanking to accommodate Eurozone users. But that would of course be up to the dev team. I certainly don’t mean to encourage more work. But this might be a rare special case. Regards, Adrien On Sep 23, 2019 w39d266, at 8:59 PM, Jon Schewe wrote: I just tried 3.7.0 from ppa:sicklylife/gnucash and the behavior hasn't changed ___ 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. -- http://mtu.net/~jpschewe ___ 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] update quotes hanging
According to gnc-fq-check I have 1.47. The 5 quotes/minute restriction would explain why when I ran the gnc-fq-dump commands manually I didn't get quotes for a lot of the commodities. However it doesn't explain the process hanging. I left it running all night last night in strace and it never finished. It was sitting here all night: 8835 write(2, "Use of uninitialized value $q[1]"..., 116) = 116 8835 write(2, "Use of uninitialized value $q[2]"..., 116) = 116 8835 write(2, "Use of uninitialized value $q[1]"..., 116 8826 <... poll resumed> ) = 0 (Timeout) 8826 poll([{fd=11, events=POLLIN}], 1, -1 On 9/23/19 10:25 PM, John Ralls wrote: Have you updated Finance::Quote to 1.49? It throttles the Alphavantage requests to comply with their 5 quotes/minute restriction. You might also consider using yahoo_json for as many non-currency commodities as you can. Yahoo! still supports the json API and doesn't require throttling. Regards, John Ralls On Sep 23, 2019, at 6:59 PM, Jon Schewe wrote: I just tried 3.7.0 from ppa:sicklylife/gnucash and the behavior hasn't changed. On 9/23/19 2:25 PM, Adrien Monteleone wrote: There are no updates to the 2.6 series any longer. 2.6.21 is the last one and nearly 18 months old. There have been eight 3.x releases so far. You can build from source, or there are debs floating around on the list for 3.7 that you should be able to install on 18.04. Regards, Adrien On Sep 23, 2019 w39d266, at 5:58 AM, Jon Schewe wrote: I'm using GnuCash 2.6.19 that ships with Ubuntu 18.04. I'm finding that the update price quotes process is hanging, both from within GnuCash and from the command line. I've created a CSV file of all of my commodities and tested them individual using gnc-fq-dump and they all return fairly quickly. Not all of them have valid prices, but none hang. Below is the script that I have used with cron in the past to update my quotes at regular intervals. When the process is running I can strace it and I find that the perl process is usually in a write call writing "use of uninitialized value". Does anyone have suggestions to determine why updating the quotes is hanging? Is this a problem with this version of gnucash? I would prefer to stick with the version of gnucash that comes with my distribution so that I get automatic updates, however I can build a custom version if that is what is needed. #!/bin/sh ALPHAVANTAGE_API_KEY=XXX export ALPHAVANTAGE_API_KEY env $(dbus-launch) sh -c 'trap "kill $DBUS_SESSION_BUS_PID" EXIT; /usr/bin/gnucash --add-price-quotes ${HOME}/Documents/banking/gnucash/accounts.gnucash' 2>&1 | grep -v "Found Finance::Quote" -- http://mtu.net/~jpschewe ___ 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. -- http://mtu.net/~jpschewe ___ 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. -- http://mtu.net/~jpschewe ___ 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] update quotes hanging
I just tried 3.7.0 from ppa:sicklylife/gnucash and the behavior hasn't changed. On 9/23/19 2:25 PM, Adrien Monteleone wrote: There are no updates to the 2.6 series any longer. 2.6.21 is the last one and nearly 18 months old. There have been eight 3.x releases so far. You can build from source, or there are debs floating around on the list for 3.7 that you should be able to install on 18.04. Regards, Adrien On Sep 23, 2019 w39d266, at 5:58 AM, Jon Schewe wrote: I'm using GnuCash 2.6.19 that ships with Ubuntu 18.04. I'm finding that the update price quotes process is hanging, both from within GnuCash and from the command line. I've created a CSV file of all of my commodities and tested them individual using gnc-fq-dump and they all return fairly quickly. Not all of them have valid prices, but none hang. Below is the script that I have used with cron in the past to update my quotes at regular intervals. When the process is running I can strace it and I find that the perl process is usually in a write call writing "use of uninitialized value". Does anyone have suggestions to determine why updating the quotes is hanging? Is this a problem with this version of gnucash? I would prefer to stick with the version of gnucash that comes with my distribution so that I get automatic updates, however I can build a custom version if that is what is needed. #!/bin/sh ALPHAVANTAGE_API_KEY=XXX export ALPHAVANTAGE_API_KEY env $(dbus-launch) sh -c 'trap "kill $DBUS_SESSION_BUS_PID" EXIT; /usr/bin/gnucash --add-price-quotes ${HOME}/Documents/banking/gnucash/accounts.gnucash' 2>&1 | grep -v "Found Finance::Quote" -- http://mtu.net/~jpschewe ___ 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. -- http://mtu.net/~jpschewe ___ 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] update quotes hanging
I'm using GnuCash 2.6.19 that ships with Ubuntu 18.04. I'm finding that the update price quotes process is hanging, both from within GnuCash and from the command line. I've created a CSV file of all of my commodities and tested them individual using gnc-fq-dump and they all return fairly quickly. Not all of them have valid prices, but none hang. Below is the script that I have used with cron in the past to update my quotes at regular intervals. When the process is running I can strace it and I find that the perl process is usually in a write call writing "use of uninitialized value". Does anyone have suggestions to determine why updating the quotes is hanging? Is this a problem with this version of gnucash? I would prefer to stick with the version of gnucash that comes with my distribution so that I get automatic updates, however I can build a custom version if that is what is needed. #!/bin/sh ALPHAVANTAGE_API_KEY=XXX export ALPHAVANTAGE_API_KEY env $(dbus-launch) sh -c 'trap "kill $DBUS_SESSION_BUS_PID" EXIT; /usr/bin/gnucash --add-price-quotes ${HOME}/Documents/banking/gnucash/accounts.gnucash' 2>&1 | grep -v "Found Finance::Quote" -- http://mtu.net/~jpschewe ___ 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.
Trouble with custom report options
All, I'm trying to create a report with some options that are disabled when others are not selected. Below are my 2 options. When I select the Memo option I get a critical error. Does anyone know why the set_selectable field is null? Am I missing some initialization. CRIT gnc_option_set_selectable: assertion 'option->odb->set_selectable != NULL' failed (gnc:register-trep-option (gnc:make-simple-boolean-option gnc:pagename-display (N_ "Notes") "d2" (N_ "Display the notes if the memo is unavailable?") #t)) ;; Add an option to display the memo, and disable the notes option ;; when memos are not included. (gnc:register-trep-option (gnc:make-complex-boolean-option gnc:pagename-display (N_ "Memo") "d" (N_ "Display the memo?") #t #f (lambda (x) (gnc-option-db-set-option-selectable-by-name gnc:*transaction-report-options* gnc:pagename-display (N_ "Notes") x Thank you, - Jon -- http://mtu.net/~jpschewe ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Virtual accounts or line items
I've got a question about using virtual accounts along with QFX imports. I found this thread about using virtual accounts to do budgeting: http://gnucash.1415818.n4.nabble.com/Virtual-accounts-td1421283.html I rather like how it works from the perspective that I know how much money is available in my checking account for things that I haven't budgeted. This also works well when reconciling against my statement as I can check the box to include sub-accounts and everything balances. However when I import a QFX file, the importer will only look at the top level account for transactions. This means that I need to manually clear the transactions in the sub-accounts. My wife uses Quickbooks at work and says there is a view that works for her for this. She can create these virtual sub-accounts and see their individual transactions, however when she looks at the top-level account she sees all transactions for the top account and the sub-accounts. Is there a way to do this in GnuCash? Thanks, - Jon -- http://mtu.net/~jpschewe ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Budget bar chart with sub-accounts
I did some debugging with the report and created a modified version that shows all accounts. I filed a bug with GnuCash with the fix at https://bugzilla.gnome.org/show_bug.cgi?id=785437. On Sun, Jul 23, 2017 at 5:58 PM, Jon Schewe <jpsch...@mtu.net> wrote: > Has anyone found a way to create a budget bar chart that sums the child > accounts? > > I have a budget for Medical and I have a Medical account and sub accounts > for Doctor and Prescription. I would like the bar chart to display the sum > of Medical, Medical:Doctor, and Medical:Prescription vs. the Medical > budget. > > I see that the text budget report does this. > > Right now I don't get any chart if the accounts have sub-accounts. > > Thanks > - Jon > > -- > http://mtu.net/~jpschewe > > -- http://mtu.net/~jpschewe ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Budget bar chart with sub-accounts
Has anyone found a way to create a budget bar chart that sums the child accounts? I have a budget for Medical and I have a Medical account and sub accounts for Doctor and Prescription. I would like the bar chart to display the sum of Medical, Medical:Doctor, and Medical:Prescription vs. the Medical budget. I see that the text budget report does this. Right now I don't get any chart if the accounts have sub-accounts. Thanks - Jon -- http://mtu.net/~jpschewe ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.