[Kmymoney] OFX transactions one at a time

[Jack]

Well, I confirm the behavior.  Unfortunately, I don't think there are  
any KMyMoney settings you can use to alter it.  It looks like it is the  
<STMTTRNRS> tags (with closing </STMTTRNRS>) of which there are four -  
each containing only one transaction.  I have not delved into the ofx  
spec looking for this tag, but I think it probably means Statement  
Transaction Record Set (or something like that) and I would expect one  
per file, not one per transaction.  Without looking at the spec, I  
can't be sure whether this is actually illegal OFX, or simply poor  
design.

You might try calling for technical help from your bank, but I strongly  
suspect that will not do much, as it seems most institutions buy (or  
lease) their OFX software from someone else, and have nobody in-house  
with any technical understanding at all, beyond reading some scripts on  
how to use Quicken.  That said, it would be interesting to see what  
Quicken would do with this file.  At minimum, you might be able to  
convince them to log the call and forward it to the technical folks who  
actually support OFX for them.

In practical terms, editing the OFX file might be possible, but  
probably not as simple as just removing the extra  
</STMTTRNRS><STMTTRNRS> pairs, since there are other sections repeated  
within them which would then probably be detected as superfluous.  Were  
you perhaps thinking about changing banks?

I'll update if I do get any more useful information out of the spec.


Jack



On 2014.12.09 20:39, William K Helbig Jr wrote:
> This message contains a small sample file (~ 152 lines) that  
> demonstrates the problem on my machine. The actual data begins with  
> the first non-blank line following this one and ends with the end of  
> the message.
> 
> 
> OFXHEADER:100
> DATA:OFXSGML
> VERSION:102
> SECURITY:NONE
> ENCODING:USASCII
> CHARSET:1252
> COMPRESSION:NONE
> OLDFILEUID:NONE
> NEWFILEUID:NONE
> 
> <OFX>
> <SIGNONMSGSRSV1>
> <SONRS>
> <STATUS>
> <CODE>0
> <SEVERITY>INFO
> </STATUS>
> <DTSERVER>20141209120713
> <LANGUAGE>ENG
> </SONRS>
> </SIGNONMSGSRSV1>
> <BANKMSGSRSV1>
> <STMTTRNRS>
> <TRNUID>0
> <STATUS>
> <CODE>0
> <SEVERITY>INFO
> </STATUS>
> <STMTRS>
> <CURDEF>USD
> <BANKACCTFROM>
> <BANKID>222222222
> <ACCTID>888888-8
> <ACCTTYPE>CHECKING
> </BANKACCTFROM>
> <BANKTRANLIST>
> <DTSTART>20140920120000
> <DTEND>20140921120000
> <STMTTRN>
> <TRNTYPE>DEBIT
> <DTPOSTED>20140920120000
> <DTUSER>20140920120000
> <TRNAMT>-58.89
> <FITID>888888-80003168462
> <NAME>ATM Withdrawal; WM SUPERCENTER
> <MEMO>ATM Withdrawal; WM SUPERCENTER #      OBERLIN      OH US
> </STMTTRN>
> </BANKTRANLIST>
> <LEDGERBAL>
> <BALAMT>3080.96
>  <DTASOF>20141209120713
> </LEDGERBAL>
> </STMTRS>
> </STMTTRNRS>
> <STMTTRNRS>
> <TRNUID>0
> <STATUS>
> <CODE>0
> <SEVERITY>INFO
> </STATUS>
> <STMTRS>
> <CURDEF>USD
> <BANKACCTFROM>
> <BANKID>222222222
> <ACCTID>888888-8
> <ACCTTYPE>CHECKING
> </BANKACCTFROM>
> <BANKTRANLIST>
> <DTSTART>20140920120000
> <DTEND>20140921120000
> <STMTTRN>
> <TRNTYPE>DEBIT
> <DTPOSTED>20140920120000
> <DTUSER>20140920120000
> <TRNAMT>-11.52
> <FITID>888888-80003168679
> <NAME>ATM Withdrawal; CIRCLE K 05321
> <MEMO>ATM Withdrawal; CIRCLE K 05321        ELYRIA       OH US
> </STMTTRN>
> </BANKTRANLIST>
> <LEDGERBAL>
> <BALAMT>3080.96
>  <DTASOF>20141209120713
> </LEDGERBAL>
> </STMTRS>
> </STMTTRNRS>
> <STMTTRNRS>
> <TRNUID>0
> <STATUS>
> <CODE>0
> <SEVERITY>INFO
> </STATUS>
> <STMTRS>
> <CURDEF>USD
> <BANKACCTFROM>
> <BANKID>222222222
> <ACCTID>888888-8
> <ACCTTYPE>CHECKING
> </BANKACCTFROM>
> <BANKTRANLIST>
> <DTSTART>20140920120000
> <DTEND>20140921120000
> <STMTTRN>
> <TRNTYPE>DEBIT
> <DTPOSTED>20140920120000
> <DTUSER>20140920120000
> <TRNAMT>-44.40
> <FITID>888888-80003168831
> <NAME>ATM Withdrawal; ABBE ROAD MARAT
> <MEMO>ATM Withdrawal; ABBE ROAD MARATHON    ELYRIA       OH US
> </STMTTRN>
> </BANKTRANLIST>
> <LEDGERBAL>
> <BALAMT>3080.96
>  <DTASOF>20141209120713
> </LEDGERBAL>
> </STMTRS>
> </STMTTRNRS>
> <STMTTRNRS>
> <TRNUID>0
> <STATUS>
> <CODE>0
> <SEVERITY>INFO
> </STATUS>
> <STMTRS>
> <CURDEF>USD
> <BANKACCTFROM>
> <BANKID>222222222
> <ACCTID>888888-8
> <ACCTTYPE>CHECKING
> </BANKACCTFROM>
> <BANKTRANLIST>
> <DTSTART>20140920120000
> <DTEND>20140921120000
> <STMTTRN>
> <TRNTYPE>DEBIT
> <DTPOSTED>20140921120000
> <DTUSER>20140921120000
> <TRNAMT>-6.25
> <FITID>888888-80003169406
> <NAME>ATM Withdrawal; WM SUPERCENTER
> <MEMO>ATM Withdrawal; WM SUPERCENTER #      OBERLIN      OH US
> </STMTTRN>
> </BANKTRANLIST>
> <LEDGERBAL>
> <BALAMT>3080.96
> <DTASOF>20141209120713
> </LEDGERBAL>
> </STMTRS>
> </STMTTRNRS>
> </BANKMSGSRSV1>
> </OFX>
> _______________________________________________
> KMyMoney mailing list
> KMyMoney at kde.org
> https://mail.kde.org/mailman/listinfo/kmymoney