Re: [GNC] Can't open old GnuCash file

[Kevin Buckley via gnucash-user]

On Friday, February 16th, 2024 at 09:00, MegaBrutal  
wrote:
>  
> Hello,
> 
> I've been using GnuCash between 2015 to 2017 to help to straighten out
> my personal finances. ...
> 
> Now I got a situation that I'm looking for certain transactions from
> around that time and I remembered that I should check my old GnuCash
> file, untouched since 2017-09-21. To my shock, the modern GnuCash
> version that comes with my distro (Ubuntu 23.10) crashes when I try to
> open my old file. ...

If I am reading the Git logs correctly, then Release 2.6.18 came out
one day after you last saved your file, and there were three more
2.6 releases to come after that.

It will definitely be worth your while to try opening the file with
a version 3, saving that if you can open it, and opening the new file 
with a v4, then saving that and opening that one with a v5.

There will have been some changes to the underlying file format, since 
the 2.6 series, but as to whether such changes are the exact cause of 
what you are seeing, you going to have to try out older versions to 
narrow things down.

Of course, if you only want to look at certain transactions from
before Sep 2017, then opening your file with a 2.6 series Gnucash
would be the way to go.

If you find that you can't even open your file with a v2, then a 
possibly corrupted file may be the root cause of what's happening.




___
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 get rid of "unrealized losses"

[Nicolas Korber]

No, they were not. When enabled the "unrealized losses" disappear. That 
was the trick ! Thanks a lot.



Le 07.02.24 à 15:44, James Edmunds a écrit :
Are Trading Accounts enabled  in your system ?    . File ->, 
Properties ->, Accounts


*From:* gnucash-user 
 on behalf of 
Nicolas Korber 

*Sent:* 05 February 2024 14:12
*To:* gnucash-user@gnucash.org 
*Subject:* Re: [GNC] How to get rid of "unrealized losses"
Hello,

I also have "unrealized losses" but with much larger amount. I use two
different currencies (EUR and CHF). These "unrealized losses" are a
consequence of variations in the currencies. I found the reason but
unfortunately not a mean to "realize" the losses and begin the next year
with a "clean" balance. Of course is it possible to set an artificial
currency so that these losses go to zero but it is not an acceptable
solution. Does it help you to one step further ?

Le 03.02.24 à 18:00, gnucash-user-requ...@gnucash.org a écrit :
> Message: 1
> Date: Sat, 3 Feb 2024 01:00:48 + (UTC)
> From: "Fiable.biz"
> To:"gnucash-user@gnucash.org" 
> Subject: [GNC] How to get rid of "unrealized losses"
> Message-ID:<1325621549.7237383.1706922048...@mail.yahoo.com>
> Content-Type: text/plain; charset=UTF-8
>
> Hello,
> For an unknown reason, I get unwanted "unrealized losses" of 0.01? 
in my balance sheet. How to remove this? I'm ready to use an 
expeditious means: no tax inspector will blame me for having cheated 
by 0.01?, and this will not significantly impact the accuracy of my 
business representation.

> Thank you in advance.
___
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] Can't open old GnuCash file

[Adrien Monteleone]

Incremental updates, yes, but you jumped 4 major versions and skipped 
those incremental updates.


The recommended process (in the wiki FAQ) is to upgrade in steps to each 
of the final releases of each major release, running Actions > Check & 
Repair > Check & Repair All upon first opening the file after each upgrade.


In your case, that is likely:

2.6.21 -> 3.11 -> 4.14 -> 5.3

remove 5.3, install 2.6.21 and proceed.

If you can't get 2.6.21 to install on Ubuntu 23.10, the easiest path 
would be to install an older Ubuntu (likely 16.04) in a virtual machine 
and install 2.6.21 there to do the check & repair. Repeat as needed for 
each gnucash version, but you will likely be okay using 23.10 from 4.x 
onward.


Regards,
Adrien

On 2/15/24 7:00 PM, MegaBrutal wrote:

Hello,

I've been using GnuCash between 2015 to 2017 to help to straighten out
my personal finances. Due to changes in my life, my transaction count
increased significantly which required more and more time to enter,
while I got less free time to do the accounting. Meanwhile, my
financial problems basically got resolved and my motivation to keep on
updating my GnuCash file dropped significantly.

Now I got a situation that I'm looking for certain transactions from
around that time and I remembered that I should check my old GnuCash
file, untouched since 2017-09-21. To my shock, the modern GnuCash
version that comes with my distro (Ubuntu 23.10) crashes when I try to
open my old file. Here is my GnuCash version and the backtrace I get:

