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

SELECT count(*) FROM ONLINE_REDEMPTION_ITEM WHERE ORDER_ID IN ('CW100153355MY','CW100153363MY','CW100153378MY','CW100153397MY'