Format of a PIP file

Moderator: Luanda_Junzi

Format of a PIP file

Postby Belinda Frick » Tue Nov 23, 2010 3:35 pm

The Topaz PIPE File is actually just a CSV file that uses pipe "|" Character to
delimit it's fields.

Format is as Follows:

Old String:
Code: Select all
Date|Time|Ext|Number|IO|Account|Hour|Min|Seconds|Line|Action|Pulses|RingTime|Reference|DID|



New String:
Code: Select all
Date|Time|Ext|Number|IO|PINCODE|Hour|Min|Seconds|Line|Action|Pulses|RingTime|Reference|DID|MGROUP|MyUSER|Account|



Explained:
Code: Select all
Date Format : dd-mm-yyyy
Time Format : HH:mm:ss ( 24 hour time)
Ext         : Extension
Number      : Phone number dialed or dialed from (CLI)
IO          : I = Incoming or O = Outgoing no other values excapted in this field.
Pincode     : Pin code used
Hour        : The Hour part of the Duration of the call
Min         : The Minute part of the Duration of the call
Sec         : The Seconds Part of the Call Duration
Line        : The Line number used for this call. (Up to 9 Char long)
Action      : An Action type related to this call.
Pulses      : Meter pulses if used.
RingTime    : Ring Time of the call in seconds
Reference   : A Reference related to this call. (Up to 30 Chars long)
DID         : Direct inward Dialing number.
MyGroup     : RUBY call centre group (for use with RUBY)
MyUser      : User name as supplied by the PABX.
Account     : Account code used


2 example calls
Code: Select all
28-10-2003|05:32:00|105|INCOMING|I||00|01|17|01|I_ANSWERED|0|0|MYFIRSTSALE|4033
19-10-2003|17:44:00|107|0834598200|O||00|04|34|01|O_NORMAL|0|0|ABD_TEST_REFERENE|4077
Belinda Frick
 
Posts: 3808
Joined: Fri Nov 12, 2010 4:25 pm

Return to Support Archive's (TOPAZ)

Who is online

Users browsing this forum: No registered users and 1 guest