---

GnuCash 5.3
Build ID: 5.3+(2023-06-26)

Backtrace:
In ice-9/boot-9.scm:
   1752:10  5 (with-exception-handler _ _ #:unwind? _ #:unwind-for-type _)
In unknown file:
4 (apply-smob/0 #)
In ice-9/boot-9.scm:
2836:4  3 (save-module-excursion #)
In ice-9/eval-string.scm:
  38:6  2 (read-and-eval # #:lang _)
In ice-9/eval.scm:
 619:8  1 (_ #(#
# *
563d43f24190>))
In unknown file:
0 (GncOption-set-value # (absolute
1496181600 . 0))

ERROR: In procedure GncOption-set-value:
Wrong type (expecting exact integer): (1496181600 . 0)

Some deprecated features have been used.  Set the environment
variable GUILE_WARN_DEPRECATED to "detailed" and rerun the
program to get more information.  Set it to "no" to suppress
this message.

---

Maybe I was wrong that I expected some backward compatibility that
modern versions are capable of performing incremental updates to old
files to update it to the current file format... What to do now? Any
suggestions?


Best regards,
MegaBrutal
___
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] Looking how to automatically download transactions from Capital One

[Kalpesh Patel]

Matatia -

First check https://www.ofxhome.com/index.php/home/directory to make sure that 
CapitalOne is still supporting OFX downloads. Ditto for PayPal...

If OFX download is still a live thing, then you can generate a client UID (see 
https://www.tenforums.com/tutorials/130522-generate-globally-unique-identifier-guid-windows.html
 for Windows platform or goto https://www.uuidgenerator.net/ to generate one 
online). Then you can add that UUID as 'Client ID" in AqBanking setup screen. 
With UUID, you will have to play with whether Capital One wants all alpha to be 
upper cases or it will tolerate lowered cases, and whether it wants dash 
separators or not  (experimenting is going to be your friend).

See more details in the document at 
https://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect for it.

If you "tech savvy" then you can also manually edit the corresponding AqBanking 
configuration file somewhere in 'C:\Users\\aqbanking' (cd 
%USERPROFILE%\aqbanking) tree for Windows if you are familiar with it. Looking 
at Chase's example at 
https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings shows that you 
can add 'clientuid = ' stanza to the config for Capital One once 
you find the corresponding AqBanking config file. 

This is I am going off my head

-Original Message-
From: Matatia Chetrit  
Sent: Friday, February 16, 2024 11:56 AM
To: gnucash-user@gnucash.org
Subject: [GNC] Looking how to automatically download transactions from Capital 
One

bs"d

Hello. I looked for ways to automatically download transactions from Capital 
One.
I tried the Online Banking Setup interface of Aq Banking  - OFX Didn't work 
with the credentials:

CapitalOne (Banking)https://ofx.capitalone.com/ofx/103/process.ofx
**OFX Version=103;APPID=MDNC;APPVER=2012. Must have CLIENTUID set.
1001Capital One Whatever your routing number is 


  "id" = "md:1052"
  "access_type" = "OFX"
  "ofx_version" = "103"
  "fi_name" = "Capital One Bank (Not Credit Cards)"
  "bootstrap_url" =
"https://onlinebanking.capitalone.com/ofx/process.ofx";
  "fi_id" = "1001"
  "uses_fi_tag" = "y"
  "app_id" = "MDNC"
  "fi_org" = "Hibernia"
  "app_ver" = "2012"
}
{
  "id" = "md:2019"
  "uses_fi_tag" = "y"
  "access_type" = "OFX"
  "fi_name" = "Capital One Bank (Not Credit Cards)"
  "bootstrap_url" = "https://ofx.capitalone.com/ofx/103/process.ofx";
  "fi_id" = "1001"
  "ofx_version" = "103"
  "app_id" = "MDNC"
  "fi_org" = "Capital One"
  "app_ver" = "2012"

tried OFX Direct Connect, EBICS, Offline Backend & HBCI. Nothing worked. Any 
Suggestions? 

I also have another paypal account - tried to log in paypal transactions - with 
paypal interface that didn't work either.

If you have info on that as well that would also be helpful.


Thanks in advance.
Matatia Chetrit
==



7 Noahide Torah Laws for All People
1 Being Faithful to G∙d - Don't Worship Idols - Object,Animal,Man
2 Respect of Integrity of Family - Prohibition of Immoral Relations- 
Adultery,Bestiality,Homosexuality& Incest
3 Respect of Human Life - Don't Murder
4 Respect of G∙d- Don't Blaspheme
5 Respect of Property-Don't Steal
6 Law & Order-Establish Courts of Law
7 Respect of Creatures-Don't Eat Limb taken from live animal
http://www.jerusalemlife.com/?p=1473 




___
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] Minor silliness bugs

