Import currency rates

[alhimik]

Hi. Can you help me. I am using two currencies in my transactions. Most of transactions i'am inputing into icash by importing from excel. How can i import rate1 and rate2?
Or i need change rates for a group of transations by SQL? How better to write SQL to change rates for all semiler transaction ?

Is it possible to store the history of currency rates in a rates table?

where i can find the tables filds summery?

thanks

 

[stanbusk]

Rates have to be applied for each transaction manually. I guess you can use a mySQL query as well to do that but the same rates will be applied to all the transactions. There is no history of currency rates but I take not of your request.

 

[alhimik]

Thank you for your answer.

I have seen the stracture of the tblTransactions.
The mean of the Transaction_CurrencyRate,Transaction_CurrencyToDefRate is clear. What does Transaction_CurrencyRecord, Transaction_CurrencyDirection1, Transaction_CurrencyDirection2 mean?

For example my DefCurrency is RUB. I'd like to change CurrencyRate for all Transactions in USD for some date. How can i undestand that the transaction is in USD?
Can you write SQL example, i'm not an SQL master :roll:

 

[alhimik]

And one more, if it is possible. How to conect icash database to MySQL server under Mac OS?
My icash file path is /users/shared/budget.
I give command mysql>use /users/shared/budget;
The result is "ERROR 1044 (42000): Access denied for user ''@'localhost' to database '/users/shared/budget'?

 

[stanbusk]

'Transaction_CurrencyRecord' is not used, you can ignore it.
'Transaction_CurrencyDirection1' and 'Transaction_CurrencyDirection2' refers to the operation to perform with the rate, '/' or '*', 0='/' and 1='*'.

About your last question, you can't do that. iCash doesn't use mySQL at all. mySQL is a vendor that sells a proprietary database system that uses the SQL language. We also use the SQL language but note the mySQL engine.