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 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: 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 applies the first time the account is opened.David Carlson On Sun, 
Feb 16, 2020, 1:49 PM Varda Rotenberg via gnucash-user 
 wrote: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
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.
Thank you. So far, I saved the settings, closed the app, rebooted the computer, 
clicked on gnucash and when it came up, there no double line. I work in ubuntu 
18.4Varda

___
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] (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 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: 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 applies the first time the account is opened.David Carlson On Sun, 
Feb 16, 2020, 1:49 PM Varda Rotenberg via gnucash-user 
 wrote: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
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.
Thank you. So far, I saved the settings, closed the app, rebooted the computer, 
clicked on gnucash and when it came up, there no double line. I work in ubuntu 
18.4Varda

___
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] 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
make the following two edits, and it should work:
* gzip.open(fname) --> open(fname)
* filestr = StringIO(fi.read().decode('utf-8')) --> filestr =
StringIO(fi.read())


Contents of some script.py file:

from io import StringIO
import gzip
import os.path as osp
import xml.etree.ElementTree as ET

selfdir = osp.dirname(osp.realpath(__file__))

def main():
fname = osp.join(selfdir, 'test_business.gnucash')
with gzip.open(fname) as fi:
# stackoverflow.com/questions/
# 14853243/parsing-xml-with-namespace-in-python-via-elementtree
# 17615414/how-to-convert-binary-string-to-normal-string-in-python3
filestr = StringIO(fi.read().decode('utf-8'))
ns = dict([node for _, node in ET.iterparse(filestr,
events=['start-ns'])])
fi.seek(0)
tree = ET.parse(fi)
book = tree.getroot().find('gnc:book', ns)
opt_slot = [slot for slot in book.find('book:slots',
ns).findall('slot', ns)
if slot.find('slot:key', ns).text == 'options'][0]
bus_slot = [slot for slot in opt_slot.find('slot:value',
ns).findall('slot', ns)
   if slot.find('slot:key', ns).text == 'Business'][0]
busname_slot = [slot for slot in bus_slot.find('slot:value',
ns).findall('slot', ns)
   if slot.find('slot:key', ns).text == 'Company Name'][0]
busname = busname_slot.find('slot:value', ns).text
print(busname)


if __name__ == '__main__':
main()

On Thu, Jan 30, 2020 at 1:42 PM  wrote:

> What is the most straight forward way to access (read) the company name
> in python. I can see it the XML, but that seems a little fragile. I'm
> talking about the company name entered in File->Properties->Book
> Option->Business not a Vendor or Customer Name.
>
> Could somebody give me a quick pointer to the module and method.
>
>
> Thanks
>
>
>
>
> ___
> 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 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, 5:30:32 PM EST, David Cousens 
 wrote:  
 
 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
saving a copy explicitly I generally exit and restart the program when I am
going to be importing reasonable quantities fo data.

https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-backup1.html

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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 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 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 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.
>
> Horse and barn doors, but this is worth pointing out. Take checkpoints.
>
> In other words, before doing a large import of data, make a backup copy
> of the file. Then, as in a case like this, you can easily back out the
> faulty import.
>
> Michael D Novack
>
>
> ___
> 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.
  
___
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] (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: 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
> 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 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
>> 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.
>>
> Thank you. So far, I saved the settings, closed the app, rebooted the
>> computer, clicked on gnucash and when it came up, there no double line. I
>> work in ubuntu 18.4
>
> Varda
>
>
___
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] (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 applies the first time the account is opened.David Carlson On Sun, 
Feb 16, 2020, 1:49 PM Varda Rotenberg via gnucash-user 
 wrote: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
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.
Thank you. So far, I saved the settings, closed the app, rebooted the computer, 
clicked on gnucash and when it came up, there no double line. I work in ubuntu 
18.4Varda
___
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] (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 applies the first time the account is opened.David Carlson On Sun, 
Feb 16, 2020, 1:49 PM Varda Rotenberg via gnucash-user 
 wrote: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
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.
Thank you. So far, I saved the settings, closed the app, rebooted the computer, 
clicked on gnucash and when it came up, there no double line. I work in ubuntu 
18.4Varda
___
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 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
saving a copy explicitly I generally exit and restart the program when I am
going to be importing reasonable quantities fo data.

https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-backup1.html

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] 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 flatpak yourself after I published my message, 
it's unlikely you 
have a flatpak build with Finance::Quote support enabled.

