[GNC] Viewing account balances of today

[Thomas]

Hello everybody,

I was wondering whether it is possible to change the account overview of 
GnuCash to the status of the current day.


What I mean is the following:
Usually, when I have some scheduled transactions or some expected 
transactions for the future, they show up in the balance and in the 
account overview immediately, even though they have a date in the future.


What I am looking for is the possibility to switch the account overview 
to include "all bookings up to today" (excluding transactions in the 
future). Is there such a feature or possibility to configure GnuCash 
like that?


E.g.,
(yesterday) Grocery shopping: 10 €
(today) Brunch: 15 €

(tomorrow) Monthly energy consumption deposit: 50 €

I'd like to see the status in the account overview where GnuCash 
(literally) draws the line ;-)



Thanks a lot in advance for any hints and pointers!

Best regards,
Thomas
___
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] Easier way to jump to specific tab/register in main window

[Thomas]

Hello there,

I always have a set of standard tabs/registers open in the main window
(GnuCash v5.4).
As it is quite a number of tabs in the meantime, it becomes rather
tiresome to scroll from one end to another. I am aware that I could
move the tabs to the left or right side instead of top, but usually, I
prefer it at the top.
How do you handle such a case and is there a way to have a drop down
menu on the right instead of horizontal scrolling (like in Firefox if
there's a certain number of tabs, there's an arrow on the right which
provides a dropdown menu of all tabs).

Thanks a lot in advance!

Best,
Thomas
___
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] QIF import fails without error messages

[Thomas via gnucash-user]

Hi Geoff,

thanks a lot for confirming my problem. I thought about a date problem
(which also explains why it worked sometimes) but as the import let's
you select the right format I didn't dig deeper.
Anyhow you are right. Using a unambiguous date it works just fine. Going
back to an older version is not an option for me right now (to much
work) and therefore I'll just wait for the fix.

I created a bug if you'd like to follow it:
https://bugs.gnucash.org/show_bug.cgi?id=799160

Best regards
Thomas

On 09.12.23 02:38, Geoff wrote:

Hi Thomas

I also use QIF files extensively and was surprised when you reported
this error.

Coincidentally, yesterday I upgraded to v5.4.1 and found that I can
reproduce the same error.  By a process of elimination I found that it
is due to the ambiguity in the date format.  Using your example, a
date of "01/12/2023" could be interpreted as 1st of December *or* 12th
of January.  Despite telling GnuCash that the dates are to be
interpreted as "d-m-y" this information seems to be lost and the
process fails.  I also tried "2023/12/01" with "y-m-d" and this failed
too.  Unambiguous dates like "29/11/2023" work fine.

I have now downgraded to v4.8 and your file was imported without any
errors - see attached screenshot.

I recommend that you:
(a) Downgrade to a version 4 release.
(b) Submit a bug report about this problem
https://bugs.gnucash.org/enter_bug.cgi

Regards

Geoff
=
GnuCash v4.8 on Windows 10

On 9/12/2023 7:59 am, Thomas via gnucash-user wrote:

Hello,

i'm using GnuCash for a very long time (thanks a lot for it). In order
to handle some regular (monthly) payments I created a small script to
create very simple QIF files that I can then import into GnuCash. That
was working perfectly for some years now. Anyhow for the last 2 or 3
months (only using it once a month) the import failed without telling me
why (there is just no message in the dialog). It happened for the first
time (I think) two months ago. Then I did it manually and it worked the
following month. Anyhow now (this month) it fails again. There it does
not seem to be a "one time problem".

The QIF file is very simple and I can't see why that should fail:

!Account
NAktiva:Umlaufvermögen:Girokonto (1234567)
^
!Type:Cash
D01/12/2023
T-123
LAktiva:Anlagevermögen:Bausparer (1234567)
^

(the real file contains more payments but this simple also fails)

During the import wizard GnuCash identifies both accounts to exist and
accepts the date format as d-m-y. Anyhow it fails without message.

Any idea on why that happens?

Thanks a lot.

___
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] QIF import fails without error messages

[Thomas via gnucash-user]

Hello,

i'm using GnuCash for a very long time (thanks a lot for it). In order
to handle some regular (monthly) payments I created a small script to
create very simple QIF files that I can then import into GnuCash. That
was working perfectly for some years now. Anyhow for the last 2 or 3
months (only using it once a month) the import failed without telling me
why (there is just no message in the dialog). It happened for the first
time (I think) two months ago. Then I did it manually and it worked the
following month. Anyhow now (this month) it fails again. There it does
not seem to be a "one time problem".

The QIF file is very simple and I can't see why that should fail:

!Account
NAktiva:Umlaufvermögen:Girokonto (1234567)
^
!Type:Cash
D01/12/2023
T-123
LAktiva:Anlagevermögen:Bausparer (1234567)
^

(the real file contains more payments but this simple also fails)

During the import wizard GnuCash identifies both accounts to exist and
accepts the date format as d-m-y. Anyhow it fails without message.

Any idea on why that happens?

Thanks a lot.

___
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] I need basic help

[James Thomas]

It may be because I have a lot of experience and training in accounting,
but it seems to me that using different terms depending on the account just
adds to the confusion. To me, using just "debit" and "credit" is a lot
easier - but one must understand three accounting basics:

1. that every account belongs in one of 5 different groups,
2. that, depending upon which "group" the account is in, it will normally
have either a debit or credit balance,.and
3. that the sum of debits minus credits in each transaction must equal zero
- without exception.

*Grouping*  *"normal balance"*

Assets  debit
Liabilities  credit
Income credit
Expense   debit
Equity   credit (but note that, if the business has been
incurring more expenses than revenue, the Equity balance will be abnormal -
a debit)

A "normal" posting to any account increases its "normal" balance. So an
increase to an asset account (checking, savings, investments, Accounts
Receivable, etc) would be a debit as would an increase to any expense
account.

However, any increase to a liability account's "normal"  balance (credit
card, loan) would be a credit as would any increase to an Income account.

This explains the confusion over whether credit means "increase" or
"decrease". *It means neither* in accounting terms. Whether a credit
increases or decreases an account depends on what type of account it is
(i.e. which "grouping" the account is in).

So, some ordinary entries for those of us just keeping track of home
finances would include:

  *debit
(dr)credit (cr)*

*paid for groceries w/credit (increases both balances):*

Visa card
50
groceries expense   50

*paid credit card from checking acct (decreases both balances)*

checking acct
  25
Visa card  25

*got my paycheck (increases both)*

checking acct  600
Income
 600


*Balances (all normal)*

Checking  575
Visa
 25
Income
600
Expense 50

Total *625*
  *625*

*Businesses "close books" at the end of the year (income and expenses are
set to zero by making "abnormal" entries in the amount of their year-end
balances). *
*Assets and liabilities are not "closed" but retain their balances.*

Income   600
Expense
50
Equity
550


Hope this helps - or at least doesn't add to the confusion :(


Jim Thomas

On Sat, Oct 21, 2023 at 12:39 PM R Losey  wrote:

> On Fri, Oct 20, 2023 at 11:57 AM Michael or Penny Novack <
> stepbystepf...@comcast.net> wrote:
>
> > On 10/20/2023 11:47 AM, Edwin Booth wrote:
> > > Thank you Michael. The ancient history of these terms is really
> > > interesting. I don’t really “get it” yet but I see the idea here. Very
> > > hard to set aside the use of credit and debit in the modern sense and
> > > use them in a very different way. Counter intuitive.
> >
> > Not exactly. The confusion over "modern sense" is something else. Thus
> > when R. Losey says:
> >
> > "It*IS*  hard because the accounting use of debit/credit is different
> from
> > the common or colloquial usage of the words. In everyday usage, people
> tend
> > to use "debit" as a synonym for "decrease" and "credit" to mean
> "increase",
> > and that is NOT the case in accounting, as the tutorials helpfully
> > explain."
> >
> >  No, the confusion is NOT because accounting use is different but
> > confusion over whose books are you looking at. We are sued to seeing
> > these "in reverse" on statements we from from the bank for our bank
> > accounts or credit card accounts because on those it is from THEIR point
> > of view, not ours.
> >
>
> I disagree; I've heard people in non-financial situations use "debit" to
> mean "decrease" and "credit" for "increase"; such as "His recent actions
> have credited his stock of goodwill "  or "he owes me; I have a huge credit
> balance with him".
>
> But this is starting to get away from GnuCash.
>
> _
> Richard Losey
> rlo...@gmail.com
> Micah 6:8
> ___
> gnucash-user mailin

Re: [GNC] Consolidation of family member accounts

[James Thomas]

I’m not sure why you’re maintaining separate books for each family member
but it occurs to me that, rather than keeping them separate and having
trouble combining when you want, you might try keeping all the accounts
together but giving each a different name (perhaps just add each  family
member’s initials before each account name). Then you could produce
statements which included only those accounts pertaining to one entity at a
time.

You could even make each entity account subsidiary to its master account
which (the master accounts) would then be the sum of all combined and could
be displayed exclusively in the combined entity statements.

Without trying it myself I’m not sure how many challenges might arise out
of this but it might be worth giving a shot.

Jim Thomas

On Mon, Aug 14, 2023 at 10:48 AM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

>
>
> > As I have replied to Liz and addressing your valid point, i am
> maintaining three separate books for each one of us, independent to each
> other. And that is why I raised a query how I can combine or consolidate
> three books to create one virtual book which I would call a family book.
> >
> When I suggested a spreadsheet application (instead of paper) to add up
> the components of individual family members to get a family totals
> report I was not meaning to imply that you could not use gnucash for
> that. I make a lot of use of gnucash for "virtual entities". But that is
> mainly when "sort of like a real entity" so you want the usual reports
> "as if it were a real entity".
>
> Thus when our "solar system" in effect "pays" an electric bill on my
> behalf (we are a "net billing" state)  treated as if this "business"
> received income (no money has changed hands) and when SRECs it generated
> were sold, gets credited for money I received (not it) and debited for
> the tax liability I incurred from that. Similarly, while it was (still)
> paying off the initial loan, implied interest was an expense, its share
> of the property insurance premium, etc. WHY do this? To correctly be
> able to determine when this "investment" paid off (as opposed to the
> over simplified examples they show you which assume interest rates are
> zero and no "other" expenses are incurred) . In other words, when the
> initial loan had been paid off in full (out of its net income) THAT the
> correct date of being paid off. Currently building a "repair and
> replacement" fund.
>
> However, not going to advise "how to" (set up books for virtual
> entities). If you need help, you shouldn't be trying this
>
> Michael D Novack
>
>
> ___
> 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.
>
-- 
Sent from Gmail Mobile (my iPhone)
___
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 transfer all my accounts etc. to new computer.

[James Thomas]

On Sat, Aug 12, 2023 at 4:48 AM Shevach Pepper  wrote:

>I’m sure this is really simple but I’m not successful.
>
>I installed gnucash on new computer but I can’t find an option to
>import all my old accounts from old computer. I’m sure this has been
>asked before, but I can’t find any instructions on how to do it.
>
>On my old computer in the AppData>Roaming>GnuCash>books folder I found
>a file with end in gnucash.gcm. Can I just copy that file and put into
>the new computer in the same place and I’ll get back old of the old
>info?
>
>Tried that but it didn’t work.
>
>Can someone help me and tell me what to do?
>
>Thank you very much
>
>
>
>Sent from [1]Mail for Windows
>
> References
>
>1. https://go.microsoft.com/fwlink/?LinkId=550986
> ___
> 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] How to transfer all my accounts etc. to new computer.

[James Thomas]

[image: image.png]




On Sat, Aug 12, 2023 at 4:48 AM Shevach Pepper  wrote:

>I’m sure this is really simple but I’m not successful.
>
>I installed gnucash on new computer but I can’t find an option to
>import all my old accounts from old computer. I’m sure this has been
>asked before, but I can’t find any instructions on how to do it.
>
>On my old computer in the AppData>Roaming>GnuCash>books folder I found
>a file with end in gnucash.gcm. Can I just copy that file and put into
>the new computer in the same place and I’ll get back old of the old
>info?
>
>Tried that but it didn’t work.
>
>Can someone help me and tell me what to do?
>
>Thank you very much
>
>
>
>Sent from [1]Mail for Windows
>
> References
>
>1. https://go.microsoft.com/fwlink/?LinkId=550986
> ___
> 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] Adding Bank Account/Cash on Reports

[Koshy Thomas]

Hello there,

On Invoice & Transaction report, how can I show the Bank Account or CASH to 
which the Customer has paid .
On Transaction report, for each transaction wish to show to which account the 
money has been deposited.

Please help.

Regards,
Koshy Thomas



___
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] exporting from gnucash to Excel

[Thomas Forrester]

Scripts can also make redundant tasks less of a burden through hands-off
automation.  That's what scripts do well, too.  I'm seeing a few posts in
this topic verging on berating the OP for wanting to do something and
asking if there's a way.  Maybe you stop second-guessing the OP's needs and
motives.  If you have no real idea how to do something, or have nothing
constructive to add, maybe just remain silent.

On Fri, Jan 13, 2023 at 4:37 AM Liz Dodd  wrote:

> On Fri, 13 Jan 2023 07:45:20 +0300
> "David T. via gnucash-user"  wrote:
>
> > Indeed.
> >
> > I don't have to comply with this either, but it seems to me that
> > "pressing a button" to export to Excel provides exactly the same
> > automated reliability as CTRL-C/CTRL-V (two buttons, if you will)
> > into Excel. The data in both cases will have the same reliability.
> >
> > ⁣David T. ​
>
> It's come from the same purveyors as many other things which sound good
> but don't work in the real world.
> Data can get changed at any point, and it doesn't have to be as obvious
> as a lightning bolt hitting your house. Automating the proceedings
> doesn't guarantee accuracy, it hides the potentials for error.
>
> When you write your script to do this little task, there are
> opportunities to add to or subtract from the data. That's what scripts
> do well ;)
>
> Liz
> ___
> 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] Register column sizing

[Thomas Forrester]

To be honest, John, it's been a minute since I bothered to think about it.
For the most part, I guess I just leave columns alone.  I don't recall the
last time I've had to resize a column, and maybe that speaks kindly of the
width-memory the columns have at this point.  Or not.  Like I say, I don't
find myself needing to resize columns much.  But neither does that mean
I've never resized a column.  My recollection of those times is that it was
somewhat frustrating and counter intuitive.  As if it seemed to be doing
the sizing backwards or was somehow causing disruption to other column
widths.

I don't feel asking me what I think GnuCash is doing differently than
spreadsheets is going to give you any important information.  Rather, I
think you should be asking yourself, "what is GnuCash doing that is
different from how spreadsheets do it?"  After all, you came to us saying,
"There have been occasional complaints for many years about column width
sizing."  I hypothesize that at the root of these complaints is the
difference between the intuitive and well accepted behavior of spreadsheets
vs the, well, clumsy(?) way GnuCash is doing it.

If GnuCash starts behaving like a spreadsheet in this regard, I would
expect all the grumbling to go away.  Or at the very least you could say
you're standing on the shoulders of giants like Excel, LibreOffice Calc,
etc, in doing it how they do it so as to bring an established standard to
the table.

Thanks.
Tom


On Fri, Jan 6, 2023 at 1:31 PM john  wrote:

> With the exception of the Description field automatically resizing itself
> to fit the register in the window width, I think GnuCash does size columns
> the same way spreadsheets do: You put the pointer on the right-hand divider
> in the header and drag it, and double-click in the header to fit the width
> to the widest entry in that column. What do you think spreadsheets do
> differently?
>
> Regards,
> John Ralls
>
>
> On Jan 6, 2023, at 5:37 AM, Thomas Forrester 
> wrote:
>
> I realize I'm answering a slightly different question, but I've never
> understood why the GnuCash developers have never made column sizing (and
> apparently hiding, too) work just like spreadsheets.  We already invented
> that wheel, and people are *really* accustomed to how it works, hence the
> grumbling when it's discovered by new GnuCash users that it doesn't work
> that way here.  I think the vast majority would agree that the way
> spreadsheet columns work is a very mature, and well understood "technology"
> (for lack of a better word) that has become ubiquitous and intuitive.  Note
> also that I said "spreadsheets" rather than, say, "Excel" because the way
> spreadsheet columns work isn't specific to any one spreadsheet program, and
> once again speaks to how universal handling spreadsheet columns has become.
>
> My guess is that what you're asking is likely just fine, but isn't it just
> another band-aid that really would be better ripped off in favor of
> spreadsheet-like resizing logic?
>
> Tom
> Thomas L. Forrester
> Middleton, WI USA
>
>
> On Thu, Jan 5, 2023 at 9:42 PM john  wrote:
>
>> Users,
>>
>> There have been occasional complaints for many years about column width
>> sizing. See for e.g. https://bugs.gnucash.org/show_bug.cgi?id=563588.
>> Most users seem to eventually get used to it, but I wonder if anybody
>> really likes it.
>>
>> The problem boils down to the auto-sizing behavior of the Description
>> column, which causes that column to grow or shrink when you adjust the
>> window's width, and to make a horizontal scrollbar appear when you widen
>> another column. Occasionally someone will complain about the normally
>> hidden price column because it's possible to catch its handle and widen it
>> when you mean to widen the balance column.
>>
>> It would be really easy to turn off autosizing on the Description field
>> and only a little work to figure out another way to handle the price and
>> ditch that column. Would anyone miss it?
>>
>> Regards,
>> John Ralls
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> 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] Register column sizing

[Thomas Forrester]

I realize I'm answering a slightly different question, but I've never
understood why the GnuCash developers have never made column sizing (and
apparently hiding, too) work just like spreadsheets.  We already invented
that wheel, and people are *really* accustomed to how it works, hence the
grumbling when it's discovered by new GnuCash users that it doesn't work
that way here.  I think the vast majority would agree that the way
spreadsheet columns work is a very mature, and well understood "technology"
(for lack of a better word) that has become ubiquitous and intuitive.  Note
also that I said "spreadsheets" rather than, say, "Excel" because the way
spreadsheet columns work isn't specific to any one spreadsheet program, and
once again speaks to how universal handling spreadsheet columns has become.

My guess is that what you're asking is likely just fine, but isn't it just
another band-aid that really would be better ripped off in favor of
spreadsheet-like resizing logic?

Tom
Thomas L. Forrester
Middleton, WI USA


On Thu, Jan 5, 2023 at 9:42 PM john  wrote:

> Users,
>
> There have been occasional complaints for many years about column width
> sizing. See for e.g. https://bugs.gnucash.org/show_bug.cgi?id=563588.
> Most users seem to eventually get used to it, but I wonder if anybody
> really likes it.
>
> The problem boils down to the auto-sizing behavior of the Description
> column, which causes that column to grow or shrink when you adjust the
> window's width, and to make a horizontal scrollbar appear when you widen
> another column. Occasionally someone will complain about the normally
> hidden price column because it's possible to catch its handle and widen it
> when you mean to widen the balance column.
>
> It would be really easy to turn off autosizing on the Description field
> and only a little work to figure out another way to handle the price and
> ditch that column. Would anyone miss it?
>
> Regards,
> John Ralls
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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] Deleting Transaction from Reconcile Deletes Wrong Transaction

[Thomas Forrester]

I won't actually be experimenting on copies of databases, not because I
don't want to be helpful or contribute to the community, but because I
simply don't have that kind of free  time.  I've noted a problem, and can
agree that I was doing something rather mindless - i.e., right-clicking and
choosing to delete a transaction multiple times because there were three
identical transactions.  That I didn't realize something was going wrong is
somewhat explainable by the fact that, once one (should have been) deleted,
another would have moved up to take its place since they appeared one after
the other, so the row currently being deleted would look just like the
last.  When I deleted three, then I came to realize I still had three
left.  That realization was followed by the realization that the left side
of the screen was looking a little shorter on transactions than before.
And sure enough, stuff had been deleted from the wrong side.  I don't know
why,  My purpose here is to get it on the radar of the developers so they
can review the code to see if there's a problem with the selection logic.
And I'm sorry I won't be able to contribute more than that.

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] Deleting Transaction from Reconcile Deletes Wrong Transaction

[Thomas Forrester]

Thanks for your opinions and experiences on the method of storage
employed.  My perceptions on the pros/coms of either storage method
notwithstanding, it is not the topic of this discussion.  Rather it was
just a side note on the complexities or applicability of restoring to get
around the fact that the program, for some unknown reason, deleted records
that were NOT being explicitly targeted for deletion.

Thanks.

On Fri, Dec 30, 2022 at 2:24 PM John Layman 
wrote:

> My experience is the same as Geert's.  I've seen no performance advantage
> when testing XML vs MySQL with my 12 years of data.  The initial load from
> db is slower than with XML, and flushing and zipping the data at
> termination
> is reasonably fast.   As for immediate commit to the db, I find that
> actually to be a negative, since I do find myself resorting to the 'revert'
> feature from time to time.  Except for the case where someone is actually
> querying the database for custom reporting, etc. I can't think of any
> advantage to using a database with GnuCash.
>
> -Original Message-
> From: gnucash-user 
> On Behalf Of Geert Janssens
> Sent: Friday, December 30, 2022 10:31 AM
> To: David Carlson ; gnucash-user@gnucash.org
> Cc: GnuCash List ; Adrien Monteleone
> 
> Subject: Re: [GNC] Deleting Transaction from Reconcile Deletes Wrong
> Transaction
>
> Op vrijdag 30 december 2022 15:47:35 CET schreef Thomas Forrester:
> (snip)
> > I use database storage over the XML storage method because it does
> > afford me opportunities that the XML plain text file does not.  I now
> > have data going back seven years in GnuCash and I think that's too
> > much to push on a text file.  At some point the scales tip in favor of
> > a full-fledged database over text file read/write operations.
>
> I haven't followed the rest of this thread, but this paragraph caught my
> eye...
>
> The way gnucash works the storage method hardly has any impact on
> performance. In all cases the whole data set is loaded completely into
> memory when the data set is opened (be it an xml file or a database
> backend). And all work is performed purely in memory.
>
> The major difference is that with a database backend, any change you make
> is
> immediately written to the db right after the model in memory has been
> altered. With the xml backend, changes are written to the xml file only on
> explicit save, or at the autosave interval (if set).
>
> So the load and save experiences may be slightly different (last time I was
> involved in this the initial db load was slower than the xml load, but
> saving to xml takes more time as it has to write everything at once, yet
> that is not done as frequently as saving each atomic change to db
> directly...)
>
> But for both the db or xml storage, after the initial read, the data is
> never read again from the storage and gnucash will only work with what's in
> memory.
>
> Regards,
>
> Geert
> ___
> 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] Deleting Transaction from Reconcile Deletes Wrong Transaction

