1. Parameter sheet creation function

1.1. Introduction

This document aims to explain the Parameter sheet creation function and how to use it.

1.2. Parameter sheet creation function overview

The Parameter creation function allows userse to create menus that can be used in ITA.

There are 2 different types of menus that can be created. "Parameter sheets" and "Data sheets".

Created menus (Parameter sheets/Data sheets) can be operated through the Web UI, Excel and RestAPI.

Users can freely customize the Menu (Parameter sheets/Data sheets) items, including the number of items, their format, size and input restrictions.

Users are also able to reference other menus through a pulldown selection item in order to prevent inconsistencies.

1.2.1. Parameter sheet

• Managing IaC variable values

  Useres can create parameter sheets that can be configured in the different drivers'"Substitute value automatic registration settings".

  In the "Creation target" item found in "Parameter sheet creation" menu group > "Define/Create parameter sheet" menu > "Parameter sheet creation" information tab > Basic information slot, created menus with Parameter sheets (With Host/Operation) and Parameter sheet (With operations) are called Parameter sheets.

  By configuring the target parameter sheet and IaC variables in the different drivers' "Substitute value automatic registration settings" menu, users can automatically substitute values that are input into parameter sheets' "Parameter" items.

  

  図 1.5 Parameter sheet (With host/operation) definition page

  

  図 1.6 Parameter sheet use example

• Items that can be selected in Parameter sheets
  • Host/with operation

    Creates parameter sheets in units of "Hosts" and "Operations".
  • With operation

    Creates parameter sheets in units of Operations.
  • Using host group

    Links "Host group function" and allows users to manage IaC variable values
  • Using bundles

    Allows for bundling items together when configuring repeating parameters.

1.2.2. Data sheet

• Managing data within ITA

  Users can create data sheets where items can be freely created. Note that Data sheets can not be used by the different drivers' "Substitute value automatic registration settings".

  Data sheets can however be used as a CMDB (Configuration Management Database, Structure management database) to manage information in ITA.

  More specifically, they can be used as items on a pulldown list.

  警告

  Note that in order to access them from pulldown lists, the items must have both Required and Unique contraint checked.

  

  図 1.7 Data sheet definition page

  

  図 1.8 Data sheet use example

1.3. Parameter sheet creation function main functions

The Parameter sheet creation function can be divided into the following categories

• Web

  Web content. Allows users to use the Parameter sheet creation function through the Browser.
• Backyard

  A resident process that runs on a server independently from the Web content.

1.4. Parameter sheet creation function menu group

The menu "Parameter sheet creation" menu group and the belonging menus are as following.

• When creating parameter sheets or data sheets in the "Create/define parameter sheet" menu, data is automatically registered to the "Parameter sheet definition list", "Collumn group management" and "Menu item creation information" items.
• In order to display hidden menus, restore the target menus in "Role/Menu link list".

  For more information regarding restoring and deleting menus, see :doc:` "Exastro-ITA_User_Instruction_Manual_Management_Console" <../it_automation_base/management_console>`

  
  

注釈

While the "Create/Define parameter sheets" menu allows users to maintain parameter and data sheets, doing so from the menu limits the user to only maintaining 1 at a time. If the user wants to maintain multiple, they will have to do so using Excel.

1.5. Parameter sheets and Data sheets

• Types of sheets that can be created

  Users can create 2 different types of sheets by changing the "Creation target" field in the "Parameter sheet creation information" tab in the :menuselection:` "Parameter creation" menu group --> "Create/Define parameter sheets" menu,`.
  • Select "Parameter sheet" and execute to create a parameter sheet.

    This will create a (**Parameter sheet) **which can be have items configured in the different driver menu groups' "Substitute value automatic registration settings" menu.

  

  • Select "Data sheet" and execute to create a data sheet.

    This will create a (**Data sheet) **" which can not be used by "Substitute value automatic registration settings" menus.

  

  表 1.77 Parameter sheet and Data sheet differences

  Creation target selected value	Substitute value auto registration settings	Menu item	Host/Operation relationship
  Parameter sheet (With host/operation)	Configurable	Links with specifi ed "Host/Operation"Items related to "Host name" and "Operation" are automatically applied. Items other than that can be created freely.	Links with specified "Host/Operation".
  Parameter sheet (With operation)	Configurable	Items related to "Operation" are automatically applied. Items other than that can be created freely.	Links with specified "Operation".
  Data sheet	Not configurable	Users can create items freely	Does not link with either "Host" or "Operation".

  注釈

  Data sheets are intended to be used as reference sources for items that can be selected from pulldown menus

  and to be used as a CMDB (Configuration Management Database, Structure management database) for managing data on ITA.
  
  
