Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

This will be either “Email” or “Direct Download”

Note

Note: When dropping a file onto the portal, ensure that it is not open in another application (e.g. Excel) otherwise it may not upload.

Anchor
download
download
Direct Download

...

Permission is also required from the vendor for some solutions therefore please contact us for further information and we can assist.

...

Note

NOTE: When dropping the Excel LLD file onto the portal, ensure that you do not have it open in Excel otherwise it will not upload.


Anchor
advanced
advanced
Advanced Options (Data Blending)

...

The format for each supported filetype is shown in the sections below, please ensure “Default Field Mappings” match the column names in your csv files.

Type

Typical export from

Default Field mappings

Info

Active Directory

Microsoft AD

Telephonenumber/Phone
DDI/Phone
CN
DisplayName/FullName/DirectoryName
firstName/givenname/forename
SAMAccountName
Company
Department
E-Mail/Email/EmailAddress/Mail
SIPADdress
ObjectSID
UPN/UserPrincipalName
Mobile/MobilePhone/Cell/CellPhone

Looks for Line1DN to patch telephonenumber/phone, if no match, attempts to match on name.

Will map all appropriate fields if it finds a match.

DDI

This is generated by us/you on a per-customer basis

EXTNPATTERN
DDIPATTERN
REGIONID
REGIONNAME
NAMESPACE
OVERRIDEREGIONNAME

This is used to bulk-map DDI and override locations if needed.

In this example, any extension in the form 420xxx will be given an appropriate line1DDI number, and the regionName will be overrriden to "Amsterdam" - The RegionId of -1 means "match all locations to find this number in the list"

The example 567x will only be overridden if the existing location (regionID /regionName ) matches.

Note: The number of underscores must be the same in the suffix of the 1st two columns for this to work

Devices

Generated by you/us if needed 

userId
MAC
deviceType

Used primarily for Broadworks exports where device information isn't in the backup;
Looks for the Line1DN or Line1DDI matching userId, if matched, sets the MAC and primaryModel (if each not already populated)

Network

Edge switches

Number
MAC
IP
Switch
Port
Last Seen

Will try to match on Number, IP or MAC. If found, will set LANSwitch, LANPort and LANLastSeen values

Recorder

NICE NTR

Primary Extension Name

If the "Primary Extension Name" matches Line1DN, then the callRecordingMode column is set to "Yes"

Voicemail

Unity

FirstName
LastName
Extension
group

Will persVoicemail voicemail if found, or groupVoicemail if set

CDR

Cisco CUCM

https://mittech.atlassian.net/wiki/spaces/MKB/pages/35323905#Adding-CDR-to-Cisco-BATs-audit

Vendor Specific Blending

Some vendors have their own formats for files that can be extracted when collecting a backup from a PBX, guides for blending these specific files are shown in this section.

...