Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
c3s_credit_card_issues [2019/01/30 16:17]
kcifreo [***Always ensure that you are using the most current version of the C3S files***]
c3s_credit_card_issues [2019/02/06 10:52] (current)
admin
Line 1: Line 1:
-====== ​ ====== +==== Description ​====
- +
- +
- +
-Description +
- +
- +
 ====== Unmask credit card number only shows first four digits ====== ====== Unmask credit card number only shows first four digits ======
  
Line 17: Line 10:
 **Solution** **Solution**
   - For SSLIP versions 04.40.1003.0501 and later, update the C3SHost to version 1.0.1002.2601.   - For SSLIP versions 04.40.1003.0501 and later, update the C3SHost to version 1.0.1002.2601.
- 
  
  
Line 24: Line 16:
   - Run this query:   - Run this query:
  
-**UPDATE** StoreData.dbo.AccountContact +<code sql> 
- +UPDATE StoreData.dbo.AccountContact 
- +SET ModifiedDate = GETDATE() 
- +, ModifiedByUser = '​CyriousTech'​ 
-<​html><​div style="​margin-left:​ 20px;">​ **SET** ModifiedDate = **GETDATE**() </​div></​html>​ +, IsCCNumEncrypt = 1 
- +, DefaultPaymentTrackingNumber = OldAC.DefaultPaymentTrackingNumber 
- +, CCCSCustomerGuid = NULL 
- +FROM [StoreData].dbo.AccountContact 
-<​html><​div style="​margin-left:​ 20px;"> ​, ModifiedByUser = '​CyriousTech' ​</​div></​html>​ +LEFT JOIN [43_StoreData].dbo.AccountContact OldAC ON OldAC.ID = AccountContact.ID 
- +WHERE CCCSCustomerGuid IS NOT NULL 
- +</code
- +
-<​html><​div style="​margin-left:​ 20px;"> ​, IsCCNumEncrypt = 1 </​div></​html>​ +
- +
- +
- +
-<​html><​div style="​margin-left:​ 20px;"> ​, DefaultPaymentTrackingNumber = OldAC.DefaultPaymentTrackingNumber ​</​div></​html>​ +
- +
- +
- +
-<​html><​div style="​margin-left:​ 20px;"> ​, CCCSCustomerGuid = NULL </​div></​html>​ +
- +
- +
- +
-<​html><​div style="​margin-left:​ 20px;">​ **FROM** [StoreData].dbo.AccountContact ​</​div></​html>​ +
- +
- +
- +
-<​html><​div style="​margin-left:​ 20px;">​ **LEFT JOIN** [43_StoreData].dbo.AccountContact OldAC **ON** OldAC.ID = AccountContact.ID ​</​div></​html>​ +
- +
- +
- +
-<​html><​div style="​margin-left:​ 20px;">​ **WHERE** CCCSCustomerGuid ​**IS NOT NULL** </​div>​</html>+
   - Restart the SSLIP.   - Restart the SSLIP.
   - Start Control. Control will again run through the process of updating existing credit card number to C3S.   - Start Control. Control will again run through the process of updating existing credit card number to C3S.
Line 62: Line 32:
  
  
-===== Elevon ​information fields not appearing in Account Setup\Unable to Process Credit cards =====+===== Elavon ​information fields not appearing in Account Setup\Unable to Process Credit cards =====