Project

General

Profile

Actions

Online Redemption » History » Revision 2

« Previous | Revision 2/4 (diff) | Next »
Soh Keong, 08/22/2022 04:56 PM


Online Redemption

Steps

1. Verify data formating:

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

3. Put the csv file to 'offline' folder

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')

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')

Updated by Soh Keong over 2 years ago · 2 revisions