Re: [GNC] QIF import ignore account

2024-01-20 Thread Joseph Keithley
As was noted by a previous responder, the following works in Gnucash 5.5 and I didn't have to do any pre-import setup. !Account NAssets:us:Investments:TaxFree:f:Roth-F-Fid TInvst ^ !Type:Invst D1/19'24 NDiv Yroyal gold CX T45.60 Mroyal gold LIncome:us:NoTax:Roth-F-Fid:div:royal gold ^ On Sat,

Re: [GNC] Maddening!!!!!!!!

2024-01-11 Thread Joseph Keithley
I have had similar issues. My only "solution" was to hit the "Save" button after any action or entry. Gnucash can then crash as it always does and I will only have lost at most one transaction. I have the autosave feature enabled for every 5 minutes. The constant crashing seems to be related

Re: [GNC] Can't import .qif files from quicken since latest update

2024-04-06 Thread Joseph Keithley
QIF importer in Gnucash 5.6 gives me the same error for my credit card import even though the same file works in Quicken and in Gnucash 5.5. I reinstalled Gnucash 5.5. If I understand your comment corrrectly, the format of the qif file, with and with the first lines of the sample qif file below,

Re: [GNC] Can't import .qif files from quicken since latest update

2024-04-07 Thread Joseph Keithley
Apologize if this is a duplicate, sometimes I'm not sure if my post actually gets sent out. The QIF importer in Gnucash 5.6 gives me the same error for my credit card import even though the same file works in Quicken and in Gnucash 5.5. I had to reinstall Gnucash 5.5. As an aside, my experience

[GNC] QIF import "Unspecified" transaction

2024-04-05 Thread Joseph Keithley
When importing a QIF in the "Match payees/memos to GnuCash accounts" window, an "Unspecified" transaction will be listed under "GnuCash account name". When you double click on the item, a window pops up that lets you scroll through the different "accounts" and assign the item to a specific one.

Re: [GNC] QIF import "Unspecified" transaction

2024-04-06 Thread Joseph Keithley
.@comcast.net> wrote: > On 4/5/2024 6:43 AM, Joseph Keithley wrote: > > When importing a QIF in the "Match payees/memos to GnuCash accounts" > > window, an "Unspecified" transaction will be listed under "GnuCash > account > > name". When y

Re: [GNC] Can't import .qif files from quicken since latest update

2024-04-08 Thread Joseph Keithley
Both version 5.6 and 5.6-1 reject my credit card qif import with the following message: "Missing QIF investment action for transaction dated 04/06/2024." Reinstalled version 5.5 and imported the qif successfully. On Sun, Apr 7, 2024 at 9:39 PM Geoff wrote: > Hi Christopher > > Thanks for

Re: [GNC] Can't import .qif files from quicken since latest update

2024-04-08 Thread Joseph Keithley
Just out of curiosity is the word "Discover" somehow a protected word, function, directive or key word in the Gnucash code? Everytime I import my Discover Card qif it asks me for the date format. No other qif import does. On Mon, Apr 8, 2024 at 4:38 AM Joseph Keithley wrote: >

[GNC] QIF import broken on v5.6

2024-04-02 Thread Joseph Keithley
QIF import keeps giving me the following error: "Missing QIF investment action for transaction dated 03/31/2024." Imports with no issue on previous version. -- iii ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription

[GNC] QIF import "Unspecified" transaction

2024-04-02 Thread Joseph Keithley
When importing a QIF in the "Match payees/memos to GnuCash accounts" window, an "Unspecified" transaction will be listed under "GnuCash account name". When you double click on the item, a window pops up that lets you scroll through the different "accounts" and assign the item to a specific one.

Re: [GNC] Identify error transaction in QIF import

2024-04-21 Thread Joseph Keithley
The first thing I did before I exported my 150mb Quicken file to a qif was to run the Validate and Repair in the File menu under File Operations. Sometimes the Quicken data file gets corrupted and you have to repair transactions. That may help you track down if the issue is with your Quicken file

Re: [GNC] Identify error transaction in QIF import

2024-04-21 Thread Joseph Keithley
One more thing, if you are not aware, the qif is a simple text file. Since the error gave you a line number you might be able to import the qif file into Excel or a word processor that identifies line or row numbers and see what the error line is. If not simply do a search for some part of the

Re: [GNC] Please address broken QIF import

2024-04-25 Thread Joseph Keithley
I tried the -1 but it doesn't import my qif's either. I had to go back to version 5.5. On Thu, Apr 25, 2024 at 12:28 AM sunfish62--- via gnucash-user < gnucash-user@gnucash.org> wrote: > While I am uncomfortable with Jim's overall tone, he makes valid points to > consider. > > Also, >

Re: [GNC] Identify error transaction in QIF import

2024-04-21 Thread Joseph Keithley
For future reference, Quicken Interchange Format - Wikipedia On Sun, Apr 21, 2024 at 8:38 AM wrote: > Hi, > > > > I'm a long time Quicken user and trying to migrate to GnuCash. I've > exported my entire Quicken file to QIF and then

Re: [GNC] Identify error transaction in QIF import

2024-04-28 Thread Joseph Keithley
ut > 10 instances in a few banking accounts. Then all others are !Type:Prices > > > > I have more than 20 years of records and more than 100 accounts. It will > be very difficult to do this one by one. > > > > Is it possible for the error message to be more specific and pointi

Re: [GNC] Manipulating data extracted from gnucash to Excel

2024-05-19 Thread Joseph Keithley
Not sure what you mean by "copy". In the Windows version of GnuCash 5.5 you can export your accounts to a csv file. You pick the account, the date range, and the separator (usually a comma). There is also an option to either add double quotes or not. On Sun, May 19, 2024 at 12:41 PM David Long

Re: [GNC] Easier way to print to PDF

2024-05-19 Thread Joseph Keithley
If you are on a Windows machine you can use the Windows built-in PDF printer driver (Settings > Devices > Printers > Add Printer - "Microsoft Print to PDF"). Alternatively, you can export the report (shows up as an .html) and open it with Microsoft Edge and save it as a PDF. On Sun, May 19,

Re: [GNC] Manipulating data extracted from gnucash to Excel

2024-05-19 Thread Joseph Keithley
Only because I don't have any keyboard shortcuts memorized except ctrl-c and ctrl-v. On Sun, May 19, 2024 at 11:25 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Any reason not to use CTRL+A? > > Regards, > Adrien > > On 5/19/24 9:08 PM, Joseph Keithley

Re: [GNC] Manipulating data extracted from gnucash to Excel

2024-05-19 Thread Joseph Keithley
u bar. You can change the number of decimal places the report provides. One note, when I change the number of decimal places the report automatically alpahbetically resorts itself. An oddity but not an issue. On Sun, May 19, 2024 at 8:35 PM David Long wrote: > Hi > I mean copy paste

Re: [GNC] Manipulating data extracted from gnucash to Excel

2024-05-19 Thread Joseph Keithley
left-click the end of you data. All your data should be highlighted. Right-click the mouse and then left-click on "Copy". On Sun, May 19, 2024 at 8:35 PM David Long wrote: > Hi > I mean copy paste from a gnucash report. > Rgds > David > > > On Mon, 20 May 2024, 04: