Re: Importing qfx files, version 3.0

[Jim Poklitar]

Thanks David - bummer.

Back to 2.6.19.

Jim P

On Wed, Apr 4, 2018 at 8:44 PM, David Carlson 
wrote:

> As noted in the release notes that feature is known to not work per
> https://bugzilla.gnome.org/show_bug.cgi?id=793461.
>
> It is not known exactly when that will be fixed.
>
> David C
>
> On Wed, Apr 4, 2018 at 7:42 PM, Jim Poklitar 
> wrote:
>
>> ​Until version 3.0, I could download and import .qfx transaction files
>> from
>> my bank for checking and savings ​accounts, as well as credit card
>> transactions from several sources.  File->Import->Import OFX/QFX for any
>> qfx suffixed files from any source worked flawlessly.
>>
>> With version 3.0, attempting to import any of these files yields a blank
>> "Generic import transaction matcher" window.  I've looked at Tools->Import
>> Map Editor, and see all my bank and credit card accounts in each of the
>> Bayesian, Non-Bayesian, and Online ID radio-button tabs, but there doesn't
>> seem to be any way to map a .qfx file.
>>
>> I have set up a couple csv mappings, but this seems to be a clumsy way of
>> doing things, compared to the v 2.xx way of doing things.
>>
>> What am I missing?  How can I restore the ease of importing .qfx files in
>> v
>> 3.0?
>> ___
>> 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: Importing qfx files, version 3.0

[David Carlson]

As noted in the release notes that feature is known to not work per
https://bugzilla.gnome.org/show_bug.cgi?id=793461.

It is not known exactly when that will be fixed.

David C

On Wed, Apr 4, 2018 at 7:42 PM, Jim Poklitar  wrote:

> ​Until version 3.0, I could download and import .qfx transaction files from
> my bank for checking and savings ​accounts, as well as credit card
> transactions from several sources.  File->Import->Import OFX/QFX for any
> qfx suffixed files from any source worked flawlessly.
>
> With version 3.0, attempting to import any of these files yields a blank
> "Generic import transaction matcher" window.  I've looked at Tools->Import
> Map Editor, and see all my bank and credit card accounts in each of the
> Bayesian, Non-Bayesian, and Online ID radio-button tabs, but there doesn't
> seem to be any way to map a .qfx file.
>
> I have set up a couple csv mappings, but this seems to be a clumsy way of
> doing things, compared to the v 2.xx way of doing things.
>
> What am I missing?  How can I restore the ease of importing .qfx files in v
> 3.0?
> ___
> 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: Importing Quicken

[David T. via gnucash-user]

When I did my import (over a decade ago, I believe), I had no problem with 
transfers. Since I was importing all in one pass, there were no duplicates 
created by transfers. 

I believe the duplication problem you describe specifically arises when you opt 
to import transaction data from individual accounts separately, since you have 
to tell the importer when a given transfer is already in the system from the 
other side. It’s precisely why I think it should NOT be the “preferred” way of 
importing from Quicken, since it forces the user to manually identify the other 
side of a transfer every time. That makes my head hurt just thinking about it. 

This is why I chose to run the Export-Import process iteratively, until I got 
the Quicken data massaged to my satisfaction. Then the imported data was all 
good.

Most of the challenge had to do with random category variations, and 
uncategorized transactions—which you well know will end up in IMBALANCE-USD.

David T.

> On Apr 4, 2018, at 7:16 PM, David Carlson  wrote:
> 
> David T,
> 
> Does the QIF importer detect duplicates created by transfers within the same 
> import file?  I seem to recall needing to separate accounts to different 
> files to detect them.
> 
> David C
> 
> On Wed, Apr 4, 2018 at 9:00 AM, David T.  > wrote:
> Alen,
> 
> What you’ve done with the Benefits section is better, but I still feel that 
> any mention of benefits of migration is misplaced here. Someone looking for 
> ways to migrate from Quicken presumably has already come to this conclusion.
> 
> * I have edited the tips portion further. I added a tip regarding the whole 
> Categories/Accounts paradigm.
> 
> * I modified your tip regarding import of categories only, since it isn’t 
> strictly necessary.
> 
> I think it’s useful here to note that I didn’t have to either import the 
> account structure or individual accounts separately when I imported my large 
> QIF file way back in the dark ages—I simply exported everything in one big 
> QIF and did the import from that. That was when I discovered the holes in my 
> Quicken data. I chose to go back in to Quicken, fill in those holes, and 
> re-export the entire file again, repeating until I had a clean enough import 
> to move forward. I know that others have had a different experience.
> 
> * I modified the tip about multiple currencies to more accurately reflect the 
> situation and make it clear that the problem isn’t with GnuCash, but with QIF.
> 
> Cheers,
> David
> 
> > On Apr 4, 2018, at 12:52 PM, Alen Siljak  > > wrote:
> >
> > Hi, David,
> >
> > You are right. I've removed the benefits section but kept the fact about 
> > open data standards. Apart from being a benefit (to me), it is also a 
> > consequence of migration that may or may not be important for users.
> >
> >> You mention multi-currency problems with QIF, saying that GnuCash only 
> >> handles one currency per file. However, I am under the impression that the 
> >> problem of multiple currencies had to do with the *QIF* specification, and 
> >> not GnuCash. In other words, the problem isn't that GnuCash doesn’t handle 
> >> multiple currencies, it’s that QIF doesn’t. Can anyone confirm that for me?
> >
> > Yes, that's probably true. However, if an application interprets a transfer 
> > in such a manner that it takes 100 Euros from one and then deposits 100 AUD 
> > into another account without warning the user, that's a big no-no for me.
> >
> > Thanks for the feedback!
> 
> 

___
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: Importing Quicken

[David Carlson]

David T,

Does the QIF importer detect duplicates created by transfers within the
same import file?  I seem to recall needing to separate accounts to
different files to detect them.

David C

On Wed, Apr 4, 2018 at 9:00 AM, David T.  wrote:

> Alen,
>
> What you’ve done with the Benefits section is better, but I still feel
> that any mention of benefits of migration is misplaced here. Someone
> looking for ways to migrate from Quicken presumably has already come to
> this conclusion.
>
> * I have edited the tips portion further. I added a tip regarding the
> whole Categories/Accounts paradigm.
>
> * I modified your tip regarding import of categories only, since it isn’t
> strictly necessary.
>
> I think it’s useful here to note that I didn’t have to either import the
> account structure or individual accounts separately when I imported my
> large QIF file way back in the dark ages—I simply exported everything in
> one big QIF and did the import from that. That was when I discovered the
> holes in my Quicken data. I chose to go back in to Quicken, fill in those
> holes, and re-export the entire file again, repeating until I had a clean
> enough import to move forward. I know that others have had a different
> experience.
>
> * I modified the tip about multiple currencies to more accurately reflect
> the situation and make it clear that the problem isn’t with GnuCash, but
> with QIF.
>
> Cheers,
> David
>
> > On Apr 4, 2018, at 12:52 PM, Alen Siljak  wrote:
> >
> > Hi, David,
> >
> > You are right. I've removed the benefits section but kept the fact about
> open data standards. Apart from being a benefit (to me), it is also a
> consequence of migration that may or may not be important for users.
> >
> >> You mention multi-currency problems with QIF, saying that GnuCash only
> handles one currency per file. However, I am under the impression that the
> problem of multiple currencies had to do with the *QIF* specification, and
> not GnuCash. In other words, the problem isn't that GnuCash doesn’t handle
> multiple currencies, it’s that QIF doesn’t. Can anyone confirm that for me?
> >
> > Yes, that's probably true. However, if an application interprets a
> transfer in such a manner that it takes 100 Euros from one and then
> deposits 100 AUD into another account without warning the user, that's a
> big no-no for me.
> >
> > Thanks for the feedback!
>
>
___
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: Importing Quicken

[David T. via gnucash-user]

Alen,

What you’ve done with the Benefits section is better, but I still feel that any 
mention of benefits of migration is misplaced here. Someone looking for ways to 
migrate from Quicken presumably has already come to this conclusion.

* I have edited the tips portion further. I added a tip regarding the whole 
Categories/Accounts paradigm. 

* I modified your tip regarding import of categories only, since it isn’t 
strictly necessary. 

I think it’s useful here to note that I didn’t have to either import the 
account structure or individual accounts separately when I imported my large 
QIF file way back in the dark ages—I simply exported everything in one big QIF 
and did the import from that. That was when I discovered the holes in my 
Quicken data. I chose to go back in to Quicken, fill in those holes, and 
re-export the entire file again, repeating until I had a clean enough import to 
move forward. I know that others have had a different experience.

* I modified the tip about multiple currencies to more accurately reflect the 
situation and make it clear that the problem isn’t with GnuCash, but with QIF.

Cheers,
David

> On Apr 4, 2018, at 12:52 PM, Alen Siljak  wrote:
> 
> Hi, David,
> 
> You are right. I've removed the benefits section but kept the fact about open 
> data standards. Apart from being a benefit (to me), it is also a consequence 
> of migration that may or may not be important for users.
> 
>> You mention multi-currency problems with QIF, saying that GnuCash only 
>> handles one currency per file. However, I am under the impression that the 
>> problem of multiple currencies had to do with the *QIF* specification, and 
>> not GnuCash. In other words, the problem isn't that GnuCash doesn’t handle 
>> multiple currencies, it’s that QIF doesn’t. Can anyone confirm that for me?
> 
> Yes, that's probably true. However, if an application interprets a transfer 
> in such a manner that it takes 100 Euros from one and then deposits 100 AUD 
> into another account without warning the user, that's a big no-no for me.
> 
> Thanks for the feedback!

___
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: Importing Quicken

[Alen Siljak]

Hi, David,

You are right. I've removed the benefits section but kept the fact about open 
data standards. Apart from being a benefit (to me), it is also a consequence of 
migration that may or may not be important for users.

> You mention multi-currency problems with QIF, saying that GnuCash only 
> handles one currency per file. However, I am under the impression that the 
> problem of multiple currencies had to do with the *QIF* specification, and 
> not GnuCash. In other words, the problem isn't that GnuCash doesn’t handle 
> multiple currencies, it’s that QIF doesn’t. Can anyone confirm that for me?

Yes, that's probably true. However, if an application interprets a transfer in 
such a manner that it takes 100 Euros from one and then deposits 100 AUD into 
another account without warning the user, that's a big no-no for me.

Thanks for the feedback!
___
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: Importing Quicken

[David T. via gnucash-user]

cicko,

I also like what you’ve done. I will add some edits there. 

Personally, I think the “Benefits” section is pointless; this page is about the 
migration from Quicken—not why someone should use GnuCash. I would recommend 
deleting it altogether, but I defer to you, since you created it.

You mention multi-currency problems with QIF, saying that GnuCash only handles 
one currency per file. However, I am under the impression that the problem of 
multiple currencies had to do with the *QIF* specification, and not GnuCash. In 
other words, the problem isn't that GnuCash doesn’t handle multiple currencies, 
it’s that QIF doesn’t. Can anyone confirm that for me?

Cheers,
David

> On Apr 3, 2018, at 5:15 PM, David Carlson  wrote:
> 
> cicko,
> 
> A very nice start.
> 
> I would add that those with large data files extending back several years
> should consider:
> 
> 1. not importing all of it.
> 
> 2. if you want to import it all, break down your export QIF process to one
> asset or liability account at a time and for limited time intervals such as
> one year at a time.
> 
> The one account at a time procedure makes it possible for GnuCash to detect
> most transfers between accounts so they are not duplicated during the
> import.  I would recommend that to all users.
> 
> I think that split memos are still not imported as of recent GnuCash
> releases up to 2.6.17 or so, but do not quote me on that.  I have not tried
> it recently.
> 
> David C
> 
> 
> 
> On Tue, Apr 3, 2018 at 5:02 AM, cicko  wrote:
> 
>> I have just copied the instructions from the FAQ page into a separate page
>> on
>> the GnuCash wiki, dedicated to Quicken migration:
>> 
>> https://wiki.gnucash.org/wiki/Quicken_Migration
>> 
>> This is a general hint to anyone considering or performing an actual
>> migration from Quicken to GnuCash, to consult the knowledge shared in this
>> page, try to apply it, and provide some feedback so that the instructions
>> can be improved over time.
>> 
>> 
>> 
>> --
>> 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.

___
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: Importing Quicken

[cicko]

I have just copied the instructions from the FAQ page into a separate page on
the GnuCash wiki, dedicated to Quicken migration:

https://wiki.gnucash.org/wiki/Quicken_Migration

This is a general hint to anyone considering or performing an actual
migration from Quicken to GnuCash, to consult the knowledge shared in this
page, try to apply it, and provide some feedback so that the instructions
can be improved over time.



--
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: : importing

[jeffrey black]

On 3/11/2018 6:32 PM, David Carlson wrote:
> Welcome to GnuCash!
>
> Since you have already found the qfx importer you are almost there.  Each
> QIF file contains only transactions from one financial institution and
> probably only for one or two accounts.
>
> You simply follow the steps that appear after starting the importer.  It
> will first ask you which account or accounts you want the transactions to
> apply to if it has never seen a file from that bank, then it will create a
> list of all the new transactions and try to get you to decide where you
> want them to go.  Finally it will actually import them when you click ok.
>
> If you are unsure which other account to assign, leave the transaction
> unassigned so you can fix it later.
>
> I always save my data just before any import so I can go back and try again
> if I decide that I made a mistake.
>
> Good luck!
>
> David C
>
> On Sun, Mar 11, 2018, 4:24 PM Beri Hull  wrote:
>
>> Hi, I am new to gnucash and want to import data from my various bank and
>> investment accounts that I have imported to finder as qfx files.  I  am
>> able to import  data as qfx  files that appear listed in a box titled
>> generic import transaction matcher.I need the transactions imported
>> into  my register.  I have tried dragging,  clicking and cannot figure out
>> how to get them there.   I have found not one instruction, forum discussion
>> or video that  explains how to get the transactions into the proper gnucash
>> accounts.  To do this  must be so simple that it has escaped me.
>>
>>
>> Neri
>> ___
>> 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.
> .
>

I think I understand what you are overlooking.

