How to assign existing transports to ITSM tickets from a file
When you introduce the ITSM integration, your system usually already contains transports that belong to tickets. You do not have to start from scratch: assign these transports to their tickets in one go from a file and transfer them to your ITSM system.
Available as of SmartChange SP7 HF05 (5.7.5.0). In older versions, the report is available on request as ZRTC_TM_SET_ITSM_ATTRIB.
Goal
Start with your history
Existing transports are linked to their tickets from day one.
One file, all transports
Assign all transports at once instead of one by one.
Tickets show the full picture
After the synchronization, each ticket shows its transports.
When do you need this?
You introduce the ITSM integration and already have transports that belong to tickets.
You start with SmartChange and take over transports, e.g. with the REALTECH extraction.
Transports come into the system in another way.
Prerequisites
SmartChange 5.7.5.0 or higher
The Integration Framework is configured, see ITSM Configuration.
You know the Server ID of your ITSM system. You find it in Integration Framework > ITSM systems configuration.
Steps
Step 1: Prepare the file
Format: Excel (XLSX) or tab-delimited file
Only the first worksheet is processed.
Exactly three columns in this order:
Column | Content |
|---|---|
Transport | Transport request, e.g. |
Ticket ID | Ticket or change ID in your ITSM system, e.g. |
Guid ID | Unique ID of the ticket. Only relevant for ServiceNow (UUID). |
Example
transport | Ticket ID | Guid ID |
|---|---|---|
MT1K900122 | TIF-8 | uuid1 |
MT1K900133 | TIF-8 | uuid2 |
MT1K900144 | TIF-9 | uuid3 |
Download the example file:
Step 2: Assign the transports to the tickets
In the TM Controller, run the report /RTC/TM_SET_ITSM_ATTRIB (transaction SE38).
Field | Description |
|---|---|
Attribute for ITSM | Prefilled with |
ITSM name | Server ID of your ITSM system, see Prerequisites. |
Attribute for Ticket/Change ID | Prefilled with |
Attribute for ID/UUID | Prefilled with |
Update Modifiable TR's | Updates transports that are still modifiable. |
Always overwrite ITSM assignment for modifiable TRs | Overwrites an existing assignment of modifiable transports. Not selected by default. |
Update Monitor | Updates the transports in the TM Workflow Monitor. |
Update History | Updates the transports in the Workflow History. |
Excel or tab delimited file | Your file from Step 1. |
Leave the prefilled attributes as they are, unless you changed them in your Integration Framework configuration.
Step 3: Transfer the data to your ITSM system
In the menu, choose SmartChange > Integration Framework > Manual Synchronization (report /RTC/TM_SYNC_SAP_ITSM).
Transport Request: Enter the transports from your file.
ITSM ID: Optionally restrict the run to the Server ID of your ITSM system.
Modifiable, Workflow-Monitor, Workflow-History: Select which transports are transferred.
Run Test Mode: Run the report in test mode first. Nothing is changed. Then deselect it to transfer the data.
Start with 3 to 5 transports to check that everything runs without errors.
For many transports, schedule the report as a background job after working hours. Each transport is updated individually, so this can take some time.
If needed, split the file into smaller parts.
Step 4: Check the result
In Monitoring > Logs, status
Smeans the transfer was successful.Failed calls are shown in the Monitor, see ITSM Monitoring.
Open some tickets in your ITSM system and check the assigned transports.