Re: [GNC] How to import MT940 and/or online banking missing in 5.5
André, There aren't any errors there, just progress messages. It's complaining that you don't have the setup files, but it doesn't need them for a plain file import. It's quite possible that your bank's MT940 format doesn't match either of the profiles. Different banks interpret MT940 spec differently resulting in incompatibilities, hence Martin's suggestion to use CAMT 0.53 instead. Regards, John Ralls > On Mar 27, 2024, at 15:17, An Ku wrote: > > Hi John, all > > I just ran it again with the debug enabled as per John's instructions. Again: > I have not done any kind of setup of online banking or anything like that, > I'm only going to File-Import-AQBanking-Swift on the left-Swift-MT940 on the > right side and click OK. Nothing happens after that. > I also tried the same with a camt53 file (choosing the related option in the > dialog) with the same result. > > I also noticed that I have a folder created on the 19. (probably that first > time I ran/installed 5.5.1) in my user folder called "aqbanking". It contain > 2 folders: > settings > This one is empty > settings6 > aqbanking > config.conf only contains one line: "int lastVersion="100992000"" > backends > aqebics.conf > aqhbci.conf > aqnone.conf > aqofxconnect.conf > aqpaypal.conf > > Here's the debug output: > * 22:48:47 ERROR > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_update.c: > 610: No AqBanking config folder found at > [C:\Users\[username]/aqbanking/settings6/users] (-1) > * 22:48:47 ERROR > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_update.c: > 610: No AqBanking config folder found at > [C:\Users\[username]/aqbanking/settings/users] (-1) > * 22:48:47 ERROR > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_update.c: > 411: There is no old settings folder, need initial setup > * 22:48:47 DEBUG started > * 22:48:47 INFO > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_init.c: >65: AqBanking v6.5.4.0stable: initialising > * 22:48:47 INFO > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_init.c: > 185: Registering bankinfo plugin manager > * 22:48:47 INFO > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_init.c: > 217: Registering provider plugin manager > * 22:48:47 INFO > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_init.c: > 249: Registering imexporters plugin manager > * 22:48:47 INFO > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: > 720: File "C:\Program Files > (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\amro940.conf" > contains profile "AMRO-MT940" > * 22:48:47 INFO > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: > 720: File "C:\Program Files > (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\amro942.conf" > contains profile "AMRO-MT942" > * 22:48:47 INFO > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: > 720: File "C:\Program Files > (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\fints940.conf" > contains profile "fints940" > * 22:48:47 INFO > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: > 720: File "C:\Program Files > (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\fints942.conf" > contains profile "fints942" > * 22:48:47 INFO > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: > 720: File "C:\Program Files > (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\swiftmt535.conf" > contains profile "SWIFT-MT535" > * 22:48:47 INFO > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: > 720: File "C:\Program Files > (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\swiftmt940.conf" > contains profile "SWIFT-MT940" > * 22:48:47 INFO > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: > 720: File "C:\Program Files > (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\swiftmt942.conf" > contains profile "SWIFT-MT942" > * 22:48:47 INFO > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: > 666: Path "C:\Users\[username]\aqbanking\imexporters\swift\profiles" is not > available > * 22:48:55 INFO > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: > 720: File "C:\Program Files > (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\amro940.conf" > contains profile "AMRO-MT940" > * 22:48:55 INFO > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: > 720: File "C:\Program Files > (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\amro942.conf" > contains profile "AMRO-MT942" > * 22:48:55 INFO >
Re: [GNC] Finance Quotes Yahoo off the rails again?
Hi
As i mentioned in an earlier email, this is extremely likely to be yahoo making
life difficult for web scrapers of their data. GNC will have to catch up to
what it is doing for a “permanent” solution.
It looks to be very much the same problem where various errors (402, 500 etc)
are returned by that same server. A temporary solution that MAY work if using
a VPN is to set it to appear like USA (say NY which did work for a while or
SanFran and sometime other countries around Europe and Asia). It seems to be
random. But the problem is linked to the login sessions not remaining valid
(but I’m not qualified to say exactly how).
The previous post also pointed to yahooquery which is a python webscraper
module and similar problems with yfinance (another similar module). You can
track it down in GitHub or the developer’s website.
Anyway, if I’m right this won’t go away and won’t fix itself.
Regards
James
> On 28 Mar 2024, at 12:43 pm, Kalpesh Patel wrote:
>
> Looking at "ERROR 429: Too Many Requests." I am guessing that they are
> throttling your queries because number of requests from IP address you have
> exceeds what they believe to be a normal person browsing would be making...
>
> -Original Message-
> From: David G. Pickett
> Sent: Wednesday, March 27, 2024 3:12 PM
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Finance Quotes Yahoo off the rails again?
>
> URLs are scraped off, so here I am on a plain text email client with more
> info on the bug. It looks like something on the web does not like some
> clients:
>
> From quote log:
>
> * AMEX:DXJ Finance::Quote reported failure with error: Error retrieving quote
> for DXJ. Attempt to fetch the URL
> https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=DXJ=price,summaryDetail,defaultKeyStatistics
> resulted in HTTP response 500 (Internal Server Error)
>
> Trying with wget:
>
> dgp@dgp-p6803w:~
> $ wget
> 'https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=DXJ=price,summaryDetail,defaultKeyStatistics'
>
> | timex wc
> --2024-03-26 14:18:10--
> https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=DXJ=price,summaryDetail,defaultKeyStatistics
> Resolving query2.finance.yahoo.com (query2.finance.yahoo.com)...
> 69.147.82.60, 69.147.82.61
> Connecting to query2.finance.yahoo.com
> (query2.finance.yahoo.com)|69.147.82.60|:443... connected.
> HTTP request sent, awaiting response... 429 Too Many Requests
> 2024-03-26 14:18:25 ERROR 429: Too Many Requests.
>
> 0 0 0
> real 15.11
> user 0.00
> sys 0.00
> dgp@dgp-p6803w:~
> $ wget
> 'https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=DXJ=price,summaryDetail,defaultKeyStatistics'
>
> | timex wc
> --2024-03-26 14:19:34--
> https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=DXJ=price,summaryDetail,defaultKeyStatistics
> Resolving query2.finance.yahoo.com (query2.finance.yahoo.com)...
> 69.147.82.60, 69.147.82.61
> Connecting to query2.finance.yahoo.com
> (query2.finance.yahoo.com)|69.147.82.60|:443... connected.
> HTTP request sent, awaiting response... 429 Too Many Requests
> 2024-03-26 14:19:50 ERROR 429: Too Many Requests.
>
> 0 0 0
> real 15.17
> user 0.00
> sys 0.00
> dgp@dgp-p6803w:~
> $
>
> With Google Chrome, get:
>
> https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=DXJ=price,summaryDetail,defaultKeyStatistics
>
> {"quoteSummary":{"result":[{"summaryDetail":{"maxAge":1,"priceHint":{"raw":2,"fmt":"2","longFmt":"2"},"previousClose":{"raw":107.84,"fmt":"107.84"},"open":{"raw":108.56,"fmt":"108.56"},"dayLow":{"raw":108.38,"fmt":"108.38"},"dayHigh":{"raw":108.88,"fmt":"108.88"},"regularMarketPreviousClose":{"raw":107.84,"fmt":"107.84"},"regularMarketOpen":{"raw":108.56,"fmt":"108.56"},"regularMarketDayLow":{"raw":108.38,"fmt":"108.38"},"regularMarketDayHigh":{"raw":108.88,"fmt":"108.88"},"dividendRate":{},"dividendYield":{},"exDividendDate":{},"payoutRatio":{},"fiveYearAvgDividendYield":{},"beta":{},"trailingPE":{"raw":12.077986,"fmt":"12.08"},"forwardPE":{},"volume":{"raw":515869,"fmt":"515.87k","longFmt":"515,869"},"regularMarketVolume":{"raw":515869,"fmt":"515.87k","longFmt":"515,869"},"averageVolume":{"raw":1097601,"fmt":"1.1M","longFmt":"1,097,601"},"averageVolume10days":{"raw":120,"fmt":"1.28M","longFmt":"1,277,770"},"averageDailyVolume10Day":{"raw":120,"fmt":"1.28M","longFmt":"1,277,
>
Re: [GNC] Finance Quotes Yahoo off the rails again?
I am no expert but I believe that it is not possible to upgrade finance-quote under flatpak. I believe the flatpak versions get their portability from the fact that a great deal is rolled into the package so that it does not need to have compatible dependencies. You might search the list archives. For example see https://lists.gnucash.org/pipermail/gnucash-devel/2022-October/046338.html Dale Dale On Wed, Mar 27, 2024 at 7:31 PM David G. Pickett wrote: > Still no advice on how to go to Finance Quote 1.59 under flatpak and Linux? > > I just checked for flatpak updates, none for GnuCash. It's been out for > a while but is still not attached to a new flatpak version. > > > ___ > 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] Finance Quotes Yahoo off the rails again?
Looking at "ERROR 429: Too Many Requests." I am guessing that they are
throttling your queries because number of requests from IP address you have
exceeds what they believe to be a normal person browsing would be making...
-Original Message-
From: David G. Pickett
Sent: Wednesday, March 27, 2024 3:12 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Finance Quotes Yahoo off the rails again?
URLs are scraped off, so here I am on a plain text email client with more info
on the bug. It looks like something on the web does not like some clients:
From quote log:
* AMEX:DXJ Finance::Quote reported failure with error: Error retrieving quote
for DXJ. Attempt to fetch the URL
https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=DXJ=price,summaryDetail,defaultKeyStatistics
resulted in HTTP response 500 (Internal Server Error)
Trying with wget:
dgp@dgp-p6803w:~
$ wget
'https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=DXJ=price,summaryDetail,defaultKeyStatistics'
| timex wc
--2024-03-26 14:18:10--
https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=DXJ=price,summaryDetail,defaultKeyStatistics
Resolving query2.finance.yahoo.com (query2.finance.yahoo.com)...
69.147.82.60, 69.147.82.61
Connecting to query2.finance.yahoo.com
(query2.finance.yahoo.com)|69.147.82.60|:443... connected.
HTTP request sent, awaiting response... 429 Too Many Requests
2024-03-26 14:18:25 ERROR 429: Too Many Requests.
0 0 0
real 15.11
user 0.00
sys 0.00
dgp@dgp-p6803w:~
$ wget
'https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=DXJ=price,summaryDetail,defaultKeyStatistics'
| timex wc
--2024-03-26 14:19:34--
https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=DXJ=price,summaryDetail,defaultKeyStatistics
Resolving query2.finance.yahoo.com (query2.finance.yahoo.com)...
69.147.82.60, 69.147.82.61
Connecting to query2.finance.yahoo.com
(query2.finance.yahoo.com)|69.147.82.60|:443... connected.
HTTP request sent, awaiting response... 429 Too Many Requests
2024-03-26 14:19:50 ERROR 429: Too Many Requests.
0 0 0
real 15.17
user 0.00
sys 0.00
dgp@dgp-p6803w:~
$
With Google Chrome, get:
https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=DXJ=price,summaryDetail,defaultKeyStatistics
{"quoteSummary":{"result":[{"summaryDetail":{"maxAge":1,"priceHint":{"raw":2,"fmt":"2","longFmt":"2"},"previousClose":{"raw":107.84,"fmt":"107.84"},"open":{"raw":108.56,"fmt":"108.56"},"dayLow":{"raw":108.38,"fmt":"108.38"},"dayHigh":{"raw":108.88,"fmt":"108.88"},"regularMarketPreviousClose":{"raw":107.84,"fmt":"107.84"},"regularMarketOpen":{"raw":108.56,"fmt":"108.56"},"regularMarketDayLow":{"raw":108.38,"fmt":"108.38"},"regularMarketDayHigh":{"raw":108.88,"fmt":"108.88"},"dividendRate":{},"dividendYield":{},"exDividendDate":{},"payoutRatio":{},"fiveYearAvgDividendYield":{},"beta":{},"trailingPE":{"raw":12.077986,"fmt":"12.08"},"forwardPE":{},"volume":{"raw":515869,"fmt":"515.87k","longFmt":"515,869"},"regularMarketVolume":{"raw":515869,"fmt":"515.87k","longFmt":"515,869"},"averageVolume":{"raw":1097601,"fmt":"1.1M","longFmt":"1,097,601"},"averageVolume10days":{"raw":120,"fmt":"1.28M","longFmt":"1,277,770"},"averageDailyVolume10Day":{"raw":120,"fmt":"1.28M","longFmt":"1,277,
770"},"bid":{"raw":108.82,"fmt":"108.82"},"ask":{"raw":108.83,"fmt":"108.83"},"bidSize":{"raw":1200,"fmt":"1.2k","longFmt":"1,200"},"askSize":{"raw":900,"fmt":"900","longFmt":"900"},"marketCap":{},"yield":{"raw":0.0293,"fmt":"2.93%"},"ytdReturn":{},"totalAssets":{"raw":4416737792,"fmt":"4.42B","longFmt":"4,416,737,792"},"expireDate":{},"strikePrice":{},"openInterest":{},"fiftyTwoWeekLow":{"raw":68.18,"fmt":"68.18"},"fiftyTwoWeekHigh":{"raw":109.28,"fmt":"109.28"},"priceToSalesTrailing12Months":{},"fiftyDayAverage":{"raw":100.636,"fmt":"100.64"},"twoHundredDayAverage":{"raw":90.06975,"fmt":"90.07"},"trailingAnnualDividendRate":{"raw":0.0,"fmt":"0.00"},"trailingAnnualDividendYield":{"raw":0.0,"fmt":"0.00%"},"navPrice":{"raw":107.95631,"fmt":"107.96"},"currency":"USD","fromCurrency":null,"lastMarket":null,"volume24Hr":{},"volumeAllCurrencies":{},"circulatingSupply":{},"algorithm":null,"maxSupply":{},"startDate":{},"tradeable":false},"defaultKeyStatistics":{"maxAge":1,"priceHint":{"raw"
:2,"fmt":"2","longFmt":"2"},"enterpriseValue":{},"forwardPE":{},"profitMargins":{},"morningStarOverallRating":{},"morningStarRiskRating":{},"category":"Japan
Stock","bookValue":{},"priceToBook":{},"annualReportExpenseRatio":{},"ytdReturn":{"raw":0.22916919,"fmt":"22.92%"},"beta3Year":{"raw":0.43,"fmt":"0.43"},"totalAssets":{"raw":4416737792,"fmt":"4.42B","longFmt":"4,416,737,792"},"yield":{"raw":0.0293,"fmt":"2.93%"},"fundFamily":"WisdomTree","fundInceptionDate":{"raw":1150416000,"fmt":"2006-06-16"},"legalType":"Exchange
Traded
Re: [GNC] How to import MT940 and/or online banking missing in 5.5
Hi John, all I just ran it again with the debug enabled as per John's instructions. Again: I have not done any kind of setup of online banking or anything like that, I'm only going to File-Import-AQBanking-Swift on the left-Swift-MT940 on the right side and click OK. Nothing happens after that. I also tried the same with a camt53 file (choosing the related option in the dialog) with the same result. I also noticed that I have a folder created on the 19. (probably that first time I ran/installed 5.5.1) in my user folder called "aqbanking". It contain 2 folders: - settings - This one is empty - settings6 - aqbanking - config.conf only contains one line: "int lastVersion="100992000"" - backends - aqebics.conf - aqhbci.conf - aqnone.conf - aqofxconnect.conf - aqpaypal.conf Here's the debug output: * 22:48:47 ERROR C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_update.c: 610: No AqBanking config folder found at [C:\Users\[username]/aqbanking/settings6/users] (-1) * 22:48:47 ERROR C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_update.c: 610: No AqBanking config folder found at [C:\Users\[username]/aqbanking/settings/users] (-1) * 22:48:47 ERROR C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_update.c: 411: There is no old settings folder, need initial setup * 22:48:47 DEBUG started * 22:48:47 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_init.c: 65: AqBanking v6.5.4.0stable: initialising * 22:48:47 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_init.c: 185: Registering bankinfo plugin manager * 22:48:47 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_init.c: 217: Registering provider plugin manager * 22:48:47 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_init.c: 249: Registering imexporters plugin manager * 22:48:47 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: 720: File "C:\Program Files (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\amro940.conf" contains profile "AMRO-MT940" * 22:48:47 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: 720: File "C:\Program Files (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\amro942.conf" contains profile "AMRO-MT942" * 22:48:47 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: 720: File "C:\Program Files (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\fints940.conf" contains profile "fints940" * 22:48:47 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: 720: File "C:\Program Files (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\fints942.conf" contains profile "fints942" * 22:48:47 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: 720: File "C:\Program Files (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\swiftmt535.conf" contains profile "SWIFT-MT535" * 22:48:47 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: 720: File "C:\Program Files (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\swiftmt940.conf" contains profile "SWIFT-MT940" * 22:48:47 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: 720: File "C:\Program Files (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\swiftmt942.conf" contains profile "SWIFT-MT942" * 22:48:47 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: 666: Path "C:\Users\[username]\aqbanking\imexporters\swift\profiles" is not available * 22:48:55 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: 720: File "C:\Program Files (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\amro940.conf" contains profile "AMRO-MT940" * 22:48:55 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: 720: File "C:\Program Files (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\amro942.conf" contains profile "AMRO-MT942" * 22:48:55 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: 720: File "C:\Program Files (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\fints940.conf" contains profile "fints940" * 22:48:55 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: 720: File "C:\Program Files (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\fints942.conf" contains profile "fints942" * 22:48:55 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: 720: File "C:\Program Files
Re: [GNC] Finance Quotes Yahoo off the rails again?
Still no advice on how to go to Finance Quote 1.59 under flatpak and Linux? I just checked for flatpak updates, none for GnuCash. It's been out for a while but is still not attached to a new flatpak version. ___ 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] Finance Quotes Yahoo off the rails again?
URLs are scraped off, so here I am on a plain text email client with
more info on the bug. It looks like something on the web does not like
some clients:
From quote log:
* AMEX:DXJ Finance::Quote reported failure with error: Error retrieving
quote for DXJ. Attempt to fetch the URL
https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=DXJ=price,summaryDetail,defaultKeyStatistics
resulted in HTTP response 500 (Internal Server Error)
Trying with wget:
dgp@dgp-p6803w:~
$ wget
'https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=DXJ=price,summaryDetail,defaultKeyStatistics'
| timex wc
--2024-03-26 14:18:10--
https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=DXJ=price,summaryDetail,defaultKeyStatistics
Resolving query2.finance.yahoo.com (query2.finance.yahoo.com)...
69.147.82.60, 69.147.82.61
Connecting to query2.finance.yahoo.com
(query2.finance.yahoo.com)|69.147.82.60|:443... connected.
HTTP request sent, awaiting response... 429 Too Many Requests
2024-03-26 14:18:25 ERROR 429: Too Many Requests.
0 0 0
real 15.11
user 0.00
sys 0.00
dgp@dgp-p6803w:~
$ wget
'https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=DXJ=price,summaryDetail,defaultKeyStatistics'
| timex wc
--2024-03-26 14:19:34--
https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=DXJ=price,summaryDetail,defaultKeyStatistics
Resolving query2.finance.yahoo.com (query2.finance.yahoo.com)...
69.147.82.60, 69.147.82.61
Connecting to query2.finance.yahoo.com
(query2.finance.yahoo.com)|69.147.82.60|:443... connected.
HTTP request sent, awaiting response... 429 Too Many Requests
2024-03-26 14:19:50 ERROR 429: Too Many Requests.
0 0 0
real 15.17
user 0.00
sys 0.00
dgp@dgp-p6803w:~
$
With Google Chrome, get:
https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=DXJ=price,summaryDetail,defaultKeyStatistics
{"quoteSummary":{"result":[{"summaryDetail":{"maxAge":1,"priceHint":{"raw":2,"fmt":"2","longFmt":"2"},"previousClose":{"raw":107.84,"fmt":"107.84"},"open":{"raw":108.56,"fmt":"108.56"},"dayLow":{"raw":108.38,"fmt":"108.38"},"dayHigh":{"raw":108.88,"fmt":"108.88"},"regularMarketPreviousClose":{"raw":107.84,"fmt":"107.84"},"regularMarketOpen":{"raw":108.56,"fmt":"108.56"},"regularMarketDayLow":{"raw":108.38,"fmt":"108.38"},"regularMarketDayHigh":{"raw":108.88,"fmt":"108.88"},"dividendRate":{},"dividendYield":{},"exDividendDate":{},"payoutRatio":{},"fiveYearAvgDividendYield":{},"beta":{},"trailingPE":{"raw":12.077986,"fmt":"12.08"},"forwardPE":{},"volume":{"raw":515869,"fmt":"515.87k","longFmt":"515,869"},"regularMarketVolume":{"raw":515869,"fmt":"515.87k","longFmt":"515,869"},"averageVolume":{"raw":1097601,"fmt":"1.1M","longFmt":"1,097,601"},"averageVolume10days":{"raw":120,"fmt":"1.28M","longFmt":"1,277,770"},"averageDailyVolume10Day":{"raw":120,"fmt":"1.28M","longFmt":"1,277,770"},"bid":{"raw":108.82,"fmt":"108.82"},"ask":{"raw":108.83,"fmt":"108.83"},"bidSize":{"raw":1200,"fmt":"1.2k","longFmt":"1,200"},"askSize":{"raw":900,"fmt":"900","longFmt":"900"},"marketCap":{},"yield":{"raw":0.0293,"fmt":"2.93%"},"ytdReturn":{},"totalAssets":{"raw":4416737792,"fmt":"4.42B","longFmt":"4,416,737,792"},"expireDate":{},"strikePrice":{},"openInterest":{},"fiftyTwoWeekLow":{"raw":68.18,"fmt":"68.18"},"fiftyTwoWeekHigh":{"raw":109.28,"fmt":"109.28"},"priceToSalesTrailing12Months":{},"fiftyDayAverage":{"raw":100.636,"fmt":"100.64"},"twoHundredDayAverage":{"raw":90.06975,"fmt":"90.07"},"trailingAnnualDividendRate":{"raw":0.0,"fmt":"0.00"},"trailingAnnualDividendYield":{"raw":0.0,"fmt":"0.00%"},"navPrice":{"raw":107.95631,"fmt":"107.96"},"currency":"USD","fromCurrency":null,"lastMarket":null,"volume24Hr":{},"volumeAllCurrencies":{},"circulatingSupply":{},"algorithm":null,"maxSupply":{},"startDate":{},"tradeable":false},"defaultKeyStatistics":{"maxAge":1,"priceHint":{"raw":2,"fmt":"2","longFmt":"2"},"enterpriseValue":{},"forwardPE":{},"profitMargins":{},"morningStarOverallRating":{},"morningStarRiskRating":{},"category":"Japan
Stock","bookValue":{},"priceToBook":{},"annualReportExpenseRatio":{},"ytdReturn":{"raw":0.22916919,"fmt":"22.92%"},"beta3Year":{"raw":0.43,"fmt":"0.43"},"totalAssets":{"raw":4416737792,"fmt":"4.42B","longFmt":"4,416,737,792"},"yield":{"raw":0.0293,"fmt":"2.93%"},"fundFamily":"WisdomTree","fundInceptionDate":{"raw":1150416000,"fmt":"2006-06-16"},"legalType":"Exchange
Traded
Re: [GNC] How to import MT940 and/or online banking missing in 5.5
Hi John
I follow the import process exactly as you describe it and not the Online
Banking. See my earlier email.
I'll do the debug and let you know.
Thanks and best regards.
André
On Wed, 27 Mar 2024, 09:32 john, wrote:
> Please copy the list on all replies.
>
> The error suggest that you're trying to do a direct-bank download (FinTS,
> PayPal, or OFX DirectConnect) without having setup online banking. That's a
> bit odd on its own because GnuCash usually won't enable those menu
> selections (in Actions>Online Banking) without having run the AQBanking
> setup assistant in Tools>Online banking.
>
> You don't need any of that to import an MT940 file. Use File>Import>Import
> using AQBanking and select Swift on the left and SWIFT-MT940 (unless you're
> an AMRO customer, in which case use AMRO-MT940) then click OK to select a
> file and proceed with the import.
>
> The Windows equivalent of Unix's `export` is `set` in CMD, e.g. `set
> AQBANKING_LOGLEVEL=debug`. After doing that run GnuCash with `"C:\Program
> Files (x86)\gnucash\bin\gnucash.exe" --log aqbanking=debug`. Don't include
> the backticks (`), do include the double quotes (").
>
> Regards,
> John Ralls
>
>
> On Mar 27, 2024, at 08:32, An Ku wrote:
>
> Hi John
>
> Thanks, I have 5.5.1 and get the error message I posted above when I try
> to import.
>
> Any thoughts?
>
>
> On Wed, 27 Mar 2024, 08:22 john, wrote:
>
>> You don't need to install AQBanking separately. There was a linking
>> problem with AQBanking in the original gnucash-5.5.setup.exe. You can
>> install gnucash-5.5-1.setup.exe from the usual places or wait until next
>> week and install GnuCash 5.6 that I'll release on Sunday.
>>
>> Regards,
>> John Ralls
>>
>>
>> > On Mar 24, 2024, at 15:11, An Ku wrote:
>> >
>> > It seems there is some issue with AQBanking related to a missing config
>> > file? As mentioned, I did not understand how I can install AQBanking
>> > separately on Windows. I did a clean start of GnuCash and only tried to
>> > import. This is what the Gnucash tracefile shows:
>> >
>> > * 14:57:04 WARN Could not locate file AUTHORS
>> > * 14:57:04 WARN Could not locate file DOCUMENTERS
>> > * 14:57:04 WARN Could not locate file LICENSE
>> > * 15:01:05 ERROR
>> >
>> C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_update.c:
>> > 610: No AqBanking config folder found at
>> > [C:\Users\[username]/aqbanking/settings6/users] (-1)
>> > * 15:01:05 ERROR
>> >
>> C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_update.c:
>> > 610: No AqBanking config folder found at
>> > [C:\Users\[username]/aqbanking/settings/users] (-1)
>> > * 15:01:05 ERROR
>> >
>> C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_update.c:
>> > 411: There is no old settings folder, need initial setup
>> > * 15:01:12 ERROR
>> >
>> C:/gcdev64/gnucash/releases/src/gwenhywfar-5.10.2/src/os/windows/syncio_file.c:
>> > 220: Error opening
>> > file[C:\Users\[username]\[path_to_file]\MT940_140324.sta]: 3
>> > * 15:01:12 WARN gnc_file_aqbanking_import:
>> Error on
>> > import
>> >
>> > If necessary, please let me know how I can increase the loglevel. I did
>> not
>> > understand how to do it on Windows reading the following pages:
>> > https://wiki.gnucash.org/wiki/AqBanking#Debugging
>> > https://wiki.gnucash.org/wiki/Logging
>> >
>> > Thanks all for the help!
>> >
>> > On Wed, Mar 20, 2024 at 1:28 AM Frank H. Ellenberger <
>> > frank.h.ellenber...@gmail.com> wrote:
>> >
>> >>
>> >>
>> >> Am 19.03.24 um 23:49 schrieb An Ku:
>> >>> Hi all
>> >>> Yes thank you, I was on 5.5 and those options were not available. I
>> have
>> >>> read about AQbanking but neither did the setup option exist nor the
>> >> import
>> >>> option.
>> >>>
>> >>> Installing 5.5.1 I do see those now. However, when I go to
>> >>> File>Import>Import using AQBanking and select swift>SWIFT-MT940
>> followed
>> >> by
>> >>> the file, nothing happens. The window closes and that's it. I have not
>> >> done
>> >>> any kind of AQBanking installation or similar or any Online Banking
>> >> setup.
>> >>
>> >> Our packages (Windows, Macos, Flatpak) include AqBanking. Only Linux
>> and
>> >> similar users mihgt have to install it separatly.
>> >>
>> >>> Is there anything I should set up first before using the Import
>> option?
>> >>
>> >> No, the setup serves to configure bank connections, e.g. your paypal
>> >> account.
>> >>
>> >>> If there's a howto I have not been able to find I would appreciate a
>> >> link.
>> >>
>> >> There is only a small paragraph in the manual:
>> >>
>> >>
>> https://code.gnucash.org/docs/C/gnucash-manual/trans-import.html#trans-import-aqbanking
>> >>
>> >> In your case the trace file
>> >> https://wiki.gnucash.org/wiki/Tracefile
>> >> could contain a clue.
>> >>
>> >>> Thanks again for your help
>> >>
>> >> HTH
>> >> Frank
>> >>
>> >>> On Sat, Mar 16, 2024 at 5:00 PM Frank H. Ellenberger <
>> >>> frank.h.ellenber...@gmail.com> wrote:
>> >>>
>>
Re: [GNC] Gnucash Frozen
Murugan, Thanks for the suggestions. I tried them both and didn't make any progress. Then I tried the obvious and opened the immediately preceding .gnucash file. This file worked fine. All I have to do is re-enter the entries I made, not a big project. Abe On 3/27/2024 14:57, Murugan Muruganandam wrote: couple of trials you can do 1. check the last log file and open it and see if it is allowing you to enter , if so you have re enter the last bit of transactions 2. other way is, copy the file to a different directly in windows and try opening it Saludos Cordiales Murugan *From:* gnucash-user on behalf of Abe Sternberg *Sent:* Wednesday, March 27, 2024 2:58 PM *To:* adrien.montele...@lusfiber.net ; gnucash-u...@lists.gnucash.org *Subject:* Re: [GNC] Gnucash Frozen Gnucash is 5.0 and Windows 11 Home, 23H2. Single monitor and no "ghost" monitor. Do you think I should go back to an earlier file? Abe On 3/27/2024 12:52, Adrien Monteleone wrote: > Anytime you have a problem, please report the GnuCash version and > Operating System you are using. > > As for the issue at hand, my first guess is a hidden window has input > control, but your OS allows you to scroll other 'background' windows. > (I know MacOS and some Linux distributions can do this, not sure of > Windows) > > How to discover if another GnuCash window/dialog has control, but is > simply overlaid by the main window, or is otherwise hidden, will > depend on your OS and setup. Another possibility, is if you are using > multi-monitor setup, the other window could be on another monitor, or > *think* it is on another monitor that isn't on/connected. > > Of course, all of the above is just a guess. We need more info. > > Regards, > Adrien > > On 3/27/24 10:11 AM, Abe Sternberg wrote: >> I've got myself into a pickle and have no idea how it happened or how >> to fix it. Gnucash has one file for my non-profit and one for my >> personal expenses. The personal expenses file is working fine, my >> non--profit displays correctly but will not take any input at all. >> >> The cursor moves up and down the register and that is all - no data >> entry, none of the actions work, etc. >> >> Does anyone have any idea on what I did and how to fix it? > > ___ > 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] Gnucash Frozen
couple of trials you can do 1. check the last log file and open it and see if it is allowing you to enter , if so you have re enter the last bit of transactions 2. other way is, copy the file to a different directly in windows and try opening it Saludos Cordiales Murugan From: gnucash-user on behalf of Abe Sternberg Sent: Wednesday, March 27, 2024 2:58 PM To: adrien.montele...@lusfiber.net ; gnucash-u...@lists.gnucash.org Subject: Re: [GNC] Gnucash Frozen Gnucash is 5.0 and Windows 11 Home, 23H2. Single monitor and no "ghost" monitor. Do you think I should go back to an earlier file? Abe On 3/27/2024 12:52, Adrien Monteleone wrote: > Anytime you have a problem, please report the GnuCash version and > Operating System you are using. > > As for the issue at hand, my first guess is a hidden window has input > control, but your OS allows you to scroll other 'background' windows. > (I know MacOS and some Linux distributions can do this, not sure of > Windows) > > How to discover if another GnuCash window/dialog has control, but is > simply overlaid by the main window, or is otherwise hidden, will > depend on your OS and setup. Another possibility, is if you are using > multi-monitor setup, the other window could be on another monitor, or > *think* it is on another monitor that isn't on/connected. > > Of course, all of the above is just a guess. We need more info. > > Regards, > Adrien > > On 3/27/24 10:11 AM, Abe Sternberg wrote: >> I've got myself into a pickle and have no idea how it happened or how >> to fix it. Gnucash has one file for my non-profit and one for my >> personal expenses. The personal expenses file is working fine, my >> non--profit displays correctly but will not take any input at all. >> >> The cursor moves up and down the register and that is all - no data >> entry, none of the actions work, etc. >> >> Does anyone have any idea on what I did and how to fix it? > > ___ > 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] Gnucash Frozen
Gnucash is 5.0 and Windows 11 Home, 23H2. Single monitor and no "ghost" monitor. Do you think I should go back to an earlier file? Abe On 3/27/2024 12:52, Adrien Monteleone wrote: Anytime you have a problem, please report the GnuCash version and Operating System you are using. As for the issue at hand, my first guess is a hidden window has input control, but your OS allows you to scroll other 'background' windows. (I know MacOS and some Linux distributions can do this, not sure of Windows) How to discover if another GnuCash window/dialog has control, but is simply overlaid by the main window, or is otherwise hidden, will depend on your OS and setup. Another possibility, is if you are using multi-monitor setup, the other window could be on another monitor, or *think* it is on another monitor that isn't on/connected. Of course, all of the above is just a guess. We need more info. Regards, Adrien On 3/27/24 10:11 AM, Abe Sternberg wrote: I've got myself into a pickle and have no idea how it happened or how to fix it. Gnucash has one file for my non-profit and one for my personal expenses. The personal expenses file is working fine, my non--profit displays correctly but will not take any input at all. The cursor moves up and down the register and that is all - no data entry, none of the actions work, etc. Does anyone have any idea on what I did and how to fix it? ___ 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] Updating gnucash
David, I could be mistaken, but I thought that the 'All' function negated the need to be viewing the CoA when running it, and that the non-All function operates as you describe. (context aware) Good tip about the task manager. Sometimes the process is so fast, you aren't sure if it completed or is stuck. While I think there is feedback in the status bar of GnuCash, if it is really quick, you'll never notice. Perhaps a dismiss-able confirmation dialog would be more reassuring. Regards, Adrien On 3/27/24 12:25 PM, David Carlson wrote: I agree with Adrien wholeheartedly. It is important to note that the Check and Repair function has a different scope of operation depending on which type of window has the current focus when it is invoked, and that if started from a window that allows access to the entire inventory of transactions, such as the chart of accounts window (I think), the process may take a considerable amount of time, possibly an hour or longer in some cases, so it would be desirable to have a task manager running in your OS to help determine when the action is complete. ___ 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] Updating gnucash
I agree with Adrien wholeheartedly. It is important to note that the Check and Repair function has a different scope of operation depending on which type of window has the current focus when it is invoked, and that if started from a window that allows access to the entire inventory of transactions, such as the chart of accounts window (I think), the process may take a considerable amount of time, possibly an hour or longer in some cases, so it would be desirable to have a task manager running in your OS to help determine when the action is complete. On Wed, Mar 27, 2024 at 11:47 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > In addition to the advice given by the other replies, it is advised to > run Actions > Check & Repair > Check & Repair All when first opening a > file after an upgrade between major releases. > > These checks and repairs are supposed to run automatically, but that > doesn't always go smoothly or completely for everyone, hence the > recommendation to do so manually. > > The only other concern with an upgrade would be if you had custom > reports that use deprecated code in the new version. But this is rare. > By 'custom' I mean either you, or someone for you, coded them in Scheme. > I'm not referring to merely Saved Configurations of included reports. > > Regards, > Adrien > > On 3/24/24 11:37 AM, Nathan Rosenthal wrote: > > I am currently running version 4.12 for two different organizations. > > > > If I was to update to 5.12 would I just download it and install it into > > the same folders or would I need to transfer the data files? > > ___ > 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. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Gnucash Frozen
Anytime you have a problem, please report the GnuCash version and Operating System you are using. As for the issue at hand, my first guess is a hidden window has input control, but your OS allows you to scroll other 'background' windows. (I know MacOS and some Linux distributions can do this, not sure of Windows) How to discover if another GnuCash window/dialog has control, but is simply overlaid by the main window, or is otherwise hidden, will depend on your OS and setup. Another possibility, is if you are using multi-monitor setup, the other window could be on another monitor, or *think* it is on another monitor that isn't on/connected. Of course, all of the above is just a guess. We need more info. Regards, Adrien On 3/27/24 10:11 AM, Abe Sternberg wrote: I've got myself into a pickle and have no idea how it happened or how to fix it. Gnucash has one file for my non-profit and one for my personal expenses. The personal expenses file is working fine, my non--profit displays correctly but will not take any input at all. The cursor moves up and down the register and that is all - no data entry, none of the actions work, etc. Does anyone have any idea on what I did and how to fix it? ___ 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] Updating gnucash
In addition to the advice given by the other replies, it is advised to run Actions > Check & Repair > Check & Repair All when first opening a file after an upgrade between major releases. These checks and repairs are supposed to run automatically, but that doesn't always go smoothly or completely for everyone, hence the recommendation to do so manually. The only other concern with an upgrade would be if you had custom reports that use deprecated code in the new version. But this is rare. By 'custom' I mean either you, or someone for you, coded them in Scheme. I'm not referring to merely Saved Configurations of included reports. Regards, Adrien On 3/24/24 11:37 AM, Nathan Rosenthal wrote: I am currently running version 4.12 for two different organizations. If I was to update to 5.12 would I just download it and install it into the same folders or would I need to transfer the data files? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Gnucash Frozen
I've got myself into a pickle and have no idea how it happened or how to fix it. Gnucash has one file for my non-profit and one for my personal expenses. The personal expenses file is working fine, my non--profit displays correctly but will not take any input at all. The cursor moves up and down the register and that is all - no data entry, none of the actions work, etc. Does anyone have any idea on what I did and how to fix it? Thanks, Abe ___ 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] Updating gnucash
I am currently running version 4.12 for two different organizations. If I was to update to 5.12 would I just download it and install it into the same folders or would I need to transfer the data files? Nathan Because this keeps coming up ... The DATA files (your books, etc.) and the program files (the executable) are NOT the same thing. You do not have to do anything to the data files just because you are changing the program. That said, ALWAYS make back ups before a major change (in addition to your normal back up procedure). As a retired pro, in addition to making a "build" back up of the data, I would also copy the executable, make a copy of the directory containing the executable << rename it --- then do the reinstall. If all goes well with the "build" you later delete the old (renamed) directory. But if the build fails, you can back it out quickly by deleting the new directory (created during the install) and rename the old one back. This is NOT specific gnucash advice. It's for any application you use. Michael D Novack PS --- If you had an application that did store data in the executable STOP USING IT. Find an alternative. Data in programs would be really bad practice for anything written in the last 60 years << before then you did sometimes see this >> ___ 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] How to import MT940 and/or online banking missing in 5.5
Please copy the list on all replies.
The error suggest that you're trying to do a direct-bank download (FinTS,
PayPal, or OFX DirectConnect) without having setup online banking. That's a bit
odd on its own because GnuCash usually won't enable those menu selections (in
Actions>Online Banking) without having run the AQBanking setup assistant in
Tools>Online banking.
You don't need any of that to import an MT940 file. Use File>Import>Import
using AQBanking and select Swift on the left and SWIFT-MT940 (unless you're an
AMRO customer, in which case use AMRO-MT940) then click OK to select a file and
proceed with the import.
The Windows equivalent of Unix's `export` is `set` in CMD, e.g. `set
AQBANKING_LOGLEVEL=debug`. After doing that run GnuCash with `"C:\Program Files
(x86)\gnucash\bin\gnucash.exe" --log aqbanking=debug`. Don't include the
backticks (`), do include the double quotes (").
Regards,
John Ralls
> On Mar 27, 2024, at 08:32, An Ku wrote:
>
> Hi John
>
> Thanks, I have 5.5.1 and get the error message I posted above when I try to
> import.
>
> Any thoughts?
>
>
> On Wed, 27 Mar 2024, 08:22 john, > wrote:
>> You don't need to install AQBanking separately. There was a linking problem
>> with AQBanking in the original gnucash-5.5.setup.exe. You can install
>> gnucash-5.5-1.setup.exe from the usual places or wait until next week and
>> install GnuCash 5.6 that I'll release on Sunday.
>>
>> Regards,
>> John Ralls
>>
>>
>> > On Mar 24, 2024, at 15:11, An Ku > > > wrote:
>> >
>> > It seems there is some issue with AQBanking related to a missing config
>> > file? As mentioned, I did not understand how I can install AQBanking
>> > separately on Windows. I did a clean start of GnuCash and only tried to
>> > import. This is what the Gnucash tracefile shows:
>> >
>> > * 14:57:04 WARN Could not locate file AUTHORS
>> > * 14:57:04 WARN Could not locate file DOCUMENTERS
>> > * 14:57:04 WARN Could not locate file LICENSE
>> > * 15:01:05 ERROR
>> > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_update.c:
>> > 610: No AqBanking config folder found at
>> > [C:\Users\[username]/aqbanking/settings6/users] (-1)
>> > * 15:01:05 ERROR
>> > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_update.c:
>> > 610: No AqBanking config folder found at
>> > [C:\Users\[username]/aqbanking/settings/users] (-1)
>> > * 15:01:05 ERROR
>> > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_update.c:
>> > 411: There is no old settings folder, need initial setup
>> > * 15:01:12 ERROR
>> > C:/gcdev64/gnucash/releases/src/gwenhywfar-5.10.2/src/os/windows/syncio_file.c:
>> > 220: Error opening
>> > file[C:\Users\[username]\[path_to_file]\MT940_140324.sta]: 3
>> > * 15:01:12 WARN gnc_file_aqbanking_import: Error on
>> > import
>> >
>> > If necessary, please let me know how I can increase the loglevel. I did not
>> > understand how to do it on Windows reading the following pages:
>> > https://wiki.gnucash.org/wiki/AqBanking#Debugging
>> > https://wiki.gnucash.org/wiki/Logging
>> >
>> > Thanks all for the help!
>> >
>> > On Wed, Mar 20, 2024 at 1:28 AM Frank H. Ellenberger <
>> > frank.h.ellenber...@gmail.com >
>> > wrote:
>> >
>> >>
>> >>
>> >> Am 19.03.24 um 23:49 schrieb An Ku:
>> >>> Hi all
>> >>> Yes thank you, I was on 5.5 and those options were not available. I have
>> >>> read about AQbanking but neither did the setup option exist nor the
>> >> import
>> >>> option.
>> >>>
>> >>> Installing 5.5.1 I do see those now. However, when I go to
>> >>> File>Import>Import using AQBanking and select swift>SWIFT-MT940 followed
>> >> by
>> >>> the file, nothing happens. The window closes and that's it. I have not
>> >> done
>> >>> any kind of AQBanking installation or similar or any Online Banking
>> >> setup.
>> >>
>> >> Our packages (Windows, Macos, Flatpak) include AqBanking. Only Linux and
>> >> similar users mihgt have to install it separatly.
>> >>
>> >>> Is there anything I should set up first before using the Import option?
>> >>
>> >> No, the setup serves to configure bank connections, e.g. your paypal
>> >> account.
>> >>
>> >>> If there's a howto I have not been able to find I would appreciate a
>> >> link.
>> >>
>> >> There is only a small paragraph in the manual:
>> >>
>> >> https://code.gnucash.org/docs/C/gnucash-manual/trans-import.html#trans-import-aqbanking
>> >>
>> >> In your case the trace file
>> >> https://wiki.gnucash.org/wiki/Tracefile
>> >> could contain a clue.
>> >>
>> >>> Thanks again for your help
>> >>
>> >> HTH
>> >> Frank
>> >>
>> >>> On Sat, Mar 16, 2024 at 5:00 PM Frank H. Ellenberger <
>> >>> frank.h.ellenber...@gmail.com >
>> >>> wrote:
>> >>>
>> I suspect, André is aWindows user and needs to upgrade to 5.5-1:
>>
>>
>> >>
Re: [GNC] Updating gnucash
The update process depends on your operating system. But keep in mind that GnuCash is only up to 5.5 (soon to be 5.6). David T. On Mar 27, 2024, 4:35 AM, at 4:35 AM, Nathan Rosenthal wrote: >I am currently running version 4.12 for two different organizations. > >If I was to update to 5.12 would I just download it and install it into > >the same folders or would I need to transfer the data files? > >Nathan >___ >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.