When the QFX/OFX importer imports your QFX file you will be asked where 
to put the transactions if it does not recognize the financial 
institution (Visa, Amex,  ...).

Once you actually see the individual transactions it will guess which 
corresponding account (groceries, gas) to post to.  If you like what a 
transaction matches, go to the next one.  If you do not like what it 
matches (or says New, UNBALANCED ) double click the "A" box.  You 
will then be asked which account to match the transaction to.  Once you 
like what you see for all of the transactions, click the "OK" button.

I also suggest that if it checks either the "U+R" or "R" box, that you 
double click the the "U+R" or "R" box just to make sure it matches the 
right transaction.  If not, double click the "A" box and manually match it.

And any time you do a manual match, you have the opportunity to create a 
new account to put it in if need be.


Hope this helps.

--JEffrey Black M.B.A.


___
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: : importing

[Dennis West]

Maybe I was just lucky, but I selected the first choice in the QIF 
export which was all accounts including categories and it did it all in 
one pass (and that was for a file that had 20 years of data, 3 banks 
with checking and savings in each and 4 credit cards).


I fully expected to have to break the file into several separate exports 
like you're referring to but figured it was worth a try. I've been using 
the result now for several months and have yet to discover any errors.


DW


On 3/11/2018 18:32, David Carlson wrote:

Welcome to GnuCash!

Since you have already found the qfx importer you are almost there.  Each
QIF file contains only transactions from one financial institution and
probably only for one or two accounts.

You simply follow the steps that appear after starting the importer.  It
will first ask you which account or accounts you want the transactions to
apply to if it has never seen a file from that bank, then it will create a
list of all the new transactions and try to get you to decide where you
want them to go.  Finally it will actually import them when you click ok.

If you are unsure which other account to assign, leave the transaction
unassigned so you can fix it later.

I always save my data just before any import so I can go back and try again
if I decide that I made a mistake.

Good luck!

David C

On Sun, Mar 11, 2018, 4:24 PM Beri Hull  wrote:


Hi, I am new to gnucash and want to import data from my various bank and
investment accounts that I have imported to finder as qfx files.  I  am
able to import  data as qfx  files that appear listed in a box titled
generic import transaction matcher.I need the transactions imported
into  my register.  I have tried dragging,  clicking and cannot figure out
how to get them there.   I have found not one instruction, forum discussion
or video that  explains how to get the transactions into the proper gnucash
accounts.  To do this  must be so simple that it has escaped me.


Neri
___
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: : importing

[Dennis West]

Maybe I was just lucky, but I selected the first choice in the QIF 
export which was all accounts including categories and it did it all in 
one pass (and that was for a file that had 20 years of data, 3 banks 
with checking and savings in each and 4 credit cards).


I fully expected to have to break the file into several separate exports 
like you're referring to but figured it was worth a try. I've been using 
the result now for several months and have yet to discover any errors.


DW


On 3/11/2018 18:32, David Carlson wrote:

Welcome to GnuCash!

Since you have already found the qfx importer you are almost there.  Each
QIF file contains only transactions from one financial institution and
probably only for one or two accounts.

You simply follow the steps that appear after starting the importer.  It
will first ask you which account or accounts you want the transactions to
apply to if it has never seen a file from that bank, then it will create a
list of all the new transactions and try to get you to decide where you
want them to go.  Finally it will actually import them when you click ok.

If you are unsure which other account to assign, leave the transaction
unassigned so you can fix it later.

I always save my data just before any import so I can go back and try again
if I decide that I made a mistake.

Good luck!

David C

On Sun, Mar 11, 2018, 4:24 PM Beri Hull  wrote:


Hi, I am new to gnucash and want to import data from my various bank and
investment accounts that I have imported to finder as qfx files.  I  am
able to import  data as qfx  files that appear listed in a box titled
generic import transaction matcher.I need the transactions imported
into  my register.  I have tried dragging,  clicking and cannot figure out
how to get them there.   I have found not one instruction, forum discussion
or video that  explains how to get the transactions into the proper gnucash
accounts.  To do this  must be so simple that it has escaped me.


Neri
___
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: : importing

[David Carlson]

Welcome to GnuCash!

Since you have already found the qfx importer you are almost there.  Each
QIF file contains only transactions from one financial institution and
probably only for one or two accounts.

You simply follow the steps that appear after starting the importer.  It
will first ask you which account or accounts you want the transactions to
apply to if it has never seen a file from that bank, then it will create a
list of all the new transactions and try to get you to decide where you
want them to go.  Finally it will actually import them when you click ok.

If you are unsure which other account to assign, leave the transaction
unassigned so you can fix it later.

I always save my data just before any import so I can go back and try again
if I decide that I made a mistake.

Good luck!

David C

On Sun, Mar 11, 2018, 4:24 PM Beri Hull  wrote:

> Hi, I am new to gnucash and want to import data from my various bank and
> investment accounts that I have imported to finder as qfx files.  I  am
> able to import  data as qfx  files that appear listed in a box titled
> generic import transaction matcher.I need the transactions imported
> into  my register.  I have tried dragging,  clicking and cannot figure out
> how to get them there.   I have found not one instruction, forum discussion
> or video that  explains how to get the transactions into the proper gnucash
> accounts.  To do this  must be so simple that it has escaped me.
>
>
> Neri
> ___
> 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: : importing

[Adrien Monteleone]

Does File > Import > Import OFX/QFX not work for you?

For instructions, visit gnucash.org. Click the documentation link on the left. 
Read over the Help Manual and the Tutorial & Concepts Guide.


Regards,
Adrien

> On Mar 10, 2018, at 8:59 AM, Beri Hull  wrote:
> 
> Hi, I am new to gnucash and want to import data from my various bank and 
> investment accounts that I have imported to finder as qfx files.  I  am able 
> to import  data as qfx  files that appear listed in a box titled generic 
> import transaction matcher.I need the transactions imported  into  my 
> register.  I have tried dragging,  clicking and cannot figure out how to get 
> them there.   I have found not one instruction, forum discussion or video 
> that  explains how to get the transactions into the proper gnucash accounts.  
> To do this  must be so simple that it has escaped me.
> 
> 
> Neri
> ___
> 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: Importing Quicken

[mahon . finbar]

Me too. I closed off 2017 in Q and used bank balances etc., to start Gnucash on 
1.1.2018. 

No issues. 

On March 11, 2018 10:27:29 AM GMT+01:00, keithwjones  
wrote:
>Edward Ingram-2 wrote
>> My Quicken files are stored in .QDF format, not .QIF. (Quicken 2017)
>> How can I import these? 
>
>I found it easier to just start again with GnuCash instead of importing
>data
>that I did not require. You then have a nice new clean set of accounts.
>
>
>Keith
>
>
>
>
>-
>GnuCash 2.6.19 - Windows 10
>--
>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.

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
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: Importing Quicken

[keithwjones]

Edward Ingram-2 wrote
> My Quicken files are stored in .QDF format, not .QIF. (Quicken 2017)
> How can I import these? 

I found it easier to just start again with GnuCash instead of importing data
that I did not require. You then have a nice new clean set of accounts. 

Keith




-
GnuCash 2.6.19 - Windows 10
--
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: Importing Quicken

[Edward Ingram]

OK DOKE

On Sat, Mar 10, 2018 at 12:00 PM, David Carlson  wrote:

> Edward, Please use reply all to include the maillist.
>
> You need to read the manual and understand how double entry bookkeeping
> works.  You do not really have hundreds of accounts that don't actually
> exist.  As you stated originally, you only have three bank accounts.  All
> the others would be what were called categories in Quicken but they are
> Income and Expense accounts in GnuCash
>
> David C
>
> David C
>
>
>
> On Sat, Mar 10, 2018 at 10:21 AM, Edward Ingram  > wrote:
>
>> Thanks for the quick response!
>> I discovered that I could export my Quicken in .QIF and amazingly,
>> gnucash had no problems whatsoever  importing them. I'm a little
>> intimidated as I begin to learn gnucash as I have hundreds of accounts that
>> don't actually exist. I will need months of work to reduce them to the
>> three registers that I actually need.
>>
>> On Sat, Mar 10, 2018 at 10:16 AM, David Carlson <
>> david.carlson@gmail.com> wrote:
>>
>>> The QDF format is one of the data formats that Quicken has used over the
>>> years.  It is proprietary and sufficiently encrypted to be impossible to
>>> read with other programs.  Before you abandon Quicken you need to use it to
>>> open your file and export your data to QIF format which GnuCash can
>>> import.  Depending on how much data you have we usually suggest exporting
>>> one account at a time.  Good Luck.
>>>
>>> David C
>>>
>>> On Sat, Mar 10, 2018 at 10:03 AM, Edward Ingram <
>>> edwardingram...@gmail.com> wrote:
>>>
 My Quicken files are stored in .QDF format, not .QIF. (Quicken 2017)
 How can I import these? I do not wish to continue using quicken.
 I only have three bank accounts and no investments. I do not need the
 extras of Quicken.
 ___
 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: Importing Quicken

[David Carlson]

Edward, Please use reply all to include the maillist.

You need to read the manual and understand how double entry bookkeeping
works.  You do not really have hundreds of accounts that don't actually
exist.  As you stated originally, you only have three bank accounts.  All
the others would be what were called categories in Quicken but they are
Income and Expense accounts in GnuCash

David C

David C



On Sat, Mar 10, 2018 at 10:21 AM, Edward Ingram 
wrote:

> Thanks for the quick response!
> I discovered that I could export my Quicken in .QIF and amazingly, gnucash
> had no problems whatsoever  importing them. I'm a little intimidated as I
> begin to learn gnucash as I have hundreds of accounts that don't actually
> exist. I will need months of work to reduce them to the three registers
> that I actually need.
>
> On Sat, Mar 10, 2018 at 10:16 AM, David Carlson <
> david.carlson@gmail.com> wrote:
>
>> The QDF format is one of the data formats that Quicken has used over the
>> years.  It is proprietary and sufficiently encrypted to be impossible to
>> read with other programs.  Before you abandon Quicken you need to use it to
>> open your file and export your data to QIF format which GnuCash can
>> import.  Depending on how much data you have we usually suggest exporting
>> one account at a time.  Good Luck.
>>
>> David C
>>
>> On Sat, Mar 10, 2018 at 10:03 AM, Edward Ingram <
>> edwardingram...@gmail.com> wrote:
>>
>>> My Quicken files are stored in .QDF format, not .QIF. (Quicken 2017)
>>> How can I import these? I do not wish to continue using quicken.
>>> I only have three bank accounts and no investments. I do not need the
>>> extras of Quicken.
>>> ___
>>> 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: Importing Quicken

[Ken Schneider]

On 03/10/2018 11:16 AM, David Carlson wrote:

The QDF format is one of the data formats that Quicken has used over the
years.  It is proprietary and sufficiently encrypted to be impossible to
read with other programs.  Before you abandon Quicken you need to use it to
open your file and export your data to QIF format which GnuCash can
import.  Depending on how much data you have we usually suggest exporting
one account at a time.  Good Luck.

David C

On Sat, Mar 10, 2018 at 10:03 AM, Edward Ingram 
wrote:


My Quicken files are stored in .QDF format, not .QIF. (Quicken 2017)
How can I import these? I do not wish to continue using quicken.
I only have three bank accounts and no investments. I do not need the
extras of Quicken.


One of the first things you may want to export is all of your Quicken 
categories that are accounts in the real world. Then export each of your 
accounts in Quicken into a qif file for import into GNUcash. You will 
need to go through each entry in the register to make sure you have none 
with an 'uncategorized' corresponding account (category in Quicken 
terms). It will be tedious but well worth the effort.
Online download of transactions may not work but you can always download 
the data to a qfx file (webconnect file) for import into GNUcash.


Ken Schneider

Long time Quicken user
Recent convert to GNUcash and loving it
___
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: Importing Quicken

[Colin Law]

I believe you have to export from quicken to QIF. Should be in the
menus somewhere.

Colin

On 10 March 2018 at 16:12, Ken Pyzik  wrote:
> Edward -- I did the switch about 8 months ago and have not looked back.
>
> I am pretty sure you can directly import your file from Quicken.  I do not
> remember exactly how I did it but I think QIF means quicken file so it
> should work.
>
> Three things to be aware:
>
> 1.  If you use categories -- those no longer exist is GNUCASH.  Each
> category, theoretically becomes a separate account
> 2.  Double entry accounting means that for every entry there will be an
> opposite an equal "counter" entry into a second account
> 3.  Finally, to get started at the beginning, you will have some "beginning
> balances" entries.
>
> Hope this all makes sense.  It may not covert over 100% --- and depending
> upon how long you were using Quicken -- you could have a lot of
> transactions.  I had transactions dated back to 2001 -- and decided I did
> not want to carry all that stuff -- so I picked a cutoff date (1/1/2014) and
> ended up deleting everything before that.It was a bit a work -- but in
> the end -- very much worth it.
>
> Best of luck -- and I am sure of the experts here can give you a bit more
> direction on the QIF file (I just don't remember what I did -- but it did
> work!).
>
> Ken
>
> -Original Message-
> From: gnucash-user  On
> Behalf Of Edward Ingram
> Sent: Saturday, March 10, 2018 8:03 AM
> To: gnucash-user@gnucash.org
> Subject: Importing Quicken
>
> My Quicken files are stored in .QDF format, not .QIF. (Quicken 2017) How can
> I import these? I do not wish to continue using quicken.
> I only have three bank accounts and no investments. I do not need the extras
> of Quicken.
> ___
> 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: Importing Quicken

[David Carlson]

The QDF format is one of the data formats that Quicken has used over the
years.  It is proprietary and sufficiently encrypted to be impossible to
read with other programs.  Before you abandon Quicken you need to use it to
open your file and export your data to QIF format which GnuCash can
import.  Depending on how much data you have we usually suggest exporting
one account at a time.  Good Luck.

David C

On Sat, Mar 10, 2018 at 10:03 AM, Edward Ingram 
wrote:

> My Quicken files are stored in .QDF format, not .QIF. (Quicken 2017)
> How can I import these? I do not wish to continue using quicken.
> I only have three bank accounts and no investments. I do not need the
> extras of Quicken.
> ___
> 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: Importing Quicken

