Data Conversion Example

This data conversion example illustrates how to copy employee records from the F0101 table in the Login Environment to the F0101 table in the PY812 environment.

1. On the Introduction form of the JD Edwards EnterpriseOne Table Conversion director, select Data Conversion, and click Next.

2. On the External Data form, accept the default selections, and click Next.

3. On the Select Environments form, select <LOGIN ENV> as the input and PY812 as the output environment, and click Next.

4. On the Select Input form, drag the Address Book Master table to the Description column on the Table tab, and click Next.

5. On the Sequencing form, accept the default selection, and click Next.

6. On the Data Selection form, define the data selection as Where AT1 (Search Type) (F0101) is equal to E to select current employees, and click Next.

7. On the Select Outputs form, drag the Address Book Master table to the Description column on the Tables tab, and click Next.

8. On the Table Options form, clear the Run Currency Triggers option because the Address Book Master file does not contain currency information, and click Next.

9. On the Mapping form, select the Row Fetched event because you are converting data from similar files, click Map Same, and click Next.

   The system automatically maps data elements with the same aliases.

10. On the Logging Options form, select Log All Errors and Log Outputs, and click Next.

    These options enable you to review the conversion after it is complete.

11. On the Finish form, select No, I will create a version of this table conversion later, and click Finish.

12. On the Table Conversion form, click Save before quitting.