DataImporter - Import attributes for CI types

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 et .xml) to prepare imports are included in the CI_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.

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.
<!-- 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="ImportationAttributsTypesCI">
<ConnectionString>Provider=Microsoft.ACE.OLEDB.12.0;Data 
Source=c:\Import\CI.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";</ConnectionString>
<ViewName>[Import Attribute$]</ViewName>
<Content>CITypeAttribute</Content>
</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