Z-Archive » MATRADE_TPMS Support

Hi ayu,

root/Cause: data issues with jasper report setting issues
  Solution : changing setting to stretch type --> relative to high band
  Please retest after deployed.. THanks a lot

HI Leo,
Kindly assist

Hi Jeng Wei,

Excel report is not showing any data,
while there is data in the PDF reports,

Tested for Programme type : Trade Fair
tested for event : SIAL CHINA 2016

Please Fix the issue

Thank You
Regards

Hi leo,

root/Cause: missing java coding at controller parts.
 solution  : adding back the coding.
 Please retest after deployed. thanks a lot

test result attached

Hi leo,

The issue tested by kak Azliza and still not tally. Please retest to confirm.

Hi Jeng Wei

The Data is not Tally,
For this report, include all the status (approve, pending approval, etc)

Please fix this
Thank You

Because inside report will print out all the company without filter by foreign or local company, that right data is not tally with system.

Hi ayu;

root/cause : Changing requirement setting
  solution   : filter query by local company plus pending approval status.
  please retest after deployed. Thanks a lot.

Hi Jeng Wei,

1. Change "Previous Participated Mission" column name to "Previous Participated Event".
2. "Previous Participated Event" value not display.
3. Please filter Business Activity & Business Interest for Mission only. No need to display if TF.
4. Title report for PDF need to change from promotion-report13 to committee report
5. Title report for Excel need to change from Company Directory Report to Committee Report
6. Excel tab need to change from Company Details By Malaysian Co to Committee Report
7. Rename product column to PRODUCT / SERVICE & EXPORT MARKET.
8. Display start date & end date (26-29 Nov 2014) instead of 26 Nov 2014 - 29 Nov 2014
9. Display multiple country with comma
10. To add Payment into Remarks column and display multiple payment if any.
11. To add Booth Requested into Remarks column

p/s: Please refer format as given by en Rizal.

Hi ayu,

Changing below-->
1)Change "Previous Participated Mission" column name to "Previous Participated Event".
2) fixed the "Previous Participated Event" value not display. to display out all the event joined by company
3)Title report for Excel need to change from Company Directory Report to Committee Report
4)Excel tab need to change from Company Details By Malaysian Co to Committee Report

The rest please List in Enhancement.
1)Please filter Business Activity & Business Interest for Mission only. No need to display if TF.
2)Excel tab need to change from Company Details By Malaysian Co to Committee Report
3)Rename product column to PRODUCT / SERVICE & EXPORT MARKET.
4)Display start date & end date (26-29 Nov 2014) instead of 26 Nov 2014 - 29 Nov 2014
5)Display multiple country with comma
6)To add Payment into Remarks column and display multiple payment if any.
7)To add Booth Requested into Remarks column.

Thanks a lot

Please refer report attachment generated as at 10/3/2016.

The changes still not reflected. Do you push the changes?
And please be informed even though the request is enhancement you need to complete by Tuesday(15/03/2016).

1. Equity Value was wrong.
2. Telephone & fax number - display with plus (+) sign
3. Postcode - Trim postcode with the State

Please assist to fix. TQ

Hi Ayu,

new Task requested
  1) adding export market
  2) business activity
  3) business interest
  4) payment status, payment mode(bank, payment mode date, amount)
  5) booth requested
  6) previous event
  Please retest after deployed.Thanks a lot.

Hi jeng Wei,

1. Please remove your hard-coded data in the report.
2. Please filter the report if SMM or TF or others. (Business Activity & Business Interest for Mission only. No need to display if TF or others)
3. To add Booth requested.

Hi Ayu,

1)was removed insert data in database to report.
    2) (Business Activity & Business Interest for Mission only. No need to display if TF or others)
      - Business Activity & Business Interest only showing for programme type 
        #SPECIALISED MARKETING MISSION,MARKET ENTRY MISSION,TRADE INVESTMENT MISSION,MARKET PENETRATION MISSION,PRIME MINISTER MISSION
        #GENERAL MARKETING MISSION,TECHNICAL MISSION.(Noted: For those Programme end with mission.)

3)To add Booth requested. Booth requested is Already adding in the report. It only available to show only for those Trade Fair programme only. (same design with the system).

Please retest after deployed. Thanks a lot.

Hi Leo,

Kindly assist to test.

