Re: [GNC] (no subject)

2020-02-16 Thread varda241 via gnucash-user
Gnucash 2.6 .19Sent from my Verizon, Samsung Galaxy smartphone Original message From: David Carlson Date: 2/16/20 6:15 PM (GMT-05:00) To: varda241 Cc: gnucash-user@gnucash.org Subject: Re: [GNC] (no subject) What version of GnuCash are you using and how did you install 

Re: [GNC] (no subject)

2020-02-16 Thread varda241 via gnucash-user
Gnucash 2.6 .19Sent from my Verizon, Samsung Galaxy smartphone Original message From: David Carlson Date: 2/16/20 6:15 PM (GMT-05:00) To: varda241 Cc: gnucash-user@gnucash.org Subject: Re: [GNC] (no subject) What version of GnuCash are you using and how did you install 

Re: [GNC] Access the Company Name in python

2020-02-16 Thread Raymond Smith
I don't know if this is a good/robust solution, but I have been playing with parsing gnucash xml files with python recently. This is how I would do it. This assumes a file in the same directory named 'test_business.gnucash' that is saved with compression. If you save without compression, you can

Re: [GNC] How to change MANY Deposits to Withdrawals? (Import error)

2020-02-16 Thread Fran_3 via gnucash-user
I found the GC file before I did the big import and am all set to try it again... but on a copy of that backup GC file, of course :-) But, I'm done for today so I'll do the import in small chunks in the morning and report back. Thanks everyone for the help. On Sunday, February 16, 2020,

Re: [GNC] How to change MANY Deposits to Withdrawals? (Import error)

2020-02-16 Thread Fran_3 via gnucash-user
Ah Ha! That must be where I took the wrong fork in the road. Thanks, good info. On Sunday, February 16, 2020, 2:50:06 PM EST, David Carlson wrote: When importing, the sign overrides the column name, so a negative withdrawal becomes a deposit. David Carlson On Sun, Feb 16, 2020, 1:33

Re: [GNC] (no subject)

2020-02-16 Thread David Carlson
What version of GnuCash are you using and how did you install it? What folder did you use for your data file? David Carlson On Sun, Feb 16, 2020, 4:55 PM varda241 wrote: > > > > > Sent from my Verizon, Samsung Galaxy Tablet > > Original message > From: David Carlson > Date:

Re: [GNC] (no subject)

2020-02-16 Thread varda241 via gnucash-user
Sent from my Verizon, Samsung Galaxy Tablet Original message From: David Carlson Date: 2/16/20 2:52 PM (GMT-05:00) To: Varda Rotenberg Cc: gnucash-user@gnucash.org Subject: Re: [GNC] (no subject) The setting sticks for each account once set.  The setting in preferences

Re: [GNC] (no subject)

2020-02-16 Thread varda241 via gnucash-user
Sent from my Verizon, Samsung Galaxy Tablet Original message From: David Carlson Date: 2/16/20 2:52 PM (GMT-05:00) To: Varda Rotenberg Cc: gnucash-user@gnucash.org Subject: Re: [GNC] (no subject) The setting sticks for each account once set.  The setting in preferences

Re: [GNC] How to change MANY Deposits to Withdrawals? (Import error)

2020-02-16 Thread David Cousens
Have you checked the directory that contains your data file for previous automatically created backup files created whenever the GnuCash program is exited and restarted?. If one of these is timestamped before your large import you may be able to recover to the point before the import. Apart from

Re: [GNC] Flatpak updates

2020-02-16 Thread Geert Janssens
Chris, You may have perl installed on your computer but for flatpak that's irrelevant. For the flatpak to find it, perl should also be installed in the flatpak sandbox. This is not the case by default. In fact I have only added code for this earlier today. So unless you have built your

Re: [GNC] payees?

2020-02-16 Thread Adrien Monteleone
Run an Account or Transaction report, move it to a spreadsheet, remove all but the description column, then set an advanced filter without duplicates with a copy to an empty column, sort by alpha either before or after the copy. Not sure about Excel or Google Sheets, but LibreOffice has

Re: [GNC] How to change MANY Deposits to Withdrawals? (Import error)

2020-02-16 Thread Adrien Monteleone
As was recommended multiple times. Regards, Adrien > On Feb 16, 2020 w8d47, at 1:58 PM, Art Chimes wrote: > > Or perhaps next time do a test run of a handful of the transactions to > be imported before running the whole batch? > -Art- > ___

[GNC] payees?

2020-02-16 Thread Ron
I do see any mention of a list of payees? I have in the past wanted to report on payees, and also used autofill for payee name so that it was consistent. Ron ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription

Re: [GNC] Flatpak updates

2020-02-16 Thread Chris Graves
Thanks Geert, For what it's worth, the trace output is included below. Not sure why the perl complaints, as it is installed. This is a development version. It may or may not work. Report bugs and other problems to gnucash-de...@gnucash.org You can also lookup and file bug reports at

Re: [GNC] How to change MANY Deposits to Withdrawals? (Import error)

2020-02-16 Thread Art Chimes
Or perhaps next time do a test run of a handful of the transactions to be imported before running the whole batch? -Art- From: Michael or Penny Novack To: gnucash-user@gnucash.org Cc: Bcc: Date: Sun, 16 Feb 2020 14:31:01 -0500 Subject: Re: [GNC] How to change MANY Deposits to Withdrawals?

Re: [GNC] (no subject)