[Thomas Forrester]

Ah.  I reported the version [GnuCash 4.11 Build ID: 4.11+(2022-06-25) using
a MariaDB backend], but totally forgot to mention I'm running on Windows 11.

Hopefully the "wonkiness" seen on the Mac isn't present in Windows?

Or hopefully it's gone on all platforms in 4.13, as you've suggested, which
I installed yesterday to get current.

On Fri, Dec 30, 2022 at 1:38 AM David H  wrote:

> I'm sure he read what you wrote and assumed you were running Gnucash 4.12
> on MacOS Ventura :-)  If not please advise OS and Gnucash version.
>
> If that is indeed the case check out
> https://lists.gnucash.org/pipermail/gnucash-user/2022-November/103465.html
> and https://gitlab.gnome.org/GNOME/gtk/-/issues/5305#note_1592320 for all
> the gory details.  Basically popups passed the mouse clicks etc through to
> the underlying register.  Fixed in 4.13 thanks goodness.
>
> Regards David H.
>
>
>
> On Fri, 30 Dec 2022 at 13:47, Thomas Forrester 
> wrote:
>
>> I guess you didn't read what I wrote.  So, let me say it again (via the
>> magic of copy/paste):
>>
>> "I was right-clicking on a transaction in the right (credit) column.  It
>> was already highlighted, and there was no other transaction highlighted.
>> The right-click context menu appeared alongside the mouse pointer which
>> was
>> positioned on the highlighted credit transaction.  From that menu I
>> selected and confirmed the delete of the highlighted credit transaction.
>> A
>> debit transaction was deleted instead."
>>
>> Reverting to a backup after doing as much work as I had leading up to that
>> reconciliation in that session would have been a multitude of times more
>> painful.  Bad stuff always happens after lots of other stuff has happened
>> -
>> Murphy's Law.  The backup is for truly catastrophic stuff, or maybe if
>> you're just lucky and haven't done anything else yet.
>>
>> This is hardly and interface error.  And checking the 4.13 change log
>> reveals nothing addressing this or any related reconciliation bug.  The
>> known issues list doesn't even identify it.  I don't think it's on
>> anyone's
>> radar.
>>
>> On Thu, Dec 29, 2022 at 4:28 PM Adrien Monteleone <
>> adrien.montele...@lusfiber.net> wrote:
>>
>> > That sounds like a GTK bug. You were raising a context menu on what was
>> > selected, not where the mouse pointer was located. If you had a line in
>> > the left pane selected, that is what got deleted.
>> >
>> > Maybe reverting to a backup file and making it your main file would be
>> > in order for restoring your books to a sane state then starting the
>> > reconciliation over.
>> >
>> > As for the bug, I suppose you can file it, but I wouldn't be surprised
>> > if it is a GTK rather than GnuCash problem.
>> >
>> > But before you do, try GnuCash 4.13 first. I think the GTK version was
>> > just bumped on that release.
>> >
>> > Regards,
>> > Adrien
>> >
>> > On 12/29/22 3:36 PM, Thomas Forrester wrote:
>> > > I was reconciling several credit card statements for the same card and
>> > had
>> > > noticed that a subscription payment I had set up as an automatic entry
>> > was
>> > > showing up even though I had canceled the subscription.  Clearly, I
>> > hadn't
>> > > discontinued the automatic transaction entry in GnuCash.  I ignored
>> > several
>> > > of the subscription transactions while reconciling, but then I
>> thought I
>> > > might as well just delete them in the Reconcile screen since you can
>> > > right-click and delete transactions right there.  With the first ot 3
>> of
>> > > the transactions highlighted, I right-clicked on it and selected
>> > delete.  I
>> > > clicked OK to the confirmation message affirming I was sure I wanted
>> to
>> > > delete the transaction. I rather mindlessly repeated that action a
>> couple
>> > > of times, then realized the transactions weren't deleting.  Much to my
>> > > horror, I realized transactions on the left (debit) column for the
>> > > reconciliation was getting shorter, not the right (credit) column
>> where
>> > the
>> > > highlighted item I was trying to delete was.
>> > >
>> > > Again, I'm going to stress this: I was right-clicking on a
>> transaction in
>> > > the right (credit) column.  It was already highlighted, and there was
>> no
>> > > other transaction highlighted.  Th

Re: [GNC] Deleting Transaction from Reconcile Deletes Wrong Transaction

[Thomas Forrester]

It is possible that a specific set of prerequisite conditions need to exist
for the bug to manifest, but I don't know exactly what I might have been
doing immediately before getting the notion that I should just delete the
transactions right from the Reconciliation dialog.

Normally, I would delete unwanted transactions directly in the register,
too.  But the Reconciliation dialog permits two methods of deleting a
transaction - right-click-delete, or top toolbar delete button.  They gave
it some thought and provided a way to do it, and frankly, it's an
appropriate and convenient place to provide that capability.  Sometimes
it's easier to see a rogue transaction in the Reconciliation dialog over
the more information dense register.

I use database storage over the XML storage method because it does afford
me opportunities that the XML plain text file does not.  I now have data
going back seven years in GnuCash and I think that's too much to push on a
text file.  At some point the scales tip in favor of a
full-fledged database over text file read/write operations.  But you're
right, backing up is not integrated into GnuCash at the push of a button.
I have to perform backups using the HeidiSQL application, and even then
it's not very intuitive.

My bad for not backing up before transitioning from working with
transactions to reconciling statements.  Yup.  That's on me.  But GnuCash
rarely lets me down, so I get complacent sometimes, I guess.

On Fri, Dec 30, 2022 at 12:36 AM David Carlson 
wrote:

> I just performed a trivial test in release 4.8 (Build ID:
> 4.8a+(2021-09-28) in Lubuntu 22.04 by adding a bogus transaction to a
> register then saving the file, opening the reconciliation window, right
> clicking the desired split in the right panel of the reconciliation window,
> and clicking delete.  The correct entire transaction was deleted.  So, from
> my perspective, if the current release does not work the same way, there
> has been a regression since 4.8.
>
> On Thu, Dec 29, 2022 at 11:08 PM David Carlson <
> david.carlson@gmail.com> wrote:
>
>> I haven't needed to do a reconciliation yet since this thread started,
>> but perhaps in the next few days.
>>
>> In the meantime,  I didn't even realize that you could right click split
>> lines in that screen and do things.  If that works successfully, wonderful.
>>
>> I have always used the menu to navigate to the transaction in the
>> register view and perform my edits there.
>>
>> Finally,  I  subscribe to the theory to save a backup just before
>> starting any significant activity such as a reconciliation or import. That
>> is one reason I am not using a database file format and I won't until the
>> application has a way to undo several recent actions.  My cat does
>> occasionally walk across the keyboard.
>>
>> On Thu, Dec 29, 2022, 9:47 PM Thomas Forrester 
>> wrote:
>>
>>> I guess you didn't read what I wrote.  So, let me say it again (via the
>>> magic of copy/paste):
>>>
>>> "I was right-clicking on a transaction in the right (credit) column.  It
>>> was already highlighted, and there was no other transaction highlighted.
>>> The right-click context menu appeared alongside the mouse pointer which
>>> was
>>> positioned on the highlighted credit transaction.  From that menu I
>>> selected and confirmed the delete of the highlighted credit
>>> transaction.  A
>>> debit transaction was deleted instead."
>>>
>>> Reverting to a backup after doing as much work as I had leading up to
>>> that
>>> reconciliation in that session would have been a multitude of times more
>>> painful.  Bad stuff always happens after lots of other stuff has
>>> happened -
>>> Murphy's Law.  The backup is for truly catastrophic stuff, or maybe if
>>> you're just lucky and haven't done anything else yet.
>>>
>>> This is hardly and interface error.  And checking the 4.13 change log
>>> reveals nothing addressing this or any related reconciliation bug.  The
>>> known issues list doesn't even identify it.  I don't think it's on
>>> anyone's
>>> radar.
>>>
>>> On Thu, Dec 29, 2022 at 4:28 PM Adrien Monteleone <
>>> adrien.montele...@lusfiber.net> wrote:
>>>
>>> > That sounds like a GTK bug. You were raising a context menu on what was
>>> > selected, not where the mouse pointer was located. If you had a line in
>>> > the left pane selected, that is what got deleted.
>>> >
>>> > Maybe reverting to a backup file and making it your main file would be
>>> > in order for restoring your books

Re: [GNC] Deleting Transaction from Reconcile Deletes Wrong Transaction

[Thomas Forrester]

I guess you didn't read what I wrote.  So, let me say it again (via the
magic of copy/paste):

"I was right-clicking on a transaction in the right (credit) column.  It
was already highlighted, and there was no other transaction highlighted.
The right-click context menu appeared alongside the mouse pointer which was
positioned on the highlighted credit transaction.  From that menu I
selected and confirmed the delete of the highlighted credit transaction.  A
debit transaction was deleted instead."

Reverting to a backup after doing as much work as I had leading up to that
reconciliation in that session would have been a multitude of times more
painful.  Bad stuff always happens after lots of other stuff has happened -
Murphy's Law.  The backup is for truly catastrophic stuff, or maybe if
you're just lucky and haven't done anything else yet.

This is hardly and interface error.  And checking the 4.13 change log
reveals nothing addressing this or any related reconciliation bug.  The
known issues list doesn't even identify it.  I don't think it's on anyone's
radar.

On Thu, Dec 29, 2022 at 4:28 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> That sounds like a GTK bug. You were raising a context menu on what was
> selected, not where the mouse pointer was located. If you had a line in
> the left pane selected, that is what got deleted.
>
> Maybe reverting to a backup file and making it your main file would be
> in order for restoring your books to a sane state then starting the
> reconciliation over.
>
> As for the bug, I suppose you can file it, but I wouldn't be surprised
> if it is a GTK rather than GnuCash problem.
>
> But before you do, try GnuCash 4.13 first. I think the GTK version was
> just bumped on that release.
>
> Regards,
> Adrien
>
> On 12/29/22 3:36 PM, Thomas Forrester wrote:
> > I was reconciling several credit card statements for the same card and
> had
> > noticed that a subscription payment I had set up as an automatic entry
> was
> > showing up even though I had canceled the subscription.  Clearly, I
> hadn't
> > discontinued the automatic transaction entry in GnuCash.  I ignored
> several
> > of the subscription transactions while reconciling, but then I thought I
> > might as well just delete them in the Reconcile screen since you can
> > right-click and delete transactions right there.  With the first ot 3 of
> > the transactions highlighted, I right-clicked on it and selected
> delete.  I
> > clicked OK to the confirmation message affirming I was sure I wanted to
> > delete the transaction. I rather mindlessly repeated that action a couple
> > of times, then realized the transactions weren't deleting.  Much to my
> > horror, I realized transactions on the left (debit) column for the
> > reconciliation was getting shorter, not the right (credit) column where
> the
> > highlighted item I was trying to delete was.
> >
> > Again, I'm going to stress this: I was right-clicking on a transaction in
> > the right (credit) column.  It was already highlighted, and there was no
> > other transaction highlighted.  The right-click context menu appeared
> > alongside the mouse pointer which was positioned on the highlighted
> credit
> > transaction.  From that menu I selected and confirmed the delete of the
> > highlighted credit transaction.  A debit transaction was deleted instead.
> >
> > Obviously, this is not correct behavior.
> >
> > This is GnuCash 4.11 Build ID: 4.11+(2022-06-25) using a MariaDB backend.
>
> ___
> 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] Deleting Transaction from Reconcile Deletes Wrong Transaction

[Thomas Forrester]

I was reconciling several credit card statements for the same card and had
noticed that a subscription payment I had set up as an automatic entry was
showing up even though I had canceled the subscription.  Clearly, I hadn't
discontinued the automatic transaction entry in GnuCash.  I ignored several
of the subscription transactions while reconciling, but then I thought I
might as well just delete them in the Reconcile screen since you can
right-click and delete transactions right there.  With the first ot 3 of
the transactions highlighted, I right-clicked on it and selected delete.  I
clicked OK to the confirmation message affirming I was sure I wanted to
delete the transaction. I rather mindlessly repeated that action a couple
of times, then realized the transactions weren't deleting.  Much to my
horror, I realized transactions on the left (debit) column for the
reconciliation was getting shorter, not the right (credit) column where the
highlighted item I was trying to delete was.

Again, I'm going to stress this: I was right-clicking on a transaction in
the right (credit) column.  It was already highlighted, and there was no
other transaction highlighted.  The right-click context menu appeared
alongside the mouse pointer which was positioned on the highlighted credit
transaction.  From that menu I selected and confirmed the delete of the
highlighted credit transaction.  A debit transaction was deleted instead.

Obviously, this is not correct behavior.

This is GnuCash 4.11 Build ID: 4.11+(2022-06-25) using a MariaDB backend.

Thank you,
Tom
Thomas L. Forrester
Middleton, WI USA
___
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] Moving Securities from one Security Account to another

[Thomas]

Dear list,

I have to different accounts for one security (regular and saving plan 
account) and recently canceled said saving plan and instructed my bank 
to merge the shares in the saving plan account into the regular account, 
which they did.
Unfortunately, I am somewhat clueless on how I can book such a 
transaction as there seem only to be the buy/sell options in security 
accounts.
Could you please give me a hint on how I can book such a transaction 
properly? Moving shares from one account to another without any fees or 
other expenses.


Thanks a lot in advance for your help!

I use GnuCash 4.12 (Version-ID: 4.12+(2022-09-24)) on ArchLinux

Best regards,
Thomas
___
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] The server ... encountered bad or corrupt data

[Thomas Forrester]

I recently transferred my GnuCash data from another computer to my new
one.  In the process, I switched from a MySQL instance in a WAMP
installation on the old computer to a stand-alone MariaDB install on the
new computer.  On the old computer, I saved the data in xml format, then
opened that file on the new computer, finally saving in sql format.  I
noticed that my dark theme and saved reports didn't follow during the move,
but another helpful person here pointed me to the correct documentation
which corrected both of those issues.  Neither seem related to the
accounting data itself.

So, all was well and I had logged in and out several times making sure the
password was recorded correctly in a keyboard macro for easier access.

I have not done any data entry since the move.  The old computer and the
original transfer file is still available.

Nevertheless, the impression I was given was that, going forward, MariaDB
was the preferred sql back end because "we switched the connectors in the
Gnucash-built bundles and in flatpak to MariaDB's because MySQL
discontinued their C ones and the C++ one won't work with libdbi".

Today I try to login to actually do work in GnuCash for the first time on
the new computer and I get the following message:

*The server at URL mysql://root@localhost/gnucash experienced an error or
encountered bad or corrupt data.*

I have verified the password is correct, restarted the PC, and looked at
the data from HeidiSQL and can see no issue with anything.  This freaks me
out as NEVER did this EVER happen with MySQL on the old computer.

Is there a resolution to this?  Must I start the migration all over again?
How do I regain confidence in the SQL back end when this happens so quickly
after changing db engines?

Thanks.

Tom
Middleton, WI  USA
___
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] MariaDB?

[Thomas Forrester]

Yes, Adrian, I probably could have just gone in search of the folder
somewhere deep within the WAMP stack's folder tree and copied that over.
Not really sure where MariaDB stores its data, though.  And to be honest
here, I'm just being lazy.  As a career-long IT guy, I certainly can figure
this stuff out.  It just seemed less of a hassle to do a save to xml on the
desktop, then open that from remote, and save again as MySQL on the new
computer.  Doesn't seemed to have lost anything in the translation.

I have all my reports and theme back after following the suggestion to get
it from the AppData folder rather than the User/.gnucash folder.  All is
good.  (until I find otherwise, that is, lol)

On Fri, Jul 29, 2022 at 12:46 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> I thought MariaDB was supposed to be a 'drop-in' replacement for MySQL.
>
> Was it really necessary to use XML in the migration?
>
> Frank has already pointed you to the config wiki page, but for the
> theme, check the FAQ on the wiki. There's an entry in the 'Customizing'
> section that will lead you to how to edit or specify the theme.
>
> Regards,
> Adrien
>
> On 7/28/22 10:36 AM, Thomas Forrester wrote:
> > I installed MariaDB and GnuCash on the new computer, then on the old
> > computer, I saved my financial data from MySQL to an XML file.
>
> > And second is that I've lost my dark mode theme and will
> > have to dig around to try to remember how I got that to work in the first
> > place.
>
>
> ___
> 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] MariaDB? .gnucash folder

[Thomas Forrester]

Ooooh!  There they all are, and my dark theme, too!  Thank you for the
link.  Very helpful when you're looking at the correct documentation, lol.

Regards,
Tom


On Thu, Jul 28, 2022 at 6:10 PM Frank H. Ellenberger <
frank.h.ellenber...@gmail.com> wrote:

> Hello Thomas,
>
> Am 28.07.22 um 17:36 schrieb Thomas Forrester:
> > First is
> > that the saved report configurations did not come across even though the
> > .gnucash folder was copied over per the docs to the same location on the
> > other computer.
>
> See https://wiki.gnucash.org/wiki/Configuration_Locations#DOT_GNUCASH_DIR
>
> Regards
> Frank
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MariaDB?

[Thomas Forrester]

Just finally reporting back on this change in my environment (new install
on Windows 11 from an older Windows 10 computer running MySQL).  Perhaps it
will help others making similar changes to what I've just done.

I'm moving on to a new computer and just didn't want to install the entire
WAMP stack just to get MySQL.  As someone who has also done a fair amount
of web development, WAMPServer has been the convenient way to get MySQL
and the rest of the development stack in place.  That's not as relevant to
me anymore, so I'm moving on without the stack.  I had also heard MariaDB
might be a better choice, especially since I only need the SQL part of the
stack.

I installed MariaDB and GnuCash on the new computer, then on the old
computer, I saved my financial data from MySQL to an XML file.  I copied
that .gnucash file to the new computer.  I also followed the guidance in
the documentation (2.6. Migrating GnuCash data) to export/import
preferences data from the registry, and copied the username/.gnucash folder
to retain saved reports.  All that complete, I opened the new installation
of GnuCash.  It opened just fine, and I immediately saved it to MySQL which
brought up the MariaDB login requesting the server name, database name,
username, and password.  It saved the data without complaint.  Closing and
reopening GnuCash then gave me the SQL login prompt which worked fine and
all is well with the data.  Only two issues with the migration.  First is
that the saved report configurations did not come across even though the
.gnucash folder was copied over per the docs to the same location on the
other computer.  And second is that I've lost my dark mode theme and will
have to dig around to try to remember how I got that to work in the first
place.  Both are relatively minor issues.

Thanks to the dev team for making the process relatively easy to comprehend
and execute.  This is not the kind of data you want to have go south on
you, and to be able to fluidly move between MySQL and XML made the transfer
quite painless.

Tom
Middleton, WI  USA


On Fri, Jul 15, 2022 at 9:47 PM john  wrote:

> None known; in fact we switched the connectors in the Gnucash-built
> bundles and in flatpak to MariaDB's because MySQL discontinued their C one
> and the C++ one won't work with libdbi.
>
> Regards,
> John Ralls
>
> > On Jul 15, 2022, at 7:40 PM, Thomas Forrester 
> wrote:
> >
> > Are there issues with using MariaDB in place of MySQL?
> >
> > 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
> > 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] MariaDB?

[Thomas Forrester]

Are there issues with using MariaDB in place of MySQL?

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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] (no subject)

[Thomas Boerner]

Mario,

under Linux Gnucash stores its settings using dconf. You can view them with the 
dconf-editor). Inside dconf you will find your gnucash settings, including the 
file history, under org/gnucash/GnuCash (Older versions of GNC used 
org.gnucash).
In the filesystem it's in ~/.config/dconf/user, so this is the file you are 
looking for. Since nearly all applications store their user related settings 
under ~/.config/, it's worth a thought to backup this folder entirely 
(including "hidden" files with names starting with a period).
But I agree Steve that it's an even better idea to backup your whole home 
directory on a regular base.

Thomas

Am Dienstag, 22. Februar 2022, 18:49:42 CET schrieb Mario Nigrovic:
> Many years ago, I had used gnucash, and was pretty happy with it. I was
> very careful to make regular backups of my data, and so, when my disk
> inevitably crashed, I was not too worried. However, I was mortified to
> discover that, although all my transaction data had been saved, all my
> custom reports were lost, as they had been stored separately in a secret
> undisclosed location, I later discovered to be elsewhere in my home
> directory.
> 
> Recently, I have decided to try again to use gnucash, but I would like very
> much to ensure ALL my data is backed up. So I hit upon the idea of running
> the tool under a custom value of $HOME, but I was then shocked to discover
> that even with this method, gnucash was able to remember previous locations
> of my database file, which suggests that the tool is also using some kind
> of other mechanism to save historical data, and that makes me very nervous
> about actually being able to do proper backups of everything related to the
> tool.
> Doing some sleuthing using strace, I was able to find the previous database
> location delivered through some socket connection, and that really scares
> me, since it is now possible critical data is stored via some other Linux
> service and I will have no way to trace out where this may be to avoid
> future nasty surprises.
> I have not seen any documentation about backup strategies other than the
> aromatic saving of previous data files, yet I do see that there was data
> being stored at least in ~/.local, so I'm hoping someone on this list may
> be able to point me to some more thorough discussion of ALL the places user
> data from gnucash may be stored.
> Thanks for your help!
> 
> -- Mario
> 
> -- Mario
> ___
> 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] Postgresql is not available as an option on "Save As"

[Thomas Boerner]

You are probably missing the libdbi driver for postgresql. Unfortunately I 
can't tell which Ubuntu package provides this library. 

On OpenSuse the package is called libdbi-drivers-dbd-pgsql, and the library is  
libdbdpgsql.so. The sqlite3 driver has similar names, so you might conclude the 
actual package to search for from there.

Good luck
Thomas


Am Montag, 21. Februar 2022, 10:45:25 CET schrieb Dimitri Balios:
> I am seeking guidance on using postgresql as a data store for gnucash. When
> I attempt to select postgresql  under" Save As" , it does not appear as an
> option. I have installed gnucash from binaries on Ubuntu 21.10, and the
> only option there is "xml" . On a separate Ubuntu 21.10 machine I built
> gnucash from source, and the only options there are xml and sqlite3.
> 
> Is there a separate setting somewhere to enable postgresql or am I mising
> something else?
> ___
> 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] CSV Price Import: Saving Colum Assignments

[Thomas]

I just created a bug report in Bugzilla for the said issue:
https://bugs.gnucash.org/show_bug.cgi?id=798437

