Re: [GNC] XML or database?
Database vs XML I've experimented with using a database and actually prefer XML. Since GnuCash operates on its datastore in memory, it loads the entire database at launch, which takes as long (or longer) as sucking in the XML. And I actually find 'revert' a handy feature when I screw something up. You can just drop back and start over afresh using XML, but your mistakes have been written immediately to the database. Also, there have been some rare occasions when I've found it expedient to edit the uncompressed XML. There are certainly things that can be accomplished using a database that would be awkward or impossible with XML, but I haven't so far found that necessary. Data accretion I converted from Microsoft Office 12 years ago. I used it both for personal and business accounting. It had the best feature I've seen for purging old data, because it was smart enough to preserve investment history, and you could even keep track of expenditures such as home improvements for as long as necessary, while removing other data that was truly stale. Using GnuCash, I keep separate books for business and personal, but 12 years on I have not found file size to be problematic. The developers have done a great job of streamlining performance. Awhile back, the HDD on my desktop died and I replaced it with an SSD. That provided a performance kick, but I was okay with what I was experiencing with the HDD. I mostly handle accounting on a desktop, but do transition to a laptop when travelling. It's a fairly straightforward matter to port all the necessary files and configuration data. -Original Message- From: gnucash-user On Behalf Of R Losey Sent: Monday, October 31, 2022 9:14 AM To: Gnucash Users Subject: [GNC] XML or database? This question may have been asked before, but I'm relatively new to this mailing list. Is there any advantage to switching to the database format? Would it use less space? My ".gnucash" file is about 1.5M currently, and opening it takes mere seconds. Long ago in my Quicken days, I would generally keep about 3 years of data and then "archive" transactions older than that... I don't know if GnuCash has (or needs) any similar feature. -- _ 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. ___ 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] XML or database?
I initially configured GnuCash for periodic backups, but found the disruption annoying. You are free to save the file at will, and, yes, if the file is "dirty" you'll get a reminder when you exit the program. -Original Message- From: gnucash-user On Behalf Of R Losey Sent: Monday, October 31, 2022 11:15 AM To: Derek Atkins Cc: Gnucash Users Subject: Re: [GNC] XML or database? That helps - thanks! I assume that if I attempt to quit GnuCash with unsaved data, it will remind me to save... but the current indications of unsaved data files have been sufficient to remind me to save the data. If you have data going back 15 years, I'm just getting started with 6 years (heh). On Mon, Oct 31, 2022 at 8:31 AM Derek Atkins wrote: > Hi, > > On Mon, October 31, 2022 9:14 am, R Losey wrote: > > This question may have been asked before, but I'm relatively new to > > this mailing list. > > > > Is there any advantage to switching to the database format? Would it > > use less space? My ".gnucash" file is about 1.5M currently, and > > opening it takes mere seconds. > > The main advantage of using the SQL backend is that all changes are > "saved" immediately, so you wont lose data because you "forgot to save" > > But no, the DB is most definitely NOT smaller; the XML file is > compressed on save, so that 1.5MB would probably be more like 10-20MB of DB. > > > Long ago in my Quicken days, I would generally keep about 3 years of > data > > and then "archive" transactions older than that... I don't know if > GnuCash > > has (or needs) any similar feature. > > For what it's worth, I have data going back to like 2007 in my file. > GnuCash does not really have an "archive" function (although there > have been 3rd party tools that do that. > > Hope that helps! > > _ > > Richard Losey > > rlo...@gmail.com > > > 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 > > -- _ 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. ___ 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] XML or database?
Besides the reminder on exit, if a file has unsaved data, there is an asterisk to the left of the filename in the titlebar and the "Save" icon is *NOT* greyed out. On Tue, Nov 1, 2022 at 2:01 AM John Layman wrote: > I initially configured GnuCash for periodic backups, but found the > disruption annoying. You are free to save the file at will, and, yes, if > the file is "dirty" you'll get a reminder when you exit the program. > > -Original Message- > From: gnucash-user > On Behalf Of R Losey > Sent: Monday, October 31, 2022 11:15 AM > To: Derek Atkins > Cc: Gnucash Users > Subject: Re: [GNC] XML or database? > > That helps - thanks! > > I assume that if I attempt to quit GnuCash with unsaved data, it will > remind > me to save... but the current indications of unsaved data files have been > sufficient to remind me to save the data. > > If you have data going back 15 years, I'm just getting started with 6 years > (heh). > > > > On Mon, Oct 31, 2022 at 8:31 AM Derek Atkins wrote: > > > Hi, > > > > On Mon, October 31, 2022 9:14 am, R Losey wrote: > > > This question may have been asked before, but I'm relatively new to > > > this mailing list. > > > > > > Is there any advantage to switching to the database format? Would it > > > use less space? My ".gnucash" file is about 1.5M currently, and > > > opening it takes mere seconds. > > > > The main advantage of using the SQL backend is that all changes are > > "saved" immediately, so you wont lose data because you "forgot to save" > > > > But no, the DB is most definitely NOT smaller; the XML file is > > compressed on save, so that 1.5MB would probably be more like 10-20MB of > DB. > > > > > Long ago in my Quicken days, I would generally keep about 3 years of > > data > > > and then "archive" transactions older than that... I don't know if > > GnuCash > > > has (or needs) any similar feature. > > > > For what it's worth, I have data going back to like 2007 in my file. > > GnuCash does not really have an "archive" function (although there > > have been 3rd party tools that do that. > > > > Hope that helps! > > > > _ > > > Richard Losey > > > rlo...@gmail.com > > > > > 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 > > > > > > -- > _ > 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. > > ___ > 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. > -- 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Invoice Template
Hi Relatively new to Gnu cash and very new in terms of running business accounts through it. I am struggling to get a suitable invoice template in the format that I require. Ideally I would like to be able to produce my own template incorporating a logo - specific footers on an A4 format and ideally a watermark image across the entire background. I have tried reformatting the various standard Invoice Reports but cannot get the flexibility I want. Alternatively is there a report to generate all invoice information into csv/excel or other suitable format to work into a Word MailMerge? Thanks Ian ___ 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] Gnu Cash / UNrealised Losses in Trial balance
HI to all. I am getting an amount as Unrealized losses in my trial balance, and this is popping up while enot being related to a given registry/account. It seems to be generated by the system, and by playing around, I am convinced it is related to Difference of Exchange. Can someone explain to me what this is, and how to get rid of it? Thank you, Eid E. Eid ___ 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] Gnu Cash / UNrealised Losses in Trial balance
Hi, On Tue, November 1, 2022 1:53 pm, Eid Eid wrote: > HI to all. > I am getting an amount as Unrealized losses in my trial balance, and this > is popping up while enot being related to a given registry/account. It > seems to be generated by the system, and by playing around, I am convinced > it is related to Difference of Exchange. > Can someone explain to me what this is, and how to get rid of it? > > Thank you, You buy 10 widgets at $10 each. You sell 5 widgets at $15 each. You need to account for that (realized) gain. Now the widget price increases to $20 each. That would be unrealized gain.. > > Eid E. Eid > 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 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Looking for stock prices over the web
What is your question? On Tue, Nov 1, 2022 at 4:16 PM James Baxter via gnucash-user < gnucash-user@gnucash.org> wrote: > As I go to see what the prices are over the web. As I was told by Geoff > to get screen shots. I tried to get a screen shot of the one, Sorry. there > was a problem. As it did not take one. As I am hopping this one works.It > shows the last one from 10/14/2022. (I think that is right) I open up the > items/Stock on two of them.So It wont do it by itself. > thanksJames baxterkangaro...@yahoo.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. > -- 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Invoice Template
Yes, any report can be copy/pasted or exported/imported into a spreadsheet app for further manipulation. However, most if not all of what you've described is achievable from within GnuCash. Explore and play with custom sytlesheets for reports. Particularly, play with Edit > Style Sheets > CSS and work from there. (be sure to assign the 'custom CSS stylesheet' to your invoice, I think that is the Options > General, tab. You'll need to delve into and learn CSS as all GnuCash reports are essentially HTML tables with some styling. You can't style everything, but you can make lots of progress and customizations. Then once you have it really close, but not quite just right, then copy/paste or export/import to a spreadsheet and finish the rest. Then if possible, file a RFE (Request For Enhancement) at bugs.gnucash.com so you can manage to style the rest directly in the future from within GnuCash. (describe well, what can only be done in a spreadsheet that you think *should* be accessible from within GnuCash.) You can certainly import invoices from csv/spreadsheet, but I'm not certain about export. But as noted above, copy/paste or save/open-import should work fine in most cases. Regards, Adrien On 11/1/22 12:28 PM, Ian Pincher wrote: Hi Relatively new to Gnu cash and very new in terms of running business accounts through it. I am struggling to get a suitable invoice template in the format that I require. Ideally I would like to be able to produce my own template incorporating a logo - specific footers on an A4 format and ideally a watermark image across the entire background. I have tried reformatting the various standard Invoice Reports but cannot get the flexibility I want. Alternatively is there a report to generate all invoice information into csv/excel or other suitable format to work into a Word MailMerge? ___ 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.
