...
This Import enters all Calls into the system and associates associate them with their respective Service IDs. The Imported Calls will then be processed according to the Call Processing and Rating Logic.
Fields
Originating Number
...
- If the To City, State, and LATA are provided, the lookup is not done.
- If the To Number starts with 011, the call is marked as International. Then, the VH lookup is not done.
- If the Call Type has already been determined to be International, Emergency, Mexico, Toll-Free, or Info, the VH lookup is not done.
- If the To Number is 4 digits long, the default NPA-NXX set in the Tenant Management grid is used.
- If the To Number is 7 digits long, the default NPA set in the Tenant Management grid is used.
- If the To Number is 11 digits long and starts with a 1, the 1 is removed before the lookup.
- If the To Number length is not 4, 7, 10 or greater, the To Number lookup is not done.
Call Date
Required if Call Date/Time is not provided.Required
Datatype is DateString.
Call Time
Required if Call Date/Time is not provided. Required
Datatype is TimeString.
Call
...
Duration
Required
Datatype is DateTimeString.
Call
...
Date/Time
Required
Datatype is String.
...
The Default value is blank.
Service
...
Datatype is String.
The Default value is blank.
The Call Rating needs to know the Service Host to use to assign Call Type and to Rate the call. By default, the Service Host of the Service will be used.
This field allows you to override the Service's Service Host value.
Service ID
Datatype is String.
The Service ID To Bill the Call.
...
This could be a Phone Number, Authcode, or Truck. Other Service Types are not considered. The Service must be Active or Inactive, and it must have a Service Host and Billing Group.If an Authcode is provided, the Service ID is set to that any billable service.
If one is not provided, the call is billed to the provided Authcode.
If there is no Authcode, the Service ID it is set billed to the ORiginating Originating Number for Outgoing Calls or Dialed Number for Incoming Calls.
Bill Date
Datatype is DateString.
Default value is Today's Date.
Call Type
Datatype is String.
...
Datatype is String.
Default value is blank.
Rating Method Inputs
Rate Tables
Maps to given Rate Table defined in Admin.
The rate must be found in the Call Rates Table.
Pass through cost in file
The costs for the call will come from the file that is being imported.
Flat Rate
Adds additional dialogue to set a flat rate.
The additional information comes from the fields in the Initial and Additional sections.
Errors
Because of the very large volume of Imported data that can occur for Calls and Usage Imports, the Error reporting is done very differently. For other Imports, if an Error happens, the Error is reported in the Imported Records grid. For Calls and Usage, the Error is stored as a code in the Call or Usage record. The available codes are in this list. This list is shared for Calls and Usage. Some of these are specifically for Calls and never happen for Usage.
Errors
...
- Column position not present in line
- Missing end for split record
- No Rate defined for this Call Type
- No Service record for Service ID
- Value not present in Lists table
- No Service record for Originating Phone Number
...
- Service ID not set
- Multiple Service records for Service ID
...
Unrecoverable Errors
...
- Error reading column using format mask
- Originating Phone Number not set
- Multiple Service records for Originating Phone Number
- Column defined as a number contains non-numeric data
- Unable to determine Call Type
...
Rating Errors
...
- No Expense GLAs for Service
- Zero or multiple matching Tenants
- Missing Service, Service Host
- Missing Service, Billing Group
- Missing Service, Rating Group
...
Billing Errors
...
- No Service record for terminating Phone Number
- Terminating Phone Number not set
- No Service record for Authcode
- Invalid duration
- Invalid date
- Invalid time
- Can't determine Origination Location
- Can't determine Termination Location
- Missing Revenue GLAs for Service Catalog and Charge Catalog
- Missing Billing Group for Service
- Unknown Error
Notes
- The Call Date and Time can be provided by the separate Date and Time fields or by the combined DateTime field.
- The Call Date and Time is considered invalid if it is more than 2 days in the future or if it is more than importFiles.ini.constants.CALL_MAX_AGE_DAYS old.
- The internal Call Processing logic does not determine if a Call is Incoming. If the Call type is Incoming, it must be assigned in the Conditional Logic.
- Either the From Number or the To Number MUST an existing Service ID.
- A Service must exist for each Call. The Service must exist as a Phone, an Authcode, or a Trunk. The other Service Types are is not considered in the Service ID lookup.
- If a Service ID is provided, that value must exist as a Service.
- else for Incoming Calls, the Dialed Number must exist as a Service ID.
- else if an Authcode is provided, the Authcode Service ID must exist.
- else for all other Outgoing Calls, the From Number must exist as a Service ID.
...