Export Job Maintenance - Fields Home | FAQs & Troubleshooting

 

Export Job Maintenance

 Show/Hide All

Job Name

Enter a job name, or click the Lookup button to list all job names. Job names can contain up to 15 characters. This field is not available if you entered a job name in the Export Job Selection window.

 

Compiled File Name

This field displays the unique compiled file name automatically assigned to the job, and can only be viewed. The format used for the file names is VIWXxx, where VI stands for Visual Integrator, W stands for Windows, X in dicates that it is an export job, and xx is a unique sequence of alphanumeric characters from 00 to ZZ.

 

1. Configuration

 

Table Name

Enter the name of the table from which data will be exported, or click the Lookup button to list all available tables. An entry is required in this field for new jobs. If you selected an existing job in the Job Name field, this field can only be viewed.

NOTE For Header-Detail tables, when you need to draw data from both the header and detail, select the Detail table as the primary table. The Detail table is linked to the Header table because the header key is part of the detail key. If you select the Header table as the primary table, the Detail table is not linked.

 

Long Description

Type a job description, up to a maximum of 240 characters. The description appears as a comment on the generated Export Job window.

 

File Type

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 specify a single target table to which to export. Click the ODBC Login Security button to enter the user name and password to use when accessing an ODBC data source, if they are required.

 

Delimiter

Type the delimiter character used to separate fields in the export file. The character entered must be a printable character. This field appears only if Delimited is selected in the File Type field. If you selected an existing job in the Job Name field, this field can only be viewed.

 

Use ASCII

Select this check box to enter the numeric ASCII decimal equivalent to the delimiter character used to separate fields in the export file. The ASCII decimal value is required if the export file uses a nonprintable delimiter character, such as a Tab. Clear this check box to use the printable character entered in the Delimiter field.

 

Export File

Enter the path and name of the file to which data will be exported. Click the Folder 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 in not selected as the file type.

 Entry Sample

..\Home\Textout\Cust.csv

 

ODBC

Enter a valid ODBC data source. This field is available only if ODBC Data Source is selected as the file type in the File Type field. The ODBC data source must first be configured on your workstation using the Windows ODBC Data Source Administrator.

 

Password

Type a password to check at runtime. The password is case-sensitive. Leave this field blank if no password is to be assigned.

 

Chain To

Enter an import/export job to be chained to after completion of this job, or click the Lookup button to list all jobs. This feature allows several jobs to be executed together in sequence.

Note A job with cycle information cannot chain to another job.

 

On Server

Select this check box to enter the file name or the ODBC data source for the server (host) system. Clear this check box to use the local (workstation) file name or data source.

This check box is available only if the system is running on Sage 100 Advanced.

 

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. Clear this check box if you do not want all fields added automatically. If you selected an existing job in the Job Name field, this check box can only be viewed.

Click Options to view and select additional options.

 

Convert Delimiter in Data to Space

Select this check box to convert any delimiter characters contained in data fields to spaces before writing to the export file. Delimiters can include tabs and other non-printable characters. Clear this check box to export delimiter characters. This field is ignored when not exporting to a delimited file. This check box is available in the Options window.

 

Pad Exported Fields with Spaces

When exporting in Delimited format, extra spaces in a data field are automatically removed. Select this check box to add spaces to extend each exported field to its maximum length. Clear this check box if you do not want to add spaces to exported fields. This check box is available in the Options window.

 

Export Column Names as First Record

Select this check box to export a delimited list of column names as the first record exported, before exporting the data. If ASCII is selected in the File Type field, the column names will be truncated to the length of the field; however, the columns names will line up with the ASCII data. Clear this check box if you do not want to export a list of column names as the first record exported. This check box is available in the Options window.

 

Display Read Only Fields For Export

Select this check box to display only the read only fields in the dictionary on the Data tab for exporting. Clear this check box if you do not want to display the read only fields. This check box is available in the Options window.

 

Wrap String Fields in Quotes

Select this check box to export the string fields contained in quotes. Clear this check box if you do not want to export the string fields contained in quotes. This check box is available in the Options window.

 

2. Data

 

Available Fields

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_.

Note  Any GL Account key field (surrogate key) is converted from its surrogate key value to the equivalent fully formatted account (FFA) value, and it is the FFA that is exported.

 

Export Fields

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. Double-click a field name to edit the field's properties.

Click the Add Temp Field button to add a temporary field to this list box. Use temporary fields to manipulate the source data for export, or to add data to the export record that is not contained in the source record.

The fields listed represent the data sources that are used in the export. They should be listed in the order of the column number or start position (for ASCII files) specified in the Col/Pos field in the Export Field Properties window. Source data for temporary fields is taken from either the Default field or Calculation field in the Export Field Properties window.

If you need to add a large number of fields, first consider the order in which you need to add them.

Note If you are entering date information, dates must be entered in the YYYYMMDD format.

 Example - Order of adding fields

For Header-Detail table pairs, you may want to add fields from the Header table before adding fields from the Detail table to avoid the need to move the Header fields up in the list box.

 

 

3. Select

 

Available Fields

This list box displays fields from the data file and any linked files. Select fields that are used in the export job to define the selection criteria. Select fields that are used in the export job, because fields are assigned to the record, then a record is selected based on some part of the contents of the record to be written.

 

Selection Fields

This list box displays all selection fields that have been defined. The list order determines the order in which actions are performed. Double-click a field name to edit the field's properties.

The selection fields determine the criteria by which records are evaluated and subsequently selected.

 

Select Begin / Select End

Type the beginning and ending key values for the main table from which data is being exported. This allows you to export a range of records in a large file instead of the entire table.

Note Do not enter beginning and ending values when exporting from smaller tables or from Header or Detail tables.

 

4. Sort

 

Available Fields

This list box displays fields from the data file, along with associated linked files.

 

Sort Fields

This list box displays all sort fields that have been defined. The order of the list is significant for sorting purposes. Double-click a field name to edit the field's properties.

Note  Only field selected for export should be included.