transactions wrongly imported in USD currency (SOLVED)

[Brendan Simon]

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>
> 
> 
> Thanks, Brendan.
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>