QFX Import Problem

[aga]

On 02/03/16 14:03, Greg wrote:
> Jack,
>
> Thank you for the quick reply.  Unfortunately, I am unable to implement
> your method,  I must be missing something obvious.  Does your method
> require a plugin?
>
> When I bring up the edit account window for the credit card accounts,
> there is no Online Settings Tab.  Rather, the only tabs showing are:
>
>   * General
>   * Institution
>   * Hierarchy
>   * Limits
>   * Tax
>
> I examined each of these tabs, and there is nothing that resembles the
> tabs that you describe.  I also went through setting up a new credit
> card account and saw nothing that lead to connecting to an online
> account.  I am puzzled and assume that I have not implemented something.
>
> I reviewed the help documents to find a description of a Online Settings
> Tab but came up empty.
>
> Greg

It may be that you do not have the ofx package installed.  See if that 
helps.

Allan




>
>
> On 3/1/2016 4:03 PM, Jack wrote:
>> On 2016.03.01 09:50, Greg wrote:
>>> I am a new user of KMyMoney and still testing the program.  As such,
>>> maybe this is not an error but user inexperience.  My question is
>>> there something that I can do so that 'Pay to' field is filled in
>>> properly.  Your insight is welcome.
>>>
>>> After setting up two credit card accounts I downloaded transactions
>>> from the two banks in the QFX file format.  While the files were
>>> imported into KMyMoney successful, some of the data do not enter into
>>> proper fields.  Specifically, most of the time the 'Pay to' contains
>>> the single letter, E, and the memo field contains the payee
>>> information.  However, some of the time the 'Pay to' field contains
>>> the proper payee information information but so does the 'Memo'
>>> field; the payee information is duplicated in these cases. To correct
>>> the 'Pay to' field I have to manually edit most transactions by
>>> moving the 'Memo' field information to the 'Pay to' field.  As a
>>> consequence, this editing of most transactions negates the
>>> convenience of downloading the transactions.
>>>
>>> The date and charge (amount) fields have the correct information.
>>>
>>> I can not find anything in the QFX files that would lead to this
>>> result.  I examined the QFX files, and the payee information is
>>> always contained in the line having tag <NAME>.   To demonstrate the
>>> file information I copied a few lines where the KMyMoney successful
>>> fills in the 'Pay to' field. and a few lines showing where the it is
>>> not.
>>>
>>> KMyMoney successful filled in the 'Pay to' field (data in the date
>>> and amount fields editied) with these lines:
>>> <STMTTRN>
>>> <TRNTYPE>Debit
>>> <DTPOSTED>yyyymmdd120000
>>> <TRNAMT>-xx.xx
>>> <FITID>yyyymmdd0001
>>> <NAME>Amazon.com             AMZN
>>> </STMTTRN>
>>> While this transaction shows an Amazon charge, other transactions
>>> from local stores are properly inserted.
>>>
>>> KMyMoney filled in the 'Pay to' field with the letter E (data in the
>>> date and amount fields removed, and the store number and location
>>> were changed to nnn and AAAA) with these lines:
>>> <STMTTRN>
>>> <TRNTYPE>Debit
>>> <DTPOSTED>yyyymmdd120000
>>> <TRNAMT>-44.55
>>> <FITID>yyyymmdd0002
>>> <NAME>HARRIS TEETER #nnn     AAAA
>>> </STMTTRN>
>>>
>>> This problem occurs for both credit cards that are issued by two
>>> different banks.  So, I do not believe that this issue is due to a
>>> particular bank.
>>>
>>> I am using KMyMoney version 4.7.2 on a Windows 10 system.  The
>>> program was installed a few weeks ago.
>>
>> Greg,
>>
>> Welcome to KMyMoney.  Yes - this is something you should be able to
>> configure.  However, right now, I can only find the way to do this if
>> you have mapped the account to an online acccount.  (OFX and QFX are
>> treated exactly the same by KMM).  In this case, with the ledger open
>> for the account (you probably have to do it for each account for which
>> you import) click the Edit Account button (or select the Account/Edit
>> Account... menu item) then select the Online Settings tab, and then
>> the Import Details subtab.  There is a dropdown at the bottom labelled
>> "Payee's name is based on contents of the OFX tag" with possible
>> values PAYEEID, NAME, MEMO.
>>
>> Question to the developers:  is there an equivalent mapping for
>> aqbanking, and for libOFX, is there a way to configure it for file
>> import?  I would expect this shouldn't matter whether the OFX comes
>> from a file or from a direct connect.
>>
>> Jack
>