Re: [GNC] Using a mysql database?
On 3/12/2019 6:14 PM, Joseph Vernice wrote: Been using MySQL DB for gnu cash for many years, mainly because of security. Never had a problem. Very reliable and fast on my lan server. Not sure how fast over internet. Hi. Can you explain a bit how the MySQL db is more secure than the standard xml, for example? ___ 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 a mysql database?
Been using MySQL DB for gnu cash for many years, mainly because of security. Never had a problem. Very reliable and fast on my lan server. Not sure how fast over internet. On Tue, Mar 12, 2019 at 7:37 PM John Ralls wrote: > > > > On Mar 12, 2019, at 3:39 PM, Jacob Larsen wrote: > > > > Hi > > > > How reliable is my data if I move from an XML file to a mysql database? > I just tried saving my books in a mysql (MariaDB) database, reload from the > database, and then saving back to an XML file. The files are of the same > size, and they have a large chunk that is identical on both sides in my > difftool. But there is also a large chunk that differs, so most likely the > order is shuffled. I started xmldiff on it just to see what it finds, but > that tool has not yet returned. > > > > Does anyone here know if there are any issues with data reliability when > saving data in a mysql database? > > > > Also, do you happen to know a difftool for xml files that runs faster > than xmldiff? I started xmldiff on the 2x50MB (uncompressed) files I have > lying around, and it is still running for the last hour or so. > > > > Jacob, > > The list of open SQL backend bugs is > https://bugs.gnucash.org/buglist.cgi?bug_status=NEW_status=ASSIGNED_status=NEEDINFO_status=REOPENED=Backend%20-%20SQL_id=3199_format=advanced. > AFAICT none affect data integrity. > > 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 > 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] How to customize the columns shown in the "generic import transaction matcher" (when downloading transactions from my bank) ?
> On Mar 12, 2019, at 1:42 PM, a b wrote: > > HI there, > > *Just joined the list (as I found nothing helpful on this on Google and > this list seems to be the most up-to-date place for asking gnucash-related > stuff)*. > > For a while now, I'm using the > > [Actions --> Online Actions --> Get Transactions...] > > feature to get my banking transactions into gnucash. So far so good. > > However, the "generic import transaction matcher"-windows which pops up as > part of this process is not much to my liking: It shows a number of (to me) > irrelevant columns; I'd like it to just always show a) the columns I'm > interested in and b) remember the ideal width per column (as set by me > *once*). How to achieve this? Possible (and if so, how easily > accomplishable)? > That dialog isn't customizable, sorry. 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 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 a mysql database?
> On Mar 12, 2019, at 3:39 PM, Jacob Larsen wrote: > > Hi > > How reliable is my data if I move from an XML file to a mysql database? I > just tried saving my books in a mysql (MariaDB) database, reload from the > database, and then saving back to an XML file. The files are of the same > size, and they have a large chunk that is identical on both sides in my > difftool. But there is also a large chunk that differs, so most likely the > order is shuffled. I started xmldiff on it just to see what it finds, but > that tool has not yet returned. > > Does anyone here know if there are any issues with data reliability when > saving data in a mysql database? > > Also, do you happen to know a difftool for xml files that runs faster than > xmldiff? I started xmldiff on the 2x50MB (uncompressed) files I have lying > around, and it is still running for the last hour or so. > Jacob, The list of open SQL backend bugs is https://bugs.gnucash.org/buglist.cgi?bug_status=NEW_status=ASSIGNED_status=NEEDINFO_status=REOPENED=Backend%20-%20SQL_id=3199_format=advanced. AFAICT none affect data integrity. 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 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] Using a mysql database?
Hi How reliable is my data if I move from an XML file to a mysql database? I just tried saving my books in a mysql (MariaDB) database, reload from the database, and then saving back to an XML file. The files are of the same size, and they have a large chunk that is identical on both sides in my difftool. But there is also a large chunk that differs, so most likely the order is shuffled. I started xmldiff on it just to see what it finds, but that tool has not yet returned. Does anyone here know if there are any issues with data reliability when saving data in a mysql database? Also, do you happen to know a difftool for xml files that runs faster than xmldiff? I started xmldiff on the 2x50MB (uncompressed) files I have lying around, and it is still running for the last hour or so. /Jacob ___ 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] How to customize the columns shown in the "generic import transaction matcher" (when downloading transactions from my bank) ?
HI there, *Just joined the list (as I found nothing helpful on this on Google and this list seems to be the most up-to-date place for asking gnucash-related stuff)*. For a while now, I'm using the [Actions --> Online Actions --> Get Transactions...] feature to get my banking transactions into gnucash. So far so good. However, the "generic import transaction matcher"-windows which pops up as part of this process is not much to my liking: It shows a number of (to me) irrelevant columns; I'd like it to just always show a) the columns I'm interested in and b) remember the ideal width per column (as set by me *once*). How to achieve this? Possible (and if so, how easily accomplishable)? Thanks! (Slippin') Jimmy ___ 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] Account Hierarchy Meesed Up
AAK, When I want to make a massive change to something like my account tree, I make a map of where I want to go first. Often it is just with pencil and paper, but sometime I can print something and mark it up. David Carlson On Tue, Mar 12, 2019 at 12:58 AM Liz wrote: > On Sat, 9 Mar 2019 10:25:07 -0600 (CST) > AAK wrote: > > > I imported a QIF file into Gnucash and started editing the account > > hierarchy. I inadvertently created a mess. I now have a checking > > account berried under the Expenses account, which in turn, is berried > > under the Automobile Expenses category. I can't figure out how to > > reverse this mess. How can I make hidden accounts show up again? Is > > there a way to edit the entire tree structure at once? > > Take a deep breath, and relax. > > Go to the Accounts tab. > Choose an account to move, right click and select Edit Account. > This opens a box. In mine, at the bottom right, is a box with a name > like "parent". > Find where the account should be in the account tree, and move it. > For example, you might put the Cheque account under "Assets". > > Make sure its right, and save. > > If you still get it wrong, you can move things again. > > 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 > 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.
Re: [GNC] OOo Spreadsheet for Canadian Payroll Tax
I found your maillist references from May of 2005 < https://lists.gnucash.org/pipermail/gnucash-user/2005-May/013882.html> but, as you suspect, the links seem to be dead from here too. Hopefully, someone here will be able to help. David Carlson On Tue, Mar 12, 2019 at 12:41 AM Jonathan Fracoeur wrote: > Hi Michael D. Crawford and all. > http://www.payswell.org/ andhttp://payswell.sourceforge.net/ both give > me "server not found". > I assume this is because this conversation in so old. I am here trying to > revive it, because I think I could use those spreadsheets. > If not, s there anyone out there who has created some spreadsheets for > taking info from a report in GNU cash and reporting payroll in Canada? > > ___ > 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.