• Parameter sheet patterns
  There are 5 different patterns in which Parameter sheets can be created.
  1. Parameter sheet using "Host group" and "Bundle"
  2. Parameter sheet using "Host group"
  3. Parameter sheet using "Bundle"
  4. Parameter sheet only
  5. Data sheet
  If Parameter sheet is selected, the same menu (Parameter sheet) will be created in the following 3 menu groups.
  • A. Input
  • B. Substitute value auto registration
  • C. Reference
  If Data sheet is selected, the same menu (Data sheet) will be created in the following menu.
  • A) Input
    The only menu that can be maintained (Register/Update/Delete/Restore) is the menus in the "A) Input" menu group.

    表 1.78 Parameter sheet patterns

    **Menu type**	**Menu group**	Maintainable
    Parameter sheet	Input	Yes
    	Susbtitute value auto registration	No
    	Reference	No
    Data sheet	Input	Yes

    • Using host groups

      We recommend using Host groups if the user is grouping the target host using the host group function.

      for more information regarding the host group function, see "Host group function".
  The following displays the different menus for "Input", "Substitute value auto registration" and "Reference"

  when a parameter sheet called "Parameter sheet 1" and a data sheet called "Data sheet 1" has been created.

  

  図 1.9 Created menus in Menu groups

Operating the "Define/Create Parameter sheets" menu

---

"Parameter sheet creation" menu group "Define/Create parameter sheets" menu

1.5.1. (A) Configure item/group

Create an item configured to the Parameter sheet

• "Item" button

  Pressing the Item button outputs and lets the user configure an item.

  

  図 1.10 Adding items

  This allows users to input items that can be added to the parameter sheet.

  

• "Group" button

  Configures column groups.

  The default value is "Group 1". Both "/ (Slash) " and "\ (Backslash) " are not usable.

  Items can be added to the group by dragging the items into the group area.

  Multiple items can be set to a single group.

  

  

  図 1.11 Column group in menu

• "Delete" button

  Returns the button to default state.

  

  図 1.12 Cancel button

• "Undo" button

  Returns the item before the "Delete button" was pressed.

  

  図 1.13 Undo button

• Define Item name

  The default value is "Item 1". Both "/ (Slash) " and "\ (Backslash) " are not usable.

  

  図 1.14 Item name definition

• Item name definition (For REST API)

  Input a Item name (For REST API). The default value is "item_1".

  Half-width characters and -_ (Hyphens and underscores) can be used.

  

  図 1.15 Item definition (For REST API)

• Input method selection

  Select an input method from the pulldown menu.

  

  図 1.16 Selecting input method

表 1.79 Input method shared setting items

Setting area	Description
Required	A checkbox that decides if the item should be an input required item or not
Unique restriction items	A checkbox that decides if the item should be an unique restricted item or not.
Description
Remarks	Free description field.

1.5.2. (B) "Parameter sheet creation information" tab

