[Kmymoney] not downloading data

Thu May 16 12:29:51 UTC 2013

On Thu, 16 May 2013 13:53:14 +0200
Gary Kirkpatrick <pegngary at gmail.com> wrote:

> I
> 
> On Wed, May 15, 2013 at 3:55 PM, Jack <ostroffjh at sbcglobal.net> wrote:
> 
> > On 2013.05.15 09:48, Gary Kirkpatrick wrote:
> >
> >>  I am trying to download from my financial institution.  I worked
> >> fine earlier but I had two accounts mixed up so the data in one
> >> went to the other.  So I deleted the account in question and
> >> started over  It connects or appears to connect to the institution
> >> but no transactions are coming into the register.  I then realized
> >> I had labeled it a cash acct when it was an investment acct,
> >> deleted it and started again but still nothing downloaded into the
> >> ledger.  Perhaps there is a limit to the number of times you can
> >> do this?
> >>
> >>  I would try to get a log for a better error message.  Per my other
> > message, just create an empty file name ofxlog.txt in your home
> > directory, and try the download again.  Then look in the file.  You
> > can also post it here - but be sure to remove account numbers and
> > passwords first. ______________________________**_________________
> > KMyMoney mailing list
> > KMyMoney at kde.org
> > https://mail.kde.org/mailman/**listinfo/kmymoney<https://mail.kde.org/mailman/listinfo/kmymoney>
> >
> 
> 
> I tried it again and nothing shows in ledger but there appears to be
> data in the ledger.
> 
> There should be securities.  I have not entered any of them yet into
> KMM. Cou;d that be the problem?

I can't say for OFX, but certainly for QIF import, it is necessary to
have created the security before import, unless specific items in the
file create it.  If you launch KMM from a terminal, you would likely
get an error message.

Allan

