[Kmymoney] Delete/Correct Account Currency Entries

Wed Sep 9 16:13:14 UTC 2015

On 09/09/15 17:02, timothy wrote:
> I have been using LO calc. I will give the text editors a try.
> Thanks.
>

I've just used an ordinary text editor.  If I remember correctly, Kate 
can baulk if long lines are detected (but was OK just now on a quick 
test), but Gedit didn't have that problem.

Allan

> On Wed, 2015-09-09 at 11:59 -0400, Jack wrote:
>> On editing XML files - xml is a plain text format, so you are best off
>> using a text editor (emacs or vi or notepad, for example).  If
>> libreoffice thinks it is some sort of spreadsheet or excel file, it
>> will never work.  If you use libreoffice writer, I think you should be
>> able to save as plain text.  libreoffice calc would probably not be a
>> good choice for this work.
>>
>> On 2015.09.09 09:55, timothy wrote:
>>> 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
>>>
>>>
>>
>> ------quoted attachment------
>>> _______________________________________________
>>> KMyMoney mailing list
>>> KMyMoney at kde.org
>>> https://mail.kde.org/mailman/listinfo/kmymoney
>>>
>>
>> _______________________________________________
>> KMyMoney mailing list
>> KMyMoney at kde.org
>> https://mail.kde.org/mailman/listinfo/kmymoney
>
>
> _______________________________________________
> KMyMoney mailing list
> KMyMoney at kde.org
> https://mail.kde.org/mailman/listinfo/kmymoney
>