Importing Data for CNAO Audit Files

To import data:

1. Access the Import Assistant form.

2. In the Define Import File area, select how to import the data.

3. In the Define Cell Range area, specify the starting and ending cells.

4. In the Define Import Location in Grid area, select an option:

   • Insert

     Select Insert to place your data at the beginning of the JD Edwards EnterpriseOne table to which you write the data. If you select this option, the system overwrites any existing data up to the number of rows in the spreadsheet. For example, if you select this option and you import 10 rows, the data in your spreadsheet replaces the first 10 rows of the data in the JD Edwards EnterpriseOne table.

   • Paste

     When you select this option, the Import Assistant form displays additional fields in which you specify where to write the data. Select Paste if you want to specify where in the JD Edwards EnterpriseOne table to place the data. Use this option to append data to existing data.

5. Click Apply.

   If all validations pass, the system displays the data that you imported in the detail form for the program. You can verify and modify the data before saving the data to the JD Edwards EnterpriseOne table.