Re: [GNC] QIF import Failed

2024-01-07 Thread sunfish62--- via gnucash-user 
The problem with that Wikipedia article is that it focuses solely on Quicken, 
but the QIF format has essentially become an open format that other 
applications use (and implement).

Since that article doesn't mention the designation of bracketed accounts as 
fitting in any particular category, it may be that some note on the wiki 
advising of that GnuCash interpretation *might* be in order. 

⁣David T.​

On Jan 8, 2024, 5:21 AM, at 5:21 AM, Geoff  wrote:
>Wikipedia has a confusing explanation here:
>
>When editing the QIF file, check for any transaction Category (the
>field 
>starting with 'L') for an account name contained in brackets, such as 
>[Checking Account]. The brackets reference another quicken account, and
>
>if left in place will post a transaction in that account in addition to
>
>the account being imported to, with potentially troublesome results. 
>Avoid this by removing the text including the brackets and replacing 
>with another category if desired. The only exception to this is an 
>opening balance transaction, identified by 'Opening Balance' in the 'P'
>
>field (POpening Balance). In this case, the brackets need to be left in
>
>place, and the account name between the brackets must exactly match the
>
>account name in the 'N' field.
>
>https://en.wikipedia.org/wiki/Quicken_Interchange_Format
>
>Geoff
>=
>
>On 8/01/2024 12:02 pm, Derek Atkins wrote:
>> This isn't a GnuCash thing. It's a QIf thing.
>> -derek
>> Sent using my mobile device. Please excuse any typos.
>> 
>> On January 7, 2024 19:58:30 Fred Tydeman 
>wrote:
>> 
>>> Thank you.
>>>
>>> Is that documented somewhere in Gnucash?
>>>
>>> On Sun, Jan 7, 2024 at 4:02 PM Derek Atkins >> > wrote:
>>>
>>> Indeed.  QIF treats the L[XX] as Asset/Liability account and LXX
>as an
>>> Income/Expense account (Category).
>>> -derek
>>>
>> 
>___
>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.

Re: [GNC] QIF import Failed

2024-01-07 Thread Geoff 

Wikipedia has a confusing explanation here:

When editing the QIF file, check for any transaction Category (the field 
starting with 'L') for an account name contained in brackets, such as 
[Checking Account]. The brackets reference another quicken account, and 
if left in place will post a transaction in that account in addition to 
the account being imported to, with potentially troublesome results. 
Avoid this by removing the text including the brackets and replacing 
with another category if desired. The only exception to this is an 
opening balance transaction, identified by 'Opening Balance' in the 'P' 
field (POpening Balance). In this case, the brackets need to be left in 
place, and the account name between the brackets must exactly match the 
account name in the 'N' field.


https://en.wikipedia.org/wiki/Quicken_Interchange_Format

Geoff
=

On 8/01/2024 12:02 pm, Derek Atkins wrote:

This isn't a GnuCash thing. It's a QIf thing.
-derek
Sent using my mobile device. Please excuse any typos.

On January 7, 2024 19:58:30 Fred Tydeman  wrote:


Thank you.

Is that documented somewhere in Gnucash?

On Sun, Jan 7, 2024 at 4:02 PM Derek Atkins > wrote:


Indeed.  QIF treats the L[XX] as Asset/Liability account and LXX as an
Income/Expense account (Category).
-derek




___
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 Failed

2024-01-07 Thread Derek Atkins 

This isn't a GnuCash thing. It's a QIf thing.
-derek
Sent using my mobile device. Please excuse any typos.
On January 7, 2024 19:58:30 Fred Tydeman  wrote:

Thank you.

Is that documented somewhere in Gnucash?

On Sun, Jan 7, 2024 at 4:02 PM Derek Atkins  wrote:
Indeed.  QIF treats the L[XX] as Asset/Liability account and LXX as an
Income/Expense account (Category).
-derek


___
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 Failed

2024-01-07 Thread Fred Tydeman 
Thank you.

Is that documented somewhere in Gnucash?

On Sun, Jan 7, 2024 at 4:02 PM Derek Atkins  wrote:

> Indeed.  QIF treats the L[XX] as Asset/Liability account and LXX as an
> Income/Expense account (Category).
> -derek
>
>
___
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 Failed

2024-01-07 Thread Derek Atkins 
Indeed.  QIF treats the L[XX] as Asset/Liability account and LXX as an
Income/Expense account (Category).
-derek

