The following is a sample file layout for the CONVASCV.EXE program.
Program: CONVASCV.EXE
Data File: TABS3.ASC
File Type: Variable Length (comma-delimited)
TABS3.ASC File Layout
Field Name Format
----- ---------------- --------------------------------------------------
1 Timekeeper up to 3 digits
2 Client Number up to 12 digits (with optional decimal point)
3 Transaction Code up to 5 digits preceded by a "$" for costs (trans code cannot be greater than
30999 in value)
4 Description up to 5000 characters (100 lines) of text
5 Date mm/dd/yy format
6 Hours Worked hours worked in decimal format up to 320.00
maximum (i.e. 1.25 is 1 hr. 15 min.)
7 Hourly Rate hourly billing rate in dollar format up to 9999.99
8 Amount billable dollar amount up to 9999999.99
CrLf carriage return/line feed
NOTES
1) Each field is delimited by a comma. The quotation marks at the
beginning and end of each field are optional with the exception of the
Description field. The description field should begin and end with quotes
(i.e. "text") so that commas in the description field are not mistaken for
a field delimiter. Also, embedded quotes in the description text should be
single quotes so they are not mistaken for boundary quotes (i.e. "this is a
sample of 'quoted' text, with a comma within the text").
2) The Timekeeper, Accumulated Time and Hourly Rate (fields 1, 6 and 7) are
ignored for cost transactions (costs are denoted
by prefixing the transaction code number with "$").
3) The Client Number can be from 3 to 12 digits long with an optional
decimal point separating the client number from the matter number.
4) Tabs3 transaction codes can be from 1 to 999. It is possible to
convert the Tabs3 bill code combined with the transaction code. A bill
code of 10 (non-billable/non-printable), 20 (non-billable/printable) or 30
(billable/non-printable) can be added to the beginning of the transaction
code. No bill code is an indication of a billable/printable transaction.
If bill code 10, 20 or 30 is used, the Tabs3 transaction code number must
be zero padded on the left to be 3 digits long (e.g., if using bill code 20
with transaction code 9, change 9 to 009 and convert transaction code 20009).
5) If the Hourly Rate field is zero, then the Tabs3 Import program will
supply the default rate assigned in the Tabs3 client record.
6) If both Hourly Rate and Amount fields are zero, then Tabs3 will
supply a default rate and calculate the Amount automatically.
7) When the data is merged into Tabs3, the Timekeeper, Client Number and
Transaction Code fields are verified as being valid. Transactions with
invalid fields are rejected and a list of rejected transactions can be
printed along with an error code indicating why it was rejected.
8) Tabs3 uses 50 characters per line for description. Actual number of
characters will be limited to what will fit on 100 lines after word
wrapping takes place.
9) Payment transactions cannot be merged into Tabs3.
Sample TABS3.ASC data file: Please note that lines with too much
description text were wrapped to the next line and indented 5 spaces.
"Actual" lines in the real world will have 1 line per transaction entry no
matter how long they are.
"02","101.00","1","Office conference with Karen Barrett and all of the
apartment managers concerning the unpaid rents at the new
apartments.","02/19/87",1.50,60.00,90.00
"01","200.01","$23","court filing fee.","02/15/87",0.00,0.00,15.00
"02","101.00","$21","photocopies.","02/15/87",0.00,0.00,1.25
"02","101.00","3","Telephone conference with Ms.
Barrett.","02/19/87",1.22,0.00,73.20
"02","200.01","$21","Photocopy originals.","02/19/87",0.00,0.00,2.50
"02","200.02","$23","Pay County Court filing fee in advance on behalf of
client.","02/19/87",0.00,0.00,25.00