Export Job Maintenance Home | FAQs & Troubleshooting

 

Window Details
	Navigation
	Overview
	Fields

 

How Do I...
	Generate an Export Job		Add a Job to the Jobs Menu
	Export to an ODBC Data Source		Compile a Job
	Check an Expression		Copy a Job
	Create a Conditional Expression		Create a Temporary Field
	Define Skip Records and Standard Records		Determine the Destination or Source File
	Set Up Cycles for a Job		Test a Job

 

 

Related Topics
	Export Job Selection		Field Properties (Temporary Fields)
	Job Definition Printing		Sort Properties
	ODBC Security Information		Select Properties
	ODBC Table Select		Logic Sequence
	Cycle Options		Table Link Maintenance
	Job Perform Logic		Visual Integrator FAQs
	Job Information		Chaining or Cycling Jobs
	Field Properties

 

Navigation

Select Visual Integrator Main menu > Export Job Maintenance. In the Export Job Selection window, enter a job name and table name, and then click Accept.

Note If you selected a job or table for the Material Requirements Planning and Work Order modules in the Export Job Selection window, you must exit Export Job Maintenance and reopen it to create or modify jobs for other modules.

Overview

The following information applies only to export jobs for the Material Requirements Planning and Work Order modules.

Use Export Job Maintenance to define and maintain export jobs that are used to export data from the software to an external file or database. After an export job is defined, this task can also be used to execute the job immediately or to schedule how often the job is to be run.

When you accept the job, you can immediately prepare the job for use and execute the export job. A job can be executed immediately after the job has been compiled.

One or more sort fields can be used to sort the data. Each field can be sorted in ascending or descending order. The sort process is optional; if no data sort criteria have been defined, all data records from the data file are exported in the order in which they are processed (typically, in the order in which the source file is sorted).

The selection fields determine the criteria by which records are evaluated and subsequently selected. The selection range values can be predefined in this task or can be entered at the beginning of the job. The selections can also be nested using ANDs and ORs. The selection process is optional; if no data selection criteria have been defined, all data records from the data file are exported.

Fields

 

Job Name
1. Configuration
Description	Password
File Name	Chain To
File Type	On Host
Delimiter	Insert All Fields During Setup
ASCII Value	Convert Commas to Spaces before Exporting
Export File	Strip Fields before Writing
Data Source
2. Data
Available Fields	Export Fields
3. Sort
Available Fields	Sort Fields
4. Select
Available Fields	Selection Fields