Exporting and importing requests in SCP using xls format

Exporting and importing requests in SCP using xls format

Step 1 : Generate a report as xls file
* Go to Reports module and choose New Custom report, select Requests module and proceed to the report wizard.




* Select the required fields (columns) and run the report. You might choose the Request ID as well, however the requests will be created with their own instance ID in the new instance during import, note that you will have to create additional field called 'Request ID' so that it could be mapped.  The Old request ID is just for your reference, however the same could not be used in any further communication and only the new ID's will be assigned during import.





* Save the report and export it as an xls file.


* You shall use the xls file to import the requests in to the new instance, however the conversations will not be available.  

Step2: Using the xls to import Requests

Refer to this link to see on how to import requests using an xls file in Supportcenter Plus.

Note : Make sure that you create the Request fields like Custom priority, level, status, categories, and others in the new instance before the import. If you have not created them, then those values will be set as Not assigned post the request import in your new instance.

                  New to ADSelfService Plus?

                    • Related Articles

                    • How to import requests data into ServiceDesk Plus MSP ?

                      You can import your existing helpdesk Requests (tickets) into ServiceDesk Plus MSP (SDP MSP) using XLS format. Requests can be migrated to SDP MSP with basic details. Assets data can be scanned again through SDP MSP windows domain scan or using ...
                    • How to Export SSL certificate using MMC?

                      When an SSL certificate is already installed on a Windows server, you may want to reinstall it on ServiceDesk Plus server. This may be required when you have a Wildcard or a Multi-domain certificate, and the subdomains or different domains are hosted ...
                    • SQL Query to export request details

                      Supported only for SQL DB(14201 build). Executed in SQL DB directly to export the requests. Below query to export requests for one account / site. SELECT "wo"."WORKORDERID" AS "Request ID", "wo"."TITLE" AS "Subject", "wotodesc"."FULLDESCRIPTION" AS ...
                    • Widget-Based Solution for Importing Change Requests into ServiceDesk Plus

                      Overview: We currently do not have a built-in feature to import XLS files directly into the Change module. However, we understand that many customers need to import change requests from other tools into ServiceDesk Plus. To address this need, we have ...
                    • How to migrate data from SDP to SDP MSP.

                      Below are the only details which can be exported from SDP and imported to SDP MSP application. 1) You can export request data from ServiceDesk Plus (SDP) using XLS format. Requests -> Goto Admin -> Reports -> New custom report -> Tabular reports -> ...