• Input information required in order to create a parameter sheet.
  • "Basic information" field

    

    表 1.80 "Basic information" setting value

    Setting area	Description	**Creation target **
    		Parameter sheet	**Data sheet**
    Item number	Displays "Auto-input" when creating parameter sheets. The item number is displayed when editing an existing menu (Parameter sheet/Data sheet).	Display	Display
    Parameter sheet name	Input the name of the Parameter sheet. The name "Main menu" is not usable.	Display	Display
    Creation target	Select one of the following from the pulldown selection: "Parameter sheet (with host/operation), "Parameter sheet (with operation)" or "Data sheet". If "Data sheet" is selected, the the "Input" row will be displayed in the "Target menu group" area. If either "Parameter sheet (with host/op eration) or "Parameter sheet (with operation) is selected, the "Host group" and "Bundle" checkbox will be dispalyed in the "Basic information" area, and the "Input ", "Substitute value auto registration" and "Reference" menu groups will be displayed in the "Target menu group" area.	Display	Display
    Display order	Input the display order of the column.They are displayed in ascending order.	Display	Display
    Host group	Is displayed if the creation target is set to "Parameter sheet (with host/operation). Will create parameter sheets per host gr oup if the "use" checkbox is ticked. Will create parameter sheets per host ifthe "Use" checkbox is not ticked.	Display	Hiddden
    Bundle	Is displayed if the creation target is "Parameter sheet" Will create a parameter sheet that supp orts bundles if the "Use" checkbox is ticked.	Display	Hidden
    Last updated date/time	Set to "Auto-input" by default. Is displayed in both "View" and "Edit"mode. If the last updated user "Parameter sheet creation function" (The user used when the record is updated by Backyard), the record displayed will be the one before that.	Display	Display
    Last updated by:	Set to "Auto-input" by default. Is displayed in both "View" and "Edit"mode. If the last updated user "Parameter sheet creation function" (The user used when the record is updated by Backyard), the record displayed will be the one before that.	Display	Display

    This section contains usable patterns of Creation target selections and the different driver's substitute value auto registration.

    表 1.81 Creation targets and Substitute value auto registration targets

    	Parameter sheet (With host/operation)	Parameter sheet (With operation)	Data sheet
    Ansible Driver	○	△	▲
    Terraform Driver	×	○	▲

    注釈

    • ○ ：Selectable in the Substitute value auto registration menu.
    • × ：Not selectable in the Substitute value auto registration menu.
    • △ ：Not selectable in the Substitute value auto registration menu, but can use values from parameter sheets using Parameter sheet reference.

      　　 "Creation target is Parameter sheet (with host/operation) with "Parameter sheet reference" item.
    • ▲ ：Not selectable in the Substitute value auto registration menu, but can use values from parameter sheets using Parameter sheet reference.

      　　 "Creation target is Parameter sheet (with host/operation"/Parameter sheet (with operation) with "Pulldown" item.

    ※ For more information regarding Creation targets see "Basic information" setting value.

    ※ For more information regarding "Parameter sheet reference" and "Pulldown" items, see, Input method shared setting items.
    
    
  • "Target menu group" field

    Displays the menu group used when creating the parameter sheets.

    Pressing the "Select target menu group" displays the "Target menu group" selection window where the user can select which menu group they want to use.

    

    注釈

    The picture above depicts when the "Creation target" is set to "Parameter sheet".
    • "Target menu group" selection page
      • Allows the user to select the target menu groups where the parameter sheet will be created to.
      • By default, the "Input,", "Substitute value auto registration" and "Reference" menu groups will be selected.
      • Select the desired menus and click the "OK" button.
      • Pressing the "OK" button whith the default values set creates a menu for for the "Input", "Substitute value auto registration" and "Reference" menu groups automatically. ( If the "Creation target" is set to "Data sheet", the menu will only be created to the "Input" menu group.)
      • (For more information, see "Exastro-ITA_Instruction_User_Manual_Management_Console".)
      • Press the "delete" button in the "Define/Create parameter sheets" menu.
  • "Unique restriction(Multiple items)" field

    This function makes it so its not possible to register multiple of the same combinations of records and items when registering data to created menus.

    

    Clicking the "Select Unique restriction(Multiple items)" button displays the "Unique restriction(Multiple items)" where users can configure combinations of unique items.
    • "Unique restriction(Multiple items)" settings page
      • Pressing the "Add pattern" adds another pattern. It is possible to configure multiple patterns.
      • The patterns displays all current items. Clicking one of the items allows the user to configure the unique restriction combination.
      • Press the "Delete" button in order to delete undesired patterns.
      • Pressing the "Delete" button allows the user to close the settings menu without displaying the settings.
      • Pressing the "OK" button displays the configured combinations.

      

      • The following patterns wil lead to validation errors.

        ① When there is only 1 item selected in a pattern.

        ② If there are multiple patterns with the same item combinations.

      

      図 1.17 When there is only 1 item selected in a pattern

      

      図 1.18 If there are multiple patterns with the same item combinations

  • "Access permission role" field
    • If a role is selected

      The seleted role(s) can access the Parameter sheet menus (menus under the "Parameter sheet creation" menu group).

      The roles selected in the "Role/Menu link management" menu can access the created menus (Parameter sheets/Data sheets).
    • If no role is selected.

      All roles can access the Parameter sheet menus (menus udner the "Parameter sheet creation" menu group).

      Created menus (Parameter sheets/Data sheets) can only be accessed by users that has the System admin role and/or the same role as the user that created the menu.

      

1.5.3. (C) "Preview"

• "Preview" tab

  Displays items in a table format.

  

• "Log" tab

  The "Log" tab displays the creation results after the "Create" button is pressed.

1.5.4. (D) "Create"

• "Create" button

  Creates the parameter sheet if all the input required items are filled in.

  

  After the parameter sheet has been created, the user can press the "Parameter sheet creation information" button to move to the "Parameter sheet creation history" menu where they can check if the parameter sheet was created successfully or not.

  

  図 1.19 Parameter sheet creation history

  "Define/Create parameter sheets"

  Data is automatically input to the "Parameter sheet definition list", "Collumn managment", "Parameter sheet item creation information", "Unique restriction (Multiple items) creation information" and "Parameter sheet role creation information" menus.

"Define/Create parameter sheets" menu after creating a parameter sheet

---

"Define/Create parameter sheets"

