Appendix D: Cisco UGCA Markup: markup.xml and call

Cisco UGCA Markup: markup.xml and call_record.discid
markup.xml

Cisco UGCA Markup: markup.xml and call_record.discid

This appendix presents the text of the file install/CSCOugca/etc/config/markup.xml. "Color" markup is detailed here.

In addition, the values for call_record.discid, which are used to mark up color, are presented here as well. call_record.discid is actually the table disc_syscode in the database to which the user has read-only access.

markup.xml

 
<?xml version="1.0" encoding="UTF-8"?>

 
<!--

 
  Markup setup file for Cisco UGCA -

 
  Universal Gateway Call Analyzer

 
  For special characters, the following have to used:

 
    &amp;    '&'

 
    &apos;   '''

 
    &quot;   '"'

 
    &lt      '<'

 
    &gt      '>'

-->

 
<!DOCTYPE MarkupSetup SYSTEM "file://localhost/_BASEDIR_/CSCOugca/etc/dtd/markup.dtd">

 
<MarkupSetup>

 
  <MarkupAttribute Name = "recid"

 
                   Type = "BIGINT"

 
                   Unique = "true"

 
                   Rule = "

 
      value = call_record.recid;

">

 
  </MarkupAttribute>

 
  <MarkupAttribute Name = "call_class"

 
                   Type = "TINYINT UNSIGNED"

 
                   Unique = "false"

 
                   Default = "1"

 
                   Rule = "

 
      value = 1;

 
      if(call_record.discid ==  8 ||

 
         call_record.discid == 10 ||

 
         call_record.discid == 11 ||

 
         call_record.discid == 12 ||

 
         call_record.discid == 13 ||

 
         call_record.discid == 14 ||

 
         call_record.discid == 15 ||

 
         call_record.discid == 16 ||

 
         call_record.discid == 17 ||

 
         call_record.discid == 18 ||

 
         call_record.discid == 19 ||

 
         call_record.discid == 20 ||

 
         call_record.discid == 21 ||

 
         call_record.discid == 22 ||

 
         call_record.discid == 23 ||

 
         call_record.discid == 25 ||

 
         call_record.discid == 26 ||

 
         call_record.discid == 27 ||

 
         call_record.discid == 28 ||

 
         call_record.discid == 29 ||

 
         call_record.discid == 30 ||

 
         call_record.discid == 31 ||

 
         call_record.discid == 32 ||

 
         call_record.discid == 33 ||

 
         call_record.discid == 34 ||

 
         call_record.discid == 35 ||

 
         call_record.discid == 36 ||

 
         call_record.discid == 35 ||

 
         call_record.discid == 36 ||

 
         call_record.discid == 37 ||

 
         call_record.discid == 39 ||

 
         call_record.discid == 41 ||

 
         call_record.discid == 42 ||

 
         call_record.discid == 43 ||

 
         call_record.discid == 56 ||

 
         call_record.discid == 57 ||

 
         call_record.discid == 60 ||

 
         call_record.discid == 61 ||

 
         call_record.discid == 62) {

 
        value = 4;

}

 
      if(call_record.duration &lt;= 60 ||

 
         call_record.rxchars &lt; 800 ||

 
         call_record.txchars &lt; 800) {

 
        value = 5;

}

 
      if( value &lt; 2 ) {

 
          if( modem_call_rec.remote_retr &gt;= 2 ||

 
              call_record.servtime &gt;= 40) {

 
            value = 2;

}

}

 
      if( value &lt; 3 ) {

 
          if( (modem_call_rec.snr &gt; 0 &amp;&amp; modem_call_rec.snr &lt;= 30 ) || 

 
              modem_call_rec.sq &lt;= 3 ||

 
              modem_call_rec.local_retr &gt;= 2) {

 
            value = 3;

}

}

 
      if( value &lt; 4 ) {

 
        if(modem_call_rec.fail_retr &gt;= 1) {

 
          value = 4;

}

}

">

 
    <MarkupAttrEnumType DefaultName  = "Normal"

 
                        DefaultValue = "1">

 
      <Pair Name="Normal"                Value="1"/>

 
      <Pair Name="Slow_Throughput"       Value="2"/>

 
      <Pair Name="Noisy_Line"            Value="3"/>

 
      <Pair Name="Abnormal_Disconnect"   Value="4"/>

 
      <Pair Name="No_Logon"              Value="5"/>

 
    </MarkupAttrEnumType>

 
  </MarkupAttribute>

 
  <MarkupAttribute Name = "cr_dur_bucket"

 
                   Type = "TINYINT UNSIGNED"

 
                   Unique = "false"

 
                   Default = "1"

 
                   Rule = "

 
      if(call_record.duration &gt; 300) {

 
        value = 3;

}

 
      else if(call_record.duration &gt; 60) {

 
        value = 2;

}

 
      else {

 
        value = 1;

}

">

 
    <MarkupAttrEnumType DefaultName  = "0-60"

 
                        DefaultValue = "1">

 
      <Pair Name="0-60"      Value="1"/>

 
      <Pair Name="60-300"    Value="2"/>

 
      <Pair Name="300-"      Value="3"/>

 
    </MarkupAttrEnumType>

 
  </MarkupAttribute>

 
  <MarkupAttribute Name = "mcr_dur_bucket"

 
                   Type = "TINYINT UNSIGNED"

 
                   Unique = "false"

 
                   Default = "1"

 
                   Rule = "

 
      if(modem_call_rec.duration &gt; 300) {

 
        value = 3;

}

 
      else if(modem_call_rec.duration &gt; 60) {

 
        value = 2;

}

 
      else {

 
        value = 1;

}

">

 
    <MarkupAttrEnumType DefaultName  = "0-60"

 
                        DefaultValue = "1">

 
      <Pair Name="0-60"      Value="1"/>

 
      <Pair Name="60-300"    Value="2"/>

 
      <Pair Name="300-"      Value="3"/>

 
    </MarkupAttrEnumType>

 
  </MarkupAttribute>

 
  <MarkupAttribute Name = "user_gr"

 
                   Type = "TINYINT UNSIGNED"

 
                   Unique = "false"

 
                   Default = "1"

 
                   Rule = "

 
      if(call_record.userid ~~ &quot;^aolnet/&quot;) {

 
        value = 2;

}

 
      else if(call_record.userid ~~ &quot;^aolip&quot;) {

 
        value = 3;

}

 
      else if(call_record.userid ~~ &quot;^aol&quot;) {

 
        value = 4;

}

 
      else {

 
        value = 1;

}

">

 
    <MarkupAttrEnumType DefaultName  = "Other"

 
                        DefaultValue = "1">

 
      <Pair Name="Other"       Value="1"/>

 
      <Pair Name="aolNet"      Value="2"/>

 
      <Pair Name="aolip"       Value="3"/>

 
      <Pair Name="aol"         Value="4"/>

 
    </MarkupAttrEnumType>

 
  </MarkupAttribute>

 
  <MarkupAttribute Name = "disc_reason_gr"

 
                   Type = "TINYINT UNSIGNED"

 
                   Unique = "false"

 
                   Default = "1"

 
                   Rule = "

 
      if(modem_call_rec.disc_reason == &quot;0x1F06&quot;) {

 
        value = 2;

}

 
      else if(modem_call_rec.disc_reason == &quot;0x1F03&quot;) {

 
        value = 3;

}

 
      else if(modem_call_rec.disc_reason == &quot;0x0220&quot;) {

 
        value = 4;

}

 
      else {

 
        value = 1;

}

">

 
    <MarkupAttrEnumType DefaultName  = "Other"

 
                        DefaultValue = "1">

 
      <Pair Name="Other"       Value="1"/>

 
      <Pair Name="Carrier"     Value="2"/>

 
      <Pair Name="IOS"         Value="3"/>

 
      <Pair Name="Normal"      Value="4"/>

 
    </MarkupAttrEnumType>

 
  </MarkupAttribute>

 
  <MarkupAttribute Name = "calling_prefix"

 
                   Type = "CHAR(6)"

 
                   Unique = "false"

 
                   Rule = "

 
      value = call_record.calling ~ &quot;[0-9]{6}&quot;;

">

 
  </MarkupAttribute>

 
  <MarkupAttribute Name = "called_prefix"

 
                   Type = "CHAR(6)"

 
                   Unique = "false"

 
                   Rule = "

 
      value = call_record.called ~ &quot;[0-9]{6}&quot;;

">

 
  </MarkupAttribute>

 
</MarkupSetup>

Table of Contents

Cisco UGCA Markup: markup.xml and call_record.discid

markup.xml