NOTE: This help page describes a specific section of the Comma-Separated Values Wizard. If you need more background information on this wizard, see the "Using the Comma Separated Values Wizard" topic.
This section of the comma-separated values (CSV) wizard pertains to the report body. Using this page, you can define different line types (rows) for the body. Each line type can have different column parameters, and each line type can either be printed or not.
There are two kinds of lines that can be defined: a pattern line and a default line. With a pattern line, you specify a pattern (string) that must be matched. If a line in the report contains the matching string, it is classified as that kind of line and printed/formatted accordingly. If a line in the report does not contain any of the defined patterns, it is classified as a default line and printed/formatted accordingly. You can define only one default line, but you can define an unlimited number of pattern lines.
Some trial and error may be required in order to set up the body accurately. To help you define the columns, you first might download the report as a text file, and view it within an editor that shows column positions. After creating a CSV configuration, you should download a report in CSV via the user interface to verify that the column headers and body are properly formatted.
| Start: | Key in the starting line for body text in the report. |
|---|---|
| Lines: | Key in the total number of lines in the report body. |
If
necessary, use the Add button to add a new line, then select/key
in the information, as required (see below). To scroll through
the existing lines, use the Previous and Next buttons. If you
need to delete a line definition, use its corresponding Delete
button.
| Type: | Select the type of line you wish to define from the drop-down list. Choose PATTERN if you want to specify a pattern (string) for the line. Note that pattern lines are searched in the order entered. Choose DEFAULT to define the line to use if none of the patterns are matched. You should define only one default line. |
|---|---|
| Pattern: | If Type = PATTERN (see above), key in the pattern (string) by which to match this line type. A default line will not have a pattern. |
| Print Line: | Select YES to print this line type or NO to suppress printing. If you select YES, you will be prompted to define the first column (see below). If you select NO, you will not define columns for this line. |
| Columns: | If necessary, use the Add button to add a column; then key in the starting and ending position, inclusive, for the column. If the column will contain a number, select YES in the "Numeric Column" field. Banner ePrint will properly format the values, so that the spreadsheet application will interpret negative numbers correctly. If you need to delete a column definition, use the Delete button to the right of the column data. |
Use the navigation bar or the buttons at the bottom of the page to move to another page or finish the wizard. For more information on navigating through a wizard, see the "Navigating Through a Wizard" topic.