On 1/27/22 09:49, Geert Janssens wrote:

Op woensdag 26 januari 2022 22:02:00 CET schreef David Carlson:

Back in prehistoric times we called that amnesia.  Today it might be called
Alzheimer’s or software bug.



LOL

I'd bet on a software bug in this case.

I vaguely remember having fixed a similar issue in the CSV transaction importer 
a while back.
The Price importer has duplicated a lot of the transaction importer early on, 
so that issue
may have been copied back then and not fixed since. Please do file this as a 
bug report.

Regards,

Geert


On Wed, Jan 26, 2022 at 2:51 PM Thomas 

wrote:

No, the CSV transaction importer seems to load all column assignments.

On 1/25/22 23:32, David Carlson wrote:

Is the CSV transaction importer equally forgetful in that release?

On Tue, Jan 25, 2022 at 4:18 PM Stephen M. Butler <

stephen.m.butle...@gmail.com> wrote:

I used to use the csv file import in version 3.8.  That remembered the
column assignments, date format, and the main account (a liability
account).

Sounds like this is a bug.

--Steve

On 1/25/22 13:40, Thomas wrote:

Dear list,

I have a fixed format of CSV-files to import prices for securities and
I saved the respective preset in the CSV import wizard.
Unfortunately, only the assignment for the date is "remembered", while
the other column assignments (e.g., namespace, symbol, value) are
always set to none when I load the said preset.

Is this normal behavior and/or is there a way to also save the other
assignments?

GnuCash
Version: 4.9
Version-ID: 4.9+(2021-12-18)
on ArchLinux


Thanks a lot in advance!

Best,
Thomas



___
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] CSV Price Import: Saving Colum Assignments

[Thomas]

No, the CSV transaction importer seems to load all column assignments.

On 1/25/22 23:32, David Carlson wrote:

Is the CSV transaction importer equally forgetful in that release?

On Tue, Jan 25, 2022 at 4:18 PM Stephen M. Butler <
stephen.m.butle...@gmail.com> wrote:


I used to use the csv file import in version 3.8.  That remembered the
column assignments, date format, and the main account (a liability
account).

Sounds like this is a bug.

--Steve


On 1/25/22 13:40, Thomas wrote:

Dear list,

I have a fixed format of CSV-files to import prices for securities and
I saved the respective preset in the CSV import wizard.
Unfortunately, only the assignment for the date is "remembered", while
the other column assignments (e.g., namespace, symbol, value) are
always set to none when I load the said preset.

Is this normal behavior and/or is there a way to also save the other
assignments?

GnuCash
Version: 4.9
Version-ID: 4.9+(2021-12-18)
on ArchLinux


Thanks a lot in advance!

Best,
Thomas



___
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.



--
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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] CSV Price Import: Saving Colum Assignments

[Thomas]

Dear list,

I have a fixed format of CSV-files to import prices for securities and I 
saved the respective preset in the CSV import wizard.
Unfortunately, only the assignment for the date is "remembered", while 
the other column assignments (e.g., namespace, symbol, value) are always 
set to none when I load the said preset.


Is this normal behavior and/or is there a way to also save the other 
assignments?


GnuCash
Version: 4.9
Version-ID: 4.9+(2021-12-18)
on ArchLinux


Thanks a lot in advance!

Best,
Thomas



___
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] Exiting Gnucash Lock file

[Thomas Forrester]

John,

Haha!  Yeah, I'm afraid I've voided that warranty a few times, but only to
correct reconciliation issues that took me moments to correct in Access,
yet seem to cause much hair-pulling and gnashing of teeth with others.

I don't think it would be any performance or storage issue to simply add an
auto-number integer field and set as the primary key, though.  Doesn't
affect your other indices in the least, so I doubt your code even needs to
change.  But IDK, and I'm sure making the GnuCash SQLite3 db compatible
with ODBC connectivity to MS Access is no priority at all. Just wishful
thinking on my part.

On Fri, Jan 21, 2022 at 3:45 PM John Ralls  wrote:

> Having the database read-only in Access sounds like a feature: Writing to
> the GnuCash database using anything except the GnuCash API voids your
> warranty.
>
> Access insisting on a non-text Primary Key an Access bug. All of GnuCash's
> tables have primary keys already, but they're mostly text representations
> of GUIDs because SQLite doesn't support 128-bit unsigned ints nor--unlike
> MySQL and Postgresql--have a UUID field type.
>
> Regards,
> John Ralls
>
> > On Jan 21, 2022, at 1:25 PM, Thomas Forrester 
> wrote:
> >
> > I have tried to switch to SQLite3 this afternoon, and although I cannot
> > answer all your questions, I have observed the following:
> >
> > 1.  Regarding your stability on Windows question, Check Wiki on SQLite.
> > It's pretty ubiquitous at this point and extraordinarily stable on all
> > platforms.  I don't think you're going to have an issue with stability.
> >
> > 2.  There are log files when using SQLite3, but I cannot say if they work
> > as you are asking.
> >
> > 3.  Using the recommended ODBC driver, I was able quite easily to connect
> > the GnuCash database to Microsoft Access, but immediately realized there
> > are insurmountable problems that I have not found with ODBC/Access using
> a
> > MySQL backend for GnuCash.  Specifically, although the tables link into
> > Access with the expected number of rows, All column data shows as
> > #DELETED#.   According to more research, I find the following
> > incompatibility between the way the GnuCash database is designed and what
> > Access aspects (from stackoverflow):
> >
> > [...] Access (Jet) wants a table to have a unique index in order to be
> able
> > to insert/update the table if necessary.
> >
> > If your SQLite table doesn't have a unique index (or primary key), then
> > Access will only allow read access to the table -- you can't edit the
> > table's data in Access, but the data displays fine.
> >
> > To make the table updateable you might revise your SQLite code (or using
> a
> > SQLite tool) to add an index to the table.
> >
> > If your PK/unique index happens to use a TEXT field, that's fine for
> > SQLite. However, when you link to it in Access, Access will show the
> > #DELETED# indications.
> >
> > The chain of events appears to be:
> >
> > Access/Jet notices the unique index, and tries to use it. However, SQLite
> > TEXT fields are variable length and possibly BLOBs. This apparently
> doesn't
> > fulfill Access's requirements for a unique index field, hence the
> #DELETED#
> > indication.
> >
> > To avoid that problem, the index has to be a SQLite field type that
> Access
> > will accept. I don't know the complete list of types that are acceptable,
> > but INTEGER works.
> >
> >
> > 4.  I don't hold any hope of this, but it would be truly outstanding if
> the
> > development team considered this issue (#3 above) and worked to resolve
> > it.  It most certainly is an outlier issue and not something germane to
> > GnuCash itself, in fact it is more akin to assisting someone in shooting
> > themselves in the foot.  But to someone who understands the proper
> > precautions, it sure would be helpful!  (Not sure why ODBC to Access
> using
> > MySQL works fine.  Different db structures for different dbs???)
> >
> >
> >
> >
> >
> >
> >
> > On Fri, Jan 21, 2022 at 2:48 PM Kalpesh Patel 
> wrote:
> >
> >> Few questions in regards to SQLite3 backend recommendation because
> >> currently
> >> XML format for my data is compressed size of 1.82MB so exploring moving
> to
> >> it. Not sure if this is considered small sized XML file or not but .
> >>
> >>
> >>
> >> 1 - SQLite was natively born on UNIX systems with UNIX systems in mind
> so
> >> how stable is it for Windows and how well is it supported from the GNC
> >> perspective?
>

Re: [GNC] Exiting Gnucash Lock file

[Thomas Forrester]

I have tried to switch to SQLite3 this afternoon, and although I cannot
answer all your questions, I have observed the following:

1.  Regarding your stability on Windows question, Check Wiki on SQLite.
It's pretty ubiquitous at this point and extraordinarily stable on all
platforms.  I don't think you're going to have an issue with stability.

2.  There are log files when using SQLite3, but I cannot say if they work
as you are asking.

3.  Using the recommended ODBC driver, I was able quite easily to connect
the GnuCash database to Microsoft Access, but immediately realized there
are insurmountable problems that I have not found with ODBC/Access using a
MySQL backend for GnuCash.  Specifically, although the tables link into
Access with the expected number of rows, All column data shows as
#DELETED#.   According to more research, I find the following
incompatibility between the way the GnuCash database is designed and what
Access aspects (from stackoverflow):

[...] Access (Jet) wants a table to have a unique index in order to be able
to insert/update the table if necessary.

If your SQLite table doesn't have a unique index (or primary key), then
Access will only allow read access to the table -- you can't edit the
table's data in Access, but the data displays fine.

To make the table updateable you might revise your SQLite code (or using a
SQLite tool) to add an index to the table.

If your PK/unique index happens to use a TEXT field, that's fine for
SQLite. However, when you link to it in Access, Access will show the
#DELETED# indications.

The chain of events appears to be:

Access/Jet notices the unique index, and tries to use it. However, SQLite
TEXT fields are variable length and possibly BLOBs. This apparently doesn't
fulfill Access's requirements for a unique index field, hence the #DELETED#
 indication.

To avoid that problem, the index has to be a SQLite field type that Access
will accept. I don't know the complete list of types that are acceptable,
but INTEGER works.


4.  I don't hold any hope of this, but it would be truly outstanding if the
development team considered this issue (#3 above) and worked to resolve
it.  It most certainly is an outlier issue and not something germane to
GnuCash itself, in fact it is more akin to assisting someone in shooting
themselves in the foot.  But to someone who understands the proper
precautions, it sure would be helpful!  (Not sure why ODBC to Access using
MySQL works fine.  Different db structures for different dbs???)







On Fri, Jan 21, 2022 at 2:48 PM Kalpesh Patel  wrote:

> Few questions in regards to SQLite3 backend recommendation because
> currently
> XML format for my data is compressed size of 1.82MB so exploring moving to
> it. Not sure if this is considered small sized XML file or not but .
>
>
>
> 1 - SQLite was natively born on UNIX systems with UNIX systems in mind so
> how stable is it for Windows and how well is it supported from the GNC
> perspective?
>
> 2 -  Does it still create the log file to be able to replay it like XML
> storage creates?
>
> 3 - How can I roll back transactions (more so related to roll back from
> import errors)? With XML I can take the previously created file and make it
> my current file after renaming it.
>
>
>
> Any other differences to keep in mind other than backup regiment?
>
>
>
>
>
>
>
> --
>
>
>
> Message: 8
>
> Date: Fri, 21 Jan 2022 08:43:04 -0800
>
> From: john mailto:jra...@ceridwen.us> >
>
> To: Thomas Forrester mailto:tlforres...@gmail.com>
> >
>
> Cc: Peter mailto:pan...@iinet.net.au> >,
> gnucash-user
>
> mailto:gnucash-user@gnucash.org
> >
> >, john.lay...@laymanandlayman.com <mailto:john.lay...@laymanandlayman.com>
>
>
> Subject: Re: [GNC] Exiting GnuCash Lock file Vol 226, Issue 57
>
> Message-ID:  <mailto:e0d29238-0072-40cd-aea7-8dacecea3...@ceridwen.us> >
>
> Content-Type: text/plain; charset=us-ascii
>
>
>
> Very few users will be able to manage a MySQL database server safely.
> Fortunately GnuCash provides a SQLite3 backend that doesn't require any
> database admin skills. The only caveat is that unlike XML it doesn't write
> a
> fresh file every session so you need to arrange backups on your own; the
> OS's built-in snapshotting facility (rather grandly named Time Machine on
> macOS and simply Windows Backup on Windows) is good for this, just make
> sure
> that your GnuCash data folder is included in its list of things to back up.
>
>
>
> Regards,
>
> John Ralls
>
>
>
>
>
> > On Jan 21, 2022, at 6:45 AM, Thomas Forrester  <mailto:tlforres...@gmail.com> > wrote:
>
> >
>
> > Seems like a lot of work. No doubt you're finding intere

Re: [GNC] Exiting gnucash Lock file Vol 226, Issue 57

[Thomas Forrester]

Good point, John.  I agree that MySQL has a large administrative footprint
and certainly does take an IT mindset.  I hadn't considered, or even
realized that GnuCash could use a SQLite database.  Maybe that's because
the use of SQL as a backend was just a beta thing back when I boarded this
bus?  IDK.  Maybe it was because I already was using MySQL in running a
couple of Internet radio stations.  So thanks for your thoughts on this.
I'm actually now reading up on how to switch to SQLite for my own data as I
do think MySQL is a bit of overkill.  Apparently as simple as just opening
the existing MySQL database, then saving as SQLite, so that's easy enough.
But I'll also need to consider ODBC connectivity to Microsoft Access, too,
because I sometimes "look" at the data and make some adjustments
where needed like if a reconciliation gets messed up because I did
something stupid. One day, I hope to look into some alternative reporting
solutions using MS Access' report features, so I'd need to keep that
connection in place if I'm going to make the switch.

On Fri, Jan 21, 2022 at 10:43 AM john  wrote:

> Very few users will be able to manage a MySQL database server safely.
> Fortunately GnuCash provides a SQLite3 backend that doesn't require any
> database admin skills. The only caveat is that unlike XML it doesn't write
> a fresh file every session so you need to arrange backups on your own; the
> OS's built-in snapshotting facility (rather grandly named Time Machine on
> macOS and simply Windows Backup on Windows) is good for this, just make
> sure that your GnuCash data folder is included in its list of things to
> back up.
>
> Regards,
> John Ralls
>
>
> > On Jan 21, 2022, at 6:45 AM, Thomas Forrester 
> wrote:
> >
> > Seems like a lot of work. No doubt you're finding interesting anomalies,
> > but...
> >
> > Rather than using xml data files, which have always seemed odd to me (a
> la,
> > this thread), if you use a MySQL database instead, all saves are
> automatic
> > and completely bypass the need for all this testing.  You still have to
> > save each transaction, or edits to a transaction (Enter key), but
> otherwise
> > you can freely close the program without any worries about loosing data,
> > and there is no save prompt on the way out.  I've run with a MySQL
> database
> > from the start without any problems at all.  Just a thought, and I
> > recognize some may have reasons not to choose that path, although I'm not
> > sure what they would be.
> >
> > On Thu, Jan 20, 2022, 11:22 PM Peter  wrote:
> >
> >>   John,
> >>   Well yes it did terminate or close.
> >>   gnucash was closed and was then reopened without any reported issue.
> >>   Other than it failed to save the changes and delete the lock file.
> >>   Maybe if you could tell me how to confirm it closed or terminated
> >>   correctly, I will go and test and see what  happens.
> >>   This issue I noted in Test#2 was actually caused by me not following
> my
> >>   own test process.
> >>
> >>   On 21/01/2022 04:48, John Layman wrote:
> >>
> >> The test cases that appear to have failed aren't conclusive, however,
> >> without co
> >> nfirming that GnuCash had actually terminated, and terminated normally.
> >>
> >> -Original Message-
> >> From: gnucash-user [1] >> ieee@gnucash.org> On
> >> Behalf Of Peter
> >> Sent: Thursday, January 20, 2022 9:39 AM
> >> To: [2]gnucash-user@gnucash.org
> >> Subject: Re: [GNC] Exiting gnucash Lock file Vol 226, Issue 57
> >>
> >> Here is the testing methods I used to verify the issue I have noted.
> >>
> >> Selected a known small good gnucash data file.
> >> Storage Location: Local D:  c: drive is Samsung SSD and D: is Seagate
> 2TB
> >> GNUCAS
> >> H Storage type :  XML and compressed Operating system: Windows 10
> GNUCASH
> >> versio
> >> n 4.9 The opening method in ALL test was to use the GNUCASH icon on the
> >> TASKBAR
> >> and then select the recent (test) file If the LOCK file was not deleted
> it
> >> was r
> >> emoved using the windows File Explorer
> >>
> >>
> >>
> >>
> 
> >> -
> >>
> >> Test #1: - change, Save Button and then File->Quit
> >>
> >> Result: This was repeated 5 times each time the same result - Lock file
> >> was dele
> >> ted and the change wa

Re: [GNC] Exiting gnucash Lock file Vol 226, Issue 57

[Thomas Forrester]

Seems like a lot of work. No doubt you're finding interesting anomalies,
but...

Rather than using xml data files, which have always seemed odd to me (a la,
this thread), if you use a MySQL database instead, all saves are automatic
and completely bypass the need for all this testing.  You still have to
save each transaction, or edits to a transaction (Enter key), but otherwise
you can freely close the program without any worries about loosing data,
and there is no save prompt on the way out.  I've run with a MySQL database
from the start without any problems at all.  Just a thought, and I
recognize some may have reasons not to choose that path, although I'm not
sure what they would be.

On Thu, Jan 20, 2022, 11:22 PM Peter  wrote:

>John,
>Well yes it did terminate or close.
>gnucash was closed and was then reopened without any reported issue.
>Other than it failed to save the changes and delete the lock file.
>Maybe if you could tell me how to confirm it closed or terminated
>correctly, I will go and test and see what  happens.
>This issue I noted in Test#2 was actually caused by me not following my
>own test process.
>
>On 21/01/2022 04:48, John Layman wrote:
>
> The test cases that appear to have failed aren't conclusive, however,
> without co
> nfirming that GnuCash had actually terminated, and terminated normally.
>
> -Original Message-
> From: gnucash-user [1] ieee@gnucash.org> On
>  Behalf Of Peter
> Sent: Thursday, January 20, 2022 9:39 AM
> To: [2]gnucash-user@gnucash.org
> Subject: Re: [GNC] Exiting gnucash Lock file Vol 226, Issue 57
>
> Here is the testing methods I used to verify the issue I have noted.
>
> Selected a known small good gnucash data file.
> Storage Location: Local D:  c: drive is Samsung SSD and D: is Seagate 2TB
> GNUCAS
> H Storage type :  XML and compressed Operating system: Windows 10 GNUCASH
> versio
> n 4.9 The opening method in ALL test was to use the GNUCASH icon on the
> TASKBAR
> and then select the recent (test) file If the LOCK file was not deleted it
> was r
> emoved using the windows File Explorer
>
>
>
> 
> -
>
> Test #1: - change, Save Button and then File->Quit
>
> Result: This was repeated 5 times each time the same result - Lock file
> was dele
> ted and the change was Saved.
>
>
> 
> -
>
> Test #2 - change then File>Quit and save at 15 seconds on timer
>
> Result: In test 5 of 5 Lock file was NOT deleted and the change was NOT
> saved in
>  the data file This test was actual performed more than 5 times but I did
> note 5
>  of 5 in one contiguous run. There were a few test that asked to save the
> transa
> ction prior to the question of save the file I was never able to get it to
> repea
> t twice in a row.
>
>
> 
> -
>
> Test #3 - change and exit File->Quit wait for the Save dialogue then let
> it time
>  out
>
> Result: In test 5 of 5 Lock file was deleted and the change was saved in
> the dat
> a file
>
>
> 
> -
>
> Test #4 - change and wait for autosave then File->Quit
>
> Result: In test 5 of 5 Lock file was deleted and the change was saved in
> the dat
> a file
>
>
> 
> -
>
> Test #5 - change and wait for autosave then use X method
>
> Result: In test 5 of 5 Lock file was deleted and the change was saved in
> the dat
> a file
>
>
> 
> -
>
> Test #6 - change then use X method wait for the save dialogue and save at
> 15 sec
> onds on timer
>
> Result: In test 5 of 5 Lock file was NOT deleted and the change was NOT
> saved in
>  the data file
>
>
> 
> -
>
> Conclusion:
>
> There is an issue in exiting with the SAVE button enabled/Highlighted and
> comply
> ing with the dialogue to SAVE the Data file.
> Test#2 and Test#6
>
> Four methods of exiting that do delete the LOCK file and SAVE the latest
> changes
> A:Waiting to exit after an Autosave  then File->Quit
> B:forcing a Save by using the SAVE button then File->Quit
> C:Waiting to exit after an Autosave  then the X method
> D:forcing a Save by using the SAVE button then the X method
>
>   X method works if you do a SAVE using the Save Button or wait till after
> an Au
> tosave then exit via the X method
>
> There is an issue with exiting and relying on gnucash to save the data if
> gnucas
> h produces the dialogue to SAVE the data then File->Quit or the 

[GNC] Error when editing transfer for transaction

[Gomer Thomas]

I am importing QFX files. One of the transaction ended up with 
"imbalance-USD" in the "Transfer" field. When I try to correct it, I get 
the message "This transaction is already being edited in another 
register. Please finish editing it there first."


What does it mean by "another register"? How do I find the other 
register to finish editing it there?


--
Gomer Thomas
9810 132nd St NE
Arlington, WA
98223-8850

___
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] Stock data export to Portfolio Performance

[Thomas]

Thanks for your feedback, rsbrux!

As I didn't find anything fitting to what I am looking for, I think
about creating something myself.
In case I have something, I'd happily report back and would ask for feedback.

Best,
Thomas

On Fri, 10 Dec 2021 at 15:16, rsbrux via gnucash-user
 wrote:
>
> Dear Thomas,
> Thanks for pointing out Portfolio Performance; I have been looking for a way 
> to extract such reporting from GC, but perhaps I would be better off using an 
> external tool like PP.
> If you succeed in finding or creating such a bridge between GC and PP, please 
> post back here, as I am sure others (including myself) would be interested.
>
> Date: Fri, 10 Dec 2021 08:03:56 -0500
> From: D 
> To: Thomas 
> Cc: Christopher Lam , "D. via gnucash-user"
> 
> Subject: Re: [GNC] Stock data export to Portfolio Performance
> Message-ID: <277c927d-12ba-4270-a874-35bf5666c...@yahoo.com>
> Content-Type: text/plain; charset=UTF-8
>
> The answer really is embedded in what format Portfolio Performance needs for 
> its input. I didn't see anything leap out at me in their website about that 
> in my brief scan. Most likely, you'd use a gnucash report to output data to a 
> spreadsheet and import to PP from there.
>
> On Dec 10, 2021, 06:15, at 06:15, Thomas  
> wrote:
> >Hi Christopher,
> >thanks for your reply!
> >With "Portfolio Performance", I was referring to specific (external)
> >tool with that name. I forgot to mention that explicitly.
> >My hope was that I could record all the data and changes in GnuCash and
> >just regularly export the required information about my current stock
> >portfolio to have additional tooling and visualizations in "Portfolio
> >Performance".
> >
> >The website of "Portfolio Performance":
> >https://www.portfolio-performance.info/en/
> >
> >Best,
> >Thomas
> >
> >On Fri, 10 Dec 2021 at 12:09, Christopher Lam
> > wrote:
> >>
> >> Imnsho, portfolio "performance" is a popular term, and I'm not sure
> >it has an official definition.
> >>
> >> There's an IFRS report in the experimental menu to analyse a single
> >stock activity. It aims to calculate a mathematical average cost price
> >of the stock. You can then compare it with the stock latest price to
> >generate a performance metric.
> >>
> >>  (Not an accountant).
> >>
> >> On Fri, 10 Dec 2021, 6:53 pm Thomas,
> > wrote:
> >>>
> >>> Hello everybody,
> >>>
> >>> in order to have a detailed and interactive overview of all my stock
> >>> portfolio, I would like to export the data I have in gnucash (e.g.,
> >>> when I bought how many stocks at what price) and import it into
> >>> Portfolio Performance. It is a rather stock-focused tool, which is
> >why
> >>> I want to stick with gnucash, but would love to have some of the
> >>> visualization and calculation tools of Portfolio Performance.
> >>>
> >>> Does anybody do this in any way already or could give a hint how
> >that
> >>> could be doable?
> >>> If there are other (more compatible) tools of the type of Portfolio
> >>> Performance that are freely available, I'd also be interested in
> >>> hearing about how you do it with these tools.
> >>>
> >>> Thanks a lot in advance!
> >>>
> >>> Best,
> >>> Thomas
> >>> ___
> >>> 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.
>
>
> --
>
> Subject: Digest Footer