In that light the perl warning and the gnc_process_get_fd and 
gnc_detach_process errors are to 
be expected.

You can retry the online quotes part with tomorrow's nightly flatpak build. It 
will also have more 
recent versions still of aqbanking (6.1.0) and gwenhywfar (5.2.0) still.

According to a few posts on the web, the Gtk-Message warnings should be 
harmless, though I 
don't know why they appear.

The first series of aqbanking warnings seem to suggest your aqbanking 
configuration is not 
correct. I seem to remember you need to redo it after upgrading from aqbanking 
5 to aqbanking 
6. Other aqbanking user may know more about that.

Just to avoid confusion I'll note again the gnucash project is not developing 
the aqbanking code. 
That is done by the aqbanking project. GnuCash only consumes that code to 
provide online 
banking support. Their website is here:
https://www.aquamaniac.de/rdm/
And while that page is in German they have their own mailing list on which 
communication 
happens both in German and English:
https://mailman.aqbanking.de/listinfo/aqbanking-user
Perhaps someone there has seen these same error messages and can provide more 
help.

Regards,

Geert

Op zondag 16 februari 2020 21:32:57 CET schreef 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 https://bugs.gnucash.org
> To find the last stable version, please refer to https://www.gnucash.org/
> Gtk-Message: 11:48:47.072: Failed to load module "pk-gtk-module"
> Gtk-Message: 11:48:47.106: Failed to load module "pk-gtk-module"
> * 11:48:51  WARN  Could not spawn perl: Failed to execute
> child process “perl” (No such file or directory)
> * 11:48:51 ERROR  gnc_process_get_fd: assertion 'proc' failed
> * 11:48:51 ERROR  gnc_detach_process: assertion 'proc &&
> proc->pid' failed
> * 11:49:36  WARN  banking_cfg.c:  668: No matching config groups
> found
> * 11:49:38  WARN  banking_cfg.c:  668: No matching config groups
> found
> * 11:49:38  WARN  banking_cfg.c:  668: No matching config groups
> found
> * 11:49:38  WARN  banking_cfg.c:  668: No matching config groups
> found
> * 11:49:38  WARN  banking_cfg.c:  668: No matching config groups
> found
> * 11:49:40 ERROR  dlg_setup.c:  214: Got id "1 id from "01
> 00 xxx xxx xxx aqofxconnect"
> * 11:49:40 ERROR  dlg_setup.c:  749: Letting backend
> "aqofxconnect" create dialog
> * 11:49:40 ERROR <> dlg_edituser.c: 1117: Activated: wiz_app_combo
> * 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
> * 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
> * 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
> * 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
> * 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
> * 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
> * 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
> * 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
> * 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
> * 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
> * 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
> * 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
> * 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
> * 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
> * 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
> * 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
> * 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
> * 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
> * 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
> * 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
> * 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
> * 11:49:40 ERROR <> dlg_edituser.c: 1117: Activated: wiz_app_combo
> * 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
> * 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
> * 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
> * 11:49:52 ERROR <> dlg_edituser.c: 1117: Activated: wiz_getaccounts_button
> * 11:49:53 ERROR  n_header.c:   41: Invalid header version
> "102", using "220" instead.
> * 11:50:07 ERROR  dialog.c:  695: Widget [storePasswordCheck]
> not found
> gnucash: 

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 Advanced Filter in the 
Data menu. Be sure to expand the options to see the duplicate and copy check 
boxes.

Regards,
Adrien

> On Feb 16, 2020 w8d47, at 2:54 PM, Ron  wrote:
> 
> 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 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 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-
> 