• View page

  

  図 1.20 View page

  After the user creates a menu, they will be moved to a page resembling the picture above.

  It is not possible to edit or create parameter sheets in the view page.

  If order to edit or create parameter sheets again, press one of the following button on the screen: "Edit", "Initialize" or the "Reuse" button.

  If "Create(New)" button is displayed instead of the "Edit" and "Initialize" buttons, that means that the backyard proccess hasnt finished creating the parameter sheet yet.

  Updating the browser after the parameter sheet has been created should display the "Edit" and "Initialize" button again.

  The status of the parameter sheet can be displayed by clicking the "Parameter sheet creation history" button.

  

  図 1.21 Button layout when the Backyard process isnt finished

  
  

  

  図 1.22 Button layout when the Backyard process is finished

  • "Create(New)" button (Before the Backyard is finished)

    Clicking the "Create(New)" button moves the user from the view page to the edit page. In the edit page, the user can add and delete items while keeping the data registered in the "Input" menu group. Edit the parameter sheet and press the "Create(Edit)" to save the changes.
  • "Create(New)" button(After the Backyard is finished)

    Clicking the "Create(New)" button moves the user from the view page to the edit page. In the edit page, the user can add and delete items while keeping the data registered in the "Input" menu group.

    (It is not possible to edit values configured to existing items and Basic information)

    Edit the parameter sheet and press the "Create(Edit)" to save the changes.
  • "Initialize" button

    Clicking the "Initialize" button moves the user from the view pqage to the initialize page. This page allows users to edit values and press the "Create(Initialize) button to recreate the parameter sheet. When recreated, the data registered in the "Input" menu group will be deleted.
  • "Reuse" button

    Clicking the "Reuse" button moves the user to a new creation page where the displayed parameter sheet is used as a template. Make sure to input a new name and display order before creating it.

    The parameter sheet name must differ from existing parameter sheets.
  • "Parameter sheet creation information" button

    Moves the user to the "Parameter sheet creation history" for the displaying parameter sheet.

    
    

    
    
• Edit page

  

  図 1.23 Edit page

  In the Edit page, the user can edit the parameter sheet while keeping the data registered in the "Input" menu group.

  This menu allows users to change the following item values: "Item name", "Regular expression", "Description" and "Remarks".

  The following items can only have their values edited to a larger number than the previously set value: "Maximum byte size", "Minimum value", "Maximum value", "Line number" and "Maximum file byte number".

  If the "Regular expression" item was edited, already registered data will be saved, even if it causes inconsistency error with the new "Regular expression".

  If a created item is deleted, data input into that data will also be deleted.

  If a new item is added, it will be added with no record registered to it (blank).

  This is also the case for records with "Required" and "Unique constraint" checked, meaning that there might be inconsistency errors.

  If the target menu groups are changed, the menu will be deleted from non-selected menu groups and will have a new one created to the newly selected menu groups (Data will be saved).

  It is not possible to change the setting value for the following items: "Basic information"'s "Parameter sheet name", "Creation target", "Using host group" and "Using bundle".

  If the item data is updated in the "Parameter data sheet item creation information" menu and the "Create(Edit)" button is clicked, inconsistency errors might occur.
  • "Create (Edit)" button

    Starts editing the displayed parameter sheet with it's data saved.

    注釈

    Note that it is not possible to exchange item names between items when editing parameter sheets. Changing the item name might cause errors when saving changes.
  • "Reload" button

    Removes all edited information.
  • "Cancel" button

    Returns it to the state before the "Edit" button was clicked.

  

  図 1.24 Edit page buttons

• Initialize page

  

  図 1.25 Initialize page

  In the initialize page, users can edit the parameter sheet displayed.

  If the target menu group is edited, the menu will be deleted from non-selected menu groups and will have a new one created to the newly selected menu groups.

  It is not possible to edit the "Basic information"'s' "Parameter sheet name".
  There are no other edit restrictions for the "Parameter name", but doing so will delete all data registered from the menu in the "Input" menu group.
  • "Create(Initialize)" button

    Recreates the displayed parameter sheet.

  注釈

  Note that it is not possible to exchange item names between items when editing parameter sheets. Changing the item name might cause errors when saving changes.
  • "Reload" button

    Removes all edited contents.
  • "Cancel" button

    Returns the parameter shet to before the "Edit" button was clicked.

    

    図 1.26 Initialize page buttons

Check parameter sheet in the "Parameter sheet defintiion list" menu

---

The following actions can be performed in the "Parameter sheet definition list" menu.

• Display list of created parameter sheets
• Maintain (View/Update/Delete/Restore) created parameter sheets

It is possible to maintain (View/Update/Delete/Restore) parameter sheets.

Pressing the "Parameter sheet definition list" from the menu list on the left displays the following page.

Press the Filter button in order to display the created parameter sheets.

図 1.27 Filter button

Press the Define/Create parameter sheets to "Define/Create parameter sheets"

図 1.28 Parameter sheet edit page

Pressing the Register button moves the user to a page where they can define a new parameter sheet.

図 1.29 Menu edit page

It is possible to use set values to use as filter options in order to narrow down definitions.

注釈

XXXIf the user is not using the default menu groups, make sure to create a menu group that can be used in the "Management console" menu group. (For more information, see :doc:` "Exastro-ITA manual Management Console" <../it_automation_base/management_console>`.)

Tip

Deleting records in the Parameter sheet defintiion list

The Parameter sheet defintiion list menu has the setting information used to create the parameter sheets.

