Calendars

This section describes the commands on calendars. The default Environment can be changed.

The command uxadd CAL adds a calendar to the list of calendars or inserts one or more years into an existing calendar. Its syntax is as follows:

uxadd CAL MU=mu [LABEL=label] [NOMODEL|MODEL] [FRHOLI|NOFRHOLI] SINCE=YYYY BEFORE=YYYY [WEEK=WWWWWCC]

The command uxupd CAL modifies the characteristics of a calendar. Its syntax is as follows:

uxupd CAL MU=mu [LABEL=label] [NOMODEL|MODEL] DSINCE=U_FMT_DATE DBEFORE=U_FMT_DATE [ATTR=W|C|H|ALL] [TO=W|C|H] [DAY=MON|TUE|WED|THU|FRI|SAT|SUN|ALL]

The command uxshw CAL displays the characteristics of a calendar. Its syntax is as follows:

uxshw CAL MU=mu [NOMODEL|MODEL] [SINCE=YYYY] [BEFORE=YYYY] [OUTPUT=filename]

The command uxdlt CAL deletes a calendar. Its syntax is as follows:

uxdlt CAL MU=mu [NOMODEL|MODEL] SINCE=YYYY BEFORE=YYYY

The command uxlst CAL lists the calendars. Its syntax is as follows:

uxlst CAL [MU=mu] [INF|FULL] [OUTPUT=filename]

The command uxtra CAL transfers the calendars in another area (same company and same node). Its syntax is as follows:

uxtra CAL MU=mu [NOMODEL|MODEL] TESP=X|S|I

The command uxext CAL extracts the definition of a (template) calendar (full range). Its syntax is as follows:

uxext CAL MU=mu|UG=ug [MODEL] [REPL] [NOVERIF] OUTPUT=filename

The command uxins CAL inserts the definition of a calendar into the corresponding Dollar Universe files (full range). Its syntax is as follows:

uxins CAL MU=mu|UG=ug [MODEL] [REPL] [CIBLE=(mu,mu,...)] INPUT=filename

Description of Items

• MU= or UG=

  Calendar's associated management unit. Accepts a model identifier or a Management unit or * (wildcard accepted except for uxadd). The default calendar may be reached using the management unit " 00" (blank 00) or " " (blank).
  Format: 64 alphanumeric characters.

• MODEL | NOMODEL

  (Optional) Type of calendar.

  • MODEL: Template calendar. A MODEL calendar must be extracted / inserted or distributed in order to become operational. "MU" in this case expresses the identifier of the model.
  • NOMODEL: Non template calendar.

  Default: NOMODEL.

• LABEL=

  (Optional) Label describing the calendar.
  Format: 64 alphanumeric characters.

• SINCE=

  First year of calendar. Indicates the year from which the calendar is to start (minimum value: current year minus one).
  Format: 4 numeric characters.

• BEFORE=

  Last year of calendar. Indicates the last year created (included) in the calendar (minimum value: current year plus two). The scope of a calendar can not exceed 25 years.
  Format: 4 numeric characters.

• FRHOLI | NOFRHOLI

  (Optional) French public holidays

  • FRHOLI: the calendar will be created with French public holidays.
  • NOFRHOLI: the calendar will be created without French public holidays.

  Default: FRHOLI

• WEEK=

  (Optional) Creation mask. Indicates which creation mask for the week is used to create the calendar.
  Format: for seven days of the week (from Monday to Sunday); the type of day may be:

  • W: working
  • C: closing
  • H: holiday

Default: WEEK=(WWWWWCC): working from Monday through Friday, closed on Saturday and Sunday (default value).

• DSINCE=

  (Optional) Update starting date. Indicates the first day on which the update is applied.
  Format: Indicated by the setting U_FMT_DATE.

• DBEFORE=

  (Optional) Update finishing date. Indicates the last day (included) on which the update is applied.
  Format: Indicated by the setting U_FMT_DATE.

• ATTR=

  (Optional) Selection on the type of day. Indicates which type of day will be affected by the update.
  Format: W (working), C (closing), H (holiday) or ALL.

  Default: ALL

• TO=

  (Optional) New type. Indicates the new type of the selected days.
  Format: W (working), C (closing), H (holiday).

