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)

APPLIES TO:
  • Parallels Plesk Panel
  • Parallels 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');

 




cbf444538ef01b1422cefda092ea0bfe 49af2da0f2dd4c81e962790bbbd0c2b4 56797cefb1efc9130f7c48a7d1db0f0c

FEEDBACK
Was this article helpful?
Tell us how we may improve it.
Yes No
 
 
 
 
 
 
Desktop Virtualization
- Parallels Desktop 8 for Mac
- Parallels Transporter
- Parallels Desktop Switch to Mac Edition
- Parallels Desktop for Mac Enterprise Edition
- Parallels Management-Mac for Microsoft SCCM
Server Virtualization
- Parallels Cloud Server
- Parallels Containers for Windows 6.0 Beta
- Parallels Virtuozzo Containers
Automation
- Parallels Automation
- Parallels Automation for Cloud Infrastructure
- Parallels Business Automation Standard
- Parallels Virtual Automation
- Parallels Plesk Panel Suite
- Web Presence Builder
- Parallels Plesk Automation
- Parallels Small Business Panel
- Value-added Services for Hosters
- Parallels Partner Storefront
Services & Resources
- Cloud Acceleration Services
- Professional Services
- Support Services
- Training & Certification