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] 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] 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- > ___

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] 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

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

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