Support #7125
[TPMS_GL075] - Currency Exchange Rate
Status: | Work Completed-End life cycle | Start date: | February 08, 2017 | |
---|---|---|---|---|
Priority: | Normal | Due date: | February 09, 2017 | |
Assignee: | Najmi Pasarudin | % Done: | 100% | |
Category: | GO_Live | Spent time: | - | |
Target version: | - |
Description
Case ID : TPMS/17-0004
Listing Currency Exchange Rate tidak dipaparkan walaupun sudah klik butang Reload From BNM.
Mohon semak.
History
#1 Updated by Najmi Pasarudin over 7 years ago
- Status changed from New - Begin Life Cycle to Development / Work In Progress
- Assignee changed from Najmi Pasarudin to Aditya Prathama
Hi Adit,
Currency exchange rate no longer working because google api for feed is no longer working. Current link is:
Is there a solution to get currency without any api. Just directly to bnm.gov because want to avoid similar issue in the future. I am currently looking at regex.
Thank you.
#2 Updated by Najmi Pasarudin over 7 years ago
- Assignee changed from Aditya Prathama to Najmi Pasarudin
- % Done changed from 0 to 50
Progress:
Done removing google api and replace with direct data response from bnm.gov.my. Regex is developed to read the xml string from bnm.gov.my. Currently testing for both TPMS and batch file.
#3 Updated by Najmi Pasarudin over 7 years ago
- Status changed from Development / Work In Progress to Internal Testing
- Assignee changed from Najmi Pasarudin to Siti Norahayu Mohd Desa
- % Done changed from 50 to 90
Issue:
Currency exchange rate not working. Code no longer request data from Bank Negara in both TPMS and batch file.
Cause:
Code request data from Bank Negara via Google feed api. Since Google feed api no longer in service, code will not work anymore.
Solution:
Removed Google feed api and replace with direct data response from Bank Negara(bnm.gov.my). Regex is developed to read the xml string from bnm.gov.my.
- Login to TPMS
- Access Administration > Currency Exchange Rate module
- Click on button named "Reload From BNM"
- Expected result, currency rate date is listed in Currency Exchange Rate page.
- Access UAT server using putty
- Access to IP 172.25.96.137 with username noroot
- Access path /application/batch
- Run command: java -jar currency-exchange-rate.jar
- Expected result, command will run and successful message will appear. Also can check in TPMS.
INFO matrade.tpms.cron.Initializer: -- Done Load Currency Exchange Rate (Time Spent = xxxx ms)
Note:
Run this script to delete currency exchange rate data for testing.
select * from currency_rates where year(currdate) = 2017 and month(currdate) = 2 order by currdate desc;
delete from currency_rates where year(currdate) = 2017 and month(currdate) = 2;
#4 Updated by Siti Norahayu Mohd Desa over 7 years ago
- Status changed from Internal Testing to User Acceptance Test
send for user testing
#5 Updated by Siti Norahayu Mohd Desa over 7 years ago
- Status changed from User Acceptance Test to Pending Prod Deployment
- Assignee changed from Siti Norahayu Mohd Desa to Najmi Pasarudin
15 Feb 10:17 AM
Dear Ayu,
Done tested.
Regards,
Azliza Husain
Application Unit
Information Technology Division,
MATRADE,
Tel (DL) : +603-62077315
Tel(GL) : +603-62077077
Email: azliza@matrade.gov.my
Hi Najmi,
Please prepare migration document and war file for production deployment.
Migration Plan ID: TPMS_ID0019
War File: TPMS_v048
#6 Updated by Najmi Pasarudin over 7 years ago
- Status changed from Pending Prod Deployment to Work Completed-End life cycle
- % Done changed from 90 to 100