MU Opens Export Module

At-A-Glance

Category: MU-related

Export file type: XML

File Naming Convention: muopens_mmddyy_hhmm.xml

This export module provides open minutes data for each contact type (CT) in one or more specified IEX WFM Integrated management units (MU). There is one output file that includes all specified MUs.

The output file contains one record per CT for each statistics period of each date specified. Dates are schedule dates, not activity code dates. The export does not include CTs that the MU doesn't have allocations from.

Output File: Fields and Descriptions

During your Professional Services engagement, you can choose which of the following fields to include in your export. Make sure you include every field you think you might need; you'll need a change request if you want to add fields after the export is configured. If you don't select specific fields, your export will include all the fields described here.

Field Description Values
opens

The root element of the XML output.

 If no data exists for any MU on any of the dates being processed, this element is blank.
muOpens

Contains all the data for a single MU, CT, and date.

  
muID

ID of the MU.

  
ctID

CT for which the MU has open minutes data for the date.

 This value may be -1.
date

Schedule date being processed.

  
time

Start time of a 15-minute period, in 24-hour time format. The source records include data for 48 hours, or 192 periods of 15 minutes each. All of these periods may be exported.

Data is always exported in 15-minute increments and 24-hour time format, even if your statistics period or configuration file is different.

 Values in this field are between 00:00 and 47:45.
openValue

MU's number of scheduled open minutes for the CT. If records exist for the same MU, CT, and date in both the MUSchedOpen database table and the MU external open table, the open minutes values are added and shown here.

Formatted to 4 decimal places.

If the total opens value is zero for a period, that period is excluded.

No openValue is returned if:

  • Every period has a zero value.
  • No data exists for the MU, the CT, and the date.

Output File: Sample

The following shows a sample file generated for a customer, based on their custom parameters. It also shows the data values rather than field names. It's meant only to give you an idea of what your export might look like.

<?xml version=”1.0”?>
<opens>
  <muOpens>
    <muID>28</muID>
    <ctID>27</ctID>
    <date><day>17</day><month>5</month><year>2021</year></date>
    <openValue time=”08:00”>12.00</openValue>
    <openValue time=”08:15”>12.00</openValue>
    <openValue time=”08:30”>12.00</openValue>
    <openValue time=”08:45”>12.00</openValue>
    <openValue time=”09:00”>12.00</openValue>
    <openValue time=”09:15”>12.00</openValue>
    <openValue time=”09:30”>12.00</openValue>
    <openValue time=”09:45”>12.00</openValue>
  </muOpens>
  <muOpens>
    <muID>28</muID>
    <ctID>28</ctID>
    <date><day>17</day><month>5</month><year>2021</year></date>
    <openValue time=”08:00”>54.00</openValue>
    <openValue time=”08:15”>52.00</openValue>
    <openValue time=”08:30”>55.00</openValue>
    <openValue time=”08:45”>57.00</openValue>
    <openValue time=”09:00”>59.00</openValue>
    <openValue time=”09:15”>59.00</openValue>
    <openValue time=”09:30”>62.00</openValue>
    <openValue time=”09:45”>60.00</openValue>
  </muOpens>
  <muOpens>
    <muID>28</muID>
    <ctID>-1</ctID>
    <date><day>17</day><month>5</month><year>2021</year></date>
    <openValue time=”08:00”>2.00</openValue>
    <openValue time=”08:15”>1.00</openValue>
    <openValue time=”08:30”>0.00</openValue>
    <openValue time=”08:45”>1.00</openValue>
    <openValue time=”09:00”>3.00</openValue>
    <openValue time=”09:15”>2.00</openValue>
    <openValue time=”09:30”>4.00</openValue>
    <openValue time=”09:45”>5.00</openValue>
  </muOpens>
  <muOpens>
    <muID>28</muID>
    <ctID>27</ctID>
    <date><day>18</day><month>5</month><year>2021</year></date>
    <openValue time=”08:00”>5.00</openValue>
    <openValue time=”08:15”>5.00</openValue>
    <openValue time=”08:30”>4.00</openValue>
    <openValue time=”08:45”>5.00</openValue>
    <openValue time=”09:00”>6.00</openValue>
    <openValue time=”09:15”>6.00</openValue>
    <openValue time=”09:30”>9.00</openValue>
    <openValue time=”09:45”>9.00</openValue>
  </muOpens>
</opens>