> > > > >

Use this form to specify the fields in the selected table that you want to import data to or export data from.

Tip Tip

The button is enabled only for and definition groups.

Tasks that use this form

Navigating the form

The following links and tables provide descriptions for the controls in this form.

Tabs

The form configuration depends on the type of the definition group.

For definition groups:

Tab page

View and modify the list of fields included in the import or export.

For definition groups:

Tab page

View and modify the list of fields included in the import.

Note Note

The and fields are required if a has not been defined in the form.

Define detailed import options for each field.

Qualify the import of individual fields through X++ code. Each field can be accessed in the input parameter of the string type. Click to check the code for errors before doing the actual import.

Fields

Field

Description

Add or remove fields for the import or export.

Specify the order in which to export the fields.

Select this check box to have data imported into this field.

Enter the start position in the import file for each field.

This is necessary if the fields are not separated by a specific character such as a comma or semicolon. The positions are measured in number of characters (counting from one).

Enter the end position in the import file for each field.

This is necessary if the fields are not separated by a specific character such as comma or semicolon. The positions are measured in number of characters (counting from one).

As part of the import, a field can be assigned a value automatically. In the list, select one of these options:

  • – Never provide an initial value automatically.

  • – Assign an initial value automatically if the field has no value. Type the initial value that should be used in the field.

  • – Always provide an initial value automatically. Type the initial value that should be used in the field.

In the field, enter characters to exclude from the import process. If the field contains any of these characters, the characters are automatically removed during import.

In the field, enter characters that should be inserted before the field value during import.

In the field, enter characters that should be inserted after the field value during import.

Tip Tip

Use \n (new line) to insert a line break. This is useful when you have several fields in the import files that you want to insert in one table field that has the correct formatting.

Example

You want to import the following fields into one table field, adding a prefix and a line break:

1142 Pine Street, Anytown, USA, 27999

By using \n, you can import the fields into the address field as follows:

1142 Pine Street

Anytown, USA, 27999