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		Export Field Properties
	Job Definition Printing		Export Select Properties
	ODBC Security Information		Logic Sequence
	ODBC Table Select		Export Sort Properties
	Cycle Options		Table Link Maintenance
	Perform Maintenance		Visual Integrator FAQs
	Job Information		Chaining or Cycling Jobs

 

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 a module other than Material Requirements Planning and Work Order in the Export Job Selection window, you must exit Export Job Maintenance and reopen it to create or modify jobs for those modules.

Overview

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

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.

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

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

Note Record selection performed on the Select tab is different from record type selection performed on the Sort tab. Record selection compares data assigned to the record to be written, whereas record type selection compares data in the source file record contained in a string array called IMP$[all].

The ability to create and run export jobs is based on your security setup, and it can vary by module.

Fields

 

Job Name	Compiled File Name
1. Configuration
Table Name	Chain To
Long Description	On Server
File Type	Insert All Fields During Setup
Delimiter	Convert Delimiter in Data to Space
Use ASCII	Pad Exported Fields with Spaces
Export File	Export Column Names as First Record
ODBC	Display Read Only Fields For Export
Password	Wrap String Fields in Quotes
2. Data
Available Fields	Export Fields
3. Select
Available Fields	Selection Fields
4. Sort
Available Fields	Sort Fields