The following is a sample file layout for the COMDIAL.EXE program.
Program: COMDIAL.EXE Data File: The input file can have any name File Type: Report (Station Report)
The fields listed below are converted from the ComDial file.
Field Name Position Length Field Notes
---------- -------- ------ -----------------------------------------------
DATE 1 5 The date is in MM/DD format - the MM and DD are
converted from here and the YY is converted
from the first report header with the
"Date:" or "Date :" text present.
ACCOUNT 21 8 Converted as client/matter number. There is
no decimal separator between the client and
matter numbers. Client/matters greater than
8 characters are impossible to convert.
COST 38 6 The cost (plus a markup/markdown percentage, if
specified during configuration) is converted
as is.
NUMBER 61 end The phone number only appears in transaction
descriptions that do not successfully merge
in with Tabs3.
Sample Comdial phone data file:
Notes: 1) The first 3 lines are not part of the ComDial station report file. 2) The program will abort if the text "Station Report" is not present anywhere in the data file. 3) The program will abort if the text "Date:" or "Date :" is not present anywhere in the data file. 4) A line in the report is only considered to be a transaction if there is a "/" character in the 3rd position and a ":" character in the 9th position. All other lines not matching this pattern are ignored. 5) If a line in the report has a leading space (i.e., the "/" character is in the 4th position and the ":" character is in the 10th position), the space will be removed from the beginning of the line so that the line matches the conditions set forth in item 4 above. 6) Since individual transactions don't contain the year as part of the date, the year is converted from the first header line with the text "Date:" or "Date :". 7) If you create the data file in January and it contains the December phone calls, the program will automatically adjust the year back by 1 if the the month from the header date is less than the month on the first transaction on the report.
1 2 3 4 5 6 7 123456789012345678901234567890123456789012345678901234567890123456789012345678 ------------------------------------------------------------------------------
Report for Unanswered Incoming Calls
Date : 12/18/98 Time : 10:41
DATE TIME STATION ACCOUNT LNGTH COST I/O RING LINE NUMBER
----- ----- ------- -------- ----- ------- --- ----- ----- ----------------
12/15 13:08 NOANS $ 0.00 I 0.1 1
12/17 09:06 NOANS $ 0.00 I 0.5 2
-----------------------------------------------------------------------------
TOTALS: 0.0 $ 0.00 0.6 INCOMING : 2
AVERAGES: 0.0 0.3 OUTGOING : 0
TOTAL CALLS : 2
Station Report for Extension - 14 (PHILLIP)
Date : 12/18/98 Time : 10:43
DATE TIME STATION ACCOUNT LNGTH COST I/O RING LINE NUMBER
----- ----- ------- -------- ----- ------- --- ----- ----- ----------------
12/15 10:44 14 1.1 $ 0.13 O 3 7714400
12/15 10:48 14 1224359 1.5 $ 0.18 O 3 18436789755
12/16 11:05 14 1444513 1.1 $ 0.13 O 3 18035937302
12/16 11:06 14 0.9 $ 0.10 O 3 411
12/16 11:07 14 1444513 0.8 $ 0.09 O 2 18036412500
12/16 11:08 14 1444513 1.3 $ 0.15 O 2 18035937300
12/16 11:16 14 0.2 $ 0.02 O 3 5519538806822222
12/16 11:21 14 1.3 $ 0.00 I 0.1 1
12/16 11:43 14 0.3 $ 0.03 O 4 7338464
12/16 11:52 14 3.5 $ 0.00 I 0.1 5
-----------------------------------------------------------------------------
TOTALS: 77.9 $ 0.83 0.2 INCOMING : 2
AVERAGES: 1.2 $ 0.11 0.1 OUTGOING : 8
TOTAL CALLS : 10