3. Support

3.1 Problems and decisions.

If by any reasons TAPI interface with PBX doesn't work on computer on which Blitz KXTD TAPI Server is installed, at start the service Blitz_KXTDServTAPI after initialization TAPI in OS Windows you will see the log which has type "Error" with text "Any line of PBX was found" in the event log in section "Application". At start Blitz_KXTDServConsole you will see the window:

  1. Check up if the cable RS-232 for KX-TD was soldered correct (how to solder the cable you can see in section Installation and connection with RS-232 port).
  2. If the number, to which RS-232 is connected, coincides with number of COM port which is pointed in TSP driver.
  3. If the COM port is enable in BIOS of computer.
  4. If parameters of COM port setting in PBX KX-TD coincides with parameters of COM port settings in TSP driver and with "Control panel/System/Hardware/Device manager/Ports Com and LPT/Properties of COM port you need/Port settings.
  5. If SMDR interface is enabled in KX-TD.
  6. Check up if TSP driver works: enter in "Start/Settings/Control Panel". If you have Windows XP, switch "Control Panel" to classic Panel. Open "Telephone and Modem/Advanced".
  7. In the window "Services and applications/Telephony" press by the right button of the mouse on "Panasonic KX-TD TSP" and press the button "Configure provider".
  8. In the opened window "Panasonic KX-TD TSP" in section "Option Settings" you must see the list of EXT telephone line in column "EXT" and in column "TAPI" opposite the lines that you selected should be set the parameter "ON".
  9. If in section "Option Settings" you don't see any telephone line:

3.1.1 Example of registering user

3.1.2 Example of division of CallerID

3.2 Import / Export of tables

