Project

General

Profile

Edit History

Online Redemption » History » Version 4

Soh Keong, 08/22/2022 04:57 PM

1 1 Soh Keong 
h1. Online Redemption
2 





    3
    
    
    
h2. Steps





    4
    
    
    





    5
    
    
    
1. Verify data formating:





    6
    
    
    





    7
    
    
    
!redeem_1.png!





    8
    2
    Soh Keong
    





    9
    
    
    
2. Save to csv file  with seperator pipe "|" , remove header





    10
    
    
    





    11
    
    
    
!redeem_2.png!





    12
    
    
    





    13
    
    
    
3. Put the csv file to 'offline' folder





    14
    
    
    





    15
    
    
    
!redeem_3.png!





    16
    
    
    





    17
    
    
    





    18
    
    
    
4. Execute script at "src-cosway" :





    19
    
    
    





    20
    
    
    
$JAVA_PATH/java -Dprogram.name=OfflineOnlineRedemptionItem -classpath $CP OfflineOnlineRedemptionItem ONLINE_REDEMPTION_ITEM_17032022.csv 





    21
    
    
    





    22
    
    
    





    23
    
    
    
5. Verify data is correct:





    24
    
    
    





    25
    
    
    
by ORDER_ID:





    26
    
    
    





    27
    4
    Soh Keong
    
SELECT * FROM ONLINE_REDEMPTION_ITEM WHERE ORDER_ID IN ('CW100153355MY','CW100153363MY','CW100153378MY'....)





    28
    2
    Soh Keong
    





    29
    
    
    
!redeem_4.png!





    30
    
    
    





    31
    
    
    





    32
    4
    Soh Keong
    
SELECT count(*) FROM ONLINE_REDEMPTION_ITEM WHERE ORDER_ID IN ('CW100153355MY','CW100153363MY','CW100153378MY'....)





    33
    2
    Soh Keong
    





    34
    
    
    
!redeem_5.png!