Re: [GNC] ANNOUNCE: GnuCash 5.9 Released

[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:27 AM, Joseph Keithley wrote:

Not to put to fine a point on it, why then have a central website that
doesn't provide the most current stable relesase?  And, no, I don't read
entire messasges that do little more than list bug fixes just to find more
websites.


___
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 handle the renaming of stocks

[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 creating a new 
security and account (since the commodity is changed), and doing a zero cost 
conversion of shares from the old to the new as of the cutover. It's not very 
difficult, and it's easier to figure things out later. I typically will put a 
note into the transaction to explain what was done ("SLK Sea Link changed to 
KLS Kelsian") for my own sanity. 

⁣David T. ​

On Oct 12, 2024, 7:48 AM, at 7:48 AM, Megan Tilley  
wrote:
>Hi everyone - another Investment question - probably procedural rather
>than
>specifically a GnuCash 'problem'.
>
>I have a number of stocks/shares that have produced dividends for
>many years.
>
>I have entered those stocks into GC as per the manual and from reading
>other threads in this mailing list.
>
>When I set them up:
>#1 - I used Security Editor - to create a new Security, using the name,
>stockcode/ symbol for the ASX, namespace STOCKS, ticked ONLINE QUOTES,
>selected MULTIPLE - ASX.
>
>#2 - I then set up the stock under the Brokerage Account in the
>Investment
>Parent making sure that the Select security/currency was STOCK and the
>security (ASX) code
>
>#3 - I THINK I set up the stock account under the Trading Parent
>
>Now the over-arching company group has decided to change the name of
>the
>stock (specifically from SLK Sea Link to KLS Kelsian on the ASX) in
>2021.
>
>In my other programs, I could just edit the name entry as there is no
>change to the holdings (amount and price remained the same) .
>
>However, I can not seem to get GC to allow me to edit the Security name
>(Security Editor) or the Trading name - which reflects all the
>purchases
>during the "SLK era" which remains relevant to the new "now-KLS era".
>
>Does this mean I have to re-enter all the data for the new KLS rather
>than
>just change a name or field?
>
>
>Thanks!
>
>
>Megan in Sydney
>___
>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 handle the renaming of stocks

[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 the
newer KLS account.

I was not absolutely clear on David's comment on "zero cost conversion of
shares" but logic dictates that the cost is Zero, which is what I have -
once I acquire more shares, the value will show up...

KLS now shows with a number of shares, and the Dividends are also being
recorded against KLS, which is what I needed.

Thanks to David and Richard!


Megan in Sydney


On Sun, 13 Oct 2024 at 03:39, R Losey  wrote:

> 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 might call the
> account under Harry H-ASX, or H401K-ASX, and Sally's account might be S-ASX
> or S401K-ASX.
>
> If the stock is renamed, there are probably a couple of ways to handle it
> -- you could try just renaming the stock in the Security list - it might be
> that the brokerage account will pick up on the rename and point to the new
> name. Alternatively, you could create a new Security entry, and just change
> the brokerage account to point to the new entry.  That way, you'd have all
> of the data under the old name. You'd probably want to turn off price
> updates for the old name, but just leave alone.
>
> Just a few ideas.
>
>
>
>
> On Fri, Oct 11, 2024 at 11:47 PM Megan Tilley 
> wrote:
>
>> Hi everyone - another Investment question - probably procedural rather
>> than
>> specifically a GnuCash 'problem'.
>>
>> I have a number of stocks/shares that have produced dividends for
>> many years.
>>
>> I have entered those stocks into GC as per the manual and from reading
>> other threads in this mailing list.
>>
>> When I set them up:
>> #1 - I used Security Editor - to create a new Security, using the name,
>> stockcode/ symbol for the ASX, namespace STOCKS, ticked ONLINE QUOTES,
>> selected MULTIPLE - ASX.
>>
>> #2 - I then set up the stock under the Brokerage Account in the Investment
>> Parent making sure that the Select security/currency was STOCK and the
>> security (ASX) code
>>
>> #3 - I THINK I set up the stock account under the Trading Parent
>>
>> Now the over-arching company group has decided to change the name of the
>> stock (specifically from SLK Sea Link to KLS Kelsian on the ASX) in 2021.
>>
>> In my other programs, I could just edit the name entry as there is no
>> change to the holdings (amount and price remained the same) .
>>
>> However, I can not seem to get GC to allow me to edit the Security name
>> (Security Editor) or the Trading name - which reflects all the purchases
>> during the "SLK era" which remains relevant to the new "now-KLS era".
>>
>> Does this mean I have to re-enter all the data for the new KLS rather than
>> just change a name or field?
>>
>>
>> Thanks!
>>
>>
>> Megan in Sydney
>> ___
>> 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.
>>
>
>
> --
> _
> Richard Losey
> rlo...@gmail.com
> Micah 6:8
>
___
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] Error getting stock quotes

[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_dialog_get_quotes_clicked()] Price
retrieval failed: Failed to parse result returned by Finance::Quote.
Error message:
(1): expected value
Result:
... followed by a 46,910 character list of stock symbols and data as one
long line

Suggestions on what I should be looking for in that data to find the error?
___
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] Database backend for gnucash?

[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 applications, suggests that GnuCash has
> supported SQL since version 2.4. Given that many users operate on Windows,
> I suspect they may be unaware that there is a version of GnuCash that does
> not include SQL support. This oversight was quite frustrating during my
> search. Therefore, it seems that this is not a case of discrimination, but
> rather an omission in the documentation.
>

TECHNICALLY, the problem is between GnuCash and you.

The GnuCash volunteers create the latest and greatest code, and put it
where you or anyone can download the source code PLUS Windows and Mac
ready-to-run binaries.

I believe the Windows and Mac versions are distributed from GnuCash.org
with the database options compiled in. I use the linux Flatpak version
produced by the same volunteers, and it definitely has the database
features already.

If you download GnuCash source on your linux system and build it yourself
according to the instructions, it can have all the features that you have
selected compiled in, including the database backends. I haven't compiled
in awhile but I believe the database features are included by default.

Many people, however, go through a linux distribution that packages the
operating system plus applications and most distributions "pre-compile" the
binaries for common hardware into packages you can install and update
easily.

FOR SOME REASON the major linux distributions separate out the database
functionality as separate package downloads, AND they mark the packages
"optional." Probably a holdover from the days when folks tried to optimize
every byte of a package because they might be installing onto a system with
limited resources.

SO after reading all of this, you might begin to recognize the challenge of
documenting it. The default situation might be different whether you
install on a Mac, or a system running Fedora, Ubuntu (or Mint or Debian),
DSL, Gnoppix (are those still around?)... etc.

It probably DOES warrant better documentation somewhere... I suggest you
might look in the GnuCash Wiki, and add some more information if you cannot
find it. Then maybe it can get into the documentation that's distributed
with GnuCash.


-
> 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] What files in my in my business folder need to be backed up?

[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 learning how to use GnuC and found the
files there are better than 100 files for 4 days of use. Will the last Text
file and the last "GNUCash Financial Data" file be all I need to copy to a
cloud? Or do I need to copy all of them?


Welcome to GnuCash!  I hope it turns out to be very useful for you.

A good first stop for answering your question is the /GnuCash Tutorial 
and Guide/ , 
section 2.5. *Backing Up and Recovering Data*.


In fact, if you are new to GnuCash and have not yet read all the way 
through the Tutorial and Guide, now might be a good time to.


You might also find the GnuCash wiki article, *Backup* 
, to be useful also. That article 
will refer you to a second, *Configuration Locations* 
, which will also 
help you know where your customisations are stored, so that you can 
include them in your backup.


Once you have read that, if you still have questions, come on back to 
the list and ask another question.


Best regards,
    —Jim DeLaHunt
___
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] Database backend for gnucash?

[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 the option
to save and open from the database appeared - great news!

So I have to revisit my earlier thought regarding the publication of a
binary that supports only one file format. I believe "omission" would be a
more accurate term than "discrimination." However, I could not find any
mention of the need to install additional packages for database backends,
not to mention the specific package names, in any of the resources I
consulted. The SQL  documentation states:

*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 applications, suggests that GnuCash has
supported SQL since version 2.4. Given that many users operate on Windows,
I suspect they may be unaware that there is a version of GnuCash that does
not include SQL support. This oversight was quite frustrating during my
search. Therefore, it seems that this is not a case of discrimination, but
rather an omission in the documentation.

My next step is to find an interface that I can easily integrate with -
ideally, a REST API. I explored the Gnucash Rest
 by loftx, but I was unable to get
it to work. If anyone has experience with something similar, I would
greatly appreciate your insights.

Thank you once again for your assistance.

Best regards,
Zsolt

On Thu, 10 Oct 2024 at 23:44, R Losey  wrote:

> It may be that you merely need to install some other packages to support
> the other options.
>
> It *IS* discrimination that the major distributors "discriminate" (that
> is, "choose") what they do and don't include in their distributions. Most
> people probably use the XML file, which I believe is the default, so they
> just didn't include those other packages. But if you want them, you can get
> them, which seems to me quite fair for those special few who want other
> options.
>
> One could also claim that it is "discrimination" that the Stock Quote
> feature works on Linux, but needs additional items on Mac and Windows to
> work (specifically, Perl distributions).
>
>
> On Thu, Oct 10, 2024 at 1:52 PM Gere Kiss Zsolt 
> wrote:
>
>> Dear all,
>>
>> Thank you for your assistance. I have identified the key issue: it is
>> related to the platform package. On Linux, GnuCash is preinstalled on the
>> major distributions. However, the packages provide a binary that supports
>> only the XML file format. As a result, when saving, there is only one
>> format option available: XML, despite the presence of a selection box.
>> This
>> appears to be the case in Ubuntu, and it seems that this limitation is not
>> widely communicated.
>>
>> I believe this situation could be considered a form of discrimination. If
>> I
>> wish to use a database backend, I will likely need to compile a GnuCash
>> binary myself. While this is not a significant problem for me, it would be
>> beneficial for others if this information were included on the download
>> page or in the documentation.
>>
>> Thank you once again for your support.
>>
>> Best regards,
>> Zsolt
>>
>>
>> ---
>> „We have two lives, and the second begins when we realize we only have
>> one.”
>> -- Confucius
>> ___
>> 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.
>>
>
>
> --
> _
> Richard Losey
> rlo...@gmail.com
> Micah 6:8
>


-- 
Üdvözlettel,

   Zsolt

---
„We have two lives, and the second begins when we realize we only have one.”
-- Confucius
___
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 handle the renaming of stocks

[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 might call the
account under Harry H-ASX, or H401K-ASX, and Sally's account might be S-ASX
or S401K-ASX.

If the stock is renamed, there are probably a couple of ways to handle it
-- you could try just renaming the stock in the Security list - it might be
that the brokerage account will pick up on the rename and point to the new
name. Alternatively, you could create a new Security entry, and just change
the brokerage account to point to the new entry.  That way, you'd have all
of the data under the old name. You'd probably want to turn off price
updates for the old name, but just leave alone.

Just a few ideas.




On Fri, Oct 11, 2024 at 11:47 PM Megan Tilley 
wrote:

> Hi everyone - another Investment question - probably procedural rather than
> specifically a GnuCash 'problem'.
>
> I have a number of stocks/shares that have produced dividends for
> many years.
>
> I have entered those stocks into GC as per the manual and from reading
> other threads in this mailing list.
>
> When I set them up:
> #1 - I used Security Editor - to create a new Security, using the name,
> stockcode/ symbol for the ASX, namespace STOCKS, ticked ONLINE QUOTES,
> selected MULTIPLE - ASX.
>
> #2 - I then set up the stock under the Brokerage Account in the Investment
> Parent making sure that the Select security/currency was STOCK and the
> security (ASX) code
>
> #3 - I THINK I set up the stock account under the Trading Parent
>
> Now the over-arching company group has decided to change the name of the
> stock (specifically from SLK Sea Link to KLS Kelsian on the ASX) in 2021.
>
> In my other programs, I could just edit the name entry as there is no
> change to the holdings (amount and price remained the same) .
>
> However, I can not seem to get GC to allow me to edit the Security name
> (Security Editor) or the Trading name - which reflects all the purchases
> during the "SLK era" which remains relevant to the new "now-KLS era".
>
> Does this mean I have to re-enter all the data for the new KLS rather than
> just change a name or field?
>
>
> Thanks!
>
>
> Megan in Sydney
> ___
> 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.
>


-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
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] Database backend for gnucash?

[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 some discussion about the procedures involved, but I don't 
find them now. I'll note that limitations with some of the Windows versions 
prevented many users from using the database back ends. That, combined with the 
minimal gains that the db back ends provide, has meant that most Windows users 
have stayed with the default xml, I believe.

That said, all the documentation is volunteer-generated, so this is an 
opportunity for you to improve that documentation. 

⁣David T. ​

On Oct 12, 2024, 5:46 PM, at 5:46 PM, Gere Kiss Zsolt  
wrote:
>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 the
>option
>to save and open from the database appeared - great news!
>
>So I have to revisit my earlier thought regarding the publication of a
>binary that supports only one file format. I believe "omission" would
>be a
>more accurate term than "discrimination." However, I could not find any
>mention of the need to install additional packages for database
>backends,
>not to mention the specific package names, in any of the resources I
>consulted. The SQL  documentation
>states:
>
>*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 applications, suggests that GnuCash
>has
>supported SQL since version 2.4. Given that many users operate on
>Windows,
>I suspect they may be unaware that there is a version of GnuCash that
>does
>not include SQL support. This oversight was quite frustrating during my
>search. Therefore, it seems that this is not a case of discrimination,
>but
>rather an omission in the documentation.
>
>My next step is to find an interface that I can easily integrate with -
>ideally, a REST API. I explored the Gnucash Rest
> by loftx, but I was unable to
>get
>it to work. If anyone has experience with something similar, I would
>greatly appreciate your insights.
>
>Thank you once again for your assistance.
>
>Best regards,
>Zsolt
>
>On Thu, 10 Oct 2024 at 23:44, R Losey  wrote:
>
>> It may be that you merely need to install some other packages to
>support
>> the other options.
>>
>> It *IS* discrimination that the major distributors "discriminate"
>(that
>> is, "choose") what they do and don't include in their distributions.
>Most
>> people probably use the XML file, which I believe is the default, so
>they
>> just didn't include those other packages. But if you want them, you
>can get
>> them, which seems to me quite fair for those special few who want
>other
>> options.
>>
>> One could also claim that it is "discrimination" that the Stock Quote
>> feature works on Linux, but needs additional items on Mac and Windows
>to
>> work (specifically, Perl distributions).
>>
>>
>> On Thu, Oct 10, 2024 at 1:52 PM Gere Kiss Zsolt
>
>> wrote:
>>
>>> Dear all,
>>>
>>> Thank you for your assistance. I have identified the key issue: it
>is
>>> related to the platform package. On Linux, GnuCash is preinstalled
>on the
>>> major distributions. However, the packages provide a binary that
>supports
>>> only the XML file format. As a result, when saving, there is only
>one
>>> format option available: XML, despite the presence of a selection
>box.
>>> This
>>> appears to be the case in Ubuntu, and it seems that this limitation
>is not
>>> widely communicated.
>>>
>>> I believe this situation could be considered a form of
>discrimination. If
>>> I
>>> wish to use a database backend, I will likely need to compile a
>GnuCash
>>> binary myself. While this is not a significant problem for me, it
>would be
>>> beneficial for others if this information were included on the
>download
>>> page or in the documentation.
>>>
>>> Thank you once again for your support.
>>>
>>> Best regards,
>>> Zsolt
>>>
>>>
>>>
>---
>>> „We have two lives, and the second begins when we realize we only
>have
>>> one.”
>>> -- Confucius
>>> ___
>>> 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-T

Re: [GNC] Database backend for gnucash?

[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 this section yet, but it looked pretty interesting.


At this point in my GnuCash journey, I'd just be happy to get income, 
expense, liabilities and assets figured out, and maybe stocks.



On 10/12/24 14:08, Ross Reedstrom wrote:

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 that. Didn't
test sqlite3.

Ross

On Sat, Oct 12, 2024 at 12:38 PM sunfish62--- via gnucash-user <
gnucash-user@gnucash.org> wrote:


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 some discussion about the procedures involved,
but I don't find them now. I'll note that limitations with some of the
Windows versions prevented many users from using the database back ends.
That, combined with the minimal gains that the db back ends provide, has
meant that most Windows users have stayed with the default xml, I believe.

That said, all the documentation is volunteer-generated, so this is an
opportunity for you to improve that documentation.

⁣David T. ​

On Oct 12, 2024, 5:46 PM, at 5:46 PM, Gere Kiss Zsolt <
zsolt.gk...@gmail.com> wrote:

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 the
option
to save and open from the database appeared - great news!

So I have to revisit my earlier thought regarding the publication of a
binary that supports only one file format. I believe "omission" would
be a
more accurate term than "discrimination." However, I could not find any
mention of the need to install additional packages for database
backends,
not to mention the specific package names, in any of the resources I
consulted. The SQL  documentation
states:

*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 applications, suggests that GnuCash
has
supported SQL since version 2.4. Given that many users operate on
Windows,
I suspect they may be unaware that there is a version of GnuCash that
does
not include SQL support. This oversight was quite frustrating during my
search. Therefore, it seems that this is not a case of discrimination,
but
rather an omission in the documentation.

My next step is to find an interface that I can easily integrate with -
ideally, a REST API. I explored the Gnucash Rest
 by loftx, but I was unable to
get
it to work. If anyone has experience with something similar, I would
greatly appreciate your insights.

Thank you once again for your assistance.

Best regards,
Zsolt

On Thu, 10 Oct 2024 at 23:44, R Losey  wrote:


It may be that you merely need to install some other packages to

support

the other options.

It *IS* discrimination that the major distributors "discriminate"

(that

is, "choose") what they do and don't include in their distributions.

Most

people probably use the XML file, which I believe is the default, so

they

just didn't include those other packages. But if you want them, you

can get

them, which seems to me quite fair for those special few who want

other

options.

One could also claim that it is "discrimination" that the Stock Quote
feature works on Linux, but needs additional items on Mac and Windows

to

work (specifically, Perl distributions).


On Thu, Oct 10, 2024 at 1:52 PM Gere Kiss Zsolt



wrote:


Dear all,

Thank you for your assistance. I have identified the key issue: it

is

related to the platform package. On Linux, GnuCash is preinstalled

on the

major distributions. However, the packages provide a binary that

supports

only the XML file format. As a result, when saving, there is only

one

format option available: XML, despite the presence of a selection

box.

This
appears to be the case in Ubuntu, and it seems that this limitation

is not

widely communicated.

I believe this situation could be considered a form of

discrimination. If

I
wish to use a database backend, I will likely need to compil

Re: [GNC] Database backend for gnucash?

[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 that. Didn't
test sqlite3.

Ross

On Sat, Oct 12, 2024 at 12:38 PM sunfish62--- via gnucash-user <
gnucash-user@gnucash.org> wrote:

> 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 some discussion about the procedures involved,
> but I don't find them now. I'll note that limitations with some of the
> Windows versions prevented many users from using the database back ends.
> That, combined with the minimal gains that the db back ends provide, has
> meant that most Windows users have stayed with the default xml, I believe.
>
> That said, all the documentation is volunteer-generated, so this is an
> opportunity for you to improve that documentation.
>
> ⁣David T. ​
>
> On Oct 12, 2024, 5:46 PM, at 5:46 PM, Gere Kiss Zsolt <
> zsolt.gk...@gmail.com> wrote:
> >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 the
> >option
> >to save and open from the database appeared - great news!
> >
> >So I have to revisit my earlier thought regarding the publication of a
> >binary that supports only one file format. I believe "omission" would
> >be a
> >more accurate term than "discrimination." However, I could not find any
> >mention of the need to install additional packages for database
> >backends,
> >not to mention the specific package names, in any of the resources I
> >consulted. The SQL  documentation
> >states:
> >
> >*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 applications, suggests that GnuCash
> >has
> >supported SQL since version 2.4. Given that many users operate on
> >Windows,
> >I suspect they may be unaware that there is a version of GnuCash that
> >does
> >not include SQL support. This oversight was quite frustrating during my
> >search. Therefore, it seems that this is not a case of discrimination,
> >but
> >rather an omission in the documentation.
> >
> >My next step is to find an interface that I can easily integrate with -
> >ideally, a REST API. I explored the Gnucash Rest
> > by loftx, but I was unable to
> >get
> >it to work. If anyone has experience with something similar, I would
> >greatly appreciate your insights.
> >
> >Thank you once again for your assistance.
> >
> >Best regards,
> >Zsolt
> >
> >On Thu, 10 Oct 2024 at 23:44, R Losey  wrote:
> >
> >> It may be that you merely need to install some other packages to
> >support
> >> the other options.
> >>
> >> It *IS* discrimination that the major distributors "discriminate"
> >(that
> >> is, "choose") what they do and don't include in their distributions.
> >Most
> >> people probably use the XML file, which I believe is the default, so
> >they
> >> just didn't include those other packages. But if you want them, you
> >can get
> >> them, which seems to me quite fair for those special few who want
> >other
> >> options.
> >>
> >> One could also claim that it is "discrimination" that the Stock Quote
> >> feature works on Linux, but needs additional items on Mac and Windows
> >to
> >> work (specifically, Perl distributions).
> >>
> >>
> >> On Thu, Oct 10, 2024 at 1:52 PM Gere Kiss Zsolt
> >
> >> wrote:
> >>
> >>> Dear all,
> >>>
> >>> Thank you for your assistance. I have identified the key issue: it
> >is
> >>> related to the platform package. On Linux, GnuCash is preinstalled
> >on the
> >>> major distributions. However, the packages provide a binary that
> >supports
> >>> only the XML file format. As a result, when saving, there is only
> >one
> >>> format option available: XML, despite the presence of a selection
> >box.
> >>> This
> >>> appears to be the case in Ubuntu, and it seems that this limitation
> >is not
> >>> widely communicated.
> >>>
> >>> I believe this situation could be considered a form of
> >discrimination. If
> >>> I
> >>> wish to use a database backend, I will likely need to compile a
> >GnuCash
> >>> binary myself. While this is not a significant problem for me, it
> >would be
> >>> beneficial for others if this information were included on the
>

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

[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 
accounts that reference the stock, as far as the Security/currency of 
the account is concerned.


The only other thing I had to do was rename each account uses the 
pertinent security. Not necessary for things to remain functional, but I 
like the name of the account to match the security.

___
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] What files in my in my business folder need to be backed up?

[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 are better than 100 files for 4 days of use. Will the last Text
file and the last "GNUCash Financial Data" file be all I need to copy to a
cloud? Or do I need to copy all of them?

 

Thx in advance

 



-- 
This email has been checked for viruses by AVG antivirus software.
www.avg.com
___
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.