Exporting workflow communication templates

When you export workflow communication templates, you create a query to select records. The export performs the standard outbound processing for the selected interface on the result set of the query.

About this task

If the standard processing runs classes or rules that exclude or that modify records or fields, you might need to create and use a new integration point that does not filter or modify records.

To export data, you enable the applicable external system and interface. You do not have to enable the outbound event listener.

Procedure

  1. From the List tab of the External Systems application, select the system where you want to export a data file. EXTSYS1 is a default system to where you can export workflow supporting data. You can create as many external systems as you need.
  2. Click the Outbound Interfaces tab and select the MXCTEMPLATEInterface that you want to export.
  3. Click Data Export.
  4. In the Integration Point field of the Data Export window, type the name of the corresponding integration point.
  5. Optional: In the Export Condition field, type a Structured Query Language (SQL) query. The query must be against the primary (top-level) Maximo® business object (MBO) in the integration object.
    1. To export all workflow-related communication templates, your query might read: templateid in (select templateid from wfassignment)
    2. To export communication templates related to a single workflow process, your query might read: templateid in (select templateid from wfassignment where processname = 'name' and processrev = 'rev') To avoid processing problems due to the size of the transaction, use the Export Condition field to filter out unnecessary records.
  6. Click OK.