/
How Can I Assign Multiple Transports to Tickets/Changes from a Excel or a Tab-delimited File?

How Can I Assign Multiple Transports to Tickets/Changes from a Excel or a Tab-delimited File?

Overview

SmartChange provides a Z-Report that enables bulk assignment of ITSM ticket information to transport requests by importing data from an Excel file. This tool is particularly useful when you need to assign multiple transports to their corresponding tickets efficiently.

Report Name: ZRTC_TM_SET_ITSM_ATTRIB (Transport request RTCK900449)

Availability: This report can be provided upon request. Please contact REALTECH support to obtain the report for your system.

Excel File Requirements

File Format

The Excel file / CSV file must meet the following specifications:

  • Supported formats: XLSX or Tab-delimited file

  • Required columns: Exactly three columns in this specific order:

    1. Transport (e.g., MT1K900122)

    2. Ticket ID (e.g., TIF-8)

    3. Guid ID (only relevant for ServiceNow UUID)

  • Worksheet processing: Only the first worksheet is processed

Example File Structure

transport

Ticket ID

Guid ID

MT1K900122

TIF-8

uuid1

MT1K900133

TIF-8

uuid2

MT1K900144

TIF-9

uuid3

 

Report Execution

Step-by-Step Instructions

  1. Call transaction SE38

  2. Execute the report: ZRTC_TM_SET_ITSM_ATTRIB

    image-20260204-131432.png

  3. Configure report parameters: The following fields are pre-filled with standard values:

    • Attribute for ITSM: ZRTC_TM_ITSM_ID

    • Attribute for Ticket/Change ID: ZRTC_TM_TICKET_ID

    • Attribute for ID/UUID: ZRTC_TM_TICKET_GUID

    ⚠️ If these attributes have not been changed in your Integration Framework configuration, you can leave them as pre-filled.

  4. Enter ITSM Name: Add your configured Server ID name from the Integration Framework > ITSM systems configuration.
    Example:

    image-20260204-131951.png

     

  5. Select the Excel file containing your transport-to-ticket mappings

  6. Execute the report

Synchronization with ITSM

Important: Mandatory Post-Processing Step

After running ZRTC_TM_SET_ITSM_ATTRIB, you must execute the synchronization report to transfer all updates to SmartITSM:

Report: /RTC/TM_SYNC_SAP_ITSM

Synchronization Configuration

  1. Include transport requests in selection criteria:

    • Use the transport requests from your Excel file in the report selection

    • This ensures only relevant transports are synchronized

  2. Deactivate Test Mode:

    • Uncheck the "Run Test Mode" flag

  3. Schedule as background job:

    • Schedule the job to run during off-peak hours (e.g., after working hours)

    • The process updates each transport individually and may take considerable time

 

 

Best Practices and Recommendations

Initial Testing

✓ Start with a small test batch:

  • Select 3–5 transports for initial testing

  • Verify the report executes without errors

  • Check the results in the TM Workflow Monitor

Large Data Volumes

✓ Split large Excel files:

  • For very large datasets, consider splitting the Excel file into multiple smaller files

  • Process transports in manageable batches

  • This approach makes troubleshooting easier if issues arise

Scheduling Strategy

✓ Plan synchronization timing:

  • Schedule the synchronization job during off-peak hours

  • Avoid running during business hours to minimize system load

  • Monitor the first execution to estimate processing time

Data Validation

✓ Verify Excel data before import:

  • Ensure all transport numbers are valid

  • Check that Ticket IDs exist in your ITSM system

  • Verify the GUID format matches your system requirements

 

 

On this page