Gnucash freezes while loading data

david amaral dejamaral at yahoo.com
Sun Jan 21 12:22:05 EST 2018


Here is a free converter you might want to try for your csv file.
 CSV Converter


  
|  
|   
|   
|   |    |

   |

  |
|  
|   |  
CSV Converter
 Free online CSV converter. Save your bank/institution statement as QIF or OFX to then import into your accountin...  |   |

  |

  |

 
      From: jeffrey black <beastmaster126 at hotmail.com>
 To: David T. <sunfish62 at yahoo.com>; Paul Konnersman <konnersman at gmail.com> 
Cc: Gnucash Users <gnucash-user at gnucash.org>
 Sent: Sunday, January 21, 2018 9:41 AM
 Subject: Re: Gnucash freezes while loading data
   
On 1/21/2018 8:50 AM, David T. via gnucash-user wrote:
> Those don’t sound like large files, so it sounds like there might be something wrong. Do they ALL hang, or only some of them?
>
> I will admit that I am not one to advise on importing, as I don’t do it much. That being said, I would take a close look at the source files—especially the date fields, as GnuCash can be somewhat finicky around variably-formed dates.
>
> David T.
>
>> On Jan 21, 2018, at 6:59 PM, Paul Konnersman <konnersman at gmail.com> wrote:
>>
>> Thank you for the suggestions David T.
>>
>> Each of the files that I have been trying to import contains three weeks of transactions from one bank account. They are all between 1kb and 3kb.
>>
>> Paul
>>
>> On Sun, Jan 21, 2018 at 1:15 AM, David T. <sunfish62 at yahoo.com <mailto:sunfish62 at yahoo.com>> wrote:
>> Moreover, any import process can take a long time to complete (with no indication of progress). If you are importing a large csv file (as you might be doing if you are migrating in to GnuCash), it can be especially time consuming. Five or ten minutes is not unheard of.
>>
>> Try again and wait it out, as David C. suggests.
>>
>> If it really gets hung up, you would be well-advised to break the import up into smaller portions, thus reducing the time to process any given subset, and also increasing the likelihood of finding any erroneous data that might be causing a glitch. Heck, you may want to do this anyway.
>>
>> David T.
>>
>>> On Jan 21, 2018, at 4:45 AM, David Carlson <david.carlson.417 at gmail.com <mailto:david.carlson.417 at gmail.com>> wrote:
>>>
>>> Not sure how you know it is 'frozen' after such a short time.  GnuCash does
>>> not have any 'activity' indicator. Try giving it several minutes.
>>>
>>> David C
>>>
>>> On Sat, Jan 20, 2018 at 4:19 PM, Paul Konnersman <konnersman at gmail.com <mailto:konnersman at gmail.com>>
>>> wrote:
>>>
>>>> I have just made the decision to use Gnucash. So far I have successfully
>>>> imported my chart of accounts from a csv-file and attempted to import a
>>>> csv-file of transaction data. After 20-30 seconds of the transaction import
>>>> Gnucash freezes and I have to force quit. Any suggestions will be
>>>> appreciated.
>>>>
>>>> Paul
>>>> Running Gnucash 2.6.19 with OSX High Sierra on a Macbook Pro
>>>> --
>>>> *Paul M. Konnersman*
>>>> *konnersman at gmail.com <mailto:konnersman at gmail.com> <konnersman at gmail.com <mailto:konnersman at gmail.com>>*
>>>> *781-639-0616 <tel:781-639-0616>*
>>>> _______________________________________________
>>>> gnucash-user mailing list
>>>> gnucash-user at gnucash.org <mailto:gnucash-user at 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 at gnucash.org <mailto:gnucash-user at 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.
>>
>>
>>
>> -- 
>> Paul M. Konnersman
>> konnersman at gmail.com <mailto:konnersman at gmail.com>
>> 781-639-0616
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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.

Paul:

I can not speak for the OS you are running, GnuCash may look a little 
different.  As will your Quicken program.  I am still running Windoze.

My version (2014), of quicken, will not export to .csv, only .qif and 
.qfx.  I would recommend exporting to .qif instead.  The qif exported 
file will allow for multiple split transactions, I do not know about the 
csv export.  If I remember correctly I exported all of my quicken data 
in one shot and imported it.

Sometimes GnuCash has to "chew" on an import for a while.  I frequently 
get a message in the top title bar that Gnucash is "not responding".  
Wait a few minutes and see if it finishes.  I gave up on .csv imports 
because I could never assign the right fields. All I use is .qif and .ofx.

If csv is your only choice, try loading one of your csv files into a 
spreadsheet program, it makes it easier to see the layout. If it is a 
layout problem the spreadsheet program will complain. Then look for 
inconsistency's  in the data fields.

If that doesn't work then you will have to look at your csv file the 
hard way, with a text editor.

--JEffrey Black M.B.A.



_______________________________________________
gnucash-user mailing list
gnucash-user at 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.

   


More information about the gnucash-user mailing list