Re: Importing qfx files, version 3.0

2018-04-04 Thread Jim Poklitar
Thanks David - bummer. Back to 2.6.19. Jim P On Wed, Apr 4, 2018 at 8:44 PM, David Carlson wrote: > As noted in the release notes that feature is known to not work per > https://bugzilla.gnome.org/show_bug.cgi?id=793461. > > It is not known exactly when that will be fixed. > > David C > > On W

Re: Importing qfx files, version 3.0

2018-04-04 Thread David Carlson
As noted in the release notes that feature is known to not work per https://bugzilla.gnome.org/show_bug.cgi?id=793461. It is not known exactly when that will be fixed. David C On Wed, Apr 4, 2018 at 7:42 PM, Jim Poklitar wrote: > ​Until version 3.0, I could download and import .qfx transaction

Re: Importing Quicken

2018-04-04 Thread David T. via gnucash-user
When I did my import (over a decade ago, I believe), I had no problem with transfers. Since I was importing all in one pass, there were no duplicates created by transfers. I believe the duplication problem you describe specifically arises when you opt to import transaction data from individual

Re: Importing Quicken

2018-04-04 Thread David Carlson
David T, Does the QIF importer detect duplicates created by transfers within the same import file? I seem to recall needing to separate accounts to different files to detect them. David C On Wed, Apr 4, 2018 at 9:00 AM, David T. wrote: > Alen, > > What you’ve done with the Benefits section is

Re: Importing Quicken

2018-04-04 Thread David T. via gnucash-user
Alen, What you’ve done with the Benefits section is better, but I still feel that any mention of benefits of migration is misplaced here. Someone looking for ways to migrate from Quicken presumably has already come to this conclusion. * I have edited the tips portion further. I added a tip rega

Re: Importing Quicken

2018-04-04 Thread Alen Siljak
Hi, David, You are right. I've removed the benefits section but kept the fact about open data standards. Apart from being a benefit (to me), it is also a consequence of migration that may or may not be important for users. > You mention multi-currency problems with QIF, saying that GnuCash only

Re: Importing Quicken

2018-04-03 Thread David T. via gnucash-user
cicko, I also like what you’ve done. I will add some edits there. Personally, I think the “Benefits” section is pointless; this page is about the migration from Quicken—not why someone should use GnuCash. I would recommend deleting it altogether, but I defer to you, since you created it. You

Re: Importing Quicken

2018-04-03 Thread David Carlson
cicko, A very nice start. I would add that those with large data files extending back several years should consider: 1. not importing all of it. 2. if you want to import it all, break down your export QIF process to one asset or liability account at a time and for limited time intervals such as

Re: Importing Quicken

2018-04-03 Thread 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 kn

Re: : importing

2018-03-12 Thread 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 appea

Re: : importing

2018-03-11 Thread 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 bre

Re: : importing

2018-03-11 Thread 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 bre

Re: : importing

2018-03-11 Thread 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 w

Re: : importing

2018-03-11 Thread 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 wa

Re: Importing Quicken

2018-03-11 Thread mahon . finbar
Me too. I closed off 2017 in Q and used bank balances etc., to start Gnucash on 1.1.2018. No issues. On March 11, 2018 10:27:29 AM GMT+01:00, keithwjones wrote: >Edward Ingram-2 wrote >> My Quicken files are stored in .QDF format, not .QIF. (Quicken 2017) >> How can I import these? > >I fou

Re: Importing Quicken

2018-03-11 Thread Dennis West
There is a menu selection in Quicken to export to a .QIF file. On 3/11/2018 04:27, keithwjones wrote: Edward Ingram-2 wrote My Quicken files are stored in .QDF format, not .QIF. (Quicken 2017) How can I import these? I found it easier to just start again with GnuCash instead of importing data

Re: Importing Quicken

2018-03-11 Thread 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

Re: Importing Quicken

2018-03-10 Thread Edward Ingram
OK DOKE On Sat, Mar 10, 2018 at 12:00 PM, David Carlson wrote: > Edward, Please use reply all to include the maillist. > > You need to read the manual and understand how double entry bookkeeping > works. You do not really have hundreds of accounts that don't actually > exist. As you stated ori

Re: Importing Quicken

2018-03-10 Thread 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 w

Re: Importing Quicken

2018-03-10 Thread 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

Re: Importing Quicken

2018-03-10 Thread Colin Law
I believe you have to export from quicken to QIF. Should be in the menus somewhere. Colin On 10 March 2018 at 16:12, Ken Pyzik wrote: > Edward -- I did the switch about 8 months ago and have not looked back. > > I am pretty sure you can directly import your file from Quicken. I do not > remembe

Re: Importing Quicken

2018-03-10 Thread 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.

RE: Importing Quicken

2018-03-10 Thread 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

Re: importing splits

2018-02-26 Thread 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

Re: importing splits

2018-02-26 Thread David Carlson
I believe the OP does not want to use a csv to qif converter. Perhaps whichever one he tried was difficult to use. Or maybe he wishes that his bank would do the split for him. David C On Feb 26, 2018 5:39 AM, "elvis" wrote: > > > On 24/02/18 03:39, Geert Janssens wrote: > >> Op vrijdag 23 fe

Re: importing splits

2018-02-26 Thread 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

Re: importing splits

2018-02-23 Thread Geert Janssens
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 10

Re: importing splits

2018-02-23 Thread Buddha Buck
On Fri, Feb 23, 2018 at 10:08 AM Jeff Abrahamson wrote: > Thanks. I see my question wasn't clear. My problem is that I want to > import the splits and it seems I can only import transactions. > Splits do not exist independently of transactions. Transactions have a collection of splits. The col

Re: importing splits

2018-02-23 Thread 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 2

Re: importing splits

