To create a function:As an administrator, you can create a customized spreadsheet function using the Spreadsheet Loader Configuration function.
To create a function:Using the Configuration Workbench responsibility, navigate to Spreadsheet Loader Configuration and click the Go to Task icon.
Click the Go to Task icon for People Data Function and Layout on the Spreadsheet Loader Configuration page.
Click Create to start creating a new function.
Select the Data Source as XML, CSV or Oracle HR in the function details section of the Create Function and Layout: Function and Spreadsheet Details page.
Select the applicable Menu.
Enter the User Function Prompt name. The spreadsheet loader records the function prompt name as the name of the layout.
Select the Entity from the following options.
Person
Address
Assignment
Course
Classes
Offerings
Enrollments
Jobs
Grades
Location
Select the applicable fields from the field options on the left, and click the Move or Move All icon to transfer them to the spreadsheet section, and click Continue.
Select the Allow Migration check box to display all business groups while uploading and downloading data. Otherwise, leave this option unchecked to display only the applicable business groups.
Select the Read Only check box to enable certain fields/columns as non-updatable while uploading and downloading data. Otherwise, leave this option unchecked to make any changes edit the fields/columns.
Select the Allow Batch Processing option to upload spreadsheets using the data pump.
Select Create and Update, Update Only or View Only options as applicable.
Click Finish.
Click the Test icon for a function, specify the applicable and click Launch Spreadsheet to download the spreadsheet.
To Download the Spreadsheets:Click the Test icon for a function in the People Data Function and Layout page.
Enter the applicable information in the fields and click Launch Spreadsheet to download the spreadsheet.