Even if records are deleted from menus in the Parameter sheet defintiion list menu, menus in the Managedment console ▶ Menu list (created menus) will not be changed.

In order to delete created parameter sheets, see Deleting/Restoring created parameter sheets .

Check creation status in the "Parameter sheet creation information" menu

---

This menu allows users to check the creation status of parameter sheets.

The "Not executed" status is monitored by Backyard, and it uses not executed data menus setting files, executes SQL to create tables and deploys and registers the menu page program.

After a couple of seconds after the status has changed to "Completed", the menu will be added to the menu group.

表 1.82 "Parameter sheet creation information" menu items

Item name	Description
Parameter sheet name	Name of the target parameter sheet.
Status	Displays what status of the Parameter sheet creation process. Not executed：Status before the parameter sheet creation process starts. Executing：Status where the Backyard is running the parameter sheet creation proccess. Complete：Status when the parameter sheet creation process has ended successfully Complete (error) ：Status when the parameter sheet ends in an error.
Creation type	The following are the available creation types. Create new: Newly created parameter sheets. Initialize: For Initialized parameter sheets Edit: Edited parameter sheets.
Remarks	Free description field.

1.5.5. Check created parameter sheets

The following section describes the different patterns of parameter sheets that can be created depending on the values selected in the "Create Parameter sheet" menu group> "Define/Create parameter sheets"> "Parameter creation inforamtion" tab> "Basic information" area.

1. Data sheet

   A. Input menu group
2. Parameter sheet

   A. Input menu group

   B. Susbtitute value auto registration menu group

   C. Reference menu group
3. Parameter sheet & using bundle

   A. Input menu group

   B. Susbtitute value auto registration menu group

   C. Reference menu group
4. Parameter sheet & using host group

   A. Input menu group

   B. Susbtitute value auto registration menu group

   C. Reference menu group

1.5.5.1. 1. Selecting "Datasheet" in the "Creation target" tab

Selecting "Data sheet" for the "Selection target" in the "Define/Create parameter sheets" (or Parameter sheet definition list menu) will create a data sheet when the "Create" button is clicked.

図 1.30 Creating data sheet

Check that the data sheet has been added in the menu group specified in the "Input (Menu group)" field.

1.5.5.1.1. A) Input menu group

Creates a data sheet that can be maintained (View/Update/Delete/Restore).

図 1.31 Data sheet created under the Input menu group

The items are as following

表 1.83 Item list ( "Data sheet" input menu)

Item			Description	Input required	Input method	Restrictions
Parameter	[Created item name]		The item created in the "Define/Create parameter sheet" menu will be displayed.	Depends on the settings of the crea ted item.	Depends on the setings of the created item.	Depends on the settings of the created item.
Remarks			Free description field.	ー	Manual	Maximum length 4000 bytes

注釈

Data sheet are not linked to specified hosts or operations, meaning that Operation items will not be displayed.

注釈

Data sheet menus will not be created under the "Substitute value auto registration" or "reference" menu groups.

1.5.5.2. 2. Selecting "Parameter sheet (With host/operation)" in the "Creation target" tab

Selecting "Parameter sheet (With host/operation) as the "Creation target" in the "Define/Create parameter sheets" or "Parameter sheet definition list" menu creates a Parameter sheet.

図 1.32 Creating parameter sheet

Check that the created parameter sheet has been added to the following menu groups: "Input", "Substitute auto value registration" and "Reference".

1.5.5.2.1. A) Input menu group

Creates a data sheet that can be maintained (View/Update/Delete/Restore).

図 1.33 Parameter sheet created under the Input menu group

The item list is as following.

1.5.5.2.2. B) Susbtitute value auto registration menu group

This menu is for view purposes only. Contents registered in the "Input" menu group is displayed in the "List" submenu.

図 1.34 Parameter sheet in the Substitute value auto registration menu group

1.5.5.2.3. C) Reference menu group

This menu is for view purposes only. The settings enabled at the time of the specified date and time in the "Operation: Reference date and time" column of the "Display Filter" sub menu will be displayed in the "List" sub menu.

図 1.35 Parameter sheet in the Reference menu group

注釈

If the filter button is clicked when the "Operation: Reference date" field in the "Display filter" submenu is blank, only the latest data in the "Reference Date" field for each operation will be displayed in the "list" submenu.

※ If the Operation's "Last executed date/time" contains a value, the "Standard date/time" will take the same value. If the "Last executed data/time" contains no value, it will take from "Scheduled execution date".

1.5.5.3. 3. Selecting "Parameter sheet (With operation)" in the "Creation target" tab

Selecting "Parameter sheet (With operation) as the "Creation target" in the "Define/Create parameter sheets" or "Parameter sheet definition list" menu creates a Parameter sheet.

図 1.36 Creating parameter sheet

Check that the created parameter sheet has been added to the following menu groups: "Input", "Substitute auto value registration" and "Reference".

