The following is a sample file layout for the COPYGDCM.EXE program.
Program: COPYGDCM.EXE (Interface program for the CopyGuard CM 24)
Data Files: TRANSACT.CSV
MACHINE.CSV
File Type: Variable Length (comma-delimited)
There are 3 possible file layouts for the TRANSACT.CSV file
Layout 1: Known as the Standard format
Field Name Format (only fields in bold are converted)
----- ------------------ --------------------------------------------------
1 Machine Number Numeric (up to 4 digits)
2 Date of Transaction Text (YYYYMMDD format)
3 Time of Transaction Text (HHMM format)
4 Client Number Text (up to 12 characters)
5 Matter Number Numeric (up to 4 digits)
6 User Number Numeric (up to 3 digits)
7 Number of A Copies Numeric (up to 5 digits, max of 32767)
8 Number of B Copies Numeric (up to 5 digits, max of 32767)
9 Source Numeric (1 digit [1=machine, 2=manual])
Sample Standard Transact.csv file:
1,20030304,"1740","100",00,1,12,44,2
3,20030304,"1747","101",00,3,102,0,2
2,20030304,"1747","102",00,3,87,1,2
1,20030304,"1747","102",00,2,88,0,2
2,20030304,"1804","200",01,3,120,0,2
Layout 2: Known as the LawPak format
Field Name Format (only fields in bold are converted)
----- ------------------ --------------------------------------------------
1 Machine Number Numeric (up to 4 digits)
2 Date of Transaction Text (YYYYMMDD format)
3 Time of Transaction Text (HHMM format)
4 Client Number Text (up to 12 characters)
5 Matter Number Numeric (up to 4 digits)
6 User Number Numeric (up to 3 digits)
7 Number of A Copies Numeric (up to 5 digits, max of 32767)
8 Number of B Copies Numeric (up to 5 digits, max of 32767)
9 Source Numeric (1 digit [1=machine, 2=manual])
10 Billable Numeric (1 digit [1=billable])
Sample LawPak Transact.csv file:
1,20030304,"1740","100",00,1,12,44,2,1
3,20030304,"1747","101",00,3,102,0,2,1
2,20030304,"1747","102",00,3,87,1,2,1
1,20030304,"1747","102",00,2,88,0,2,1
2,20030304,"1804","200",01,3,120,0,2,1
Layout 3: Known as the MultiRate format
Field Name Format (only fields in bold are converted)
----- ------------------ --------------------------------------------------
1 Machine Number Numeric (up to 4 digits)
2 Date of Transaction Text (YYYYMMDD format)
3 Time of Transaction Text (HHMM format)
4 Client Number Text (up to 12 characters)
5 Matter Number Numeric (up to 4 digits)
6 User Number Numeric (up to 3 digits)
7 Number of A Copies Numeric (up to 5 digits, max of 32767)
8 Number of B Copies Numeric (up to 5 digits, max of 32767)
9 Source Numeric (1 digit [0=copier, 1=external, 2=manual])
10 Billable Numeric (1 digit [1=billable, 2=nonbillable])
11 Cost per A Copy Numeric (up to 5 digits)
12 Cost per B Copy Numeric (up to 5 digits)
13 Total Cost for A Numeric (up to 7 digits)
14 Total Cost for B Numeric (up to 7 digits)
15 Total of A + B Numeric (up to 7 digits)
16 Description Text (up to 20 characters)
Sample MultiRate Transact.csv file:
1,20030304,"1740","100",00,1,12,44,2,1,.15,.25,.30,.30,8.60,"certfied letters"
3,20030304,"1747","101",00,3,102,0,2,1,.15,.25,.35,.35,8.70,"meeting notes"
2,20030304,"1747","102",00,3,87,1,2,1,.15,.25,.40,.40,8.80,"court briefs"
1,20030304,"1747","102",00,2,88,0,2,1,.15,.25,.45,.45,8.90,""
2,20030304,"1804","200",02,3,120,0,2,1,.15,.25,.50,.50,9.00,"correspondence"
MACHINE.CSV File Layout:
Field Name Format (only fields in bold are converted)
----- ---------------- --------------------------------------------------
1 Machine Number Numeric (up to 4 digits)
2 Location Text (up to 25 characters)
3 Type Text (up to 25 characters)
4 Not Used Numeric (up to 2 digits)
5 Job A Description Text (up to 25 characters)
6 Job A Cost Price Numeric (up to 8 digits, max of 9999.999)
7 Job A Selling Price Numeric (up to 8 digits, max of 9999.999)
8 Job B Description Text (up to 25 characters)
9 Job B Cost Price Numeric (up to 8 digits, max of 9999.999)
10 Job B Selling Price Numeric (up to 8 digits, max of 9999.999)
11 Not Used Numeric (up to 10 digits)
12 Not Used Text (up to 10 characters)
13 Date of Last Poll Text (YYYYMMDD format)
14 Time of Last Poll Text (HH:MM format)
Sample Machine.csv file:
1,"1st Floor","50 Cps Copier",0,"Letter",0.030,0.400,"Legal",0.040,0.500,0,"",20030326,"15:47"
2,"1st Floor","50 Cps Copier",0,"Letter",0.030,0.400,"Legal",0.040,0.500,0,"",20010101,"00:00"
3,"2nd Floor","40 Cps Copier",0,"Letter",0.030,0.400,"Legal",0.040,0.500,0,"",20010101,"00:00"
Notes:
1) Each field is delimited by a comma. The quotation marks at the
beginning and end of each field are optional.
2) If the Matter Number is a zero, then the Client Number is converted as
the Client ID. Otherwise, the Matter Number is padded on the right with
zeros and appended to the Client Number.
3) If there are copies at rate A, the number of copies at rate B are ignored.
4) If the Selling Price field is zero, then the TABS III Import program will
supply the default rate assigned in the COPYGDCM parameter file.