XPAC Reference Guide

Using the Field Setup Wizard

Using the Field Setup Wizard

Previous topic Next topic  

Using the Field Setup Wizard

Previous topic Next topic  

Use the Field Setup Wizard to help you set up fields when importing or exporting XPAC data. You can access the wizard by clicking Setup Wizard in the import or export window, for example:

Field Setup Wizard - Setup Wizard button

To set up data fields using the Field Setup Wizard:

1.On the welcome page of the Field Setup Wizard window, click Next. The second page of the wizard displays.
2.For each field in the data file:
a.Define the field properties of each field.
b.Click Next. The last page of the wizard displays.
3.Click Finish. The import/export window redisplays.

Field properties

Section

Field/option

Description

N/A

Line Number

Read-only fields.

Item Number

Start Position

Lets you define the range of cells that XPAC reads for the selected field.

XPAC scans the file and assumes where the field boundaries are. These boundaries are presented as the default Start Position and Field Width for each field.

Field Width

Field Type

Ignore

Determines where XPAC stores the data.

PIL Number

Record Name

Data Field

Field Attribute

 

Lets you specify exactly where XPAC stores the data. For example, at the Strip level.

Note

The options that display in this section depend on the Field Type that you selected.

Multiplier

None

Multiplies the number in the field by a factor of 1.0.

% (0.01)

Converts the number in the field from a percentage to a fraction.

Other

Multiplies the number in the field by a factor, then lets you specify the value in the field that displays.

Constant

N/A

Adds a constant to the number in the field.