1.5.5.3.1. A) Input menu group

Creates a data sheet that can be maintained (View/Update/Delete/Restore).

図 1.37 Parameter sheet created under the Input menu group

The item list is as following.

1.5.5.3.2. B) Substitute value auto registration menu group

This menu is for view purposes only. Contents registered in the "Input" menu group is displayed in the "List" submenu.

図 1.38 Parameter sheet created under the Substitute auto registration value menu group

1.5.5.3.3. C) Referemce menu group

This menu is for view purposes only. The settings enabled at the time of the specified date and time in the "Operation: Reference date and time" column of the "Display Filter" sub menu will be displayed in the "List" sub menu.

図 1.39 Parameter sheet created under the Reference menu group

注釈

If the filter button is clicked when the "Operation: Reference date" field in the "Display filter" submenu is blank, only the latest data in the "Reference Date" field for each operation will be displayed in the "list" submenu.

※ If the Operation's "Last executed date/time" contains a value, the "Standard date/time" will take the same value. If the "Last executed data/time" contains no value, it will take from "Scheduled execution date".

1.5.5.4. 4. Selecting "Parameter sheet" in the "Creation target" field and ticking the "Use bundle" checkbox

Creating a parameter sheet(either "with host/operation" or "with operation") with the "Use bundle" checkbox ticked will create a parameter sheet in a bundled format.

1.5.5.4.1. A) Input menu group

Creates a data sheet that can be maintained (View/Update/Delete/Restore).

In parameter sheets (with host/operation), it is possible to register multiple parameters for records with registered "host name" and "operation" combinations by using the "Substitute order" column.

In parameter sheets (with operation), it is possible to register multiple parameters for records with registered "operation" combinations by using the "Substitute order" column.

図 1.40 Parameter sheet created under the Input menu group

The item list is as following.

Example) If users attempts to register the information above without using bundles①

The user will not be able to register multiple parameters to registered "host name" and "operation" combinations.

図 1.41 Parameter sheet created under the Input menu group

注釈

Trying to set 22.22.22.22 and "test2.com" while "11.11.11.11 and "test1.com" is already set for the combination of "host1" "ope_sample1" will cause an error.

Example) If users attempts to register the information above without using bundles

Whle the user can set multiple parameters for a registered combination of "host name " and "Operation" by increasing the number of items the parameter sheet will oriented horizontally and the visibility will be poor.

注釈

"Parameter sheet creation" menu group> "Define/Create parameter sheets"

図 1.42 Parameter sheet created under the Input menu group

注釈

The example below creates items up until "IP_Address_3" and "Domain_3". Items later than that does not exist.

As those items does not exist, the user will not be able to register the contents("44.44.44.44" and "test4.com") for "IP_Address_4" and "Domain_4" for the same combination of host name and operation.

In order to create a parameter sheet with repeating items, use bundles (Data sheets cannot use bundles).

1.5.5.4.2. B) Substitute value auto registration menu group

This menu is for view purposes only. Contents registered in the "Input" menu group is displayed in the "List" submenu.

図 1.43 Parameter sheet created under the Substitute auto registration value menu group

1.5.5.4.3. C) Reference menu group

This menu is for view purposes only. The settings enabled at the time of the specified date and time in the "Operation: Reference date and time" column of the "Display Filter" sub menu will be displayed in the "List" sub menu.

図 1.44 Parameter sheet created under the Reference menu group

注釈

For "Parameter sheet (with host/operation)", if the "Filter" button is pressed while in the "Display filter" submenu when the "Operation:Standard date/time" item is empty, The "Standard date/time" will only display the newest data per host name in the "list" submenu.

For "Parameter sheet (with operation)", if the "Filter" button is pressed while in the "Display filter" submenu when the "Operation:Standard date/time" item is empty, The "Standard date/time" will only display the newest in the "list" submenu.

※ If the Operation's "Last executed date/time" contains a value, the "Standard date/time" will take the same value. If the "Last executed data/time" contains no value, it will take from "Scheduled execution date".

1.5.5.5. 5. Selecting "Parameter sheet" in the "Creation target" field and ticking the "Use host group" checkbox

When creating Parameter sheets, select "Parameter sheet (with host/operation) for the the "Creation target" in the "Define/Create parameter sheets" ( or "Parameter sheet definition list") menu and tick the "Use" checkbox for "Use host group" to create a Parameter sheet for host groups.

図 1.45 Creating parameter sheet (using host group)

Check that the created parameter sheet has been added to the following menu groups: "Input", "Substitute value auto registration" and "Reference".

1.5.5.5.1. A) Input menu group

Creates a data sheet that can be maintained (View/Update/Delete/Restore) per host group and host name.

図 1.46 Parameter sheet created under the Input menu group (Using host group)

図 1.47 Pulldown values for host items when using host groups

The item list is as following.

注釈

