Updating the tblDNCConfig Table

Updating the tblDNCConfig table involves the following steps:

•   Step 1: Enable the DNC Option

•   Step 2: Set the SFTP Account Details Obtained from PossibleNOW

•   Step 3: Enable the Brand Option for DNC

•   Step 4: Set the SFTP Folder Configurations

Step 1: Enable the DNC Option

Run the following SQL statements to enable the DNC option:

Declare @tTraceString nVarchar(Max), @nRetVal Int

Set @tTraceString = N''

Set @nRetVal = 0

Exec @nRetVal = Sproc_SetDNCConfig 'DNCEnabled', '1', @tTraceString Output

Select @nRetVal, @tTraceString

Go

Note

The time taken to complete the execution of the above SQL statements will depend on the number of Lead items in Talisma.

Step 2: Set the SFTP Account Details Obtained from PossibleNOW

Run the following SQL statements to set the SFTP Account details obtained from PossibleNOW. Before running the following SQL statements, replace the text DNCAccountConfig.xml file content with the content of the DNCAccountConfig.xml file. For information about the content of the DNCAccountConfig.xml file, see Configure the DNCAccountConfig.xml File.

Declare @tAccountXML nVarchar(Max), @nRetVal Int, @tTraceString nVarchar(Max)

Set @nRetVal = 0

Set @tTraceString = N''

set @tAccountXML = N'DNCAccountConfig.xml file content '

Exec @nRetVal = Sproc_SetDNCConfig @tDataName = N'DNCAccountConfig', @tDataValue = @tAccountXML, @tTraceString = @tTraceString Output

select @nRetVal, @tTraceString

Go

Step 3: Enable the Brand Option for DNC

If Brands are configured for the DNC feature, run the following SQL statements:

Declare @tTraceString nVarchar(Max), @nRetVal Int

Set @tTraceString = N''

Set @nRetVal = 0

Exec @nRetVal = Sproc_SetDNCConfig 'DNCBrandEnabled', '1', @tTraceString Output

Select @nRetVal, @tTraceString

Go

Step 4: Set the SFTP Folder Configurations

Run the following SQL statements to set the SFTP Folder configurations obtained from PossibleNOW, after replacing the text DNCBrandToFolderConfig.xml file content with the content of the DNCBrandToFolderConfig.xml file. For information about the content of the DNCBrandToFolderConfig.xml file, see Configure the DNCBrandToFolderConfig.xml File.

Declare @tBrandXML nVarchar(Max), @nRetVal Int, @tTraceString nVarchar(Max)

Set @nRetVal = 0

Set @tTraceString = N''

set @tBrandXML = N'DNCBrandToFolderConfig.xml file content'

Exec @nRetVal = Sproc_SetDNCConfig @tDataName = N'DNCBrandConfig', @tDataValue = @tBrandXML, @tTraceString = @tTraceString Output

select @nRetVal, @tTraceString

Go

Note

When the above SQL statements are executed and the folder configuration information is integrated in Talisma, the SQL statements must not be executed again with any change in the DNCBrandToFolderConfig.xml file. A change in the DNCBrandToFolderConfig.xml for Brand configuration has a dependency with PossibleNOW and it must go through a maintenance phase with Talisma which involves time and effort.