flywire,
You're crossing up threads here. Jim specifically needs to create
Security entries in his GnuCash file (and has stated this on several
occasions) so that he can add transactions for those securities later.
Your advice regarding adding commodity transactions using csv import
tools is
Geoff's suggestion (to use an external automation tool) would best be
placed on the Using Gnucash page
(https://wiki.gnucash.org/wiki/Using_GnuCash) that Adrien suggested.
Flywire suggested Piecash, which is already listed on the Published
tools page.
On 8/16/2022 12:05 AM, Frank H.
Jim,
As you continue down this project, consider how you want to handle
various aspects of accounting for stocks and mutual funds--particularly,
how you want to manage tax-related transactions, such as dividend
income, capital gains income, etc. With that many commodities, you will
want to
Message: 1
Date: Sun, 14 Aug 2022 19:19:44 -0700
From: Jim DeLaHunt
To: gnucash-user@gnucash.org
Subject: Re: [GNC] How to bulk import about 130 Securities entries?
Message-ID: <137f3e3b-148f-feb2-9950-d7fcb32f6...@jdlh.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Kalpesh:
Thank
Obviously it wasn't clear that the post copied below identifies the
keystroke operations from opening GnuCash through the Security Editor with
*** as user input. The Import accounts was an aside comment. (Thanks David
for start the account tree comments.) Interestingly New security is one of
the
Thanks for that tip!
As also mentioned in the Github comments (from user 'talliberman') of that
#230 pull request, for Windows installation, I just copied the updated
alphavantage.pm to overwrite the one the perl CurrencyRates folder and Get
Quotes is now updating currencies again.
For
Hi,
Am 16.08.22 um 13:03 schrieb flywire:
btw A lot (the majority?) ofhttps://wiki.gnucash.org/wiki/Published_tools
are so old they won't work.
as it is a wiki you can just update it.
The page would probably also deserve more links from other pages so that
it is easier found.
Regards
To what Geoff wrote:
The problem is not how to back up you gnucash data. The problem is how
to back up ALL of your user data. There are two fundamentally different
approaches, incremental backup and total as of some date backup. The
usual way to decide is the volume of data to be backed up.
Hi, David,
Please see my last posting. On MacOS Catalina, the results appear correct
on the Transaction Report, but not on Big Sur.
-P.
On Tue, Aug 16, 2022 at 6:24 PM David Cousens
wrote:
> Peter,
>
> I have done the same thing you did with a brand new account setup and a
> single
>
Nope, PEBKAC.
Both reports are correct and the same. It's just that in the BigSur one you
turned off both of the sorting options so that only the transfer to/from
account is visible and then misread the report to mean that that was the
account being credited or debited.
Regards,
John Ralls
I think at last I see what you all are saying.
When I have not displayed account totals, the only account shown on a debit
or credit line is the *counterpart* of the current leg of the transaction;
so the line in the last of my four attachments that says "Checking Account"
and lists $100 as a
On 2022-08-16 15:23, David Cousens wrote:
> It may help if you can list the options you have selected in each tab of the
> Report Options dialogue to see if we can define the conditions that are
> producing your result.
Not just those, but also Edit » Preferences » Accounts » Reverse
Balanced
Peter,
I think the problem stems from your choice of report options.
Namely, by default, 'Account Name' under the Display tab is *not*
selected, while the 'other account' is.
This is because by default the Sort options are:
Primary: account
Secondary: register order
So by default, the
As xml is text, and xml storage is used in my gnucash, one might add securities
by running the *.gnucash through gunzip, add in the text, and run it back
through gzip, unless there is a nasty checksum in there somewhere? Keep a copy
of the original!
I pulled this from my file using shell
On 2022-08-16 19:54, john wrote:
OTOH I'm pretty sure that gnc_commodity is fully exposed to the Python bindings
so you should
be able to write a python script using them to do the same thing without
voiding your warranty
or needing to unzip the file or, for that matter, caring which backend
> running the *.gnucash through gunzip, add in the text, and run it back
through gzip
As a connoisseur of bad ideas for adding data to GnuCash myself, I have to
point out that one should use a programming language that has a library
with support for the structured data format that one wants to
Sorry, while I did send screenshots on 8/2, my reply on 8/3 contains the
annotated versions.
Regards,
Adrien
On 8/16/22 8:25 PM, Adrien Monteleone wrote:
I sent a reply on 8/2 with annotated screenshots showing the issue using
default options save for the account selection.
Glenn, check the wiki with respect to the GTKInspector which might be
able to help you find the proper id/class/object to target.
From the Inspector you can also make changes in real time to experiment.
I'm pretty sure that GnuCash doesn't expose this element to styling, but
customizing the
Indeed, my apologies David. I got lost in the thread, which it seems has
now broken again (2 new messages I see are threaded separately as a new
topic) and one reply from Chris Good concerning OFX import having the
auto-creation option somehow ended up in a thread "Due Invoices Reminder
form"!
Re:
>> 5.Back ups - I have read a lot about the back ups but still unsure
>> what to do. Any suggestions would be appreciated.
>
> The wiki has plenty of info about file and configuration locations and
> making backups.
>
> https://wiki.gnucash.org/wiki/FAQ#Questions_about_Backups
>
> Backup
Peter,
You are reading the report incorrectly.
I sent a reply on 8/2 with annotated screenshots showing the issue using
default options save for the account selection.
John replied this afternoon saying the same thing using significantly
less words than I did on 8/2.
The reports are all
Chris:
On 2022-08-16 02:36, Chris Good wrote:
…There is code in the ofx import to handle creating securities which
is done before an investment transaction if the security (commodity)
does not exist and Preference, Import, "Automatically create new
commodities" is ticked.
I have never used it
Please remember to copy the list on all replies. Reply-all (often a double
arrow pointing left) does it. Some mail programs also have a reply-list button
or menu item.
We generally mean "the book" to refer to a single GnuCash file and its
accounts. That comes from the name an internal data
It has been some time since I dealt with the topic, but I vaguely seem
to recall that someone reported that the Inspector can run under
Windows, though I didn't think that possible at first. Of course, I
could be remembering wrong, and I don't have an installation on that OS
to test it out.
On 8/16/22 1:33 PM, dsamo...@shaw.ca wrote:
I am new to Gnucash and have a few questions regarding saving data. I use
Windows 10 and Gnucash Version: 4.11 Build ID: 4.11+(2022-06-25)
1. I would like to save everything in one folder named Gnucash. I
think I will use the xml format.
Thanks Geoff, good to know!
Regards,
Adrien
On 8/16/22 8:17 PM, Geoff wrote:
Both Microsoft Windows 10 & 11 have a comprehensive automated file based
backup and restore utility built in. Read this article for an overview:
> On Aug 16, 2022, at 2:11 PM, Robert Simmons wrote:
>
>> running the *.gnucash through gunzip, add in the text, and run it back
> through gzip
>
> As a connoisseur of bad ideas for adding data to GnuCash myself, I have to
> point out that one should use a programming language that has a
Hi,
In on Windows and unfortunately there are no Windows details for GTK
Inspector on: https://wiki.gnucash.org/wiki/GTK3#Using_the_GTK_Inspector so
I'm not sure if it's even available on Windows.
I did add the 'environment.local' file to 'C:\Program Files
(x86)\gnucash\etc' per the
Actually, it was clear to me. Jim's point was that if you do these steps 130
times in a row, your brain will explode. Certainly it would be nice to be able
to import them.
On Aug 16, 2022, 14:05, at 14:05, flywire wrote:
>Obviously it wasn't clear that the post copied below identifies the
Hi,
Does anyone know how to change the scrollbar and scrollbar button color in
gtk-3.0.css?
I have tried:
scrollbar slider {
color: blue;
}
and...
scrollbar button {
color: blue;
}
Both have no effect. I didn't find anything in the mailing list archives
and the above I got from
Adrien,
It has been complicated, I agree. However, this thread originated with
https://lists.gnucash.org/pipermail/gnucash-user/2022-August/102395.html
written by Jim. Flywire has added a number of good comments related
generally to importing investment transactions on the thread, but is
As an experiment, I started a band new Gnucash file for test purposes. I
entered a single transaction. I am attaching a view of the register, a
Transaction report and a Balance sheet.
You can see that the same thing is happening that happened before:
- Register view shows that the checking
Hi, here is THE ANSWER. It is a Guncash bug.
The previous report was obtained on MacOS 11.6.8 (Big Sur). This gave the
credits and debits mislabeled in the transaction report.
I have access to another mac running 10.16.2 (Catalina). Running the SAME
version of Gnucash (4.11) on the SAME dataset
Hi, David,
On the balance sheet, everything is correct; the sums reflecting the
balances of the various real accounts are correct and in agreement with the
bank statements; in other words, they reconcile. I also demonstrated this
in the very first screen shot I sent when I started the case, the
1. Re: Due Invoices Reminder form (Adrien Monteleone)
I knew the setting had to be somewhere. It is taking more time than I like to
learn all the settings and processes.
On the plus side, as I do so I get an increasing respect for the work and
expertise that is going into GnuCash.
Thank
I am new to Gnucash and have a few questions regarding saving data. I use
Windows 10 and Gnucash Version: 4.11 Build ID: 4.11+(2022-06-25)
1. I would like to save everything in one folder named Gnucash. I
think I will use the xml format. Currently it seems there are files in
three
David,
This thread keeps breaking, but unless I've lost track as a result, I
thought this was flywire's thread from the start. (who also has several
other related threads dealing with specific aspects of the task at hand.)
The goal was to import transactions for, and as a result, mass create
Hello,
I was just testing something out with a new book, and when I went to
save this new book, I was unable to select the storage format for the
new book. I would have imagined that I would be able to tell GnuCash to
use a specific format (like SQLite3) when I save a new book, but this
> On Aug 16, 2022, at 11:56 AM, David T. via gnucash-user
> wrote:
>
> Hello,
>
> I was just testing something out with a new book, and when I went to save
> this new book, I was unable to select the storage format for the new book. I
> would have imagined that I would be able to tell
39 matches
Mail list logo
