How to Hard Code Calendar for Activities?

Modified on Tue, 14 Apr at 9:28 AM

TABLE OF CONTENTS


Introduction

Sometimes you may want to ignore the Calendar used by Activities in source schedule, and instead refer to the receiving schedule's own calendar(s). This article will demonstrate how this can be achieved.


Prerequisites

In order to prevent the sender's calendars from being replicated in receiving schedule (since receiver wants to reuse their own existing calendars instead of the ones coming from the sender), you need to set this Host System Parameter (HSP) in IEA to false (see red frame):



Example of how it can be done

Here is a "step-by-step" description of how you can achieve setting calendars in a receiving Config:

Screenshot showing example of how this can be done. See below for instructions.


  1. Select the "Value Transformations" tab in Config
  2. Press "Add Core Field" button
  3. Select Field "Calendar" for Activity in popup-list
  4. Set host Host field to "Calendar"
  5. In formula set the name of the calendar you wish to use (E.g.: "MyCalendar"), or alternatively make a formula such as the one seen below (it is more readable if you split it across separate lines):


[VALUE]?.Description == "Standard" ? "7x24" :    <- If "Standard" then use "7x24"...if not then use next row

[VALUE]?.Description == "5wd8h" ? "NoMayWork" :  <- If "5wd8h" when use "NoMayWork"... if not then use the next row

"Standard"                                        <- use the original name if not found...


The result of the above formula is seen below (Source at top and result in Destination at bottom):

The source schedule activities and their calendars.


The destination schedule activities and their calendars after example mapping formula




Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article