Project

General

Profile

History

Online Redemption » History » Revision 3

Revision 2 (Soh Keong, 08/22/2022 04:56 PM) → Revision 3/4 (Soh Keong, 08/22/2022 04:57 PM) 

h1. Online Redemption 

 h2. Steps 

 1. Verify data formating: 

 !redeem_1.png! 

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

 !redeem_2.png! 

 3. Put the csv file to 'offline' folder 

 !redeem_3.png! 


 4. Execute script at "src-cosway" : 

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


 5. Verify data is correct: 

 by ORDER_ID: 

 SELECT * FROM ONLINE_REDEMPTION_ITEM WHERE ORDER_ID IN ('CW100153355MY','CW100153363MY','CW100153378MY') ('CW100153355MY','CW100153363MY','CW100153378MY','CW100153397MY','CW100153399MY','CW100153405MY','CW100153424MY','CW100153445MY','CW100153484MY','CW100153595MY','CW100153596MY','CW100153620MY','CW100153788MY','CW100153956MY','CW100153999MY','CW100154020MY','CW100154021MY','CW100154170MY','CW100154224MY','CW100154242MY','CW100154269MY','CW100154319MY','CW100154404MY','CW100154441MY','CW100154554MY','CW100154696MY','CW100154716MY','CW100154726MY','CW100154766MY','CW100154782MY','CW100154783MY','CW100154832MY','CW100154833MY','CW100154834MY','CW100154835MY','CW100154836MY','CW100154847MY','CW100154848MY','CW100154849MY','CW100154850MY','CW100154857MY','CW100154858MY','CW100154859MY','CW100154860MY','CW100154873MY','CW100154876MY','CW100154883MY','CW100154884MY','CW100154901MY','CW100154910MY','CW100154911MY','CW100154912MY','CW100154913MY','CW100154923MY','CW100154929MY','CW100154930MY','CW100154931MY','CW100154933MY','CW100154952MY','CW100154975MY','CW100154979MY','CW100154985MY') 

 !redeem_4.png! 


 SELECT count(*) FROM ONLINE_REDEMPTION_ITEM WHERE ORDER_ID IN ('CW100153355MY','CW100153363MY','CW100153378MY','CW100153397MY' ('CW100153355MY','CW100153363MY','CW100153378MY','CW100153397MY','CW100153399MY','CW100153405MY','CW100153424MY','CW100153445MY','CW100153484MY','CW100153595MY','CW100153596MY','CW100153620MY','CW100153788MY','CW100153956MY','CW100153999MY','CW100154020MY','CW100154021MY','CW100154170MY','CW100154224MY','CW100154242MY','CW100154269MY','CW100154319MY','CW100154404MY','CW100154441MY','CW100154554MY','CW100154696MY','CW100154716MY','CW100154726MY','CW100154766MY','CW100154782MY','CW100154783MY','CW100154832MY','CW100154833MY','CW100154834MY','CW100154835MY','CW100154836MY','CW100154847MY','CW100154848MY','CW100154849MY','CW100154850MY','CW100154857MY','CW100154858MY','CW100154859MY','CW100154860MY','CW100154873MY','CW100154876MY','CW100154883MY','CW100154884MY','CW100154901MY','CW100154910MY','CW100154911MY','CW100154912MY','CW100154913MY','CW100154923MY','CW100154929MY','CW100154930MY','CW100154931MY','CW100154933MY','CW100154952MY','CW100154975MY','CW100154979MY','CW100154985MY') 

 !redeem_5.png!