Re: [GNC] Changing multiple transactions

2021-01-31 Thread Jean L
Note: as a dev I have (and probably many before me) tried to look at what it would take allow selecting multiple transactions at the same time and then do an operation. Sadly, there's no quick fix to GC that could make this happen, it's a large re-write apparently. One dev looked (is looking?)

Re: [GNC] mysql setup in linux (debian)

2021-01-31 Thread Cam Ellison
On 2021-01-31 20:05, David Cousens wrote: I don't have any experience of MySQL with GnuCash but I would try and look at logs for the MySQL server in /var/log/mysql. If the problem is with the server rather than GnuCash itself, that may indicate it. Also check the Gnucash,trace file (

Re: [GNC] mysql setup in linux (debian)

2021-01-31 Thread David Cousens
I don't have any experience of MySQL with GnuCash but I would try and look at logs for the MySQL server in /var/log/mysql. If the problem is with the server rather than GnuCash itself, that may indicate it. Also check the Gnucash,trace file ( https://wiki.gnucash.org/wiki/Tracefile) which should

Re: [GNC] mysql setup in linux (debian)

2021-01-31 Thread David Carlson
That might be a permissions issue. Recently I have had some problems when GnuCash doesn't know how to gain access if it doesn't already have it in Linux. In my case it is a Samba problem. On Sun, Jan 31, 2021, 7:45 PM gnu Gord wrote: > Thank you very much for the information. It seems the

Re: [GNC] mysql setup in linux (debian)

2021-01-31 Thread gnu Gord
Thank you very much for the information. It seems the problem was that I had not installed the libdbd-mysql package. I did have the libdbi but not the mysql package. I also did not have the libdbd packages for pgsql or sqlite3 ... but I do now! and they now show up in gnucash as options for the

Re: [GNC] mysql setup in linux (debian)

2021-01-31 Thread David Cousens
It will depend on whether you have installed for the distributions repositories using their software manager or whether you have installed a flatpak version either from the repository or the GnuCash website. The flatpak versions often require specific permissions granted so they can access the

Re: [GNC] gnucash-user Digest, Vol 214, Issue 66

2021-01-31 Thread John Angelico
Quoting: From: gnu Gord To: gnucash-user@gnucash.org Cc: Bcc: Date: Sun, 31 Jan 2021 14:56:03 -0800 Subject: [GNC] mysql setup in linux (debian) Having some problems with mysql setup for linux. I got the Windows version to work but don't seem to have the option to "save as" mysql in my linux

Re: [GNC] mysql setup in linux (debian)

2021-01-31 Thread gnu Gord
Thanks for the reply. When I go to 'save as' the Data Format drop-down only has XML as an option, unlike my Windows version that has Mysql and others. I installed the Linux version using apt so I did not build it myself. Perhaps the official package was built without this support? If so, would I

Re: [GNC] Changing multiple transactions

2021-01-31 Thread Jeff Rizzo
On 1/31/21 2:30 PM, Stephen M. Butler wrote: On 1/31/21 12:26 PM, Jeff Rizzo wrote: On 1/31/21 12:05 PM, Stephen M. Butler wrote: PPS  Backups are mandatory. Yeah, they will be, once I get enough useful data in there that I don't keep starting over from scratch.  Since I sent out the

Re: [GNC] Changing multiple transactions

2021-01-31 Thread Jeff Rizzo
Using what you wrote here as a clue, I went looking for some older posts by you, and I think I found the actual helpful piece in it:  it wasn't clear to me before that the account field WAS actually paste-able;  I thought I had tried and failed, but I must have done something else wrong. This

Re: [GNC] mysql setup in linux (debian)

2021-01-31 Thread David Cousens
If you select File-Saves As from the menu, you should see a drop down box labelled Data Format at the top of the dialog window. "xml" is selected by default.Click on the down arrow and select the format you wish to use. GnuCash is normally built by default with the support for the various

Re: [GNC] mysql setup in linux (debian)

2021-01-31 Thread Michael via gnucash-user
I believe the first thing to check is libdbi, is it installed? Mike On Sun, 2021-01-31 at 14:56 -0800, gnu Gord wrote: > Having some problems with mysql setup for linux. > > I got the Windows version to work but don't seem to have the option > to > "save as" mysql in my linux version. > Are

Re: [GNC] Changing multiple transactions

2021-01-31 Thread D via gnucash-user
I'd ask how many transactions you've got to edit-- because over the years, I've had many opportunities to bulk edit transactions (new ideas on account setups, realizations that what I'd been doing didn't meet my needs or goals, etc.). In every case, it's been quite easy to change even large

[GNC] mysql setup in linux (debian)

