Search

Language:  
Search for:

Available article translations:

How to add another currency in Customer & Business Manager of Parallels Plesk Panel (former Plesk Billing or ModernBill)

Article ID: 9358, created on Nov 24, 2010, last review on May 10, 2014

APPLIES TO:
  • Plesk
  • Plesk Billing

Resolution

Though Customer & Business Manager might not include some of the world currencies out of the box, any currency can be easily added. Please follow the intructions below:

1. Enter the host where Customer and Business Manager (formerly known as Plesk Billing or ModernBill) installed

2. Connect to Plesk Billing database. Execute the command below if Customer and Business Manager is installed on Unix machine (root access is required):
# /usr/share/plesk-billing/billing-db

In Windows first of all run

> "%plesk_bin%\dbclient.exe" --direct-sql --sql="select admin_password from databaseservers order by id asc limit 1"

to find out a password for Customer and Business Manager database. Then run:
>"%plesk_dir%\mysql\bin\mysql -uadmin –p<cbm_db_password> billing

3. Now you see MySQL client prompt. You can validate the connection by executing the query below
mysql> select * from currencies;
and getting output like
+-------------+---------------+--------------------+
| currency_id | currency_code | currency_name      |
+-------------+---------------+--------------------+
| AUD         | 036           | TRANS_CURRENCY_AUD |
| CAD         | 124           | TRANS_CURRENCY_CAD |
| EGP         | 818           | TRANS_CURRENCY_EGP |
| EUR         | 978           | TRANS_CURRENCY_EUR |
| GBP         | 826           | TRANS_CURRENCY_GBP |
| HKD         | 344           | TRANS_CURRENCY_HKD |
| JPY         | 392           | TRANS_CURRENCY_JPY |
| MXN         | 484           | TRANS_CURRENCY_MXN |
| RUB         | 643           | TRANS_CURRENCY_RUB |
| SEK         | 752           | TRANS_CURRENCY_SEK |
| SGD         | 702           | TRANS_CURRENCY_SGD |
| USD         | 840           | TRANS_CURRENCY_USD |


4. Insert the new currency. You will need 3-letter currency code (like USD for United States Dollar or PHP for Philippine Peso, etc), 3-digit numeric code (like 840 for United States Dollar or 608 for Philippine Peso) and currency name. Currency codes can be obtained from ISO 4217 (specifying wrong code may cause improper showing currency symbol and other issues). Below is a sample query:
mysql> replace into currencies (currency_id, currency_code, currency_name) values ('PHP', 608, 'Philippine peso');

 




08b3edb77202fffdd656b40acff117c1 a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c

FEEDBACK
Was this article helpful?
Tell us how we may improve it.
Yes No
 
 
 
 
 
 
Server Virtualization
- Odin Cloud Server
- Odin Containers for Windows 6.0
- Odin Virtuozzo Containers
Automation
- Odin Automation
- Odin Automation for Cloud Infrastructure
- Odin Business Automation Standard
- Odin Virtual Automation
- Odin Plesk Panel Suite
- Web Presence Builder
- Odin Plesk Automation
- Odin Small Business Panel
- Value-added Services for Hosters
- Odin Partner Storefront
Services & Resources
- Cloud Acceleration Services
- Professional Services
- Support Services
- Training & Certification