Online Redemption » History » Revision 2
Revision 1 (Soh Keong, 08/22/2022 04:52 PM) → Revision 2/4 (Soh Keong, 08/22/2022 04:56 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','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','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!