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 Export SSL certificate using MMC?

                        When an SSL certificate is already installed on a Windows server, you may want to reinstall it on SupportCenter Plus server. This may be required when you have a Wildcard or a Multi-domain certificate, and the subdomains or different domains are ...
                      • Steps to Import accounts / contacts through schedule csv from SCP 11001 build

                        This is applicable only from 11001 builds. How to do? # Based on the Globalconfig table entry with category as 'CSVUserImportSchedule', this can be turned ON/OFF. By default this is turned OFF. Query to enable the feature - update Globalconfig set ...
                      • User Import Issue (CSV)

                        While importing Contact or Support Rep via CSV many customer face issue with importing getting failed The most comman reason is that the CSV file may not have the password for the users getting imported We have set the Display Name and Login Name as ...
                      • SCP upgrade from 11.0 to 14.0 prerequisites

                        Before migration to scp version 14 below 2 points has to be done in scp 11027 1. Back up password should not be default i.e SCP123!, it should be updated 2. TLSv1, TLSv1.1 has to be added under the file /home/jre/lib/security/java.security file ( ...
                      • Delete requests

                        If you would like to delete the older requests, you could use the below query. Connect to the Database For MSSQL: delete from workorder where dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (CREATEDTIME/1000),'1970-01-01 00:00:00') <= ...