Re: [GNC] Stock data export to Portfolio Performance

[Thomas]

Hi Christopher,
thanks for your reply!
With "Portfolio Performance", I was referring to specific (external)
tool with that name. I forgot to mention that explicitly.
My hope was that I could record all the data and changes in GnuCash
and just regularly export the required information about my current
stock portfolio to have additional tooling and visualizations in
"Portfolio Performance".

The website of "Portfolio Performance":
https://www.portfolio-performance.info/en/

Best,
Thomas

On Fri, 10 Dec 2021 at 12:09, Christopher Lam  wrote:
>
> Imnsho, portfolio "performance" is a popular term, and I'm not sure it has an 
> official definition.
>
> There's an IFRS report in the experimental menu to analyse a single stock 
> activity. It aims to calculate a mathematical average cost price of the 
> stock. You can then compare it with the stock latest price to generate a 
> performance metric.
>
>  (Not an accountant).
>
> On Fri, 10 Dec 2021, 6:53 pm Thomas,  wrote:
>>
>> Hello everybody,
>>
>> in order to have a detailed and interactive overview of all my stock
>> portfolio, I would like to export the data I have in gnucash (e.g.,
>> when I bought how many stocks at what price) and import it into
>> Portfolio Performance. It is a rather stock-focused tool, which is why
>> I want to stick with gnucash, but would love to have some of the
>> visualization and calculation tools of Portfolio Performance.
>>
>> Does anybody do this in any way already or could give a hint how that
>> could be doable?
>> If there are other (more compatible) tools of the type of Portfolio
>> Performance that are freely available, I'd also be interested in
>> hearing about how you do it with these tools.
>>
>> Thanks a lot in advance!
>>
>> Best,
>> Thomas
>> ___
>> 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] Stock data export to Portfolio Performance

[Thomas]

Hello everybody,

in order to have a detailed and interactive overview of all my stock
portfolio, I would like to export the data I have in gnucash (e.g.,
when I bought how many stocks at what price) and import it into
Portfolio Performance. It is a rather stock-focused tool, which is why
I want to stick with gnucash, but would love to have some of the
visualization and calculation tools of Portfolio Performance.

Does anybody do this in any way already or could give a hint how that
could be doable?
If there are other (more compatible) tools of the type of Portfolio
Performance that are freely available, I'd also be interested in
hearing about how you do it with these tools.

Thanks a lot in advance!

Best,
Thomas
___
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] Advanced Portfolio Template: Population of data with dividends

[Thomas]

Maybe something along the lines of "Money Invested"?

On Thu, 9 Dec 2021 at 13:26, D  wrote:
>
> Well, it seems that "Money In" is an ambiguous phrase. Perhaps there is a 
> better term that this report could use instead? "Purchase Cost" comes to 
> mind
> On Dec 9, 2021, at 06:39, Thomas  wrote:
>>
>> Thanks for the clarification Richard!
>> it seems like the dividends are added in another column that I did not
>> look into as I always expected to see the dividends in the 'money in'
>> column.
>>
>> Thanks to all of your feedback!
>>
>> On Wed, 8 Dec 2021 at 19:09, Richard Ullger  wrote:
>>>
>>>
>>>  I recall the discussions that took place on the mailing list years ago
>>>  when fixing up the Advanced Portfolio Report.
>>>
>>>  The 'Money In' column reflects only the actual cash You have used to
>>>  purchase the security. Dividend and interest income is included in the
>>>  'Income' column only and not in the 'Money In' column.
>>>
>>>  'Basis' does include the cost of the security whether bought from your
>>>  own funds or from income.
>>>
>>>
>>>  On 08/12/2021 17:36, Thomas wrote:
>>>>
>>>>  Thanks Tom and David for your quick replies!
>>>>
>>>>  I actually found that info some time ago as well, but it seems not to
>>>>  do the trick (for me).
>>>>  In the security's account I have the buy transactions (which are taken
>>>>  into account by the advanced portfolio template) and also the dividend
>>>>  payments in a "neutral" transaction as part of the dividend payment
>>>>  transaction. That means that the dividend transaction has multiple
>>>>  accounts involved (translated, so terms might not be 100% accurate):
>>>>  - "Earnings:Dividends" containing the whole amount I get from the company
>>>>  - "Expenses:Taxes" the amount of taxes that was deducted from the above
>>>>  - "Assets:ClearingAccount" the amount that remained after the deduction 
>>>> of taxes
>>>>  - "Assets:Securities:CompanyXY" just added without any amount
>>>>
>>>>  Is there something I am missing to make it work?
>>>>
>>>>  Best,
>>>>  Thomas
>>>>
>>>>  On Wed, 8 Dec 2021 at 16:45, David Carlson  
>>>> wrote:
>>>>>
>>>>>
>>>>>  IIRC Tom's suggestion is the key to getting dividends correctly assigned 
>>>>> in
>>>>>  the Advanced Portfolio Report.  I cannot find the documentation either, 
>>>>> but
>>>>>  there is a lot of information in the Tutorial chapter on investments <
>>>>>  https://gnucash.org/viewdoc.phtml?rev=4=C=guide>
>>>>>
>>>>>  On Wed, Dec 8, 2021 at 9:36 AM Tom Teixeira 
>>>>>  wrote:
>>>>>
>>>>>>  On 12/8/21 10:09 AM, Thomas wrote:
>>>>>>>
>>>>>>>  Dear User-List,
>>>>>>>
>>>>>>>  I successfully populated the advanced portfolio template with most of
>>>>>>>  the data by selecting of all the accounts of my securities.
>>>>>>>  What I did not manage to get filled is the "money in" column, to also
>>>>>>>  include received dividends in the calculations. I tried to add the
>>>>>>>  accounts with the dividends, but that was not successful.
>>>>>>>  My question essentially is, how to properly fill the "money in" column
>>>>>>>  with dividends.
>>>>>>
>>>>>>
>>>>>>  I don't remember where it is in the manual, but add a split to the
>>>>>>  dividend transaction and include the asset account for the stock. You
>>>>>>  shouldn't have to enter any amount for the stock itself unless you are
>>>>>>  reinvesting some or all of the dividend.
>>>>>>
>>>>>>
>>>>>> 
>>>>>>
>>>>>>  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 

Re: [GNC] Advanced Portfolio Template: Population of data with dividends

[Thomas]

Thanks for the clarification Richard!
it seems like the dividends are added in another column that I did not
look into as I always expected to see the dividends in the 'money in'
column.

Thanks to all of your feedback!

On Wed, 8 Dec 2021 at 19:09, Richard Ullger  wrote:
>
> I recall the discussions that took place on the mailing list years ago
> when fixing up the Advanced Portfolio Report.
>
> The 'Money In' column reflects only the actual cash You have used to
> purchase the security. Dividend and interest income is included in the
> 'Income' column only and not in the 'Money In' column.
>
> 'Basis' does include the cost of the security whether bought from your
> own funds or from income.
>
>
> On 08/12/2021 17:36, Thomas wrote:
> > Thanks Tom and David for your quick replies!
> >
> > I actually found that info some time ago as well, but it seems not to
> > do the trick (for me).
> > In the security's account I have the buy transactions (which are taken
> > into account by the advanced portfolio template) and also the dividend
> > payments in a "neutral" transaction as part of the dividend payment
> > transaction. That means that the dividend transaction has multiple
> > accounts involved (translated, so terms might not be 100% accurate):
> > - "Earnings:Dividends" containing the whole amount I get from the company
> > - "Expenses:Taxes" the amount of taxes that was deducted from the above
> > - "Assets:ClearingAccount" the amount that remained after the deduction of 
> > taxes
> > - "Assets:Securities:CompanyXY" just added without any amount
> >
> > Is there something I am missing to make it work?
> >
> > Best,
> > Thomas
> >
> > On Wed, 8 Dec 2021 at 16:45, David Carlson  
> > wrote:
> >>
> >> IIRC Tom's suggestion is the key to getting dividends correctly assigned in
> >> the Advanced Portfolio Report.  I cannot find the documentation either, but
> >> there is a lot of information in the Tutorial chapter on investments <
> >> https://gnucash.org/viewdoc.phtml?rev=4=C=guide>
> >>
> >> On Wed, Dec 8, 2021 at 9:36 AM Tom Teixeira 
> >> wrote:
> >>
> >>> On 12/8/21 10:09 AM, Thomas wrote:
> >>>> Dear User-List,
> >>>>
> >>>> I successfully populated the advanced portfolio template with most of
> >>>> the data by selecting of all the accounts of my securities.
> >>>> What I did not manage to get filled is the "money in" column, to also
> >>>> include received dividends in the calculations. I tried to add the
> >>>> accounts with the dividends, but that was not successful.
> >>>> My question essentially is, how to properly fill the "money in" column
> >>>> with dividends.
> >>>
> >>> I don't remember where it is in the manual, but add a split to the
> >>> dividend transaction and include the asset account for the stock. You
> >>> shouldn't have to enter any amount for the stock itself unless you are
> >>> reinvesting some or all of the dividend.
> >>>
> >>>
> >>> ___
> >>> 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.
> >>>
> >>
> >>
> >> --
> >> 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
> >> 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/mail

[GNC] Advanced Portfolio Template: Population of data with dividends

[Thomas]

Dear User-List,

I successfully populated the advanced portfolio template with most of
the data by selecting of all the accounts of my securities.
What I did not manage to get filled is the "money in" column, to also
include received dividends in the calculations. I tried to add the
accounts with the dividends, but that was not successful.
My question essentially is, how to properly fill the "money in" column
with dividends.

I also tried to decipher the template definition in GitHub, but
unfortunately, I couldn't identify what I would need to do to achieve
my goal.

Version: 4.8
Version-ID: 4.8a+(2021-09-28)

Thanks a lot in advance!

Best,
Thomas
___
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 Gnucash to access file over flaky network

[Thomas Forrester]

Or, if the situation allows (perhaps because the only reason to do this in
the first pace is to keep that kind of data off the GnuCash machine), use a
NAS device connected directly to the router your GnuCash machine is
connected to.  It may not be as "remote" as you're doing now, but it's not
on the same machine anyway.


On Wed, Nov 24, 2021 at 9:58 AM Chris Green  wrote:

> On Wed, Nov 24, 2021 at 11:24:21AM -0400, Chris Mitchell wrote:
> > Hi all,
> >
> > For reasons that are complicated but not especially interesting, I
> > would like to run Gnucash on one machine, with the data file located on
> > a remote machine — with the added challenge that the network access
> > available to the Gnucash "client" machine is a terrible cellular data
> > connection that sometimes drops without warning.
> >
> > I have daily backups, so I don't need strong guarantees against data
> > loss, but if it's possible, I'd like to set things up so there's
> > reasonable resilience against a network dropout corrupting the remote
> > Gnucash data. I'm not the only user with access to the data, so (given
> > that multi-user is still a long way off), I need file locking to work.
> > Having to manually delete an orphaned lock file after a network dropout
> > is acceptable.
> >
> > I assume that any of the database server backends would include this
> > kind of resilience "out of the box", and I'm not entirely unwilling to
> > try my hand at setting that up, but I am by no means a qualified
> > database administrator. If I can get sufficient resilience by easier
> > means, I'd prefer to stay away from the whole database server thing.
> >
> > What about Sqlite over sshfs?  I realize Sqlite is not designed for
> > access to a database residing on a different machine, but my inexpert
> > impression is that its "atomic commit" implementation should protect
> > against sudden disconnection between the program and the storage medium
> > just like it protects against sudden power loss. (IE the transaction
> > that's in the midst of being written will be lost, but the database
> > should be fine.)
> >
> > Can anyone confirm whether it's reasonable to expect that Gnucash with
> > Sqlite backend over sshfs would have working locking and decent
> > resilience against data corruption in this scenario? Or point out any
> > obvious "gotcha" I'm missing?
> >
> I think a better approach might be to simply copy the database to the
> machine you're working on when you start GnuCash and then copy the
> database back again afterwards.
>
> --
> Chris Green
> ___
> 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.
>


-- 
Tom
Thomas L. Forrester
3211 Patty Lane
Middleton, WI 53562-1652 USA
608-831-0769
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How do you do this - differentiate scheduled transaction versus no scheduled one

[Thomas Forrester]

gt; to be scheduled out. What I was hoping would be that is in the reconcile
> column there would be able to put user defined character, rather than just
> limited to 'y', 'c' and 'n' so that I can actually sort out and see what is
> actually scheduled out and what is not in that account. It seems that this
> is not possible so what would be the best way to differentiate between two
> in the register? I do use scheduling to auto enter certain transactions but
> I still verify with the bank that transaction is actually scheduled and
> want
> to mark that it has been confirmed as such.
>
>
>
> 2 - How should I be handling a transactions where for example my credit
> card
> credits my payment today but bank doesn't show the corresponding withdrawal
> transaction until 3 days later when the funds are actually withdrawn from
> the account. Currently one transaction will accept only one date for both
> side of the transactions but during import and reconcile time if I update +
> reconcile then the timestamp changes to whoever's transactions are
> reconciled last from the two accounts. This is somewhat super annoying
> because it re-arranges things in register so when you try to find an
> erroneous transaction of small amount, you cannot compare against the
> running ledger from the institution's on-line portal against entries in the
> register or the running total in the register entailing lots of manual
> back-and-forth in the register and possibly updating reconciled
> transactions.
>
>
>
> 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
> 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.
>


-- 
Tom
Thomas L. Forrester
3211 Patty Lane
Middleton, WI 53562-1652 USA
608-831-0769
___
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.8: doesn't read or store config

[Thomas Boerner]

Hey Klaus,
glad it's working for you now, too!
I've written that I got it working by modifying XDG_DATA_DIRS. That is true, 
but it cures only the symptom. The root cause was a forgotten schema from an 
old self-compiled version of gnucash below /usr/local/share. After deleting 
that it works with the original XDG_DATA_DIRS.
Perhaps you have had a similar situation that has been solved implicitly by 
removing and re-installing versions?
Best, Thomas

Am Samstag, 9. Oktober 2021, 20:51:26 CEST schrieb Klaus Dahlke:
> Hi Geert,
> I was about to do some tests whether any of the below mentioned tweaks 
> (adapting XDG_DATA_DIRS, using .gconf/org/gnucash/Gnucash) would help, and if 
> not doing an fresh install after removal of gnucash-4.5 or going release by 
> release to gnucash-4.8 - but surprisingly, when I installed the freshly 
> compiled gnucash-4.8 over the existing gnucash 4.5, gnucash-4.8 starts 
> normal, and the configurations is the one as of gnucash-4.5: currency is EUR, 
> register colors are default, date format german ...
> 
> I did exactly the same procedure as last week except I was using gnucash-4.5 
> a bit since switching back to gnucash-4.5 after the non-successful upgrade. 
> 
> In essence: today it worked as it should be, I didn't have to do anything on 
> the location of the configuration files or change XDG_DATA_DIRS (is still at 
> $ echo $XDG_DATA_DIRS -> /usr/local/share:/usr/share)
> 
> I assume that error must have been somehow on my side. 
> 
> Best regards
> Klaus
> 
> 
> On Thu, 07 Oct 2021 14:07:40 +0200
> Geert Janssens  wrote:
> 
> > Hi David,
> > 
> > Thanks for the feedback. It also works fine on my Fedora 34 box. And at 
> > this 
> > point I don't see reason yet to believe the intermediate step via 4.7 is 
> > required. The bug hunt will hopefully give more details.
> > 
> > As for the /org/gnucash/GnuCash path, that's a virtual path, not a 
> > filesystem 
> > one. It's how preferences are organised hierarchically inside GSettings. 
> > Every 
> > application is supposed to generate the three-component "prefix" consisting 
> > of 
> > /org// and under that prefix all preferences for 
> > that particular application can then be structured. You will find this 
> > structure for example by opening dconf-editor on linux systems (provided 
> > gnucash is installed in the default prefix /usr or /usr/local; if not, 
> > you'll 
> > have to manipulate the XDG_DATA_DIRS environment variable to include  > prefix>/share in the search path).
> > 
> > Regards,
> > 
> > Geert
> > 
> > Op donderdag 7 oktober 2021 11:50:46 CEST schreef davidcousen...@gmail.com:
> > > Hi Geert,
> > > 
> > > For your info if it will help diagnose problems on other Linux systems. As
> > > far as I cn tell GunCash 4.8 is reading the preferences when they exist on
> > > Linux Mint 20.2. I up graded from 4.6 via a patched version of 4.7 and 
> > > then
> > > to 4.8 with a further patch suggested by John. Both 4.7 and 4.8 built from
> > > scratch from the downloaded tarball. These still show up under
> > > .local/share/gnucash/ for the books reports etc and .config/gnucash for 
> > > the
> > > gtk style sheets.  The file modifications times and dates indicate changes
> > > (I deliberately changed a few setting exited and then restarted and then
> > > changed them back). I am presuming the /org/gnucash/GnuCash translates to
> > > these locations during installation as I cannot find any such directories
> > > on my computer.
> > > 
> > > David
> > > 
> > > On Thu, 2021-10-07 at 09:29 +0200, Geert Janssens wrote:
> > > > Hi Thomas,
> > > > 
> > > > Klaus hasn't filed a bug yet. If you can, please do.
> > > > 
> > > > Regards,
> > > > 
> > > > Geert
> > > > 
> > > > Op woensdag 6 oktober 2021 16:25:41 CEST schreef boer...@t-online.de:
> > > > > Hi,
> > > > > 
> > > > > I am experiencing the same issue coming from 4.6 and upgrading to 4.8
> > > > > from
> > > > > an OpenSuse Repo. One thing that I have in common with Klaus is that 
> > > > > we
> > > > > both skipped 4.7
> > > > > 
> > > > > Indeed in Dconf I can find a new preference path /org/gnucash/GnuCash
> > > > > along
> > > > > with the old /org/gnucash. However, gnucash 4.8 doesn't seem to take
> > > > > care
> > > > > of this path. Neither 

Re: [GNC] Gnucash 4.8: doesn't read or store config

[Thomas Boerner]

Hey Klaus,

In my case it was enough to set the environment variable XDG_DATA_DIRS to its 
correct value.
See also https://bugs.gnucash.org/show_bug.cgi?id=798330

Cheers, Thomas

Am Freitag, 8. Oktober 2021, 10:14:31 CEST schrieb Geert Janssens:
> Hi Klaus, the delay is no problem. However please remember to keep the 
> conversation on-list...
> 
> Before I redirect you to a bug, a few questions: did you build in an empty 
> build directory and install in an empty install directory ? There may be 
> interference from an older install.
> Or, do you have another version of gnucash installed (perhaps installed via 
> pacman) ?
> 
> Regards,
> 
> Geert
> 
> Op donderdag 7 oktober 2021 22:00:28 CEST schreef Klaus Dahlke:
> >  
> > Hi Geert,
> > sorry for teh delay, was busy the lst two dayss. Anyhw, I read that a bug is
> > filed by now and I am happy to give a helping hand here in root cause
> > analyses. 
> > Best regards
> > Klaus
> >  
> > Gesendet: Dienstag, 05. Oktober 2021 um 12:21 Uhr
> > Von: "Geert Janssens" 
> > An: gnucash-user@gnucash.org
> > Cc: "Klaus Dahlke" 
> > Betreff: Re: [GNC] Gnucash 4.8: doesn't read or store config
> > Hi,
> > 
> > This likely means for some reason the preference migration hasn't run.
> > 
> > I'd like to figure out why if you're willing to work with me on debugging
> > this. If so, please file a bug so we can track our research there.
> > 
> > Regards,
> > 
> > Geert
> > 
> > Op maandag 4 oktober 2021 23:06:13 CEST schreef Klaus Dahlke:
> > > Hi,
> > > I run gnucash 4.5 on ArchLinux and compile gnucash from the sources.
> > > Yesterday I wanted to upgrade/install gnucash 4.8 by:
> > > 
> > > cmake -D CMAKE_INSTALL_PREFIX=/home/klaus -G Ninja ..
> > > ninja
> > > ninja install
> > > 
> > > All went smoothly, but when starting gnucash, the warning/error came up:
> > > no
> > > book found (or similar), i.e., gnucash starts but no accounts, register
> > > etc
> > > are there. I then went to File -> Open' and opened the postgres database.
> > > The data were read, but not displayed as expected: currency was USD, date
> > > format was US, no register color etc. I changed some of Preferences as
> > > setting the register color scheme to gnucash default, currency to Er, date
> > > format etc. But after exiting and restarting gnucash, none of the
> > > preference settings where save. The warning message and teh look and feel
> > > was exactly the same as right after compile.
> > > 
> > > I then switched back to gnucash 4.5 by compiling it from the sources by
> > > the
> > > above method and all works fine again.
> > > 
> > > Did I miss something in the installation procedure or is it worth filing a
> > > bug?
> > > 
> > > Thanks
> > > Klaus
> > > ___
> > > 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] Gnucash 4.8: doesn't read or store config

[Thomas Boerner]

The bug no. is 798330 
https://bugs.gnucash.org/show_bug.cgi?id=798330

