Optimize FlexOffers deployment process

FlexOffers and FlexOffer filters as part of Interact Channel are deployed on Interact RT with Interact channel. Marketers often modify the FlexOffers mapping table. During the Interact Channel deployment, if system detects that FlexOffer data is not in sync between DT and RT server groups, the system displays a warning message and asks the marketers to manually publish the FlexOffers to RT server group.

This enhancement removes the manual publish step, making the FlexOffers deployment more automated and user friendly. If FlexOffers is out of sync with RT server group, the system automatically publishes the FlexOffers to RT server group, synchronizing it again. Administrators can also use JVM parameter

com.unicacorp. Campaign.interact.offermapping.service.synctimeout

to control the timeout of publishing FlexOffers. The default value is 300 seconds.

Automatically reimport customer FlexOffers delimited file or database table through platform scripts scheduling or linux cronjob

Reimport customer data from database table or csv files to FlexOffers in DT. There are two types of customer data that can be re-imported to FlexOffers.

Reimport from delimited file
Reimport from database table

To manually reimport delimited file or database table, see the FlexOffers mapping tables section. This section provides details on how to run reimportFlexOffers.bat/sh script from Platform scheduling or cronjob to invoke automatic reimporting process.

The system provides two scripts.

For Windows: reimportFlexOffers.bat
For Linux: reimportFlexOffers.sh

Users can execute the scripts using command lines or using Unica Platform scheduler management user interface.

The reimportFlexOffers scripts are located at UnicaInstall\Interact\interactDT\tools\others\reimportFlexOffers.bat/sh

The scripts are based on java class ReImportFlexOffer.class. It calls the FlexOffers Restful APIs to execute reimport, system request reimportFlexOffer.jar under UnicaInstall\Interact\interactDT\tools\others\lib\ directory.

Use the command line to run reimportFlexOffers.bat/sh. Pass the reimport.properties file:

C:\UnicaInstall\Interact\interactDT\tools\others\reimportFlexOffers.bat .\conf\reimportflexoffer.properties -p<Unica password>

Request parameters to reimport table with sample data


S.NO.	Parameter name	Parameter value
1	platformurl	http://<ip>:<port>/ If Platform API Auth - Secure API access over HTTPS is enabled, https://<ip>:<port>/
2	url	http://<ip>:<port>/ If Platform API Auth - Secure API access over HTTPS is enabled, https://<ip>:<port>/
3	interactchannelIdOrName	18 If name has white space Example: interactchannelIdOrName=Test IC Replace one white space with %20 interactchannelIdOrName=Test%20IC After setting locale, ensure that your value is same as displayed in Unica UI.
4	Flexoffername	testReimportTable After setting locale, ensure that your value is same as displayed in Unica UI. Note: You must have the locale set up at the OS level.
5	sourceType	table
6	sourceFileName	UACI_OfferMapping1978
7	Username	Asm_admin

Sample reimportflexoffer.properties file

Request parameters to reimport file with sample data


S.NO.	Parameter name	Parameter value
1	platformurl	http://<ip>:<port>/ If Platform API Auth - Secure API access over HTTPS is enabled, https://<ip>:<port>/
2	url	http://<ip>:<port>/ If Platform API Auth - Secure API access over HTTPS is enabled, https://<ip>:<port>/
3	interactchannelIdOrName	18 If name has white space Example: interactchannelIdOrName=Test IC Replace one white space with %20 interactchannelIdOrName=Test%20IC After setting locale, ensure that your value is same as displayed in Unica UI.
4	flexoffername	testReimportFile After set locale, ensure that your value is same as displayed in Unica UI. Note: You must have the locale set up at the OS level.
5	sourceType	File
6	sourceFileName	C:\MyTestData\MyBigCSVData.csv
7	userName	Asm_admin
8	delimiter	,
9	fields	[{"name":"offerid","type":"LONG","value":null,"dateFormat":null,"size":20}]

The execution results display in the command window.

Using Platform schedule management UI, schedule to run reimport.bat/sh. Complete the following steps.

Update Platform config file Platform\conf\Platform_Admin_Scheduler_Scripts.
For example, update with the following line:
C:\UnicaInstall\Interact\interactDT\tools\others\reimportFlexOffers.bat
In Platform scheduler user interface, pass the following content to run parameter.
C:\UnicaInstall\Interact\interactDT\tools\others\reimportFlexOffers.bat
##C:\HCL12\IMSMain\Interact\interactDT\conf\reimportflexoffer.proerties## ##-pPassword##

Before starting the schedule request, perform a small update in reimportFlexOffers.bat/sh file, example -jar.

"C:\HCL12\IMSMain\Interact\interactDT\tools\others\lib\reimportflexoffer.jar" pass entire path of the reimportflexoffer.jar.

The reimportFlexOffers.bat/sh file will run based on the configuration of schedule. The execution result can be viewed in the Platform log.