2021-01-31 Thread gnu Gord
Having some problems with mysql setup for linux. I got the Windows version to work but don't seem to have the option to "save as" mysql in my linux version. Are there some instructions somewhere that talk about using/setting up mysql in linux? ___

Re: [GNC] Multi-column balance sheet report

2021-01-31 Thread Stephen M. Butler
On the main GnC menu, pick Reports. Then pick Experimental.  Look for the ones that have "(Multicolumn)" in their name. On 1/31/21 1:04 PM, Marcus Winston wrote: Hi all, I just found this thread on the web:

Re: [GNC] Changing multiple transactions

2021-01-31 Thread Stephen M. Butler
On 1/31/21 12:26 PM, Jeff Rizzo wrote: On 1/31/21 12:05 PM, Stephen M. Butler wrote: PS  If using a database back-end and you have experience as a database admin or programmer then use the database tools to effect the changes.  Again, make that backup first and loop around as needed until

[GNC] Multi-column balance sheet report

2021-01-31 Thread Marcus Winston
Hi all, I just found this thread on the web: https://gnucash.uservoice.com/forums/101223-feature-request/suggestions/2149519-reporting-multiple-periods Given the date on the post from Geert Janssens, I'm guessing this report or capability isn't included in my GnuCash version 3.6 (from ~1.5

Re: [GNC] Changing multiple transactions

2021-01-31 Thread Adrien Monteleone
You can save as XML, make your changes, then save as SQLite again. I've bounced back and forth several times without issue. You can also do an export to csv, make edits in a spreadsheet, then import the corrected transactions, and just delete the Imbalance account and all transactions in it.

Re: [GNC] Changing multiple transactions

2021-01-31 Thread David Carlson
If those transactions appeared in the imbalance account because you imported them without correctly assigning them during the import process, just re-import them. Note that if they were imported from OFX files the bad transactions would have to be deleted before they can be re-imported. On Sun,

Re: [GNC] Changing multiple transactions

2021-01-31 Thread Jeff Rizzo
On 1/31/21 12:05 PM, Stephen M. Butler wrote: PS  If using a database back-end and you have experience as a database admin or programmer then use the database tools to effect the changes.  Again, make that backup first and loop around as needed until GnC looks good. Yeah, since I'm using

Re: [GNC] Changing multiple transactions

2021-01-31 Thread Stephen M. Butler
I have not had to do this at a large enough level to warrant the below: 1.  Make a backup copy of your file (I presume you are using XML instead of a database back-end). 2.  Export all the transactions from the Imbalance Account (getting the other splits also). 3.  Delete the entire Imbalance

Re: [GNC] New scheduled transaction--error message--I'm stumped

2021-01-31 Thread randix
Ok, I did manage to get the new scheduled transaction added. Can't really say what I did different from the other 5 times I tried, but regardless, the issue (for me) is resolved. Thanks for the reply, consider this inquiry closed... -- Sent from:

[GNC] Changing multiple transactions

2021-01-31 Thread Jeff Rizzo
Hi- I'm currently trying to get my financial house back in order after some years, and have been pleasantly surprised with how much progress GNUCash has made since last I tried to use it (8 or 9 years ago).  It seems to fit my need almost perfectly at this point, with one gaping hole - not

Re: [GNC] Description Field

2021-01-31 Thread John Ralls
David should have mentioned that there is a second text field available called Notes and that you select View>Double Line to access it, and yet another, Memo, that's associated with each split in a transaction; click the Split button in the toolbar or choose auto split or journal view in the

Re: [GNC] US Federal Credit Union as Bank Account

2021-01-31 Thread David Carlson
John, First please reply to the list or reply all. I personally cannot help you. Second, as David T hinted, there are two ways that Quicken does downloads from financial institutions. One is the direct download method that is proprietary through Intuit but is sometimes called QFX. That method

Re: [GNC] Description Field

2021-01-31 Thread David Carlson
That's getting into an area that is hard coded. Some field names will change depending on your language settings, but that's about it. On Sun, Jan 31, 2021 at 5:20 AM Gary Stewart wrote: > Hi, I'm new to GnuCash and I was wondering if it is possible to change the > Description Column heading

Re: [GNC] Usaa requires newer QWIN support

2021-01-31 Thread John Quigley
That is perhaps what is causing my problem with setting up accounts with Security Service FCU. -- John Quigley, Kinney County ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

[GNC] Description Field

2021-01-31 Thread Gary Stewart
Hi, I'm new to GnuCash and I was wondering if it is possible to change the Description Column heading to another name and then add an extra Description Field under a different heading to the main page? Thank you Gary -- This email has been checked for viruses by AVG.