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

[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 to
my Windows 10 installation.  Windows will initiate some background process
which I notice becuase the mouse pauses for a microsecond and the screen
will briefly flash as if a messsage box were trying to pop up but it goes
away so quickly I can't really figure out what is going on.  Once this
happens, if Gnucash is open I can bet on a crash in short order.  There
will be no notification, Gnucash just quits and any unsaved work is lost.
If I reboot Wndows then Gnucash doesn't crash until the next time Windows
has its little hiccup.  The hiccup happens at most once a month but it is
still irritating to lose my work.  The hiccup doesn't seem to bother any
other running programs to include Quicken 2016, Excel, and Comodo A/V and
Firewall.



On Thu, Jan 11, 2024 at 3:33 PM Mark at Lorimark 
wrote:

> You can post an image as an attachment to your email, it will be
> available to the group here.
>
> ~w:http://www.lorimarksolutions.com
>
> On 1/11/24 13:00, Jack Slater wrote:
> > Is there a way I post the image?
> >
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>


-- 
iii
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] QIF import ignore account

[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, Jan 13, 2024 at 12:45 PM Fred Tydeman 
wrote:

> GnuCash 4.14 on Linux
>
> As part of a QIF import, I have the following transaction:
> ^
> D1/12'24
> NDiv
> Yblue owl cap
> CX
> T122.50
> Mblue owl cap
> LIncome:us:NoTax:Roth-F-Fid:div:blue owl cap
> ^
>
> However, when I do the Import in GnuCash, it shows up as:
> Income:Dividends:Assets:us:Investments:TaxFree:f:Roth-F-Fid.:blue owl cap
>
> I do not understand why the QIF importer is ignoring the L... line
> Now, the account on the L... line does not yet exist (so that might be the
> reason).
>
> In case it matters, the first few lines in the QIF are:
> !Account
> NAssets:us:Investments:TaxFree:f:Roth-F-Fid
> TInvst
> ^
> !Type:Invst
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>


-- 
iii
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

[GNC] QIF import broken on v5.6

[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 preferences or to unsubscribe:
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.

[GNC] QIF import "Unspecified" transaction

[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.

Is there some way to just type in the account name directly instead of
surfing around with the mouse?

-- 
iii
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

[GNC] QIF import "Unspecified" transaction

[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.

Is there some way to just type in the account name directly instead of
surfing around with the mouse?
-- 
iii
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] QIF import "Unspecified" transaction

[Joseph Keithley]

Your response was a little too deep for my question.  I simply want to type
in "Expense:Entertainment:Restaurant:Tip" instead of scrolling to the
Expense item then clicking on a triangle then scrolling to the
Enterntainment item then clicking on that triangle then scrolling to the
Restaurant item then clicking on that triangle then scrolling to the Tip
item and then highlighting it and then closing the window.  Which is
exactly what Quicken does and it is much faster than surfing all my
accounts, items and categories with a mouse.  If the account doesn't exist
I want to be asked, just like Gnucash and Quicken both do now, to add an
account/item. This feature already exists in Gnucash in individual account
register when entering a transaction.  Why can't this feature also exist in
the QIF importer?

On Fri, Apr 5, 2024 at 9:17 AM Michael or Penny Novack <
stepbystepf...@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 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.
> >
> > Is there some way to just type in the account name directly instead of
> > surfing around with the mouse?
>
> Perhaps not. As a retired senior systems analyst/senior business analyst
> I can see a very good reason requiring you to select from the list of
> existing accounts.
>
> Answer this question --- if free entry of an account name were allowed,
> what would you want the system to do if the string of characters you
> typed in were NOT the name of an existing account? Do you want it to
> give you an error message at that point? Do you want it to not let you
> enter an invalid character*? Is introducing this error process (and how
> user recovers) worth the complication of the user's work flow?
>
> Michael D Novack
>
> * That's possible because the set of existing accounts can be expressed
> as a tree structure with the nth level of the tree being the possible
> nth characters. So this is like the nth character entered causing the
> "not (yet) in dictionary" of the Lempel-Ziv algorithm. Notice that even
> this "not letting you" would, have issues. because as a user, how do you
> know "well what character am I allowed to enter?"
>
>
> --
> There is no possibility of social justice on a dead planet except the
> equality of the grave.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>


-- 
iii
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

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

[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, both import into
Gnucash 5.5.  The only difference is you don't have to tell Gnucash which
account to use, it is automatically specified in the first four lines.

!Account
NCredit Card Name
TCCard
^
!Type:CCard
Cc
D03/31/2024
MRestaurants
PStarbucks
T-9.53
^


On Sat, Apr 6, 2024 at 7:21 PM Fross, Michael via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Bryan, I believe "something" is purchased when you move money into an IRA.
> For me, it's a money market fund with the share price a constant $1.
>
> Michael
>
> On Sat, Apr 6, 2024 at 5:28 PM Bryan B.  wrote:
>
> > I've tried several different methods to export a .qif file from quicken
> and
> > import it into GnuCash.
> >
> > The process of importing the file goes fine until I reach the part where
> > the actual import occurs. Then I get this type of message:
> >
> > "Missing QIF investment action for transaction dated 08/31/2023."
> >
> > Upon investigation, it would seem that these transactions are from
> > automated transfers from my bank account to an IRA fund. I believe these
> > are money transfers, where the money is simply transferred without
> > explicitly purchasing a security, and then the security is purchased
> later.
> >
> > When I opened and examined the .qif file, and did some conversation with
> > ChatGPT-4, it would seem that I would have to put a line such as
> > "N***XIn***" for each of the offending transactions. I did try that, and
> > GnuCash still didn't accept those transactions (that I could see).
> >
> > Is anyone familiar with this problem already, or have any ideas on how to
> > solve it?
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > 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
> To update your subscription preferences or to unsubscribe:
> 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.
>


-- 
iii
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

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

[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 with Quicken is that the qif export doesn't
contain the first four lines, just the transactions.  Without the first
four lines you have to tell Quicken which account to use during a qif
import in order to read in a qif file that you originally exported from
Quicken.  The problem is, not all of you accounts are available for a qif
import.  The trick, after considerable web searching, was to add the first
four lines, as shown below, to a qif file.  Then you can import transaction
data into any account in Quicken.  There is a Quicken qif wiki on the
subject.

The bottom line is, the format of the qif file, with and without the first
lines of the sample qif file below, will both import into Gnucash 5.5.  The
only difference is you don't have to tell Gnucash which account to use, it
is automatically specified in the first four lines.

!Account
NCredit Card Name
TCCard
^
!Type:CCard
Cc
D03/31/2024
MRestaurants
PStarbucks
T-9.53
^

On Sat, Apr 6, 2024 at 6:28 PM Bryan B.  wrote:

> I've tried several different methods to export a .qif file from quicken and
> import it into GnuCash.
>
> The process of importing the file goes fine until I reach the part where
> the actual import occurs. Then I get this type of message:
>
> "Missing QIF investment action for transaction dated 08/31/2023."
>
> Upon investigation, it would seem that these transactions are from
> automated transfers from my bank account to an IRA fund. I believe these
> are money transfers, where the money is simply transferred without
> explicitly purchasing a security, and then the security is purchased later.
>
> When I opened and examined the .qif file, and did some conversation with
> ChatGPT-4, it would seem that I would have to put a line such as
> "N***XIn***" for each of the offending transactions. I did try that, and
> GnuCash still didn't accept those transactions (that I could see).
>
> Is anyone familiar with this problem already, or have any ideas on how to
> solve it?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>


-- 
iii
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

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

[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 resolving this so quickly.
>
> I have successfully imported both my Bank Statement and Credit Card QIF
> files on Windows 10 using this nightly build:
>
> gnucash-5.6-2024-04-06-git-5.6-9-gcab6173cd5+.setup.exe
>
> If anyone is interested, this is the layout of my QIF files.  Only the
> first two transactions are shown.  Ignore the equals signs (=).
>
> Bank Statement
> ==
> !Account
> NAssets:Bank Accounts:GNC Savings Bank
> TBank
> ^
> !Type:Bank
> D03/03/24
> T123.45
> N
> PBEING A PRESIDENT IS LIKE RIDING A TIGER
> L
> ^
> D03/03/24
> T-987.65
> N
> PA MAN HAS TO KEEP ON RIDING OR BE SWALLOWED
> LExpenses:Medical:Insurance
> ^
> ==
>
> Credit Card
> ===
> NLiabilities:Credit Cards:GNC Mastercard
> TBank
> ^
> !Type:Bank
> D02/03/24
> T-12.34
> PI NEVER SIT ON A FENCE.
> L
> ^
> D02/03/24
> T-135.79
> PI AM EITHER ON ONE SIDE OR ANOTHER.
> LExpenses:Medical:Surgery
> ^
> ===
>
>
> Regards
>
> Geoff
> =
>
>
> On 7/04/2024 7:25 pm, Christopher Lam wrote:
> > Correct Geoff, and the latest nightlies will have the correct fix.
> >
> >   https://code.gnucash.org/builds/win32/stable/
> >
> > On Sun, 7 Apr 2024, 12:10 pm Geoff,  wrote:
> >
> >> I suspect this bug fix in the 5.6 release notes is the cause:
> >>
> >> Bug 799225 - QIF Importer Crashes Silently after "Start Import" Button:
> >> Don't allow a QIF investment transaction without an action
> (buy/sell/etc)
> >>
> >> I *think* it was intended to block *investment* transactions but it
> >> appears to have blocked *banking* transactions too?
> >>
> >> Geoff
> >> =
> >>
> >> On 7/04/2024 11:44 am, Ian Cuthbertson wrote:
> >>> Bryan
> >>> This problem seems to be caused by the latest update (5.6) .I import
> >>> direct from a bank and got the same error message but when I used an
> >>> earlier version (5.4) transactions imported OK. Problem has been
> reported
> >>> in another thread.
> >>> Ian
> >>> ___
> >>> gnucash-user mailing list
> >>> gnucash-user@gnucash.org
> >>> To update your subscription preferences or to unsubscribe:
> >>> 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
> >> To update your subscription preferences or to unsubscribe:
> >> 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
> > To update your subscription preferences or to unsubscribe:
> > 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
> To update your subscription preferences or to unsubscribe:
> 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.
>


-- 
iii
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

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

[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:

> 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 resolving this so quickly.
>>
>> I have successfully imported both my Bank Statement and Credit Card QIF
>> files on Windows 10 using this nightly build:
>>
>> gnucash-5.6-2024-04-06-git-5.6-9-gcab6173cd5+.setup.exe
>>
>> If anyone is interested, this is the layout of my QIF files.  Only the
>> first two transactions are shown.  Ignore the equals signs (=).
>>
>> Bank Statement
>> ==
>> !Account
>> NAssets:Bank Accounts:GNC Savings Bank
>> TBank
>> ^
>> !Type:Bank
>> D03/03/24
>> T123.45
>> N
>> PBEING A PRESIDENT IS LIKE RIDING A TIGER
>> L
>> ^
>> D03/03/24
>> T-987.65
>> N
>> PA MAN HAS TO KEEP ON RIDING OR BE SWALLOWED
>> LExpenses:Medical:Insurance
>> ^
>> ==
>>
>> Credit Card
>> ===
>> NLiabilities:Credit Cards:GNC Mastercard
>> TBank
>> ^
>> !Type:Bank
>> D02/03/24
>> T-12.34
>> PI NEVER SIT ON A FENCE.
>> L
>> ^
>> D02/03/24
>> T-135.79
>> PI AM EITHER ON ONE SIDE OR ANOTHER.
>> LExpenses:Medical:Surgery
>> ^
>> ===
>>
>>
>> Regards
>>
>> Geoff
>> =
>>
>>
>> On 7/04/2024 7:25 pm, Christopher Lam wrote:
>> > Correct Geoff, and the latest nightlies will have the correct fix.
>> >
>> >   https://code.gnucash.org/builds/win32/stable/
>> >
>> > On Sun, 7 Apr 2024, 12:10 pm Geoff,  wrote:
>> >
>> >> I suspect this bug fix in the 5.6 release notes is the cause:
>> >>
>> >> Bug 799225 - QIF Importer Crashes Silently after "Start Import" Button:
>> >> Don't allow a QIF investment transaction without an action
>> (buy/sell/etc)
>> >>
>> >> I *think* it was intended to block *investment* transactions but it
>> >> appears to have blocked *banking* transactions too?
>> >>
>> >> Geoff
>> >> =
>> >>
>> >> On 7/04/2024 11:44 am, Ian Cuthbertson wrote:
>> >>> Bryan
>> >>> This problem seems to be caused by the latest update (5.6) .I import
>> >>> direct from a bank and got the same error message but when I used an
>> >>> earlier version (5.4) transactions imported OK. Problem has been
>> reported
>> >>> in another thread.
>> >>> Ian
>> >>> ___
>> >>> gnucash-user mailing list
>> >>> gnucash-user@gnucash.org
>> >>> To update your subscription preferences or to unsubscribe:
>> >>> 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
>> >> To update your subscription preferences or to unsubscribe:
>> >> 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
>> > To update your subscription preferences or to unsubscribe:
>> > 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
>> To update your subscription preferences or to unsubscribe:
>> 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.
>>
>
>
> --
> iii
>


-- 
iii
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Identify error transaction in QIF import

[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 or GnuCash.

I tried to export my Quicken file as a single qif and then import it into
GnuCash.  That approach was a complete disaster.  I assume that since my
Quicken file was so large, GnuCash couldn't really handle the conversion
directly.

In order for me to finally get my Quicken file imported into GnuCash, after
ten different attempts, I exported one account at a time, one year at a
time, until I had all the data exported. Then I imported each into
GnuCash.  I then had to make a number of manual edits and corrections to
the GnuCash file but that was largely due to my unfamiliarity with GnuCash.

The bottom line is, one way to make the import easier is to stick to
exporting/importing one account at a time.  When you then import the next
account, matching up transactions will be much easier.  I also found that
having the account structure already setup in GnuCash, mimicing the same
account names and categories in Quicken, made the import task much easier.
Otherwise each time you import a file that wants to add a new account or
category to GnuCash for any undefined transaction account/category gets
extremely confusing.



On Sun, Apr 21, 2024 at 8:49 AM  wrote:

> One more thing.  In Quicken, I can't find any investment transaction on
> that
> date.  They are credit card or banking transactions.
>
>
>
> From: hh8...@gmail.com 
> Sent: Sunday, April 21, 2024 8:37 AM
> To: gnucash-user@gnucash.org
> Subject: Identify error transaction in QIF import
>
>
>
> 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 try to import into GnuCash.
> Here is what I noted during the attempt.
>
>
>
> Load QIF files
>
> Line 627318: Could not parse price line: "#C093280",," 5/ 4'21"
>
>
>
> Match payees/memos to GnuCash accounts
>
> It listed about 10 that maps to Unspecified and I kept them as New selected
>
>
>
> Tradable commodities
>
> There are many and I did not review them.  Exchange or abbreviation type
> appear to be NONCURRENCY for all of them
>
>
>
> New Book Options
>
> I did not change any settings
>
>
>
> QIF Import - Failed
>
> Missing QIF investment action for transaction dated 9/19/2019
>
>
>
> I have many accounts and many transactions.  Searching the QIF file find
> many with this date.  How can I get the details on what to fix?  Is there a
> log file of import?
>
>
>
> Thanks
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>


-- 
iii
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Identify error transaction in QIF import

[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
item you specified ("#C093280",," 5/ 4'21").

I found the entire Quicken export - GnuCash import exercise to be very time
consuming and frustrating but it is possible.


On Sun, Apr 21, 2024 at 8:49 AM  wrote:

> One more thing.  In Quicken, I can't find any investment transaction on
> that
> date.  They are credit card or banking transactions.
>
>
>
> From: hh8...@gmail.com 
> Sent: Sunday, April 21, 2024 8:37 AM
> To: gnucash-user@gnucash.org
> Subject: Identify error transaction in QIF import
>
>
>
> 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 try to import into GnuCash.
> Here is what I noted during the attempt.
>
>
>
> Load QIF files
>
> Line 627318: Could not parse price line: "#C093280",," 5/ 4'21"
>
>
>
> Match payees/memos to GnuCash accounts
>
> It listed about 10 that maps to Unspecified and I kept them as New selected
>
>
>
> Tradable commodities
>
> There are many and I did not review them.  Exchange or abbreviation type
> appear to be NONCURRENCY for all of them
>
>
>
> New Book Options
>
> I did not change any settings
>
>
>
> QIF Import - Failed
>
> Missing QIF investment action for transaction dated 9/19/2019
>
>
>
> I have many accounts and many transactions.  Searching the QIF file find
> many with this date.  How can I get the details on what to fix?  Is there a
> log file of import?
>
>
>
> Thanks
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>


-- 
iii
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Identify error transaction in QIF import

[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 try to import into GnuCash.
> Here is what I noted during the attempt.
>
>
>
> Load QIF files
>
> Line 627318: Could not parse price line: "#C093280",," 5/ 4'21"
>
>
>
> Match payees/memos to GnuCash accounts
>
> It listed about 10 that maps to Unspecified and I kept them as New selected
>
>
>
> Tradable commodities
>
> There are many and I did not review them.  Exchange or abbreviation type
> appear to be NONCURRENCY for all of them
>
>
>
> New Book Options
>
> I did not change any settings
>
>
>
> QIF Import - Failed
>
> Missing QIF investment action for transaction dated 9/19/2019
>
>
>
> I have many accounts and many transactions.  Searching the QIF file find
> many with this date.  How can I get the details on what to fix?  Is there a
> log file of import?
>
>
>
> Thanks
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>


-- 
iii
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Please address broken QIF import

[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,
> https://code.gnucash.org/builds/win32/releases/gnucash-5.6-1.setup.exe
> was pushed out a couple of weeks ago and announced as a fix to an import
> problem, I believe. I admit I don't pay too much attention to discussions
> about importing, since I stopped using import features a long time ago.
> Maybe it will remedy your troubles.
>
> ⁣David T. ​
>
> On Apr 25, 2024, 3:13 AM, at 3:13 AM, Jim DeLaHunt 
> wrote:
> >On 2024-04-23 14:31, Yann Salmon via gnucash-user wrote:
> >> Since there is, if I understand correctly, a fix to this major bug, I
> >
> >> really think a 5.6.1 release would be helpful.…
> >On 2024-04-24 15:24, Yann Salmon via gnucash-user wrote:
> >> …the one thing I learned is : you do not break things, and if you do,
> >
> >> you unbreak them as quickly as possible.…
> >>
> >> …I would be interested to know the bigger picture that I am obviously
> >
> >> missing in the decision not to publish a .1 that fixes a regression
> >> (especially on a stable release) and allows Otto Normaluser and his
> >> Grandma to quickly get back on their feet by simpling doing what they
> >
> >> know and have been educated to do : upgrading their software.
> >
> >Oh, I think I can help you see the bigger picture.
> >
> >Please run a report on your financial records in GnuCash. Look for all
> >the payments you made to the GnuCash developers, in order to have the
> >use of GnuCash software.  If your records are like mine, the total
> >amount will be:
> >
> >0.00 EUR (approximately 0.00 CAD, 0.00 USD, 0.00 CNY, at current
> >exchange rates)
> >
> >I suspect that the GnuCash team has spent at least double that amount,
> >and applied it to making a 5.6.1 release. It was sufficient for them to
> >
> >reach 0% of the way to completion. (I am being sarcastic. I don't know
> >the internals of the GnuCash project.)
> >
> >Putting aside sarcasm, please remember that the GnuCash developers are
> >volunteers. They are donating their time and expertise to develop
> >GnuCash. There are not many of them. Yet they deliver regular releases,
> >
> >complete with bug fixes, and ever-increasing capabilities.  The
> >appropriate tone to take with them is one of gratitude.
> >
> >At the same time, the GnuCash developers have granted you a license to
> >GnuCash's source code. You are permitted to see the source code, to
> >diagnose the problem yourself, and to come up with a fix. If you wish,
> >you can donate the fix back to the GnuCash developers. Or, you could
> >make your own 5.6.1 release with the fix (but this is "forking", and
> >you
> >should give the new software a different name).  If you own skills do
> >not extend to diagnosing and fixing the problem, you are free to hire a
> >
> >skilled software engineer, and have them diagnose, fix, and release a
> >version of the software for you. If you want to pay the software
> >engineer for an extended time, so that they can build up a relationship
> >
> >with the GnuCash developers, they might be able to take on the task of
> >making bug-fix releases. It could be your contribution to GnuCash.
> >Please, go right ahead!
> >
> >However, you may discover that this costs you more in time and money
> >than the 0.00 EUR which you have paid for GnuCash so far.
> >
> >Best regards,
> >  —Jim DeLaHunt
> >
> >
> >On 2024-04-24 15:24, Yann Salmon via gnucash-user wrote:
> >> Hello,
> >>
> >> Le 23/04/2024 à 23:48, David Carlson a écrit :
> >>> Sir,
> >>>
> >>> In my experience most financial institutions that offer QIF exports
> >>> also offer OFX format which will often go under a similar name.
> >>
> >> Alas, a hundred times alas, not always. Not in France, at least. They
> >
> >> should…
> >>
> >> I was able, however, to use . I
> >
> >> had to reverse all transactions (which is easier to do in the QIF,
> >> btw) because my bank seems to directly produce a QIF for my point of
> >> view while GnuCash seems to expect a QIF with transactions from the
> >> bank's point of view, but that is another story.
> >>
> >>
> >>> If you need the QIF format then you will probably be stuck either
> >>> waiting for the 5.7 windows release or reverting either to an
> >earlier
> >>> 5 series or maybe even 4 series if you have an older Linux based
> >>> machine as I do.
> >>
> >> Even though the Gnucash team has been releasing new versions at a
> >> steady and formidable rythm of one every 3 to 4 months, that still
> >> makes 4 months of non-working QIF import — downgrading is really not
> >a
> >> straightforward route as software managers, for good reasons, make
> >> upgrading software easy and downgrading it harder (and one would have
> >
> >> to get the idea of doing so).
> >>
> >>

Re: [GNC] Identify error transaction in QIF import

[Joseph Keithley]

I feel your pain, my quicken data went back almost thirty years.  If there
is a more definitive description in some GnuCash log file for qif import
errors, I haven't found it.  Hopefully someone with more knowledgeable on
the inner workings of GnuCash can shed more light on that.

I gather the particular sticking point is with either an option or futures
contract.  I only have direct experience using Quicken with stocks and
bonds.  I assume the process is similar for options/futures.  I can offer
one more option for you to consider.  Make a copy of your quicken data file
(your ".QDF" file) and open it with Quicken.  Delete all the transactions
with the date in question.  Then create your QIF file to import into
GnuCash and see if your file will import.  Assuming the number of
transactions aren't too great you can then manually enter them in to
GnuCash OR create a QIF file or CSV file, manually, to import into GnuCash.

I found that if you recreate your account/category structure in GnuCash
beforehand the import becomes somewhat less laborious.




On Sun, Apr 28, 2024 at 7:43 AM  wrote:

> Hi,
>
>
>
> Thanks for the advice.  I run Quicken -> Validate and Repair File and it
> reported a few errors that I fixed.
>
>
>
> However, I still get the same error message
>
>
>
> Missing QIF investment action for transaction dated 9/19/2019
>
> I opened the QIF in text editor and searched for 9/19’19.  There are about
> 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 pointing to
> exact transaction?
>
>
>
> Thanks
>
>
>
> *From:* Joseph Keithley 
> *Sent:* Sunday, April 21, 2024 11:47 AM
> *To:* hh8...@gmail.com
> *Cc:* gnucash-user@gnucash.org
> *Subject:* Re: [GNC] Identify error transaction in QIF import
>
>
>
> 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 or GnuCash.
>
>
>
> I tried to export my Quicken file as a single qif and then import it into
> GnuCash.  That approach was a complete disaster.  I assume that since my
> Quicken file was so large, GnuCash couldn't really handle the conversion
> directly.
>
>
>
> In order for me to finally get my Quicken file imported into GnuCash,
> after ten different attempts, I exported one account at a time, one year at
> a time, until I had all the data exported. Then I imported each into
> GnuCash.  I then had to make a number of manual edits and corrections to
> the GnuCash file but that was largely due to my unfamiliarity with GnuCash.
>
>
>
> The bottom line is, one way to make the import easier is to stick to
> exporting/importing one account at a time.  When you then import the next
> account, matching up transactions will be much easier.  I also found that
> having the account structure already setup in GnuCash, mimicing the same
> account names and categories in Quicken, made the import task much easier.
> Otherwise each time you import a file that wants to add a new account or
> category to GnuCash for any undefined transaction account/category gets
> extremely confusing.
>
>
>
>
>
>
>
> On Sun, Apr 21, 2024 at 8:49 AM  wrote:
>
> One more thing.  In Quicken, I can't find any investment transaction on
> that
> date.  They are credit card or banking transactions.
>
>
>
> From: hh8...@gmail.com 
> Sent: Sunday, April 21, 2024 8:37 AM
> To: gnucash-user@gnucash.org
> Subject: Identify error transaction in QIF import
>
>
>
> 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 try to import into GnuCash.
> Here is what I noted during the attempt.
>
>
>
> Load QIF files
>
> Line 627318: Could not parse price line: "#C093280",," 5/ 4'21"
>
>
>
> Match payees/memos to GnuCash accounts
>
> It listed about 10 that maps to Unspecified and I kept them as New selected
>
>
>
> Tradable commodities
>
> There are many and I did not review them.  Exchange or abbreviation type
> appear to be NONCURRENCY for all of them
>
>
>
> New Book Options
>
> I did not change any settings
>
>
>
> QIF Import - Failed
>
> Missing QIF investment action for transaction dated 9/19/2019
>

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

[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 
wrote:

> When I copy data from Gnucash to Excel it arrives on text format along with
> the currency denomination, so I cannot then manipulate it in Excel.
> Is there anyway I can export data to Excel in data format?.
> Thanks
> David
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>


-- 
iii
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Easier way to print to PDF

[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, 2024 at 6:07 PM Daffy Duck  wrote:

> A few years ago, when you wanted to print to PDF a report, it started
> in the last directory used.  It was then changed to basically go
> through the print dialogue and start in home directory, which wastes a
> lot of time.
>
> I do now notice there is a "make PDF" icon that does nothing but bring
> up the print dialogue.
>
> Is there any way to have a quick way to print the current report to PDF
> starting in the most recent directory, like it used to be?
>
> Thanks,
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>


-- 
iii
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

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

[Joseph Keithley]

Understood.  I can tell you what I do with copy/pasting a paticular
report.  I've never had a problem with double quotes.  In my case, I
copy/paste the "Investment Portfolio" report under "Assets and Liabilities"
to Excel.  When the tab opens with the report, I put the mouse cursor on
the top left of the tab window just in front of where I want the copy to
start.  I then left-click the mouse and hold the button down and drag the
cursor down the page until everything I want to copy is highlighted and
release the left-click.  The page will automatically scroll as long as you
keep the mouse button depressed and directed at the bottom of the tab.  As
long as what want I want to copy stays highlighted, I then right click the
mouse and a small pop-up menu shows "Copy".  Then I left-click the word
copy.  I usually already have a spreadsheet open, I then right-click on an
empty cell on the spreadsheet and on the pop-up menu I pick "Paste Special"
and choose "Text".  If the pop-up menu doesn't have "Paste Special" , look
for "Paste Options" and left-click.  Another window should pop-up and
"Paste Special" should be one of the choices.The resulting spreadsheet
has everything set up in columns just like the GnuCash report.  If the
number of decimal places in your resulting Excel file isn't right then you
have to go back to the GnuCash Report tab and choose the "Options" button
on the menu 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 from a gnucash  report.
> Rgds
> David
>
>
> On Mon, 20 May 2024, 04:13 Joseph Keithley,  wrote:
>
>> 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 
>> wrote:
>>
>>> When I copy data from Gnucash to Excel it arrives on text format along
>>> with
>>> the currency denomination, so I cannot then manipulate it in Excel.
>>> Is there anyway I can export data to Excel in data format?.
>>> Thanks
>>> David
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> 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.
>>>
>>
>>
>> --
>> iii
>>
>

-- 
iii
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

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

[Joseph Keithley]

If the whole left-click hold copy and drag doesn't work well, there is an
alternate method.  When you move the mouse cursor to the top left of the
tab, move the cursor slowly to the right until the mouse cursor changes
from an arrow to a line (assuming your PC set up is similar to mine) and
left-click the mouse. Then hold down the shift key (with a finger on the
hand that doesn't work the mouse).  Then, using either the "Page Up/Down"
keyss, the arrow keys, or by clicking and/or dragging the scroll bar,
navigate to the end of your desired data.  Release the shift key and then
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:13 Joseph Keithley,  wrote:
>
>> 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 
>> wrote:
>>
>>> When I copy data from Gnucash to Excel it arrives on text format along
>>> with
>>> the currency denomination, so I cannot then manipulate it in Excel.
>>> Is there anyway I can export data to Excel in data format?.
>>> Thanks
>>> David
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> 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.
>>>
>>
>>
>> --
>> iii
>>
>

-- 
iii
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

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

[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 wrote:
> > If the whole left-click hold copy and drag doesn't work well, there is an
> > alternate method.  When you move the mouse cursor to the top left of the
> > tab, move the cursor slowly to the right until the mouse cursor changes
> > from an arrow to a line (assuming your PC set up is similar to mine) and
> > left-click the mouse. Then hold down the shift key (with a finger on the
> > hand that doesn't work the mouse).  Then, using either the "Page Up/Down"
> > keyss, the arrow keys, or by clicking and/or dragging the scroll bar,
> > navigate to the end of your desired data.  Release the shift key and then
> > left-click the end of you data.  All your data should be highlighted.
> > Right-click the mouse and then left-click on "Copy".
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>


-- 
iii
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Import from Quicken to GnuCash not Working

[Joseph Keithley]

I had a 150mb Quicken 2016 file to import.  The only way I got it to work
was to export the file into yearly qif files by account.  It took a long
time and the final gnucash file required significant hand editing to match
up transactions to the right categories and transfer accounts.  Good luck!

On Sun, Sep 22, 2024 at 3:56 AM Tom R  wrote:

> I'm trying to import a QIF file from Quicken 2016 to GnuCash 5.8 on a
> Windows 11 system.  It's a 14 MB QIF file with over 30 years of data.
> At the first step of the Import process, there are 56 issues reported,
> all the same: "Could not parse price line".  But I just click Next to
> continue and go on to the next step.  I go thru all the remaining
> steps of the Import process basically just accepting all the default
> account name mappings.  For the selected currency, I'm using USD (US
> Dollar).  At the step for Tradable Commodities, GnuCash appears to
> have already filled in all the fields (Name, Ticker, Exchange); so at
> that step I just click Next to continue.  And at that point, I click
> the Start Import button to continue.  Then the actual Import process
> begins.  In the first few minutes, the progress bar gets to around 10%
> of the way across the window.  Then things slow down dramatically.
>
> Over the next 2 to 3 hours the progress bar eventually gets to around
> maybe 20% of the way across the window.  I'm not sure how far the
> progress bar actually gets; since I've never been sitting in front of
> the screen the whole time to see how far it does get.  But when I come
> back to the computer to check on it, the GnuCash window has closed,
> with no status or error message on the screen.  And when I go and
> check to see if a .gnucash file was created, there is a file sitting
> there.  But it's extremely small -- just 3 KB in size.  And that's
> clearly a problem; since the original QIF file is 14 MB.
>
> I'm a brand new user with GnuCash.  This is the first time I'm really
> trying to use it.  And I've tried this Import process now 3 times --
> all with the same result.  So if anyone out there has some idea what's
> going on, I'd appreciate any help or suggestions you could provide.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>


-- 
iii
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Import from Quicken to GnuCash not Working

[Joseph Keithley]

You could try checking the integrity of your Quicken file first by running
one of the "Validate and Repair" options in the "File" menu under "File
Operations".  Sometimes parts of the qdf file gets corrupted and the repair
procedure may point you to various issues within your data.I broke my
qdf file into individual accounts by year before I imported them (30+ years
and roughly 100 different accounts).  That was the only way I could get
gnucash to import my complete data without crashing.  Unfortunately it was
a few years back and I don't exactly remember what import settings and
options I chose.

The only help I can offer is that you can import one year at a time and
then save the file to create a backup file.  Then import the next year and
save the file as a new backup file.  Keep up the process until one of the
imports crashes.  At least then you can narrow down what year of data is
causing the issue and you will have a backup up file of all the prior
imports.  Since the qif file is a simple text file you can open the "bad"
qif file in notepad and look through the file for errors.  You can also
skip that "bad" file and continue the process with the remaining files just
to get as much imported as possible.

On Mon, Sep 23, 2024 at 4:15 AM Tom R  wrote:

> Hi Ken.  Thanks for the detailed suggestions.  I did go ahead and try
> splitting the 30 years of Quicken into two segments -- one for the
> first 20 years, and another for the most recent 10 years.
> Unfortunately, they both resulted in the GnuCash Import process
> crashing the same way.  GnuCash just aborts and closes for both
> segments with no error message or other indication of why it's
> crashing.
>
> Your suggestion though of importing things in one year at a time might
> be a possible solution.  As a test I tried importing just one year
> like that -- 2023 by itself.  And interestingly enough, GnuCash was
> able to pull in that one year successfully.  So I guess I could try
> doing more individual years that way, one at a time.  But that sure is
> a long tedious process that I never thought would be necessary in
> migrating to GnuCash.
>
> The main problem with that method is: what happens when I find
> individual years that cause GnuCash to crash?  Will I then need to
> have to try importing that failing year one month at a time?  Then one
> week at a time?  Then one day at a time?  All in an effort to isolate
> the line in the QIF file that's causing GnuCash to fail?  It could
> take a very long time to get 30 years of Quicken data into GnuCash
> that way.
>
> I can understand that GnuCash handles some data differently than
> Quicken does.  But I would think that the Import process would be
> capable of identifying any issues it detects, and then just provide a
> log file at the end listing which lines in the QIF file are causing
> problems and need to be corrected.  The fact that a QIF file can cause
> GnuCash to just crash and close seems like a major bug in the program
> that needs to be fixed.  Are the software developers aware that this
> problem even exists?
>
> On Sun, Sep 22, 2024 at 6:56 PM Ken Farley  wrote:
> >
> > A suggestion that comes up many times in the past and even in some of
> > the responses you got is to break up the file and perhaps not try to
> > import the whole thing in one go.
> >
> > That being said, 14Mb is really not a very large file. The last time I
> > did this kind of thing a couple of years ago I loaded about 20 years of
> > data in a year at a time. The files were maybe 3Mb max each and imported
> > in minutes, not hours.
> >
> > I imported a year at a time, starting with the oldest. I found that
> > Quicken had allowed me to make some bad transactions. Also, Quicken did
> > some weird stuff to account for stock splits that don't concur with the
> > method Gnucash uses. So I slogged through all the years by reading a
> > year in, fixing all the messed up stuff, checking balances, saving. I'd
> > copy the latest "good" file to a safe spot on my hard drive as I went
> > along, in case a catastrophe occurred.
> >
> > If you're getting the kind of failure you're seeing, my approach would
> > be to split the file into two pieces. First half of years in one file,
> > second half of years in another file. Try importing each half of the
> > data. If one fails and not the other, split the failed one into two
> > halves and try importing each of them, etc. You  should be able to zero
> > in on the portion(s) of the QIF data that is "bad". You might have to
> > look into the actual QIF data (it's just a text file) and see if there
> > are any weird characters in there or something. 30 years of data
> > probably modified by dozens of different versions of Quicken might have
> > some strange entries like corrupted text fields and the like.
> >
> > Once you find (and maybe fix) the bad QIF data, I'd suggest starting a
> > fresh new Gnucash file and then import all the "good" QIF file(s) into
> > that, oldest first.
>