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 <ke...@worlebury.co.uk> 
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.

: importing

[Beri Hull]

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.

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 <david.carlson@gmail.com
> 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 <edwardingram...@gmail.com
> > 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 <edwardingram...@gmail.com>
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 <py...@cox.net> 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 <gnucash-user-bounces+pyz01=cox@gnucash.org> 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 <gnucash-user-bounces+pyz01=cox@gnucash.org> 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" <el...@dogonfire.com 
<mailto:el...@dogonfire.com>> 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 <mailto:gnucash-user@gnucash.org>
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists
<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" <el...@dogonfire.com> 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 <j...@p27.eu> 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 <j...@p27.eu>
> > 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 

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 <j...@p27.eu>
> 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 <j...@p27.eu>
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: Headers for importing accounts from CSV

[Adrien Monteleone]

Sorry,

I don’t use that feature at all, so I’ll have to defer.

Try a google search on the list with “site:lists.gnucash.org” (without the 
quotes) followed by your search terms. You’ll get hits only from the list 
archives. There are many threads on OFX and AqWizard and I doubt you’re the 
first to stumble on this so someone may have a solution buried in past threads.

Also, please be sure to copy the list on all replies for non-personal messages 
as others may benefit from the discussion.

Regards,
Adrien

> On Feb 15, 2018, at 5:30 PM, Holly Ochidi  wrote:
> 
> Adrien, 
> 
> Any advice on setting up OFX import via AqWizard for a bank that is not 
> listed?
> 
> 
> Regards,
> 
> Holly Ochidi
> 
> On Thu, Feb 15, 2018 at 5:24 PM, Holly Ochidi  wrote:
> Sweet! What a simple solution... Can't believe I didn't think of trying to 
> make an account then export it. Setting up all the accounts I need one by one 
> is painful. Thanks for the info!
> 
> 
> Regards,
> 
> Holly Ochidi
> 
> On Thu, Feb 15, 2018 at 4:49 PM, Adrien Monteleone 
>  wrote:
> Sorry, I forgot to mention that in the hidden and place_holder columns, the 
> export shows ‘F’ and ‘T’ so those should work, but if not, using or 0 or 1 
> should suffice.
> 
> The tax column also appears to be binary. I think the setting is just a check 
> box for each account that asks “Tax Related?” so that makes sense. But I know 
> the tax report setup is more complicated and likely that data lies somewhere 
> else. Even after the import, you’ll likely have to set that up separately.
> 
> 
> Regards,
> Adrien
> 
> > On Feb 15, 2018, at 4:45 PM, Adrien Monteleone 
> >  wrote:
> >
> > Holly,
> >
> > I’m relying on what I see from an export, but here’s something that might 
> > help:
> >
> > ‘full_name' is the entire tree path, so 'Assets:Current Assets:Cash In 
> > Wallet'
> >
> > where ‘name’ is just ‘Cash In Wallet’
> >
> > All of my ‘commoditym’ fields contain ‘USD’ and all of my ‘commodityn’ 
> > fields contain ‘CURRENCY’ if that helps.
> >
> > I see the export doesn’t include trading accounts so I can’t help with what 
> > the other options are for ‘commodityn’. My suspicion would be it is used 
> > for stocks or mutual funds. (STOCK and FUND respectively would be the 
> > likely data)
> >
> > I tried looking for an explanation of the fields online, but haven’t 
> > managed to find them yet.
> >
> >
> > Regards,
> > Adrien
> >
> >> On Feb 15, 2018, at 1:28 PM, Holly Ochidi  wrote:
> >>
> >> [image: Inline image 1]
> >>
> >> Kindly, please describe the column headers and where the data points to:
> >>
> >> name vs. full_name
> >> commoditym
> >> commodityn
> >>
> >> I have attempted to use the following entries for "commoditym" and
> >> "commodityn" without success:
> >> USD
> >> US Dollar
> >>
> >> Also, I assume the columns "hidden" and "place_holder" should hold a TRUE
> >> or FALSE? or should it be a "0" or "1"?
> >>
> >> Also, what values can I put under the "tax" column to automatically create
> >> accounts with the correct Income Tax account designations?
> >>
> >> I believe I understand the remaining columns.
> >>
> >> Much appreciation!
> >>
> >> Regards,
> >>
> >> Holly Ochidi
> >> ___
> >> 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: Headers for importing accounts from CSV

[Holly Ochidi]

Sweet! What a simple solution... Can't believe I didn't think of trying to
make an account then export it. Setting up all the accounts I need one by
one is painful. Thanks for the info!


Regards,

Holly Ochidi

On Thu, Feb 15, 2018 at 4:49 PM, Adrien Monteleone <
adrien.montele...@gmail.com> wrote:

> Sorry, I forgot to mention that in the hidden and place_holder columns,
> the export shows ‘F’ and ‘T’ so those should work, but if not, using or 0
> or 1 should suffice.
>
> The tax column also appears to be binary. I think the setting is just a
> check box for each account that asks “Tax Related?” so that makes sense.
> But I know the tax report setup is more complicated and likely that data
> lies somewhere else. Even after the import, you’ll likely have to set that
> up separately.
>
>
> Regards,
> Adrien
>
> > On Feb 15, 2018, at 4:45 PM, Adrien Monteleone <
> adrien.montele...@gmail.com> wrote:
> >
> > Holly,
> >
> > I’m relying on what I see from an export, but here’s something that
> might help:
> >
> > ‘full_name' is the entire tree path, so 'Assets:Current Assets:Cash In
> Wallet'
> >
> > where ‘name’ is just ‘Cash In Wallet’
> >
> > All of my ‘commoditym’ fields contain ‘USD’ and all of my ‘commodityn’
> fields contain ‘CURRENCY’ if that helps.
> >
> > I see the export doesn’t include trading accounts so I can’t help with
> what the other options are for ‘commodityn’. My suspicion would be it is
> used for stocks or mutual funds. (STOCK and FUND respectively would be the
> likely data)
> >
> > I tried looking for an explanation of the fields online, but haven’t
> managed to find them yet.
> >
> >
> > Regards,
> > Adrien
> >
> >> On Feb 15, 2018, at 1:28 PM, Holly Ochidi  wrote:
> >>
> >> [image: Inline image 1]
> >>
> >> Kindly, please describe the column headers and where the data points to:
> >>
> >> name vs. full_name
> >> commoditym
> >> commodityn
> >>
> >> I have attempted to use the following entries for "commoditym" and
> >> "commodityn" without success:
> >> USD
> >> US Dollar
> >>
> >> Also, I assume the columns "hidden" and "place_holder" should hold a
> TRUE
> >> or FALSE? or should it be a "0" or "1"?
> >>
> >> Also, what values can I put under the "tax" column to automatically
> create
> >> accounts with the correct Income Tax account designations?
> >>
> >> I believe I understand the remaining columns.
> >>
> >> Much appreciation!
> >>
> >> Regards,
> >>
> >> Holly Ochidi
> >> ___
> >> 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: Headers for importing accounts from CSV

[Adrien Monteleone]

Sorry, I forgot to mention that in the hidden and place_holder columns, the 
export shows ‘F’ and ‘T’ so those should work, but if not, using or 0 or 1 
should suffice.

The tax column also appears to be binary. I think the setting is just a check 
box for each account that asks “Tax Related?” so that makes sense. But I know 
the tax report setup is more complicated and likely that data lies somewhere 
else. Even after the import, you’ll likely have to set that up separately.


Regards,
Adrien

> On Feb 15, 2018, at 4:45 PM, Adrien Monteleone  
> wrote:
> 
> Holly,
> 
> I’m relying on what I see from an export, but here’s something that might 
> help:
> 
> ‘full_name' is the entire tree path, so 'Assets:Current Assets:Cash In Wallet'
> 
> where ‘name’ is just ‘Cash In Wallet’
> 
> All of my ‘commoditym’ fields contain ‘USD’ and all of my ‘commodityn’ fields 
> contain ‘CURRENCY’ if that helps.
> 
> I see the export doesn’t include trading accounts so I can’t help with what 
> the other options are for ‘commodityn’. My suspicion would be it is used for 
> stocks or mutual funds. (STOCK and FUND respectively would be the likely data)
> 
> I tried looking for an explanation of the fields online, but haven’t managed 
> to find them yet.
> 
> 
> Regards,
> Adrien
> 
>> On Feb 15, 2018, at 1:28 PM, Holly Ochidi  wrote:
>> 
>> [image: Inline image 1]
>> 
>> Kindly, please describe the column headers and where the data points to:
>> 
>> name vs. full_name
>> commoditym
>> commodityn
>> 
>> I have attempted to use the following entries for "commoditym" and
>> "commodityn" without success:
>> USD
>> US Dollar
>> 
>> Also, I assume the columns "hidden" and "place_holder" should hold a TRUE
>> or FALSE? or should it be a "0" or "1"?
>> 
>> Also, what values can I put under the "tax" column to automatically create
>> accounts with the correct Income Tax account designations?
>> 
>> I believe I understand the remaining columns.
>> 
>> Much appreciation!
>> 
>> Regards,
>> 
>> Holly Ochidi
>> ___
>> 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: Where does Gnucash keep the list of accounts to match transactions to when importing OFX/QFX

[Christopher Lam]

Hi Clint, the associations are kept within the datafile itself. There's no
current mechanism for modifying these associations, however, the upcoming
version 3.0 will feature an editor.

On 23 Jan 2018 11:16 AM, "Clint Redwood" <cl...@screwtape.co.uk> wrote:

> Hi,
>
> I'm importing a number of transactions, and most repeating transactions
> import fine, but some have incorrect accounts linked and some don't choose.
>
> I seem to remember that there is a file or page somewhere where these
> links are stored, but I can neither find that within Gnucash or a reference
> by googling.
>
> Could someone point me in the right direction please?
>
> Thanks!
>
> Yours,
>
> Clint Redwood
>
> Screwtape Limited, Registered 06663232, Babington House, 26 College Road,
> Chilwell, Nottingham NG9 4AS
>
> ___
> 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.

Where does Gnucash keep the list of accounts to match transactions to when importing OFX/QFX

[Clint Redwood]

Hi,

I'm importing a number of transactions, and most repeating transactions import 
fine, but some have incorrect accounts linked and some don't choose. 

I seem to remember that there is a file or page somewhere where these links are 
stored, but I can neither find that within Gnucash or a reference by googling.

Could someone point me in the right direction please?

Thanks!

Yours,

Clint Redwood 

Screwtape Limited, Registered 06663232, Babington House, 26 College Road, 
Chilwell, Nottingham NG9 4AS

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

Control order of splits importing from QIF?

[Greg Skelhorn]

   Hello,
   I created a QIF file to test importing a payroll transaction. The
   import works well but the splits are ordered differently in the gnucash
   transaction than the QIF file.
   I enter the splits in an order matching the report from the payroll
   software to make it easier to review / check.
   Is it possible to control the order of splits within a transaction
   imported from a QIF file? If not, is there another format I could
   import transactions from that will preserve the order of the splits?
   Thanks!
   Greg
___
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: Crashes importing CSV

[David Carlson]

Hi Phillip

I think that earlier versions would crash if the date format was not
correctly selected.

I am not sure if that has been fixed in the current release.

David C

On Oct 29, 2017 12:42 PM, "Phillip Gotobed" <pgoto...@gmail.com> wrote:

> Hello everyone,
>
> I've been using gnucash for a bit now and had no issues once I started to
> understand things but recently I tried importing CSV files, not for the
> first time, and gnucash crashed. Going through some previous suggestions
> I've tried re-saving the file, adding "," to the end of each line, removing
> extraneous information, etc and nothing seems to work. No matter what it
> crashes after I select which account to import transactions into. I also
> went back to the old file that I had succeeded in importing before to test
> it and that one also crashed the program now. I'm not sure what changed but
> if anyone has suggestions that'd be great; I'm at my end here.
>
> Thanks,
> Phillip
> ___
> 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.

Crashes importing CSV

[Phillip Gotobed]

Hello everyone,

I've been using gnucash for a bit now and had no issues once I started to
understand things but recently I tried importing CSV files, not for the
first time, and gnucash crashed. Going through some previous suggestions
I've tried re-saving the file, adding "," to the end of each line, removing
extraneous information, etc and nothing seems to work. No matter what it
crashes after I select which account to import transactions into. I also
went back to the old file that I had succeeded in importing before to test
it and that one also crashed the program now. I'm not sure what changed but
if anyone has suggestions that'd be great; I'm at my end here.

Thanks,
Phillip
___
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.

Importing Data

[Rick Strupkus]

I have just purchased a new laptop with Windows 10 and am trying to import
the data from my old laptop onto it.  Which files do I look for and how can
I put them on my new machine?

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