Am Donnerstag, 7. Oktober 2021, 11:17:03 CEST schrieb Thomas Boerner:
> Thanks Geert, done.
> Regards, Thomas
> 
> Am Donnerstag, 7. Oktober 2021, 09:29:53 CEST schrieb Geert Janssens:
> > Hi Thomas,
> > 
> > Klaus hasn't filed a bug yet. If you can, please do.
> > 
> > Regards,
> > 
> > Geert
> > 
> > Op woensdag 6 oktober 2021 16:25:41 CEST schreef boer...@t-online.de:
> > > Hi,
> > > 
> > > I am experiencing the same issue coming from 4.6 and upgrading to 4.8 from
> > > an OpenSuse Repo. One thing that I have in common with Klaus is that we
> > > both skipped 4.7
> > > 
> > > Indeed in Dconf I can find a new preference path /org/gnucash/GnuCash 
> > > along
> > > with the old /org/gnucash. However, gnucash 4.8 doesn't seem to take care
> > > of this path. Neither changes in my settings are reflected there nor
> > > changes done directly in Dconf (e.g. set time format to 24h) have any
> > > effect. Moreover the default preference for the date format is ISO
> > > (2021-10-06), while gnucash uses the US format (10/06/2021) persistently.
> > > So it appears to me that gnucash neather reads nor writes from/to the new
> > > preferences path in this situation.
> > > 
> > > @Klaus: Did you file that bug already? So it might be worth to add this
> > > information there.
> > > 
> > > Best
> > > Thomas
> > > 
> > > Tue Oct 5 06:21:11 EDT 2021 Geert Janssens geert.gnucash at kobaltwit.be
> > > 
> > > > Hi,
> > > > 
> > > > This likely means for some reason the preference migration hasn't run.
> > > > 
> > > > I'd like to figure out why if you're willing to work with me on 
> > > > debugging
> > > > this. If so, please file a bug so we can track our research there.
> > > > 
> > > > Regards,
> > > > 
> > > > Geert
> > > > 
> > > > Op maandag 4 oktober 2021 23:06:13 CEST schreef Klaus Dahlke:
> > > > > Hi,
> > > > > I run gnucash 4.5 on ArchLinux and compile gnucash from the sources.
> > > > > Yesterday I wanted to upgrade/install gnucash 4.8 by:
> > > > > 
> > > > > cmake -D CMAKE_INSTALL_PREFIX=/home/klaus -G Ninja ..
> > > > > ninja
> > > > > ninja install
> > > > > 
> > > > > All went smoothly, but when starting gnucash, the warning/error came 
> > > > > up:
> > > > > no
> > > > > book found (or similar), i.e., gnucash starts but no accounts, 
> > > > > register
> > > > > etc
> > > > > are there. I then went to File -> Open' and opened the postgres
> > > > > database.
> > > > > The data were read, but not displayed as expected: currency was USD,
> > > > > date
> > > > > format was US,  no register color etc. I changed some of Preferences 
> > > > > as
> > > > > setting the register color scheme to gnucash default, currency to Er,
> > > > > date
> > > > > format etc. But after exiting and restarting gnucash, none of the
> > > > > preference settings where save. The warning message and teh look and
> > > > > feel
> > > > > was exactly the same as right after compile.
> > > > > 
> > > > > I then switched back to gnucash 4.5 by compiling it from the sources 
> > > > > by
> > > > > the
> > > > > above method and all works fine again.
> > > > > 
> > > > > Did I miss something in the installation procedure or is it worth 
> > > > > filing
> > > > > a
> > > > > bug?
> > > > > 
> > > > > Thanks
> > > > > Klaus
> > > > > ___
> > > > > gnucash-user mailing list
> > > > > gnucash-user at 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] Gnucash 4.8: doesn't read or store config

[Thomas Boerner]

Hi Geert,

can it be a file acces issue? According to the trace file Gnucash cannot access 
the new preferences path properly.

Regards, Thomas

Am Donnerstag, 7. Oktober 2021, 14:07:40 CEST schrieb Geert Janssens:
> Hi David,
> 
> Thanks for the feedback. It also works fine on my Fedora 34 box. And at this 
> point I don't see reason yet to believe the intermediate step via 4.7 is 
> required. The bug hunt will hopefully give more details.
> 
> As for the /org/gnucash/GnuCash path, that's a virtual path, not a filesystem 
> one. It's how preferences are organised hierarchically inside GSettings. 
> Every 
> application is supposed to generate the three-component "prefix" consisting 
> of 
> /org// and under that prefix all preferences for 
> that particular application can then be structured. You will find this 
> structure for example by opening dconf-editor on linux systems (provided 
> gnucash is installed in the default prefix /usr or /usr/local; if not, you'll 
> have to manipulate the XDG_DATA_DIRS environment variable to include  prefix>/share in the search path).
> 
> Regards,
> 
> Geert
> 
> Op donderdag 7 oktober 2021 11:50:46 CEST schreef davidcousen...@gmail.com:
> > Hi Geert,
> > 
> > For your info if it will help diagnose problems on other Linux systems. As
> > far as I cn tell GunCash 4.8 is reading the preferences when they exist on
> > Linux Mint 20.2. I up graded from 4.6 via a patched version of 4.7 and then
> > to 4.8 with a further patch suggested by John. Both 4.7 and 4.8 built from
> > scratch from the downloaded tarball. These still show up under
> > .local/share/gnucash/ for the books reports etc and .config/gnucash for the
> > gtk style sheets.  The file modifications times and dates indicate changes
> > (I deliberately changed a few setting exited and then restarted and then
> > changed them back). I am presuming the /org/gnucash/GnuCash translates to
> > these locations during installation as I cannot find any such directories
> > on my computer.
> > 
> > David
> > 
> > On Thu, 2021-10-07 at 09:29 +0200, Geert Janssens wrote:
> > > Hi Thomas,
> > > 
> > > Klaus hasn't filed a bug yet. If you can, please do.
> > > 
> > > Regards,
> > > 
> > > Geert
> > > 
> > > Op woensdag 6 oktober 2021 16:25:41 CEST schreef boer...@t-online.de:
> > > > Hi,
> > > > 
> > > > I am experiencing the same issue coming from 4.6 and upgrading to 4.8
> > > > from
> > > > an OpenSuse Repo. One thing that I have in common with Klaus is that we
> > > > both skipped 4.7
> > > > 
> > > > Indeed in Dconf I can find a new preference path /org/gnucash/GnuCash
> > > > along
> > > > with the old /org/gnucash. However, gnucash 4.8 doesn't seem to take
> > > > care
> > > > of this path. Neither changes in my settings are reflected there nor
> > > > changes done directly in Dconf (e.g. set time format to 24h) have any
> > > > effect. Moreover the default preference for the date format is ISO
> > > > (2021-10-06), while gnucash uses the US format (10/06/2021)
> > > > persistently.
> > > > So it appears to me that gnucash neather reads nor writes from/to the
> > > > new
> > > > preferences path in this situation.
> > > > 
> > > > @Klaus: Did you file that bug already? So it might be worth to add this
> > > > information there.
> > > > 
> > > > Best
> > > > Thomas
> > > > 
> > > > Tue Oct 5 06:21:11 EDT 2021 Geert Janssens geert.gnucash at kobaltwit.be
> > > > 
> > > > > Hi,
> > > > > 
> > > > > This likely means for some reason the preference migration hasn't run.
> > > > > 
> > > > > I'd like to figure out why if you're willing to work with me on
> > > > > debugging
> > > > > this. If so, please file a bug so we can track our research there.
> > > > > 
> > > > > Regards,
> > > > > 
> > > > > Geert
> > > > > 
> > > > > Op maandag 4 oktober 2021 23:06:13 CEST schreef Klaus Dahlke:
> > > > > > Hi,
> > > > > > I run gnucash 4.5 on ArchLinux and compile gnucash from the sources.
> > > > > > Yesterday I wanted to upgrade/install gnucash 4.8 by:
> > > > > > 
> > > > > > cmake -D CMAKE_INSTALL_PREFIX=/home/klaus -G Ninja ..
> > > > > > ni

Re: [GNC] Gnucash 4.8: doesn't read or store config

[Thomas Boerner]

Thanks Geert, done.
Regards, Thomas

Am Donnerstag, 7. Oktober 2021, 09:29:53 CEST schrieb Geert Janssens:
> Hi Thomas,
> 
> Klaus hasn't filed a bug yet. If you can, please do.
> 
> Regards,
> 
> Geert
> 
> Op woensdag 6 oktober 2021 16:25:41 CEST schreef boer...@t-online.de:
> > Hi,
> > 
> > I am experiencing the same issue coming from 4.6 and upgrading to 4.8 from
> > an OpenSuse Repo. One thing that I have in common with Klaus is that we
> > both skipped 4.7
> > 
> > Indeed in Dconf I can find a new preference path /org/gnucash/GnuCash along
> > with the old /org/gnucash. However, gnucash 4.8 doesn't seem to take care
> > of this path. Neither changes in my settings are reflected there nor
> > changes done directly in Dconf (e.g. set time format to 24h) have any
> > effect. Moreover the default preference for the date format is ISO
> > (2021-10-06), while gnucash uses the US format (10/06/2021) persistently.
> > So it appears to me that gnucash neather reads nor writes from/to the new
> > preferences path in this situation.
> > 
> > @Klaus: Did you file that bug already? So it might be worth to add this
> > information there.
> > 
> > Best
> > Thomas
> > 
> > Tue Oct 5 06:21:11 EDT 2021 Geert Janssens geert.gnucash at kobaltwit.be
> > 
> > > Hi,
> > > 
> > > This likely means for some reason the preference migration hasn't run.
> > > 
> > > I'd like to figure out why if you're willing to work with me on debugging
> > > this. If so, please file a bug so we can track our research there.
> > > 
> > > Regards,
> > > 
> > > Geert
> > > 
> > > Op maandag 4 oktober 2021 23:06:13 CEST schreef Klaus Dahlke:
> > > > Hi,
> > > > I run gnucash 4.5 on ArchLinux and compile gnucash from the sources.
> > > > Yesterday I wanted to upgrade/install gnucash 4.8 by:
> > > > 
> > > > cmake -D CMAKE_INSTALL_PREFIX=/home/klaus -G Ninja ..
> > > > ninja
> > > > ninja install
> > > > 
> > > > All went smoothly, but when starting gnucash, the warning/error came up:
> > > > no
> > > > book found (or similar), i.e., gnucash starts but no accounts, register
> > > > etc
> > > > are there. I then went to File -> Open' and opened the postgres
> > > > database.
> > > > The data were read, but not displayed as expected: currency was USD,
> > > > date
> > > > format was US,  no register color etc. I changed some of Preferences as
> > > > setting the register color scheme to gnucash default, currency to Er,
> > > > date
> > > > format etc. But after exiting and restarting gnucash, none of the
> > > > preference settings where save. The warning message and teh look and
> > > > feel
> > > > was exactly the same as right after compile.
> > > > 
> > > > I then switched back to gnucash 4.5 by compiling it from the sources by
> > > > the
> > > > above method and all works fine again.
> > > > 
> > > > Did I miss something in the installation procedure or is it worth filing
> > > > a
> > > > bug?
> > > > 
> > > > Thanks
> > > > Klaus
> > > > ___
> > > > gnucash-user mailing list
> > > > gnucash-user at 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] Gnucash 4.7 Problem

[Thomas Forrester]

>>>>>> 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, please see
> >>> https://wiki.gnucash.org/wiki/Mailing_Lists
> >>> for more information. -
> >>> Please remember to CC this list on all your replies.
> >>> You can do this by using Reply-To-List or Reply-All.
> >>
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >>
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>
> >> If you are using Nabble or Gmane, please see
> >> https://wiki.gnucash.org/wiki/Mailing_Lists
> >> for more information.
> >> -
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
Tom
Thomas L. Forrester
3211 Patty Lane
Middleton, WI 53562-1652 USA
608-831-0769
___
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] XML vs MySQL Data Storage

[Thomas Forrester]

Very good explanation, Derek.  Seems my choice of MySQL was the
best decision for me, and you've reminded me of some of the more subtle
reasons.  I'll keep things as they are.

Appreciate the help!
- Tom

On Fri, Sep 17, 2021 at 11:39 AM Derek Atkins  wrote:

> Hi,
>
> On Fri, September 17, 2021 12:21 pm, Thomas Forrester wrote:
> > I've been using GnuCash for several years now, and almost right from the
> > start I made the decision to use MySQL as the database engine.  Other
> that
> > forgetting to start MySQL first now and then, it's working fine, and the
> > ability to easily schedule automated backups is nice.
> >
> > I am assuming that the program gains some optimization by using a
> > professional RDBMS as its data engine.  But is it?  I know that XML is
> the
> > native data storage type for GnuCash, but that's really just a text file
> > format without any back end optimization.
> >
> > My question is:  With an ever-increasing data load, am I correct in
> > assuming that performance is going to take in increasingly large hit over
> > MySQL?  Would there be any reason at all to move back to XML over MySQL?
>
> At this point, the only real benefit of using a SQL backend is that
> commits go into storage immediately instead of waiting for you to save
> them.  Beyond that, GnuCash generally doesn't differentiate between them.
> Specifically, GnuCash always loads the whole dataset into RAM when the
> application starts.  It does this regardless of whether it's SQL or XML.
> In this case, you may find that as the dataset size increases, SQL may
> "load" slower, but you will be able to exit faster (because saves are
> incremental).
>
> On the roadmap is a plan to change to full SQL, so GnuCash would be a true
> SQL DB application and (hopefully) not have to read the whole dataset into
> RAM.  For XML it would load the data into an in-RAM SQLite image, but
> MySQL would just be used directly.
>
> Whether to move from SQL back to XML is up to you, of course.
>
> Hope this helps!
>
> > Thanks!
> > --
> > Tom
> > Thomas L. Forrester
> > Middleton, WI  USA
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
>

-- 
Tom
Thomas L. Forrester
3211 Patty Lane
Middleton, WI 53562-1652 USA
608-831-0769
___
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] XML vs MySQL Data Storage

[Thomas Forrester]

I've been using GnuCash for several years now, and almost right from the
start I made the decision to use MySQL as the database engine.  Other that
forgetting to start MySQL first now and then, it's working fine, and the
ability to easily schedule automated backups is nice.

I am assuming that the program gains some optimization by using a
professional RDBMS as its data engine.  But is it?  I know that XML is the
native data storage type for GnuCash, but that's really just a text file
format without any back end optimization.

My question is:  With an ever-increasing data load, am I correct in
assuming that performance is going to take in increasingly large hit over
MySQL?  Would there be any reason at all to move back to XML over MySQL?

Thanks!
-- 
Tom
Thomas L. Forrester
Middleton, WI  USA
___
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] Duplicate Trading Account Created in V4.5

[Thomas Chen]

Thanks for reply.

Everything is working well in GNC V4.5 with duplicate Trading Accounts, it just 
looks weird.

I tried to move accounts under Old Trading Account to New Trading Account, but 
the accounts under new Trading Account are still duplicate.

I usually use Trading Account to understand the unrealized cap gain/loss and 
currency exchange gain/loss, I am wondering if it is providing right 
information if there are two Trading Accounts.

Thanks,


> Mike Alexander  於 2021年4月2日 下午3:24 寫道：
> 
> On 29 Mar 2021, at 22:53, Thomas Chen wrote:
> 
>> Just upgraded GNC to V4.5 from V4.4 yesterday, and it’s running in a Mac.
>> Today when I added a transaction for a stock purchase, a duplicate Trading 
>> Account was created automatically by GNC.
>> Two Trading Accounts exist now.
> 
> This is just a guess, but I'll bet this is related to this change:
> 
>   • Bug 798093 - Changing the symbol/abbreviation of a security after the 
> trading account was created breaks GnuCash.
> Makes it possible for the user to rename trading accounts or securities 
> independent of each other.
> 
> Mike
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-userdata=04%7C01%7C%7Cb5dc31de28f7455ab60e08d8f5a8a4c4%7C84df9e7fe9f640afb435%7C1%7C0%7C637529451955677646%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000sdata=bKxOuChtuwfVqhrgcwfTMGvocMkrm7sUMnVBOyyFsdg%3Dreserved=0
> If you are using Nabble or Gmane, please see 
> https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Listsdata=04%7C01%7C%7Cb5dc31de28f7455ab60e08d8f5a8a4c4%7C84df9e7fe9f640afb435%7C1%7C0%7C637529451955677646%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000sdata=T9h8ThdFAu3Pcgi00yyGgMnnI7LpCosCNPCIcqK0gEA%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.

[GNC] Duplicate Trading Account Created in V4.5

[Thomas Chen]

Hi all,

Just upgraded GNC to V4.5 from V4.4 yesterday, and it’s running in a Mac.
Today when I added a transaction for a stock purchase, a duplicate Trading 
Account was created automatically by GNC.
Two Trading Accounts exist now.

I downgraded it to V4.4 just now, and it’s working well as usual when I added a 
stock purchase.

Anyone has the same issue? Thank you.

BTW, I set the language in Traditional Chinese in GNC.

Thomas Chen
___
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] Rounding & formulas

[Thomas Lenherr]

Thank you all for your responses.

For the record, this is for private bookkeeping purposes (mainly splitting
costs for different things with roommates), and so regulations generally
don't apply as accuracy to a cent is more than enough and I mostly just
want to prevent having to fix imbalances often. Having done this for the
past ~12 years, for anything between 5-10 monthly transactions, I was
hoping to automate this ever so slightly more, as is the trend with
software.

Given the late rounding, somebody mentioned the idea earlier that adding or
subtracting 0.005 could be used to turn the "normal rounding" into either
"rounding up" or "rounding down", I haven't tested that yet, but I suspect
that could work, at least as long as the amount only has be split between
two parties:

my_expense_amount = (total_amount / 2)  # Normal rounding
roommates_expense_amount = (total_amount / 2) - 0.005  # Rounding down

This is a little messier than I hoped and only works well when splitting
two-ways (when you do 3+-ways it gets a little trickier). I was wondering
if any devs here could comment on the options to rather supporting a
function to explicitly trigger the rounding early, that way the above could
e.g. be written as:

roommates_expense_amount = (total_amount / 2)  # Or really any fraction
could work with this
my_expense_account = total_amount - roommates_expense_amount = total_amount
- gnc_round(total_amount / 2)

I'm aware that custom functions can be added to fin.scm, but I didn't dig
deep enough yet to understand how I could explicitly trigger the
rounding-step from there, if at all. Plus it seemed like there's a slim
chance this could be a useful function to include by default since gnucash
doing rounding is an omnipresent operation.

Thanks for all your suggestions!
 Thomas

On Tue, Dec 22, 2020 at 3:56 PM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 12/22/2020 5:17 PM, Liz wrote:
> > I think that we have taken a peek down a rabbit hole and found
> > enormous complexity past the entrance.
> >
> > Liz
>
>
> For us pros it gets far worse than that. In my working days often had to
> compute the "fuzz" value to use in comparisons because of "rounding
> errors" when the two amounts being compared came from different
> calculations. The "fuzz" is the maximum amount of difference that could
> have caused. So you can't test for "equal" but need to test for equal
> +/- fuzz.
>
> Michael D Novack
>
> ___
> 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] Rounding & formulas

[Thomas Lenherr]

Hi,

I've been using gnucash for a few years now, including scheduled
transactions with variables/formulas, but one thing I never figured out is
how to avoid imbalances in them when variables cause "bad" rounding,
requiring me to fix those manually.

Simple example:
I use a scheduled transaction for an expense that varies month to month
(=variable), and I'd like to split it into two (share with another person,
i.e. book 50% against their account). Every now and then that amount is an
odd number of cents, and so just dividing by two for both the amount
against my expense account and their debitor-account results in an
imbalance that I need to fix manually (= I'm fine always being the person
that pays a cent more than the other one).

I tried to be "clever" by writing one of them as "total_amount/2" and the
other one as "total_amount-(total_amount/2)" but that didn't work either.
Is there a way to e.g. force rounding in the formula? E.g. something like
"round(total_amount/2, 0.01)" and "total_amount - round(total_amount/2,
0.01)"? Or is there a different solution I'm not aware of?

If there's no existing option, would it be hard to add support for such a
function or other solution?

Thank you for your help and thank you for this software!
 Thomas
___
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] Open Files Error with Chinese Path Name in V4.0

[Chen Thomas]

Hi John,

Thank you for response.

Open the program, File Explorer, then find the .gnucash file and open it by 
double click. This shows error message as I mentioned below.

It's working well to open the file from GNC File>Open.

Thanks, 
Thomas Chen

-Original Message-
From: John Ralls  
Sent: Tuesday, June 30, 2020 10:52 AM
To: Chen Thomas 
Cc: GnuCash Users 
Subject: Re: [GNC] Open Files Error with Chinese Path Name in V4.0

By File Explorer do you mean Windows Explorer or the File Chooser that you use 
from File>Open? Which ever it is, does the other way work?

Regards,
John Ralls


> On Jun 29, 2020, at 5:25 PM, Chen Thomas  wrote:
> 
> Sorry, 3.11 instead of 3.9 mentioned below.
> 
> -Original Message-
> From: gnucash-user 
>  On Behalf Of 
> Chen Thomas
> Sent: Tuesday, June 30, 2020 8:22 AM
> To: GnuCash Users 
> Subject: [GNC] Open Files Error with Chinese Path Name in V4.0
> 
> Thanks for releasing V4.0.
> Just upgraded it from V3.9 in Windows 10. When I opened GNC files from File 
> Explorer and an error message showed up due to there are Chinese characters 
> in my directories.
> I usually do it well in V3.9.
> 
> Is there any Asian user who uses non-English Windows OS having the same issue?
> 
> Thank you.
> Thomas Chen
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flist
> s.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-userdata=02%7C01%7C%
> 7C8dcbfb9b4b4f49b1ffdd08d81ca0a606%7C84df9e7fe9f640afb435%
> 7C1%7C0%7C637290823584640776sdata=jnh2OlADDAemgdh%2Ff%2Fd4Ip%2F8c
> q4QH2Gp%2FrJ%2F5cc7NX4%3Dreserved=0
> If you are using Nabble or Gmane, please see 
> https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Listsdata=02%7C01%7C%7C8dcbfb9b4b4f49b1ffdd08d81ca0a606%7C84df9e7fe9f640afb435%7C1%7C0%7C637290823584650772sdata=tn9GY61ortGg3W%2F0adLkrLSfchA3qhuLBVSFQhDck4Q%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://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flist
> s.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-userdata=02%7C01%7C%
> 7C8dcbfb9b4b4f49b1ffdd08d81ca0a606%7C84df9e7fe9f640afb435%
> 7C1%7C0%7C637290823584650772sdata=4EJWrshqvEr3VasAuxWfFns%2FgDbnB
> UOrmUIPTqHhlac%3Dreserved=0 If you are using Nabble or Gmane, 
> please see 
> https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Listsdata=02%7C01%7C%7C8dcbfb9b4b4f49b1ffdd08d81ca0a606%7C84df9e7fe9f640afb435%7C1%7C0%7C637290823584650772sdata=tn9GY61ortGg3W%2F0adLkrLSfchA3qhuLBVSFQhDck4Q%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.