___
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] 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 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] 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 https://bugs.gnucash.org
To find the last stable version, please refer to https://www.gnucash.org/
Gtk-Message: 11:48:47.072: Failed to load module "pk-gtk-module"
Gtk-Message: 11:48:47.106: Failed to load module "pk-gtk-module"
* 11:48:51  WARN  Could not spawn perl: Failed to execute
child process “perl” (No such file or directory)
* 11:48:51 ERROR  gnc_process_get_fd: assertion 'proc' failed
* 11:48:51 ERROR  gnc_detach_process: assertion 'proc &&
proc->pid' failed
* 11:49:36  WARN  banking_cfg.c:  668: No matching config groups
found
* 11:49:38  WARN  banking_cfg.c:  668: No matching config groups
found
* 11:49:38  WARN  banking_cfg.c:  668: No matching config groups
found
* 11:49:38  WARN  banking_cfg.c:  668: No matching config groups
found
* 11:49:38  WARN  banking_cfg.c:  668: No matching config groups
found
* 11:49:40 ERROR  dlg_setup.c:  214: Got id "1 id from "01
00 xxx xxx xxx aqofxconnect"
* 11:49:40 ERROR  dlg_setup.c:  749: Letting backend
"aqofxconnect" create dialog
* 11:49:40 ERROR <> dlg_edituser.c: 1117: Activated: wiz_app_combo
* 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
* 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
* 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
* 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
* 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
* 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
* 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
* 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
* 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
* 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
* 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
* 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
* 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
* 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
* 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
* 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
* 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
* 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
* 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
* 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
* 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
* 11:49:40 ERROR <> dlg_edituser.c: 1117: Activated: wiz_app_combo
* 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
* 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
* 11:49:40 ERROR  dialog.c:  695: Widget [wiz_stack] not found
* 11:49:52 ERROR <> dlg_edituser.c: 1117: Activated: wiz_getaccounts_button
* 11:49:53 ERROR  n_header.c:   41: Invalid header version
"102", using "220" instead.
* 11:50:07 ERROR  dialog.c:  695: Widget [storePasswordCheck]
not found
gnucash: buffer.c:275: GWEN_Buffer_GetUsedBytes: Assertion `bf' failed.

On Sun, Feb 16, 2020 at 11:37 AM Geert Janssens 
wrote:

> 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: 10:35:23.144: Failed to load module "pk-gtk-module"
>
> > Gtk-Message: 10:35:23.164: Failed to load module "pk-gtk-module"
>
> > gnucash: buffer.c:275: GWEN_Buffer_GetUsedBytes: Assertion `bf' failed.
>
> >
>
> > The crash happens when running the AqB setup wizard. The user has been
>
> > created, however when I edit the user and click Bank Settings->Retrieve
>
> > Account List, enter password, click Ok - boom, crash.
>
> >
>
> > Chris
>
>
>
> Hi Chris,
>
>
>
> You can get the information that would have been written to the trace file
> by running gnucash as follows:
>
>
>
> flatpak run org.gnucash.GnuCash --logto=stdout
>
>
>
> Alternatively you can replace "stdout" with the path to a file in a
> location flatpak is allowed to write to (like anywhere under your home
> directory).
>
>
>
> As for the aqbanking specific issue I can't offer much insight as I don't
> (and can't) use it on my system. You may also ask on the aqbanking user
> mailing list or hope for others on this list to be able to help you out.
>
>
>
> Regards,
>
>
>
> Geert
>
>
>
___
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 

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? (Import error)
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 for any help.

Horse and barn doors, but this is worth pointing out. Take checkpoints.

In other words, before doing a large import of data, make a backup copy
of the file. Then, as in a case like this, you can easily back out the
faulty import.

Michael D Novack
___
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] (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 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
> 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 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 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.
>
> Horse and barn doors, but this is worth pointing out. Take checkpoints.
>
> In other words, before doing a large import of data, make a backup copy
> of the file. Then, as in a case like this, you can easily back out the
> faulty import.
>
> Michael D Novack
>
>
> ___
> 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.


[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
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] 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: 10:35:23.144: Failed to load module "pk-gtk-module"
> Gtk-Message: 10:35:23.164: Failed to load module "pk-gtk-module"
> gnucash: buffer.c:275: GWEN_Buffer_GetUsedBytes: Assertion `bf' failed.
> 
> The crash happens when running the AqB setup wizard.  The user has been
> created, however when I edit the user and click Bank Settings->Retrieve
> Account List, enter password, click Ok - boom, crash.
> 
> Chris

Hi Chris,

You can get the information that would have been written to the trace file by 
running gnucash 
as follows:

flatpak run org.gnucash.GnuCash --logto=stdout

Alternatively you can replace "stdout" with the path to a file in a location 
flatpak is allowed to 
write to (like anywhere under your home directory).

As for the aqbanking specific issue I can't offer much insight as I don't (and 
can't) use it on my 
system. You may also ask on the aqbanking user mailing list or hope for others 
on this list to be 
able to help you out.

Regards,

Geert

___
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 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 for any help.


Horse and barn doors, but this is worth pointing out. Take checkpoints.

In other words, before doing a large import of data, make a backup copy 
of the file. Then, as in a case like this, you can easily back out the 
faulty import.


Michael D Novack


___
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] 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 create a new gnucash file
with at least two bank accounts (e.g. with account names "Account1" and
"Account2").

In order to analyze the effects on the gnucash file I would recommend to
save the gnucash file in sqlite3 format and to watch the changes on the
account-releated entries in table slots with the help of the attached
shell script (requires sqlite3). For this purpose just call

...$ watch SCRIPT_NAME GNUCASH_FILE

at console level.

Now proceed with the online banking wizard as follows:

1.  Create an aqbanking user with at least one online bank account.

2.  Proceed to the "Match Online accounts with GnuCash accounts" page of
the online banking wizard and link the aqbanking account to the
first gnucash account (e.g. Account1).

3.  Proceed to the final page of the wizard and apply your changes.
This will show an output from the script similar to the following:

obj_guidacc_name  slot_name s  slot_value
--      -  -
34a7f42...  Account1  hbci  9  ad00640...
ad00640...hbci/account-id   4  X
ad00640...hbci/account-uid  1  2
ad00640...hbci/bank-code4  50010060

In this case the gnucash account with name "Account1" and identified
by guid 34a7f42... has got three attributes from the aqbanking
account:
- 'hbci/account-id', which is just the account number,
- 'hbci/account-uid ' the unique account id of this bank account
  in aqbanking, and
- 'hbci/bank-code' the bank code of the account
  (German Bankleitzahl).
This is information is used for the (first) online retrieval of
the balance or transactions of this gnucash account.

4.  Open the first gnucash account (e.g. Account1)

5.  Request its account balance by online action "Get Balance"

6.  A "Select Account" dialog will appear and you are requested once
more to assign the retrieved balance to a gnucash account.
Select the first gnucash account (e.g. Account1).

7.  Reply with "No" to the "Reconcile account now?" question.
Now the output from the script should look like the following one:

obj_guidacc_name  slot_name s  slot_value
--      -  -
34a7f42...  Account1  hbci  9  7ec08f4...
7ec08f4...hbci/account-id   4  X
7ec08f4...hbci/account-uid  1  2
7ec08f4...hbci/bank-code4  50010060
34a7f42...  Account1  online_id 4  50010060X

Please note that a new slot attribute with name 'online_id',
which seems to be the concatenation of the  bank code and
the account number, has been assigned to the first gnucash account.
This looks somehow redundant to me because this information is
already covered by the other (hbci) slot values.

8.  Open the "Online Banking Wizard" again and proceed to the
"Match Online accounts with GnuCash accounts" page.

Please note that the previous assignment of the gnucash account
is no longer shown on this page (see also remark below).

9.  Double-click on the same aqbanking account as in step 2, but now
link it to the second gnucash account (e.g. Account2).

10. Proceed to the final page of the wizard and apply yout changes.
Now the output from the script will look like this:

obj_guidacc_name  slot_name s  slot_value
--      -  -
34a7f42...  Account1  hbci  9  056b1cb...
056b1cb...hbci/account-id   4  X
056b1cb...hbci/account-uid  1  2
056b1cb...hbci/bank-code4  50010060
34a7f42...  Account1  online_id 4  50010060X
aa18bf8...  Account2  hbci  9  0291dfe...
0291dfe...hbci/account-id   4  X
0291dfe...hbci/account-uid  1  2
0291dfe...hbci/bank-code4  50010060

Please note that now both gnucash accounts have got assigned to
the same aqbanking account via the 'hbci/...' slot attributes.

11. Now open the second gnucash account (e.g. Account2)

12. Call online action "Requests transactions..." for this account.
Ensure that the selected date interval covers at least
one transaction.

13. Quit the "Generic import transaction matcher" dialog with "OK".

Please note that the transactions are imported to
the first gnucash account but not to the second one which has
been opened just 

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 both 
the Deposit & Withdrawal columns populated with positive numbers...
Our bank puts deposits & withdrawals in the same column with a negative sign 
for withdrawals...
Preparing the spreadsheet for import into GC I used 
=if(A2>0, A2,) to get the positive numbers into the Deposit column and then 
used=if(A2<0, A2,) to get the negative numbers into the Withdrawal field.So the 
withdrawal column should have the negative sign in front of each 
withdrawal...Maybe GC wants both to be positive and uses the Column Heading to 
figure things out... I'm not sureI'll experiment
Anyway thanks for talking me through this guys :-)
Wish me luck.


On Sunday, February 16, 2020, 1:27:33 PM EST, David Carlson 
 wrote:  
 
 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 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, Description, Deposit, Withdrawal
Next I need to delete the last 633 transactions from the check register but I 
have not been able to select multiple checking transactions...
Any idea on how do select multiple checking transactions so you can just delete 
them all at once?
Thanks for the help !

On Sunday, February 16, 2020, 12:34:02 PM EST, David Carlson 
 wrote:  
 
 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 could import again if it was a qif import then delete the 
ones that are wrong. 
David Carlson 
On Sun, Feb 16, 2020, 10:30 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 for any help.

___
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] 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 load module "pk-gtk-module"
gnucash: buffer.c:275: GWEN_Buffer_GetUsedBytes: Assertion `bf' failed.

The crash happens when running the AqB setup wizard.  The user has been
created, however when I edit the user and click Bank Settings->Retrieve
Account List, enter password, click Ok - boom, crash.

Chris
___
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 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 export those last 633 transactions and edit them in a
> spreadsheet... which I've already done
> and I ended up with just 5 columns...  Date, Num, Description, Deposit,
> Withdrawal
>
> Next I need to delete the last 633 transactions from the check register
> but I have not been able to select multiple checking transactions...
>
> Any idea on how do select multiple checking transactions so you can just
> delete them all at once?
>
> Thanks for the help !
>
>
> On Sunday, February 16, 2020, 12:34:02 PM EST, David Carlson <
> david.carlson@gmail.com> wrote:
>
>
> 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 could import again if it was a qif import then
> delete the ones that are wrong.
>
> David Carlson
>
> On Sun, Feb 16, 2020, 10:30 AM Fran_3 via gnucash-user <
> gnucash-user@gnucash.org> 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 for any help.
>
> ___
> 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 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 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, Description, Deposit, Withdrawal
> Next I need to delete the last 633 transactions from the check register but I 
> have not been able to select multiple checking transactions...
> Any idea on how do select multiple checking transactions so you can just 
> delete them all at once?
> Thanks for the help !


___
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 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, Description, Deposit, Withdrawal
Next I need to delete the last 633 transactions from the check register but I 
have not been able to select multiple checking transactions...
Any idea on how do select multiple checking transactions so you can just delete 
them all at once?
Thanks for the help !

On Sunday, February 16, 2020, 12:34:02 PM EST, David Carlson 
 wrote:  
 
 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 could import again if it was a qif import then delete the 
ones that are wrong. 
David Carlson 
On Sun, Feb 16, 2020, 10:30 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 for any help.

___
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] 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 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 manager to get the most recent release, otherwise you can find more
> info on installing flatpaks here:
> https://wiki.gnucash.org/wiki/Flatpak
> 
> The package on flathub should be available in a few hours from now, our
> nightly build repository will provide it as of tomorrow.
> 
> If you experience any issues please let us know.
> 
> Enjoy!
> 
> Geert
> ___
> 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 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 could import again if it was a qif import then
delete the ones that are wrong.

David Carlson

On Sun, Feb 16, 2020, 10:30 AM Fran_3 via gnucash-user <
gnucash-user@gnucash.org> 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 for any help.
>
> ___
> 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.


[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.

___
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] 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 manager 
to get the most recent release, otherwise you can find more info on installing 
flatpaks 
here:
https://wiki.gnucash.org/wiki/Flatpak

The package on flathub should be available in a few hours from now, our nightly 
build 
repository will provide it as of tomorrow.

If you experience any issues please let us know.

Enjoy!

Geert
___
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.