Contents

List of Figures

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introduction to JD Edwards EnterpriseOne Table Conversion

• 1.1 JD Edwards EnterpriseOne Table Conversion Overview
• 1.2 JD Edwards EnterpriseOne Table Conversion Implementation Steps

2 Understanding Table Conversion

• 2.1 Table Conversions
• 2.2 Types of Tables to Use
• 2.3 Business Views in Table Conversions
• 2.4 Text Files in Table Conversions
• 2.5 Sort and Selection Criteria in Table Conversions
• 2.6 Input and Output Environments

3 Setting Up Table Conversions

• 3.1 Understanding Table Conversion Setup
• 3.2 Understanding the Table Conversion Process Flow
• 3.3 Adding Table Conversions
  • 3.3.1 Understanding the Navigation Assistant
  • 3.3.2 Prerequisites
  • 3.3.3 Forms Used to Add New Table Conversions
  • 3.3.4 Adding New Table Conversions
  • 3.3.5 Starting the Table Conversion Director
• 3.4 Converting Data
  • 3.4.1 Understanding Data Conversion
    • 3.4.1.1 Data Conversion Example
  • 3.4.2 Forms Used to Convert Data
  • 3.4.3 Defining External Data for Table Conversions
  • 3.4.4 Defining Input and Output Environments for Table Conversions
  • 3.4.5 Defining Table Conversion Input
  • 3.4.6 Defining Table Conversion Output
  • 3.4.7 Mapping Inputs to Outputs
  • 3.4.8 Specifying Table Conversion Logging Options
  • 3.4.9 Reviewing Table Conversion Results
• 3.5 Defining File Formats for Table Conversion Input or Output
  • 3.5.1 Understanding User-Defined Formats
    • 3.5.1.1 Importing and Exporting Text Files
    • 3.5.1.2 Using User-Defined Formats as Input
    • 3.5.1.3 Using User-Defined Formats as Output
  • 3.5.2 Prerequisite
  • 3.5.3 Defining Delimited File Formats with a Single Format
  • 3.5.4 Defining Delimited File Formats with Multiple Formats
  • 3.5.5 Defining Fixed-Width File Formats with a Single Format
  • 3.5.6 Defining Fixed-Width File Formats with Multiple Formats
• 3.6 Copying Data
  • 3.6.1 Understanding Copying Data
  • 3.6.2 Prerequisites
  • 3.6.3 Defining Data Copy Actions
• 3.7 Copying Data with Table Input
  • 3.7.1 Understanding How to Copy Data with Table Input
  • 3.7.2 Prerequisites
  • 3.7.3 Defining Data Copy with Table Input Actions
• 3.8 Deleting Groups of Records
  • 3.8.1 Understanding Batch Deletion
    • 3.8.1.1 Example: Creating Purge Programs as a Batch Delete
  • 3.8.2 Prerequisites
  • 3.8.3 Defining Batch Deletion Actions
• 3.9 Using Event Rules in Table Conversions
  • 3.9.1 Understanding Event Rules in Table Conversions
    • 3.9.1.1 Table Conversion System Functions
  • 3.9.2 Creating Event Rules in Table Conversions

4 Running Table Conversions

• 4.1 Understanding Table Conversion Processing
• 4.2 Submitting Table Conversions
  • 4.2.1 Understanding Submitting Table Conversions
  • 4.2.2 Understanding Overriding Table Conversion Properties
    • 4.2.2.1 Table Conversions on the Web Client
  • 4.2.3 Forms Used to Submit Table Conversions
  • 4.2.4 Overriding Table Conversion Properties at Runtime
  • 4.2.5 Overriding Table Conversion Properties of New Versions
  • 4.2.6 Overriding Table Conversion Locations
  • 4.2.7 Running Table Conversions from the Web Client
• 4.3 Testing Table Conversions
  • 4.3.1 Understanding Table Conversion Testing
    • 4.3.1.1 Difference Between Logging Options and Debug Logging
    • 4.3.1.2 Trace Levels
  • 4.3.2 Setting the Trace Level for Debug Logging on the Workstation
  • 4.3.3 Setting the Trace Level for Debug Logging on the Server
  • 4.3.4 Forcing Row-By-Row Conversion

5 Preparing Foreign Tables for Table Conversion

• 5.1 Understanding Foreign Tables
• 5.2 Adding Data Sources
  • 5.2.1 Forms Used to Add Data Sources
  • 5.2.2 Adding Data Sources
• 5.3 Adding Environments
  • 5.3.1 Forms Used to Add Environments
  • 5.3.2 Adding Environments
• 5.4 Setting Up Default OCM Mappings
  • 5.4.1 Understanding OCM Mappings
  • 5.4.2 Forms Used to Set Up Default OCM Mappings
  • 5.4.3 Setting Up Default OCM Mappings

Glossary

Index