Eagle Text File Transfer
Introduction 1
Method I – Diskette Transfer & Expansion 2
Eagle Operator 2
Copying the .S or .8 Files to a Diskette 2
Database Operator 3
Copying the EXPS.EXE or EXPS8.EXE File to the Database Computer 3
Expanding the .S or .8 Files to Text Files on the Database Computer 3
Method II – Expansion & Diskette Transfer 4
Eagle Operator 4
Telephone Communication Method (Level 6 & 7) 5
Eagle Operator 5
Database Operator 5
Telephone Communication Method (Level 8 Only) 6
Eagle Computer 6
Receiving Computer 7
Getting Kermit on the Receiving Computer 7
Running Kermit on the Receiving Computer 8
Exiting Kermit 8
Kermit-MS> Prompt Commands 9
Modem Commands 9
Modem Commands from DOS 9
Modem Indicators 10
Importing Text Files into Excel 12
File Structure General Information 15
File Structure Level 6.xx & 7.xx 16
Customer.S File Structure 16
Mix.S File Structure 17
Order.S File Structure 19
Ticket.S File Structure 21
File Structure Level 8.xx 24
Customer.8 File Structure 24
Delivery.8 File Structure 24
Mix.8 File Structure 25
Order.8 File Structure 27
Perform.8 File Structure 29
Ticket.8 File Structure 30
Truck.8 File Structure 34
Plant.8 File Structure 34
Switches 35
Changes by Revision 36
Introduction
The Eagle Batching Computer stores a large amount of information relating to such things as the plant setup, mixes, orders, tickets, etc. In the version 6.xx and 7.xx software, these files all have a .S extension. Starting with version 8 of the Eagle software, the extension was changed to a .8.
Much of the information in these files can also be used for billing purposes. As such, the Eagle contains a program which will convert the data to a comma delimited ASCII (American Standard Code for Information Interchange) file to allow it to be imported into other database or spreadsheet programs. This is called “Expanding” the files. Once the files have been expanded, they can be transferred from the Eagle to any office PC either by floppy disk or by telephone communications.
EXPS.EXE is the program used to expand the compressed Level 6.xx & 7.xx files into an ASCII format. EXPS8.EXE is a similar program for the Level 8 Eagles. The files that can be expanded by these programs are as follows:
Level 6.xx and Level 7.xx
Order.S (Eagle Order File)
Customer.S (Eagle Customer File)
Mix.S (Eagle Mix File)
Ticket.S (Eagle Ticket File)
Level 8.xx
Order.8 (Eagle Order File)
Customer.8 (Eagle Customer File)
Mix.8 (Eagle Mix Design File)
Ticket.8 (Eagle Ticket File)
Truck.8 (Eagle Truck File)
Level 8.20 and above will also have
Deliveries.8 (Eagle Deliveries File)
Performance.8 (Eagle Performance File)
For level 6.xx systems, CDI can send the customer the EXPS.EXE program on a diskette. On level 7.xx systems, EXPS.EXE resides on the Eagle system "C" disk drive. On level 8.xx systems, EXPS8.EXE resides on the Eagle system "C" disk drive. On level 7 and 8 Eagles, the applicable program can executed using the Eagle computer, or it can be copied to the removable floppy "A" diskette, installed on an office PC, and executed from there. Included in this document are several methods for expanding and transferring the files to an office PC.
Method I – Diskette Transfer & Expansion
In this procedure, the Eagle operator will first copy the applicable files to a diskette. Again, the Level 6 & 7 files will have a .S extension and Level 8 files will have a .8 extension. The files will be expanded by and onto the database computer.
Eagle Operator
Copying the .S or .8 Files to Diskette
• From the main menu on the Eagle press <F4> to open the “Plant Setup menu.”
• Select Disk Maintenance and press “Enter.”
• Insert a blank formatted diskette into the drive.
• Choose which files are to be copied by putting a “Y” in the Copy column. If you do not want to copy a file, put a “N” in the Copy column for that file. To copy all files put a “Y” for the “Copy ALL Files?” question.
• Press <F2> Backup data files to the diskette.
• A dialog box will display on the bottom of your screen telling you how many disks are required to complete this operation.
• Press “Y” to continue or “N” to cancel.
When you press “Y” the Eagle will copy the files selected. The monitor will show the process as it progresses in a format similar to the example below.
Copying the files
Customer.8 Data Floppy
When the process is complete, the Eagle will go back to the Disk Maintenance menu.
The .S or .8 files will now be on the diskette. Remove the diskette from the drive to give to the operator of the Database PC.
Database Operator
Copying the EXPS.EXE or EXPS8.EXE File to the Database Computer
Before you expand the files you must have the EXPS.EXE or EXPS8.EXE file on the database PC. The procedure to copy the file, which only needs to be done once, is listed in the following steps. These steps will create a subdirectory on your database computer called util, and will copy the file into that subdirectory. If a different subdirectory name is desired, replace the util name with any desired name.
To copy the file from the Eagle
• Insert a diskette into the disk drive on the Eagle
• Type “Ctrl” “E” to exit to the DOS prompt.
• Type cd\util and press “Enter”. The DOS prompt should change to C:\Util>.
• Type copy exps.* a: (level 7) or copy exps8.* a: (level 8) and press “Enter”. This will copy the file to the diskette so that it can be installed on the Database computer.
To copy the file to the database computer
• Insert the diskette with the EXPS.EXE or EXPS8.EXE into the drive on the database computer.
• At the root directory DOS prompt type (C:/>) type md util and press “Enter”.
• Type cd\util and press “Enter”. The DOS prompt should change to C:\Util>.
• Type copy a:exps.* (level 7) or copy a:exps8.* (level 8) and press “Enter”. This will copy the file from the diskette to the Database computer. Once the file is on the database computer you are ready to expand the .8 files.
Expanding the .S or .8 Files to Text Files on the Database Computer
• Insert the diskette containing the .S or .8 files into your “A” drive.
• The DOS prompt should be C:\util>. If not, type cd\util and press “Enter” to change to the util subdirectory.
• Type exps a: or exps8 a: and press “Enter”. This will expand the files on the diskette and store them in the util subdirectory on the database computer.
Method II – Expansion & Diskette Transfer
In this method. The .S or .8 files will be expanded by the Eagle and onto a diskette to give to the database operator.
Eagle Operator
• On the Eagle Type “Ctrl” “E” to exit to the DOS prompt.
• Start the expansion of the files by typing either exps d: a: or exps8 c:\eagle8 a: at the DOS prompt and pressing ‘Enter.’ The monitor should display information similar to that depicted below:
.8 File Expansion Utility, Version 08.28
Copyright 1996 Command Data Inc.
Expanding: C:\eagle8\CUSTOMER.8
Expanding: C:\eagle8\DELIVERY.8
Expanding: C:\eagle8\MIX.8
Expanding: C:\eagle8\ORDER.8
Expanding: C:\eagle8\PERFORM.8
Expanding: C:\eagle8\TICKET.8
Expanding: C:\eagle8\TRUCK.8
Expanding: C:\eagle8\PLANT.8
C:\ >
When the monitor returns the DOS prompt, the .S or .8 files will have been expanded onto the 3.5” diskette. These files will have a .TXT extension and be in a form that can be imported into a database. To restart the Eagle program, type “GO” at the DOS prompt and pressing “Enter”, or turn the power off and then back on.
Telephone Communication Method (Level 6.xx & 7.xx ONLY)
In this procedure, the Eagle will expand the .S files and store them on a diskette drive for retrieval by the database computer. This procedure utilizes modems at both the Eagle and the database computer to transfer the expanded files to the database computer.
Eagle Operator
• On the Eagle Type “Ctrl” “E” to exit to the DOS prompt.
• Upon display of the screen prompt "PSI/Command Data>", insert a formatted diskette into the Eagle drive and type Standby.bat, then press “Enter”. The program automatically expands the .S files to the ASCII format and transfers the files to the floppy disk.
• The "Standby.bat" program will then start the Kermit program, an industry standard communications protocol program, in the Eagle system.
• The Kermit program puts the Eagle in a "Listening Mode".
• The telephone modem connected to the Eagle will be set to the "Auto-Answer" mode.
Database Operator
• The Kermit program also must be on the host database computer. Command Data in Dallas can supply this program to the customer (on diskette) if necessary.
Telephone Communication Method (Level 8.xx ONLY)
Eagle Computer
• Connect the serial cable from COM1 (COM2) on the Eagle to the modem.
• Attach the phone cord from the modem to a direct phone line connection (no extensions).
• Plug in the modem and turn on the power.
• From the Eagle Main menu press <F4> to go to the Plant Setup menu.
• From the Plant Setup menu select Remote Configuration.
• Press <F5> and under Kermit set the port to COM1 (COM2) and the baud to the desired value (see the note below). Press <F5> to accept these settings.
NOTE:
If both Kermit and Batchview are available, it is reccommended that the baud rate be set the same for both options. Common baud rate settings are 300, 1200, 2400, 4800, and 9600. The higher the setting, the faster the data transfer. Kermit, however, is limited to a maximum baud rate of 9600. Kermit can also use only COM1 or COM2 for it’s communications port.
• Once the settings are entered and accepted, press <F2> for Kermit. The Eagle screen should resemble the example below.
NOTE:
Do not use your back up disk, use a different disk and label it Kermit.
• Once the disk is in the disk drive, press any key to continue. The Eagle will automatically expand the .8 files to the ASCII format and transfer the files to the floppy disk. The Eagle monitor will show the progress of this process as the files are expanded. When the process has completed, the Eagle screen will change to the Server Mode.
Server Mode
Now the Eagle system is ready for the receiving computer to make the call.
Receiving Computer
NOTE:
Kermit must be installed on the Receiving Computer. If Kermit is not on the receiving computer, follow the steps below to copy it from the Eagle. This procedure copies the necessary files into the util subdirectory, and this is the subdirectory specified throughout the remainder of this method. If a different subdirectory name is desired, simply substitute the desired directory name for util.
Getting Kermit on the Receiving Computer
To copy the file from the Eagle
• Type “Ctrl” “E” to exit to the DOS prompt.
• At the DOS prompt, type cd\util and press the “Enter” key. The DOS prompt should change to C:\Util>.
• Insert a blank diskette into the Eagle diskette drive and type copy kermit.exe a: and press the “Enter” key. The computer will copy the file to the diskette and then return to the DOS prompt.
• To restart the Eagle, type go at the DOS prompt.
To copy the file to the receiving computer
Kermit is a DOS application. As such, the first step on a Windows based system is to click “Start”, “Programs”, and “MS Dos Prompt”. This will allow the use of DOS commands. The following steps can then be used to copy the Kermit program to the receiving computer.
• At the DOS prompt, type cd\ and press the “Enter” key. This should change the DOS prompt to C:\>.
• Type md util and press the “Enter” key to make a subdirectory called Util.
• Type cd util and press the “Enter” key to change to this new dubdirectory. The DOS prompt should now read C:\UTIL>.
• Type copy a:kermit.exe and press the “Enter” key. This will copy the Kermit program into the util subdirectory on the receiving computer.
• To return to Windows, type exit and press the “Enter” key.
Running Kermit on the Receiving Computer
• Click “Start”, “Programs”, “MS DOS Prompt” to open a DOS window.
• At the DOS prompt, type cd\util and press the “Enter” key. This should change the DOS prompt to read C:\util>.
• Type Kermit and press the “Enter” key. The screen prompt will change to
• Kermit - MS>
• If the modem is connected to COM2, type SET PORT 2 and press the “Enter” key.
• Type SET BAUD xxxx (this must match the Eagle) and press the “Enter” key.
• Type C to connect to the modem.
• The screen will change and will no longer have the Kermit-MS> prompt.
NOTE: On the bottom of your screen you will see the following:
ESC - chr: ^] help: ^}? Port:1 speed:2400 parity: none echo: rem VT102….
NOTE: ^ = Ctrl key.
• Type ATDT 1-xxx-xxx-xxxx (phone number of the Eagle being called) and press the “Enter” key. The dialing process will begin. When the connection is made, the screen should display a message that the connection is made.
NOTE: If you are calling out of the Command Dallas office, it will be necessary to add ,,,,,xxxxx to the end of this string where xxxxx is the long distance access code.
• Press “Ctrl” and type ] (the right bracket).
• Type C
• Screen will change to show the prompt Kermit -MS>
• Type Get A:*.* and press the “Enter” key. The screen will change to resemble the example below.
File name: Customer.TXT
Kbytes transferred: 1
Receiving: In process
Number of packets: 42
Number of retries: 0
Last error: None
Last Warning Renaming file to Customer.TXT
Exiting Kermit
When the process is complete the screen will again display the prompt Kermit -MS>.
• Type BYE and press the “Enter” key. This will let the Eagle know that the Kermit session is over. The Eagle should automatically restart.
• This will probably take the receiving computer back to the C:Util> prompt also. If it does, type kermit and press the “Enter” key to get back to the Kermit-MS> prompt. It will be necessary to type SET PORT 2 if the modem is connected to COM2.
• Type HANGUP and press the “Enter” key to disconnect the phone line.
• Type EXIT and press the “Enter” key to exit Kermit and return to the DOS prompt.
• Type EXIT and press the “Enter” key again to restart Windows.
MS-Kermit> Prompt Commands
? Gives a list of Kermit Commands.
Bye Terminates the Server Mode on the Eagle and restarts the Eagle software
Connect or C Puts the Kermit program into the modem command screen.
Get Starts the file retrieval process.
Hangup Disconnects the modem. (Places the modem back on-hook)
Quit Exits the Kermit program and returns the user to DOS.
Status List the Communications parameters for the modem.
Set Baud xxxx Sets the baud rate. Limited to a maximum of 9600.
Set Port x Sets the Comm Port to 1 or 2.
Modem Commands
ATDT xxx-xxx Places the modem in a call mode and dials the number.
CTRL ] Places the cursor off the modem command line (must be used prior to exiting).
C Closes the modem command screen and returns to the MS-Kermit> prompt.
ATS0? Displays the modem’s Auto Answer setting.
ATS0=1 Sets the modem’s Auto Answer to pick up after the first ring.
AT&W0 Saves the S parameters as defaults.
Modem Commands from DOS
Modem commands can be sent from any computer to set certain parameters in a modem; for example, Auto Answer. There are programs that make it much easier to access and monitor the modem but the modem can be accessed from DOS by using echo commands.
The following are a few examples that may be helpful in the field to verify that the modems are responding to the computer, etc. Please be aware that it may be necessary to change the com1 to a com2.
Echo ATS0=1>com1 Sets the modem to auto answer after the first ring.
Echo ATS=0>com1 Disables auto answer.
Echo AT&W0>com1 Saves the S parameters as defaults.
Echo ATH1>com1 Takes the modem off hook. You should hear a dial tone.
Echo ATH0>com1 Hangs up the modem.
Echo ATDT 262-7160>com1 This will go off hook and dial the phone number.
Echo ATL3>com1 Changes volume (Loudness).
Modem Indicators
Importing Text files into Excel
Note:
What is done with the data from this point is the customer’s responsibility working with an in-house MIS employee or outside programming consultant. The following is an example of how to import expanded files into Excel. You may use the database of your choice.
• Insert the floppy disk with the transferred files into the “A” drive of the computer to be used to open the data.
• Open the Excel program
• File/Open
• Select “A” drive
For this example the customer files will be opened.
• Click on the down arrow by “Files of type:” and select “Text Files (*.prn., *.txt., *.csv)”
• Click on “Customer.txt”
• Click on “Open”
The Import Wizard dialog box will open as in the example below:
• Click on “Delimited” for the file type that best describes the data.
• Make sure the “File Origin” is set for “Window (ANSI)”
• Click on “Next”
The Step 2 dialog box will open. In this box
• For the Delimiters select “Comma”
• Be sure that there are quotation marks in the Text Qualifier box.
• Click on “Next”
The Step 3 dialog box will open
In this box you may chose to skip or not import the columns that have data that is not needed. By following the tables for Level 6.xx to 8.xx in at the end of this document you will be able to determine the names or headings of the columns. This is done by:
• Select the column to be skipped and click on “Do Not Import Column (Skip)”
• When this is selected the heading for the column selected will change to Skip
• When all the columns that are not needed have been marked Skip click on “Finish”
• The excel spreadsheet will be displayed.
• Insert a row above the top line of text and enter the heading names.
• Remember to follow the table in the Eagle Text File Transfer document for Customers. Noting the columns that have been skipped.
Below is an example of a spread sheet in Excel using Customers.
Customer ID Stamp Is_cod Billing 1 Billing 2 Billing 3 Telephone
O&D Thu Mar 01 1990 0.77083333 N Command Data
COD Thu Mar 12 1998 0.54875 Y COD Customer 555-1212
123413 Thu Apr 09 1998 0.58696759 N
1 Wed Apr 15 1998 0.56667824 Y COD ORDERS
2 Wed Apr 15 1998 0.56731481 N JOHNSON 1414 WILL AVE Dallas, TX 75403 972-262-2693
4 Wed Apr 15 1998 0.56795138 N CUSTOMER # 4 3304 Brisco Greenville, SC 66094
5 Thu Apr 09 1998 0.64163194 N
6 Thu Apr 09 1998 0.64178240 N
3 Wed Apr 15 1998 0.56762731 N BURLINGTON SHIPYARD
162 Mon Jun 15 1998 0.37601851 N JOE'S CONCRETE 6543 EAST GATE Ft. Worth, TX 77700 800-777-8888
File Structure General Information
The EXPS.EXE program is an MS-DOS utility used to expand the Eagle Level 6.xx & 7.xx series CUSTOMER.S, MIX.S, ORDER.S, and TICKET.S files to the ASCII data format. The EXPS8.EXE is an MS-DOS utility used to expand the Eagle Level 8.xx series CUSTOMER.8, MIX.8, ORDER.8, TICKET.8, AND TRUCK.8 files to the ASCII data format. The file format used is the PARADOX database file format in all of the cases above.
The EXPS.EXE program uses two command line parameters. The first is the input path of the .S, (or .8) files, and the second is the output path of the .TXT files. If the output path is omitted, it will use the current directory for the output path. If both parameters are omitted, it will use the current directory for both input and output paths. Be sure that the PLANT.S file resides in the same directory as the Eagle's .S, (or .8) files, as the EXPS.EXE, (or EXPS8.EXE), will read this file for necessary information. Upon execution, EXPS.EXE , (or EXPS8.EXE), will attempt to expand all of the Eagle's .S , (or .8) files.
The Paradox file format recognizes two types of fields: (1) Alphanumeric text fields, and (2) Numeric character fields. Each record in the file is delimited by a carriage return and line feed combination. For the purposes of this discussion alphanumeric fields will be referred to as string fields.
String fields in the Paradox file format are delimited by a comma character and a quotation mark character at both the beginning and ending of the field.
Example: ,"1/2" Rock",
If however, a string field is the first field in a record it will begin with only a quotation mark. If it is the last field in a record, it will end with a quotation mark and a carriage return - the carriage return being the record separator.
Numeric fields are delimited by only comma characters at both ends of the field.
Example: ,12000,
If however, a numeric field is the first field in a record it will begin with the first ascii-numeric character of the field. If it is the last field in a record, it will end with a carriage return instead of a comma.
The following pages are a brief description of the .S and the .8 file structures. Please note that the time stamp portion of the structures are divided into two strings as:
,"MON MAY 22 1989", "13:22:33",
File Structure Level 6.xx & 7.xx
Customer.S File Structure
(Level 6.xx & 7.xx ONLY)
Field Type Number of Characters
record_code string 2, (always "Cr")
customer_id string 8
stamp string (s) 23, (2 strings, 15 + 8)
is_cod string 1, (“Y” or “N”)
billing1 string 30
billing2 string 30
billing3 string 30
telephone string 12
notes1 string 16
notes2 string 16
Mix.S File Structure
(Level 6.xx & 7.xx ONLY)
Field Type Number of Characters
record_code string 2, (always "MR")
mix_id string 8
stamp string 23, (2 strings, 15 + 8)
description string 24
load_size numeric 5, (4 + dp 12.34)
mix_time numeric 5, (# of seconds)
agg1_name string 8
agg1_amount numeric 9
agg1_units string 3
agg2_name string 8
agg2_amount numeric 9
agg2_units string 3
agg3_name string 8
agg3_amount numeric 9
agg3_units string 3
agg4_name string 8
agg4_amount numeric 9
agg4_units string 3
agg5_name string 8
agg5_amount numeric 9
agg5_units string 3
cem1_name string 8
cem1_amount numeric 9
cem1_units string 3
cem2_name string 8
cem2_amount numeric 9
cem2_units string 3
cem3_name string 8
cem3_amount numeric 9
cem3_units string 3
admix1_name string 8
admix1_amount numeric 9
Mix.S File Structure cont’d
(Level 6.xx & 7.xx ONLY)
Field Type Number of Characters
admix1_units string 3
admix2_name string 8
admix2_amount numeric 9
admix2_units string 3
admix3_name string 8
admix3_amount numeric 9
admix3_units string 3
admix4_name string 8
admix4_amount numeric 9
admix4_units string 3
admix5_name string 8
admix5_amount numeric 9
admix5_units string 3
admix6_name string 8
admix6_amount numeric 9
admix6_units string 3
water1_name string 8
water1_amount numeric 9
water1_units string 3
water2_name string 8
water2_amount numeric 9
water2_units string 3
Order.S File Structure
(Level 6.xx & 7.xx ONLY)
Field Type Number of Characters
record_code string 2, (always "Or")
order_id string 8
stamp string 23, (2 strings, 15 + 8)
customer_id string 8
mix_id string 8
are_extras string 1, ("Y" or "N")
deliver1 string 24
deliver2 string 24
instruct1 string 24
instruct2 string 24
qty_ordered numeric 9, (6 + dp + 2)
qty_delivered numeric 9, (6 + dp + 2)
num_of_loads numeric 5
start_time string 23, (2 strings, 15 + 8)
spacing_time numeric 5, (# of minutes)
price numeric 9, (6 + dp + 2)
tax numeric 9, (5 + dp + 3)
user1 string 8
user2 string 8
user3 string 8
user4 string 8
user5 string 8
user6 string 8
user7 string 8
user8 string 8
user9 string 16
user10 string 16
extra_id1 string 8
extra_qty1 numeric 9, (6 + dp + 2)
extra_price1 numeric 9, (6 + dp + 2)
extra_tax1 numeric 9, (5 + dp + 3)
extra_id2 string 8
Order.S File Structure cont’d
(Level 6.xx & 7.xx ONLY)
Field Type Number of Characters
extra_qty2 numeric 9, (6 + dp + 2)
extra_price2 numeric 9, (6 + dp + 2)
extra_tax2 numeric 9, (5 + dp + 3)
extra_id3 string 8
extra_qty3 numeric 9, (6 + dp + 2)
extra_price3 numeric 9, (6 + dp + 2)
extra_tax3 numeric 9, (5 + dp + 3)
extra_id4 string 8
extra_qty4 numeric 9, (6 + dp + 2)
extra_price4 numeric 9, (6 + dp + 2)
extra_tax4 numeric 9, (6 + dp + 2)
extra_id5 string 8
extra_qty5 numeric 9, (6 + dp + 2)
extra_price5 numeric 9, (6 + dp + 2)
extra_tax5 numeric 9, (6 + dp + 2)
extra_id6 string 8
extra_qty6 numeric 9, (6 + dp + 2)
extra_price6 numeric 9, (6 + dp + 2)
extra_tax6 numeric 9, (6 + dp + 2)
load_size numeric 5, (2 + dp + 2)
is_cod string 1
sobtotal_dollars numeric 9, (6 + dp + 2)
subtotal_tax numeric 9, (6 + dp + 2)
total_dollars numeric 9, (6 + dp + 2)
Ticket.S File Structure
(Level 6.xx & 7.xx ONLY)
Field Type No. of Characters
record_code string 2, (always "TR")
ticket_id string 8
stamp string(s) 23
order_id string 8
customer_id string 8
mix_id string 8
load_size numeric 5, (2 + dp + 2)
resold numeric 5, (2 + dp + 2)
is_cod string 1, ("Y" or "N")
time_batched string(s) 23, (2 strings 15 + 8)
time_due string(s) 23, (2 strings 15 + 8)
truck_number numeric 5
unit_price numeric 9, (6 + dp + 2)
tax numeric 9, (6 + dp + 2)
agg1_name string 8
agg1_amount numeric 9
agg1_units string 3
agg2_name string 8
agg2_amount numeric 9
agg2_units string 3
agg3_name string 8
agg3_amount numeric 9
agg3_units string 3
agg4_name string 8
agg4_amount numeric 9
agg4_units string 3
agg5_name string 8
agg5_amount numeric 9
agg5_units string 3
cem1_name string 8
cem1_amount numeric 9
cem1_units string 3
Ticket.S File Structure cont’d
(Level 6.xx & 7.xx ONLY)
Field Type No. of Characters
cem2_name string 8
cem2_amount numeric 9
cem2_units string 3
cem3_name string 8
cem3_amount numeric 9
cem3_units string 3
admix1_name string 8
admix1_amount numeric 9
admix1_units string 3
admix2_name string 8
admix2_amount numeric 9
admix2_units string 3
admix3_name string 8
admix3_amount numeric 9
admix3_units string 3
admix4_name string 8
admix4_amount numeric 9
admix4_units string 3
admix5_name string 8
admix5_amount numeric 9
admix5_units string 3
admix6_name string 8
admix6_amount numeric 9
admix6_units string 3
water1_name string 8
water1_amount numeric 9
water1_units string 3
water2_name string 8
water2_amount numeric 9
water2_units string 3
extra_id1 string 8
extra_qty1 numeric 9
Ticket.S File Structure cont’d
(Level 6.xx & 7.xx ONLY)
Field Type No. of Characters
extra_price1 numeric 9
extra_tax1 numeric 9
extra_id2 string 8
extra_qty2 numeric 9
extra_price2 numeric 9
extra_tax2 numeric 9
extra_id3 string 8
extra_qty3 numeric 9
extra_price3 numeric 9
extra_tax3 numeric 9
extra_id4 string 8
extra_qty4 numeric 9
extra_price numeric 9
extra_tax4 numeric 9
extra_id5 string 8
extra_qty5 numeric 9
extra_price5 numeric 9
extra_tax5 numeric 9
extra_id6 string 8
extra_qty6 numeric 9
extra_price6 numeric 9
extra_tax6 numeric 9
is_modified string 1
is_voided string 1
percent_moist1 numeric 5
percent_moist2 numeric 5
percent_moist3 numeric 5
percent_moist4 numeric 5
percent_moist5 numeric 5
File Structure Level 8.xx
Customer.8 File Structure
(Level 8.xx ONLY)
Field Type Number of Characters
record_code string 2, (always “Cr” optional)
customer_id string 8
stamp string(s) 23, (2 strings, 15, 8)
is_cod string 1, (“Y” or “N”)
billing1 string 30
billing2 string 30
billing3 string 30
telephone string 12
notes1 string 16
notes2 string 16
Delivery.8 File Structure
(Level 8.20 & above ONLY)
Field Type Number of Characters
record_code string 2, (always “Dr” optional)
material string 8
qty_rvcd Numeric 9
units string 4
supplier string 20
ticket_number string 8
stamp string 23, (2 strings 15,8)
truck string 20
hauler string 20
is_printed string 1, (“Y” or “N”)
is_com_sent string 1, (“Y” or “N”)
Mix.8 File Structure
(Level 8.xx ONLY)
Field Type Number of Characters
recoed_code string 2, (always “Mr” optional)
mix_id string 8
stamp string (s) 23, (2 strings, 15, 8)
description string 24
load_size numeric 5, (4 + dp 12.34)
mix_time numeric 5, (# of seconds)
agg1_name string 8
agg1_amount numeric 9
agg1_units string 3
agg2_name string 8
agg2_amount numeric 9
agg2_units string 3
agg3_name string 8
agg3_amount numeric 9
agg3_units string 3
agg4_name string 8
agg4_amount numeric 9
agg4_units string 3
agg5_name string 8
agg5_amount numeric 9
agg5_units string 3
cem1_name string 8
cem1_amount numeric 9
cem1_units string 3
cem2_name string 8
cem2_amount numeric 9
cem2_units string 3
cem3_name string 8
cem3_amount numeric 9
cem3_units string 3
admix1_name string 8
admix1_amount numeric 9
admix1_units string 3
Mix.8 File Structure cont’d
(Level 8.xx ONLY)
Field Type Number of Characters
admix2_name string 8
admix2_amount numeric 9
admix2_units string 3
admix3_name string 8
admix3_amount numeric 9
admix3_units string 3
admix4_name string 8
admix4_amount numeric 9
admix4_units string 3
admix5_name string 8
admix5_amount numeric 9
admix5_units string 3
admix6_name string 8
admix6_amount numeric 9
admix6_units string 3
water1_name string 8
water1_amount numeric 9
water1_units string 3
water2_name string 8
water2_amount numeric 9
water2_units string 3
percent_air numeric 5, (4 + dp 12.34)
slump_target numeric 5
dry_max_size numeric 5, (4 + dp 12.34)
async_max_size numeric 5, (4 + dp 12.34)
agg_moist_ref numeric 1, (0=SSD, 1=WET, 2=OVEN_DRY
spare numeric 9, Reserved
is_metric string 1, (Y = Metric, N = Customary)
Order.8 File Structure
(Level 8.xx ONLY)
Field Type Number of Characters
record_code string 1, (always “Or” optional)
order_id string 8
stamp string (s) 23, (2 strings, 15, 8)
customer_id string 8
mix_id string 8
are_extras string 1, "Y" or "N"
deliver1 string 24
deliver2 string 24
instruct1 string 24
instruct2 string 24
qty_ordered numeric 9, (8 + dp, 123456.78)
qty_delivered numeric 9, (8 + dp, 123456.78)
num_of_loads numeric 5
start_time string (s) 23, (2 strings, 15, 8)
spacing_time numeric 5, (# of minutes)
price numeric 9, (8 + dp, 123456.78)
tax numeric 9, (8 + dp, 12345.678)
user1 string 8
user2 string 8
user3 string 8
user4 string 8
user5 string 8
user6 string 8
user7 string 8
user8 string 8
user9 string 16
user10 string 16
extra_id1 string 8
extra_qty1 numeric 9, (8 + dp, 123456.78)
extra_price1 numeric 9, (8 + dp, 123456.78)
extra_tax1 numeric 9, (8 + dp, 12345.678)
extra_id2 string 8
extra_qty2 numeric 9, (8 + dp, 123456.78)
Order.8 File Structure cont’d
(Level 8.xx ONLY)
Field Type Number of Characters
extra_price2 numeric 9, (8 + dp, 123456.78)
extra_tax2 numeric 9, (8 + dp, 12345.678)
extra_id3 string 8
extra_qty3 numeric 9, (8 + dp, 123456.78)
extra_price3 numeric 9, (8 + dp, 123456.78)
extra_tax3 numeric 9, (8 + dp, 12345.678)
extra_id4 string 8
extra_qty4 numeric 9, (8 + dp, 123456.78)
extra_price4 numeric 9, (8 + dp, 123456.78)
extra_tax4 numeric 9, (8 + dp, 12345.678)
extra_id5 string 8
extra_qty5 numeric 9, (8 + dp, 123456.78)
extra_price5 numeric 9, (8 + dp, 123456.78)
extra_tax5 numeric 9, (8 + dp, 12345.678)
extra_id6 string 8
extra_qty6 numeric 9, (8 + dp, 123456.78)
extra_price6 numeric 9, (8 + dp, 123456.78)
extra_tax6 numeric 9, (8 + dp, 12345.678)
load_size numeric 5, (4 + dp, 12.34)
is_cod string 1, (“Y” or “N”)
sobtotal_dollars numeric 9, (8 + dp, 123456.78)
subtotal_tax numeric 9, (8 + dp, 123456.78)
total_dollars numeric 9, (8 + dp, 123456.78)
is_remem_amx_trims string 1, (“Y” or “N”)
amx_percentage1 numeric 5
amx_percentage2 numeric 5
amx_percentage3 numeric 5
amx_percentage4 numeric 5
amx_percentage5 numeric 5
amx_percentage6 numeric 5
amx_percentage7 numeric 5
amx_percentage8 numeric 5
Order.8 File Structure cont’d
(Level 8.xx ONLY)
Field Type Number of Characters
amx_percentage9 numeric 5
amx_percentage10 numeric 5
amx_percentage11 numeric 5
amx_percentage12 numeric 5
is_metric string 1, (Y = Metric, N = Customary)
Perform.8 File Structure
(Level 8.20 & above ONLY)
Field Type Number of Characters
record_code string 2, (always “Pr” optional)
ticket_id string 8
mix_id string 8
batch_number numeric 9
drop_number numeric 5
load_size numeric 5, (4 + dp, 12.34)
is_metric string 1, (Y = Metric, N = Customary)
reserved string 1, (always N)
batch_start string(s) 23, (2 strings 15, 8, Load Size)
start_stamp string(s) 23, (2 strings 15, 8, Matl start)
start_of_drop numeric 9, (master start tick in 100ths)
material string 8
target numeric 9
actual numeric 9
status string 6, (Under, Over, Done, Manual)
gate_open numeric 9, (100ths of sec. from Start)
start_of_flow numeric 9, (100ths of sec. from Start)
low_flow numeric 5, (elapsed 100ths of sec. from 0)
gate_close numeric 9, (100ths of sec. from Start)
jogs numeric 5, (total number of jogs)
end_of_drop numeric 9, (100ths of sec. from Start)
start_of_disc numeric 9, (100ths of sec. from Start)
end_of_disc numeric 9, (100ths of sec. from Start)
start_tare numeric 9, (scale weight @ start of disc)
end_tare numeric 9, (scale weight 15, 8, end time)
end_stamp numeric 23, (2 strings 15, 8, end time)
Ticket.8 File Structure
(Level 8.xx ONLY)
Field Type No. of Characters
record_code string 1, (always “Tr” optional)
ticket_id string 8
stamp string (s) 23, (2 strings 15, 8, End Time),
order_id string 8
customer_id string 8
mix_id string 8
load_size numeric 5, (4 + dp, 12.34)
resold numeric 5, (4 + dp, 12.34)
is_cod string 1, "Y" or "N"
time_batched string (s) 23, (2 strings 15, 8, Start Time)
time_due string (s) 23, (2 strings 15, 8)
truck_number numeric 5
unit_price numeric 9, (8 + dp, 123456.78)
tax numeric 9, (8 + dp, 12345.678)
agg1_name string 8
agg1_amount numeric 9
agg1_units string 3
agg2_name string 8
agg2_amount numeric 9
agg2_units string 3
agg3_name string 8
agg3_amount numeric 9
agg3_units string 3
agg4_name string 8
agg4_amount numeric 9
agg4_units string 3
agg5_name string 8
agg5_amount numeric 9
agg5_units string 3
cem1_name string 8
cem1_amount numeric 9
cem1_units string 3
cem2_name string 8
Ticket.8 File Structure cont’d
(Level 8.xx ONLY)
Field Type No. of Characters
cem2_amount numeric 9
cem2_units string 3
cem3_name string 8
cem3_amount numeric 9
cem3_units string 3
admix1_name string 8
admix1_amount numeric 9
admix1_units string 3
admix2_name string 8
admix2_amount numeric 9
admix2_units string 3
admix3_name string 8
admix3_amount numeric 9
admix3_units string 3
admix4_name string 8
admix4_amount numeric 9
admix4_units string 3
admix5_name string 8
admix5_amount numeric 9
admix5_units string 3
admix6_name string 8
admix6_amount numeric 9
admix6_units string 3
water1_name string 8
water1_amount numeric 9
water1_units string 3
water2_name string 8
water2_amount numeric 9
water2_units string 3
extra_id1 string 8
extra_qty1 numeric 9, (8 + dp, 123456.78)
extra_price1 numeric 9, (8 + dp, 123456.78)
Ticket.8 File Structure cont’d
(Level 8.xx ONLY)
Field Type No. of Characters
extra_tax1 numeric 9, (8 + dp, 12345.678)
extra_id2 string 8
extra_qty2 numeric 9, (8 + dp, 123456.78)
extra_price2 numeric 9, (8 + dp, 123456.78)
extra_tax2 numeric 9, (8 + dp, 12345.678)
extra_id3 string 8
extra_qty3 numeric 9, (8 + dp, 123456.78)
extra_price3 numeric 9, (8 + dp, 123456.78)
extra_tax3 numeric 9, (8 + dp, 12345.678)
extra_id4 string 8
extra_qty4 numeric 9, (8 + dp, 123456.78)
extra_price numeric 9, (8 + dp, 123456.78)
extra_tax4 numeric 9, (8 + dp, 12345.678)
extra_id5 string 8
extra_qty5 numeric 9, (8 + dp, 123456.78)
extra_price5 numeric 9, (8 + dp, 123456.78)
extra_tax5 numeric 9, (8 + dp, 12345.678)
extra_id6 string 8
extra_qty6 numeric 9, (8 + dp, 123456.78)
extra_price6 numeric 9, (8 + dp, 123456.78)
extra_tax6 numeric 9, (8 + dp, 12345.678)
is_modified string 1
is_voided string 1
percent_moist1 numeric 5, (4 + dp, 123.4, signed)
percent_moist2 numeric 5, (4 + dp, 123.4, signed)
percent_moist3 numeric 5, (4 + dp, 123.4, signed)
percent_moist4 numeric 5, (4 + dp, 123.4, signed)
percent_moist5 numeric 5, (4 + dp, 123.4, signed)
driver_id string 8
agg1_target numeric 9
agg2_target numeric 9
agg3_target numeric 9
Ticket.8 File Structure cont’d
(Level 8.xx ONLY)
Field Type No. of Characters
agg4_target numeric 9
agg5_target numeric 9
cem1_target numeric 9
cem2_target numeric 9
cem3_target numeric 9
admix1_target numeric 9
admix2_target numeric 9
admix3_target numeric 9
admix4_target numeric 9
admix5_target numeric 9
admix6_target numeric 9
water1_target numeric 9
water2_target numeric 9
is_local string 1, (“Y” or “N”)
total_water numeric 9, (follows plant’s water units)
reference_id string 8, (contents of Eagle field # 149)
type_code string 2, (contents of Eagle field # 408)
is_metric string 1, (Y = Metric, N = Customary)
Truck.8 File Structure
(Level 8.xx ONLY)
Field Type Number of Characters
record_code string 2, (always “Kr” optional)
truck_id string 8
number numeric 5
driver string 32
max_load numeric 5, (12.34)
loading_rate numeric 5, (Dry Rate)
paste_loading_rate numeric 5, (Matrix Master Rate)
is_to_batch string 1, (“Y” or “N”)
is_washed string 1, (“Y” or “N”)
washed_stamp string (s) 23, (2 strings 15, 8, Last Wash Time)
h2o_in_truck numeric 5, (in metered or weighed units)
amx_in_truck numeric 5, (in metered or weighed units)
mix_in_truck string 8, (mix_id of last load)
resold_mixes numeric 5, (total # of resold loads)
resold_yards numeric 9, (123456.78, total resold yards)
resold_stamp string (s) 23, (2 strings 15, 8, Last Res. Time)
bbk_amx_id_in_trk string 3, (admix ID if Batchbook enabled)
Plant.8 File Structure
(Level 8.xx OLNY)
Field Type Number of Characters
record_code string 2, (always “Pr” optional)
title string 24
plant string 24
material_name string 8
is_used string 1
sp_grav numeric 5
material_source string 15
on_hand numeric 9
short_term_used numeric 9
long_term_used numeric 9
deviation numeric 5
long_term_received numeric 9
percent_moisture numeric 5
material_alias string 8
eagle_revision string 5 (xx.xx)
Switches
The /r switch:
This will cause EXPS8 to suppress record codes. By default, EXPS8 will put record codes in each record of each file.
The /f switch:
This will cause EXPS8 to change time stamp format to “05/22/89”, “13:22:33.”
By default , the time stamp string is: “MON MAY 22 1998”, “13:22:33”.
The /d switch
This will cause EXPS8 to remove all Comma, Quotation Mark, Carriage Return, and Line Feed delimiter characters.
The /t switch:
This will cause EXPS8 to replace the Alpha-Numeric String field delimiter, normally a Quotation Mark character (“), with the character immediately following the “/t”, such as: /t˜ would yield a delimited String field as: ,˜1/2” ROCK˜.
Changes by Revision
Version 8.00 January 31. 1995
1. Derived from original EXPS Version 2.07
2. Removed RAVEN support.
3. Add /t command line switch.
Version 8.01 March 3, 1995
1. Added /r command line switch.
Version 8.02 April 24, 1995
1. Added /f command line switch.
Version 8.03 May 5, 1995
1. Added support for Metric/Customary dual units.
Version 8.20 February 14, 1996
1. Added support for expanding DELIVERY.8
2. Added support for expanding PERFORM.8
Version 8.21 February 28, 1996
1. Implemented Alias and Revision fields for PLANT.TXT file.
2. Added Batchbook Admix Id in Truck field to TRUCK.TXT file.
Version 8.22 April 19, 1996
1. Added detection for “seconds since Jan 01 1970” stamps of -1 (they now show as Jan 01 1980)
Version 8.24 June 27, 1996
1. Fixed the problem with the Material Source Field in the PLANT.TXT file.
Version 8.28 August 15, 1996
1. The format of admix (1-6) _amount and water(1-2)_amount fields in the MIX.TXT has been changed. The values in these fields will be same as the values in the Mix Design Menu.