Gnucash freezes while loading data

Sun Jan 21 17:46:49 EST 2018

Thanks Jeffery, I'll save that sight for future reference.

It turned out that all I needed was a quick search and replace (replace "/"
in the date field with "-") and everything then went smoothly.

Paul

On Sun, Jan 21, 2018 at 12:50 PM, david amaral <dejamaral at yahoo.com> wrote:

> site is csvconverter.biz
>
> it is an online converter.
>
>
> ------------------------------
> *From:* david amaral via gnucash-user <gnucash-user at gnucash.org>
> *To:* jeffrey black <beastmaster126 at hotmail.com>; 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 10:23 AM
> *Subject:* Re: Gnucash freezes while loading data
>
> 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 <(781)%20639-0616> <tel:781-639-0616 <(781)%20639-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 <(781)%20639-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.
>
>
> _______________________________________________
> 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 M. Konnersman*
*konnersman at gmail.com <konnersman at gmail.com>*
*781-639-0616*