[Kmymoney] Delete/Correct Account Currency Entries

[timothy]

Hi

Thanks Allan and Thomas for your helpful replies.
Sorry for the delay, but I have been in and out.

I have attached the output of the Tools/Update Stock and Currency Prices
showing
the two entries that throw up the error. SNMM and AGMM are money market
investments accounts. The E0000... appear to have become the currencies,
but do not show in the ledgers or anywhere else. The correct currency is
shown for these accounts in ledgers, reports and investments.

I have followed Allan's instructions, but cannot save the modified .xml
in a format that kmymoney will accept. Either 'Unknown format' or 'old
binary format'.

I am running kmymoney version  4.7.90-601bc8c80c. My O/S is lmde2 (linux
mint debian edition) and I am using Libre Office to edit the .xml file.
It has various choices for formats of excel to save, but none of them
are acceptable.
It is not the editing that is the problem because I tried saving the
file without any editing and still could not read it into kmm.

If you have any advice on what format of excel to save please let me
know. Also I am opening the .xml file in libre in fixed format with no
separators, utf8.

Timothy

PS There are many more E0000.. currencies in the kmy file, but only the
two shown are being picked up. Here are other entries for E000028

  <SECURITY saf="1000" trading-currency="ZAR" symbol="AGMM" type="1"
id="E000028" name="AG Money Market" trading-market="FUND"/>

  <PRICEPAIR from="ZAR" to="E000028">
   <PRICE price="1/1" source="Yahoo Currency" date="2014-12-23"/>
   <PRICE price="1/1" source="Yahoo Currency" date="2015-01-02"/>
   <PRICE price="1/1" source="Yahoo Currency" date="2015-02-02"/>
   <PRICE price="1/1" source="Yahoo Currency" date="2015-03-27"/>
   <PRICE price="1/1" source="Yahoo Currency" date="2015-04-01"/>
   <PRICE price="1/1" source="Yahoo Currency" date="2015-04-24"/>
   <PRICE price="1/1" source="Yahoo Currency" date="2015-05-04"/>
   <PRICE price="1/1" source="Yahoo Currency" date="2015-06-01"/>
   <PRICE price="1/1" source="Yahoo Currency" date="2015-06-26"/>
   <PRICE price="1/1" source="User" date="2015-07-29"/>
   <PRICE price="1/1" source="Yahoo Currency" date="2015-08-03"/>
   <PRICE price="1/1" source="Yahoo Currency" date="2015-08-27"/>
  </PRICEPAIR>



On Wed, 2015-09-09 at 12:38 +0200, Thomas Baumgart wrote:
> Hi,
> 
> On Tuesday 08 September 2015 11:30:53 aga wrote:
> 
> > On 08/09/15 10:11, timothy wrote:
> > > Hi
> > > 
> > > I have a problem with spurious currencies. I saved my .kmy file to .xml
> > > and identified the entries which are similar to below:-
> > > 
> > >   <ACCOUNT currency="E000027" description="" parentaccount="A000353"
> > > 
> > > opened="2008-05-07" number="" lastmodified="2014-08-08" type="15"
> > > id="A000388" lastreconciled="" institution="" name="............">
> > > 
> > > The currency "E000027" is not valid and throws up errors in the Tools >
> > > Update Stock and Currency Prices option.
> > > 
> > > How would I go about changing the E0000.. to the base currency in
> > > the .kmy file? There is no way that I can see to delete these entries.
> > > They only show up in the Tools > Update Stock and Currency Prices and
> > > cannot be deleted there.
> > > 
> > > Any help would be appreciated.
> > > Regards
> > > 
> > > Timothy
---------------------
> > From Allan
> > 
> > Hi Timothy
> > 
> > Apart from the errors in the Tools/Update Stock and Currency Prices
> > option, does everything else appear to work normally?.
> > 
> > I would have expected the Consistency check to have flagged a problem
> > like this, assuming you have done one.  It might be as well to ensure
> > you keep a copy of that file in case any investigation of that aspect is
> > necessary.
> > 
> > Does the currency ID "E000027" show up elsewhere in your file?  Can you
> > see what it relates to?
> > 
> > Before anything else, ensure you have good working backup.  Bear in mind
> > that editing the file involves some risk, so take your time.  Change the
> > currency ID to that of your base currency, for just one of these
> > records, then save as XML, and you can then load that into KMM as usual.
> >   Run a Consistency check and then look for this account and see if all
> > looks normal.  Then, if OK, repeat the process for the other errors,
> > with your fingers crossed.
> ----------------------------------------
> From Thomas
> I don't repeat the security hints about keeping backups.
> 
> A type="15" account is a stock account so E000027 must be a security of some 
> stock. It should be somewhere in the file. If not, I wonder how you deleted 
> it. Are there transactions referencing this security?
> 
> If you don't see E000027 elsewhere in your file, I would create a dummy 
> security or currency, figure out its ID in the XML file and change E000027 to 
> that ID. Then start removing this stuff. It is certainly not valid if E000027 
> is missing.
> 
> Hope that helps. If instructions are unclear, please let us know.
> 
> 
> _______________________________________________
> KMyMoney mailing list
> KMyMoney at kde.org
> https://mail.kde.org/mailman/listinfo/kmymoney

-------------- next part --------------
A non-text attachment was scrubbed...
Name: tools-updateStock.jpg
Type: image/jpeg
Size: 28970 bytes
Desc: not available
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20150909/c5d76cdf/attachment-0001.jpg>