Import Designer - Line Type tabs

Navigator > Setup > Data Interchange > Import Designer > Line Type [Number] tab

You can have one or more Line Type tabs, for each type of data line in the Import file. Insert additional Line Type tabs from the Definition tab. Line Type tabs are numbered sequentially, starting with Line Type 1.

List the fields in the import file for this Line type to define them as variables that can be used in the Import Data code below. Enter code to use these variables to set data fields in Accredo.


Name		The variable name given to the field in the import file record. This can be referenced in the Import Data code below. Must be unique valid variable names.
Offset		Determine the position of the field within the import file record. For CSV and Tab delimited files, this is the field number (or field) in the file (starting from 1 as the first field). For ASCII files this is the starting character position (starting from 1).
Width		Only used for ASCII file format, this is the width of the field in characters.
Comment		Has no effect on the import, allows for documentation attached to the field.
Grid Toolbar
	Expand Toolbar `(Ctrl+F9)`	Expand the toolbar to give access to all toolbar options. Press `Esc` to close the expanded toolbar.
	Insert `(F4)`	Insert a line.
	Move up `(Shift+Up)` Move down `(Shift+Down)`	Move a line up or down the grid.
	Delete `(F3)`	Delete a line.
	Export Fields	Open Export Line Type to create a file in a selected format containing the headers from the field list.
	Add Fields	Create variable names and field offsets from a header line. This is not available for ASCII input files. You will be prompted to enter which line number contains the header line for the line type.
Import data		Code you can call from the Perform Import code on the Definition tab, to process this type of line in the import file. See also Script Editor.

See Code Editor for options available.

In This Section

Import Designer - Export Line Type