If the parameter sheet is a "Parameter sheet( with host/operation)" and has "Use Host group" activated, the user will be able to select Host groups.

The Host group names will start with [HG], and Host names will start with [H].

1.5.5.5.2. B) Susbtitute value auto registration menu group

This menu is for view purposes only. Contents registered in the "Input" menu group is displayed in the "List" submenu.

図 1.48 Parameter sheet created under the Substitute auto registration value menu group

注釈

If the parameter sheet is a "Parameter sheet( with host/operation)" and has "Use Host group" activated, the user can check data divided per host from host groups with "Host group function".

1.5.5.5.3. C) Reference menu group

This menu is for view purposes only. The settings enabled at the time of the specified date and time in the "Operation: Reference date and time" column of the "Display Filter" sub menu will be displayed in the "List" sub menu.

図 1.49 Parameter sheet created under the Reference menu group

注釈

For "Parameter sheet (with host/operation)", if the "Filter" button is pressed while in the "Display filter" submenu when the "Operation:Standard date/time" item is empty, The "Standard date/time" will only display the newest data per host name in the "list" submenu. | If the parameter sheet is a "Parameter sheet( with host/operation)" and has "Use Host group" activated, the user can check data divided per host from host groups "Host group function". | | ※ If the Operation's "Last executed date/time" contains a value, the "Standard date/time" will take the same value. If the "Last executed data/time" contains no value, it will take from "Scheduled execution date".

"Create Parameter sheet" hidden menus

---

Registering column group in the "Column group management" menu

---

The "Column group management" menu is hidden by default. This menu allows users to maintain parameter sheets' column group.

A column group is a group that contains the header section of items in parameter sheets.

The Parameter sheet creation function allows users to create the column group of the items they are creating in the parameter sheet.

The are marked with red is an example of a column group.

図 1.50 Parameter sheet created under the Input menu group

The system checks for the following when items are updated/deleted.

1. The data itself cannot be selected in the parent column group.
2. It is not possible to delete items when specifying parent groups for other data.
3. It is not possible to configure a parent-child relationship that loops.

   (E.g. if a relation ship goes like this: A⇒B⇒C, C cannot be the parent of A)

Registering items configured to the "Parameter sheet item creation information" menu

---

The "Parameter sheet item creation information" is hidden by default.

This menu allows users to maintain items managed in Parameter sheets and data sheets.XXX

---

The "Unique restrictions (multiple items)" menu is hidden by default.

This menu allows users to maintain the parameter sheets' unique restrictions (multiple items)'s creation information.

---

The "Parameter sheet role creation information" menu is hidden by default.

This menu allows users to maintain parameter sheets' parameter sheet role creation information.

表 1.84 "Parameter sheet role creation information" menu setting values

**Setting item**	Description
Parameter sheet name	Select parameter sheet that will configure the parameter sheet role creation information from the pulldown selection
Role	Select the role that will be linked to the selectedparameter sheet.

1.6. Appendix

1.6.1. Parameter sheet definition - table link management

This menu displayes the link between created parameter sheets and DB tables.

This menu is hidden by default.

This menu is used by Backyard and cannot be operated by users.

Changing the link right after the parameter sheet is created will not change this menu.

図 1.51 Parameter sheet definition - table link management

表 1.85 Setting item list

Item name	Description
Parameter sheet name	Name of the parameter sheet linked to DB
Parameter sheet name (rest)	Rest name of the parameter sheet linked to DB
Table name	Name of the created table
Main key	Main key of the created table
Table name (history)	History table name of the created table
Remarks	Free description field.

1.6.2. Link with other menus

This menu is configured by default and displays links between DP tables, Items, and Menu groups from created parameter sheets.

This menu is hidden by default.

This menu is used by Backyard and cannot be operated by users.

Even if a Parameter sheet is linked after being created, the data in this menu will not be edited.

図 1.52 Link with other menus

表 1.86 Setting item list

Item name	Description
Menu group name	Name of the menu group linked to DB.
Menu name	Name of the created parameter/data sheet.
Menu name(rest)	rest name of the created menu.
Item name(ja)	Japanese name of the created item.
Item name(en)	English name of the created item.
Menu group name: Menu name :Item name(ja)	Created Menu group name: Menu name: Item name in Japanese.
Menu group name: Menu name :Item name(en)	Created Menu group name: Menu name: Item name in Japanese.
ID link table	Name of the link table.
ID link table PK	Link destination link table.
ID link item name	Name of the link item.
ID link item name (rest):Item name(ja)	rest name of the link item.
ID link sort condition	The sort conditions of the ID link.
ID link Multilingual support	Set to "True" for multilingual support.
Column class	Link destination target Coloumn class.
Parameter sheet Creation target flag	Set to "True" for parameter sheet creation targets.
Remarks	Free description field.

1.6.3. Selection 1

Menu that manages items used in pulldown selections.(1st selections)

This menu is hidden by default.