Re: [GNC] Open Files Error with Chinese Path Name in V4.0

[Chen Thomas]

Sorry, 3.11 instead of 3.9 mentioned below.

-Original Message-
From: gnucash-user  On 
Behalf Of Chen Thomas
Sent: Tuesday, June 30, 2020 8:22 AM
To: GnuCash Users 
Subject: [GNC] Open Files Error with Chinese Path Name in V4.0

Thanks for releasing V4.0.
Just upgraded it from V3.9 in Windows 10. When I opened GNC files from File 
Explorer and an error message showed up due to there are Chinese characters in 
my directories.
I usually do it well in V3.9.

Is there any Asian user who uses non-English Windows OS having the same issue?

Thank you.
Thomas Chen
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-userdata=02%7C01%7C%7C561805d5b221421142ff08d81c8bd408%7C84df9e7fe9f640afb435%7C1%7C0%7C637290734161366980sdata=29FgH0L2InBKa2oy5dfW%2BFa38V3qGGWdmllwQnE5q90%3Dreserved=0
If you are using Nabble or Gmane, please see 
https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Listsdata=02%7C01%7C%7C561805d5b221421142ff08d81c8bd408%7C84df9e7fe9f640afb435%7C1%7C0%7C637290734161376978sdata=mSxxlZaQ%2BNrVYJB0LTMUTYbcan42jG6DMdzkVhq%2FqM8%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.

[GNC] Open Files Error with Chinese Path Name in V4.0

[Chen Thomas]

Thanks for releasing V4.0.
Just upgraded it from V3.9 in Windows 10. When I opened GNC files from File 
Explorer and an error message showed up due to there are Chinese characters in 
my directories.
I usually do it well in V3.9.

Is there any Asian user who uses non-English Windows OS having the same issue?

Thank you.
Thomas Chen
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Trouble opening ancient files

[Thomas Klausner]

On Tue, Jun 16, 2020 at 10:22:33AM -0400, Derek Atkins wrote:
> This looks like it might be a GnuCash 1.2 or 1.4 binary datafile.  The
> ability to read those old binary files was removed more than a decade ago.
> 
> You'll need to import that using something probably as old (new?) as 1.6
> in order to convert it to XML, but you'll probably need a very old OS in
> order to build it.

Ok, I didn't find such an old binary.

Does anyone still have such a binary running, or a Windows 2.0.x exe somewhere?

> [snip]
> > Any suggestions on how to get versions of these files that could be
> > opened by gnucash 3.10?
> 
> These later XML files are also relatively old.  My guess, you'll
> probably need to start with 1.6 (or maybe even 1.4 for the binary data)
> and then keep on doing File -> Open /  File -> Save As to translate the
> data files from version to version:
> 
> 1.4 -> 1.6 -> 1.8 (was there a 1.8?  I don't recall) -> 2.0 -> 2.2 ->
> 2.4 -> 2.6 -> 3.x
> 
> Expect this to take a while.

Actually, this quite a bit easier than I expected. I downloaded the
Windows 2.2.9 binary and opened the newer file and saved it, then 3.10
could open it successfully. :)

Can you please fix this warning:

"This file/URL appears to be from a newer version of GnuCash. You must upgrade 
your version of GnuCash to work with this data."

that appeared for this file?

Thanks,
 Thomas
___
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] Trouble opening ancient files

[Thomas Klausner]

Hi!

I have been using gnucash for a very long time, and recently I tried
opening some of my first files -- but couldn't. Many old files worked,
but not these two and their related .xac files.

I see two different symptoms.

One file has an timestamp from 2002. I don't recognize the file
format, it's a binary format, but gzip cannot unpack it
The error I get from gnucash (3.10) is:

"No suitable backend was found for /path/to/file."

A hexdump of the file starts with:

  00 00 00 0a 00 00 00 04  00 00 00 ab 00 08 00 00  ||
0010  00 09 41 75 73 67 61 62  65 6e 00 00 00 00 04 31  |..Ausgaben.1|
0020  30 30 00 00 00 00 01 00  00 00 00 01 00 00 00 00  |00..|
0030  04 46 52 46 00 00 00 00  01 00 00 00 00 00 00 00  |.FRF|
0040  00 01 00 00 00 05 00 00  00 d6 00 08 00 00 00 06  ||
0050  45 73 73 65 6e 00 00 00  00 04 31 31 30 00 00 00  |Essen.110...|

where I'm quite sure that "Ausgaben" is an account name and FRF is a
unit of currency, so probably Account number 100 in the Unit of FRF.


The second file has a timestamp from 2005. It is plaintext XML. The
error from gnucash is:

"This file/URL appears to be from a newer version of GnuCash. You must
upgrade your version of GnuCash to work with this data."

The file starts with:

--- begin quote ---


1

61535f2d2589fccc34164e57b1255f25
1
38
1023

  NASDAQ
  Fond
  Fond
  10

--- end quote ---

Then follows a gnc:pricedb and some accounts like

--- begin quote ---

  Ausgaben
  be0508dcdbc39e35f677dd6f334d36e5
  EXPENSE
  
ISO4217
ATS
  
  100
  100
  Ausgaben

--- end quote ---

Any suggestions on how to get versions of these files that could be
opened by gnucash 3.10?

Thank you,
 Thomas
___
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

[Thomas Salt]

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.

[GNC] Budget Report 3.10

[Thomas Salt]

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://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] ANNOUNCE: GnuCash 3.10 Released

[Thomas Klausner]

Hi!

I see the following build problem when building gnucash-3.10 (in a
clean environment where 3.9 builds):

gmake[2]: *** No rule to make target 
'bindings/python/tests/swig-app-utils-python', needed by 
'bindings/python/tests/CMakeFiles/test-python-bindings'.  Stop.
gmake[1]: *** [CMakeFiles/Makefile2:11293: 
bindings/python/tests/CMakeFiles/test-python-bindings.dir/all] Error 2

swig-2.0.12 is installed in case it matters.

Any suggestions?

Thanks,
 Thomas

(not subscribed, please cc)
___
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] Old Line Bank

[Thomas Moffett]

Thanks David. I was hoping to make the first option work but apparently it
will not. I will keep working on the second option.

Tom

sent from my Note 5

On Thu, Feb 28, 2019, 6:30 PM David Carlson 
wrote:

> Tom,
>
> There are two types of approach for you to consider and either will not
> require Quicken once you have it working.
>
> 1.  GnuCash does have a feature similar to the Quicken One Step Update
> through the Online Actions menu, but it is tricky to set up and you need to
> set up credentials which are easiest to obtain by reading the Logs from
> previous Quicken activity.   Some of us make this work and others give up
> and switch  to:
>
> 2.  Your bank probably allows you to download transaction histories in
> several different formats from your Internet online banking page, possibly
> including CSV, QIF, and OFX.  Sometimes they use different names.  Of the
> three, the OFX gives the best experience when importing into GnuCash.  The
> bank may call the OFX format the Quicken format.  With this method you
> download the data file, save it somewhere in a temporary folder, then
> import it into GnuCash.
>
> Since I have not made number 1 work for me, I cannot help you try that.
>
> David Carlson
>
> On Thu, Feb 28, 2019 at 5:05 PM Kenneth Schneider <
> kschnei...@bout-tyme.net> wrote:
>
>> Download you transactions from the bank in CSV format for import directly
>> to GNUcash. I’ve found this works very well. You will need to go through
>> the process of bayeshen (?) matching but with time it works. There is going
>> to be a learning curve but it’s not that steep.
>>
>> Ken Schneider
>>
>> > On Feb 28, 2019, at 5:37 PM, Thomas Moffett 
>> wrote:
>> >
>> > I'm not sure I follow you. The point of switching to gnucash is so that
>> I
>> > no longer need to download into Quicken because they're cutting off my
>> > online access unless I upgrade.
>> >
>> > It sounds like you're suggesting that I download into Quicken and then
>> > import from Quicken into gnucash. Or am I completely misunderstanding
>> your
>> > suggestion?
>> >
>> > Tom
>> >
>> > sent from my Note 5
>> >
>> >> On Thu, Feb 28, 2019, 5:20 PM  wrote:
>> >>
>> >> I would use the the import function of gnu cash after downloading the
>> >> quicken information from your bank website using your username and
>> >> password. I use this method for all my online banking services that
>> are not
>> >> gnucash friendly.
>> >>
>> >> Joseph St Denis
>> >>
>> >> Get Outlook for Android <https://aka.ms/ghei36>
>> >>
>> >>
>> >>
>> >>
>> >> On Thu, Feb 28, 2019 at 4:29 PM -0500, "Tom Moffett" <
>> >> tlmoffet...@gmail.com> wrote:
>> >>
>> >> Has anyone had success connecting to Old Line Bank?  It is listed in
>> the
>> >>> database, but when I setup a user and attempt to retrieve a list of
>> accounts
>> >>> I get an error message that I have entered and incorrect username or
>> >>> password.  I questioned the bank's tech support folks and they had
>> never
>> >>> heard of GnuCash.  They said they support Quicken (which I have been
>> using
>> >>> successfully).  If I can't connect to this bank GnuCash won't work
>> for me at
>> >>> all.
>> >>>
>> >>>
>> >>>
>> >>> Thanks in advance for any help.
>> >>>
>> >>>
>> >>>
>> >>> Tom Moffett
>> >>>
>> >>> I hope to become the man my dog thinks I am.
>> >>>
>> >>>
>> >>>
>> >>> ___
>> >>> 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 subscri

Re: [GNC] Old Line Bank

[Thomas Moffett]

Thanks

Tom

sent from my Note 5

On Thu, Feb 28, 2019, 6:07 PM  wrote:

> I am using gnucash for the my accounting program and download the quicken
> information from my bank website directly since I am not using quicken I do
> not have to upgrade the quicken program. You have to open the bank's
> website from your computer's internet program and download the quicken
> information save the download data. I normally have gnucash already opened
> so that I can just click on the qnucash tab and import  the latest download
> from the bank.
>
> Get Outlook for Android <https://aka.ms/ghei36>
>
>
>
>
> On Thu, Feb 28, 2019 at 5:37 PM -0500, "Thomas Moffett" <
> tlmoffet...@gmail.com> wrote:
>
>  I'm not sure I follow you. The point of switching to gnucash is so that I
>> no longer need to download into Quicken because they're cutting off my
>> online access unless I upgrade.
>>
>> It sounds like you're suggesting that I download into Quicken and then
>> import from Quicken into gnucash. Or am I completely misunderstanding your
>> suggestion?
>>
>> Tom
>>
>> sent from my Note 5
>>
>> On Thu, Feb 28, 2019, 5:20 PM  wrote:
>>
>>> I would use the the import function of gnu cash after downloading the
>>> quicken information from your bank website using your username and
>>> password. I use this method for all my online banking services that are not
>>> gnucash friendly.
>>>
>>> Joseph St Denis
>>>
>>> Get Outlook for Android <https://aka.ms/ghei36>
>>>
>>>
>>>
>>>
>>> On Thu, Feb 28, 2019 at 4:29 PM -0500, "Tom Moffett" <
>>> tlmoffet...@gmail.com> wrote:
>>>
>>> Has anyone had success connecting to Old Line Bank?  It is listed in the
>>>> database, but when I setup a user and attempt to retrieve a list of 
>>>> accounts
>>>> I get an error message that I have entered and incorrect username or
>>>> password.  I questioned the bank's tech support folks and they had never
>>>> heard of GnuCash.  They said they support Quicken (which I have been using
>>>> successfully).  If I can't connect to this bank GnuCash won't work for me 
>>>> at
>>>> all.
>>>>
>>>>
>>>>
>>>> Thanks in advance for any help.
>>>>
>>>>
>>>>
>>>> Tom Moffett
>>>>
>>>> I hope to become the man my dog thinks I am.
>>>>
>>>>
>>>>
>>>> ___
>>>> 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] Old Line Bank

[Thomas Moffett]

 I'm not sure I follow you. The point of switching to gnucash is so that I
no longer need to download into Quicken because they're cutting off my
online access unless I upgrade.

It sounds like you're suggesting that I download into Quicken and then
import from Quicken into gnucash. Or am I completely misunderstanding your
suggestion?

Tom

sent from my Note 5

On Thu, Feb 28, 2019, 5:20 PM  wrote:

> I would use the the import function of gnu cash after downloading the
> quicken information from your bank website using your username and
> password. I use this method for all my online banking services that are not
> gnucash friendly.
>
> Joseph St Denis
>
> Get Outlook for Android 
>
>
>
>
> On Thu, Feb 28, 2019 at 4:29 PM -0500, "Tom Moffett" <
> tlmoffet...@gmail.com> wrote:
>
> Has anyone had success connecting to Old Line Bank?  It is listed in the
>> database, but when I setup a user and attempt to retrieve a list of accounts
>> I get an error message that I have entered and incorrect username or
>> password.  I questioned the bank's tech support folks and they had never
>> heard of GnuCash.  They said they support Quicken (which I have been using
>> successfully).  If I can't connect to this bank GnuCash won't work for me at
>> all.
>>
>>
>>
>> Thanks in advance for any help.
>>
>>
>>
>> Tom Moffett
>>
>> I hope to become the man my dog thinks I am.
>>
>>
>>
>> ___
>> 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] GnuCash 3.2 Japanese Keyboard

[Thomas Reich]

Hi,
I have exactly the same problem now. I've made no changes to my system or
gnucash and prior it worked fine, but suddenly it only shows Kanas and
ignores all IME settings. I then updated to Gnucash 3.4 but no change. Prior
I was on 3.1 and it worked until today. Is there a solution for this?

As a sidenote, I had the same problem for Geany and never found a fix. I
would only do it intermittendly. Using Pycharm now and no more problems. I'm
afraid no such alternative for Gnucash exists, so would love to know a
solution.]

thanks,
thomas




--
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.

[GNC] USD Currency Missing in 3.4

[Chen Thomas]

Hi,

I just downloaded V3.4 and updated it from V3.3 in Windows 10.

Since Finance::Quote can not work with AlphaVantage for a while, I usually 
update currency and stock price manually in Price Database.
But, in V3.4 I can not find USD currency list to update. I can find other 
currency and replace it with USD and get USD currency updated, but it still can 
not be shown in USD currency list.
Something weird, I can not find it but the USD currency I just updated is 
working.

Anyone has the same issue like mine?

Thank you.

Thomas Chen
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Gnucash 3.3

[Thomas Hill]

I have Mac Mohave 10.14.2. I downloaded Gnucash 3.3 and installed. Then I 
attempted to open it. Went through the usual open sequence, said opening, but 
does not open. Icon in Menu Bar, but does not open.

 

 

 

Thomas Hill

Web: www.masterministries.org

Email: hill_...@att.net

 

 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] [GNC-dev] GnuCash 3.3 Released

[Thomas Hill]

I have Mac Mohave 10.14.2. I downloaded Gnucash 3.3 and installed. Then I 
attempted to open it. Went through the usual open sequence, said opening, but 
not open. In fact, cannot find it open on my Mac. Icon still in Menu Bar, but 
does not show it open.

 

Thomas Hill

Web: www.masterministries.org

Email: hill_...@att.net

 

 

___
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] Accounting Modules

[Thomas Forrester]

Hence the reason payroll is so often outsourced.

On Wed, Nov 28, 2018 at 4:20 PM Derek Atkins  wrote:

> Geert Janssens  writes:
>
> > Payroll on the other hand is not my cup of tea and likely more targeted
> at
> > larger businesses.
>
> When I was more active in my consulting business, a payroll feature
> would have been very useful.
>
> I still maintain that GnuCash could contain a payroll framework which
> defines the types of entries and sets of rules for taxes, deductions,
> etc that would cover all locales.  However, the rules vary so much by
> locality and change so frequently that there's no way we could maintain
> that part of the system.
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
> --
>Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>Member, MIT Student Information Processing Board  (SIPB)
>URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
>warl...@mit.eduPGP key available
> ___
> 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] Old dates preferred to near future

[Thomas Klausner]

On Thu, Sep 06, 2018 at 10:53:45AM +0200, Geert Janssens wrote:
> Perhaps you are experiencing a change in the Date completion settings.
> 
> Can you check Edit->Preferences->Date/Time->Date Completion and adjust to 
> your 
> preferences.

Indeed, setting that from 11 to 3 makes it match what I want.

Thank you!
 Thomas
___
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] Old dates preferred to near future

[Thomas Klausner]

Hi!

Something changed in one of the last versions of gnucash (now using
3.2).

ISTR that when I type Oct 10, it would choose Oct 10 2018. Now it uses
Oct 10 2017, which is almost never what I want.

Do I misremember?

If not, can I please have the old behaviour back, or at least
something more like the old behaviour?

Thanks,
 Thomas
___
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 @ Mac OS annoyances

[Thomas Klausner]

On Wed, Aug 15, 2018 at 06:52:03AM -0700, John Ralls wrote:
> 
> 
> > On Aug 15, 2018, at 12:21 AM, Thomas Klausner  wrote:
> > 
> > Hi!
> > 
> > I'm a long-time gnucash user, and tried out the Mac OS version (3.2)
> > for the first time today. I was using the official binary downloaded
> > from sourceforge.
> > 
> > I have the following issues that I hadn't seen before on other OS:
> > 
> > * When I start typing the Description, it auto-completes, but does not
> >  automatically select the completed part, which makes it much harder
> >  to write new entries.
> > 
> >  E.g. if I want to write "Bank" but "Bus" already exists, I get
> >  "Bankus" because "us" is not selected and automatically overwritten
> >  when I type the "u". So I manually have to select and delete the
> >  autocompleted part I don't want.
> > 
> > * When I enter an account name, ":" does not work to select the subaccount.
> > 
> >  I.e. when I type "E:C" I don't get "Expenses:Car" selected, but just
> >  "E:Cxpenses". I can choose the account I want with the up/down keys,
> >  but that's much slower with many subaccounts.
> > 
> > * I liked my Umlauts, but I usually enter them using "Option+u u".
> >  However, when I press "Option" in an Account Creation (or Edit)
> >  dialog, the input field loses its focus (it does work in
> >  "Description" fields when entering transactions). It also worked in
> >  the initial account creation dialogs.
> > 
> >  Here I have the workaround of entering the letter in some other
> >  application and copy'n'pasting it, and I don't need this dialog that
> >  often, but it would be nice if it worked anyway.
> > 
> > The first two items are quite annoying. Are there solutions or at
> > least workarounds for this?
> > 
> > Should I file bug reports?
> 
> The first two are the same and already reported as 
> https://bugs.gnucash.org/show_bug.cgi?id=796734 
> <https://bugs.gnucash.org/show_bug.cgi?id=796734> and there’s a workaround 
> explained there.

Thank you, the workaround works for me.

> The third one is new, so please do file a bug report on it. It’s not option 
> by itself, it’s option-u or more correctly alt-u, is set as a binding 
> somewhere. There’s no problem entering é, for example.

I've filed https://bugs.gnucash.org/show_bug.cgi?id=796810 for this.

Cheers,
 Thomas
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] gnucash @ Mac OS annoyances

[Thomas Klausner]

Hi!

I'm a long-time gnucash user, and tried out the Mac OS version (3.2)
for the first time today. I was using the official binary downloaded
from sourceforge.

I have the following issues that I hadn't seen before on other OS:

* When I start typing the Description, it auto-completes, but does not
  automatically select the completed part, which makes it much harder
  to write new entries.

  E.g. if I want to write "Bank" but "Bus" already exists, I get
  "Bankus" because "us" is not selected and automatically overwritten
  when I type the "u". So I manually have to select and delete the
  autocompleted part I don't want.

* When I enter an account name, ":" does not work to select the subaccount.

  I.e. when I type "E:C" I don't get "Expenses:Car" selected, but just
  "E:Cxpenses". I can choose the account I want with the up/down keys,
  but that's much slower with many subaccounts.

* I liked my Umlauts, but I usually enter them using "Option+u u".
  However, when I press "Option" in an Account Creation (or Edit)
  dialog, the input field loses its focus (it does work in
  "Description" fields when entering transactions). It also worked in
  the initial account creation dialogs.

  Here I have the workaround of entering the letter in some other
  application and copy'n'pasting it, and I don't need this dialog that
  often, but it would be nice if it worked anyway.

The first two items are quite annoying. Are there solutions or at
least workarounds for this?

Should I file bug reports?

Thanks,
 Thomas
___
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] Going Back to Go Forward?

[Thomas Forrester]

That is a truly useful suggestion.  Makes sense!  Thank you!

On Tue, Aug 7, 2018 at 2:11 AM cicko  wrote:

> Adrien Monteleone-2 wrote
> > There were some early issues with data but those seem to have been solved
> > by 3.2. (I’m using the sqlite3 backend, and had to switch to XML during
> > the interim but am back to normal with the 3.2 release) Sure there are a
> > few annoyances with the 3.x series so far, but those are being worked
> out.
>
> Also, if you take the latest build from
> https://code.gnucash.org/builds/win32/maint/ (Windows!), you can get some
> extra bug fixes that will only be officially released by October.
> In general, I find these releases a bit more stable than the stable
> versions. :) This is due to the fact that they contain mostly bug fixes and
> no new features as such.
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Going Back to Go Forward?

[Thomas Forrester]

For me, Dave, I *am* importing transactions.  These are transactions coming
from the banks I do business with and they have the typical all-caps,
hacked-up wording the ACH applies to the transactions.  I'm actually trying
to clean them up.  Yes, I suppose I could go into the qfx file and clean it
up there before import, but, well, no.  I'm supposed to be able to do it
more easily (and safely) in GnuCash, not some random text editor.