[Ken Pyzik]

Edward -- I did the switch about 8 months ago and have not looked back.

I am pretty sure you can directly import your file from Quicken.  I do not
remember exactly how I did it but I think QIF means quicken file so it
should work.

Three things to be aware: 

1.  If you use categories -- those no longer exist is GNUCASH.  Each
category, theoretically becomes a separate account
2.  Double entry accounting means that for every entry there will be an
opposite an equal "counter" entry into a second account
3.  Finally, to get started at the beginning, you will have some "beginning
balances" entries.

Hope this all makes sense.  It may not covert over 100% --- and depending
upon how long you were using Quicken -- you could have a lot of
transactions.  I had transactions dated back to 2001 -- and decided I did
not want to carry all that stuff -- so I picked a cutoff date (1/1/2014) and
ended up deleting everything before that.It was a bit a work -- but in
the end -- very much worth it.  

Best of luck -- and I am sure of the experts here can give you a bit more
direction on the QIF file (I just don't remember what I did -- but it did
work!).

Ken

-Original Message-
From: gnucash-user  On
Behalf Of Edward Ingram
Sent: Saturday, March 10, 2018 8:03 AM
To: gnucash-user@gnucash.org
Subject: Importing Quicken

My Quicken files are stored in .QDF format, not .QIF. (Quicken 2017) How can
I import these? I do not wish to continue using quicken.
I only have three bank accounts and no investments. I do not need the extras
of Quicken.
___
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: importing splits

[elvis]

On 27/02/18 01:59, David Carlson wrote:
I believe the OP does not want to use a csv to qif converter. Perhaps 
whichever one he tried was difficult to use.


Or maybe he wishes that his bank would do the split for him
David C





I got a python script written to put the Australia gst split into 
downloaded bank (qif) files. Otherwise there doesn't seem to be any way 
of accounting for it short of putting every purchase through the 
invoicing system. And that just isn't reasonable or practical for a 
large volume of transactions.


I've never used a commercial product, I've always wondered how they 
handle it.


Lawrence


On Feb 26, 2018 5:39 AM, "elvis" > wrote:




On 24/02/18 03:39, Geert Janssens wrote:

Op vrijdag 23 februari 2018 16:06:37 CET schreef Jeff Abrahamson:

Thanks.  I see my question wasn't clear.  My problem is
that I want to
import the splits and it seems I can only import transactions.

I.e. (super simplified):

     deposit cheque           bank dx 100.00
     cheque 1        Alice    membership     rx 50.00
     cheque 2        Bob      membership     rx 50.00

Jeff

Assuming this is one transaction, you are essentially asking
to import multi-
split transactions.

This is not possible in gnucash 2.6, but it will be in 3.0
(which we are
preparing for release, hopefully next month).

I've been importing multi split transactions for years using the
qif importer. Am I missing something here?

Cheers
Lawrence
___
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: importing splits

[David Carlson]

I believe the OP does not want to use a csv to qif converter. Perhaps
whichever one he tried was difficult to use.

Or maybe he wishes that his bank would do the split for him.

David C



On Feb 26, 2018 5:39 AM, "elvis"  wrote:

>
>
> On 24/02/18 03:39, Geert Janssens wrote:
>
>> Op vrijdag 23 februari 2018 16:06:37 CET schreef Jeff Abrahamson:
>>
>>> Thanks.  I see my question wasn't clear.  My problem is that I want to
>>> import the splits and it seems I can only import transactions.
>>>
>>> I.e. (super simplified):
>>>
>>>  deposit cheque   bank  dx 100.00
>>>  cheque 1Alicemembership rx 50.00
>>>  cheque 2Bob  membership rx 50.00
>>>
>>> Jeff
>>>
>> Assuming this is one transaction, you are essentially asking to import
>> multi-
>> split transactions.
>>
>> This is not possible in gnucash 2.6, but it will be in 3.0 (which we are
>> preparing for release, hopefully next month).
>>
> I've been importing multi split transactions for years using the qif
> importer. Am I missing something here?
>
> Cheers
> Lawrence
> ___
> 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: importing splits

[elvis]

On 24/02/18 03:39, Geert Janssens wrote:

Op vrijdag 23 februari 2018 16:06:37 CET schreef Jeff Abrahamson:

Thanks.  I see my question wasn't clear.  My problem is that I want to
import the splits and it seems I can only import transactions.

I.e. (super simplified):

 deposit cheque   bank  dx 100.00
 cheque 1Alicemembership rx 50.00
 cheque 2Bob  membership rx 50.00

Jeff

Assuming this is one transaction, you are essentially asking to import multi-
split transactions.

This is not possible in gnucash 2.6, but it will be in 3.0 (which we are
preparing for release, hopefully next month).
I've been importing multi split transactions for years using the qif 
importer. Am I missing something here?


Cheers
Lawrence
___
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: importing splits

[Buddha Buck]

On Fri, Feb 23, 2018 at 10:08 AM Jeff Abrahamson  wrote:

> Thanks.  I see my question wasn't clear.  My problem is that I want to
> import the splits and it seems I can only import transactions.
>

Splits do not exist independently of transactions. Transactions have a
collection of splits. The collection of splits within a transaction must
balance. You cannot import splits alone, as they would then lack a
transaction context.

 What do you mean by only being able to import transactions when you want
to import splits?


>
> I.e. (super simplified):
>
> deposit cheque   bank  dx 100.00
> cheque 1Alicemembership rx 50.00
> cheque 2Bob  membership rx 50.00
>

This is overly simplified. I can't tell, for instance, the date of the
cheque deposit, if this is referring to 1 check or 3, what is debited or
credited, etc. It *looks* like it might be a single transaction in which
one check was used to pay for both Alice and Bob's memberships, but it's
lacking basic information about the transaction like the date.

And it should be "E.g. (super simplified)" not "I.e. (super simplified)".
The abbreviation "i.e." is short for "id est",Latin for "that is". It's
used to give an alternative definition or description of something (like
"in other words"). In contrast, "e.g." means "exempli gratia", Latin for
"for example", used to provide an example.



>
> Jeff
>
>
> On Tue, Feb 20, 2018 at 09:01:54PM +, Matt Graham wrote:
> > The easiest way would be saving  the spreadsheet to .csv format and
> importing
> > that to Gnucash.
> >
> > Id recommend:
> > - first removing any other text and stuff you have so that the
> spreadsheet is
> > just the headings you want and the data you want in columns
> > - doing the import on a new test gnucash file first if you have a lot of
> data
> > already in your gnucash book. Just in case.
> >
> > Good luck!
> >
> > Thanks and regards,
> > Matt
> >
> >
> >  Original message 
> > From: Jeff Abrahamson 
> > Date: 21/2/18 05:00 (GMT+10:00)
> > To: gnucash-user@gnucash.org
> > Subject: importing splits
> >
> > I'm processing check deposits.  I have a spreadsheet with lovely columns
> > like name, check number, amount, and the account to debit.  It seems a
> > shame to retype it all.
> >
> > I see some old discussion on the list that, essentially, says this is
> > not well supported if supported at all.
> >
> > https://nam04.safelinks.protection.outlook.com/?url=
> > https%3A%2F%2Flists.gnucash.org
> %2Fpipermail%2Fgnucash-user%2F2014-October%2F056617.html
> > =
> >
> 02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590
> >
> =uG5aM8vQ0%2FJ6JvudouGDUL%2F%2BJaLVQvq%2FOQcX93gD%2BaA%3D=0
> >
> > Is there anything since that might help?  I'm not sure converting
> > spreadsheets to QIF to then import into gnucash is better than retyping.
> >
> > --
> >
> > Jeff Abrahamson
> > +33 6 24 40 01 57 <+33%206%2024%2040%2001%2057>
> > +44 7920 594 255 <+44%207920%20594255>
> >
> > https://nam04.safelinks.protection.outlook.com/?url=
> > http%3A%2F%2Fp27.eu%2Fjeff%2F=
> >
> 02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590
> > =Y%2FRcHTU8yWdltXDL4zBTAMPN8grAsKCwY7mf%2FQfmhyw%3D=0
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://nam04.safelinks.protection.outlook.com/?url=
> > https%3A%2F%2Flists.gnucash.org
> %2Fmailman%2Flistinfo%2Fgnucash-user=
> >
> 02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590
> > =LnIFOxRytZiVO6O4On68c7%2B%2FT6DbEEEOclsFRTwyxyo%3D=0
> > If you are using Nabble or Gmane, please see https://
> > nam04.safelinks.protection.outlook.com/?url=
> > https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists=
> >
> 02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590
> > =gnCglOKNDVqlWOaz1Wc4ilJcgVFWM9OkBtXcCFXJdWE%3D=0 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:

Re: importing splits

[Jeff Abrahamson]

Thanks.  I see my question wasn't clear.  My problem is that I want to
import the splits and it seems I can only import transactions.

I.e. (super simplified):

deposit cheque   bank  dx 100.00
cheque 1Alicemembership rx 50.00
cheque 2Bob  membership rx 50.00

Jeff


On Tue, Feb 20, 2018 at 09:01:54PM +, Matt Graham wrote:
> The easiest way would be saving  the spreadsheet to .csv format and importing
> that to Gnucash.
> 
> Id recommend:
> - first removing any other text and stuff you have so that the spreadsheet is
> just the headings you want and the data you want in columns
> - doing the import on a new test gnucash file first if you have a lot of data
> already in your gnucash book. Just in case.
> 
> Good luck!
> 
> Thanks and regards,
> Matt
> 
> 
>  Original message 
> From: Jeff Abrahamson 
> Date: 21/2/18 05:00 (GMT+10:00)
> To: gnucash-user@gnucash.org
> Subject: importing splits
> 
> I'm processing check deposits.  I have a spreadsheet with lovely columns
> like name, check number, amount, and the account to debit.  It seems a
> shame to retype it all.
> 
> I see some old discussion on the list that, essentially, says this is
> not well supported if supported at all.
> 
> https://nam04.safelinks.protection.outlook.com/?url=
> https%3A%2F%2Flists.gnucash.org%2Fpipermail%2Fgnucash-user%2F2014-October%2F056617.html
> =
> 02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590
> =uG5aM8vQ0%2FJ6JvudouGDUL%2F%2BJaLVQvq%2FOQcX93gD%2BaA%3D=0
> 
> Is there anything since that might help?  I'm not sure converting
> spreadsheets to QIF to then import into gnucash is better than retyping.
> 
> --
> 
> Jeff Abrahamson
> +33 6 24 40 01 57
> +44 7920 594 255
> 
> https://nam04.safelinks.protection.outlook.com/?url=
> http%3A%2F%2Fp27.eu%2Fjeff%2F=
> 02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590
> =Y%2FRcHTU8yWdltXDL4zBTAMPN8grAsKCwY7mf%2FQfmhyw%3D=0
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://nam04.safelinks.protection.outlook.com/?url=
> https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user=
> 02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590
> =LnIFOxRytZiVO6O4On68c7%2B%2FT6DbEEEOclsFRTwyxyo%3D=0
> If you are using Nabble or Gmane, please see https://
> nam04.safelinks.protection.outlook.com/?url=
> https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists=
> 02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590
> =gnCglOKNDVqlWOaz1Wc4ilJcgVFWM9OkBtXcCFXJdWE%3D=0 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: importing splits

[Matt Graham]

The easiest way would be saving  the spreadsheet to .csv format and importing 
that to Gnucash.

Id recommend:
- first removing any other text and stuff you have so that the spreadsheet is 
just the headings you want and the data you want in columns
- doing the import on a new test gnucash file first if you have a lot of data 
already in your gnucash book. Just in case.

Good luck!

Thanks and regards,
Matt


 Original message 
From: Jeff Abrahamson 
Date: 21/2/18 05:00 (GMT+10:00)
To: gnucash-user@gnucash.org
Subject: importing splits

I'm processing check deposits.  I have a spreadsheet with lovely columns
like name, check number, amount, and the account to debit.  It seems a
shame to retype it all.

I see some old discussion on the list that, essentially, says this is
not well supported if supported at all.


https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fpipermail%2Fgnucash-user%2F2014-October%2F056617.html=02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590=uG5aM8vQ0%2FJ6JvudouGDUL%2F%2BJaLVQvq%2FOQcX93gD%2BaA%3D=0

Is there anything since that might help?  I'm not sure converting
spreadsheets to QIF to then import into gnucash is better than retyping.

--

Jeff Abrahamson
+33 6 24 40 01 57
+44 7920 594 255

https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fp27.eu%2Fjeff%2F=02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590=Y%2FRcHTU8yWdltXDL4zBTAMPN8grAsKCwY7mf%2FQfmhyw%3D=0

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user=02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590=LnIFOxRytZiVO6O4On68c7%2B%2FT6DbEEEOclsFRTwyxyo%3D=0
If you are using Nabble or Gmane, please see 
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists=02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590=gnCglOKNDVqlWOaz1Wc4ilJcgVFWM9OkBtXcCFXJdWE%3D=0
 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: importing

[Christopher Lam]

There should be no need to delete the Trading Accounts. It only exists if
you have set File>Properties>Use Trading Accounts to true, and you have
transactions that involve a currency/stock conversion. The transactions in
the Trading Accounts are harmless, and are even useful when performing some
capital gains calculations. If you delete them, they will be created again
if you have "Use Trading Accounts" ticked, and you run Actions > Check &
Repair.

The Imbalance transactions also contain splits which indicate an error in
data entry... Best to go through them and find another account for each
split. The Imbalance account can be deleted if it's empty, or, set View >
Filter By > Other > Show zero total accounts to True to hide it when it's
empty.

On 15 October 2017 at 02:52, frank raney  wrote:

> I tried to delete the trading account and my program crashed.  I tried
> again and sometimes it crashes and sometimes nothing happensHow do
> we delete that trading accountI do not need it, but it has
> transactions, I cannot delete the transactions either.  There is also am
> imbalance account it has transactions that are from other accounts that I
> manually updated the balances. can it be deleted also.
>
>
> Frankie Raney
> 12454 Auberry Rd.
> Clovis, Ca.
> 559.297.8577 H
> 559.304.1751 C
> On 10/12/2017 3:33:34 PM, frank raney  wrote:
> Thanks David.I'm almost afraid to try to delete that one
> account.I'll try lateri'm backing up manually and the auto
> alsoso I will not loose anything.   The thing I am trying to do now is
> set up online banking...I don't see much in the help files..looks
> pretty complicated without the help fileI'm surprised it didn't import
> it all.I don't think the recurring auto reminders got imported either,
> but that is easy to create..the memorized transactions got imported fine.
>
>
> Frankie Raney
> 12454 Auberry Rd.
> Clovis, Ca.
> 559.297.8577 H
> 559.304.1751 C
> On 10/12/2017 8:21:16 AM, David Carlson 
> wrote:
> Frank,
>
>
> You certainly had way too many issues with installing and starting to use
> GnuCash.  Hopefully, you have seen them all and will enjoy the benefits now.
>
>
> If GnuCash ever crashes again please report that here.
>
>
> David C
>
>
> On Thu, Oct 12, 2017 at 10:09 AM, frank raney  [mailto:frankraney...@gmail.com]> wrote:
>
> I re-downloaded and re-installedworks now..
>
>
> Frankie Raney
> 12454 Auberry Rd. [https://maps.google.com/?q=
> 12454+Auberry+Rd._Clovis,+Ca_entry=gmailsource=g]
> Clovis, Ca [https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_;
> amp;entry=gmailsource=g].
> 559.297.8577 [tel:(559)%20297-8577] H
> 559.304.1751 [tel:(559)%20304-1751] C
> On 10/12/2017 7:52:06 AM, frank raney  frankraney...@gmail.com]> wrote:
> I am using win 10 and installed GC 2.6.18.
>
> I have even tried putting the help pdf file manually, no luck..looks
> like the install file is only the program, no help file...got it from the
> GC web site  https://www.gnucash.org/download.phtml [
> https://www.gnucash.org/download.phtml]
>
>
> Frankie Raney
> 12454 Auberry Rd. [https://maps.google.com/?q=
> 12454+Auberry+Rd._Clovis,+Ca_entry=gmailsource=g]
> Clovis, Ca [https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_;
> amp;entry=gmailsource=g].
> 559.297.8577 [tel:(559)%20297-8577] H
> 559.304.1751 [tel:(559)%20304-1751] C
> On 10/11/2017 10:00:32 PM, David Carlson  [mailto:david.carlson@gmail.com]> wrote:
> What O S are you installing into and what version are you installing?
> The help files come along automatically in Windows and most Linux packages.
>
> David C
>
>
> On Oct 11, 2017 11:18 PM, "frank raney"  frankraney...@gmail.com]> wrote:
>
> I can't find the documentation to tell me where to put the help files.  I
> put them in the same dir as the program but when I click on help, I am told
> it can not be found.
>
>
> Frankie Raney
> 12454 Auberry Rd. [https://maps.google.com/?q=
> 12454+Auberry+Rd._Clovis,+Ca_entry=gmailsource=g]
> Clovis, Ca [https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_;
> amp;entry=gmailsource=g].
> 559.297.8577 [tel:(559)%20297-8577] H
> 559.304.1751 [tel:(559)%20304-1751] C
> On 10/11/2017 2:14:08 PM, David Carlson  [mailto:david.carlson@gmail.com]> wrote:
> I forgot to mention that there is a setting somewhere called "Use Trading
> Accounts" that turns that feature on or off.  I think it is mentioned
> somewhere in the documentation.
>
>
> David C
>
>
> On Wed, Oct 11, 2017 at 4:07 PM, David Carlson <
> david.carlson@gmail.com [mailto:david.carlson@gmail.com]> wrote:
>
> Frank,
>
>
> There is still a problem with Gnucash on your computer because it should
> not be crashing.
>
>
> It may be somehow related to the 

Re: importing

[frank raney]

I tried to delete the trading account and my program crashed.  I tried again 
and sometimes it crashes and sometimes nothing happensHow do we delete 
that trading accountI do not need it, but it has transactions, I cannot 
delete the transactions either.  There is also am imbalance account it has 
transactions that are from other accounts that I manually updated the balances. 
can it be deleted also.


Frankie Raney
12454 Auberry Rd.
Clovis, Ca.
559.297.8577 H
559.304.1751 C
On 10/12/2017 3:33:34 PM, frank raney  wrote:
Thanks David.I'm almost afraid to try to delete that one account.I'll 
try lateri'm backing up manually and the auto alsoso I will not loose 
anything.   The thing I am trying to do now is set up online banking...I 
don't see much in the help files..looks pretty complicated without the help 
fileI'm surprised it didn't import it all.I don't think the recurring 
auto reminders got imported either, but that is easy to create..the memorized 
transactions got imported fine.


Frankie Raney
12454 Auberry Rd.
Clovis, Ca.
559.297.8577 H
559.304.1751 C
On 10/12/2017 8:21:16 AM, David Carlson  wrote:
Frank,


You certainly had way too many issues with installing and starting to use 
GnuCash.  Hopefully, you have seen them all and will enjoy the benefits now.


If GnuCash ever crashes again please report that here.


David C


On Thu, Oct 12, 2017 at 10:09 AM, frank raney  wrote:

I re-downloaded and re-installedworks now..


Frankie Raney
12454 Auberry Rd. 
[https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_entry=gmailsource=g]
Clovis, Ca 
[https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_entry=gmailsource=g].
559.297.8577 [tel:(559)%20297-8577] H
559.304.1751 [tel:(559)%20304-1751] C
On 10/12/2017 7:52:06 AM, frank raney  wrote:
I am using win 10 and installed GC 2.6.18.