[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 <frankraney...@gmail.com> 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 <frankraney...@gmail.com> 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" <clan...@gmail.com 
[mailto:clan...@gmail.com]> 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 <frankraney...@gmail.com 
[mailto:frankraney...@gmail.com]> 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" <ed...@billiau.net [mailto:ed...@billiau.net]> 
> wrote:
>
>> On Mon, 9 Oct 2017 20:39:34 -0700
>> Frankie Raney <frankraney...@gmail.com [mailto:frankraney...@gmail.com]> 
>> 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 <frankraney...@gmail.com> 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" <clan...@gmail.com 
[mailto:clan...@gmail.com]> 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 <frankraney...@gmail.com 
[mailto:frankraney...@gmail.com]> 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" <ed...@billiau.net [mailto:ed...@billiau.net]> 
> wrote:
>
>> On Mon, 9 Oct 2017 20:39:34 -0700
>> Frankie Raney <frankraney...@gmail.com [mailto:frankraney...@gmail.com]> 
>> 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 <frankraney...@gmail.com> 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" <ed...@billiau.net> wrote:
>
>> On Mon, 9 Oct 2017 20:39:34 -0700
>> Frankie Raney <frankraney...@gmail.com> 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" <ed...@billiau.net> wrote:

> On Mon, 9 Oct 2017 20:39:34 -0700
> Frankie Raney <frankraney...@gmail.com> 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 <frankraney...@gmail.com> 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" <clan...@gmail.com> wrote:

> On 9 October 2017 at 16:13, frank raney <frankraney...@gmail.com> 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 <dartm...@gmail.com> wrote:
> > On Sun, Oct 8, 2017 at 9:27 PM, frank raney <frankraney...@gmail.com
> [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 <david.carlson@gmail.com>
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" <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.
> <https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_=gmail=g>*
> *Clovis, Ca
> <https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_=gmail=g>.*
> *559.297.8577 <(559)%20297-8577> H*
> *559.304.1751 <(559)%20304-1751> C*
>
> On 10/7/2017 7:15:37 PM, David Carlson <david.carlson@gmail.com>
> 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 <frankraney...@gmail.com>
> 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 <david.carlson@gmail.com>
>> 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" <frankraney...@gmail.com> 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. <sunfis...@yahoo.com> wrote:
>> Frank,
>>
>> The *other* David suggested importing each account separately; I was
>> su

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" <frankraney...@gmail.com> 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. <sunfis...@yahoo.com> 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 <frankraney...@gmail.com [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 [mailto: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 <frankraney...@gmail.com
[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,+
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 <david.carlson@gmail.com> 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" <frankraney...@gmail.com 
[mailto:frankraney...@gmail.com]> 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. <sunfis...@yahoo.com 
[mailto:sunfis...@yahoo.com]> 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 <frankraney...@gmail.com 
[mailto:frankraney...@gmail.com] [mailto:frankraney...@gmail.com 
[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 [mailto:sunfis...@yahoo.com] 
[mailto:sunfis...@yahoo.com [mailto: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 <frankraney...@gmail.com 
[mailto:frankraney...@gmail.com] [mailto:frankraney...@gmail.com 
[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,+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:

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 <frankraney...@gmail.com> 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 <david.carlson@gmail.com>
> 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" <frankraney...@gmail.com> 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. <sunfis...@yahoo.com> 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 <frankraney...@gmail.com
> [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 [mailto:
> 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 <frankraney...@gmail.com
> [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=gmail=g>. [
> 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:(55

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. <sunfis...@yahoo.com> 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 <frankraney...@gmail.com 
[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 [mailto: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 <frankraney...@gmail.com 
[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,+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 <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 
> <mailto: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 <frankraney...@gmail.com 
> <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=gmail=g>
>  
> <https://maps.google.com/?q=12454+Auberry+Rd.+%3EClovis,+Ca=gmail=g>>Clovis,
>  Ca 
> <https://maps.google.com/?q=12454+Auberry+Rd.+%3EClovis,+Ca=gmail=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

[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" <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 <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=gmail=g>
>
> <https://maps.google.com/?q=12454+Auberry+Rd.+%3EClovis,+Ca=gmail=g>
> >Clovis, Ca
> <https://maps.google.com/?q=12454+Auberry+Rd.+%3EClovis,+Ca=gmail=g>
> .
> >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 <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.
>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.

importing

[frank raney]

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.

importing qif file

[Mike Weston via gnucash-user]

I import a 10 day bank transaction from my only  bank into my only gnucash  
checking account.  My checking is in current assets.  When I imported prior to 
this week, my transaction went to the checking account with a "unspecified" 
note in my transfer column.  This worked great for me.  When I tried to import 
the same way today, all of the data went to the "unspecified" account and not 
to the checking account as usual.  When I changed the "matching file" to 
checking account it still sent data to "unspecified". Then I got only deposits.

I have just a basic home setup.  Nothing fancy.  How do I get all of my 
transactions to my checking account to verify and balance them.
___
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.

Importing bookings with accounts fully assigned

[Cornelis Bockemühl]

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...)?

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.

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?

Thanks and regards, Cornelis

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

Importing Memo data via QIF

[Thomas Young]

I have been unable to import data in the M field using QIF import. 
Everything else imports OK, but the Memo data does not import. How do I 
import the Memo field data using QIF import?


___
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: Preferred Date Format When Importing CSV Files

[David Carlson]

It does seem odd that the importer does not default to the same choice that
the user has chosen for the data file, even though it is important to allow
the user to change it if (s)he has a CSV file with a different choice.

David C

On Sat, Jul 29, 2017 at 7:36 AM, Jean-David Beyer 
wrote:

> On 07/28/2017 09:32 PM, Paul W. wrote:
> > I set the date format to m-d-y in Edit>Preferences>Date/time
> >
> > When I import CSV files, the date format on the Preview Settings page
> shows y-m-d.  I manually change the format to m-d-y.
> > What do I need to do to have GC automatically show the format I selected.
> >
> Different strokes...
>
> Years ago I had to figure out how to make dates all y-m-d because
> sorting by date is easier for me that way.
>
>
> --
>   .~.  Jean-David Beyer  Registered Linux User 85642.
>   /V\  PGP-Key:166D840A 0C610C8B Registered Machine  1935521.
>  /( )\ Shrewsbury, New Jerseyhttp://linuxcounter.net
>  ^^-^^ 08:35:01 up 3 days, 9:30, 2 users, load average: 5.05, 4.83, 4.54
> ___
> 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: Preferred Date Format When Importing CSV Files

[Jean-David Beyer]

On 07/28/2017 09:32 PM, Paul W. wrote:
> I set the date format to m-d-y in Edit>Preferences>Date/time
>  
> When I import CSV files, the date format on the Preview Settings page shows 
> y-m-d.  I manually change the format to m-d-y.
> What do I need to do to have GC automatically show the format I selected.
> 
Different strokes...

Years ago I had to figure out how to make dates all y-m-d because
sorting by date is easier for me that way.


-- 
  .~.  Jean-David Beyer  Registered Linux User 85642.
  /V\  PGP-Key:166D840A 0C610C8B Registered Machine  1935521.
 /( )\ Shrewsbury, New Jerseyhttp://linuxcounter.net
 ^^-^^ 08:35:01 up 3 days, 9:30, 2 users, load average: 5.05, 4.83, 4.54
___
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.

Preferred Date Format When Importing CSV Files

[Paul W.]

I set the date format to m-d-y in Edit>Preferences>Date/time
 
When I import CSV files, the date format on the Preview Settings page shows 
y-m-d.  I manually change the format to m-d-y.
What do I need to do to have GC automatically show the format I selected.



Affordable Wireless Plans
Set up is easy. Get online in minutes.
Starting at only $14.95 per month! 
www.netzero.net?refcd=nzmem0216
___
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: When importing transactions, what happens to non-identical data in the description and notes fields?

[pfwoolver...@juno.com]

David and David, Thanks for the info.  I would like an import option to import 
the new data and retain the existing data, perhaps show all of the data in the 
split view. Paul -- Original Message --
From: David Carlson <david.carlson@gmail.com>
To: pfwoolver...@juno.com
Cc: gnucash-user@gnucash.org
Subject: Re: When importing transactions, what happens to non-identical data in 
the description and notes fields?
Date: Sun, 9 Jul 2017 10:33:21 -0500


Paul
 In my experience it depends on which method you use.  I usually use the OFX 
import and if I choose update the new text replaces the existing so I often 
either choose match which keeps the existing text or add to keep.the existing 
transaction intact so I can manually merge text later. David C 
On Jul 9, 2017 10:15 AM, "pfwoolver...@juno.com" <pfwoolver...@juno.com> wrote:

 I import transactions in QIF, GFX and CSV formats to GC 2.6.16.  When I import 
transactions, GC proposes to match some of the imported transactions with 
transactions in my file.  GC highlights these transactions in green.  These 
transactions do not have identical data in the date, description, and notes 
fields.  What happens to the non-identical data in the description and notes 
fields?  Which date survives the match.
 
 Paul
 ___
 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: When importing transactions, what happens to non-identical data in the description and notes fields?

[David T. via gnucash-user]

The importer includes three options: A, R and R+U. These mean:

A = add the transaction as new 
R+U =  reconcile the transaction with a matching transaction and update the 
existing GC transaction with the incoming data (description field etc.) 
R = Reconcile the incoming transaction with the existing transaction 

What you choose affects what you get.

HTH,
David

> On Jul 9, 2017, at 8:12 PM, pfwoolver...@juno.com wrote:
> 
> 
> I import transactions in QIF, GFX and CSV formats to GC 2.6.16.  When I 
> import transactions, GC proposes to match some of the imported transactions 
> with transactions in my file.  GC highlights these transactions in green.  
> These transactions do not have identical data in the date, description, and 
> notes fields.  What happens to the non-identical data in the description and 
> notes fields?  Which date survives the match.
> 
> Paul
> ___
> 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.

When importing transactions, what happens to non-identical data in the description and notes fields?

[pfwoolver...@juno.com]

I import transactions in QIF, GFX and CSV formats to GC 2.6.16.  When I import 
transactions, GC proposes to match some of the imported transactions with 
transactions in my file.  GC highlights these transactions in green.  These 
transactions do not have identical data in the date, description, and notes 
fields.  What happens to the non-identical data in the description and notes 
fields?  Which date survives the match.

Paul
___
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: Issues with Importing Invoices

[Bruce Danielson]

Thanks David - I'm not really sure how useful Jobs will be, but it is a
little confusing, and appears tp be a singular list of Jobs but each job is
tagged as either a Vendor Job or a Customer Job.
Thanks again for your input - I'm learning as I go.
Thx for the tip on the double search too - I'm going to try that out.  :)


-Original Message-
From: gnucash-user
[mailto:gnucash-user-bounces+danielsonb=logroom@gnucash.org] On Behalf
Of DaveC49
Sent: Sunday, May 28, 2017 6:55 PM
To: gnucash-user@gnucash.org
Subject: Re: Issues with Importing Invoices

Hi Buster,
Customer jobs are not meant to be the same as Vendor jobs at least according
to the Gnucash Help manual entries which seem to indicate that they are
separate
https://www.gnucash.org/docs/v2.6/C/gnucash-help/busnss-ar-jobs1.html and
https://www.gnucash.org/docs/v2.6/C/gnucash-help/busnss-ap-jobs1.html.
 
However the Find Jobs dialog does not seem to distinguish between customer
and vendor jobs. If you enter a search term (anything will do, e.g. "*"),
hit Find ( returns nothing or anything matching what you entered) and then
hit Find again all jobs are listed. (This shifts the radio button on the
left to the refine search option after doing a new search which returns all
the jobs both customer and vendor). I could not find this behavior
documented anywhere, but I presume it does a regex search to match any
character on the second Find. You can also select "matches regex" instead of
"contains in the search option and enter "." in the text field as documented
in the find documentation referenced  below, however I find the double Find
is quicker than altering the search citeria ( at least for a small number of
customers/vendors/jobs). You cannot allocate a vendor job to a customer
invoice as the find jobs  dialog for setting the job in the invoice edit
dialog is limited to customer jobs (and I presume similarly for Bills
/vendor jobs but I have not tested this).

The Find behavior is documented at
https://www.gnucash.org/docs/v2.6/C/gnucash-help/busnss-ar-customers1.html#b
usnss-ar-custfind2
in the Help Manual.

David Cousens.



--
View this message in context:
http://gnucash.1415818.n4.nabble.com/Issues-with-Importing-Invoices-tp469190
4p4691921.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
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: Issues with Importing Invoices

[DaveC49]

Hi Buster,
Customer jobs are not meant to be the same as Vendor jobs at least according
to
the Gnucash Help manual entries which seem to indicate that they are
separate
https://www.gnucash.org/docs/v2.6/C/gnucash-help/busnss-ar-jobs1.html and
https://www.gnucash.org/docs/v2.6/C/gnucash-help/busnss-ap-jobs1.html.
 
However the Find Jobs dialog does not seem to distinguish between customer
and vendor jobs. If you enter a search term (anything will do, e.g. "*"),
hit Find ( returns nothing or anything matching what you entered) and then
hit Find again all jobs are listed. (This shifts the radio button on the
left to the refine search option after doing a new search which returns all
the jobs both customer and vendor). I could not find this behavior
documented anywhere, but I presume it does a regex search to match any
character on the second Find. You can also select "matches regex" instead of
"contains in the search option and enter "." in the text field as documented
in the find documentation referenced  below, however I find the double Find
is quicker than altering the search citeria ( at least for a small number of
customers/vendors/jobs). You cannot allocate a vendor job to a customer
invoice as the find jobs  dialog for setting the job in the invoice edit
dialog is limited to customer jobs (and I presume similarly for Bills
/vendor jobs but I have not tested this).

The Find behavior is documented at
https://www.gnucash.org/docs/v2.6/C/gnucash-help/busnss-ar-customers1.html#busnss-ar-custfind2
in the Help Manual.

David Cousens.



--
View this message in context: 
http://gnucash.1415818.n4.nabble.com/Issues-with-Importing-Invoices-tp4691904p4691921.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
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.

Issues with Importing Invoices

[Bruce Danielson]

Greetings - I am a fairly new user, and have a couple of business questions.
I was looking to see if I can make, print & send to vendors Purchase Orders
in GnuCash, and assign this to job(s) if necessary.  I see Orders in the
Properties / Counters tab but there is little to no explanation as to what
this is for.  Could be for stock orders, but having them pre-numbered
doesn't make sense.  This looks like maybe a latent Purchase Order
numbering?

 

Yes I can twist & alter a custom Vendor Bill printout to say Purchase Order,
& send that, but that's not exactly the same thing.  So just wondering what
the thoughts are on that.

 

 

On a related topic - are the Jobs relating to Customers the same as Jobs
relating to vendors?  Can A Job relate to A Vendor with multiple Bills AND
also to A Customer with multiple Invoices?  This is a little confusing, but
I can see from what I do having A Job that covers A Customer AND A Vendor.
Trouble is I might have multiple vendors, but usually one customer per job.

 

 

Any feedback on either topic is appreciated.  

Thanks,

 

Buster

 

 

___
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: Issues with Importing Invoices

[Bruce Danielson]

Nelson – on a whim, today at work I decided to import my 34 June 1 invoices, 
opening date today but invoice date and due date June 1, with posting fields 
filled in – worked like a charm.  So I have to plug in invoice numbers, but 
that’s ok.

 

You’re right about the header row forcing commas as without the header row and 
without invoice numbers, Excel deletes the blank column A when saving.  I 
opened the file in a text editor and placed a leading comma in both rows, but 
then got the same error as if I omitted invoice numbers with a header row (ID 
Not Set).

 

To tell the truth, I could not import customers from my work PC, but it worked 
the first try on my home PC.  At work all the fields to the right of Ship Name 
got shifted 1 field to the right, like if there were one too many commas in the 
file – but at home it worked perfect using the same csv file.  Weird.

 

SO – I’m importing and posting, all one step.  Thanks Nelson, all is good.

I appreciate your help & suggestions.

Bruce

 

 

From: Nelson Handcock [mailto:nelson.handc...@gmail.com] 
Sent: Thursday, May 25, 2017 8:03 PM
To: Bruce Danielson
Cc: gnucash-user@gnucash.org
Subject: Re: Issues with Importing Invoices

 

Glad to hear you got it working!

 

If you google "gnucash counters" or look in the online tutorial guide you might 
find some hints that may help you get that aspect working.

 

I guess having a header row for the invoice import forces all the optional 
fields as having blank values and also forces the required number of commas 
into each row, thereby making sure the file is in the correct format for the 
import function. If you open the file in wordpad/notepad then you'll see all 
the comma's in the data rows - I'm guessing these might not have been there in 
your original file.

 

The customer import may not have so many optional fields and therefore what you 
had in your file was valid right from the start. 

 

It's up to you if you post your invoices as a separate activity to importing 
them - but if you fill the "posting" fields in file as well then it's all done 
for you when you run the import.

 

 

Cheers, Nelson




 

 

On Fri, May 26, 2017 at 12:47 PM, Bruce Danielson <daniels...@logroom.com> 
wrote:

Nelson – OK, I just copied your exact header row and tried importing but with 
no ID’s (Invoice Number blank) – I got errors that No ID Set (or something like 
that).

So, I plugged in Invoice Numbers – and it worked.  2 invoices to 2 users, 
perfect, just as you would expect.  I then posted both and all is well.

 

So – it won’t self-generate invoice numbers, and it needs the header row, I can 
live with all that.

 

BTW - When I imported 32 customers, it self-generated customer numbers, and I 
did not have a header row.  But hey, who cares?

 

Thanks Nelson, this has been a learning experience.  We can consider this issue 
closed.

Bruce

 

 

Thx Nelson – Let me try filling in the header row & see if it helps with the 
customer number at all.  That is the central issue right now.

When I post invoices on June 1, I don’t want all 34 to go to C001 (or whoever 
is first on the list).  So I’m trying just these two customers to see if I can 
get this to work.

 

I have the latest version 2.6.16 loaded on both PC’s.  I updated both when I 
had the idea to try this on the water club.

 

If you think of any reason I get both invoices going to customer C033, please 
let me know.  Any idea would help.

And I’ll let you know if & when I get some success.

 

Thx Again Nelson,

Bruce 

 

 

From: Nelson Handcock [mailto:nelson.handc...@gmail.com] 
Sent: Thursday, May 25, 2017 5:57 PM


To: Bruce Danielson
Cc: gnucash-user@gnucash.org
Subject: Re: Issues with Importing Invoices

 

Hi Bruce,

 

In no particular order

 

Please check your version of gnucash - most recent version is 2.6.16. It's best 
to keep up to date.

 

Tou can't delete an invoice - but if it's left as not posted then it won't show 
in any of the accounts. It's a bit annoying but it's always been that way AFAIK.

 

 

I suggest you firstly complete the remaining columns out to 'V', and then try 
again If GST is not relevant for you then leave columns O, P and Q blank. You 
might want to change your invoice numbers to something else first - to ensure 
Gnucash doesn't get confused with existing invoices.

 

Due Date can be set to the same as Date Posted - I add 7 days to mine but you 
don't have to if you don't want to.

 

Yes - if you keep the first column blank then that could well fix your 
auto-generate invoice numbers. Another way is to open the csv file using 
Wordpad, and adding a comma in the first character position to each line (if 
you don't want to add the header row)

 

 

It's very strange that you are getting the second invoice with the C033 
customer - that has not been my experience.

 

Hope this helps

 




Thanks & Regards,


Nelson 

 

On Fri, May 26, 

RE: Issues with Importing Invoices

[Bruce Danielson]

Nelson – OK, I just copied your exact header row and tried importing but with 
no ID’s (Invoice Number blank) – I got errors that No ID Set (or something like 
that).

So, I plugged in Invoice Numbers – and it worked.  2 invoices to 2 users, 
perfect, just as you would expect.  I then posted both and all is well.

 

So – it won’t self-generate invoice numbers, and it needs the header row, I can 
live with all that.

 

BTW - When I imported 32 customers, it self-generated customer numbers, and I 
did not have a header row.  But hey, who cares?

 

Thanks Nelson, this has been a learning experience.  We can consider this issue 
closed.

Bruce

 

 

Thx Nelson – Let me try filling in the header row & see if it helps with the 
customer number at all.  That is the central issue right now.

When I post invoices on June 1, I don’t want all 34 to go to C001 (or whoever 
is first on the list).  So I’m trying just these two customers to see if I can 
get this to work.

 

I have the latest version 2.6.16 loaded on both PC’s.  I updated both when I 
had the idea to try this on the water club.

 

If you think of any reason I get both invoices going to customer C033, please 
let me know.  Any idea would help.

And I’ll let you know if & when I get some success.

 

Thx Again Nelson,

Bruce 

 

 

From: Nelson Handcock [mailto:nelson.handc...@gmail.com] 
Sent: Thursday, May 25, 2017 5:57 PM
To: Bruce Danielson
Cc: gnucash-user@gnucash.org
Subject: Re: Issues with Importing Invoices

 

Hi Bruce,

 

In no particular order

 

Please check your version of gnucash - most recent version is 2.6.16. It's best 
to keep up to date.

 

Tou can't delete an invoice - but if it's left as not posted then it won't show 
in any of the accounts. It's a bit annoying but it's always been that way AFAIK.

 

 

I suggest you firstly complete the remaining columns out to 'V', and then try 
again If GST is not relevant for you then leave columns O, P and Q blank. You 
might want to change your invoice numbers to something else first - to ensure 
Gnucash doesn't get confused with existing invoices.

 

Due Date can be set to the same as Date Posted - I add 7 days to mine but you 
don't have to if you don't want to.

 

Yes - if you keep the first column blank then that could well fix your 
auto-generate invoice numbers. Another way is to open the csv file using 
Wordpad, and adding a comma in the first character position to each line (if 
you don't want to add the header row)

 

 

It's very strange that you are getting the second invoice with the C033 
customer - that has not been my experience.

 

Hope this helps

 




Thanks & Regards,


Nelson 

 

On Fri, May 26, 2017 at 10:37 AM, Bruce Danielson <daniels...@logroom.com> 
wrote:

Hey Nelson – I totally get all that, and I should have thought to attach a copy 
of my short import file for you to take a look.  Plz see attached.

One thing that did not occur to me is to keep the header row, which I should 
have realized would get ignored during import.  Thx for that tip.

 

In my file, both lines are virtually the same except for the Customer ID – 
which are in order (not sure why that should make a difference).

I end up with two invoices, as one would expect, BUT - both are for Cust ID 
C033 (with that person’s name, etc), just as if I’d used C033 for both lines.

 

The first couple of times I tried this, I had all the posting info included 
(columns R and up) – but then I had to keep unposting them, so I got rid of 
that.  I figured if I could get this to work, I could manually post later (just 
2 invoices).

 

Also – so you know, I’ve tried this on more than one PC – first at work, then 
at home.  Both use Win-7 & Office-10.  Same result.

 

My import file was made with MS Excel and saved in CSV (Comma delimited) 
(*.csv) file type.  MS Excel is not perfect at CSV files as if I don’t put in 
invoice numbers, Excel deletes the first column (which is blank) when it saves 
the file.  HEY - Light bulb coming on – maybe if I keep the header row, Excel 
won’t delete the first column, and GnuCash might generate the invoice numbers.  
I gotta give that a try.  Thx.

 

One related thing – is there a way to DELETE the bad invoices I’ve created by 
trying to import?  I could not see how to delete unposted invoices that I would 
like to get rid of.

 

Thanks Nelson – I appreciate your help.  Please check out my import file and 
see if you spot anything amiss.

Bruce

 

From: Nelson Handcock [mailto:nelson.handc...@gmail.com] 
Sent: Wednesday, May 24, 2017 12:54 PM
To: Bruce Danielson
Cc: gnucash-user@gnucash.org
Subject: Re: Issues with Importing Invoices

 

Bruce,

 

I've attached a sample of an invoice import file that I recently prepared and 
successfully loaded up.

If you change the "memberidn" to match your customer ID's and also change the 
account names then it should work for you.

 

The key thing for me is sorting my source da

RE: Issues with Importing Invoices

[Bruce Danielson]

Thx Nelson – Let me try filling in the header row & see if it helps with the 
customer number at all.  That is the central issue right now.

When I post invoices on June 1, I don’t want all 34 to go to C001 (or whoever 
is first on the list).  So I’m trying just these two customers to see if I can 
get this to work.

 

I have the latest version 2.6.16 loaded on both PC’s.  I updated both when I 
had the idea to try this on the water club.

 

If you think of any reason I get both invoices going to customer C033, please 
let me know.  Any idea would help.

And I’ll let you know if & when I get some success.

 

Thx Again Nelson,

Bruce 

 

 

From: Nelson Handcock [mailto:nelson.handc...@gmail.com] 
Sent: Thursday, May 25, 2017 5:57 PM
To: Bruce Danielson
Cc: gnucash-user@gnucash.org
Subject: Re: Issues with Importing Invoices

 

Hi Bruce,

 

In no particular order

 

Please check your version of gnucash - most recent version is 2.6.16. It's best 
to keep up to date.

 

Tou can't delete an invoice - but if it's left as not posted then it won't show 
in any of the accounts. It's a bit annoying but it's always been that way AFAIK.

 

 

I suggest you firstly complete the remaining columns out to 'V', and then try 
again If GST is not relevant for you then leave columns O, P and Q blank. You 
might want to change your invoice numbers to something else first - to ensure 
Gnucash doesn't get confused with existing invoices.

 

Due Date can be set to the same as Date Posted - I add 7 days to mine but you 
don't have to if you don't want to.

 

Yes - if you keep the first column blank then that could well fix your 
auto-generate invoice numbers. Another way is to open the csv file using 
Wordpad, and adding a comma in the first character position to each line (if 
you don't want to add the header row)

 

 

It's very strange that you are getting the second invoice with the C033 
customer - that has not been my experience.

 

Hope this helps

 




Thanks & Regards,


Nelson 

 

On Fri, May 26, 2017 at 10:37 AM, Bruce Danielson <daniels...@logroom.com> 
wrote:

Hey Nelson – I totally get all that, and I should have thought to attach a copy 
of my short import file for you to take a look.  Plz see attached.

One thing that did not occur to me is to keep the header row, which I should 
have realized would get ignored during import.  Thx for that tip.

 

In my file, both lines are virtually the same except for the Customer ID – 
which are in order (not sure why that should make a difference).

I end up with two invoices, as one would expect, BUT - both are for Cust ID 
C033 (with that person’s name, etc), just as if I’d used C033 for both lines.

 

The first couple of times I tried this, I had all the posting info included 
(columns R and up) – but then I had to keep unposting them, so I got rid of 
that.  I figured if I could get this to work, I could manually post later (just 
2 invoices).

 

Also – so you know, I’ve tried this on more than one PC – first at work, then 
at home.  Both use Win-7 & Office-10.  Same result.

 

My import file was made with MS Excel and saved in CSV (Comma delimited) 
(*.csv) file type.  MS Excel is not perfect at CSV files as if I don’t put in 
invoice numbers, Excel deletes the first column (which is blank) when it saves 
the file.  HEY - Light bulb coming on – maybe if I keep the header row, Excel 
won’t delete the first column, and GnuCash might generate the invoice numbers.  
I gotta give that a try.  Thx.

 

One related thing – is there a way to DELETE the bad invoices I’ve created by 
trying to import?  I could not see how to delete unposted invoices that I would 
like to get rid of.

 

Thanks Nelson – I appreciate your help.  Please check out my import file and 
see if you spot anything amiss.

Bruce

 

From: Nelson Handcock [mailto:nelson.handc...@gmail.com] 
Sent: Wednesday, May 24, 2017 12:54 PM
To: Bruce Danielson
Cc: gnucash-user@gnucash.org
Subject: Re: Issues with Importing Invoices

 

Bruce,

 

I've attached a sample of an invoice import file that I recently prepared and 
successfully loaded up.

If you change the "memberidn" to match your customer ID's and also change the 
account names then it should work for you.

 

The key thing for me is sorting my source data by Member ID and then by Date, 
before setting the ID column with the invoice number. Note how you can have two 
lines with the same ID number one after the other - this results in a 
multi-line invoice being imported.

 

I usually leave the header row in my source data - gnucash just spits it out 
anyway. It only ever rejects data for me if the memberID does not match an 
existing customer.

 

I'm pretty sure I've imported data like this without setting the ID column at 
all, and Gnucash sets the ID number based on the number range set up in the 
settings - Menu path File - Properties - Counters.

 

 

Hope this helps,..

 




Thanks & R

Re: Issues with Importing Invoices

[Nelson Handcock]

Hi Bruce,

In no particular order

Please check your version of gnucash - most recent version is 2.6.16. It's
best to keep up to date.

Tou can't delete an invoice - but if it's left as not posted then it won't
show in any of the accounts. It's a bit annoying but it's always been that
way AFAIK.


I suggest you firstly complete the remaining columns out to 'V', and then
try again If GST is not relevant for you then leave columns O, P and Q
blank. You might want to change your invoice numbers to something else
first - to ensure Gnucash doesn't get confused with existing invoices.

Due Date can be set to the same as Date Posted - I add 7 days to mine but
you don't have to if you don't want to.

Yes - if you keep the first column blank then that could well fix your
auto-generate invoice numbers. Another way is to open the csv file using
Wordpad, and adding a comma in the first character position to each line
(if you don't want to add the header row)


It's very strange that you are getting the second invoice with the C033
customer - that has not been my experience.

Hope this helps


Thanks & Regards,

Nelson

On Fri, May 26, 2017 at 10:37 AM, Bruce Danielson <daniels...@logroom.com>
wrote:

> Hey Nelson – I totally get all that, and I should have thought to attach a
> copy of my short import file for you to take a look.  Plz see attached.
>
> One thing that did not occur to me is to keep the header row, which I
> should have realized would get ignored during import.  Thx for that tip.
>
>
>
> In my file, both lines are virtually the same except for the Customer ID –
> which are in order (not sure why that should make a difference).
>
> I end up with two invoices, as one would expect, BUT - both are for Cust
> ID C033 (with that person’s name, etc), just as if I’d used C033 for both
> lines.
>
>
>
> The first couple of times I tried this, I had all the posting info
> included (columns R and up) – but then I had to keep unposting them, so I
> got rid of that.  I figured if I could get this to work, I could manually
> post later (just 2 invoices).
>
>
>
> Also – so you know, I’ve tried this on more than one PC – first at work,
> then at home.  Both use Win-7 & Office-10.  Same result.
>
>
>
> My import file was made with MS Excel and saved in CSV (Comma delimited)
> (*.csv) file type.  MS Excel is not perfect at CSV files as if I don’t put
> in invoice numbers, Excel deletes the first column (which is blank) when it
> saves the file.  HEY - Light bulb coming on – maybe if I keep the header
> row, Excel won’t delete the first column, and GnuCash might generate the
> invoice numbers.  I gotta give that a try.  Thx.
>
>
>
> One related thing – is there a way to DELETE the bad invoices I’ve created
> by trying to import?  I could not see how to delete unposted invoices that
> I would like to get rid of.
>
>
>
> Thanks Nelson – I appreciate your help.  Please check out my import file
> and see if you spot anything amiss.
>
> Bruce
>
>
>
> *From:* Nelson Handcock [mailto:nelson.handc...@gmail.com]
> *Sent:* Wednesday, May 24, 2017 12:54 PM
> *To:* Bruce Danielson
> *Cc:* gnucash-user@gnucash.org
> *Subject:* Re: Issues with Importing Invoices
>
>
>
> Bruce,
>
>
>
> I've attached a sample of an invoice import file that I recently prepared
> and successfully loaded up.
>
> If you change the "memberidn" to match your customer ID's and also change
> the account names then it should work for you.
>
>
>
> The key thing for me is sorting my source data by Member ID and then by
> Date, before setting the ID column with the invoice number. Note how you
> can have two lines with the same ID number one after the other - this
> results in a multi-line invoice being imported.
>
>
>
> I usually leave the header row in my source data - gnucash just spits it
> out anyway. It only ever rejects data for me if the memberID does not match
> an existing customer.
>
>
>
> I'm pretty sure I've imported data like this without setting the ID column
> at all, and Gnucash sets the ID number based on the number range set up in
> the settings - Menu path File - Properties - Counters.
>
>
>
>
>
> Hope this helps,..
>
>
>
>
> Thanks & Regards,
>
>
> Nelson
>
>
>
> On Wed, May 24, 2017 at 12:58 PM, Bruce Danielson <daniels...@logroom.com>
> wrote:
>
> Greetings - I am a new user, and I am trying out GnuCash on a rather odd
> application - I manage a couple of employee water clubs at work (for
> Sparkletts bottled water - since our employer won't spring for the water -
> pardon the pun).  I have it setup as a business type of accounting.  I'm
> trying this on the smaller &a

Re: Issues with Importing Invoices

[Nelson Handcock]

Bruce,

I've attached a sample of an invoice import file that I recently prepared
and successfully loaded up.
If you change the "memberidn" to match your customer ID's and also change
the account names then it should work for you.

The key thing for me is sorting my source data by Member ID and then by
Date, before setting the ID column with the invoice number. Note how you
can have two lines with the same ID number one after the other - this
results in a multi-line invoice being imported.

I usually leave the header row in my source data - gnucash just spits it
out anyway. It only ever rejects data for me if the memberID does not match
an existing customer.

I'm pretty sure I've imported data like this without setting the ID column
at all, and Gnucash sets the ID number based on the number range set up in
the settings - Menu path File - Properties - Counters.


Hope this helps,..


Thanks & Regards,

Nelson

On Wed, May 24, 2017 at 12:58 PM, Bruce Danielson 
wrote:

> Greetings - I am a new user, and I am trying out GnuCash on a rather odd
> application - I manage a couple of employee water clubs at work (for
> Sparkletts bottled water - since our employer won't spring for the water -
> pardon the pun).  I have it setup as a business type of accounting.  I'm
> trying this on the smaller & newer of the clubs I manage.  Weird I know,
> but
> I want to make this work.  I am also treasurer of a non-profit, I wish I'd
> known about GnuCash before I went & bought QB.  But OK, for the water club
> -
>
>
>
> I was able to import a bunch of customers (club members) via a csv file I
> made from an Excel roster.  So far, so good.  I have an asset account
> called
> Cash On Hand which monthly dues will pay into, and water bills will be paid
> out of.  And I have only one Vendor (Sparkletts) and one applicable expense
> account (bottled water).
>
>
>
> Since I don't really want to produce 36 separate invoices each month for
> member dues, one at a time, I am hoping to find a way to sort of batch
> generate invoices.  I have tried numerous times making a small 2 line csv
> file from an excel table to import, and have run into several issues.  It
> is
> only 2 lines now because I have 2 customers that are late paying for May,
> so
> I thought I'd try this out on them.
>
>
>
> One issue is that if I leave the ID field blank, "import" does not self
> generate invoice ID's - but instead just ignores the lines.  OK - no
> worries, I can plug in invoice numbers in the excel table, that's not too
> much work.  The more serious issue is this, although the specific customers
> are C033 and C034 - when I import, both invoices generated are applied to
> one of the customers only (C033) and none to the other customer (C034).  I
> generate 2 invoices, but both for the same customer (C033).
>
>
>
> Import Invoices is not reading the customer (Owner ID) in the table and
> applying to the correct customer.  This I do not know how to work around.
> I'm looking for ideas or anything I may be doing wrong.  I have upgraded to
> the latest version 2.6.16 (rev 509ce16+) BTW.
>
>
>
> Really, if I cannot batch-make invoices, I can't make use of GnuCash.
> Trying to generate 36 (or so) individual invoices on the 1st of each month
> is not going to work for me.
>
>
>
> I know this is probably a better application for just using Excel, but I
> wanted to give this a try.  Actually if I could figure a way to batch email
> my batch prepared invoices, this would be totally awesome.
>
>
>
> Any feedback is appreciated.  I will be away from this email address for a
> couple of days, so no big emergency.
>
> Thanks,
>
>
>
> Buster
>
>
>
>
>
> ___
> 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.
>
id,date_opened,owner_id,billing_id,notes,date,description,action,account,quantity,price, disc_type, disc_how, discount, taxable, taxincluded, tax_table,date_posted,due_date, account_posted,memo_posted,accu_splits
2016-1755,10/01/2017,memberid1,,,10/01/2017,GST Free Stock Purchases,,Income:Membership Fees,1,50Y,Y,GST Inclusive Sales,10/01/2017,17/01/2017,Assets:Accounts Receivable,,Y
2016-1756,10/01/2017,memberid2,,,10/01/2017,GST Free Stock Purchases,,Income:Sales,1,11.8,,,10/01/2017,17/01/2017,Assets:Accounts Receivable,,Y
2016-1757,17/01/2017,memberid3,,,17/01/2017,GST Applicable Stock Purchases,,Income:Sales,1,7.19Y,Y,GST Inclusive Sales,17/01/2017,24/01/2017,Assets:Accounts Receivable,,Y
2016-1757,17/01/2017,memberid3,,,17/01/2017,GST Free Stock Purchases,,Income:Sales,1,121.02,,,17/01/2017,24/01/2017,Assets:Accounts Receivable,,Y
2016-1758,17/01/2017,memberid4,,,17/01/2017,GST Free Stock Purchases,,Income:Sales,1,70.64,,,17/01/2017,24/01/2017,Assets:Accounts Receivable,,Y