> here is the txt
> 
> url: https://ofx.removed by me.com/ftgw/OFX/clients/download
> request:
> OFXHEADER:100
> DATA:OFXSGML
> VERSION:102
> SECURITY:NONE
> ENCODING:USASCII
> CHARSET:1252
> COMPRESSION:NONE
> OLDFILEUID:NONE
> NEWFILEUID:20130516133727.000
> 
> <OFX>
> <SIGNONMSGSRQV1>
> <SONRQ>
> <DTCLIENT>20130516133727.000
> <USERID>removed by me
> <USERPASS>removed by me
> <LANGUAGE>ENG
> <FI>
> <ORG>removed by me.com
> <FID>7776
> </FI>
> <APPID>QWIN
> <APPVER>1700
> </SONRQ>
> </SIGNONMSGSRQV1>
> <INVSTMTMSGSRQV1>
> <INVSTMTTRNRQ>
> <TRNUID>20130516133727.000
> <CLTCOOKIE>1
> <INVSTMTRQ>
> <INVACCTFROM>
> <BROKERID>removed by me.com
> <ACCTID>removed by me
> </INVACCTFROM>
> <INCTRAN>
> <DTSTART>20130316
> <INCLUDE>Y
> </INCTRAN>
> <INCOO>Y
> <INCPOS>
> <DTASOF>20130516133727.000
> <INCLUDE>Y
> </INCPOS>
> <INCBAL>Y
> </INVSTMTRQ>
> </INVSTMTTRNRQ>
> </INVSTMTMSGSRQV1>
> </OFX>
> response:
> OFXHEADER:100
> DATA:OFXSGML
> VERSION:102
> SECURITY:NONE
> ENCODING:USASCII
> CHARSET:1252
> COMPRESSION:NONE
> OLDFILEUID:NONE
> NEWFILEUID:20130516133727.000
> 
> <OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0<SEVERITY>INFO<MESSAGE>SUCCESS</STATUS><DTSERVER>20130516073730.631[-4:EDT]<LANGUAGE>ENG<FI><ORG>removed
> by
> me.com<FID>7776</FI></SONRS></SIGNONMSGSRSV1><INVSTMTMSGSRSV1><INVSTMTTRNRS><TRNUID>20130516133727.000<STATUS><CODE>0<SEVERITY>INFO<MESSAGE>SUCCESS</STATUS><INVSTMTRS><DTASOF>20130516033015.000[-4:EDT]<CURDEF>USD<INVACCTFROM><BROKERID>removed
> by me.com<ACCTID>removed by
> me</INVACCTFROM><INVTRANLIST><DTSTART>20130316000000.000[-4:EDT]<DTEND>20130516073730.876[-4:EDT]<BUYMF><INVBUY><INVTRAN><FITID>removed
> by
> me<DTTRADE>20130328000000.000[-4:EDT]<MEMO>REINVESTMENT</INVTRAN><SECID><UNIQUEID>316146604<UNIQUEIDTYPE>CUSIP</SECID><UNITS>+0000000000000.02400<UNITPRICE>000000013.300000000<COMMISSION>+00000000000000.0000<FEES>+00000000000000.0000<TOTAL>-00000000000000.3200<CURRENCY><CURRATE>1.00<CURSYM>USD</CURRENCY><SUBACCTSEC>CASH<SUBACCTFUND>CASH</INVBUY><BUYTYPE>BUY
> </BUYMF><BUYMF><INVBUY><INVTRAN><FITID>removed by
> me<DTTRADE>20130430000000.000[-4:EDT]<MEMO>REINVESTMENT</INVTRAN><SECID><UNIQUEID>316146604<UNIQUEIDTYPE>CUSIP</SECID><UNITS>+0000000000000.01000<UNITPRICE>000000013.410000000<COMMISSION>+00000000000000.0000<FEES>+00000000000000.0000<TOTAL>-00000000000000.1300<CURRENCY><CURRATE>1.00<CURSYM>USD</CURRENCY><SUBACCTSEC>CASH<SUBACCTFUND>CASH</INVBUY><BUYTYPE>BUY
> </BUYMF><INCOME>    <INVTRAN><FITID>Xremoved by
> me08801220130328<DTTRADE>20130328000000.000[-4:EDT]<MEMO>DIVIDEND
> RECEIVED</INVTRAN><SECID><UNIQUEID>316048107<UNIQUEIDTYPE>CUSIP</SECID><INCOMETYPE>DIV<TOTAL>+00000000000000.0100<SUBACCTSEC>CASH<SUBACCTFUND>CASH<CURRENCY><CURRATE>1.00<CURSYM>USD</CURRENCY>
> </INCOME><INCOME>    <INVTRAN><FITID>Xremoved by
> me08801420130328<DTTRADE>20130328000000.000[-4:EDT]<MEMO>DIVIDEND
> RECEIVED</INVTRAN><SECID><UNIQUEID>316146604<UNIQUEIDTYPE>CUSIP</SECID><INCOMETYPE>DIV<TOTAL>+00000000000000.3200<SUBACCTSEC>CASH<SUBACCTFUND>CASH<CURRENCY><CURRATE>1.00<CURSYM>USD</CURRENCY>
> </INCOME><INCOME>    <INVTRAN><FITID>Xremoved by
> me12101220130430<DTTRADE>20130430000000.000[-4:EDT]<MEMO>DIVIDEND
> RECEIVED</INVTRAN><SECID><UNIQUEID>316048107<UNIQUEIDTYPE>CUSIP</SECID><INCOMETYPE>DIV<TOTAL>+00000000000000.0100<SUBACCTSEC>CASH<SUBACCTFUND>CASH<CURRENCY><CURRATE>1.00<CURSYM>USD</CURRENCY>
> </INCOME><INCOME>    <INVTRAN><FITID>Xremoved by
> me12101420130430<DTTRADE>20130430000000.000[-4:EDT]<MEMO>DIVIDEND
> RECEIVED</INVTRAN><SECID><UNIQUEID>316146604<UNIQUEIDTYPE>CUSIP</SECID><INCOMETYPE>DIV<TOTAL>+00000000000000.1300<SUBACCTSEC>CASH<SUBACCTFUND>CASH<CURRENCY><CURRATE>1.00<CURSYM>USD</CURRENCY>
> </INCOME><INVBANKTRAN>
> <STMTTRN><TRNTYPE>DEP<DTPOSTED>20130402000000.000[-4:EDT]<TRNAMT>+00000000000064.3500<FITID>Xremoved
> by me09301120130402<NAME>DIRECT               DEPOSIT FIA<MEMO>DIRECT
> DEPOSIT FIA CARDSVC DCB
> PAYMNT<CURRENCY><CURRATE>1.00<CURSYM>USD</CURRENCY>
> </STMTTRN><SUBACCTFUND>CASH    </INVBANKTRAN><INVBANKTRAN>
> <STMTTRN><TRNTYPE>DEBIT<DTPOSTED>20130501000000.000[-4:EDT]<TRNAMT>-00000000000458.9800<FITID>Xremoved
> by me12201120130501<NAME>CASH ADVANCE         ATM0111 120<MEMO>CASH
> ADVANCE ATM0111 120386309
> VALENCIA<CURRENCY><CURRATE>1.00<CURSYM>USD</CURRENCY>
> </STMTTRN><SUBACCTFUND>CASH
> </INVBANKTRAN></INVTRANLIST><INVPOSLIST><POSMF><INVPOS><SECID><UNIQUEID>316146604<UNIQUEIDTYPE>CUSIP</SECID><HELDINACCT>MARGIN<POSTYPE>LONG<UNITS>751.31000<UNITPRICE>13.1300000<MKTVAL>+00000009864.70<DTPRICEASOF>20130516033015.000[-4:EDT]<CURRENCY><CURRATE>1.0<CURSYM>USD</CURRENCY></INVPOS></POSMF></INVPOSLIST><INVBAL><AVAILCASH>405.97<MARGINBALANCE>+00000000000.00<SHORTBALANCE>+00000000000.00<BUYPOWER>+00000010120.94<BALLIST><BAL><NAME>Networth<DESC>The
> net market value of all long and short positions in the
> account<BALTYPE>DOLLAR<VALUE>10270.67<DTASOF>20130516033015.000[-4:EDT]<CURRENCY><CURRATE>1.000<CURSYM>USD</CURRENCY></BAL><BAL><NAME>Margin
> Equity<DESC>The margin market value less any margin debit
> balance<BALTYPE>DOLLAR<VALUE>9864.7<DTASOF>20130516033015.000[-4:EDT]<CURRENCY><CURRATE>1.000<CURSYM>USD</CURRENCY></BAL><BAL><NAME>Margin
> Equity Percentage<DESC>Margin equity / market value of long and short
> positions<BALTYPE>PERCENT<VALUE>100.0<DTASOF>20130516033015.000[-4:EDT]<CURRENCY><CURRATE>1.000<CURSYM>USD</CURRENCY></BAL><BAL><NAME>Cash
> Debit Balance<DESC>Cash Debit
> Balance<BALTYPE>DOLLAR<VALUE>0.0<DTASOF>20130516033015.000[-4:EDT]<CURRENCY><CURRATE>1.000<CURSYM>USD</CURRENCY></BAL><BAL><NAME>Total
> Money Markets<DESC>The total value of all money market positions in
> the cash
> account<BALTYPE>DOLLAR<VALUE>405.97<DTASOF>20130516033015.000[-4:EDT]<CURRENCY><CURRATE>1.000<CURSYM>USD</CURRENCY></BAL><BAL><NAME>House
> Surplus<DESC>Equity amount above house
> requirements<BALTYPE>DOLLAR<VALUE>6905.29<DTASOF>20130516033015.000[-4:EDT]<CURRENCY><CURRATE>1.000<CURSYM>USD</CURRENCY></BAL><BAL><NAME>NYSE
> Surplus<DESC>Equity amount above exchange
> requirements<BALTYPE>DOLLAR<VALUE>7398.53<DTASOF>20130516033015.000[-4:EDT]<CURRENCY><CURRATE>1.000<CURSYM>USD</CURRENCY></BAL><BAL><NAME>Federal
> Call<DESC>Amount due for a federal
> call<BALTYPE>DOLLAR<VALUE>-5060.47<DTASOF>20130516033015.000[-4:EDT]<CURRENCY><CURRATE>1.000<CURSYM>USD</CURRENCY></BAL><BAL><NAME>Buying
> Power - Equities<DESC>Amount of equities you can buy on margin
> without generating a margin
> call<BALTYPE>DOLLAR<VALUE>10120.94<DTASOF>20130516033015.000[-4:EDT]<CURRENCY><CURRATE>1.000<CURSYM>USD</CURRENCY></BAL><BAL><NAME>Buying
> Power - Municipal Bonds<DESC>Amount of municipal bonds you can buy on
> margin without generating a margin
> call<BALTYPE>DOLLAR<VALUE>36556.3<DTASOF>20130516033015.000[-4:EDT]<CURRENCY><CURRATE>1.000<CURSYM>USD</CURRENCY></BAL><BAL><NAME>Buying
> Power - Government Bonds<DESC>Amount of government bonds you can buy
> on margin without generating a margin
> cal<BALTYPE>DOLLAR<VALUE>54664.4<DTASOF>20130516033015.000[-4:EDT]<CURRENCY><CURRATE>1.000<CURSYM>USD</CURRENCY></BAL><BAL><NAME>Buying
> Power - Corporate Bonds<DESC>Amount you can buy of corporate bonds on
> margin with no margin
> call<BALTYPE>DOLLAR<VALUE>18221.46<DTASOF>20130516033015.000[-4:EDT]<CURRENCY><CURRATE>1.000<CURSYM>USD</CURRENCY></BAL><BAL><NAME>Option
> Market Value<DESC>The market value of all options in the
> account<BALTYPE>DOLLAR<VALUE>0.0<DTASOF>20130516033015.000[-4:EDT]<CURRENCY><CURRATE>1.000<CURSYM>USD</CURRENCY></BAL><BAL><NAME>Option
> In The Money Amount<DESC>The in-the-money amount on covered
> options<BALTYPE>DOLLAR<VALUE>0.0<DTASOF>20130516033015.000[-4:EDT]<CURRENCY><CURRATE>1.000<CURSYM>USD</CURRENCY></BAL><BAL><NAME>Cash
> Market value<DESC>Total value of all cash account
> positions<BALTYPE>DOLLAR<VALUE>0.0<DTASOF>20130516033015.000[-4:EDT]<CURRENCY><CURRATE>1.000<CURSYM>USD</CURRENCY></BAL><BAL><NAME>Margin
> Market Value<DESC>Total value of positions in margin less
> in-the-money amount of covered
> options<BALTYPE>DOLLAR<VALUE>9864.7<DTASOF>20130516033015.000[-4:EDT]<CURRENCY><CURRATE>1.000<CURSYM>USD</CURRENCY></BAL><BAL><NAME>Short
> Market Value<DESC>Total value of short positions less in-the-money
> amount of covered put
> options<BALTYPE>DOLLAR<VALUE>0.0<DTASOF>20130516033015.000[-4:EDT]<CURRENCY><CURRATE>1.000<CURSYM>USD</CURRENCY></BAL><BAL><NAME>Available
> to Borrow<DESC>Cash amount that can be borrowed without generating a
> margin
> call<BALTYPE>DOLLAR<VALUE>5060.47<DTASOF>20130516033015.000[-4:EDT]<CURRENCY><CURRATE>1.000<CURSYM>USD</CURRENCY></BAL></BALLIST></INVBAL></INVSTMTRS></INVSTMTTRNRS></INVSTMTMSGSRSV1><SECLISTMSGSRSV1><SECLIST><MFINFO><SECINFO><SECID><UNIQUEID>316146604<UNIQUEIDTYPE>CUSIP</SECID><SECNAME>removed
> by me INFLATION PROTECTED
> BOND<TICKER>FINPX<UNITPRICE>13.1300000<DTASOF>20130516033015.000[-4:EDT]<CURRENCY><CURRATE>1.000<CURSYM>USD
> </CURRENCY></SECINFO><MFTYPE>OTHER<DTYIELDASOF>20130516033015.000[-4:EDT]</MFINFO><MFINFO><SECINFO><SECID><UNIQUEID>316048107<UNIQUEIDTYPE>CUSIP</SECID><SECNAME>removed
> by me MUNICIPAL MONEY
> MARKET<TICKER>FTEXX<DTASOF>20130516033015.000[-4:EDT]<CURRENCY><CURRATE>1.000<CURSYM>USD
> </CURRENCY></SECINFO><MFTYPE>OTHER<DTYIELDASOF>20130516033015.000[-4:EDT]</MFINFO></SECLIST></SECLISTMSGSRSV1></OFX>
> Completed
> 
> thanks for any assistance
> 
> 
> garyk