Providing the data for the person import
Create the file PersonImport.csv in the required data structure with the following field options:
Character set: Unicode (UTF-8)
Field separator: semicolon (;)
Text delimiter: quotation marks (")
Place the file in the directory that was defined for the person import.
The import of the persons is then carried out automatically by a time-controlled workflow.
PersonImport.csv
For each data record, all listed fields with the specified column name are expected by the import and must be present.
Mandatory fields
Column name | Description | Clearly? | Field format | Maximum field length | |
|---|---|---|---|---|---|
PersonID | ID to identify the person | yes | string | 100 | |
LastName | Last name | no | string | 100 | |
FirstName | First name | no | string | 100 |
Optional fields
Column name | Description | Clearly? | Field format | Maximum field length | |
|---|---|---|---|---|---|
OfficePhone | Telephone (business) | no | string | 50 | |
OfficeEmail | E-mail (business) | no | string | 50 | |
OfficeCellPhone | Cell phone (business) | no | string | 50 | |
OfficeFax | Fax (business) | no | string | 50 | |
FormOfAddress | Salutation 0 = woman 1 = Mr | no | [de] |
Import of the Office E-mail
When generating assignment proposals, the Office E-mail stored at the imported Active Directory account and the available internal employees are compared, among other things.
You should therefore also provide this information - if available - in the person import and in the Active Directory accounts in order to receive as many assignment proposals as possible.
Example
PersonID | LastName | FirstName | OfficePhone | OfficeEmail | OfficeCellPhone | OfficeFax | FormOfAddress |
MA4711 | Sample woman | Mary | +496241123456 | maria.musterfrau@kydso.de | 0 |