Instrument Import / Export tables can save the contents of the tables of your database files CSV, edit these CSV files in any convenient to you editor, such as Microsoft Excel or Notepad editor, create new files CSV, to fill their data and import them back in your database. When you import and export Contribute table:

  • DID/DDI Extended
  • DIL 1:1 Extended
  • CallerID distribution
  • Users
  • Speed Dial KX-TDA - this table in CSV format for the program "Panasonic KX-TDA". It recorded data from the database tables "CallerID distribution, while exports to numbers CallerID automatically adds the prefix entry into the outside line, the prefix is taken from the preferences "TAPI & Server." This table is designed for programming the PBX system Panasonic KX-TDA and to export data from it.
  • 3.2.1 Export of Tables

    The tool may be obtained through the menu "Tools / Export of Tables."

    You should choose the table that need to export the data, then selected for each table to select the column of tables CSV (default selected columns), specify the path and file names CSV and click "Finish". If all entered correctly, a tool box "Export tables close, but you specified directory will file CSV.

    3.2.2 Import of Tables

    This tool is called the menu "Tools / Import Tables" and allows the back to fill the tables of the database files from CSV. Initially, you must select the imported table, for each selected table to choose the path to your CSV file and then specify the column CSV columns database tables. It is very important to observe the appropriate types of data in both tables.

    When you import data in the column "Destination" (the direction of translation call), as the columns of tables CSV can indicate:

  • Domestic telephone numbers of users;
  • Number groups RING and UCD;
  • Usernames, and the program will undertake a search user with the same name in "Others". If a user is found, under the column "IdUser" database spread the ID-number, and Blitz_KXTDServConsole you notice his name, otherwise this field is left blank. Later in the table "Users". Users can rename all these changes will automatically appear in the columns "Destination";
  • The "1", which refers to the "End";
  • The "8", which refers to command, "Do not process the call;
  • If all entered correctly, click "Finish". In the absence of errors in the CSV file and subject to the types of data in CSV tables and databases, data ENTERED into the database. If suddenly the program finds that the imported data already present in the database (records with the same numbers DID \ DDI, CO, CallerID, EXT users), it will be asked to update these records, replacing the data in the remaining columns.

    3.2.3 Create Tables

    Create Tables menu item is intended to check the availability of tables and columns in the database required for Blitz KX-TD TAPI Server. This menu is used to update the program to a newer version. If the structure of database tables new version differs from the current structure, the Create Tables will make the appropriate changes needed for the program.

    3.3. Format of DB table

    "CallerID" - the table of CallerID distribution:

    ¹Column nameData typeLength, bytesAllow Nulls
    1CallerIDvarchar15No
    2EXT1int4Yes
    3EXT2int4Yes
    4EXT3int4Yes
    5IdClientchar6No
    6IdUser1char5Yes
    7IdUser2char5Yes
    8IdUser3char5Yes
    1. CallerID - Number of incoming outside call.
    2. EXT1 - EXT number (first EXT), on which calls will be transferred.
      Blitz_KXTDServConsole has name "Destination 1".
    3. EXT2 - EXT number (second EXT) on which calls will be transferred.
      Blitz_KXTDServConsole has name "Destination 2".
    4. EXT3 - EXT number (third EXT), on which calls will be transferred.
      Blitz_KXTDServConsole has name "Destination 3".
    5. IDClient - Identifier, allows to tie defined number with description of Client, arranged on the table ClientsID, and if it necessary to tie with other tables created by user.
      Blitz_KXTDServConsole has name "Client's name".
    6. IdUser1 - ID-1 (manager-1), used in case of a transfer of an incoming external call by name user. To do this, stobltse EXT1 should be written to "9".
    7. IdUser2 - ID-2 (manager-2), used in case of a transfer of an incoming external call by name user. To do this, stobltse EXT2 should be written to "9".
    8. IdUser3 - ID-3 (manager-3), used in case of a transfer of an incoming external call by name user. To do this, stobltse EXT3 should be written to "9".
    "DID_DIL11_Extended" - the table of conformity of CO lines, DID/DDI, EXT_Victim and EXT_Default

    ¹Column nameData typeLength, bytesAllow Nulls
    1DIDvarchar15Yes
    2COint4Yes
    3EXT_Victimint4No
    4EXT_Defaultint4No
    5Methodtinyint1No
    6IdUserchar5Yes
    1. DID - Number dialed by client at incoming call.
      Blitz_KXTDServConsole has name "DDI/DID".
    2. CO - Number of CO line, on which the calls will come.
      Blitz_KXTDServConsole has name "CO line".
    3. EXT_Victim - EXT number, from which calls will be processed.
      Blitz_KXTDServConsole has name "EXT Supervisor CO" and "EXT Supervisor DID".
    4. EXT_Default - Default number, on which calls will be transferred in case when there is no corresponding information on the table "Caller ID" or if number Caller ID was not defined.
      Blitz_KXTDServConsole has name "EXT IRNA CO" and "EXT IRNA DID".
    5. Method - The method of transfer of incoming calls:
    6. IdUser - User ID (manager), used in case of a transfer of an incoming external call by name user. To do this, stobltse EXT_Default should be written to "9". Algorithm sample EXT-numbers user and his name is similar to the algorithm described for the table CallerID.
    "LogIncCalls " - table - list of contacts

    ¹Column nameData typeLength, bytesAllow Nulls
    1CallerIDvarchar15Yes
    2CalledIDvarchar15Yes
    3DIDvarchar15Yes
    4PBXtinyint1Yes
    5COint4Yes
    6EXTConnectedint4Yes
    7CallDatedatetimeYes
    8ReplyTimedatetimeYes
    9QueryTimedatetimeYes
    10iQueryint8Yes
    11RingTimedatetimeYes
    12iRingint8Yes
    13CallDurationdatetimeYes
    14iDurationint8Yes
    15HoldTimedatetimeYes
    16IdCallIncint4Yes
    17CDchar6Yes
    1. CallerID - Number of incoming outside call.
    2. CalledID - Number dialed by subscriber vhodyaschth team in the calls.
    3. DID - Number dialed by subscriber at incoming call.
      Blitz_KXTDServConsole has name "DID/DDI".
    4. PBX - reserve
    5. CO - Number of PBX's CO-port, on which the call came.
    6. EXTConnected - EXT number, on which the call was transferred.
      Blitz_KXTDServConsole has name "EXT-line".
    7. ÑallDate - Date and time when the call came.
      Blitz_KXTDServConsole has name "Date and time of call".
    8. ReplyTime - Time, when subscriber has answered on call.
      Blitz_KXTDServConsole has name "Reply Time".
    9. QueryTime - Time to find an incoming call queue.
    10. iQuery - Time to find vhodyaschegovneshnego call in the queue, sec.
    11. RingTime - Time of incoming call.
    12. iRing - Time of incoming call, sec.
    13. CallDuration - Duration of call. (Blitz_KXTDServConsole has name "Duration").
    14. iDuration - Duration of call, sec.
    15. HoldTime - Total time, during which the incoming call is hold.
    16. IDCallInc - reserve
    17. CD - The status of call.
    "LogOutCalls" - table - list of outgoing outside calls

    ¹Column nameData typeLength, bytesAllow Nulls
    1CalledIDvarchar15Yes
    2CalledIDTailvarchar40Yes
    3PBXtinyint1Yes
    4COint4Yes
    5EXTConnectedint4Yes
    6CallDatedatetimeYes
    7ReplyTimedatetimeYes
    8RingTimedatetimeYes
    9iRingint8Yes
    10CallDurationdatetimeYes
    11iDurationint8Yes
    12CDchar6Yes
    1. CalledID - Dialed urban number.
    2. CalledIDTail - Digits dialed after telephone number.
      Blitz_KXTDServConsole has name "Additional digits".
    3. PBX - reserve
    4. CO - name of PBX's CO-port through which the outgoing outside call was made.
    5. EXTConnected - EXT number, from which the call was made.
      Blitz_KXTDServConsole has name "EXT-line".
    6. CallDate - Date and time of the beginning of the call.
      Blitz_KXTDServConsole has name "Date and time of call".
    7. ReplyTime - Time of answering the call.
      Blitz_KXTDServConsole has name "Reply Time".
    8. RingTime - Time outgoing call.
    9. iRing - Time outgoing call, sec.
    10. CallDuration - Duration of call.
      Blitz_KXTDServConsole has name "Duration".
    11. iDuration - The duration of the call, sec.
    12. CD - The status of the call.
    "ClientsID " - table - list of clients

    ¹Column nameData typeLength, bytesAllow Nulls
    1IDClientchar6No
    2Namevarchar20No
    3Name_Midvarchar20No
    4Name_Lastvarchar20No
    5Postvarchar50Yes
    6Departamentvarchar50Yes
    7ICQchar12No
    8emailchar20Yes
    9Notevarchar255Yes
    10IdOrgchar6Yes
    1. IDClient - Identifier of client.
    2. Name - Client's name.
    3. Name_Mid - Middle name.
    4. Name_Last - Last name.
    5. Post - Mailing address.
    6. Departament - Position in the company.
    7. ICQ - Number ICQ.
    8. email - E-mail address.
    9. Note - Note about client's.
    10. IdOrg - ID organization in which the client works.
    "OrganizationID" - Schedule - a list of companies in which customers

    ¹Column nameData typeLength, bytesAllow Nulls
    1IDchar6No
    2Namevarchar50Yes
    3Countryvarchar30Yes
    4ZIP_Codechar8Yes
    5Cityvarchar20Yes
    6Addressvarchar50Yes
    7urlvarchar50Yes
    8Typetinyint1No
    9Notevarchar255Yes
    1. ID - ID company.
    2. Name - The name of the company.
    3. Country - Country of the company.
    4. ZIP_Code - Zip of the company.
    5. City - City of the company.
    6. Address - Postal address.
    7. url - Website.
    8. Type - Type of the company.
    9. Note - Note of the company.
    "Managers" - table - the list of managers

    ¹Column nameData typeLength, bytesAllow Nulls
    1IDchar5No
    2EXTchar5Yes
    3Namevarchar50Yes
    4IPPortvarchar22Yes
    5AddrBooktinyint1Yes
    6AddrBook_Writetinyint1Yes
    7Loginvarchar16Yes
    8Pwdvarchar32Yes
    9Authtinyint1Yes
    10ID_Grouptinyint1No
    1. ID - Manager's identifier.
    2. EXT - Number of manager's EXT line.
    3. Name - Manager's name.
    4. IPPort - Host's name/IP address of manager's computer. It is used to define the manager's computer address, which has sanctions to receive TAPI information from certain lines of PBX. You can use CTI application which supports work with this Server (for example Blitz CallerID Display begin from version 3.0.0) as an application receives TAPI-information. And also over ":" port's number, which at incoming calls is used by application which receives text notice about incoming calls using protocol TCP/IP. It can be any application which listens socket. The port's number is not obligatory parameter. If this parameter is absent the connection will be done to the port by default which is set in settings.
    5. AddrBook - The sanction to clients to receive the information from a directory of a server.
    6. AddrBook_Write - The sanction to clients to make changes of the information in a directory of a server.
    7. Login - Name of the user for authorization.
    8. Pwd - The password of the user for authorization.
    9. Auth - Way of authorization :
    10. ID_Group - Identifier of group in which the manager is input.
    "UserGroup" - table - the list of groups

    ¹Column nameData typeLength, bytesAllow Nulls
    1IDtinyint1No
    2Namevarchar15No
    1. ID - Identifier of group.
    2. Name - Name of group.
    "Permissions" - the table of permission

    ¹Column nameData typeLength, bytesAllow Nulls
    1IDint(count)4No
    2ID_Grouptinyint1No
    3EXTvarchar5No
    4Monitortinyint1No
    5Ownertinyint1No
    6Play_Calltinyint1No
    1. ID - Counter - identifier of permission.
    2. ID_Group - Identifier of group which has permission.
    3. EXT - Number of EXT line, access to which is described by this permission. Conditional index "#1" - designates - "your line" or conditional index "#2" - designates - "all lines". Number "your line" is taken from table "Managers".
    4. Monitor - Permission or prohibition any access to PBX line.
    5. Owner - Permission or prohibition to control this line - change COS - services, subscriber's name, etc. These functions will be used in next versions of Blitz KXTD TAPI Server.
    6. Play_Call - Permission to listen to audio calls.
    "LinesStatus" - the state of internal lines

    ¹Column nameData typeLength, bytesAllow Nulls
    1EventDatedatetimeYes
    2EXTchar5Yes
    3Statustinyint1Yes
    4NotReadytinyint1Yes
    5Logouttinyint1Yes
    6Logout_GRPchar5Yes
    7DNDFWD_Inttinyint1Yes
    8DNDFWD_Exttinyint1Yes
    9OUTStinyint1Yes
    10FWDNum_Intchar15Yes
    11FWDNum_Extchar15Yes
    1. EventDate - Date and time of the event.
    2. EXT - The number of domestic lines, access to which is described this resolution. Conditional index "# 1" - indicates "My Line", the notional index "# 2" - refers to "all lines". No. "My Line", taken from the table "Managers".
    3. Status - The list of the state line
    4. NotReady - The state is not ready, turn the manager if he can not take the call.
    5. Logout - The temporary withdrawal from the group.
    6. Logout_GRP - The number of groups that had been input / output.
    7. DNDFWD_Int - Installing regime DND (busy) or forward for domestic lines
    8. DNDFWD_Ext - Installing regime DND or forward to outside lines.
    9. OUTS - Phone service or outside phone does not work.
    10. FWDNum_Int - Number which is set forward for the inner line.
    11. FWDNum_Ext - Number which is set forward for the external line.