I have even tried putting the help pdf file manually, no luck..looks like 
the install file is only the program, no help file...got it from the GC web 
site  https://www.gnucash.org/download.phtml 
[https://www.gnucash.org/download.phtml]


Frankie Raney
12454 Auberry Rd. 
[https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_entry=gmailsource=g]
Clovis, Ca 
[https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_entry=gmailsource=g].
559.297.8577 [tel:(559)%20297-8577] H
559.304.1751 [tel:(559)%20304-1751] C
On 10/11/2017 10:00:32 PM, David Carlson  wrote:
What O S are you installing into and what version are you installing?
The help files come along automatically in Windows and most Linux packages.

David C


On Oct 11, 2017 11:18 PM, "frank raney"  wrote:

I can't find the documentation to tell me where to put the help files.  I put 
them in the same dir as the program but when I click on help, I am told it can 
not be found.


Frankie Raney
12454 Auberry Rd. 
[https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_entry=gmailsource=g]
Clovis, Ca 
[https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_entry=gmailsource=g].
559.297.8577 [tel:(559)%20297-8577] H
559.304.1751 [tel:(559)%20304-1751] C
On 10/11/2017 2:14:08 PM, David Carlson  wrote:
I forgot to mention that there is a setting somewhere called "Use Trading 
Accounts" that turns that feature on or off.  I think it is mentioned somewhere 
in the documentation.


David C


On Wed, Oct 11, 2017 at 4:07 PM, David Carlson  wrote:

Frank,


There is still a problem with Gnucash on your computer because it should not be 
crashing.


It may be somehow related to the account named Trading that GnuCash created.  
Normally, GnuCash will only create that account for users that know that they 
want to use a special feature that is there for investors to use to help with 
capital gains calculations, and it normally isn't used by most people.


Actually, I am not sure how to safely delete that account (and prevent it from 
coming back) if you do not want it, because it contains transfers to and from 
your security accounts.  Perhaps a developer or another user can advise us 
about that.   That is still not the cause of the crash, the developers may need 
more details about that.


Good luck.


David C



On Wed, Oct 11, 2017 at 3:06 PM, Aaron Laws  wrote:

On Wed, Oct 11, 2017 at 3:31 PM, frank raney 
wrote:

> I just answered my own question..The lck file is a temporary file
> when the main file is opened.  I opened my file read only, resaved it.
> closed it and the 

Re: importing

[David Carlson]

Frank,

You certainly had way too many issues with installing and starting to use
GnuCash.  Hopefully, you have seen them all and will enjoy the benefits now.

If GnuCash ever crashes again please report that here.

David C

On Thu, Oct 12, 2017 at 10:09 AM, frank raney 
wrote:

> I re-downloaded and re-installedworks now..
>
> *Frankie Raney*
> *12454 Auberry Rd.
> *
> *Clovis, Ca
> .*
> *559.297.8577 <(559)%20297-8577> H*
> *559.304.1751 <(559)%20304-1751> C*
>
> On 10/12/2017 7:52:06 AM, frank raney  wrote:
> I am using win 10 and installed GC 2.6.18.
>
> I have even tried putting the help pdf file manually, no luck..looks
> like the install file is only the program, no help file...got it from the
> GC web site  https://www.gnucash.org/download.phtml
>
> *Frankie Raney*
> *12454 Auberry Rd.
> *
> *Clovis, Ca
> .*
> *559.297.8577 <(559)%20297-8577> H*
> *559.304.1751 <(559)%20304-1751> C*
>
> On 10/11/2017 10:00:32 PM, David Carlson 
> wrote:
> What O S are you installing into and what version are you installing?
> The help files come along automatically in Windows and most Linux packages.
>
> David C
>
>
> On Oct 11, 2017 11:18 PM, "frank raney"  wrote:
>
>> I can't find the documentation to tell me where to put the help files.  I
>> put them in the same dir as the program but when I click on help, I am told
>> it can not be found.
>>
>> *Frankie Raney*
>> *12454 Auberry Rd.
>> *
>> *Clovis, Ca
>> .*
>> *559.297.8577 <(559)%20297-8577> H*
>> *559.304.1751 <(559)%20304-1751> C*
>>
>> On 10/11/2017 2:14:08 PM, David Carlson 
>> wrote:
>> I forgot to mention that there is a setting somewhere called "Use Trading
>> Accounts" that turns that feature on or off.  I think it is mentioned
>> somewhere in the documentation.
>>
>> David C
>>
>> On Wed, Oct 11, 2017 at 4:07 PM, David Carlson <
>> david.carlson@gmail.com> wrote:
>>
>>> Frank,
>>>
>>> There is still a problem with Gnucash on your computer because it should
>>> not be crashing.
>>>
>>> It may be somehow related to the account named Trading that GnuCash
>>> created.  Normally, GnuCash will only create that account for users that
>>> know that they want to use a special feature that is there for investors to
>>> use to help with capital gains calculations, and it normally isn't used by
>>> most people.
>>>
>>> Actually, I am not sure how to safely delete that account (and prevent
>>> it from coming back) if you do not want it, because it contains transfers
>>> to and from your security accounts.  Perhaps a developer or another user
>>> can advise us about that.   That is still not the cause of the crash, the
>>> developers may need more details about that.
>>>
>>> Good luck.
>>>
>>> David C
>>>
>>>
>>> On Wed, Oct 11, 2017 at 3:06 PM, Aaron Laws  wrote:
>>>
 On Wed, Oct 11, 2017 at 3:31 PM, frank raney 
 wrote:

 > I just answered my own question..The lck file is a temporary
 file
 > when the main file is opened.  I opened my file read only, resaved it.
 > closed it and the lck file went away.  I opened the file in a smaller
 > window so I coiuld see my directory and the lck file appeared
 again..it
 > went away when I closed the file..so.what was happening
 was,
 > when the program crashed, it did not close the lck file, and when I
 tried
 > to reopen it, it thought it was in usewala..Im back in
 > business...
 >
 >
 > Frankie Raney
 > 12454 Auberry Rd.
 

 >
 Clovis, Ca
 
 .
 > 559.297.8577 H
 > 559.304.1751 C


 That lck file is the mechanism by which gnucash ensures that each file
 is
 only opened once at a time. If that file is there, that means gnucash is
 using the corresponding ".gnucash" file. Of course, if gnucash crashes
 and
 is unable to delete that .lck file, it will superexist the gnucash
 process.
 In this case, the correct choice is "open anyway", and copying
 everything
 first is an excellent idea, too.
 

Re: importing

[frank raney]

I re-downloaded and re-installedworks now..


Frankie Raney
12454 Auberry Rd.
Clovis, Ca.
559.297.8577 H
559.304.1751 C
On 10/12/2017 7:52:06 AM, frank raney  wrote:
I am using win 10 and installed GC 2.6.18.

I have even tried putting the help pdf file manually, no luck..looks like 
the install file is only the program, no help file...got it from the GC web 
site  https://www.gnucash.org/download.phtml


Frankie Raney
12454 Auberry Rd.
Clovis, Ca.
559.297.8577 H
559.304.1751 C
On 10/11/2017 10:00:32 PM, David Carlson  wrote:
What O S are you installing into and what version are you installing?
The help files come along automatically in Windows and most Linux packages.

David C


On Oct 11, 2017 11:18 PM, "frank raney"  wrote:

I can't find the documentation to tell me where to put the help files.  I put 
them in the same dir as the program but when I click on help, I am told it can 
not be found.


Frankie Raney
12454 Auberry Rd. 
[https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_entry=gmailsource=g]
Clovis, Ca 
[https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_entry=gmailsource=g].
559.297.8577 [tel:(559)%20297-8577] H
559.304.1751 [tel:(559)%20304-1751] C
On 10/11/2017 2:14:08 PM, David Carlson  wrote:
I forgot to mention that there is a setting somewhere called "Use Trading 
Accounts" that turns that feature on or off.  I think it is mentioned somewhere 
in the documentation.


David C


On Wed, Oct 11, 2017 at 4:07 PM, David Carlson  wrote:

Frank,


There is still a problem with Gnucash on your computer because it should not be 
crashing.


It may be somehow related to the account named Trading that GnuCash created.  
Normally, GnuCash will only create that account for users that know that they 
want to use a special feature that is there for investors to use to help with 
capital gains calculations, and it normally isn't used by most people.


Actually, I am not sure how to safely delete that account (and prevent it from 
coming back) if you do not want it, because it contains transfers to and from 
your security accounts.  Perhaps a developer or another user can advise us 
about that.   That is still not the cause of the crash, the developers may need 
more details about that.


Good luck.


David C



On Wed, Oct 11, 2017 at 3:06 PM, Aaron Laws  wrote:

On Wed, Oct 11, 2017 at 3:31 PM, frank raney 
wrote:

> I just answered my own question..The lck file is a temporary file
> when the main file is opened.  I opened my file read only, resaved it.
> closed it and the lck file went away.  I opened the file in a smaller
> window so I coiuld see my directory and the lck file appeared again..it
> went away when I closed the file..so.what was happening was,
> when the program crashed, it did not close the lck file, and when I tried
> to reopen it, it thought it was in usewala..Im back in
> business...
>
>
> Frankie Raney
> 12454 Auberry Rd. 
> [https://maps.google.com/?q=12454+Auberry+Rd.+%0D+%3E+Clovis,+Caentry=gmailsource=g]
> Clovis, Ca 
> [https://maps.google.com/?q=12454+Auberry+Rd.+%0D+%3E+Clovis,+Caentry=gmailsource=g].
> 559.297.8577 [tel:559.297.8577] H
> 559.304.1751 [tel:559.304.1751] C


That lck file is the mechanism by which gnucash ensures that each file is
only opened once at a time. If that file is there, that means gnucash is
using the corresponding ".gnucash" file. Of course, if gnucash crashes and
is unable to delete that .lck file, it will superexist the gnucash process.
In this case, the correct choice is "open anyway", and copying everything
first is an excellent idea, too.

___
gnucash-user mailing list
gnucash-user@gnucash.org [mailto:gnucash-user@gnucash.org]
https://lists.gnucash.org/mailman/listinfo/gnucash-user 
[https://lists.gnucash.org/mailman/listinfo/gnucash-user]
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.




[https://www.avast.com/sig-email?utm_medium=emailutm_source=linkutm_campaign=sig-emailutm_content=emailclientutm_term=icon]
 Virus-free. www.avast.com 
[https://www.avast.com/sig-email?utm_medium=emailutm_source=linkutm_campaign=sig-emailutm_content=emailclientutm_term=link]
[#m_-361508229154219599_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2]

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your 

Re: importing

[frank raney]

I am using win 10 and installed GC 2.6.18.

I have even tried putting the help pdf file manually, no luck..looks like 
the install file is only the program, no help file...got it from the GC web 
site  https://www.gnucash.org/download.phtml


Frankie Raney
12454 Auberry Rd.
Clovis, Ca.
559.297.8577 H
559.304.1751 C
On 10/11/2017 10:00:32 PM, David Carlson  wrote:
What O S are you installing into and what version are you installing?
The help files come along automatically in Windows and most Linux packages.

David C


On Oct 11, 2017 11:18 PM, "frank raney"  wrote:

I can't find the documentation to tell me where to put the help files.  I put 
them in the same dir as the program but when I click on help, I am told it can 
not be found.


Frankie Raney
12454 Auberry Rd. 
[https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_entry=gmailsource=g]
Clovis, Ca 
[https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_entry=gmailsource=g].
559.297.8577 [tel:(559)%20297-8577] H
559.304.1751 [tel:(559)%20304-1751] C
On 10/11/2017 2:14:08 PM, David Carlson  wrote:
I forgot to mention that there is a setting somewhere called "Use Trading 
Accounts" that turns that feature on or off.  I think it is mentioned somewhere 
in the documentation.


David C


On Wed, Oct 11, 2017 at 4:07 PM, David Carlson  wrote:

Frank,


There is still a problem with Gnucash on your computer because it should not be 
crashing.


It may be somehow related to the account named Trading that GnuCash created.  
Normally, GnuCash will only create that account for users that know that they 
want to use a special feature that is there for investors to use to help with 
capital gains calculations, and it normally isn't used by most people.


Actually, I am not sure how to safely delete that account (and prevent it from 
coming back) if you do not want it, because it contains transfers to and from 
your security accounts.  Perhaps a developer or another user can advise us 
about that.   That is still not the cause of the crash, the developers may need 
more details about that.


Good luck.


David C



On Wed, Oct 11, 2017 at 3:06 PM, Aaron Laws  wrote:

On Wed, Oct 11, 2017 at 3:31 PM, frank raney 
wrote:

> I just answered my own question..The lck file is a temporary file
> when the main file is opened.  I opened my file read only, resaved it.
> closed it and the lck file went away.  I opened the file in a smaller
> window so I coiuld see my directory and the lck file appeared again..it
> went away when I closed the file..so.what was happening was,
> when the program crashed, it did not close the lck file, and when I tried
> to reopen it, it thought it was in usewala..Im back in
> business...
>
>
> Frankie Raney
> 12454 Auberry Rd. 
> [https://maps.google.com/?q=12454+Auberry+Rd.+%0D+%3E+Clovis,+Caentry=gmailsource=g]
> Clovis, Ca 
> [https://maps.google.com/?q=12454+Auberry+Rd.+%0D+%3E+Clovis,+Caentry=gmailsource=g].
> 559.297.8577 [tel:559.297.8577] H
> 559.304.1751 [tel:559.304.1751] C


That lck file is the mechanism by which gnucash ensures that each file is
only opened once at a time. If that file is there, that means gnucash is
using the corresponding ".gnucash" file. Of course, if gnucash crashes and
is unable to delete that .lck file, it will superexist the gnucash process.
In this case, the correct choice is "open anyway", and copying everything
first is an excellent idea, too.

___
gnucash-user mailing list
gnucash-user@gnucash.org [mailto:gnucash-user@gnucash.org]
https://lists.gnucash.org/mailman/listinfo/gnucash-user 
[https://lists.gnucash.org/mailman/listinfo/gnucash-user]
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.




[https://www.avast.com/sig-email?utm_medium=emailutm_source=linkutm_campaign=sig-emailutm_content=emailclientutm_term=icon]
 Virus-free. www.avast.com 
[https://www.avast.com/sig-email?utm_medium=emailutm_source=linkutm_campaign=sig-emailutm_content=emailclientutm_term=link]
[#m_-361508229154219599_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2]

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: importing

[David Carlson]

What O S are you installing into and what version are you installing?
The help files come along automatically in Windows and most Linux packages.

David C


On Oct 11, 2017 11:18 PM, "frank raney"  wrote:

> I can't find the documentation to tell me where to put the help files.  I
> put them in the same dir as the program but when I click on help, I am told
> it can not be found.
>
> *Frankie Raney*
> *12454 Auberry Rd.
> *
> *Clovis, Ca
> .*
> *559.297.8577 <(559)%20297-8577> H*
> *559.304.1751 <(559)%20304-1751> C*
>
> On 10/11/2017 2:14:08 PM, David Carlson 
> wrote:
> I forgot to mention that there is a setting somewhere called "Use Trading
> Accounts" that turns that feature on or off.  I think it is mentioned
> somewhere in the documentation.
>
> David C
>
> On Wed, Oct 11, 2017 at 4:07 PM, David Carlson <
> david.carlson@gmail.com> wrote:
>
>> Frank,
>>
>> There is still a problem with Gnucash on your computer because it should
>> not be crashing.
>>
>> It may be somehow related to the account named Trading that GnuCash
>> created.  Normally, GnuCash will only create that account for users that
>> know that they want to use a special feature that is there for investors to
>> use to help with capital gains calculations, and it normally isn't used by
>> most people.
>>
>> Actually, I am not sure how to safely delete that account (and prevent it
>> from coming back) if you do not want it, because it contains transfers to
>> and from your security accounts.  Perhaps a developer or another user can
>> advise us about that.   That is still not the cause of the crash, the
>> developers may need more details about that.
>>
>> Good luck.
>>
>> David C
>>
>>
>> On Wed, Oct 11, 2017 at 3:06 PM, Aaron Laws  wrote:
>>
>>> On Wed, Oct 11, 2017 at 3:31 PM, frank raney 
>>> wrote:
>>>
>>> > I just answered my own question..The lck file is a temporary
>>> file
>>> > when the main file is opened.  I opened my file read only, resaved it.
>>> > closed it and the lck file went away.  I opened the file in a smaller
>>> > window so I coiuld see my directory and the lck file appeared
>>> again..it
>>> > went away when I closed the file..so.what was happening
>>> was,
>>> > when the program crashed, it did not close the lck file, and when I
>>> tried
>>> > to reopen it, it thought it was in usewala..Im back in
>>> > business...
>>> >
>>> >
>>> > Frankie Raney
>>> > 12454 Auberry Rd.
>>> 
>>> > Clovis, Ca
>>> 
>>> .
>>> > 559.297.8577 H
>>> > 559.304.1751 C
>>>
>>>
>>> That lck file is the mechanism by which gnucash ensures that each file is
>>> only opened once at a time. If that file is there, that means gnucash is
>>> using the corresponding ".gnucash" file. Of course, if gnucash crashes
>>> and
>>> is unable to delete that .lck file, it will superexist the gnucash
>>> process.
>>> In this case, the correct choice is "open anyway", and copying everything
>>> first is an excellent idea, too.
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>>
>>
>>
>
>
> 
>  Virus-free.
> www.avast.com
> 
> <#m_-361508229154219599_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: importing

[David Carlson]

I forgot to mention that there is a setting somewhere called "Use Trading
Accounts" that turns that feature on or off.  I think it is mentioned
somewhere in the documentation.

David C

On Wed, Oct 11, 2017 at 4:07 PM, David Carlson 
wrote:

> Frank,
>
> There is still a problem with Gnucash on your computer because it should
> not be crashing.
>
> It may be somehow related to the account named Trading that GnuCash
> created.  Normally, GnuCash will only create that account for users that
> know that they want to use a special feature that is there for investors to
> use to help with capital gains calculations, and it normally isn't used by
> most people.
>
> Actually, I am not sure how to safely delete that account (and prevent it
> from coming back) if you do not want it, because it contains transfers to
> and from your security accounts.  Perhaps a developer or another user can
> advise us about that.   That is still not the cause of the crash, the
> developers may need more details about that.
>
> Good luck.
>
> David C
>
>
> On Wed, Oct 11, 2017 at 3:06 PM, Aaron Laws  wrote:
>
>> On Wed, Oct 11, 2017 at 3:31 PM, frank raney 
>> wrote:
>>
>> > I just answered my own question..The lck file is a temporary
>> file
>> > when the main file is opened.  I opened my file read only, resaved it.
>> > closed it and the lck file went away.  I opened the file in a smaller
>> > window so I coiuld see my directory and the lck file appeared
>> again..it
>> > went away when I closed the file..so.what was happening was,
>> > when the program crashed, it did not close the lck file, and when I
>> tried
>> > to reopen it, it thought it was in usewala..Im back in
>> > business...
>> >
>> >
>> > Frankie Raney
>> > 12454 Auberry Rd.
>> > Clovis, Ca.
>> > 559.297.8577 H
>> > 559.304.1751 C
>>
>>
>> That lck file is the mechanism by which gnucash ensures that each file is
>> only opened once at a time. If that file is there, that means gnucash is
>> using the corresponding ".gnucash" file. Of course, if gnucash crashes and
>> is unable to delete that .lck file, it will superexist the gnucash
>> process.
>> In this case, the correct choice is "open anyway", and copying everything
>> first is an excellent idea, too.
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: importing

[David Carlson]

Frank,

There is still a problem with Gnucash on your computer because it should
not be crashing.

It may be somehow related to the account named Trading that GnuCash
created.  Normally, GnuCash will only create that account for users that
know that they want to use a special feature that is there for investors to
use to help with capital gains calculations, and it normally isn't used by
most people.

Actually, I am not sure how to safely delete that account (and prevent it
from coming back) if you do not want it, because it contains transfers to
and from your security accounts.  Perhaps a developer or another user can
advise us about that.   That is still not the cause of the crash, the
developers may need more details about that.

Good luck.

David C


On Wed, Oct 11, 2017 at 3:06 PM, Aaron Laws  wrote:

> On Wed, Oct 11, 2017 at 3:31 PM, frank raney 
> wrote:
>
> > I just answered my own question..The lck file is a temporary file
> > when the main file is opened.  I opened my file read only, resaved it.
> > closed it and the lck file went away.  I opened the file in a smaller
> > window so I coiuld see my directory and the lck file appeared
> again..it
> > went away when I closed the file..so.what was happening was,
> > when the program crashed, it did not close the lck file, and when I tried
> > to reopen it, it thought it was in usewala..Im back in
> > business...
> >
> >
> > Frankie Raney
> > 12454 Auberry Rd.
> > Clovis, Ca.
> > 559.297.8577 H
> > 559.304.1751 C
>
>
> That lck file is the mechanism by which gnucash ensures that each file is
> only opened once at a time. If that file is there, that means gnucash is
> using the corresponding ".gnucash" file. Of course, if gnucash crashes and
> is unable to delete that .lck file, it will superexist the gnucash process.
> In this case, the correct choice is "open anyway", and copying everything
> first is an excellent idea, too.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: importing

[Aaron Laws]

On Wed, Oct 11, 2017 at 3:31 PM, frank raney 
wrote:

> I just answered my own question..The lck file is a temporary file
> when the main file is opened.  I opened my file read only, resaved it.
> closed it and the lck file went away.  I opened the file in a smaller
> window so I coiuld see my directory and the lck file appeared again..it
> went away when I closed the file..so.what was happening was,
> when the program crashed, it did not close the lck file, and when I tried
> to reopen it, it thought it was in usewala..Im back in
> business...
>
>
> Frankie Raney
> 12454 Auberry Rd.
> Clovis, Ca.
> 559.297.8577 H
> 559.304.1751 C


That lck file is the mechanism by which gnucash ensures that each file is
only opened once at a time. If that file is there, that means gnucash is
using the corresponding ".gnucash" file. Of course, if gnucash crashes and
is unable to delete that .lck file, it will superexist the gnucash process.
In this case, the correct choice is "open anyway", and copying everything
first is an excellent idea, too.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: importing

[frank raney]

I just answered my own question..The lck file is a temporary file when 
the main file is opened.  I opened my file read only, resaved it. closed it and 
the lck file went away.  I opened the file in a smaller window so I coiuld see 
my directory and the lck file appeared again..it went away when I closed 
the file..so.what was happening was, when the program crashed, it 
did not close the lck file, and when I tried to reopen it, it thought it was in 
usewala..Im back in business...


Frankie Raney
12454 Auberry Rd.
Clovis, Ca.
559.297.8577 H
559.304.1751 C
On 10/11/2017 12:21:33 PM, frank raney  wrote:
OK
So I redid the import and saved my self periodicallyeverything was going 
well.Untill I deleted an accoiut that was called TradingI did not have 
that accoiunt in quicken by that name.  It is my IRA...when I deleted that 
file, the program crashed again.  I had just saved before I tried to delete.  
(it also saved its own with date..

When I tried to open my file I got a message that the lock file could not be 
found...  I opened the backup created by GC but the main checking account is 
not the same.  The message was " GnuCash could not obtain the lock for 
file://C:\Users\Frankie\Documents\gnucash\mydata 2017.gnucash. That database 
may be in use by another user, in which case you should not open the database. 
What would you like to do?"

There are options to open read only, create a new file, open anyway, quit.

this is exactly what happened tbefore, but I opened anyway.

the lock file exists (lck file) but is 0 bites and is an hour old...

What is this lock file?  

I am going to copy the whole dir and then try to open read only, then resave.


Frankie Raney
12454 Auberry Rd.
Clovis, Ca.
559.297.8577 H
559.304.1751 C
On 10/10/2017 10:22:24 AM, Frankie Raney  wrote:
Only backups was the ones within the first 20-15 min, nothing else during the 
4-5 hrs of work.  I have started over and as before, only one acct is off, my 
main checkingalmost $6000 off. What I will do is compare balances every 2-3 
months, untill I find a spot they do not agree, then delete the duplicate. This 
is the fastest way with a 1.2 Meg file. This time I will manually save every 10 
min...

Someone mentioned XML and SQLthese should already be installed since I use 
other databases?  Or will I have to install them for use with GC.


On Oct 10, 2017 7:01 AM, "Colin Law"  wrote:

Are there any of the backups there somename.gnucash.nnn?  The
number string is the date/time that it was taken. These will be mixed
up with the log files so you may not have noticed them.

Colin

On 10 October 2017 at 14:30, Frankie Raney  wrote:
> Did a search, that's how I know it went to lala land.  Can't remember ever
> having this happen before.
>
> On Oct 10, 2017 2:50 AM, "Liz"  
> wrote:
>
>> On Mon, 9 Oct 2017 20:39:34 -0700
>> Frankie Raney  
>> wrote:
>>
>> > Yes, yes, and yes. It was, is the only filewhen it crashed it went
>> > awayI saved it after importing, and looked at it with file
>> > browserit was therethen I went back, run GC and started
>> > editing..when GC crashed, the file went to lala land. Only the
>> > log file was left.
>>
>> basic idea, but in case lala land is still on your hard drive, a search
>> for *.gnucash is worthwhile
>>
>> Liz
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org [mailto:gnucash-user@gnucash.org]
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
>> [https://lists.gnucash.org/mailman/listinfo/gnucash-user]
>> -
>> 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 [mailto:gnucash-user@gnucash.org]
> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
> [https://lists.gnucash.org/mailman/listinfo/gnucash-user]
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: importing

[frank raney]

OK
So I redid the import and saved my self periodicallyeverything was going 
well.Untill I deleted an accoiut that was called TradingI did not have 
that accoiunt in quicken by that name.  It is my IRA...when I deleted that 
file, the program crashed again.  I had just saved before I tried to delete.  
(it also saved its own with date..

When I tried to open my file I got a message that the lock file could not be 
found...  I opened the backup created by GC but the main checking account is 
not the same.  The message was " GnuCash could not obtain the lock for 
file://C:\Users\Frankie\Documents\gnucash\mydata 2017.gnucash. That database 
may be in use by another user, in which case you should not open the database. 
What would you like to do?"

There are options to open read only, create a new file, open anyway, quit.

this is exactly what happened tbefore, but I opened anyway.

the lock file exists (lck file) but is 0 bites and is an hour old...

What is this lock file?  

I am going to copy the whole dir and then try to open read only, then resave.


Frankie Raney
12454 Auberry Rd.
Clovis, Ca.
559.297.8577 H
559.304.1751 C
On 10/10/2017 10:22:24 AM, Frankie Raney  wrote:
Only backups was the ones within the first 20-15 min, nothing else during the 
4-5 hrs of work.  I have started over and as before, only one acct is off, my 
main checkingalmost $6000 off. What I will do is compare balances every 2-3 
months, untill I find a spot they do not agree, then delete the duplicate. This 
is the fastest way with a 1.2 Meg file. This time I will manually save every 10 
min...

Someone mentioned XML and SQLthese should already be installed since I use 
other databases?  Or will I have to install them for use with GC.


On Oct 10, 2017 7:01 AM, "Colin Law"  wrote:

Are there any of the backups there somename.gnucash.nnn?  The
number string is the date/time that it was taken. These will be mixed
up with the log files so you may not have noticed them.

Colin

On 10 October 2017 at 14:30, Frankie Raney  wrote:
> Did a search, that's how I know it went to lala land.  Can't remember ever
> having this happen before.
>
> On Oct 10, 2017 2:50 AM, "Liz"  
> wrote:
>
>> On Mon, 9 Oct 2017 20:39:34 -0700
>> Frankie Raney  
>> wrote:
>>
>> > Yes, yes, and yes. It was, is the only filewhen it crashed it went
>> > awayI saved it after importing, and looked at it with file
>> > browserit was therethen I went back, run GC and started
>> > editing..when GC crashed, the file went to lala land. Only the
>> > log file was left.
>>
>> basic idea, but in case lala land is still on your hard drive, a search
>> for *.gnucash is worthwhile
>>
>> Liz
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org [mailto:gnucash-user@gnucash.org]
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
>> [https://lists.gnucash.org/mailman/listinfo/gnucash-user]
>> -
>> 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 [mailto:gnucash-user@gnucash.org]
> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
> [https://lists.gnucash.org/mailman/listinfo/gnucash-user]
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: importing

[Colin Law]

Are there any of the backups there somename.gnucash.nnn?  The
number string is the date/time that it was taken. These will be mixed
up with the log files so you may not have noticed them.

Colin

On 10 October 2017 at 14:30, Frankie Raney  wrote:
> Did a search, that's how I know it went to lala land.  Can't remember ever
> having this happen before.
>
> On Oct 10, 2017 2:50 AM, "Liz"  wrote:
>
>> On Mon, 9 Oct 2017 20:39:34 -0700
>> Frankie Raney  wrote:
>>
>> > Yes, yes, and yes. It was, is the only filewhen it crashed it went
>> > awayI saved it after importing, and looked at it with file
>> > browserit was therethen I went back, run GC and started
>> > editing..when GC crashed, the file went to lala land. Only the
>> > log file was left.
>>
>> basic idea, but in case lala land is still on your hard drive, a search
>> for *.gnucash is worthwhile
>>
>> Liz
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> 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
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: importing

[Maf. King]

On Tuesday, 10 October 2017 14:30:41 BST Frankie Raney wrote:
> Did a search, that's how I know it went to lala land.  Can't remember ever
> having this happen before.
> 

Hi Frankie,

Don't know much about importing, 'cos I've never done it, but trashing the 
data file is a worry!

AFAIK,when GC does a save (or autosave) it doesn't delete the data file - it 
renames the old one to [name].timestamp.gnucash, and then creates a new 
[name].gnucash  -  which I know doesn't help much...

are you on Windows?  Try looking for hidden files?  What was the full path to 
the folder the file disappeared from ?  Were you using the XML or SQLite file 
backend (or a full-on database)? 

- fully appreciate that as a new user, you may not know the answers to these, 
especially the last question!

HTH,
Maf.

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: importing

[Frankie Raney]

Did a search, that's how I know it went to lala land.  Can't remember ever
having this happen before.

On Oct 10, 2017 2:50 AM, "Liz"  wrote:

> On Mon, 9 Oct 2017 20:39:34 -0700
> Frankie Raney  wrote:
>
> > Yes, yes, and yes. It was, is the only filewhen it crashed it went
> > awayI saved it after importing, and looked at it with file
> > browserit was therethen I went back, run GC and started
> > editing..when GC crashed, the file went to lala land. Only the
> > log file was left.
>
> basic idea, but in case lala land is still on your hard drive, a search
> for *.gnucash is worthwhile
>
> Liz
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: importing

[Liz]

On Mon, 9 Oct 2017 20:39:34 -0700
Frankie Raney  wrote:

> Yes, yes, and yes. It was, is the only filewhen it crashed it went
> awayI saved it after importing, and looked at it with file
> browserit was therethen I went back, run GC and started
> editing..when GC crashed, the file went to lala land. Only the
> log file was left.

basic idea, but in case lala land is still on your hard drive, a search
for *.gnucash is worthwhile

Liz
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: importing

[Frankie Raney]

Yes, yes, and yes. It was, is the only filewhen it crashed it went
awayI saved it after importing, and looked at it with file
browserit was therethen I went back, run GC and started
editing..when GC crashed, the file went to lala land. Only the log file
was left.

On Oct 9, 2017 8:26 AM, "Colin Law"  wrote:

> On 9 October 2017 at 16:13, frank raney  wrote:
> > I thought it did something like that..I usually do save periodically
> when working for long periods,  But I got so involved, I forgot.How do
> I get/install an sql backend.
>
> I thought the default was to auto-save every 5 minutes or something.
> Are you absolutely certain that you have lost everything? Are you sure
> you are looking at the correct file?
>
> Colin
>
> >
> >
> > Frankie Raney
> > 12454 Auberry Rd.
> > Clovis, Ca.
> > 559.297.8577 H
> > 559.304.1751 C
> > On 10/9/2017 6:43:14 AM, Aaron Laws  wrote:
> > On Sun, Oct 8, 2017 at 9:27 PM, frank raney  [mailto:frankraney...@gmail.com]> wrote:
> >
> > Just finished 6 hours correcting all the data i imported and before I
> could save it, the program crashed. All I have is the unchanged imported
> data fileWhen it crashed, the file was lost but there is a log
> file..what it is I don't know.  Guess I have to start all over?
> >
> >
> > Frankie Raney
> > 12454 Auberry Rd.
> > Clovis, Ca.
> > 559.297.8577 [tel:559.297.8577] H
> > 559.304.1751 [tel:559.304.1751] C
> >
> >
> > Oh, that's so painful; know that we feel your pain!
> >
> > If you use a sql backend (sqlite is certainly the easiest to set up), it
> saves everything you do as you do it. This means two things: you won't have
> the catastrophe that you described, and you can't back out of changes by
> closing without saving. Either way, you'll want to take periodic backup
> "snapshots" of your books.
> >
> > ---
> > This email has been checked for viruses by Avast antivirus software.
> > https://www.avast.com/antivirus
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: importing

[Buddha Buck]

It's entirely possible that Frank has a "mybooks.gnucash" file that doesn't
have everything, and a bunch of "mybooks.gnucash..gnucash" files
which have (incrementally) more of everything, as well as the "*.log" files
which go along with them, but beign a new user doesn't realize what those
timestamped autosave files are.


On Mon, Oct 9, 2017 at 11:32 AM Colin Law  wrote:

> On 9 October 2017 at 16:13, frank raney  wrote:
> > I thought it did something like that..I usually do save periodically
> when working for long periods,  But I got so involved, I forgot.How do
> I get/install an sql backend.
>
> I thought the default was to auto-save every 5 minutes or something.
> Are you absolutely certain that you have lost everything? Are you sure
> you are looking at the correct file?
>
> Colin
>
> >
> >
> > Frankie Raney
> > 12454 Auberry Rd.
> > Clovis, Ca.
> > 559.297.8577 <(559)%20297-8577> H
> > 559.304.1751 <(559)%20304-1751> C
> > On 10/9/2017 6:43:14 AM, Aaron Laws  wrote:
> > On Sun, Oct 8, 2017 at 9:27 PM, frank raney  [mailto:frankraney...@gmail.com]> wrote:
> >
> > Just finished 6 hours correcting all the data i imported and before I
> could save it, the program crashed. All I have is the unchanged imported
> data fileWhen it crashed, the file was lost but there is a log
> file..what it is I don't know.  Guess I have to start all over?
> >
> >
> > Frankie Raney
> > 12454 Auberry Rd.
> > Clovis, Ca.
> > 559.297.8577 <(559)%20297-8577> [tel:559.297.8577 <(559)%20297-8577>] H
> > 559.304.1751 <(559)%20304-1751> [tel:559.304.1751 <(559)%20304-1751>] C
> >
> >
> > Oh, that's so painful; know that we feel your pain!
> >
> > If you use a sql backend (sqlite is certainly the easiest to set up), it
> saves everything you do as you do it. This means two things: you won't have
> the catastrophe that you described, and you can't back out of changes by
> closing without saving. Either way, you'll want to take periodic backup
> "snapshots" of your books.
> >
> > ---
> > This email has been checked for viruses by Avast antivirus software.
> > https://www.avast.com/antivirus
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > 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
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: importing

[frank raney]

I thought it did something like that..I usually do save periodically when 
working for long periods,  But I got so involved, I forgot.How do I 
get/install an sql backend.


Frankie Raney
12454 Auberry Rd.
Clovis, Ca.
559.297.8577 H
559.304.1751 C
On 10/9/2017 6:43:14 AM, Aaron Laws  wrote:
On Sun, Oct 8, 2017 at 9:27 PM, frank raney  wrote:

Just finished 6 hours correcting all the data i imported and before I could 
save it, the program crashed. All I have is the unchanged imported data 
fileWhen it crashed, the file was lost but there is a log 
file..what it is I don't know.  Guess I have to start all over?


Frankie Raney
12454 Auberry Rd.
Clovis, Ca.
559.297.8577 [tel:559.297.8577] H
559.304.1751 [tel:559.304.1751] C


Oh, that's so painful; know that we feel your pain!

If you use a sql backend (sqlite is certainly the easiest to set up), it saves 
everything you do as you do it. This means two things: you won't have the 
catastrophe that you described, and you can't back out of changes by closing 
without saving. Either way, you'll want to take periodic backup "snapshots" of 
your books.

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: importing

[David Carlson]

Frank,

I just tried the QIF importer on a tiny file that I had laying around.  For
this test I was using release 2.6.15 in Windows.

I found that the QIF importer is somewhat tedious to use initially until it
has some history in it's memory from previous imports.  After several steps
of finding the correct account names to import into, it does have a step to
find possible matches of existing transactions to new incoming
transactions.  A good reason to take baby steps here is that you may need
to remember what the transactions looked like in Quicken to be good at
making the correct matches.  Once you have some history imported correctly,
it should get easier to import more history without accidentally letting
too many duplicates through.  When you see the data you may find that
certain transactions in your Quicken file would import better if they were
changed in Quicken before being exported.  I recall that around 2005 or a
little later it was possible to export single accounts and limited time
intervals from Quicken, which helped me then.  I know that Quicken has
changed a lot since then and that may not be possible any more.


David C


On Sun, Oct 8, 2017 at 10:24 PM, David Carlson 
wrote:

> Frank,
>
> Sorry to hear about that misfortune.
>
> Theoretically you you can use file > replay log and that may get you close
> to where it was before it crashed, but in your case that may not be your
> best choice.
>
> I suggest writing up your experiences so far to learning about some of the
> mistakes that Gnucash is not very good at protecting users from making.
>
> That said, you can establish procedures to avoid those mistakes, and I
> think that if you do that and continue with Gnucash it can probably meet
> your needs.
>
> You have now learned that you should save your d ata file often, perhaps
> every five minutes.
>
> When learning how the import process works, it is wise to start with baby
> steps, perhaps starting over several times when you are not getting the
> desired results.
>
> As David T suggested, you may find it helpful to make changes to your
> Quicken data before exporting to QIF.
>
> Good luck.
>
> David C
>
> On Oct 8, 2017 8:27 PM, "frank raney"  wrote:
>
> Just finished 6 hours correcting all the data i imported and before I
> could save it, the program crashed. All I have is the unchanged imported
> data fileWhen it crashed, the file was lost but there is a log
> file..what it is I don't know.  Guess I have to start all over?
>
> *Frankie Raney*
> *12454 Auberry Rd.
> *
> *Clovis, Ca
> .*
> *559.297.8577 <(559)%20297-8577> H*
> *559.304.1751 <(559)%20304-1751> C*
>
> On 10/7/2017 7:15:37 PM, David Carlson 
> wrote:
> Frank,
>
> I did not mean to imply that it worked better then, but it may have worked
> differently in older releases.  In any case, if you went that far back,
> there are some file compatibility issues to be concerned with.  I do recall
> being irritated with the fact that the QIF importer failed to import memos
> in split transactions, and I think that has been fixed.
>
> The main thing is that neither David T nor I recall having a significant
> problem avoiding the potential duplicate transactions that could arise if
> the user does not know the best procedure (as you have seen).
>
> David C
>
> On Sat, Oct 7, 2017 at 6:55 PM, frank raney 
> wrote:
>
>>
>>
>> *Frankie Raney*
>> *If it worked good in 2.2, then maybe I can get that version, try it and
>> if it works good, then upgrade.*
>>
>> On 10/7/2017 4:45:51 PM, David Carlson 
>> wrote:
>> Frank and David T,
>>
>> I believe that the QIF importer may not work exactly the same way that it
>> did back in the 2.2 series or the 2.4 series  or even the 2.6 series before
>> release 2.6.18.
>>
>> If that is the c as e  then we really do need someone who is familiar
>> with the way it works now to jump in and help.
>>
>> David C
>>
>> On Oct 7, 2017 3:18 PM, "frank raney"  wrote:
>>
>> I did import all at once..don't know yet how to export individual
>> accounts from Quicken..
>>
>>
>> Frankie Raney
>>
>> On 10/7/2017 7:46:05 AM, David T.  wrote:
>> Frank,
>>
>> The *other* David suggested importing each account separately; I was
>> suggesting importing all at once. In my (admittedly ancient) experience, I
>> worked to get the Quicken data just so, and when I imported everything, I
>> had little to no duplicates.
>>
>> David (T.)
>>
>> On Oct 7, 2017, at 7:17 PM, Frankie Raney > [mailto:frankraney...@gmail.com]> wrote:
>>
>> You are right as to what is being done When I import, it sees the
>> duplicates, but there are hundredsit would take forever to Mark
>> 

Re: importing

[David Carlson]

Frank and David T,

I believe that the QIF importer may not work exactly the same way that it
did back in the 2.2 series or the 2.4 series  or even the 2.6 series before
release 2.6.18.

If that is the c as e  then we really do need someone who is familiar with
the way it works now to jump in and help.

David C

On Oct 7, 2017 3:18 PM, "frank raney"  wrote:

I did import all at once..don't know yet how to export individual
accounts from Quicken..


Frankie Raney

On 10/7/2017 7:46:05 AM, David T.  wrote:
Frank,

The *other* David suggested importing each account separately; I was
suggesting importing all at once. In my (admittedly ancient) experience, I
worked to get the Quicken data just so, and when I imported everything, I
had little to no duplicates.

David (T.)

On Oct 7, 2017, at 7:17 PM, Frankie Raney  wrote:

You are right as to what is being done When I import, it sees the
duplicates, but there are hundredsit would take forever to Mark
themI do not know how to export just one account at a timeI could
try to figure it out and try that way I guess.

On Oct 6, 2017 8:34 PM, "D" 
wrote:

Frank,
Like the other David, on the other thread, it has been a while since I
imported from Quicken. When I did, I was able to bring in everything in one
huge pass. Gnucash properly created the many accounts and captured most of
the transfers as well.
Are you exporting each account from Quicken separately? It sounds as if you
are getting both sides of your transactions, i.e., the transfer payment
from checking to your credit card is being processed once for the checking
and once for the credit card. If this is what is happening for you, then
there are two solutions: either match the second version to the first
during the import process, or don't import the second transaction.
I seem to recall that I didn't have to do much manual massage to my large
quicken file when I imported way back when, so I believe that exporting the
whole file (accounts, categories and transactions for it all) will catch
those duplications. But I've been known to be wrong before.
David T.
On October 7, 2017, at 6:24 AM, frank raney  wrote:
>I thought I had the importing figured out, but no...
>I exported my quicken data to qif format.  When I import it into GC I get
a lot of double entries.  Quicken uses catagories, GC uses accounts... How
do I import my cash accounts without getting all the duplicates.
>My checking account imports as do all my categories to the same accounts
in GC.  I am given a list of possible duplicates, but it will take days to
go through this.  Isn't there a way import without sorting through the
list?  If I do not go through the list (just import everything as is, I end
up with every account with double entries, double money.
>I am trying to get away from quicken because of all the troubles they are
having, but now I wonder if it is worth it.  I am always for programs like
GC, but sometimes they are very cumbersome, like this appears to be.  What
am I missing?
>Frankie Raney
>12454 Auberry Rd. [https://maps.google.com/?q=12454+Auberry+Rd.+%3EClovis,+
Caentry=gmailsource=g]
[https://maps.google.com/?q=12454+Auberry+Rd.+%3EClovis,+
Caentry=gmailsource=g]>Clovis, Ca [https://maps.google.com/?q=
12454+Auberry+Rd.+%3EClovis,+Caentry=gmailsource=g].
>559.297.8577 [tel:(559)%20297-8577] H
>559.304.1751 [tel:(559)%20304-1751] C
>---
>This email has been checked for viruses by Avast antivirus software.
>https://www.avast.com/antivirus [https://www.avast.com/antivirus]
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org [mailto:gnucash-user@gnucash.org]
>https://lists.gnucash.org/mailman/listinfo/gnucash-user [
https://lists.gnucash.org/mailman/listinfo/gnucash-user]
>-
>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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: importing

[frank raney]

Frankie Raney
If it worked good in 2.2, then maybe I can get that version, try it and if it 
works good, then upgrade.
On 10/7/2017 4:45:51 PM, David Carlson  wrote:
Frank and David T,

I believe that the QIF importer may not work exactly the same way that it did 
back in the 2.2 series or the 2.4 series  or even the 2.6 series before release 
2.6.18.

If that is the c as e  then we really do need someone who is familiar with the 
way it works now to jump in and help.

David C 

On Oct 7, 2017 3:18 PM, "frank raney"  wrote:

I did import all at once..don't know yet how to export individual accounts 
from Quicken..


Frankie Raney


On 10/7/2017 7:46:05 AM, David T.  wrote:
Frank,

The *other* David suggested importing each account separately; I was suggesting 
importing all at once. In my (admittedly ancient) experience, I worked to get 
the Quicken data just so, and when I imported everything, I had little to no 
duplicates.

David (T.)


On Oct 7, 2017, at 7:17 PM, Frankie Raney  wrote:

You are right as to what is being done When I import, it sees the 
duplicates, but there are hundredsit would take forever to Mark themI 
do not know how to export just one account at a timeI could try to figure 
it out and try that way I guess.

On Oct 6, 2017 8:34 PM, "D"  wrote:

Frank,
Like the other David, on the other thread, it has been a while since I imported 
from Quicken. When I did, I was able to bring in everything in one huge pass. 
Gnucash properly created the many accounts and captured most of the transfers 
as well.
Are you exporting each account from Quicken separately? It sounds as if you are 
getting both sides of your transactions, i.e., the transfer payment from 
checking to your credit card is being processed once for the checking and once 
for the credit card. If this is what is happening for you, then there are two 
solutions: either match the second version to the first during the import 
process, or don't import the second transaction.
I seem to recall that I didn't have to do much manual massage to my large 
quicken file when I imported way back when, so I believe that exporting the 
whole file (accounts, categories and transactions for it all) will catch those 
duplications. But I've been known to be wrong before.
David T.
On October 7, 2017, at 6:24 AM, frank raney  wrote:
>I thought I had the importing figured out, but no...
>I exported my quicken data to qif format.  When I import it into GC I get a 
>lot of double entries.  Quicken uses catagories, GC uses accounts... How do I 
>import my cash accounts without getting all the duplicates.
>My checking account imports as do all my categories to the same accounts in 
>GC.  I am given a list of possible duplicates, but it will take days to go 
>through this.  Isn't there a way import without sorting through the list?  If 
>I do not go through the list (just import everything as is, I end up with 
>every account with double entries, double money.  
>I am trying to get away from quicken because of all the troubles they are 
>having, but now I wonder if it is worth it.  I am always for programs like GC, 
>but sometimes they are very cumbersome, like this appears to be.  What am I 
>missing?
>Frankie Raney

>12454 Auberry Rd. 
>[https://maps.google.com/?q=12454+Auberry+Rd.+%3EClovis,+Caentry=gmailsource=g
> 
>[https://maps.google.com/?q=12454+Auberry+Rd.+%3EClovis,+Caamp;entry=gmailamp;source=g]]
[https://maps.google.com/?q=12454+Auberry+Rd.+%3EClovis,+Caentry=gmailsource=g
 
[https://maps.google.com/?q=12454+Auberry+Rd.+%3EClovis,+Caamp;entry=gmailamp;source=g]]>Clovis,
 Ca 
[https://maps.google.com/?q=12454+Auberry+Rd.+%3EClovis,+Caentry=gmailsource=g
 
[https://maps.google.com/?q=12454+Auberry+Rd.+%3EClovis,+Caamp;entry=gmailamp;source=g]].

>559.297.8577 [tel:559.297.8577] [tel:(559)%20297-8577] H
>559.304.1751 [tel:559.304.1751] [tel:(559)%20304-1751] C
>---
>This email has been checked for viruses by Avast antivirus software.
>https://www.avast.com/antivirus [https://www.avast.com/antivirus] 
>[https://www.avast.com/antivirus [https://www.avast.com/antivirus]]
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org [mailto:gnucash-user@gnucash.org] 
>[mailto:gnucash-user@gnucash.org [mailto:gnucash-user@gnucash.org]]
>https://lists.gnucash.org/mailman/listinfo/gnucash-user 
>[https://lists.gnucash.org/mailman/listinfo/gnucash-user] 

Re: importing

[David Carlson]

Frank,

I did not mean to imply that it worked better then, but it may have worked
differently in older releases.  In any case, if you went that far back,
there are some file compatibility issues to be concerned with.  I do recall
being irritated with the fact that the QIF importer failed to import memos
in split transactions, and I think that has been fixed.

The main thing is that neither David T nor I recall having a significant
problem avoiding the potential duplicate transactions that could arise if
the user does not know the best procedure (as you have seen).

David C

On Sat, Oct 7, 2017 at 6:55 PM, frank raney  wrote:

>
>
> *Frankie Raney*
> *If it worked good in 2.2, then maybe I can get that version, try it and
> if it works good, then upgrade.*
>
> On 10/7/2017 4:45:51 PM, David Carlson 
> wrote:
> Frank and David T,
>
> I believe that the QIF importer may not work exactly the same way that it
> did back in the 2.2 series or the 2.4 series  or even the 2.6 series before
> release 2.6.18.
>
> If that is the c as e  then we really do need someone who is familiar
> with the way it works now to jump in and help.
>
> David C
>
> On Oct 7, 2017 3:18 PM, "frank raney"  wrote:
>
> I did import all at once..don't know yet how to export individual
> accounts from Quicken..
>
>
> Frankie Raney
>
> On 10/7/2017 7:46:05 AM, David T.  wrote:
> Frank,
>
> The *other* David suggested importing each account separately; I was
> suggesting importing all at once. In my (admittedly ancient) experience, I
> worked to get the Quicken data just so, and when I imported everything, I
> had little to no duplicates.
>
> David (T.)
>
> On Oct 7, 2017, at 7:17 PM, Frankie Raney  [mailto:frankraney...@gmail.com]> wrote:
>
> You are right as to what is being done When I import, it sees the
> duplicates, but there are hundredsit would take forever to Mark
> themI do not know how to export just one account at a timeI could
> try to figure it out and try that way I guess.
>
> On Oct 6, 2017 8:34 PM, "D"  sunfis...@yahoo.com]> wrote:
>
> Frank,
> Like the other David, on the other thread, it has been a while since I
> imported from Quicken. When I did, I was able to bring in everything in one
> huge pass. Gnucash properly created the many accounts and captured most of
> the transfers as well.
> Are you exporting each account from Quicken separately? It sounds as if
> you are getting both sides of your transactions, i.e., the transfer payment
> from checking to your credit card is being processed once for the checking
> and once for the credit card. If this is what is happening for you, then
> there are two solutions: either match the second version to the first
> during the import process, or don't import the second transaction.
> I seem to recall that I didn't have to do much manual massage to my large
> quicken file when I imported way back when, so I believe that exporting the
> whole file (accounts, categories and transactions for it all) will catch
> those duplications. But I've been known to be wrong before.
> David T.
> On October 7, 2017, at 6:24 AM, frank raney  [mailto:frankraney...@gmail.com]> wrote:
> >I thought I had the importing figured out, but no...
> >I exported my quicken data to qif format.  When I import it into GC I get
> a lot of double entries.  Quicken uses catagories, GC uses accounts... How
> do I import my cash accounts without getting all the duplicates.
> >My checking account imports as do all my categories to the same accounts
> in GC.  I am given a list of possible duplicates, but it will take days to
> go through this.  Isn't there a way import without sorting through the
> list?  If I do not go through the list (just import everything as is, I end
> up with every account with double entries, double money.
> >I am trying to get away from quicken because of all the troubles they are
> having, but now I wonder if it is worth it.  I am always for programs like
> GC, but sometimes they are very cumbersome, like this appears to be.  What
> am I missing?
> >Frankie Raney
> >12454 Auberry Rd
> . [
> https://maps.google.com/?q=12454+Auberry+Rd.+%3EClovis,+Ca;
> amp;entry=gmailsource=g]
> [https://maps.google.com/?q=12454+Auberry+Rd.+%3EClovis,+Ca;
> amp;entry=gmailsource=g]>Clovis, Ca [https://maps.google.com/?q=12
> 454+Auberry+Rd.+%3EClovis,+Caentry=gmailsource=g].
> >559.297.8577 [tel:(559)%20297-8577] H
> >559.304.1751 [tel:(559)%20304-1751] C
> >---
> >This email has been checked for viruses by Avast antivirus software.
> >https://www.avast.com/antivirus [https://www.avast.com/antivirus]
> >___
> >gnucash-user mailing list
> >gnucash-user@gnucash.org [mailto:gnucash-user@gnucash.org]
> 

Re: importing

[frank raney]

I did import all at once..don't know yet how to export individual accounts 
from Quicken..


Frankie Raney

On 10/7/2017 7:46:05 AM, David T.  wrote:
Frank,

The *other* David suggested importing each account separately; I was suggesting 
importing all at once. In my (admittedly ancient) experience, I worked to get 
the Quicken data just so, and when I imported everything, I had little to no 
duplicates.

David (T.)

On Oct 7, 2017, at 7:17 PM, Frankie Raney  wrote:

You are right as to what is being done When I import, it sees the 
duplicates, but there are hundredsit would take forever to Mark themI 
do not know how to export just one account at a timeI could try to figure 
it out and try that way I guess.

On Oct 6, 2017 8:34 PM, "D"  
wrote:

Frank,
Like the other David, on the other thread, it has been a while since I imported 
from Quicken. When I did, I was able to bring in everything in one huge pass. 
Gnucash properly created the many accounts and captured most of the transfers 
as well.
Are you exporting each account from Quicken separately? It sounds as if you are 
getting both sides of your transactions, i.e., the transfer payment from 
checking to your credit card is being processed once for the checking and once 
for the credit card. If this is what is happening for you, then there are two 
solutions: either match the second version to the first during the import 
process, or don't import the second transaction.
I seem to recall that I didn't have to do much manual massage to my large 
quicken file when I imported way back when, so I believe that exporting the 
whole file (accounts, categories and transactions for it all) will catch those 
duplications. But I've been known to be wrong before.
David T.
On October 7, 2017, at 6:24 AM, frank raney  wrote:
>I thought I had the importing figured out, but no...
>I exported my quicken data to qif format.  When I import it into GC I get a 
>lot of double entries.  Quicken uses catagories, GC uses accounts... How do I 
>import my cash accounts without getting all the duplicates.
>My checking account imports as do all my categories to the same accounts in 
>GC.  I am given a list of possible duplicates, but it will take days to go 
>through this.  Isn't there a way import without sorting through the list?  If 
>I do not go through the list (just import everything as is, I end up with 
>every account with double entries, double money.  
>I am trying to get away from quicken because of all the troubles they are 
>having, but now I wonder if it is worth it.  I am always for programs like GC, 
>but sometimes they are very cumbersome, like this appears to be.  What am I 
>missing?
>Frankie Raney
>12454 Auberry Rd. 
>[https://maps.google.com/?q=12454+Auberry+Rd.+%3EClovis,+Caentry=gmailsource=g]
[https://maps.google.com/?q=12454+Auberry+Rd.+%3EClovis,+Caentry=gmailsource=g]>Clovis,
 Ca 
[https://maps.google.com/?q=12454+Auberry+Rd.+%3EClovis,+Caentry=gmailsource=g].
>559.297.8577 [tel:(559)%20297-8577] H
>559.304.1751 [tel:(559)%20304-1751] C
>---
>This email has been checked for viruses by Avast antivirus software.
>https://www.avast.com/antivirus [https://www.avast.com/antivirus]
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org [mailto:gnucash-user@gnucash.org]
>https://lists.gnucash.org/mailman/listinfo/gnucash-user 
>[https://lists.gnucash.org/mailman/listinfo/gnucash-user]
>-
>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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: importing

[David T. via gnucash-user]

Frank,

The *other* David suggested importing each account separately; I was suggesting 
importing all at once. In my (admittedly ancient) experience, I worked to get 
the Quicken data just so, and when I imported everything, I had little to no 
duplicates.

David (T.)

> On Oct 7, 2017, at 7:17 PM, Frankie Raney  wrote:
> 
> You are right as to what is being done When I import, it sees the 
> duplicates, but there are hundredsit would take forever to Mark themI 
> do not know how to export just one account at a timeI could try to figure 
> it out and try that way I guess.
> 
> On Oct 6, 2017 8:34 PM, "D"  > wrote:
> Frank,
> 
> Like the other David, on the other thread, it has been a while since I 
> imported from Quicken. When I did, I was able to bring in everything in one 
> huge pass. Gnucash properly created the many accounts and captured most of 
> the transfers as well.
> 
> Are you exporting each account from Quicken separately? It sounds as if you 
> are getting both sides of your transactions, i.e., the transfer payment from 
> checking to your credit card is being processed once for the checking and 
> once for the credit card. If this is what is happening for you, then there 
> are two solutions: either match the second version to the first during the 
> import process, or don't import the second transaction.
> 
> I seem to recall that I didn't have to do much manual massage to my large 
> quicken file when I imported way back when, so I believe that exporting the 
> whole file (accounts, categories and transactions for it all) will catch 
> those duplications. But I've been known to be wrong before.
> 
> David T.
> 
> On October 7, 2017, at 6:24 AM, frank raney  > wrote:
> 
> >I thought I had the importing figured out, but no...
> >I exported my quicken data to qif format.  When I import it into GC I get a 
> >lot of double entries.  Quicken uses catagories, GC uses accounts... How do 
> >I import my cash accounts without getting all the duplicates.
> >My checking account imports as do all my categories to the same accounts in 
> >GC.  I am given a list of possible duplicates, but it will take days to go 
> >through this.  Isn't there a way import without sorting through the list?  
> >If I do not go through the list (just import everything as is, I end up with 
> >every account with double entries, double money.  
> >I am trying to get away from quicken because of all the troubles they are 
> >having, but now I wonder if it is worth it.  I am always for programs like 
> >GC, but sometimes they are very cumbersome, like this appears to be.  What 
> >am I missing?
> >Frankie Raney
> >12454 Auberry Rd. 
> >
>  
> >Clovis,
>  Ca 
> .
> >559.297.8577  H
> >559.304.1751  C
> >---
> >This email has been checked for viruses by Avast antivirus software.
> >https://www.avast.com/antivirus 
> >___
> >gnucash-user mailing list
> >gnucash-user@gnucash.org 
> >https://lists.gnucash.org/mailman/listinfo/gnucash-user 
> >
> >-
> >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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: importing

[Frankie Raney]

You are right as to what is being done When I import, it sees the
duplicates, but there are hundredsit would take forever to Mark
themI do not know how to export just one account at a timeI could
try to figure it out and try that way I guess.

On Oct 6, 2017 8:34 PM, "D"  wrote:

> Frank,
>
> Like the other David, on the other thread, it has been a while since I
> imported from Quicken. When I did, I was able to bring in everything in one
> huge pass. Gnucash properly created the many accounts and captured most of
> the transfers as well.
>
> Are you exporting each account from Quicken separately? It sounds as if
> you are getting both sides of your transactions, i.e., the transfer
> payment from checking to your credit card is being processed once for the
> checking and once for the credit card. If this is what is happening for
> you, then there are two solutions: either match the second version to the
> first during the import process, or don't import the second transaction.
>
> I seem to recall that I didn't have to do much manual massage to my large
> quicken file when I imported way back when, so I believe that exporting the
> whole file (accounts, categories and transactions for it all) will catch
> those duplications. But I've been known to be wrong before.
>
> David T.
>
> On October 7, 2017, at 6:24 AM, frank raney 
> wrote:
>
> >I thought I had the importing figured out, but no...
> >I exported my quicken data to qif format.  When I import it into GC I get
> a lot of double entries.  Quicken uses catagories, GC uses accounts... How
> do I import my cash accounts without getting all the duplicates.
> >My checking account imports as do all my categories to the same accounts
> in GC.  I am given a list of possible duplicates, but it will take days to
> go through this.  Isn't there a way import without sorting through the
> list?  If I do not go through the list (just import everything as is, I end
> up with every account with double entries, double money.
> >I am trying to get away from quicken because of all the troubles they are
> having, but now I wonder if it is worth it.  I am always for programs like
> GC, but sometimes they are very cumbersome, like this appears to be.  What
> am I missing?
> >Frankie Raney
> >12454 Auberry Rd.
> 
>
> 
> >Clovis, Ca
> 
> .
> >559.297.8577 <(559)%20297-8577> H
> >559.304.1751 <(559)%20304-1751> C
> >---
> >This email has been checked for viruses by Avast antivirus software.
> >https://www.avast.com/antivirus
> >___
> >gnucash-user mailing list
> >gnucash-user@gnucash.org
> >https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >-
> >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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: importing

[D via gnucash-user]

Frank,

Like the other David, on the other thread, it has been a while since I imported 
from Quicken. When I did, I was able to bring in everything in one huge pass. 
Gnucash properly created the many accounts and captured most of the transfers 
as well. 

Are you exporting each account from Quicken separately? It sounds as if you are 
getting both sides of your transactions, i.e., the transfer payment from 
checking to your credit card is being processed once for the checking and once 
for the credit card. If this is what is happening for you, then there are two 
solutions: either match the second version to the first during the import 
process, or don't import the second transaction.

I seem to recall that I didn't have to do much manual massage to my large 
quicken file when I imported way back when, so I believe that exporting the 
whole file (accounts, categories and transactions for it all) will catch those 
duplications. But I've been known to be wrong before.

David T.

On October 7, 2017, at 6:24 AM, frank raney  wrote:

>I thought I had the importing figured out, but no...
>I exported my quicken data to qif format.  When I import it into GC I get a 
>lot of double entries.  Quicken uses catagories, GC uses accounts... How do I 
>import my cash accounts without getting all the duplicates.
>My checking account imports as do all my categories to the same accounts in 
>GC.  I am given a list of possible duplicates, but it will take days to go 
>through this.  Isn't there a way import without sorting through the list?  If 
>I do not go through the list (just import everything as is, I end up with 
>every account with double entries, double money.  
>I am trying to get away from quicken because of all the troubles they are 
>having, but now I wonder if it is worth it.  I am always for programs like GC, 
>but sometimes they are very cumbersome, like this appears to be.  What am I 
>missing?
>Frankie Raney
>12454 Auberry Rd.
>Clovis, Ca.
>559.297.8577 H
>559.304.1751 C
>---
>This email has been checked for viruses by Avast antivirus software.
>https://www.avast.com/antivirus
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Importing bookings with accounts fully assigned

[Cornelis Bockemühl]

Good evening, ;-)

That sounds indeed like exactly the thing that I would need!

However, I already tried a bit with the QIF format, reading the manual,
then trying to manually fabricate some QIF file exactly with that
intention - with no success so far.

So if you have any knowledge of that format: Would you be able to just
fabricate a little example file with one booking record in the way that
you describe?

I would be more than happy if you could do this!

I think with this I would be more or less "done": First generate that
table that I described, then write some (probably easy) conversion from
the table to QIF - and import!

With thanks and regards,

Cornelis


Am 18.08.2017 um 17:05 schrieb Derek Atkins:
> Cornelis Bockemühl  writes:
>
>> Good morning,
>>
>> Does anybody know a way or a specific data format that allows to import
>> bookings into Gnucash that have already their "counter booking"
>> (probably not the correct bookkeeper's language...)?
> QIF supports this by using the LCategory or L[Account] features to
> specify the QIF Category (Income/Expense) or the QIF Account
> (Asset/Liability) of the "other" account.
>
> The importer will allow you to map the QIF Categories and QIF Accounts
> to GnuCash Accounts.  The names do not need to match, although it's
> obviously easier if they do.
>
>> Example: I have a list of bookings somehow like the following:
>>
>> Date  Amount  Text   Account from  
>> Account to
>> 
>> 11-08-2017 25.70  Birthday gift  Giro  
>> Gifts
>> 24-08-2017   2000.00  Salary for August  Salary
>> Bankaccount
>>
>> etc. etc.
>>
>> Of course the accounts "Giro", "Gifts", "Salary" and "Bankaccount"
>> should exist in Gnucash already.
> The accounts don't actually need to exist; the QIF importer will create
> them if they don't.
>
>> So far I always prepare several lists, two for each of the main bank
>> accounts, then I import them as CSV and then I have to more or less
>> assign the "counter booking" for each single like manually because even
>> after a couple of years the automatic assignment does not really do a
>> really useful job.
>>
>> Any idea or proposal?
> Use QIF?
>
>> Thanks and regards, Cornelis
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> -derek
>



0x91FAB8DE.asc
Description: application/pgp-keys


signature.asc
Description: OpenPGP digital signature
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.