The following is a sample file layout for the DANYL.EXE program.
Program: DANYL.EXE
Note: There are 4 possible DANYL formats that this program supports.
Format 1: QBACOL format
Data File: TRACRnnn.DAT (nnn is the copier number)
File Type: Variable Length (comma-delimited)
Field Is Field
Number Converted? Field Description
------ ---------- ------------------------------------------------------------
1 Yes Record Type (Have record types "A", "B" and "T")
2 Yes Copier Number
3 Yes Account (Type "A": client/matter number, no separator)
(Type "B": date - in MM/DD/YY format)
(Type "T": the text "**TOTALS**")
4 Yes Copy Count
Sample TRACR001.DAT file:
"B",023,"03/16/1996",000000000
"A",023,"0000000011",000004207
"A",023,"0000000638",000000021
"A",023,"0000075132",000000157
"A",023,"local ****",000000010
"T",023,"**TOTALS**",000004395
Format 2: Expense Logger (old format)
Data File: TRACER.LGS
File Type: Variable Length (comma-delimited)
Field Is Field
Number Converted? Field Description
------ ---------- ------------------------------------------------------------
1 Yes Date (in MM/DD/YY format)
2 No Time (in HH:MM format)
3 No Unit Number (01 thru 95)
4 Yes Disbursement Code (00 thru 99)
5 Yes Amount in nnn.nn format)
6 No Copy Count (1 thru 99999)
7 Yes Client Number
8 Yes Matter Number
Sample TRACER.LGS file:
01/08/96,08:57,01,00,00002.50,00025,101,00
01/08/96,09:14,01,00,00004.25,00040,200,03
01/08/96,10:15,02,22,00015.00,00000,200,01
01/09/96,09:10,01,00,00003.75,00035,200,03
01/09/96,10:15,01,00,00005.00,00042,200,02
Format 3: Expense Logger
Data File: TRACER.LGS
File Type: Variable Length (comma-delimited)
Field Is Field
Number Converted? Field Description
------ ---------- ------------------------------------------------------------
1 Yes Date (in MM/DD/YY format)
2 No Time (in HH:MM format)
3 No Unit Number (01 thru 95)
4 Yes Disbursement Code (00 thru 99)
5 Yes Amount (in nnn.nn format)
6 No Copy Count (1 thru 99999)
7 Yes Phone Number (in nnn-nnn-nnnn or 011nnnnnnnnn format)
8 No User Initials
9 Yes Client Number
10 Yes Matter Number
Sample TRACER.LGS file:
01/08/96,08:57,01,13,00002.50,00025," ","PJT",101,00
01/08/96,09:14,01,14,00004.25,00000,"609-234-8000","WF ",200,03
01/08/96,10:15,02,14,00015.00,00000,"212-921-1175","WF ",200,01
01/09/96,09:10,01,11,00003.75,00035," ","PJT",200,03
01/09/96,10:15,01,13,00005.00,00042," ","PRM",200,02
Format 4: LANsimile Professional or RECOUNT 3000
Data File: TRACER.LGS
File Type: Variable Length (comma-delimited)
Field Is Field
Number Converted? Field Description
------ ---------- ------------------------------------------------------------
1 Yes Date (in MM/DD/YY format)
2 No Time (in HH:MM format)
3 No Unit Number (01 thru 95)
4 Yes Disbursement Code (00 thru 99)
5 Yes Amount (in nnn.nn format)
6 No Copy Count (1 thru 99999)
7 No Fax Page Count (0 thru 9999)
8 Yes Phone Number (in nnn-nnn-nnnn or 011nnnnnnnnn format)
9 No Call Duration (12.3 minutes stored as 123)
10 No User Initials
11 Yes Client Number
12 Yes Matter Number
Sample TRACER.LGS file:
01/08/96,08:57,01,13,00002.50,00025,0000," ", ,"PJT",101,00
01/08/96,09:14,01,14,00004.25,00000,0010,"609-234-8000",0005,"WF ",200,03
01/08/96,10:15,02,14,00015.00,00000,0020,"212-921-1175",0008,"WF ",200,01
01/09/96,09:10,01,11,00003.75,00035,0000," ", ,"PJT",200,03
01/09/96,10:15,01,13,00005.00,00042,0000," ", ,"PRM",200,02