[NoobAlice]

On 2024-02-13 11:44 AM, David G. Pickett via gnucash-user wrote:

I run the latest gnucash from flatpak on Ubuntu 22.04 LTS Linux.  When I launch 
gnucash from my taskbar of favorites, it sends a notification to my top central 
bar menu that it is ready, when it is only ready to display a splash, and many 
additional seconds must elapse before all the XML is loaded into VM structures. 
 Maybe it should not bother, or wait until the app window is actually open 
(usually asking if I approve my scheduled transaction creation with a list of 
mostly unchanged folders or subaccounts, also silly, as yes, I approve of it 
not changing unrelated things).


I don't know about Ubuntu or Flatpak peculiarities, but if you go to 
Edit > Preferences > sidebar General > section General, you can uncheck 
the splash screen, "tip of the day", and possibly account list setup if 
that is causing annoyance.  I do have account list setup checked, but it 
does not appear when I open GnuCash to my usual books, so that may be a 
Flatpak oddity.  (I'm using Linux, but not an Ubuntu derivative.)


Also, Edit > Preferences > sidebar Scheduled Transactions lets you turn 
off automatically running these when you open your books.  I can't tell 
from your email if that bothers you or not.  I do like "Review created 
transactions" if you want to check that box while you're in there. :)

___
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] Find Question

[David Knoblich via gnucash-user]

I need to know how to find a number (31.82) that is in asplit entry. The find 
function for this (^F) does not work. I press ^F, select ‘number’,‘contains’, 
and ’31.82’. I do this from the main list of accounts or fromwithin the actual 
account. I’ve even tried it from withing the account with thesplit open. The 
results are always a search result tab with an emptytransaction. Does anyone 
know how to do 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.

[GNC] Problem install Finance::Quote

[Gustavo Taouil]

Hi Guys, I tried to install Finance::Quote in my new mac (M3) with Sonoma 
macOs. I Use these lines of command to install:

sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64'cpan -f -i Test2
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64'cpan -f -i 
Finance::Quote
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64'cpan -f -i JSON::Parse

Now, I was receiving theses kind of messages when I tried to update quotes:


* B3:IVVB11.SA Finance::Quote reported failure with error: 501 Protocol scheme 
'https' is not supported (LWP::Protocol::https not installed)


I already force the install of LWP::Protocol::https and I installed the opensll 
with the command: brew install openssl, but it’s not working.

My perl is installed in /usr/bin/perl and my version is 5.30.3

anyone can help me?




___
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] Find Question

[David Reiser via gnucash-user]

If the 31.82 is in the debit or credit columns, you want to be searching 
‘value’ not ’number’. If it’s just text somewhere, search ‘Description, notes, 
and memo’.

--
Dave Reiser
dbrei...@icloud.com



> On Feb 16, 2024, at 12:50 PM, David Knoblich via gnucash-user 
>  wrote:
> 
> 
> I need to know how to find a number (31.82) that is in asplit entry. The find 
> function for this (^F) does not work. I press ^F, select ‘number’,‘contains’, 
> and ’31.82’. I do this from the main list of accounts or fromwithin the 
> actual account. I’ve even tried it from withing the account with thesplit 
> open. The results are always a search result tab with an emptytransaction. 
> Does anyone know how to do 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] Find Question

[Joseph St. Denis via gnucash-user]

Hello all

The easiest way to find the particular number is to be in the correct account 
of the spilt if you are looking for a dining transaction of 31.82. Or any other 
account details not the parent account.


All the best
Joseph St Denis

Get Outlook for Android

From: gnucash-user  on 
behalf of David Knoblich via gnucash-user 
Sent: Friday, February 16, 2024 12:50:06 PM
To: gnucash-user@gnucash.org 
Subject: [GNC] Find Question


I need to know how to find a number (31.82) that is in asplit entry. The find 
function for this (^F) does not work. I press ^F, select ‘number’,‘contains’, 
and ’31.82’. I do this from the main list of accounts or fromwithin the actual 
account. I’ve even tried it from withing the account with thesplit open. The 
results are always a search result tab with an emptytransaction. Does anyone 
know how to do 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.
___
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.