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 <dejama...@yahoo.com> wrote: > site is csvconverter.biz > > it is an online converter. > > > ------------------------------ > *From:* david amaral via gnucash-user <gnucash-user@gnucash.org> > *To:* jeffrey black <beastmaster...@hotmail.com>; David T. < > sunfis...@yahoo.com>; Paul Konnersman <konners...@gmail.com> > *Cc:* Gnucash Users <gnucash-user@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 <beastmaster...@hotmail.com> > To: David T. <sunfis...@yahoo.com>; Paul Konnersman <konners...@gmail.com> > > Cc: Gnucash Users <gnucash-user@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 <konners...@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. <sunfis...@yahoo.com <mailto: > sunfis...@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....@gmail.com <mailto:david.carlson....@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 <konners...@gmail.com > <mailto:konners...@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* > >>>> *konners...@gmail.com <mailto:konners...@gmail.com> < > konners...@gmail.com <mailto:konners...@gmail.com>>* > >>>> *781-639-0616 <(781)%20639-0616> <tel:781-639-0616 <(781)%20639-0616> > >* > >>>> _______________________________________________ > >>>> 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. > >> > >> > >> > >> -- > >> Paul M. Konnersman > >> konners...@gmail.com <mailto:konners...@gmail.com> > >> 781-639-0616 <(781)%20639-0616> > > _______________________________________________ > > 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. > > 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@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. > > > -- *Paul M. Konnersman* *konners...@gmail.com <konners...@gmail.com>* *781-639-0616* _______________________________________________ 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.
