Task #592

IBFT Reports

Added by Latipah Abdul Rashid almost 14 years ago. Updated almost 14 years ago.

Status:Work Completed-End life cycleStart date:November 25, 2010
Priority:NormalDue date:November 26, 2010
Assignee:Latipah Abdul Rashid% Done:

100%

Category:-Spent time:4.00 hours
Target version:-

Description

New report:
  1. IBFT report
Report modification:
  1. internet transaction history report
  2. daily consolidated report
  3. monthly consolidated report
Report to monitor
  1. user activities report

InternetTransactionReport_DAILY_20101109.csv Magnifier (2.81 KB) Hafizudin MD, November 10, 2010 17:48

UserActivitiesReport_DAILY_20101109.txt Magnifier (7.61 KB) Hafizudin MD, November 10, 2010 17:48

UserActivitiesReport_DAILY_20101109.csv Magnifier (4.76 KB) Hafizudin MD, November 10, 2010 17:48

IBFTTransferReport_DAILY_20101109.txt Magnifier (4.12 KB) Hafizudin MD, November 10, 2010 17:48

IBFTTransferReport_DAILY_20101109.csv Magnifier (1.99 KB) Hafizudin MD, November 10, 2010 17:48

ConsolidatedTransactionReport_DAILY_20101109.txt Magnifier (3.74 KB) Hafizudin MD, November 10, 2010 17:48

ConsolidatedTransactionReport_DAILY_20101109.csv Magnifier (1.96 KB) Hafizudin MD, November 10, 2010 17:48

InternetTransactionReport_DAILY_20101109.txt Magnifier (5.42 KB) Hafizudin MD, November 10, 2010 17:48

MonthlyConsolidatedTransactionReport_MONTHLY_201010.csv Magnifier (1.98 KB) Hafizudin MD, November 15, 2010 12:14

MonthlyConsolidatedTransactionReport_MONTHLY_201010.txt Magnifier (3.74 KB) Hafizudin MD, November 15, 2010 12:14

IBFTTransferReport_DAILY_20101109.txt Magnifier (4.37 KB) Hafizudin MD, November 15, 2010 12:14

IBFTTransferReport_DAILY_20101109.csv Magnifier (2.01 KB) Hafizudin MD, November 15, 2010 12:14

ITEPSReport_DAILY_20101130.txt Magnifier (2.95 KB) Hafizudin MD, November 30, 2010 13:07

ITEPSReport_DAILY_20101130.csv Magnifier (1.25 KB) Hafizudin MD, November 30, 2010 13:07

History

#1 Updated by Sarinah Darsy almost 14 years ago

  • Status changed from New - Begin Life Cycle to Development / Work In Progress
  • % Done changed from 0 to 90

Done creating & updating reports related to IBFT but cannot be fully tested coz IB part for IBFT Transfer module is not yet done. This is tested by manually put the dummy data at the database.

Created new report named:
IBFTTransferReport_DAILY_<yyyyMMdd>.txt/csv

report changed on:
1) InternetTransactionReport_DAILY_<yyyyMMdd>.txt/csv
2) ConsolidatedTransactionReport_DAILY_<yyyyMMdd>.txt/csv
3) ConsolidatedTransactionReport_MONTHLY_<yyyyMMdd>.txt/csv

IBFT transaction should also reflected to report named:
UserActivitiesReport_DAILY_<yyyyMMdd>.txt/csv

#2 Updated by Sarinah Darsy almost 14 years ago

  • Due date changed from October 29, 2010 to November 10, 2010
  • Status changed from Development / Work In Progress to Internal Testing
  • % Done changed from 90 to 100

Hi Hafiz,

Need you to retest report generated for IBFT transaction.

There are Five reports included:
1) IBFTTransferReport_DAILY_<yyyyMMdd>.txt/csv
2) InternetTransactionReport_DAILY_<yyyyMMdd>.txt/csv
3) ConsolidatedTransactionReport_DAILY_<yyyyMMdd>.txt/csv
4) ConsolidatedTransactionReport_MONTHLY_<yyyyMMdd>.txt/csv
5) UserActivitiesReport_DAILY_<yyyyMMdd>.txt/csv

Testing Environment

to generate the report file:
- project located at - /opt/REPORT/IBUtils_IBFT
- open putty then run:
- cd /opt/REPORT/IBUtils_IBFT
- ./rundailyreport.sh
- ./runmonthlyreport.sh
- or you can manually generate the report for which date you want by run:
- ./runReport.sh and follow the instruction.

To get the IBFT report file
- you can check the file generated, on BVMC (select 'Content' tab > 'IB Report' menu) by:
login as:
username: ibReport01
password: report01

then get the report (txt and csv file) for named:

1) IBFTTransferReport_DAILY_<yyyyMMdd>.txt/csv
2) InternetTransactionReport_DAILY_<yyyyMMdd>.txt/csv
3) ConsolidatedTransactionReport_DAILY_<yyyyMMdd>.txt/csv
4) ConsolidatedTransactionReport_MONTHLY_<yyyyMMdd>.txt/csv
5) UserActivitiesReport_DAILY_<yyyyMMdd>.txt/csv

Thanks. Any enquiry let me know.

#3 Updated by Latipah Abdul Rashid almost 14 years ago

  • Assignee changed from Sarinah Darsy to Hafizudin MD
  • % Done changed from 100 to 80

Hafiz, FYA.
Darsy, pls assign to hafiz if ready to test next time.

#4 Updated by Hafizudin MD almost 14 years ago

bug report

BFTTransferReport_DAILY_20101109.txt

1) Reason length is to short

2) from record we get 1 successful , 2 unsuccessful . but get this result

Total Successful/Accepted Transfer: 0
Total Unsuccessful Transfer: 3
Below information is only for Successful/Accepted transaction
Currency Total:-

delay testing
cannot regenerate monthly report for Consolidated Transaction
waiting for darsy to fix it

#5 Updated by Hafizudin MD almost 14 years ago

tested by hafiz
Status : passed

#6 Updated by Latipah Abdul Rashid almost 14 years ago

  • Due date changed from November 10, 2010 to November 26, 2010
  • Status changed from Work Completed-End life cycle to Development / Work In Progress
  • Assignee changed from Latipah Abdul Rashid to Sarinah Darsy
  • Start date changed from October 27, 2010 to November 25, 2010
  • % Done changed from 100 to 40

ITEPS Report to include IBFT trxn records.

#7 Updated by Sarinah Darsy almost 14 years ago

  • Status changed from Development / Work In Progress to Internal Testing
  • Assignee changed from Sarinah Darsy to Hafizudin MD
  • % Done changed from 40 to 90

Already update the report to include IBFT in ITEPS report. Changes made at file IBReports.java at method getFundTransferSelectStatementSpecial() and add new method named getIBFTStatementSpecial() to get all IBFT transaction.

Hafiz please retest it.

U need to make some transaction for IBFT module then u try generate the report. supposedly inside report named ITEPS report should display IBFT transaction if the transaction is there.

TESTING ENVIRONVIRONMET:
- same as previous report testing environment, but you need to access the file from BVMC which Report Type is '*ITEPS Report*'

and revert me the status. TQ.

#8 Updated by Hafizudin MD almost 14 years ago

tested by hafiz
status : passed

Also available in: Atom PDF