This menu cannot be operated by users.

図 1.53 Selection 1

表 1.87 Item list

Item name	Description
*-(Blank)	Item for using "*" in pulldown selections.

1.6.4. Selection 2

Menu that manages items used in pulldown selections.(2nd selections)

This menu is hidden by default.

This menu cannot be operated by users.

図 1.54 Selection 2

表 1.88 Item list

Item name	Description
Yes-No	Item for using "Yes" or "No" in pulldown selections.
True-False	Item for using "True" or "False" in pulldown selections.

Usable "Selection items" in "Pulldown selections"

---

The "Pulldown selection" can use the following "Selection items"

表 1.89 Item list

Menu group	Menu	Item	Remarks
Management console	Menu management	Menu group name Menu name
Basic console	Operation list	Operation name
	Movement list	Movement name
Ansible common	Device list	Host name
	File management	File embedded variable name
	Template management	Template embedded variable name
Conductor	Conductor list	Conductor name
Create parameter sheet	Selection 1	*-(blank)
Create parameter sheet	Selection 2	True-False
Create parameter sheet	Selection 2	Yes-No

|Additionaly, the following items from created menus (Parameter sheets/Data sheets) can also be used if they have both "Required" and "Unique restriction" set to them: "String (single line)", "String (multiple lines)", "Integer", "Decimal", "Date/time" "Date" and "Link".

"Reference items" when using "Pulldown selections

---

When using "Pulldown selection" items, users can display different items based on the selected value.

If the user has selected "Pulldown selection", users can press the "Select reference item" button to select what menu they want to reference items from.

Tick the checkbox for the target items and press "OK" to input the values into the "Reference item".

Items that can be used as "Reference" items are as follows.

表 1.90 Item list

Selection item	Menu	Item name	Item name (rest)	remarks
Management console: menu management: Menu name	Menu management	Menu name (rest)	menu_name_rest
Ansible common: device list: host name	Device list	DNS host name	host_dns_name
		IP address	ip_address
		User	login_user
		Password	login_password

When the "Selection item" is a menu created using the "Create Parameter" function, the other column classes (string(single line), string(multiple lines), Integer, Float, Date/time, Date, Password, File upload, Link) are also target for the selection item.

Creating a Parameter sheet with a "Reference item" selected, the "Register" will only display the Pulldown item field in the "Input" menu group, but pressing the "List/Update" button displays records on the same line as the value configured to the "Pulldown selection".

Displaying a menu created in the "Substitute value auto registration" or "Reference" menu group with the "List" button will also display the "Reference" item values.

"Reference" items displayed in menu groups created in the "Substitute value auto registration" menu group can be used the same as standard values in the different driver's "Substitute value automatic registration settings" menu.

1.6.5. Reference item information

"Define/Create parameter sheets"

This menu is hidden by default.

This menu is used by Backyard and cannot be operated by users.

表 1.91 Item list

Item name	Description
Link ID with other menus	ID of the reference source menu
Menu group name	Name of the reference source target menu group
Menu name	Name of the reference source target menu.
Display order	Display order when selecting reference items. Displayed in ascending order.
Column class	Reference source table's column class.
Item name(ja)	Reference source item name (Japanese).
Item name(en)	Reference source item name (English).
Item name(rest)	Reference source item name (REST).
Column group	Reference source column group.
ID link table	Reference source table name.
ID link table PK	Reference source table PK.
ID link item name	Reference source table's item name.
ID link item name	Reference source table's item name(REST).
ID link sort conditions(REST)	Sord condition for the ID link.
ID link multilanguage support	Set to "True" if the reference source is multilingual supported.
Sensitive settings	Set to "True" if the reference source target item is "Password".
Parameter sheet creation target flag	Set to "True" if the item is "Parameter creation target".
Description(ja)	Description for the target reference source.
Description(en)	Description for the target reference source.
Remarks	Free description field.

1.6.6. Deleting/Restoring created parameter sheets

This section describes how to delete(delete logic) and restore created parameter sheets.

1. Access the Management console ▶ Menu management page.

2. Press the Filter button and use the following items to search for the target parameter sheet.

   • Menu name(ja)

   • Menu name(en)

   • Menu name(rest)

3. Press the Edit button to restore/delete the target parameter sheet.

Menus that can be deleted/restored are the ones that belongs to the menu groups that was specified when creating the parameter sheet.

Create parameter sheet ▶ Define/Create parameter sheets Target menu group

DeleteRestore

Select the Parameter sheet in the Management console ▶ Menu management menu and delete it.

警告

Deleted parameter sheets can no longer be used.

If the parmeter sheets' pulldown item or reference items are used, an ID conversion failure (X) will occur.

If the parameter shete is used in the different drivers' Susbtitute value auto registration menu, an ID conversion failure (X) will occur.

Similarly, the same will happen for items that references deleted parameter sheets' menu name and item names.