DataImporter - Import attributes for CI types

SHOW ALL CONTENT

Table of contents

Overview

Importing CI attributes allows to add information to CIs depending on what is important to know for a specific type.

The CI Types must already be imported before proceeding to this type of import. 

 

References

Link to the articles related to the import of CI attributes and to the XML configuration file.

What you need to know:  

The reference template files (.xlsx and .xml) to prepare imports are included in the ConfigCIType_EN.zip file.
 

Available fields for CI attributes import

Required Fields

  • Type – Text(125)
  • Attribute – Text(125)

Optional Fields

  • Rank - Numeric
    • Represents the order in which the attribute will be displayed on the Configuration tab of a CI.
NOTE: 

This field is replaced by new imported data each time. The program does not append the information it overrides it.

KeepHistory- Boolean

  • Indicates if the modifications to the attribute will be kept in the history
  • Accepted values are: 1 or 0, True or False, Yes or No
  • If this field is not completed, the default value is Yes
NOTE: 

This field can be added using DataImporter only when creating the attribute. For an attribute that already exists, the modification must be made in the reference data management of Octopus. 

Configuration file content

The declaration of the source is done by indicating the CITypeAttribute value in the <Content> tag.

NOTE : The XML file used as this example is for an import done from Excel 2007 or 2010.
<?xml version="1.0" encoding="utf-8" ?>
<Sources>
<Source Name="CITypeAttributeImport">
<ConnectionString>Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\Import\ConfigCIType_EN.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";</ConnectionString>
<ViewName>[Import Attribute$]</ViewName>
<Content>CITypeAttribute</Content>

<!-- Additionnal tags -->
</Source>
</Sources>

 

Refer to the XML Configuration File article that explains how to program references to the data sources.

X
Help us improve our articles








Help us improve our articles