• DAY=

  (Optional) Day of week selection. Indicates which day of the week (or which series of days) will be updated.
  Format:

  • MON: Monday.
  • TUE: Tuesday.
  • WED: Wednesday.
  • THU: Thursday.
  • FRI: Friday.
  • SAT: Saturday.
  • SUN: Sunday.
  • or ALL: Irrespective of the day in the week (default value).

  For example: DAY=(SAT,MON): Saturdays and Mondays, DAY=WED: Wednesdays.

• CIBLE=

  Target management units for insertions. Used only by uxins.
  Format:

  • *: wildcards are accepted.
  • A management unit code, if only one management unit is targeted.
  • (mu,mu,…) if multiple management units are targeted, mu being a management unit code.

  Indicates, for the selected template calendars, the management units to be targeted (the model/template will be used to create as many calendars as there are management units in the target list).

  If two distinct models result in the generation of the same calendar (possibly in the same command), the second insertion is rejected, as it would be if the calendar already existed (a warning message is provided with each rejection). If the option "REPL" is used, the last insertion overwrites the existing calendar.

  If CIBLE=*, any non-model calendar contained in the input file will be inserted with their original MU, which must already exist on the target machine. If it does not exist the calendar will not be inserted.

  This feature makes it easy to execute backup/restore operations for the whole active scheduling base using the 4 commands listed below. It is recommended to export/import model and non-model calendars separately.

  uxext CAL MU=* OUTPUT=c:\temp\cal_nomod.ext

  uxins CAL MU=* CIBLE=* INPUT=c:\temp\cal_nomod.ext

  uxext CAL MU=* MODEL OUTPUT=c:\temp\cal_mod.ext

  uxins CAL MU=* MODEL CIBLE=* INPUT=c:\temp\cal_mod.ext

• REPL

  (Optional) Replacement flag. Indicates whether the extracted (or inserted) records delete and replace the records that already exist in the destination file.

  Default: Extraction (or insertion) is refused for each record that already exists (indicated by a message for each occurrence).

• INF | FULL

  (Optional) Display option.

  • INF: Confines display to the names of the objects.
  • FULL: Displays all available information on the list of objects.

  Default: FULL

• NOVERIF

  (Optional) only to be used with the uxext command. Force the command to skip the checking of the output data file before insertion of new records. This enhances performance and can only be used for the creation of a new output data file.

• TESP=

  Area code, target of the transfer: X for Production, S for Simulation or I for Integration.

• OUTPUT=

  • Output file for the uxext command.
  • (Optional) Output file for display storage of uxshw or uxlst commands.

  Default: The output is sent to screen.

• INPUT=

  Input file for the uxins command.

Examples

• Create the default calendar or replace the years 2010 to 2030 to the default calendar and create the calendar for the HEADQUART management unit in the current environment:

  uxadd CAL MU=\" 00\" LABEL=\"Default calendar\" SINCE=2010 BEFORE=2030

  uxadd CAL MU=HEADQUART LABEL=\"Headquarters calendar\" SINCE=2010 BEFORE=2030

• Modify the calendar for the HEADQUART Management unit in the current environment to make the period from 27/12/2018 to 31/12/2018 closed if the setting U_FMT_DATE has the value YYYYMMDD:

  uxupd CAL MU=HEADQUART DSINCE=20181227 DBEFORE=20181231 ATTR=ALL TO=C

• Display the 2018 year of the HEADQUART calendar:

  uxshw CAL MU=HEADQUART SINCE=2018 BEFORE=2018

• Delete the years 2010 to 2016 from the calendar for the HEADQUART Management unit:

  uxdlt CAL MU=HEADQUATER SINCE=2010 BEFORE=2016

• List all calendars in the current environment to the file c:\temp\LstCal.txt:

  uxlst CAL OUTPUT=c:\temp\LstCal.txt

• Transfer the template calendars of the management units beginning by D_ from the application area to the production area:

  uxtra CAL APP MU=D_* MODEL TESP=X

• Extract the template calendar "MOD" from the production area and archive the data in file c:\temp\DOC.ext:

  uxext CAL MODEL MU=MOD output=c:\temp\DOC.ext

• Insert the template calendar "MOD" from the file c:\temp\DOC.ext as a template calendar into the current environment unless it already exists:

  uxins CAL MODEL MU=MOD CIBLE=MOD input=c:\temp\DOC.ext

• Insert the template calendar "MOD" from the file c:\temp\DOC.ext. as calendar for the HEADQUART management unit in the current environment unless it already exists:

  uxins CAL MU=MOD CIBLE=HEADQUART input=c:\temp\DOC.ext