Support #7125

[TPMS_GL075] - Currency Exchange Rate

Added by Siti Norahayu Mohd Desa over 7 years ago. Updated over 7 years ago.

Status:Work Completed-End life cycleStart date:February 08, 2017
Priority:NormalDue date:February 09, 2017
Assignee:Najmi Pasarudin% Done:

100%

Category:GO_LiveSpent time:-
Target version:-

Description

Case ID : TPMS/17-0004

Listing Currency Exchange Rate tidak dipaparkan walaupun sudah klik butang Reload From BNM.

Mohon semak.

GL075 - TPMS =_ Error Currency Exchange Rate.pdf (119 KB) Siti Norahayu Mohd Desa , February 08, 2017 14:53

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:

http://ajax.googleapis.com/ajax/services/feed/load?v=1.0&num=200&q=http://www.bnm.gov.my/index.php?tpl=fxrates.tsl

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.

Test scenario for TPMS:
  1. Login to TPMS
  2. Access Administration > Currency Exchange Rate module
  3. Click on button named "Reload From BNM"
  4. Expected result, currency rate date is listed in Currency Exchange Rate page.
Test scenario for batch file:
  1. Access UAT server using putty
  2. Access to IP 172.25.96.137 with username noroot
  3. Access path /application/batch
  4. Run command: java -jar currency-exchange-rate.jar
  5. 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:

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

Also available in: Atom PDF