transactions wrongly imported in USD currency (SOLVED)

[John Ralls]

On Mar 16, 2010, at 3:38 PM, Brendan Simon wrote:

> SOLVED.
> 
> * backup database
> 
> * uncompressed the database with gzip
> 
> * with a text editor (eg. VIM), search for USD transactions.
>  - '<cmdty:id>USD</cmdty:id>'
> 
> * verified transaction had wrong currency.
> 
> * replaced with USD with AUD
>  - '<cmdty:id>AUD</cmdty:id>'
> 
> * Open gnucash and continue.
> 
> Cheers, Brendan.
> 
> 
> On 16/03/10 3:25 PM, Brendan Simon wrote:
>> Hi,
>> 
>> I have a whole lot of transactions, that were imported from QIF files
>> that were downloaded from my bank (in Australia).
>> 
>> When I try to create splits in the transaction, it is asking me for an
>> exchange rate or value from USD to AUD.  All transactions are in AUD so
>> it shouldn't be doing this.  Previous transactions do not do this.
>> 
>> I decompressed the .gnucash database and searched for the transaction. 
>> It seems that quite a few transactions have a currency of USD which is
>> wrong.
>> 
>> I'm not sure how this happened.  There doesn't seem to be anyway to
>> change this with the GnuCash GUI .... is there ???
>> 
>> Is it ok to change the database text file, then compress with gzip ??
>> 
>> Here is an example of an _incorrect_ transaction:
>> 
>>    <gnc:transaction version="2.0.0">
>>      <trn:id type="guid">e3be63456c3b0dd071775b8424929a08</trn:id>
>>      <trn:currency>
>>        <cmdty:space>ISO4217</cmdty:space>
>> 
>>        <cmdty:id>USD</cmdty:id>
>> 
>>      </trn:currency>
>>      <trn:date-posted>
>>        <ts:date>2005-09-28 00:00:00 +1000</ts:date>
>>      </trn:date-posted>
>>      <trn:date-entered>
>>        <ts:date>2006-01-04 16:10:51 +1100</ts:date>
>>        <ts:ns>884806000</ts:ns>
>>      </trn:date-entered>
>>      <trn:description>TRANSFER    FROM FEREN - STOCKDAL LANDLORD
>>    PAYMENT</trn:description>
>>      <trn:splits>
>>        <trn:split>
>>          <split:id type="guid">0516f06d92ba7357d60da1841a97dcc7</split:id>
>>          <split:reconciled-state>c</split:reconciled-state>
>>          <split:value>73325/100</split:value>
>>          <split:quantity>73325/100</split:quantity>
>>          <split:account
>>    type="guid">4580ebb9a86619fee286aaf4997263b2</split:account>
>>        </trn:split>
>> 
>> 
>> 
>> 
>> Here is an example of an _correct_ transaction:
>> 
>>    <gnc:transaction version="2.0.0">
>>      <trn:id type="guid">763aa898ae7eaeb573eb5b2f24d79a57</trn:id>
>>      <trn:currency>
>>        <cmdty:space>ISO4217</cmdty:space>
>> 
>>        <cmdty:id>AUD</cmdty:id>
>> 
>>      </trn:currency>
>>      <trn:date-posted>
>>        <ts:date>2005-08-31 00:00:00 +1000</ts:date>
>>      </trn:date-posted>
>>      <trn:date-entered>
>>        <ts:date>2005-09-11 14:35:10 +1000</ts:date>
>>        <ts:ns>25283000</ts:ns>
>>      </trn:date-entered>
>>      <trn:description>TRANSFER    FROM FEREN - STOCKDAL LANDLORD
>>    PAYMENT</trn:description>
>>      <trn:splits>
>>        <trn:split>
>>          <split:id type="guid">cd722550abe122421294c203c3c349ad</split:id>
>>          <split:reconciled-state>n</split:reconciled-state>
>>          <split:value>73325/100</split:value>
>>          <split:quantity>73325/100</split:quantity>
>>          <split:account
>>    type="guid">4580ebb9a86619fee286aaf4997263b2</split:account>
>>        </trn:split>

Out of curiosity, do the transactions in the original .qif file indicate a currency?

Regards,
John Ralls