Re: [GNC] How to handle the renaming of stocks

2024-10-12 Thread Megan Tilley
Well, I do not know how I did it, but I think it was creating a new account. I know that when I started this thread yesterday, I was unable to add the number of shares, but after reading both David's and Richard's responses, I went back into GC, and lo and behold, I was able to add the shares to th

Re: [GNC] ANNOUNCE: GnuCash 5.9 Released

2024-10-12 Thread Adrien Monteleone
Joseph, Those are the direct download links in the e-mail, which eventually appear on the website. They usually are already there by the time this announcement goes out, but occasionally, like this instance, the update of those links don't go through properly. Regards, Adrien On 9/30/24 1:2

Re: [GNC] Database backend for gnucash?

2024-10-12 Thread Tommy Trussell
On Sat, Oct 12, 2024 at 9:46 AM Gere Kiss Zsolt wrote: > *Since version 2.4 GnuCash supports SQL via the DBI backend. That again > > supports PostgreSQL, MySQL and SQLite3 databases. This page contains > > details about the SQL backend of GnuCash.* > > This, like many other documents and applicat

Re: [GNC] What files in my in my business folder need to be backed up?

2024-10-12 Thread Jim DeLaHunt
Dan: On 2024-10-12 09:49, Dan a1TNC wrote: What files in my in my business folder need to be backed up? I'm running my Gnu Cash on a windows machine which have to be stored on the local drive. Backing up the needed files in case of computer failure is always a good practice. I have been learni

Re: [GNC] Database backend for gnucash?

2024-10-12 Thread Bruce Griffis
Chapter 12 of the book "GnuCash 2.4 Small Business Accounting" section on Application Integration and Other Advanced Topics SQLite discusses OpenOffice Base, SQLite3 and ODBC drivers. It also goes a little bit into reporting using MS Excel with SQLite3 ODBC drivers.I haven't messed around with

Re: [GNC] Database backend for gnucash?

2024-10-12 Thread Ross Reedstrom
Derek has the right package names, for ubuntu BTW: I just installed libdbd-sqlite3 and libdbd-pgsql and both options now appear in the drop down for "Save As ...". I went ahead and set up an account and DB in my local postgresql server, and it "just worked" to save my existing set of accounts into

Re: [GNC] Database backend for gnucash?

2024-10-12 Thread sunfish62--- via gnucash-user
Indeed, there does appear to be a (large) gap in terms of instruction regarding the database back ends. Having been around for a long time (back to 2006 or so), I remember the implementation. There has been a lot of instruction on this topic in the lists over the years, and I seem to recall so

[GNC] Error getting stock quotes

2024-10-12 Thread Fred Tydeman
On Fedora 40 Linux, with GnuCash 5.8, I am running gnucash-cli --log gnc.price-quotes=debug --quotes get /lindata/GnuCash/pers/pers.gnucash I get in the trace file: * 16:36:08 ERROR gtk_tree_model_filter_convert_iter_to_child_iter: assertion 'valid == TRUE' failed * 16:51:57 ERROR [gnc_prices_di

[GNC] What files in my in my business folder need to be backed up?

2024-10-12 Thread Dan a1TNC
What files in my in my business folder need to be backed up? I'm running my Gnu Cash on a windows machine which have to be stored on the local drive. Backing up the needed files in case of computer failure is always a good practice. I have been learning how to use GnuC and found the files there a

Re: [GNC] How to handle the renaming of stocks

2024-10-12 Thread R Losey
Note that the account name (under the brokerage account) is a separate name from the securities listing, but as you noted, the account has a link to the stock. I tend to give the account name something that ties it to the account; for example, if Harry & Sally each have a 401K with ASX stock, I mi

Re: [GNC] How to handle the renaming of stocks

2024-10-12 Thread Ken Farley
I've dealt with this many times in the past, for example a mutual fund is renamed. Updating to the new name and symbol was done using Security Editor. I just checked for a random stock, and I can change the Full Name, Symbol/abbreviation, Display symbol, etc. Changing these updates any accoun

Re: [GNC] Database backend for gnucash?

2024-10-12 Thread Gere Kiss Zsolt
Hi Richard and all, Thank you for your prompt response. You and Derek were correct; it was sufficient to install some additional packages to support the database backend. Specifically: libdbd-mysql for mysql, libdbd-sqlite3 for sqlite and a similar one for postgres. I installed *libdbd-mysql* and

Re: [GNC] How to handle the renaming of stocks

2024-10-12 Thread sunfish62--- via gnucash-user
I thought you could just change the name in the stock editor and also change the ticker symbol. At least, I've done that before, I think. Can't you? I'll note that if you change the identity of the asset, the entire history will use the new nomenclature. Technically, you would be better creatin