TNG EXPORT STRING FORMAT

Moderators: Leon van Heerden, Luanda_Junzi, Belinda Frick, Lee Hendricks

TNG EXPORT STRING FORMAT

Postby Belinda Frick » Mon Nov 15, 2010 8:51 am

Overview:


Each call loaded into TNG will be exported to the 'Export' folder.
The export string has a fixed format. It consists of a single string delimited by the pipe | character.

Code: Select all
UniqueID|yyyy/mm/dd hh:mm:ss|extensionnumber|extensionname
|username|department|number|DIDdigits|Destination
|IncomingOutgoing|Duration(hh:mm:ss)|trunkline|Action|Pulses
|CostingUnit|RingTime(seconds)|AccountCode|Cost|Reference
|Private or Business Flag|Phonebook Category|Trunk Name
|Account Name|Ratebook Name|CallType|BranchCode|Price|MyLink|


Note:

  • Field = 'Private or Business Flag'

    Business = 0
    Private = 1
  • We do not export the Pin Code as its value is hidden.

    We do however, export the user name linked to the pin code in the field 'username'.
  • The Price is the Cost plus the Department Markup that was added.

If you need to integrate TNG with 3rd party software, you can use one of the 2 export options. However you need to do your own development to convert the TNG call details to the format and import option for your 3rd party software.

Export options:

  • TCP port

    Log into TNG, click on the 'General Settings' icon and scroll down to 'Live Export Settings' - please configure your 'TCP Client Port'.

    You can test this by running a telnet to the IP TNG is running on and port 20003. It will display the export string for the next call loaded into TNG.

    Please note: TNG sends the data via the TCP port that is configured. It is up to you to make sure of the availability of that port and make certain that it is not blocked by firewalls etc. TNG simply sends the information and is not responsible for confirming whether that information was received by the 3rd party application.

  • a txt file in folder:

    • Up to TNG version 1.0.5.8:
      • Windows: C:\Program Files\datatex\tng\export\{yyyymmdd}\export.txt
      • Linux: /opt/datatex/tng/{yyyymmdd}/export.txt
    • From TNG version 1.0.6.0:
      • Windows: C:\Program Files\datatex\tng\export\{yyyymmdd.txt}
      • Linux: /opt/datatex/tng/export/{yyyymmdd.txt}
      Where {yyyymmdd} is the date on which the export file was written to.

Additional fields added:
Version 1.0.6.5 - Price field was added.
Version 1.0.7.0 - MyLink field added
Belinda Frick
 
Posts: 3808
Joined: Fri Nov 12, 2010 4:25 pm

Return to Support Archive's (TNG)

Who is online

Users browsing this forum: No registered users and 1 guest

cron