TELSENSE.EXE File Layout

The following is a sample file layout for the TELSENSE.EXE program.


Tel-Sense/PC Conversion Program - TELSENSE.EXE Version 1.8 - February 26, 2004
The TELSENSE interface program works with the following Tel-Sense/PC versions.

*** Telsense version 1.0 data fields used by STI interface ***
Date = Field 1
Extension = Field 5
Client = Field 6
State = Field 8
Phone Number = Field 9 + "-" + Field 10 + "-" + Field 11
Cost = Field 13

sample file (version 1.0 - 14 fields):

"06/02/87","13:41",1,1,2380,20003,"LDist","UT","801","350","1549",2,.28,3
"06/02/87","14:11",1,1,2380,54321,"WATS","WI","414","367","6868",1,.34,3
"06/02/87","14:21",1,1,2380,10100,"LDist","UT","801","535","1476",14,1.43,1
"06/02/87","12:16",1,1,2384,54321,"LDist","UT","801","278","2637",4,.47,1
"06/01/87","13:31",1,2,2015,12345,"LDist","UT","801","328","6100",1,,3
"06/02/87","13:08",1,2,2026,12345,"LDist","UT","801","355","6039",7,.76,2

*** TELSENSE version 2.0 or 3.1 or 3.11 or 3.2 or WIN-SENSE data fields used by STI interface ***
Date = Field 2
Extension = Field 4
Client = Field 5
State = Field 7
Phone = Field 8 + "-" + Field 9 + "-" + Field 10
Cost = Field 12

sample file (version 2.0 - 13 fields):

F,"06/02/87","13:41","  10","20013","LDist","UT","801","350","1549","2",0.280000,"3"
F,"06/02/87","14:11","  10","54321","WATS","WI","414","367","6868","1",0.340000,"3"
F,"06/02/87","14:21","  11","10101","LDist","UT","801","535","1476","14",1.430000,"1"
F,"06/02/87","12:16","  12","54321","LDist","UT","801","278","2637","4",0.470000,"1"
F,"06/01/87","13:31","  12","12345","LDist","UT","801","328","6100","1",0.000000,"3"
F,"06/02/87","13:08","  12","12345","LDist","UT","801","355","6039","7",0.760000,"2"

sample file (version 3.1 - 13 fields):

0,"05/27/92","12:16","  200","  9000000000"," Info","IL","312","555","1212","  1.0","   0.10","6"
0,"05/26/92","14:45","  200","  4013508915","LDist","NM","505","982","1873","  4.0","   1.03","4"
0,"05/26/92","14:43","  200","  4013508915","LDist","NM","505","758","8604","  2.0","   0.58","1"
0,"05/26/92","14:41","  200","  4013508915","LDist","NM","505","758","3361","  2.0","   0.58","2"
0,"05/26/92","14:40","  200","  4013508915","LDist","NM","505","758","3361","  1.0","   0.33","2"
0,"05/26/92","07:20","  200","  4045509101","LDist","NM","505","863","3132","  3.0","   0.41","2"
0,"05/26/92","07:09","  200","  4045509101","LDist","NM","505","863","3132","  1.0","   0.16","1"
0,"05/26/92","07:08","  200","  4045509101","LDist","NM","505","863","3132","  1.0","   0.16","1"

sample file (version 3.11 & WIN-SENSE - 14 fields):

1,"11/02/92","02:48","  100","","LDist","PA","215","732","5040","  2.0","   0.28","11","0"
1,"11/02/92","10:05","  100","","LDist","PA","215","732","5040","  1.0","   0.27","11","0"
1,"11/02/92","01:19","  102","","LDist","PA","215","972","8662","  1.0","   0.14","12","0"
1,"11/02/92","03:17","  102","","LDist","PA","215","972","8662","  6.0","   0.81","10","0"
1,"10/31/92","19:02","  106","","LDist","DC","202","862","932","  2.0","   0.35","9","0"
1,"10/31/92","18:30","  107","","LDist","NY","212","986","5500","  2.0","   0.35","9","0"
1,"11/01/92","22:56","  107","","LDist","NY","212","594","5300","  7.0","   1.10","11","0"
1,"11/02/92","03:52","  111","","LDist","IL","708","374","3235","  2.0","   0.27","12","0"

sample file (version 3.2 - 15 fields):

0,"02/24/04","13:53","2072","10000","Local Call","CO","303","756","0320","0.07","0.00","","Denver,","Local Call"
0,"02/24/04","13:53","2001","10100","Local Call","CO","303","795","3615","0.20","0.00","","Denver,","Local Call"
0,"02/24/04","13:53","1001","10200","Local Call","CO","303","795","3615","0.98","0.00","","Denver,","Local Call"
0,"02/24/04","13:55","2060","10300","Local Call","NE","402","423","1440","0.38","0.00","","Denver,","Local Call"
0,"02/24/04","13:55","2071","12345","Local Call","NE","402","423","1440","2.78","0.00","","Denver,","Local Call"
0,"02/24/04","13:58","2071","20001","In State Info","","","","411","0.45","0.75","","Denver,","In State Info"
0,"02/24/04","13:48","2061","20002","Local Call","CO","303","447","7140","11.03","0.00","","Denver,","Local Call"
0,"02/24/04","13:59","2071","20003","Local Call","CO","303","782","4928","0.25","0.00","","Denver,","Local Call"