Table of contents
This article presents the method to join the CI covered by a service contract.
- Import Service Contracts - Internal Mode
- Import Service Contracts - External Mode
- XML Configuration File
- Back to main page for DataImporter
- Back to the Import Source Specification list
- Contract - Text (50)
- Must contain the contract number
- CI - Text (100)
- Must contain the name of the associated CI
- Cost - Decimal
- The cost of the contract for the CI
- The value must be between 0 and 9 999 999.99
- Example: 1234567.89.
Configuration File (XML)
The declaration of the source is done by indicating the SupportedCI value in the <Content> tag.
<?xml version="1.0" encoding="utf-8" ?> <Sources> <Source Name="ImportSupportedCI"> <ConnectionString>Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\Import\ServiceContract.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";</ConnectionString> <ViewName>[Import CoveredCI$]</ViewName> <Content>SupportedCI</Content> <EmptyValueHandling>NoChange</EmptyValueHandling> </Source> </Sources>
Information on Additional Tags
To import CI covered by a service contracts, the XML file can contain 1 additional tag. This tag is not mandatory and if it's not specified, the default value will be used.
Management of Empty Fields
DataImporter can help clean the data contained in Octopus when empty fields are encountered. If this tag is not present, the NoChange default value will be used.
If you want to use this tag as part of an import, it is important that your data source only contain columns to act on. DataImporter will systematically try to clean all these columns. You can clean all fields except:
- Required fields
- Fields that have been configured as mandatory in the Octopus database
- Fields that accept only specific values, for example boolean type fields (yes/no)
Permitted values for the EmptyValueHandling tag
- Clear: The existing value in Octopus will be cleared and the field will be empty
- NoChange (Default Value): Fields that are empty in the data source being imported will be ignored and the existing value in Octopus will be kept
To use this tag, add the following line to the XML file :
Thank you, your message has been sent.