1. Selection Committee Report is for Malaysian Companies with status "Pending Approval" only.
2. Please check if program type which park under :
• "Mission" the view at Remarks column will be Business Interest & Business Activity
• "TF" will view Booth requested
• Export Market will view in all program type except "INSP".

- Please request Previous Participated Event list from en. Rizal....(en Rizal will extract the Previous Participated Event list from all system)

Hi Jeng Wei

Missing 'Booth Requested' in TF Report,

Please kindly assist

Hi leo,

root/Cause: Filter by wrong programme Id by event
  solution  : changing filter programme id to 1 which is trade fair.
  Please retest after deployed. Thanks a lot.

Jeng Wei,

the same issue still exsist

please fix

test result attached

Hi Leo,

I returned back this issue to you due to Previous Participated Event still not tested. Please email to en. Rizal and request for a sample company with Previous Participated Event.

Hi Jeng Wei,

the column for Previous participated Event should be displayed,
Please check on the database,

Event : Medical Fair Thailand 2013
Company : MEDICAL DEVICES CORPORATION SDN BHD
Previous Participated Event : INTRADE 2011
MIHAS 2011
INTERNATIONAL MEDICAL, HOSPITAL & PHARMACEUTICAL EXHIBITION 2011
PLASTEC EAST 2011
CPHI WORLDWIDE 2012
ARAB HEALTH 2012
HOSPITAL EXPO 2011
TEHRAN INTERNATIONAL INDUSTRIAL FAIR 2011
CPHI WORLDWIDE 2014, PARIS
MEDICA DUSSELDORF 2013
CPHI WORLDWIDE
MEDICAL FAIR THAILAND 2013

Please sort the event based on year desc.

Please Kindly Assist

Salam Najmi,

Kindly assist.

Hi Chee Onn,

Please assist.

Hi Ayu,

Finding/Root Cause: Wrong checking previous participating company status on query.
Resolution: Check previous participating company base on approved status only.
Special Instructions: Please test on UAT or simulation environment.

Thank you.

Hi Chee Onn,

The data was OK but please sort the event based on year desc.

Hi Ayu,

Sorting done and please test again on UAT.

Thank you.

[29032016-Lizah] Tested and passed. Previous Participated Event sorted in desc order.

Issue re-open on 13/4/2014 due to Previous Participated Event not display all from DB.

Event Name: SIAL PARIS 2016
Company Name : BEN FORTUNE PASTRY MANUFACTURING (M) SDN BHD

• SIAL CANADA 2013-2013
• SIAL PARIS 2012-2012
• ANUGA 2011-2011
• FINE FOOD AUSTRALIA 2007-2007
• HOTELYMPIA 2004-2004

• SIAL CANADA 2013
• SIAL PARIS 2012
• ANUGA 2011
• FOODEX JAPAN 2011
• FINE FOOD AUSTRALIA 2007
• 53RD FANCY FOOD SHOW
• HOTELYMPIA 2004

Event Name: SIAL PARIS 2016
Company Name : KELLYFRESH FOOD MANUFACTURING SDN BHD

• FINE FOOD AUSTRALIA 2015-2015
• FINE FOOD AUSTRALIA 2014-2014
• FINE FOOD AUSTRALIA 2013,SYDNEY-2013
• SIAL MONTREAL 2009-2009
• ANUGA 2007-2007
• SIAL CHINA 2006-2006

• ANUGA 2015
• FINE FOOD AUSTRALIA 2015
• FINE FOOD AUSTRALIA 2014
• ANUGA 2013 2013-10-05
• FINE FOOD AUSTRALIA 2013, SYDNEY
• SIAL MONTREAL 2009
• ANUGA 2007
• SIAL 2006
• 52ND SUMMER FANCY FOOD SHOW, NEW YORK,
• SIAL CHINA 2006
• FOOD & HOTEL ASIA 2006

Hi Ayu,

Finding/Root Cause: Wrong event sorting function merge all event with same year
Resolution: Change event sorting function without merge all event with same year.
Special Instructions: Please try again on UAT environment.

Thank you.

Issue have been migrated to production environment on 14/04/2016 at 7.15 pm.

Refer : TPMS version 27 - Committee report
TPMS production version 27 has been deployed on 14/04/2016 at 7.15 pm. Main update is on Promotion Committee report.

25/5/2016 - Closed this issue. No feedback from user after deployment. Send email to verify on 11/5/16 - Subject: Matrade TPMS Cut Off Issue Status up to date