{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","TMS_LoadVariableMapping","TMS_LoadAssignmentConfig","TMS_LoadTaskGroupTemplate","TMS_LoadTaskTemplate","TMS_LoadVariableTemplate","TMS_LoadFlowTemplate","TMS_LoadAssociationTemplate"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["Instructions for completing this workbook:"]
[]
[null,"This workbook consists of multiple tabs. Each tab corresponds to an ITSM form.\nEach column in the spreadsheet corresponds to a column on the form."]
[]
[null,"Column headings provide instructions for completing that column of the spreadsheets \naccording to the following standards:"]
[null,"* A green column heading indicates a required field."]
[null,"* An orange column heading indicates a field that might be required, \ndepending on a value set in another column."]
[null,"Additional instructions for entering data in the column appear in the first row."]
[null,"The number above each column heading is the database length of the field. Validation on each column indicates whether\n you entered data longer than this maximum allowed length."]
[]
[]
[]
[]
[]
[]
[]
["Version for ITSM Release 9.1.03"]
["Copyright © 2007-2017, BMC Software, Inc. All rights reserved."]

{"sheet":"TMS_LoadVariableMapping","index":1,"n_rows":3,"n_cols":6,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["This required field contains the AR Field ID of the Task or Task Group or Flow Forms based on Object Template Type selected. This is the Field ID used to read or write values by the Variable Mapping.","This required field contains the AR Field Name of the Task or Task Group or Flow Forms based on Object Template Type selected. This is the Field ID used to read or write values by the Variable Mapping.","This required field must be completed with one of the following numbers or words, according to the significance indicated in the following list:\n0 or Task Group\n1 or Task \n2 or Flow","This required field must be completed with one of the following numbers or words, according to the significance indicated in the following list:\n0 or Input\n1 or Output","This required field contains the Task Template Identifier or Task Group Template Identifier or Flow Template Identifier based on Object Template Type selected, from the Staging form or the Task Template Instance ID or Task Group Template Instance ID or Flow Template  Instance ID from the Target form (for a template that is already loaded into the system). This is the Task or Task Group or Flow Template  for which the Mapping is being made.","This required field contains the Variable Template Identifier from the Staging form or the Variable Template Instance ID from the Target form (for a template that is already loaded into the system). This is the Variable Template  for which the Mapping is being made."]
["15","254","-","-","15","15"]
["Mapping Field ID*","Mapping Field Name*","Object Template Type*","Variable Direction*","Object Template Identifier*","Variable Template Identifier*"]

{"sheet":"TMS_LoadAssignmentConfig","index":2,"n_rows":3,"n_cols":11,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Entries in this required field must match an existing company in the COM:Company form or you can enter “- Global -\" if all companies will be assigned to this configuration.\nThe conbination of Company, Operational Category Tier 1, 2, 3 and Product Category 1, 2, 3 must be unique.","This field must be completed with one of the following numbers or words, according to the significance indicated in the following list:\n0 or Potential\n1 or Active\n2 or Inactive\nFor a record to be fully function in ITSM, its status must be set to Active.","This field contains the Assignment Processes that is already defined in the System (CFG:AssignmentProcessMapping form where Request Form is Task and is set to Enabled).","Entries in this column must match an existing Tier 1 operational category in the CFG:Service Catalog form.","Entries in this column must match an existing Tier 2 operational category in the CFG:Service Catalog form.","Entries in this column must match  an existing Tier 3 operational category in the CFG:Service Catalog form.","Entries in this column must match an existing Tier 1 product category in the PCT:Product Catalog form.","Entries in this column must match an existing Tier 2 product category in the PCT:Product Catalog form.","Entries in this column must match an existing Tier 3 product category in the PCT:Product Catalog form.","Entries in this column must match an existing product name in the PCT:Product Catalog form.","Entries in this column must match an existing model or version in the PCT:Product Model/Version form."]
["254","-","254","60","60","60","60","60","60","254","254"]
["Company*","Status*","Process Name*","Operational Category Tier 1","Operational Category Tier 2","Operational Category Tier 3","Product Category Tier 1","Product Category Tier 2","Product Category Tier 3","Product Name+","Model/Version"]

{"sheet":"TMS_LoadTaskGroupTemplate","index":3,"n_rows":3,"n_cols":16,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["This required field is used only as a unique reference for data import function. The entry in this field contains the Task Group Template Identifier and it  must be unique.","This required field contains the Task Group Template's name.","This required field contains a brief summary of the Task Group Template.","Entry in this required field must be \"- Global -\" or must match a company already loaded in the COM:Company form, or the Company Spreadsheet, and have a type of Operating Company or Customer.","This field contains the Category with which to categorize this template. Values in this field can include (but are not limited to) entries in TMS:IntegrationConfiguration where Status is set to \"Active\" and Use Task Template is set to \"Yes\" .","This field contains the Sub Category to further categorize this Task Group Template.","This field contains additional notes related to this Task Group Template.","This required field must be completed with one of the following numbers or words, according to the significance indicated in the following list:\n1000 or Standard\n3000 or Sequencing","This required field must be completed with one of the following numbers or words, according to the significance indicated in the following list:\n0 or Critical\n1 or High\n2 or Medium\n3 or Low","This field must be completed with one of the following numbers or words, according to the significance indicated in the following list:\n0 or Yes\n1 or No","This field contains the Locale for this Task Group Template.","This required field must be completed with one of the following numbers or words, according to the significance indicated in the following list:\n0 or Potential\n1 or Active\n2 or Inactive","This field contains the Time Out Value, expressed in Units specified in the next column. This field has data limit of 0 to 2147483647.","This field must be completed with one of the following numbers or words, according to the significance indicated in the following list:\n2000 or Assigned\n3000 or Pending\n4000 or Work In Progress\n5000 or Waiting\n6000 or Closed","This field contains the status reason for the Status entered in next column. For a list of the valid status reasons refer to the appendix of the Data Management Administrator's Documentation.","This field must be completed with one of the following numbers or words, according to the significance indicated in the following list:\n0 or Seconds\n1 or Minutes\n2 or Hrs\n3 or Days"]
["15","255","254","254","255","100","0","-","-","-","30","-","-","-","-","-"]
["Task Group Template Identifier*","Name*","Summary*","Company*","Category","SubCategory","Notes","Type*","Priority","Visible","Locale","Status*","Time Out Value","Time Out Status","Time Out Status Reason","Unit"]

{"sheet":"TMS_LoadTaskTemplate","index":4,"n_rows":4,"n_cols":45,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["This is a required field that is used only as a unique reference for the data import function. The entry in this field contains the Task Template Identifier and it must be unique.","This required field contains the Task Template name.","This required field contains a brief summary of the Task Template.","This field contains the Category with which to categorize this template. Values in this field can include (but are not limited to) entries in TMS:IntegrationConfiguration where Status is set \"Active\" and Use Task Template is set to \"Yes\" .","This field contains the Sub Category to further categorize this Task Template.","This field contains additional notes related to this Task Template.","This required field must be completed with one of the following numbers or words, according to the significance indicated in the following list:\n2000 or Manual\n3000 or Automatic","This field must be completed with one of the following numbers or words, according to the significance indicated in the following list:\n0 or Critical\n1 or High\n2 or Medium\n3 or Low","This field must be completed with one of the following numbers or words, according to the significance indicated in the following list:\n0 or Yes\n1 or No","This field contains the Locale for this Task Group Template.","This required field must be completed with one of the following numbers or words, according to the significance indicated in the following list:\n0 or Potential\n1 or Active\n2 or Inactive","Entry in this required field must be \"- Global -\" or must match a company already loaded in the COM:Company form and which has a type of Operating Company or Customer.","This field contains a region for the task Location. The entry in this field must match a region already loaded in the CTM:Region form.","This field contains the site group for the task location. The entry in this field must match a site group already loaded in the SIT:Site Group form.","This field contains the Site for the task location. The entry in this field must match a site already loaded in the SIT:Site form.","Entries in this field should match a CAI Command (but not limited to) that is already loaded in the CAI:Commands form and which has a DataTag of either: CMS or blank.  (Not SRM commands)","Entries in this field should match a CAI Command (but not limited to) that is already loaded in the CAI:Commands form and which has a DataTag of either: CMS or blank.  (Not SRM commands)","This field contains the Time Out Value, expressed in the Units specified in the Time Out Status (next) column. This field has data limit of 0 to 2147483647.","This field must be completed with one of the following numbers or words, according to the significance indicated in the following list:\n2000 or Assigned\n3000 or Pending\n4000 or Work In Progress\n5000 or Waiting\n6000 or Closed","This field contains the status reason for the Status entered in previous column. For a list of the valid status reasons, refer to the appendix in the Data Management Administrator's Documentation.","Entries in this column must match an existing Tier 1 operational category associated with a Company specified in the Company column. Alternatively, you can specify \"- Global -\" in the \"CFG:Service Catalog LookUp\" form.","Entries in this column must match an existing Tier 2 operational category associated with a Company specified in the Company column. Alternatively, you can specify \"- Global -\" in the \"CFG:Service Catalog LookUp\" form.","Entries in this column must match an existing Tier 3 operational category associated with a Company specified in the Company column. Alternatively, you can specify \"- Global -\" in the \"CFG:Service Catalog LookUp\" form.","Entries in this column must match an existing Tier 1 product category associated with a Company specified in the Company column. Alternatively, you can specify \"- Global -\" in the \"PCT:ProductCompanyAssocLookup\" form.","Entries in this column must match an existing Tier 2 product category associated with a Company specified in the Company column. Alternatively, you can specify \"- Global -\" in the \"PCT:ProductCompanyAssocLookup\" form.","Entries in this column must match an existing Tier 3 product category associated with a Company specified in the Company column. Alternatively, you can specify \"- Global -\" in the \"PCT:ProductCompanyAssocLookup\" form.","Entries in this column must match an existing product name associated with a Company specified in the Company column. Alternatively,  you can specify \"- Global -\" in the \"PCT:ProductCompanyAssocLookup\" form.","Entries in this column must match an existing model or version in the \"PCT:Product Model/Version\" form.","This field contains the name of the assignee company. Entries in this field must match a company that is already loaded in the COM:Company form and which has a type of either Operating Company or Customer.","This field contains the Assignment Processes that is already defined in the System (CFG:AssignmentProcessMapping form where Request Form is Task and is set to Enabled).","This field contains the name of the assignee organization. Entries in this field must match a support group organization already loaded in the CTM:Support Group form. If this field contains a value, then the Assignee Company field must also contain an entry.","This field contains the name of the assignee support group. Entries in this field must match support group entries already loaded in the CTM:Support Group form. If this field contains a value, then the Assignee Company and Assignee Organization fields must also contain an entry. This field or Assignee is required if the Status is Assigned or Work in Progress.","This field contains the assignee person's full name. The assignee must already be loaded on the CTM:People form. If this field contains a value, then the Assignee Company field must also contain an entry. This field or Assignee Group is required if the Status is Assigned or Work in Progress.","This field must be completed with one of the following numbers or words, according to the significance indicated in the following list:\n0 or Yes\n1 or No","This filed contains the Automatic Command for this Task Template. Entries in this file are only permitted if the Task Type is set to 'Automatic'. (Entries in this field must match ones in SYS:Menu Items where Menu Type is 'TMSAutomaticTypes'.)","This field is used for Automatic Command purposes. It may have different uses depending on the Command entered for this Task Template. This field will contain the DB field name in the following format: $field name$. No validity checking is done on the contents of this field.","This field is used for Automatic Command purposes. It may have different uses depending on the Command entered for this Task Template. This field contains the DB field name in the following format: $field name$. No validity checking is done on the contents of this field.","This field is used for Automatic Command purposes. It may have different uses depending on the Command entered for this Task Template. This field contains the DB field name in the following format: $field name$. No validity checking is done on the contents of this field.","This field is used for Automatic Command purposes. It may have different uses depending on the Command entered for this Task Template. This field contains the Text for the Command. No validity checking is done on the contents of this field.","This field is used for Automatic Command purposes. It may have different uses depending on the Command entered for this Task Template. This field contains the Decimal value for the Command. No validity checking is done on the contents of this field.","This field is used for Automatic Command purposes. It may have different uses depending on the Command entered for this Task Template. This field contains the Interval value integer for the Command. This filed has a data limit of 0 to 2147483647. No validity checking is done on the contents of this field.","This field is used for Automatic Command purposes. It may have different uses depending on the Command entered for this Task Template. This field must be completed with one of the following numbers or words, according to the significance indicated in the following list:\n0 or Days\n1 or Hours\n2 or Minutes.\nNo validity checking is done on the contents of this field.","This field is used for Automatic Command purposes. It may have different uses depending on the Command entered for this Task Template. This field contains the Number of Retries for the Command entered. This field has data limit of 0 to 10. No validity checking is done on the contents of this field.","This field must be completed with one of the following numbers or words, according to the significance indicated in the following list:\n0 or Flat Rate\n1 or Hours\n2 or Minutes","This field contains the Estimated Total Time number for the Task Template that is being loaded. This field has data limit of 0 to 2147483647."]
["15","255","254","255","100","0","-","-","-","30","-","254","60","60","60","80","80","-","-","-","60","60","60","60","60","60","254","254","254","254","60","60","254","-","-","254","254","254","0","-","-","-","-","-","-"]
["Task Template Identifier*","Name*","Summary*","Category","SubCategory","Notes","Type*","Priority","Visible","Locale","Status*","Company*","Region","Site Group","Site","Launch Command","Details Command","Time Out Value","Time Out Status","Time Out Status Reason","Operational Category Tier 1","Operational Category Tier 2","Operational Category Tier 3","Product Category Tier 1","Product Category Tier 2","Product Category Tier 3","Product Name","Model/Version","Assignee Company","Process Name","Assignee Organization","Assignee Group","Assignee","Notify Assignee","Automatic Command","Field 1","Field 2","Field 3","Text","Decimal","Interval","Interval Unit","Number of Retries","Budget Calculation Unit Type","Estimated Total Time"]
["1003","TSCS Task Template","This is TSCS Change Task Template Summary",null,null,null,"2000","Medium","Yes",null,"Active","Calbro Services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calbro Services",null,"IT Support","Backoffice Support","Allen a Allbrook","Yes",null,null,null,null,null,null,null,null,null,"Flat Rate"]

{"sheet":"TMS_LoadVariableTemplate","index":5,"n_rows":3,"n_cols":9,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["This required field must be completed with one of the following numbers or words, according to the significance indicated in the following list:\n0 or Potential\n1 or Active\n2 or Inactive","This required field contains the Variable Template name.","This field contains the Category with which to categorize this template. Values in this field can include (but are not limited to) entries in TMS:IntegrationConfiguration where Status is set \"Active\" and Use Variable Template is set to \"Yes\".","This field contains the Sub Category to further categorize this Variable Template.","This field contains additional notes related to this Variable Template.","This is a required field that is used only as a unique reference for the data import function. The entry in this field contains the Variable Template Identifier and it must be unique.","This required field must be completed with one of the following numbers or words, according to the significance indicated in the following list:\n0 or Local\n1 or Global","",""]
["-","254","255","100","0","15","-","0","30"]
["Status*","Name*","Category","SubCategory","Notes","Variable Template Identifier*","Type*","Default Value","Locale"]

{"sheet":"TMS_LoadFlowTemplate","index":6,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["This is a required field that is used only as a unique reference for the data import function. The entry in this field contains the Flow Template Identifier and it must be unique.","This is a required field that is used to create a Flow link between this ID and the Successor Association ID. The entry in this field contains one of the following: the Association Identifier from the staging form, the Instance ID from TMS:AssociationTemplate form, or it can be set to 'Start' to indicate the entry is the starting point of the Flow.","This is a required field that is used to create a Flow link between this ID and the Predecessor Association ID. The entry in this field contains the Association Identifier from the staging form or the Instance ID from TMS:AssociationTemplate form."]
["15","254","254"]
["Flow Template Identifier*","Predecessor Association Identifier*","Successor Association Identifier*"]

{"sheet":"TMS_LoadAssociationTemplate","index":7,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["This required field is used only as a unique reference for the data import function. The entry in this field contains the Association Identifier and it must be unique.","This required field contains the  Change Template Identifier from the Staging form or the Change Template ID from the Target form (for a template that is already loaded into the system). This is the  Change Template for which the Association is being made.","This required field is used to look up the Task Template or the Task Group Template that is being associated with the Task Group Template or Change Template.  The entry in this field contains the Task Group Template, Task Template Identifier, or the Instance ID for a template that is already loaded into the system.","This required field must be completed with one of the following numbers or words, according to the significance indicated in the following list:\n0 or Task Group Template\n1 or Task Template","Enter Sequence value starting from 1. If nothing is specified, then it will set Sequence in default order."]
["15","254","254","-","-"]
["Association Identifier*","Parent - Template Identifier*","Child - Template Identifier*","Child Type*","Sequence"]