The Data Usage file Fixed data is defined and directly used from the Usage file as
character fields written to a card; the fields cannot contain characters not allowed for the
defined track format. In other words, tracks written with five bits per character can use only
Appendix B, Table 2 characters; likewise, tracks written with seven bits per character can use
the character set in Appendix B, Table 1.
Variable data written to the cards is specified by two characters that define the Data
Columns in the Database file. The two characters have a fixed format. The first
character is a lower case “f” followed by a second “Column” letter (a through z). The
variable names correspond to the column letter in an Excel
csv
file. The Data Column
variable data and the Usage file fixed track data can be mixed in the Usage file DATA
definition.
An example database is provided with the WorkShop Utility files. That example is used
here to show the format. The example does not define the SETTING rules; the rules are
shown and are ignored by the WorkShop Database Application (any line in the User file
that starts with two forward slash characters // is ignored). When no SETTING rules are
defined, ISO Standard parameters are the default. The DATA definition specifies the data
to write on the three tracks. When there is no data specified for a track, the track is not
written. The
csv
file has 10 rows; therefore, ten cards can be written. Each card is
written with variable data from one of the ten rows, starting with row one.
The data written on the first card is shown. The number in brackets { } indicates the card
track number:
{1}
SLAM-DUNK~SPORTS~EVENT=DAVID=12340999
{2}
12340=999=250205
{3}
(
nothing is written on track three
)
Using only track 1 as the example, the “SLAM-DUNK SPORTING EVENT=” is a fixed
card data field; “DAVID” is a variable field from the database file as defined by “fa”; the
next “=” is a fixed field; and “12340999” is two variable fields from the database file as
defined by “fbfc”. The next card written has the same fixed field data and new variable field
data based on row two in the csv file. Defined in row two is the name “MICHAEL”
and the card number & validation number is “12341989”. The data in track 2 is a variable
and remains the same for all cards because it is defined as the same in the database file.
See the example here for the second card written:
{1}
SLAM-DUNK~SPORTS~EVENT=MICHAEL=12341989
{2}
12341=989=250205
{3}
(
nothing is written on track three
)
The database Usage file is shown below. This file can be copied from the CD and then
modified for other database applications.
B & C Data Systems * (541) 601-8282 * http://bcdata.com
22 of 42
Summary of Contents for EzW
Page 4: ...EzWriter MagStripe Reader Writer B C Data Systems 541 601 8282 http bcdata com 4 of 42 ...
Page 17: ...Format Tab View User Tab View B C Data Systems 541 601 8282 http bcdata com 17 of 42 ...
Page 39: ...Appendix A Outline drawings B C Data Systems 541 601 8282 http bcdata com 39 of 42 ...
Page 42: ...42 of 42 ...
