Tabs3 TBDevice
ASCII Variable Length Data Format
Overview
The Tabs3 TBDevice software (ASCII Variable format) can be used to convert fee, cost, and payment transactions from an ASCII file with variable length fields to be compatible with the Merge Tabs3 Remote Data program.
The TBDevice program must reside in the same directory as the Tabs3 programs in order to work properly. The ASCII data file must reside in the Tabs3 program directory. Details regarding the exact file layout can be found on the following page.
Installation
To install the TBDevice program on your hard disk:
Note: The TBDevice program (TBDEVICE.EXE) must be installed in the same directory where the Tabs3 program resides.
Configuring the Data Collection Device Type
Before you can convert any data from a data collection device, TBDevice must be configured to handle the necessary format.
Converting ASCII Variable Length Data
Use the following procedure for the conversion:
Note: A TBDEVICE.LOG file is created and will contain any records that were not converted. If no errors were encountered during the conversion, then the TBDEVICE.LOG file will be a zero byte file.
Note: If you are using a full user system, the ASCII Variable data file will automatically be deleted when the conversion is complete to avoid double posting of the data. However, when using a trial system, the data file is not deleted.
Note: You can change the Descriptions options used by the ASCII Variable format by selecting File | Configure.
Input Field Positions
|
File Layout |
||
|
Field |
Field # |
Format |
|
Client ID |
1 |
Up to 12 characters |
|
Timekeeper |
2 |
Up to 3 characters (can be either timekeeper number or timekeeper initials) |
|
Tcode |
3 |
Up to 3 digits preceded by a "$" for costs or payments (trans code cannot be greater than 999 in value) |
|
Phase/Task Code |
4 |
Must be in the format XNNN, where X is any upper case letter (excluding A and E) and NNN is 3 digits |
|
Activity Code |
5 |
Must be in the format XNNN, where X is either the letter A (for fees) or E (for costs), and NNN is 3 digits |
|
Date |
6 |
Must be in the mm/dd/yy or the mm/dd/yyyy format. |
|
Hours (for fees) |
7 |
Decimal format up to 9999.99 maximum (i.e. 1.25 is 1 hr. 15 min.) |
|
Rate |
8 |
Dollar format up to 9999.99 |
|
Amount |
9 |
Billable dollar amount up to 9999999.99 |
|
Description |
10 |
Up to a maximum of 5000 characters |
|
CrLf |
carriage return/line feed |
|
Notes
Sample Data File
The following is an example of a variable length ASCII data file. Please note that lines with longer descriptions were wrapped to the next line and indented in this example so the text can be seen on the printed copy. Actual transactions in a real data file will appear as one continuous line.
101.00,RJB,,L110,A101,02/19/03,1.50,60.00,90.00, "Office conference with Karen Barrett and all of the apartment managers concerning the unpaid rents at the new apartments." 200.01,1,$23,,,02/15/03,0.00,0.00,15.00, "court filing fee." 101.00,MLJ,$,L110,E101,02/15/03,0.00,0.00,1.25, "photocopies." 101.00,MLJ,,L120,A106,02/19/03,1.22,0.00,73.20, "Telephone conference with Ms. Barrett." 200.01,2,$21,,,02/19/03,0.00,0.00,2.50, "Photocopy originals." 200.02,2,$23,,,02/19/03,0.00,0.00,25.00, "Pay County Court filing fee in advance on behalf of Client."
Startup Options
Command line options can be used when starting TBDevice to bypass the User ID prompt and automatically execute the Convert and Validation programs thereby eliminating user interaction. These startup options can be quite useful when implemented as part of a batch file.
The following are examples of the available startup options:
Bypass the User ID prompt F:\STI\TBDEVICE.EXE ALICE
Convert F:\STI\TBDEVICE.EXE /CONVERT ASCII VARIABLE
Validation F:\STI\TBDEVICE.EXE /VALIDATION ASCII VARIABLE
Note: The normal "sign in" routine is used when TBDevice is started with the "/CONVERT" or "/VALIDATION" options. If you have not specified a User ID on the command line, you will be required to enter the User ID. If password security has been defined, you will also be required to enter the password before the Convert or Validation program will proceed.
The TBDevice Help includes complete details regarding Startup Options.
2003/12