Importing Requests from XLS file
ManageEngine ServiceDesk Plus - MSP provides an easy-to-use XLS import option to import bulk requests from your existing application or even from other applications. The total size of the XLS file that you are importing should not exceed 20 MB.
To import requests from XLS file,
Step 1: Upload XLS file
NOTE: A sample XLS file can be downloaded by clicking on the click here link.
Step 2: Map fields
In this step you can map the SDP MSP fields with the corresponding XLS fields to make sure the request values are transferred properly. The field names of the XLS file are populated in the drop down boxes beside the each field label in SDP MSP.
To map fields,
Step 3: Import Status
This section appears whenever a new field value is available for the mapped field in the XLS file. For example, if a new priority 'Urgent' is available in the XLS file, then the field name 'Priority' with the new value 'Urgent' will be displayed in this section. To get the new values imported, you will have to add the new values under Admin module prior to the import. You can also skip adding the new values by selecting Import without adding the above field values check box. Click Import button. The requests are imported from the XLS file.
NOTE: Requests cannot be imported unless you add the new values or skip adding the new values.
On completion of the import, the total records on the selected sheet, the number of records imported and the number of records failed to import are displayed under this section. A list of failed records and the reason for failure are represented in the form of a link. You can click the ‘Failed XLS File’ to view the list of failed requests. To view the reasons for import failure, click ‘Failed Records’ link.
The possible reasons for request import failure are as follows:
Click Finish button to view the imported requests in the Request List view.