On Sun, January 7, 2024 6:53 pm, Geoff wrote:
> Hi Fred
>
> At a guess I think the problem is the square brackets "[]" surrounding
> the Account Names - try removing them.
>
> This:
>  > L[Expenses:fees]
>
> Should be:
>  > LExpenses:fees
>
>
> Regards
>
> Geoff
> =
>
> On 7/01/2024 2:01 pm, Fred Tydeman wrote:
>> Running GC 4.14 on Linux
>> During an import of a QIF file, I am getting "Failed" on the QIF Import
>> screen.
>> The message at the top of the box says there should be details shown
>> below
>> for my review.  However, there are no details about the failure.
>>
>> Suggestions on where I should look for the details of the failure?
>>
>> The entire QIF file is:
>>
>> !Account
>> NAssets:Investments
>> TInvst
>> ^
>> !Type:Invst
>> ^
>> D02/26/2021
>> NMiscExp
>> CX
>> T0.12
>> Mfee
>> L[Expenses:fees]
>> ^
>> D03/31/2021
>> NMiscExp
>> CX
>> T0.24
>> Mfee
>> L[Expenses:fees]
>> ^
>> D04/30/2021
>> NMiscExp
>> CX
>> T0.38
>> Mfee
>> L[Expenses:fees]
>> ^
>> D05/28/2021
>> NMiscExp
>> CX
>> T0.51
>> Mfee
>> L[Expenses:fees]
>> ^
>> D06/30/2021
>> NMiscExp
>> CX
>> T0.64
>> Mfee
>> L[Expenses:fees]
>> ^
>>
>> As an experiment,
>> I changed
>>   L[Expenses:fees]
>> to
>>   LFees
>>
>> and that imported just fine (although I had to pick the mapping of Fees
>> to
>> Expenses:Fees during the import process).
>> ___
>> 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.
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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 Failed

2024-01-07 Thread Geoff 

Hi Fred

At a guess I think the problem is the square brackets "[]" surrounding 
the Account Names - try removing them.


This:
> L[Expenses:fees]

Should be:
> LExpenses:fees


Regards

Geoff
=

On 7/01/2024 2:01 pm, Fred Tydeman wrote:

Running GC 4.14 on Linux
During an import of a QIF file, I am getting "Failed" on the QIF Import
screen.
The message at the top of the box says there should be details shown below
for my review.  However, there are no details about the failure.

Suggestions on where I should look for the details of the failure?

The entire QIF file is:

!Account
NAssets:Investments
TInvst
^
!Type:Invst
^
D02/26/2021
NMiscExp
CX
T0.12
Mfee
L[Expenses:fees]
^
D03/31/2021
NMiscExp
CX
T0.24
Mfee
L[Expenses:fees]
^
D04/30/2021
NMiscExp
CX
T0.38
Mfee
L[Expenses:fees]
^
D05/28/2021
NMiscExp
CX
T0.51
Mfee
L[Expenses:fees]
^
D06/30/2021
NMiscExp
CX
T0.64
Mfee
L[Expenses:fees]
^

As an experiment,
I changed
  L[Expenses:fees]
to
  LFees

and that imported just fine (although I had to pick the mapping of Fees to
Expenses:Fees during the import process).
___
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.

[GNC] QIF import Failed

2024-01-06 Thread Fred Tydeman 
Running GC 4.14 on Linux
During an import of a QIF file, I am getting "Failed" on the QIF Import
screen.
The message at the top of the box says there should be details shown below
for my review.  However, there are no details about the failure.

Suggestions on where I should look for the details of the failure?

The entire QIF file is:

!Account
NAssets:Investments
TInvst
^
!Type:Invst
^
D02/26/2021
NMiscExp
CX
T0.12
Mfee
L[Expenses:fees]
^
D03/31/2021
NMiscExp
CX
T0.24
Mfee
L[Expenses:fees]
^
D04/30/2021
NMiscExp
CX
T0.38
Mfee
L[Expenses:fees]
^
D05/28/2021
NMiscExp
CX
T0.51
Mfee
L[Expenses:fees]
^
D06/30/2021
NMiscExp
CX
T0.64
Mfee
L[Expenses:fees]
^

As an experiment,
I changed
 L[Expenses:fees]
to
 LFees

and that imported just fine (although I had to pick the mapping of Fees to
Expenses:Fees during the import process).
___
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 - Failed

2019-11-18 Thread Derek Atkins 
HI,

D via gnucash-user  writes:

[snip]
> One common problem is that the dates in the file do not match the
> locale settings. That is, your file has DD-MM- but your locale
> uses MM-DD-.

The QIF Importer doesn't require this matching, and indeed has lots of
logic to test for four common date formats.  If there is any ambiguity
it will prompt the user to choose.  For example, if your dates look like
01/01/19, 02/12/19, 03/09/19...  Is this M-D-Y or D-M-Y?   If, however,
you have dates that look like:  01/13/19, 31/03/19 -- then it will
complain because you have conflicting date formats.   In no case does
the *QIF* importer care about your locale date setting.

[snip]
> what can cause the QIF import to fail ?

Several things can.  Could you be more explicit about how it is failing?
What error do you get?
Is there anything in the Trace File?
If you run GnuCash from the console, is anything printed there?

> Thanks,
>
> Louis

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek
-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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 - Failed

2019-11-16 Thread D via gnucash-user 
Louis,

Lots of things can cause a QIF import failure. It's usually a formatting 
problem--a tag where one isn't expected, for example.

One common problem is that the dates in the file do not match the locale 
settings. That is, your file has DD-MM- but your locale uses MM-DD-. 

If the problem isn't glaringly obvious, it may be easier to re-export a smaller 
set of transactions to isolate the problem.

HTH,
David

On November 16, 2019, at 9:29 PM, Louis Caron  wrote:

Hello,

what can cause the QIF import to fail ?

Thanks,

Louis
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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 - Failed

2019-11-16 Thread Louis Caron 
Hello,

what can cause the QIF import to fail ?

Thanks,

Louis
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.