EnterWorks - ETT 038 - Services Framework 2020-06-02 Release Highlights

EnterWorks - ETT 038 - Services Framework 2020-06-02 Release Highlights

Services Framework, Release Overview

Cancel Apply

rate limit

Code not recognized.

About this course

This details the Services Framework 2020-06-02 Release Highlights:

General

  • Removed output of passwords from log files

Change Notification

  • Increased size of CN_Condition_Value_Literal in CN_Transformation_Registry to 5000
  • Fixed issue when existing trigger invokes Change Notification Trigger using an older signature that does not pass in the item changes, avoiding a null pointer exception. The calling triggers should be updated to invoke the signature that includes the item changes to allow the Change Notification processing to act on changes made by the custom trigger
  • Changed CN_Registry CN_Create_Only to default to No if not set instead of yes to ensure backwards compatibility
  • Corrected Change Notification debug logging messages


Changed Transformation processing logic

  • Presence of CN_Target_SQL now implies an update of non-trigger records, which allows for sibling records in the same repository to be updated. Previously, the SQL was ignored resulting in the update going only to the trigger record.  Updates are only derived from CN_Target_SQL columns. Previously, one attribute could be set in all records by specifying the CN_Target_Attribute and some value source. Since SQL needs to be specified to identify the target records, it can define any attribute to be updated, making all updates defined in one place
  • Ignore column name for InternalRecordId (it is required to be the first column returned by the CN_Target_SQL query) to avoid case sensitivity to ensure proper updates to existing records

Email

  • Added support of email messages having attachments with commas in the file name. Combine attachments for different messages if combined for digest mode (when To: address and subject are the same for more than one queued message)


EPX Callout BICs

  • AttachFilesBIC – replacement BIC for the File Attachment BIC. Provides support for file names with embedded commas. File names can either be specified in separate (numbered) input arguments or in a comma-delimited list. For the latter, if a file name contains a comma, the name must be surrounded by double-quotes

Export Post-Processing/Import Pre-Processing

  • Changed outputParsedLine(PrintWriter output, HashMap parsedLine, String[] columns, String delimiter) method to honor the double quote as the text qualifier for all delimiters, not just comma. If a different text qualifier is desired, the signature that includes the text qualifier should be used

Scheduled Exports, Imports, and Promotions Scheduling Enhancement

  • Added support to limit Scheduled jobs of type Minutes to specific days and within a specific period of time.  For example, a job can be set to run every 15 minutes, but only during business hours from Monday through Friday. Four new attributes have been added on the Schedule tab:
    • Active Times Only – only allow scheduled times between the specified Active Start Time and Active End Time if Yes
    • Active Days Only – further restrict the scheduled times to the days specified in Schedule Days if Yes
    • Active Start Time – beginning time in hh:mm:ss format of when scheduled job will run (if Active Times Only is set to Yes)
    • Active End Time – ending time in hh:mm:ss format of when scheduled job will run (if Active Times Only is set to Yes)

Scheduled Imports

  • Made Source S3 Path optional to allow for files to be loaded from the root location in a bucket.
    SQL Support
  • RelinkAllNotLinkedWorkItems.sql – added detailed instructions. Added support for the EPIM and EPX databases to be renamed (e.g., EPIM_DEV, EPX_PROD, etc.). SQL generates SQL commands to re-link work items that have had their connections to repository records severed

Deployment Support

  • GenerateCustomWidgetDetailCorrections.sql & CorrectCustomWidgetDetails.sql – SQL Script and stored procedure for correcting the attributes with Custom Search Control Dynamic control type assigned after being migrated to a target EnterWorks platform where the attribute IDs are not the same as the source. The SQL script is run on the Source Enterworks EPIM database and generates the SQL commands to correct the Custom Search Control Dynamic SQL in the target EnterWorks platform after migration

 Prerequisites - EBU

About this course

This details the Services Framework 2020-06-02 Release Highlights:

General

  • Removed output of passwords from log files

Change Notification

  • Increased size of CN_Condition_Value_Literal in CN_Transformation_Registry to 5000
  • Fixed issue when existing trigger invokes Change Notification Trigger using an older signature that does not pass in the item changes, avoiding a null pointer exception. The calling triggers should be updated to invoke the signature that includes the item changes to allow the Change Notification processing to act on changes made by the custom trigger
  • Changed CN_Registry CN_Create_Only to default to No if not set instead of yes to ensure backwards compatibility
  • Corrected Change Notification debug logging messages


Changed Transformation processing logic

  • Presence of CN_Target_SQL now implies an update of non-trigger records, which allows for sibling records in the same repository to be updated. Previously, the SQL was ignored resulting in the update going only to the trigger record.  Updates are only derived from CN_Target_SQL columns. Previously, one attribute could be set in all records by specifying the CN_Target_Attribute and some value source. Since SQL needs to be specified to identify the target records, it can define any attribute to be updated, making all updates defined in one place
  • Ignore column name for InternalRecordId (it is required to be the first column returned by the CN_Target_SQL query) to avoid case sensitivity to ensure proper updates to existing records

Email

  • Added support of email messages having attachments with commas in the file name. Combine attachments for different messages if combined for digest mode (when To: address and subject are the same for more than one queued message)


EPX Callout BICs

  • AttachFilesBIC – replacement BIC for the File Attachment BIC. Provides support for file names with embedded commas. File names can either be specified in separate (numbered) input arguments or in a comma-delimited list. For the latter, if a file name contains a comma, the name must be surrounded by double-quotes

Export Post-Processing/Import Pre-Processing

  • Changed outputParsedLine(PrintWriter output, HashMap parsedLine, String[] columns, String delimiter) method to honor the double quote as the text qualifier for all delimiters, not just comma. If a different text qualifier is desired, the signature that includes the text qualifier should be used

Scheduled Exports, Imports, and Promotions Scheduling Enhancement

  • Added support to limit Scheduled jobs of type Minutes to specific days and within a specific period of time.  For example, a job can be set to run every 15 minutes, but only during business hours from Monday through Friday. Four new attributes have been added on the Schedule tab:
    • Active Times Only – only allow scheduled times between the specified Active Start Time and Active End Time if Yes
    • Active Days Only – further restrict the scheduled times to the days specified in Schedule Days if Yes
    • Active Start Time – beginning time in hh:mm:ss format of when scheduled job will run (if Active Times Only is set to Yes)
    • Active End Time – ending time in hh:mm:ss format of when scheduled job will run (if Active Times Only is set to Yes)

Scheduled Imports

  • Made Source S3 Path optional to allow for files to be loaded from the root location in a bucket.
    SQL Support
  • RelinkAllNotLinkedWorkItems.sql – added detailed instructions. Added support for the EPIM and EPX databases to be renamed (e.g., EPIM_DEV, EPX_PROD, etc.). SQL generates SQL commands to re-link work items that have had their connections to repository records severed

Deployment Support

  • GenerateCustomWidgetDetailCorrections.sql & CorrectCustomWidgetDetails.sql – SQL Script and stored procedure for correcting the attributes with Custom Search Control Dynamic control type assigned after being migrated to a target EnterWorks platform where the attribute IDs are not the same as the source. The SQL script is run on the Source Enterworks EPIM database and generates the SQL commands to correct the Custom Search Control Dynamic SQL in the target EnterWorks platform after migration

 Prerequisites - EBU

Precisely
Terms of Use Legal Privacy Notices Trademarks Sitemap Your Privacy Choices California Privacy Choices Cookie Settings