2020-02-16 Thread David Carlson
The setting sticks for each account once set. The setting in preferences applies the first time the account is opened. David Carlson On Sun, Feb 16, 2020, 1:49 PM Varda Rotenberg via gnucash-user < gnucash-user@gnucash.org> wrote: > Once in a while, I loose the double line on account. The

Re: [GNC] How to change MANY Deposits to Withdrawals? (Import error)

2020-02-16 Thread David Carlson
When importing, the sign overrides the column name, so a negative withdrawal becomes a deposit. David Carlson On Sun, Feb 16, 2020, 1:33 PM Michael or Penny Novack < stepbystepf...@comcast.net> wrote: > On 2/16/2020 11:28 AM, Fran_3 via gnucash-user wrote: > > I imported a big bunch of checking

[GNC] (no subject)

2020-02-16 Thread Varda Rotenberg via gnucash-user
Once in a while, I loose the double line on account. The option is checked at register default ,but I still get the single lines only. I use the double line for memos. What can be done?thanks, Varda ___ gnucash-user mailing list

Re: [GNC] Flatpak updates

2020-02-16 Thread Geert Janssens
Op zondag 16 februari 2020 20:00:10 CET schreef Chris Graves: > Geert, > > Thanks for your work on this. > > On Fedora 29, I installed maint-C3.8b-151-g555a467ab-D3.8b-13-g93566dc. > > I get a Gnucash crash with nothing in the tracefile, but the following on > console: > Gtk-Message:

Re: [GNC] How to change MANY Deposits to Withdrawals? (Import error)

2020-02-16 Thread Michael or Penny Novack
On 2/16/2020 11:28 AM, Fran_3 via gnucash-user wrote: I imported a big bunch of checking transactions and guess I got the Deposit & Withdrawal columns labeled wrong during the import process. Is there any way to select a bunch of checking transactions and change Deposits to Withdrawals? Thanks

[GNC] Weird behavior of gnucash-aqbanking account mappings

2020-02-16 Thread Peter Zimmerer
Hi all, I have tested online banking with fints pin/tan this weekend for a quite recent gnucash version (e.g commit b23d244 from maint, aqbanking 6.1.0, gwenhywfar 5.2.0) and have found some weird behavior with the gnucash-aqbanking account mappings. In order to reproduce this behavior please

Re: [GNC] How to change MANY Deposits to Withdrawals? (Import error)

2020-02-16 Thread Fran_3 via gnucash-user
Well, turns out I did have a copy of the GC file just before import :-)And I have the data ready to import again.I can experiment and find this out but my question now is... Does the sign need to be minus for Withdrawals? I think, when I originally imported the 663 transactions I may have had

Re: [GNC] Flatpak updates

2020-02-16 Thread Chris Graves
Geert, Thanks for your work on this. On Fedora 29, I installed maint-C3.8b-151-g555a467ab-D3.8b-13-g93566dc. I get a Gnucash crash with nothing in the tracefile, but the following on console: Gtk-Message: 10:35:23.144: Failed to load module "pk-gtk-module" Gtk-Message: 10:35:23.164: Failed to

Re: [GNC] How to change MANY Deposits to Withdrawals? (Import error)

2020-02-16 Thread David Carlson
In the future, be sure to save a copy of the file just before importing! David Carlson On Sun, Feb 16, 2020, 12:14 PM Fran_3 wrote: > They are the last 663 checking transactions and they were already saved > gnuCash and its going to be hard to go back to an earlier version. > > My plan is to

Re: [GNC] How to change MANY Deposits to Withdrawals? (Import error)

2020-02-16 Thread Adrien Monteleone
You can’t. It is a one at a time deal. But if that is everything in that register, you can delete the entire account, then re-create it and start over. Regards, Adrien > On Feb 16, 2020 w8d47, at 12:14 PM, Fran_3 via gnucash-user > wrote: > > They are the last 663 checking transactions and

Re: [GNC] How to change MANY Deposits to Withdrawals? (Import error)

2020-02-16 Thread Fran_3 via gnucash-user
They are the last 663 checking transactions and they were already saved gnuCash and its going to be hard to go back to an earlier version. My plan is to export those last 633 transactions and edit them in a spreadsheet... which I've already doneand I ended up with just 5 columns...  Date, Num,

Re: [GNC] Flatpak updates

2020-02-16 Thread Geert Janssens
I forgot to mention the second "feature" of this new flatpak package: on flathub will also have the most recent aqbanking release (6.02). Regards, Geert Op zondag 16 februari 2020 16:20:56 CET schreef Geert Janssens: > Hi, > > I have just landed Finance::Quote support in our gnucash flatpak

Re: [GNC] How to change MANY Deposits to Withdrawals? (Import error)

2020-02-16 Thread David Carlson
The easiest way is to close gnucash without saving to abandon the current data and import again. If you saved the file with the incorrect import, close it and open the last save before the import. If you didn't notice the error until much later, there is no mass correction possible, but you

[GNC] How to change MANY Deposits to Withdrawals? (Import error)

2020-02-16 Thread Fran_3 via gnucash-user
I imported a big bunch of checking transactions and guess I got the Deposit & Withdrawal columns labeled wrong during the import process. Is there any way to select a bunch of checking transactions and change Deposits to Withdrawals? Thanks for any help.

[GNC] Flatpak updates

2020-02-16 Thread Geert Janssens
Hi, I have just landed Finance::Quote support in our gnucash flatpak packages. From a user point of view all that has to be done to make it working is to either install the most recent version or upgrade to it. If your linux distribution has built-in flatpak support you can use your package