Differences

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

Link to this comparison view

Next revision 		Previous revision
c3s_credit_card_issues [2019/01/30 09:22]
127.0.0.1 external edit 		c3s_credit_card_issues [2019/02/06 10:52]
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 =====
  
  
Line 83: Line 53:
  
  
-====***Always ensure that you are using the most current version of the C3S files***==== +==== *Always ensure that you are using the most current version of the C3S files* ====
  
 **Resolution #1: Modify the C3S Connection String** **Resolution #1: Modify the C3S Connection String**
-  - Open the SSLIP_Options.txt+ 
 +   - Open the SSLIP_Options.txt
   - Add this option to the file and save: UpdateC3SHostConfig=0. This will prevent the SSLIP from overriding the changes that will be made next in the C3S Host configuration file.   - Add this option to the file and save: UpdateC3SHostConfig=0. This will prevent the SSLIP from overriding the changes that will be made next in the C3S Host configuration file.
-  - Open the C3SHost.exe.config file located in ...\SSLIP\Utilities\C3S\.+  - Open the C3SHost.exe.config file located in …\SSLIP\Utilities\C3S\.
   - Delete the "Integrated Security=True" parameter from the connection string.   - Delete the "Integrated Security=True" parameter from the connection string.
   - Type in User Id=USERNAME;Password=PASSWORD*;   - Type in User Id=USERNAME;Password=PASSWORD*;
Line 95: Line 66:
  
 **Resolution #2: Add User to SQL Server login** **Resolution #2: Add User to SQL Server login**
 +
   - Modify SQL Server to allow the user the SSLIP will run from as an accepted login user.   - Modify SQL Server to allow the user the SSLIP will run from as an accepted login user.
  
 **Resolution #3: Switch Users** **Resolution #3: Switch Users**
-  - Run the SSLIP as a user that has rights to the SQL Server database. 
  
 +  - Run the SSLIP as a user that has rights to the SQL Server database.