|
|
Transfer Fields Builder
Overview
The Transfer Fields Builder is used to define what fields you will be transmitting (exporting) when you select Tasks | Transmit Data... from the menu. It also lets you define the field order and other information depending on whether you choose to transmit to a comma separated values or a fixed length field file in the Options | Data Transfer tab.
The dialog below appears if you selected Comma Delimited File in the Options | Data Transfer tab.
About CSV Files
The
default extension for a comma separated value is CSV although you can use any extension that you want
or the that receiving program requires.
The
first record of a CSV file contain field names separated by commas.
CSV
files use one line for each record and each line ends with a carriage return and line feed.
Fields
are separated by commas. Text fields are surrounded by quotes (""). Date/Time fields are surrounded
by pound (#) symbols.
Example:
Truck, TicketID, NetWt, DateTime
"13432","JX-113",56234,#10/22/2000 10:18:06#
"29953","JX-114",48922,#10/22/2000 10:25:18#
Field Name
This list contains all the available fields of data that can be transferred. Select a field containing data that you want to transfer from the Field Name drop down list.
The list includes a special field called a <NULL> field. This field is nothing more than a blank field and can be used to insert blank fields (commas) into the CSV. This is sometimes helpful if positioning is important to the receiving program.
Alias Name
If the program that will end up processing the CSV file requires a specific field name, you can enter it in the alias field. EZScale will label the field using your alias instead of the native field name in the first line of the CSV file.
After selecting a field and entering an optional alias name, click Add to add the field to the Transfer Fields list. The field will be added ABOVE the selected field.
Note: You are allowed to add a field more than once if needed. It will appear each place in the CSV file. It can be given different alias names at each location if needed.
You can use Replace to change a field setting. Select the field in the Transfer Fields list that you want to change. Then change the Field Name and/or Alias above and click replace.
Fields are output in the order listed in the Transfer Fields list. You can move a field up or down in the list by selecting it and clicking the Move Up or Move Down button respectively.
To remove a field from the Transfer Fields list, select the field that you want to remove and click the Remove button.
Click OK to save your changes or Cancel to ignore your changes and return to the Options | Data Transfer tab.
The dialog below appears if you selected Fixed Length Fields (ASC) in the Options | Data Transfer tab.
About ASC Files
The
default extension for a fixed length fields exported from EZScale is ASC although you can use any extension
that you want or that the receiving program requires.
ASC
files do not contain a header record. The receiving program must "know" the format.
ASC
files use one line for each record and each line ends with a carriage return and line feed.
Fields
are fixed length without any separator or delimiter and there are no special delimiters around different
field types. Again, the receiving program must "know" how to parse the field.
Example:
13432 JX-113 56234 10/22/2000 10:18:06
29953 JX-114 48922 10/22/2000 10:25:18
Field Name
This list contains all the available fields of data that can be transferred. Select a field containing data that you want to transfer from the Field Name drop down list.
The list includes a special field called a <NULL> field. This field is nothing more than a blank field and can be used to insert spaces (white space) into an ASC file.
Field Length or Format
When you first select a Field Name, the Field Length or Format field is set to the default length or field size required for this field based on the size of the field in EZScale's database. This default value is always displayed in just above the field in (brackets).
Length
You can change the field size by simply entering a difference value. If you enter a value smaller than the default, EZScale will truncate results when transmitting data. If you enter a value larger than the default, EZScale will padded.
Text
fields are truncated and padded from the right with spaces.
Numeric
fields are truncated and padded from the left with zeros.
Format
If you need more control over numbers and data/time fields than simply setting the field length, you can use Format Number and Format DateTime strings to set exactly how the output should be formatted. The value will still be padded as needed to ensure the same fixed field length for each record.
A special provision is made for logical (boolean) fields that evaluate to True or False, Yes or No, etc. You can enter the two words or numbers you want returned separated by a forward slash (/).
Example:
True/False will return the word True or the word False
Yes/No will return the word Yes or the word No
-1 / 0 will return the value -1 or the value 0
In each case, the return values will be padded to match the length of the longest word between the two choices.
Add / Replace / Move Up / Move Down / Remove and OK / Cancel
These buttons perform the same function as for a Comma Separated Value file described above.
|
|