Table of contents
Importing the relationship between the users and the CI allows to add the users that use a CI. It is important to have previously added the users and the CI before doing this type of import.
- CI – Text (125)
- Name of CI to be related
- The identifier of the user to be related
- See section User identification method
Configuration File (XML)
The declaration of the source is done by indicating the CIUser value in the <Content> tag.
<?xml version="1.0" encoding="utf-8" ?> <Sources> <Source Name="User CI Import"> <ConnectionString>Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\Import\CI.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";</ConnectionString> <ViewName>[Import CI User$]</ViewName> <UserIdentificationMethod>UserByWindowsUsername </UserIdentificationMethod> <ManageRelations>False</ManageRelations> <Content>CIUser</Content> </Source> </Sources>
Information on Additional Tags
To import CI users, the XML file used can contain 1 additional tag. This tag is not mandatory and if it's not specified, the default value will be used.
User Identification Method
In the XML file to import the relationship between the users and CI, it is possible to specify how the user will be found. This value becomes the unique key to the import. If this tag is not specified, the default value will be the CI name.
Permitted values for the UserIdentificationMethod tag:
- UserByID: User employee number
- UserByName: First and last name of user (in the following format John Smith)
- UserByWindowsUsername (Default value): Windows username of the user
To use this tag, add the following line to the XML file:
Thank you, your message has been sent.