Show/Hide All
Enter a job name, or click the Lookup button to list all job names.
1. Configuration
Type a job description. The description appears as a comment on the generated Export Job window.
Enter the name of the data file from which data will be exported, or click the Lookup button to list all available files. An entry is required in this field.
Select the file type from which to export the data. The following options are available.
Select Ascii to export from an ASCII file type.
Select Delimited to export from a delimited file type.
Select ODBC Data Source to export from an ODBC data source (Version 2.0 and higher). The ODBC data source can be used to export to many other file types, such as Excel and Access, that support ODBC "write-back" capabilities. When exporting to an ODBC data source, you must select a single target table to which to export.
Type the delimiter character used to separate fields in the export file. This field appears only if Delimited is selected in the File Type field. If the ASCII Value check box is selected, the numeric ASCII value is entered. If the check box is cleared, the actual character is entered.
Select this check box to enter the numeric ASCII value in the Delimiter field. Clear this check box to enter the actual character.
Enter the path and name of the file to which data will be exported, or click the Lookup button to select an existing file. This field is optional because the export file can be specified at the time that the export job is executed. This field is available only if an ODBC data source is not selected as the file type.
..\Home\Textout\Cust.csv
Enter a valid ODBC data source. This field is available only if ODBC is selected as the file type. The ODBC data source must first be configured on your workstation using the Windows ODBC Data Source Administrator.
Type a password to be checked at run time. Leave this field blank if no password is to be assigned.
Enter an import/export job to be chained to after completion of this job, or click the Lookup button to select an existing job. This feature allows several jobs to be executed together in sequence.
Note A job with cycle information cannot chain to another job. This field is not available if cycle information is entered for the job.
This field appears if the system detects that it is running on the client/server software. Select this check box to enter the file name or the ODBC data source for the host (server) system. Clear this check box to use the local (workstation) file name or data source.
Insert All Fields During Setup
Select this check box to insert all the available fields automatically to the right-hand list box on the Data tab. This field is available only when exporting to a delimited file. Clear this check box if you do not want all fields added automatically.
Convert Commas to Spaces before Exporting
Select this check box to convert any commas contained in data fields to spaces before writing to the export file. This will prevent unwanted commas from causing errors when exporting to delimited files. Clear this check box to export commas. This field is available only when exporting to a delimited file.
Select this check box to strip trailing spaces from data fields before writing to the export file. This field is available only when exporting to a delimited file.
2. Data
This list box displays fields from the data file selected on the Configuration tab. Any associated file linked to the main file is included. Any user-defined fields are listed at the bottom of the list with a prefix of UDF_.
This list box displays all data fields that have been selected for export. The order of this list is significant for calculation purposes and the order of data assignment.
3. Sort
This list box displays fields from the data file, along with associated linked files.
This list box displays all sort fields that have been defined. The order of the list is significant for sorting purposes.
4. Select
This list box displays fields from the data file and any linked files.
This list box displays all selection fields that have been defined. The list order determines the order in which actions are performed.
