Price Book Designer - Definition tab

Navigator > Setup > Data Interchange > Price Book Designer > Definition tab

Preview the import definition from Navigator > Tasks > Price Book Import

Input Format

Select the import file type.

CSV/Tab Delimited CRLF Terminated	Comma separated value file or Tab delimited file, with lines terminated by Carriage Return Line Feed (CRLF) characters. Fields are optionally enclosed in quotation marks (" "), and are separated by commas or the Tab CHR(9) character. Record terminators do not consider quotes.
CSV/Tab Delimited LF Terminated	Comma separated value file or Tab delimited file, with lines terminated by a Line Feed (LF) character. Fields are optionally enclosed in quotation marks (" "), and are separated by commas or the Tab CHR(9) character. Record terminators do not consider quotes.
CSV/Tab Delimited Any Terminator	Comma separated value file or Tab delimited file, with lines terminated by either Line Feed (LF), Carriage Return (CR) or Carriage Return Line Feed (CRLF) characters. Fields are optionally enclosed in quotation marks (" "), and are separated by commas or the Tab CHR(9) character. Record terminators do not consider quotes.
ASCII Fixed Widths	Fixed width ASCII file. Fields are located at fixed positions across each line of the import file.
DBF	dBase file format.
Excel Worksheet	The Excel Worksheet selection becomes available, and defaults to the first worksheet. Select the sheet from your workbook.

Default Input File

File name for the import definition. On Price Book Import the file name is supplied.

If this is an XLS or XLSX file, the Input Format must be Excel Worksheet.

Load Structure

For structured file formats (.DBF), loads the file structure in the grid.

Excel Worksheet

For Excel Worksheets, specifies the Worksheet.

Grid Fields

Name

Optional name for the field in the import file. Provided the name is a valid MaxBasic variable name it can be referenced in MaxBasic code, and is the field title in PB Import Preview.

Offset

Determine the position of the field in the import file. For CSV and DBF files it is the field number in the file, 1 as the first field. For ASCII files it is the starting character position, starting from 1.

To import data not represented in the import file (for example, default field values) specify an offset 0 and supply the data from MaxBasic code (if offset 0 the field is not located in the import file).

Width

For ASCII format, the field width in characters.

Destination

The field in the Accredo Product file the data will be imported into. Can be left blank as not all fields in the import file need to be imported.

Grid Toolbar