The following is a sample file layout for the MICROCAL.EXE program.
Program: MICROCAL.EXE
Note: There are 5 possible Microcall formats that this program supports.
Format 1: (not sure which Microcall version this is)
Data File: MICROCAL.DTA
File Type: Fixed Length (record length = 85 bytes)
Name Start Length Description
-------------- ----- ------ ----------------------------------------------
Date 1 8 Date in MM/DD/YY format
Extension 20 4 Phone extension from which call was made
Phone Number 26 14 Phone number dialed
Location 40 13 City and state of phone number dialed
Amount 53 8 Call amount
Account Number 61 17 Client/Matter number - can convert accounts
with a "." or "-" or no separator between
the client and matter numbers
Example of Microcall format 1:
Note: Each record has been divided into 2 separate sections (a 70 byte
section followed by a 15 byte section) so the records won't be truncated on
the page. Also, the first 3 lines are not part of the MICROCAL.DTA file.
1 2 3 4 5 6 7
1234567890123456789012345678901234567890123456789012345678901234567890
----------------------------------------------------------------------
03/28/8712:560:03.4 301 3 - -623-0787COLUMBUS WI 1.51
10000 42
03/28/8713:390:00.7 301 8 -212-878-6264NY CITY 1 NY 0.58
10100 88
03/28/8712:050:00.7 310 0 - -357-4360MILWAUKEE4 WI 0.77
12345 5
03/28/8713:370:01.5 310 9 -619-221-1021SAN DIEGO CA 1.01
10200 86
03/28/8713:470:04.2 310 0 -800-233-8987800 CALL 0.00
20001 100
==============================================================================
Format 2: (not sure which Microcall version this is - probably 5.x or 6.x)
Data File: MICROCAL.DTA
File Type: Fixed Length (record length = 89 bytes)
Name Start Length Description
-------------- ----- ------ ----------------------------------------------
Date 1 8 Date in MM/DD/YY format
Extension 20 4 Phone extension from which call was made
Phone Number 32 14 Phone number dialed
Location 46 13 City and state of phone number dialed
Amount 59 7 Call amount
Account Number 66 16 Client/Matter number - can convert accounts
with a "." or "-" or no separator between
the client and matter numbers
Example of Microcall format 2:
Note: Each record has been divided into 2 separate sections (a 70 byte
section followed by a 19 byte section) so the records won't be truncated on
the page. Also, the first 3 lines are not part of the MICROCAL.DTA file.
1 2 3 4 5 6 7
1234567890123456789012345678901234567890123456789012345678901234567890
----------------------------------------------------------------------
01/02/8912:250:00.4 102 3 3 - -736-6464COLUMBIA SC 0.77
12345 18
01/02/8912:580:00.7 102 1 1 - -736-6464COLUMBIA SC 1.01
10200 21
01/03/8910:150:13.0 102 2 21-919-460-0775CARY NC 0.00
20001 60
01/03/8911:040:00.6 102 2 2 - -788-3860COLUMBIA SC 3.05
20002 76
01/03/8912:300:01.6 102 4 4 -139-304-0616 1.21
20003 96
==============================================================================
Format 3: (not sure which Microcall version this is - probably 5.x or 6.x)
Data File: MICROCAL.DTA
File Type: Fixed Length (record length = 123 bytes)
Name Start Length Description
-------------- ----- ------ ----------------------------------------------
Date 1 8 Date in MM/DD/YY format
Extension 21 4 Phone extension from which call was made
Phone Number 45 17 Phone number dialed
Location 62 13 City and state of phone number dialed
Amount 75 6 Call amount
Account Number 81 17 Client/Matter number - can convert accounts
with a "." or "-" or no separator between
the client and matter numbers
Example of Microcall format 3:
Note: Each record has been divided into 2 separate sections (a 70 byte
section followed by a 53 byte section) so the records won't be truncated on
the page. Also, the first 3 lines are not part of the MICROCAL.DTA file.
1 2 3 4 5 6 7
1234567890123456789012345678901234567890123456789012345678901234567890
----------------------------------------------------------------------
01/03/8913:540:02.6 102 2 2 1-404-998-9970 ROSWELL
GA 0.12 40000 107
01/03/8913:580:03.3 102 4 4 - 1-724-6922 CHARLESTO
N SC 1.58 402.00 110
01/03/8914:030:06.0 102 2 2 1-314-445-6833 COLUMBIA
MO 1.25 500.00 111
01/03/8915:250:00.2 102 1 1 - -754-0975 COLUMBIA
SC 0.69 60000 149
01/05/8915:210:01.7 102 2 2 1-704-394-0319 CHARLOTTE
NC 4.18 600.01 462
==============================================================================
Format 4: Microcall version 7.x
Data File: MICROCAL.DTA
File Type: Fixed Length (record length = 137 bytes)
Name Start Length Description
-------------- ----- ------ ----------------------------------------------
Date 1 8 Date in MM/DD/YY format
Extension 28 7 Phone extension from which call was made
Phone Number 51 23 Phone number dialed
Location 74 13 City and state of phone number dialed
Amount 87 6 Call amount
Account Number 93 17 Client/Matter number - can convert accounts
with a "." or "-" or no separator between
the client and matter numbers
Example of Microcall format 4 (version 7.x):
Note: Each record has been divided into 2 separate sections (a 70 byte
section followed by a 67 byte section) so the records won't be truncated on
the page. Also, the first 3 lines are not part of the MICROCAL.DTA file.
1 2 3 4 5 6 7
1234567890123456789012345678901234567890123456789012345678901234567890
----------------------------------------------------------------------
03/02/9700:4400:04.6 1425 1425 1 1 1-717-325-3324
1.21 200-03 OUT 7
03/03/9709:2200:06.2 1507 1507 1 1 -770-536-5363
0.15 300.00 OUT 8
03/03/9711:1200:01.8 2023 2023 1 1 - - -
1.58 402-00 IN 10
03/03/9711:2200:06.5 1629 1629 1 1 - -555-1212
1.25 500.00 OUT 11
03/03/9711:5704:01.3 1714 1714 1 1 011- 42-545-5545234
32 0.69 60000 OUT 12
==============================================================================
Format 5: Microcall for Windows
Data File: MICROCAL.DTA
File Type: Fixed Length (record length = 138 bytes)
Name Start Length Description
-------------- ----- ------ ----------------------------------------------
Date 1 8 Date in MM/DD/YY format
Extension 29 7 Phone extension from which call was made
Phone Number 52 23 Phone number dialed
Location 75 13 City and state of phone number dialed
Amount 88 6 Call amount
Account Number 94 17 Client/Matter number - can convert accounts
with a "." or "-" or no separator between
the client and matter numbers
Example of Microcall format 5 (for Windows):
Note: Each record has been divided into 2 separate sections (a 70 byte
section followed by a 68 byte section) so the records won't be truncated on
the page. Also, the first 3 lines are not part of the MICROCAL.DTA file.
1 2 3 4 5 6 7
1234567890123456789012345678901234567890123456789012345678901234567890
----------------------------------------------------------------------
03/14/9708:5600:05:00 2510 2510 1 1 1-405-294-4218
2.04 OUT 114
03/14/9708:5800:02:00 2515 2515 1 1 - -612-4298
0.00 OUT 117
03/14/9709:0900:05:00 2510 2510 1 1 011- 7-206-0533
11.00 OUT 128
03/14/9709:2200:00:48 1011 1011 1 1 - - -
0.00 IN 139
03/14/9709:2400:07:00 1308 1308 1 1 1-907-447-3354
3.31 OUT 140