On Mon, Aug 6, 2018 at 11:28 PM David Reiser via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Do you always have to edit a transaction after pasting it? You only have
> to close and reopen the register if you have to use the delete key after
> pasting. If I had to cut and paste that many transaction elements a day,
> I’d figure out a way to export the source to CSV and import them instead of
> copy/paste.
>
> I guess I’m jaded because my file is big enough that type-ahead works so
> well I almost never have to paste anything in, and I’m usually only typing
> a few characters per field, except for the amount columns.
>
> Everyone gets to pick which annoyances count as showstoppers for them.
> --
> Dave Reiser
> dbrei...@icloud.com
>
>
>
>
>
> > On Aug 7, 2018, at 12:09 AM, David Carlson 
> wrote:
> >
> > I would consider needing to close and reopen a bank account register
> after
> > each transaction edit executed by pasting some text from the clipboard to
> > be a major showstopper when I have ten or twenty transaction s a day.
> >
> > David C
> >
> > On Mon, Aug 6, 2018, 10:42 PM Michael via gnucash-user <
> > gnucash-user@gnucash.org> wrote:
> >
> >> I guess I hadn't tried to do a paste into a transaction.  I see what
> >> you mean, although I didn't need to restart gnucash to recover.  While
> >> I was typing the answer came from David Reiser that it will be fixed
> >> when 3.3 comes out.  Mike
> >>
> >> On Mon, Aug 6, 2018 at 8:12 PM, Thomas Forrester
> >>  wrote:
> >>> Well, in particular, what I mentioned in the original post: once you
> >>> use
> >>> the clipboard to paste into a transaction, all further editing of
> >>> that. or
> >>> apparently anything else is just not going to happen until you
> >>> restart the
> >>> program.  To me, that's about the biggest show-stopper I could ever
> >>> consider with *any* program - having to restart it all the time just
> >>> to get
> >>> it working again.  I should think this massive problem would have been
> >>> corrected almost immediately given the magnitude of the inconvenience
> >>> it
> >>> causes, but it has been quite a while and I have no clue how long it
> >>> will
> >>> take.
> >>>
> >>> If someone can tell me it's already been fixed and there is a 3.2.1
> >>> (or
> >>> whatever) release due any second now, great!  I'll wait it out.  But
> >>> a few
> >>> more months till something happens, well, um...
> >>>
> >>> On Mon, Aug 6, 2018 at 11:18 AM Adrien Monteleone <
> >>> adrien.montele...@lusfiber.net> wrote:
> >>>
> >>>> You may not get a warning or alert!
> >>>>
> >>>> Also, yes, at the very least the date/time stamps are different and
> >>>> this
> >>>> is particularly an issue with the MySQL backend if I recall
> >>>> correctly. I
> >>>> wouldn’t attempt to step back any further than 2.6.21, but I’d
> >>>> ask, what in
> >>>> particular are you finding that you need to step back for?
> >>>>
> >>>> There were some early issues with data but those seem to have been
> >>>> solved
> >>>> by 3.2. (I’m using the sqlite3 backend, and had to switch to XML
> >>>> during the
> >>>> interim but am back to normal with the 3.2 release) Sure there are
> >>>> a few
> >>>> annoyances with the 3.x series so far, but those are being worked
> >>>> out.
> >>>>
> >>>> Regards,
> >>>> Adrien
> >>>>
> >>>>> On Aug 6, 2018, at 10:15 AM, Thomas Forrester
> >>>> 
> >>>> wrote:
> >>>>>
> >>>>> Thanks, Mike.
> >>>>>
> >>>>> So from what you are saying, there is some sort of data
> >>>> structures check
> >>>>> that would alert me if I am using a v

Re: [GNC] Going Back to Go Forward?

[Thomas Forrester]

I will look at this again closely in light of your reply, Dave.  My
experience has been that no further edits are possible, period, but I will
experiment a bit more next time it happens.  Closing and restarting GnuCash
was a solution noted in a much earlier thread on this topic and I don't
recall any one saying closing and reopening the register was sufficient to
get unstuck.

Thanks.

On Mon, Aug 6, 2018 at 10:36 PM David Reiser  wrote:

> In my experience the pasting-prevents-delete-key-action bug only affects
> the particular register in which the pasting occurred. And fixing the
> problem only requires closing that register and reopening it, not
> relaunching gnucash itself.
>
> Also, while the delete key is impeded, you can select text and type
> corrections directly. You still can’t select text and delete it, so you’ll
> have to type at least one character to replace any mistakes until you close
> and reopen the register.
>
> The bug is fixed for 3.3, scheduled for release at the end of September.
> The team has been very good lately at hitting release dates.
> --
> Dave Reiser
> dbrei...@icloud.com
>
>
>
>
>
> > On Aug 6, 2018, at 11:12 PM, Thomas Forrester 
> wrote:
> >
> > Well, in particular, what I mentioned in the original post: once you use
> > the clipboard to paste into a transaction, all further editing of that.
> or
> > apparently anything else is just not going to happen until you restart
> the
> > program.  To me, that's about the biggest show-stopper I could ever
> > consider with *any* program - having to restart it all the time just to
> get
> > it working again.  I should think this massive problem would have been
> > corrected almost immediately given the magnitude of the inconvenience it
> > causes, but it has been quite a while and I have no clue how long it will
> > take.
> >
> > If someone can tell me it's already been fixed and there is a 3.2.1 (or
> > whatever) release due any second now, great!  I'll wait it out.  But a
> few
> > more months till something happens, well, um...
> >
> > On Mon, Aug 6, 2018 at 11:18 AM Adrien Monteleone <
> > adrien.montele...@lusfiber.net> wrote:
> >
> >> You may not get a warning or alert!
> >>
> >> Also, yes, at the very least the date/time stamps are different and this
> >> is particularly an issue with the MySQL backend if I recall correctly. I
> >> wouldn’t attempt to step back any further than 2.6.21, but I’d ask,
> what in
> >> particular are you finding that you need to step back for?
> >>
> >> There were some early issues with data but those seem to have been
> solved
> >> by 3.2. (I’m using the sqlite3 backend, and had to switch to XML during
> the
> >> interim but am back to normal with the 3.2 release) Sure there are a few
> >> annoyances with the 3.x series so far, but those are being worked out.
> >>
> >> Regards,
> >> Adrien
> >>
> >>> On Aug 6, 2018, at 10:15 AM, Thomas Forrester 
> >> wrote:
> >>>
> >>> Thanks, Mike.
> >>>
> >>> So from what you are saying, there is some sort of data structures
> check
> >>> that would alert me if I am using a version of the program that is
> >>> incompatible with the data version.  Checking my downloads, I find I
> have
> >>> the .21 installer which I wouldn't have unless I had installed that
> >>> version.  So Looks like I may be good to take a step back.
> >>>
> >>> Maybe a corollary question then -  although backward compatible with a
> >> .21
> >>> database, does 3.x introduce any new changes to the data structures
> that
> >>> would make this a really bad idea?
> >>>
> >>> On Mon, Aug 6, 2018 at 9:26 AM Michael  wrote:
> >>>
> >>>> It is my understanding that 2.6.21 is the only 2.6.x that is
> compatible
> >>>> with the 3.2 data structure.  I have used 2.6.21 successfully with 3.2
> >>>> data, but older 2.6.x report that they are not compatible.  I believe
> >> that
> >>>> is true of xml and sql databases.  Mike
> >>>>
> >>>> On Mon, Aug 6, 2018 at 4:17 AM, Thomas Forrester <
> tlforres...@gmail.com
> >>>
> >>>> wrote:
> >>>>
> >>>> On a Windows computer, I upgraded to 3.2 from 2.6.20 I think it was
> back
> >>>> when I first noticed version 3 had been released. Took me till 3.2 to
> >>>> notice, but I think it was within a few days of 

Re: [GNC] Going Back to Go Forward?

[Thomas Forrester]

Well, in particular, what I mentioned in the original post: once you use
the clipboard to paste into a transaction, all further editing of that. or
apparently anything else is just not going to happen until you restart the
program.  To me, that's about the biggest show-stopper I could ever
consider with *any* program - having to restart it all the time just to get
it working again.  I should think this massive problem would have been
corrected almost immediately given the magnitude of the inconvenience it
causes, but it has been quite a while and I have no clue how long it will
take.

If someone can tell me it's already been fixed and there is a 3.2.1 (or
whatever) release due any second now, great!  I'll wait it out.  But a few
more months till something happens, well, um...

On Mon, Aug 6, 2018 at 11:18 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> You may not get a warning or alert!
>
> Also, yes, at the very least the date/time stamps are different and this
> is particularly an issue with the MySQL backend if I recall correctly. I
> wouldn’t attempt to step back any further than 2.6.21, but I’d ask, what in
> particular are you finding that you need to step back for?
>
> There were some early issues with data but those seem to have been solved
> by 3.2. (I’m using the sqlite3 backend, and had to switch to XML during the
> interim but am back to normal with the 3.2 release) Sure there are a few
> annoyances with the 3.x series so far, but those are being worked out.
>
> Regards,
> Adrien
>
> > On Aug 6, 2018, at 10:15 AM, Thomas Forrester 
> wrote:
> >
> > Thanks, Mike.
> >
> > So from what you are saying, there is some sort of data structures check
> > that would alert me if I am using a version of the program that is
> > incompatible with the data version.  Checking my downloads, I find I have
> > the .21 installer which I wouldn't have unless I had installed that
> > version.  So Looks like I may be good to take a step back.
> >
> > Maybe a corollary question then -  although backward compatible with a
> .21
> > database, does 3.x introduce any new changes to the data structures that
> > would make this a really bad idea?
> >
> > On Mon, Aug 6, 2018 at 9:26 AM Michael  wrote:
> >
> >> It is my understanding that 2.6.21 is the only 2.6.x that is compatible
> >> with the 3.2 data structure.  I have used 2.6.21 successfully with 3.2
> >> data, but older 2.6.x report that they are not compatible.  I believe
> that
> >> is true of xml and sql databases.  Mike
> >>
> >> On Mon, Aug 6, 2018 at 4:17 AM, Thomas Forrester  >
> >> wrote:
> >>
> >> On a Windows computer, I upgraded to 3.2 from 2.6.20 I think it was back
> >> when I first noticed version 3 had been released. Took me till 3.2 to
> >> notice, but I think it was within a few days of the 3.2 release Having
> now
> >> used 3.2 for a short while, I'm wondering if there's any issue with
> going
> >> back to 2.6.x? In other words, are there any underlying data structure
> >> changes, or other file changes, that would make this a huge mistake? I
> am
> >> using the MySQL database backend. I just feel at this point that, if I
> >> can't further edit anything after pasting something in from the
> clipboard,
> >> that it may be a better idea to go back so I can go forward.
> >> ___ 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
> I

Re: [GNC] Going Back to Go Forward?

[Thomas Forrester]

Thanks, Mike.

So from what you are saying, there is some sort of data structures check
that would alert me if I am using a version of the program that is
incompatible with the data version.  Checking my downloads, I find I have
the .21 installer which I wouldn't have unless I had installed that
version.  So Looks like I may be good to take a step back.

Maybe a corollary question then -  although backward compatible with a .21
database, does 3.x introduce any new changes to the data structures that
would make this a really bad idea?

On Mon, Aug 6, 2018 at 9:26 AM Michael  wrote:

> It is my understanding that 2.6.21 is the only 2.6.x that is compatible
> with the 3.2 data structure.  I have used 2.6.21 successfully with 3.2
> data, but older 2.6.x report that they are not compatible.  I believe that
> is true of xml and sql databases.  Mike
>
> On Mon, Aug 6, 2018 at 4:17 AM, Thomas Forrester 
> wrote:
>
> On a Windows computer, I upgraded to 3.2 from 2.6.20 I think it was back
> when I first noticed version 3 had been released. Took me till 3.2 to
> notice, but I think it was within a few days of the 3.2 release Having now
> used 3.2 for a short while, I'm wondering if there's any issue with going
> back to 2.6.x? In other words, are there any underlying data structure
> changes, or other file changes, that would make this a huge mistake? I am
> using the MySQL database backend. I just feel at this point that, if I
> can't further edit anything after pasting something in from the clipboard,
> that it may be a better idea to go back so I can go forward.
> ___ 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] Going Back to Go Forward?

[Thomas Forrester]

On a Windows computer, I upgraded to 3.2 from 2.6.20 I think it was back
when I first noticed version 3 had been released.  Took me till 3.2 to
notice, but I think it was within a few days of the 3.2 release

Having now used 3.2 for a short while, I'm wondering if there's any issue
with going back to 2.6.x?  In other words, are there any underlying data
structure changes, or other file changes, that would make this a huge
mistake?  I am using the MySQL database backend.

I just feel at this point that, if I can't further edit anything after
pasting something in from the clipboard, that it may be a better idea to go
back so I can go forward.
___
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] Quote seems to have stopped working

[Chen Thomas]

Yes, I have the same problem, and I posted this issue on 7/31, looks like some 
had the same issue.
I think AlphaVantage has been having some problem since 7/30. It ever worked 2 
days ago, but not right now.

-Original Message-
From: gnucash-user  On 
Behalf Of Megagrumpy
Sent: Friday, August 3, 2018 2:31 PM
To: gnucash-user@gnucash.org
Subject: [GNC] Quote seems to have stopped working

I have been unable to retrieve quotes since July 31st. It did not work 
perfectly since the change away from Yahoo and there was usually a few quotes 
that were not retrieved but by running it regularly I was able to keep most 
stocks up to date. It always completed and came back with a message saying what 
had not been retrieved even though it took a few minutes. Now I get the Perl 
window and the rotating pointer but then nothing. I have left it running for 
more than 15 minutes and there is no change.

I am using GnuCash 2.6.18 



--
Sent from: 
https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgnucash.1415818.n4.nabble.com%2FGnuCash-User-f1415819.htmldata=02%7C01%7C%7C7069e38fc56e4b05f1a608d5f91bcd2d%7C84df9e7fe9f640afb435%7C1%7C0%7C636688820153140683sdata=WKQPNtZH71MdbZhReOAz7MgIjJqIL2KJ8HlndaNxtGU%3Dreserved=0
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-userdata=02%7C01%7C%7C7069e38fc56e4b05f1a608d5f91bcd2d%7C84df9e7fe9f640afb435%7C1%7C0%7C636688820153296950sdata=fd2ZdUdszo8o%2FpO2qeAlsnbT93OsNhul%2B43vVPjgsHQ%3Dreserved=0
If you are using Nabble or Gmane, please see 
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Listsdata=02%7C01%7C%7C7069e38fc56e4b05f1a608d5f91bcd2d%7C84df9e7fe9f640afb435%7C1%7C0%7C636688820153296950sdata=knhjqFRlcLVsMNF4TOtII7GVY%2F9h3l%2Fp9yDLwUAeF4s%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.

Re: [GNC] Get Quote is Not Working?

[Chen Thomas]

I also think AlphaVantage is having a problem, due to I tried it on another 
laptop, it's still not working yet.

thomas

-Original Message-
From: gnucash-user  On 
Behalf Of Les
Sent: Tuesday, July 31, 2018 9:48 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Get Quote is Not Working?

I have the same problem. I think AlphaVantage is having a problem.

Les


On 07/31/2018 08:28 AM, Chen Thomas wrote:
> Hi,
>
> My GC is 3.2 and Finance::Quote is also up to date 1.47 in Windows 10.
> Get Quote had been working well until yesterday. Get Quote window (perl is 
> running) is now freezing and not working today.
>
> Is anyone experiencing the same issue?
>
> Thanks,
> thomas
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-userdata=02%7C01%7C%7Cf36c6d1a0fdd4c7d6bfb08d5f6edc8a3%7C84df9e7fe9f640afb435%7C1%7C0%7C636686423480722879sdata=T9bISwyd9n%2BWs5aiQP4AgTll%2BpgGp2y4aHVgc6dr0L4%3Dreserved=0
> If you are using Nabble or Gmane, please see 
> https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Listsdata=02%7C01%7C%7Cf36c6d1a0fdd4c7d6bfb08d5f6edc8a3%7C84df9e7fe9f640afb435%7C1%7C0%7C636686423480722879sdata=7qqWwnc46Q3pxuhDJ%2Fs1qGPRDjvyv7jL8cbRXyFOp20%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://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-userdata=02%7C01%7C%7Cf36c6d1a0fdd4c7d6bfb08d5f6edc8a3%7C84df9e7fe9f640afb435%7C1%7C0%7C636686423480722879sdata=T9bISwyd9n%2BWs5aiQP4AgTll%2BpgGp2y4aHVgc6dr0L4%3Dreserved=0
If you are using Nabble or Gmane, please see 
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Listsdata=02%7C01%7C%7Cf36c6d1a0fdd4c7d6bfb08d5f6edc8a3%7C84df9e7fe9f640afb435%7C1%7C0%7C636686423480722879sdata=7qqWwnc46Q3pxuhDJ%2Fs1qGPRDjvyv7jL8cbRXyFOp20%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.

[GNC] Get Quote is Not Working?

[Chen Thomas]

Hi,

My GC is 3.2 and Finance::Quote is also up to date 1.47 in Windows 10.
Get Quote had been working well until yesterday. Get Quote window (perl is 
running) is now freezing and not working today.

Is anyone experiencing the same issue?

Thanks,
thomas
___
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] 529 Help New

[Thomas E Moughan]

Hi Khristine...

With our 529 plans, the price we pay for new shares is more than the
"current" price for the share, e.g. we pay $1.10 for a share with a current
value of $1.00!

Have you accounted for this difference in your GnuCash transaction, e.g.
$.10 per share, expensed to a broker fee or some such? This would reduce
your GnuCash total to what would be on the website..

Tom


>
> Date: Sat, 7 Jul 2018 21:43:28 +
> From: Khristine Ann Ramella 
> To: "gnucash-user@gnucash.org" 
> Subject: [GNC] 529 Help New
> Message-ID:
> <
> bn6pr11mb1779f0755312e6e495be1c93d6...@bn6pr11mb1779.namprd11.prod.outlook.com
> >
>
> Content-Type: text/plain; charset="Windows-1252"
>
> Super clueless new Gnu User seeks someone to help explain 529. I asked for
> help before and was directed to various places which gave a little insight,
> but not as much as I need.
>
> Here is what I have done:Created a Mutual Fund for 529 A and
> one for 529 B?I believe I have done this right but it is open to debate
> since I don?t understand a lot of the specifics required to open the
> accounts (security/commodity?) Yikes!
>   Created a cash
> account to transfer the money out of my checking. Then I went in to the
> mutual fund and made the purchase out of the cash. That seemed to go well.
> The info on my 529 web site/statement and the ledger of my 529 seem to add
> up/match in terms of shares, price paid-HOWEVER the totals don?t add up. My
> gnu total  shows for example 4503 , while my account online total shows 4392
> Also, on my main gnu page instead of showing the total in each account, it
> shows the shares and the account number and then the total is shown
> (incorrectly as mentioned before) under mutual fund in general.
>
>
> I have scoured the internet for videos, articles related to this and no
> luck. I really don?t understand, but would like to if someone can explain
> in simple terms. Open to email lessons or anything
>
> Many 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
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] Imbalance-

[Thomas Forrester]

The "Imbalance" account is used when GnuCash knows where one side of the
transaction is going, but not the other.  That's actually a pretty helpful
catch-all account for when GnuCash has undistributed amounts.  During the
import, you can specify the other side of the transaction on the screen
that lists all the transactions found in your bank download.  GnuCash will
try to automatch based upon previous transactions that appear to be the
same as one just downloaded, but may have found something completely new,
or not yet figured out what to do with a transaction.  In particular, look
for the ones marked "New, Unbalanced...".  You can double click the entry
and tell GnuCash where the other side of the transaction should go.

You can delete the account, I suppose, but I think GnuCash would just
recreate it next time it finds it needs it.  It's a necessary account since
GnuCash has to have somewhere to put unbalanced amounts.  The goal
shouldn't be to eliminate it, but keep it at a zero balance since a
non-zero balance indicates a problem with a transaction somewhere.  It's a
red flag account.  Preventing it from populating requires making sure all
transactions have corresponding debit and credit accounts (totalling to the
same amount if split).

On Sat, Jul 7, 2018 at 6:44 PM Hmm  wrote:

> I have just installed GnuCash and I am importing Quicken (QFX) files from
> my
> bank (chequing, savings, credit cards etc.) and I have a separate account
> name for Imbalance.
>
> How can I delete this or prevent it from populating in the future whenever
> I
> download transactions?
>
> Thanks
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Where is the theme selection in 3.x?

[Thomas Forrester]

You're right Geert, this class of application rarely has theming
capabilities, but it was a very nice feature of GnuCash and it at least had
the capability of dressing up an otherwise rather utilitarian interface.

Personally, if you would just go in and adjust the tool-tips to be
something other that thin white text on a jet black background, I'd be 3/4
the way to happy.  The text literally takes on a rainbow effect on my
monitors because the antialiasing isn't correct for the colors used and the
stroke weight of the font.  That can't be a huge undertaking to fix. Don't
worry about the antialiasing, just make the font color black, and font
weight bold and set the background color to maybe 15% grey and it ought to
look way better.

As for stepping up, I'd love to, and I used to develop financial systems
customizations and full modules in what has slowly morphed from Solomon IV
to Great Plains to Microsoft Dynamics.  But that was in a Visual Basic 6 /
MS SQL Server environment.  Not to mention somewhere around 18 years ago.
I have no idea how to develop anything in the Linux environment, and don't
even know what language GnuCash is written in.  Never been involved in a
"community" project of this magnitude.  Overall, I think the problem you
face is that your audience (whatever platform they are on) are accountants
and bookkeepers, not programmers.  Hard to find just the right development
skill set and knowledge of accounting all in one person.

And thank you for listening to my gripe anyway,  ;)

Tom





On Wed, Jul 4, 2018 at 7:33 AM Geert Janssens 
wrote:

> Op woensdag 4 juli 2018 13:56:36 CEST schreef Thomas Forrester:
> > I think trying to make al the Windows users into programmers just so they
> > can get a theme they like - something they always had in 2.x - is a
> crying
> > shame.
>
> Personally I think you're overreacting here. How many more serious
> applications on Windows allow custom themes ? I don't think MS Office
> does,
> nor LibreOffice, Firefox used to have something like personalities, but I
> think they dropped that as well. And for sure *none* of the accounting
> packages I have personally used on Windows (Winbooks, Expert M, Vero,
> Popsy,...) did have anything like custom themes.
>
> I agree it's unfortunate gnucash can't provide a nice gui for that at this
> point and I understand very well the frustration of seeing a feature you
> relied disappear.
>
> > I've said it before, but I guess I'll say it again, I realize this
> > application is developed primarily on Linux.  That's completely awesome,
> > but like many other cross-platform applications, I suspect the installed
> > base of Windows users may eclipse all others.  I've seen this before
> where
> > the development platform takes second-fiddle to Windows as the most
> popular
> > usage platform.  I'm not trying to create debate on what platform is good
> > for what, but I do think it's important to maintain feature parity
> between
> > platforms.  This theming issue on Windows should be addressed in an
> update
> > soon.
> >
> So I'll repeat as well what I've said before: someone has to step in to
> provide the code. The currently active developers are working on more
> serious
> issues (program crashes, broken pre-existing functionality,...)
>
> So as there are so many more Windows users than on other platforms: I'm
> eagerly waiting for some of those Windows native users to care enough
> about
> gnucash to actually want to help in coding Windows specific features. This
> is
> a community project after all!
>
> > That said, if it's as simple as getting some files, or adding a two-line
> > file somewhere, please tell me where to go to get the files, where they
> > need to be put, and what to put in a file.  A tutorial on how to manually
> > theme GnuCash on Windows is better than no option at all.
> >
> That information is collected on this wiki page:
> https://wiki.gnucash.org/wiki/GTK3
>
> Regards,
>
> Geert
>
>
>
___
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 theme selection in 3.x?