2018-02-20 Thread 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 fir

Re: Importing Data

2017-10-16 Thread Maf. King
On Monday, 16 October 2017 21:42:19 BST Rick Strupkus wrote: > 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 Hi Rick, look at section 3 of the FAQ f

Re: importing

2017-10-14 Thread 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 ca

Re: importing

2017-10-14 Thread 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 acco

Re: importing

2017-10-12 Thread frank raney
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

Re: importing

2017-10-12 Thread 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 a

Re: importing

2017-10-12 Thread 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 th

Re: importing

2017-10-12 Thread 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.

Re: importing

2017-10-11 Thread 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

Re: importing

2017-10-11 Thread frank raney
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 H 559.304.1751 C On 10/11/2017 2:14:08 PM, David Carlson wrote: I

Re: importing

2017-10-11 Thread 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 you

Re: importing

2017-10-11 Thread 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

Re: importing

2017-10-11 Thread 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

Re: importing

2017-10-11 Thread 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

Re: importing

2017-10-11 Thread 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

Re: importing

2017-10-10 Thread Frankie Raney
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

Re: importing

2017-10-10 Thread Colin Law
Are there any of the backups there somename.gnucash.nnn? The number string is the date/time that it was taken. These will be mixed up with the log files so you may not have noticed them. Colin On 10 October 2017 at 14:30, Frankie Raney wrote: > Did a search, that's how I know it went to

Re: importing

2017-10-10 Thread 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 d

Re: importing

2017-10-10 Thread Frankie Raney
Did a search, that's how I know it went to lala land. Can't remember ever having this happen before. On Oct 10, 2017 2:50 AM, "Liz" wrote: > On Mon, 9 Oct 2017 20:39:34 -0700 > Frankie Raney wrote: > > > Yes, yes, and yes. It was, is the only filewhen it crashed it went > > awayI saved

Re: importing

2017-10-10 Thread Liz
On Mon, 9 Oct 2017 20:39:34 -0700 Frankie Raney wrote: > Yes, yes, and yes. It was, is the only filewhen it crashed it went > awayI saved it after importing, and looked at it with file > browserit was therethen I went back, run GC and started > editing..when GC crashed, the fi

Re: importing

2017-10-09 Thread 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,

Re: importing

2017-10-09 Thread 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 timestam

Re: importing

2017-10-09 Thread Colin Law
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.

Re: importing

2017-10-09 Thread 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

Re: importing

2017-10-09 Thread Aaron Laws
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 d

Re: importing

2017-10-08 Thread GWB
Hello, Frank, I am very sorry to hear that, and yes, it is very frustrating. I'm not a "guru" for .qif importing or anything else for that matter, but I did some experimentation with .QIF files some weeks ago. But just off the top of my head, I would suggest: -Are you sure your version of Quick

Re: importing

2017-10-08 Thread 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 th

Re: importing

2017-10-08 Thread David Carlson
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 Gn

Re: importing

2017-10-08 Thread frank raney
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

Re: importing

2017-10-07 Thread 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 h

Re: importing

2017-10-07 Thread frank raney
Frankie Raney If it worked good in 2.2, then maybe I can get that version, try it and if it works good, then upgrade. On 10/7/2017 4:45:51 PM, David Carlson wrote: Frank and David T, I believe that the QIF importer may not work exactly the same way that it did back in the 2.2 series or the 2.

Re: importing

2017-10-07 Thread 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

Re: importing

2017-10-07 Thread frank raney
I did import all at once..don't know yet how to export individual accounts from Quicken.. Frankie Raney On 10/7/2017 7:46:05 AM, David T. wrote: Frank, The *other* David suggested importing each account separately; I was suggesting importing all at once. In my (admittedly ancient) experi

Re: importing

2017-10-07 Thread 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

Re: importing

2017-10-07 Thread Frankie Raney
You are right as to what is being done When I import, it sees the duplicates, but there are hundredsit would take forever to Mark themI do not know how to export just one account at a timeI could try to figure it out and try that way I guess. On Oct 6, 2017 8:34 PM, "D" wrote: >

Re: importing

2017-10-06 Thread 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 Quick

Re: Importing bookings with accounts fully assigned

2017-08-20 Thread Cornelis Bockemühl
One more clarification: Thanks to Derek for the crucial hint regarding the L line: Without this I would have never managed to get the result! What I finally managed to generate on my own is to fabricate manually a synthetic minimum import file that really works. Am 20.08.2017 um 06:49 schrieb C

Re: Importing bookings with accounts fully assigned

2017-08-20 Thread Cornelis Bockemühl
Thanks Derek: I finally managed myself do do the thing that I want to do - at least for a little test import! This is the QIF file that I generated manually for my bookings: === !Type:Bank D11/08/17 T-25.70 PBirthday gift LGifts ^ D24/08/17 T2000 PSalary for Au

Re: Importing bookings with accounts fully assigned

2017-08-18 Thread 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

Re: Importing bookings with accounts fully assigned

2017-08-18 Thread 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] f

Re: Importing Memo data via QIF

2017-08-08 Thread Thomas Young
Hi Derek That did it. I was unaware of two line view mode as something different from splits. Thanks Thomas On 8/8/2017 5:42 PM, Derek Atkins wrote: Hi, On Tue, August 8, 2017 12:35 am, Thomas Young wrote: I have been unable to import data in the M field using QIF import. Everything else i

Re: Importing Memo data via QIF

2017-08-08 Thread Derek Atkins
Hi, On Tue, August 8, 2017 12:35 am, Thomas Young wrote: > 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? I presume your QIF has both P (Payee) and M (Memo)

Re: Importing Memo data via QIF

2017-08-08 Thread Jeffrey Black
Thomas Young wrote > 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 > gnuc