[Thomas Forrester]

I think trying to make al the Windows users into programmers just so they
can get a theme they like - something they always had in 2.x - is a crying
shame.  I've said it before, but I guess I'll say it again, I realize this
application is developed primarily on Linux.  That's completely awesome,
but like many other cross-platform applications, I suspect the installed
base of Windows users may eclipse all others.  I've seen this before where
the development platform takes second-fiddle to Windows as the most popular
usage platform.  I'm not trying to create debate on what platform is good
for what, but I do think it's important to maintain feature parity between
platforms.  This theming issue on Windows should be addressed in an update
soon.

That said, if it's as simple as getting some files, or adding a two-line
file somewhere, please tell me where to go to get the files, where they
need to be put, and what to put in a file.  A tutorial on how to manually
theme GnuCash on Windows is better than no option at all.

Thanks!

On Wed, Jul 4, 2018 at 4:25 AM cicko  wrote:

> Perhaps Geert's were not clear enough. The theming in GnuCash relies (more
> or
> less) completely on GTK framework. This framework, in version 3, has moved
> completely to open standards (read CSS) for styling, allowing many more
> people to customize the visual appearance of GTK applications.
> Also, if you look at sites like https://www.gnome-look.org/, you might
> notice ~1000 different GTK3 themes.
> All you need to do is place the downloaded files into an appropriate
> directory.
> If all you want is a dark theme (whether on Windows or Linux), it gets even
> easier. All you need to do is create one settings file and copy/paste two
> lines into it.
> If this is too much effort, hopefully you can find someone to do it for
> you.
> If that is also not an option, then too bad.
> I think that spending development time of GnuCash developers on reinventing
> the wheel would really be a waste, considering the above. There are many
> more bugs and features to work on, which are more closely related to the
> core field of GnuCash.
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] autocomplete not working in 3.2

[Thomas Forrester]

Is it possible to revert to 2.x?  That is, were there any database changes
that would preclude going back?  Personally, 2.x was working perfectly for
me, but I would like to stay current.  That said, the removal of theming
from Windows is almost enough to make me want to go back till someone works
out that feature.

On Tue, Jul 3, 2018 at 9:47 PM Deane Yamane  wrote:

> I have the same problems. IMHO V3.x has been buggy from the start. Some
> nice features but not worth it. I think I’ll revert to 2.26(?) and wait
> till the ‘dust clears’ :(
> On Jul 1, 2018, 2:34 AM -1000, Michael Matz ,
> wrote:
> > I just upgraded from 3.0 to 3.2. macOs 10.13.5
> >
> > (I skipped 3.1 because 3.0 has worked well for me, with the limited set
> of
> > features I use.)
> >
> > When I enter a new transaction, I type the first letter in the
> description
> > column and GnuCash makes a suggestion but if I continue typing the
> > suggestion is not updated or replaced.
> >
> > For example, if I type "F" the description becomes "Food". If I then type
> > "a" then the description becomes "Faood". Or typing "Fo" becomes "Foood"
> > This worked as expected in 3.0 and previous versions, i.e. typing "Fa"
> > results in "Fa" (no suggestion) and typing "Fo" result in "Food".
> >
> > The same thing happens in the Transfer column
> >
> > Anybody else having this problem?
> >
> > I've switched back to 3.0 for now.
> >
> > Thanks,
> > Michael
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> ___
> 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] Uninstalling previous versions

[Thomas Forrester]

Hmm.  In the past it seemed that was happening just by replying, but I see
it did not in this case.  Replying to you AND the list this time, because I
agree that the devs need feedback on issues like this.  Thanks for pointing
out the missed address.


On Sun, Jul 1, 2018 at 12:25 PM Stan Brown 
wrote:

> Thanks for your agreement, but t looks like you replied to me and not to
> the list. I think the devs need to see comments on this point -- the
> more they see, the more likely they'll actually fix it.
>
> --
> Regards,
> Stan Brown
> Tompkins County, New York, USA
> http://BrownMath.com
> http://OakRoadSystems.com
>
>
> On 2018-07-01 11:58, Thomas Forrester wrote:
> > Totally agree.  Windows in not entirely free of messy installers, far
> > from it, but the vast majority of installers take care of the
> > prerequisites, including suspending the installation waiting for the
> > user to close a program that's trying to upgrade itself.  At a minimum
> > any installer worth its salt should be able to check existing files
> > against a manifest of valid files for the currently installing version,
> > and delete anything conflicting.
> >
> >
> > On Sun, Jul 1, 2018 at 7:04 AM Stan Brown  > <mailto:the_stan_br...@fastmail.fm>> wrote:
> >
> > Here's my take, for what it's worth. At least in the Windows world,
> the
> > assumption is that when you install a new version it either removes
> the
> > old version entirely, or leaves the old version functional but
> installs
> > the new version in parallel. (The latter is less common, but some
> > programs do it when the new version is a major change.) Leaving a few
> > old files behind as orphans is usually regarded as an error of the
> new
> > installer.
> >
> > I don't have a problem with the requirement to uninstall the old
> > version, but it was news to me, and I think would surprise many
> Windows
> > users. Surely the installer of the new version can uninstall the old
> > version itself -- and in my opinion, it should.
> >
> > --
> > Regards,
> > Stan Brown
> > Tompkins County, New York, USA
> > http://BrownMath.com
> > http://OakRoadSystems.com
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org <mailto: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] Edit Scheduled Transaction - This transaction is already being edited...

[Thomas Forrester]

Needing to adjust a recurring mortgage payment template, I went into the
Edit Scheduled Transactions window, over to the Template Transaction tab
and changed one of the amounts.  This resulted in an error message stating:

"This transaction is already being edited in another register.  Please
finish editing it there first."

Didn't think so, but closed ALL register tabs and tried again.  Same
error.  Restarted the program and tried again.  Same error.  Tried to edit
a completely different recurring transaction.  Same error.

Apparently editing a template transaction is not possible(?)  Or am I
missing something here?


GNC version 3.0-118-gd2ef5fd0f+ (2018-04-28) on Windows 10 / MySQL
___
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 theme selection in 3.x?

[Thomas Forrester]

I would have to agree.  Leaving all the Windows users to deal with a
single, not very appealing interface scheme is tragic.  It almost makes me
want to go back to 2.x until this situation has been dealt with.  2.x was
very stable and I had been able to find a theme I liked.  For the sake of
those Windows users who use this program on a daily basis, I think this
should be a development imperative.  I get that this program was born on
Linux and is developed and maintained there, and that's perfectly
brilliant.  So, too, is a similar situation for my favorite recreational
program - the X-Plane flight simulator.  It was written in the Mac world
and has version for other platforms.  Despite it's Mac origins, its most
used platform (and highest performance platform) is Windows.

I cannot devote hardware to a Linux box just for GnuCash, and wouldn't want
to have to go to another machine to do my accounting anyway.  Although I
could spool up a virtual machine with a Linux distro in Oracle VM
VirtualBox (and already have two) I find that they inevitably blow up for
some unknown reason.  I just cannot justify putting my financial data on a
precarious virtual machine.

Please, Please, Please don't let the Windows users fall to second-class
status.  That, IMHO, would be a huge mistake.



On Thu, Jun 7, 2018 at 12:18 PM Geert Janssens 
wrote:

> Op donderdag 7 juni 2018 19:03:09 CEST schreef randix:
> > /*Hope something similar comes back in a future version, cause speaking
> on
> > behalf of those who (1) don't have the time or (2) the skills or (3) the
> > patience, following the instructions in that wiki link to get some decent
> > color in GnuCash, well, that just "ain't" goin' happen.*/
> >
> > */Not user friendly.../*
> >
>
> It can certainly come back if someone is willing to spend developer time
> on
> it.
>
> Preferably someone who isn't already buried in other gnucash development
> work...
>
> Geert
>
>
> ___
> 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] Saved Report Configurations Missing After Upgrade to v3

[Thomas Forrester]

Hi Geert,

I located the trace files.  Not sure why, if they are such a valuable
diagnostic tool, that they are stored in the AppData Temp folder.  I also
found that every report I've looked at since upgrading to 3.x has a
corresponding html file in that Temp folder, too.  It might be worth
reconsidering the location for those files along with a retention
schedule.  But anyway...

Oh, and another suggestion - the trace file should have a version stamp,
not just a time stamp.  I can't really tell the exact point at which I
upgraded by just the time stamp.  I believe it was early in the day on
either Tuesday or Wednesday of this week, but a version stamp would
completely eliminate doubt.

I only have 13 trace files dated from 2018.06.04 to today, 2018.06.08.
These dates to include the upgrade from 2.?.19 to 3.0-118-gd2ef5fd0f+
(2018-04-28)

The vast majority of trace files only say:
* 05:58:17  WARN  Could not spawn perl: Failed to execute
child process (No such file or directory)

One of them pre-upgrade (I'm pretty sure) says:
* 06:30:48  WARN  Could not spawn perl: Failed to execute
child process (No such file or directory)
* 06:31:40  WARN  Could not find the icon 'gtk-file'. The 'hicolor'
theme
was not found either, perhaps you need to install it.
You can get a copy from:
http://icon-theme.freedesktop.org/releases

>From the morning of Wed 2018.06.06 which may be the time of upgrade:
* 06:25:32  WARN  Could not spawn perl: Failed to execute
child process (No such file or directory)
* 06:44:17  WARN  Could not locate file AUTHORS
* 06:44:17  WARN  Could not locate file DOCUMENTERS
* 06:44:17  WARN  Could not locate file LICENSE
* 07:07:15  CRIT  [gnc_ui_file_access_response_cb()] Invalid
response

The very next trace file, after I accidentally left the program running all
day says:
* 10:36:13  WARN  Could not spawn perl: Failed to execute
child process (No such file or directory)
* 18:45:07  CRIT 
[GncDbiSqlConnection::begin_transaction()] BEGIN transaction failed()
* 18:45:07  CRIT  [GncSqlBackend::commit()]
begin_transaction failed

The one that was apparently created just now when I started the program
says:
* 06:11:57  WARN  Could not spawn perl: Failed to execute
child process (No such file or directory)
* 06:15:05  CRIT  [gnc_ui_file_access_response_cb()] Invalid
response


There was no popup about moving metadata following the upgrade.

I never experimented with the dev series.

I will re-check the release notes, but as I upgraded to 3.1.x, hopefully I
just skipped over any earlier 3.0 issues.

Thanks!

On Thu, Jun 7, 2018 at 10:01 AM Geert Janssens 
wrote:

> Op donderdag 7 juni 2018 16:48:11 CEST schreef Thomas Forrester:
> > Hi Geert,
> >
> > The old saved-reports-2.4 file was found in the  %USER%\.gnucash folder.
> > None of the 3.-variations you mention apply here.
> >
> > When I located the 2.4 file, I backed up the new 2.8 file to take it
> > completely out of the picture, then copied the 2.4 file over to
> > %APPDATA%\GnuCash
> > to see what would happen.  If nothing, I figured I'd rename the file from
> > 2.4 to 2.8, but it worked with the 2.4 name.  Is this alright?  Will it
> > cause problems later?  Is there a better way?
> >
> No. That is what the migration should have done as well.
>
> >  When I upgraded to 3.x,
> > that is the environment it found itself upgrading.
>
> Ok, do you think you could still find the trace file gnucash generated the
> first time you started gnucash 3.x ? Where to find trace files is
> described
> here: http://wiki.gnucash.org/wiki/Tracefile
>
> Secondly, the first time you ran gnucash 3.x did you get a pop up window
> explaining you your metadata was being moved to a new location ?
>
> And lastly, did you ever experiment with the 2.7 development series on
> your
> current machine ?
>
> >
> > I'm slipping out of scope on the OP topic here, but (in the Windows
> > environment, if that matters) what is the best practice for data storage?
> > Am I setting myself up for problems using MySQL?  Has my use of MySQL
> > contributed to the missing report situation on upgrade to 3.x?
> >
> Xml is still considered the most stable format in general. That is
> independent
> of your OS. On the other hand the db formats are improving with each
> release.
> We did find a few issues in gnucash 3.0 and 3.1 in this area. So be sure
> to
> read the release notes for more details.
>
> Regards
>
> Geert
>
>
>
___
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] Saved Report Configurations Missing After Upgrade to v3

[Thomas Forrester]

Hi Geert,

The old saved-reports-2.4 file was found in the  %USER%\.gnucash folder.
None of the 3.-variations you mention apply here.

When I located the 2.4 file, I backed up the new 2.8 file to take it
completely out of the picture, then copied the 2.4 file over to
%APPDATA%\GnuCash
to see what would happen.  If nothing, I figured I'd rename the file from
2.4 to 2.8, but it worked with the 2.4 name.  Is this alright?  Will it
cause problems later?  Is there a better way?

A little history on this installation.
I'm not sure I'd remember the initial installed version, but it was back in
the fall of 2016 when I installed GnuCash on Windows in whatever manner the
installer prescribed as the standard install.  I LOVE the true double entry
accounting GnuCash allows over the typical one-sided manner in which most
financial programs (e.g., Quicken, et al) provide.  My only disappointment
has been in the reporting formats.  Not so much what is in the reports or
the ability to customize them; that's all perfectly acceptable.  It's the
overall report styling.  I don't understand why on the Income Statement,
for instance, there's a small font "Net Income for Period" line following a
large, bold "Total Expenses" line.  The formatting is whack, and I just
don't see an easy way to correct it or any resources to teach me how. (Know
of any?  Please share!)  That got me thinking that, since MySQL was an
option, I could just ODBC in with Microsoft Access and potentially use it's
report writer to generate prettier reports than I know how to make within
GnuCash.  I never really got to report designing in Access, but it sure got
me over some initial reconciliation pains!  But regardless, and for better
or worse, I left the backend for GnuCash as MySQL.  When I upgraded to 3.x,
that is the environment it found itself upgrading.

I'm slipping out of scope on the OP topic here, but (in the Windows
environment, if that matters) what is the best practice for data storage?
Am I setting myself up for problems using MySQL?  Has my use of MySQL
contributed to the missing report situation on upgrade to 3.x?

Thanks,
Tom




On Thu, Jun 7, 2018 at 3:09 AM Geert Janssens 
wrote:

> Op donderdag 7 juni 2018 05:38:47 CEST schreef Mike Churchill via gnucash-
> user:
> > Ok Tom.  Good to hear you were successful.  I wondered about the 2.8
> also,
> > but it seems to be the right file.  Mike
> >
> The 2.8 version is a small oversight. It was decided fairly late in the
> last
> development cycle to name the next big release 3.0. Before that we were
> aiming
> for 2.8 as a natural follow up for 1.8->2.0->2.2->2.4->2.6.
>
> The release numbering scheme was changed, but we omitted renaming the
> saved-
> reports file.
>
>
> Tom, out of curiosity: where did you find the old saved-reports-2.4 file ?
>
> Normally gnucash does migrate the metadata to %APPDATA%\GnuCash on the
> first
> time you run a gnucash 3.x version from %USER%\.gnucash.
>
> I can imagine a few situations where that won't happen:
> 1. %APPDATA%\GnuCash already exists
> 2. Can't create %APPDATA%\GnuCash (in which case the trace file should
> have a
> warning)
> 3. %USER%\.gnucash doesn't exist
>
> A variation of 3. can be that you changed the HOME variable in the gnucash
> environment file or you have set GNC_DOT_DIR to point to another directory.
>
> In those cases the migration will never happen and the user should do this
> manually.
>
> Geert
>
>
>
___
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] Saved Report Configurations Missing After Upgrade to v3

[Thomas Forrester]

Thanks Michael,

I created a test report and found a new file in the AppData folder for
GnuCash called saved-reports-2.8 which I find odd since this is v3.
Nevertheless the file is new and, looking at it in a text editor, it
contains the definition for the test report I just created.  I had to do a
search of my entire hard drive, but found a file similarly called
saved-reports-2.4.  I backed up the 2.8 version and just copied the 2.4
versions into the new folder and the reports automagically reappeared.

I appreciate your good suggestions.

Tom



On Wed, Jun 6, 2018 at 11:28 AM Michael  wrote:

> Haven't tried 3.1 on windows.  What I did to find the new folder on linux
> was to save a report config and search for the file which was
> saved_reports2.8 or something like that.  The old reports were still where
> 2.6.xx put them.  Moved them to the new location and renamed them to the
> 2.8 file name and the old reports worked.  Don't know if any of that helps
> in windows, but it's not as simple as I thought it would be.  Mike
>
> On Wed, Jun 6, 2018 at 8:37 AM, Thomas Forrester 
> wrote:
>
> Sorry, I should have said that I am on Windows.
>
> I can find the folder GnuCash created -  AppData\Roaming\GnuCash, but I
> don't see report definitions there.  Not sure what they are called either,
> but nothing stands out as a report definition.  Perhaps they are stored in
> the data file/database?  But regardless, I have no saved report
> configurations.
>
> I'd really like them back!
>
> Thanks.
>
> On Wed, Jun 6, 2018 at 9:46 AM Michael  wrote:
>
>> I found them to be at /home/user_name/.local/share/gnucash.  This was on
>> archlabs (linux).  Mike
>>
>> On Wed, Jun 6, 2018 at 4:50 AM, Thomas Forrester 
>> wrote:
>>
>> I just now upgraded to 3.1.2 from 2.x. Looking for my saved reports,
>> GnuCash tells me I have none. Not true, at least before the upgrade anyway.
>> I am using MySQL as the database, and I did read that there have been
>> changes to the default data storage locations. Not sure that's relevant
>> when using MySQL since it's a database not a file, but I also do not know
>> if the upgrade somehow tried to relocate stuff to the OS-appropriate
>> storage location? Anyone else lose their reports and get them back? 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 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] Where is the theme selection in 3.x?

[Thomas Forrester]

On Windows, as I recall, there was a seperate program in the Start menu
under GnuCash for previewing and selecting a visual theme to use with
GnuCash.  I don't see that, and the 3.x visual styles on Windows is not all
that attractive.  Was this feature removed?  If so, why??

Thank you.
___
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] Saved Report Configurations Missing After Upgrade to v3

[Thomas Forrester]

Sorry, I should have said that I am on Windows.

I can find the folder GnuCash created -  AppData\Roaming\GnuCash, but I
don't see report definitions there.  Not sure what they are called either,
but nothing stands out as a report definition.  Perhaps they are stored in
the data file/database?  But regardless, I have no saved report
configurations.

I'd really like them back!

Thanks.

On Wed, Jun 6, 2018 at 9:46 AM Michael  wrote:

> I found them to be at /home/user_name/.local/share/gnucash.  This was on
> archlabs (linux).  Mike
>
> On Wed, Jun 6, 2018 at 4:50 AM, Thomas Forrester 
> wrote:
>
> I just now upgraded to 3.1.2 from 2.x. Looking for my saved reports,
> GnuCash tells me I have none. Not true, at least before the upgrade anyway.
> I am using MySQL as the database, and I did read that there have been
> changes to the default data storage locations. Not sure that's relevant
> when using MySQL since it's a database not a file, but I also do not know
> if the upgrade somehow tried to relocate stuff to the OS-appropriate
> storage location? Anyone else lose their reports and get them back? 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 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] Saved Report Configurations Missing After Upgrade to v3

[Thomas Forrester]

I just now upgraded to 3.1.2 from 2.x.  Looking for my saved reports,
GnuCash tells me I have none.  Not true, at least before the upgrade anyway.

I am using MySQL as the database, and I did read that there have been
changes to the default data storage locations.  Not sure that's relevant
when using MySQL since it's a database not a file, but I also do not know
if the upgrade somehow tried to relocate stuff to the OS-appropriate
storage location?

Anyone else lose their reports and get them back?

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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reports are displayed as HTML text rather than being rendered

[Thomas Levine]

John Ralls writes:
> I'd have to guess that you're not getting webkit properly integrated or =
> that there's something wrong with the webkit build. Start by looking =
> closely at the build output for libgncmodule-html.

Thank you for the tip

It appears that all of the interested Nix users have switched from
GNUCash to Ledger (or, in my case, from Nix to OpenBSD), so I don't
think anyone will get to it very soon, but I have noted your suggestion
in the issue tracker.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing OFX fails with GnuCash 3.0?

[Thomas E Moughan]

Thanks, David. I can work around it.

Is there a link where one can see current open bugs for GnuCash?


On Mon, Apr 9, 2018, 2:56 PM David Carlson <david.carlson@gmail.com>
wrote:

> Yes, that is a feature that is in the list of known bugs, so if you need
> that, do not upgrade.
>
> David C
>
> On Mon, Apr 9, 2018, 1:16 PM Thomas E Moughan <moug...@gmail.com> wrote:
>
>> Haven't see this reported, but when I upgraded from 2.6 to 3.0 on my
>> Windows 10 device, I can't import OFX files from my Credit Union.
>>
>> The normal dialog box appears that would shows matches, but is completely
>> blank except for the column headers. I did a Check and Repair all
>> transactions, deleted all the records on the Import Map Editor, and
>> removed
>> the Account Code entries on these bank accounts.. nothing helped.
>>
>> Any ideas?
>> Thanks!
>> Tom Moughan
>> ___
>> 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] Importing OFX fails with GnuCash 3.0?

[Thomas E Moughan]

Haven't see this reported, but when I upgraded from 2.6 to 3.0 on my
Windows 10 device, I can't import OFX files from my Credit Union.

The normal dialog box appears that would shows matches, but is completely
blank except for the column headers. I did a Check and Repair all
transactions, deleted all the records on the Import Map Editor, and removed
the Account Code entries on these bank accounts.. nothing helped.

Any ideas?
Thanks!
Tom Moughan
___
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.