This chapter includes the following sections:
About the Summit Sample Application for ADF Desktop Integration
The Summit sample application for ADF Desktop Integration is a set of sample demonstrations that illustrate the main capabilities from ADF Desktop Integration.
Each of the samples contains specific features that can be identified in the developer's guide. All of the samples use the same underlying database schema which makes it easy for accessing the source code, and also to experience the runtime behavior in a standalone way.
Setting Up and Running the Summit Sample Application for ADF Desktop Integration
Set up the development environment before you download and run the Summit sample application for ADF Desktop Integration.
For information about how to set up the development environment, see Setting Up Your Development Environment .
Running the Summit sample application for ADF Desktop Integration requires you to:
- Download the application resources, as described in How to Download the Application Resources.
- Run the Summit sample application, as described in How to Run the Summit Sample Application for ADF Desktop Integration.
How to Download the Application Resources
You download the application resources from Oracle Technology Network.
To download the Summit sample application for ADF Desktop Integration:
Download and install Oracle JDeveloper.
For information, see Installing the Oracle JDeveloper Software in Installing Oracle JDeveloper.
Install ADF Desktop Integration. See Installing ADF Desktop Integration.
If you have an old version of ADF Desktop Integration installed on your system, upgrade ADF Desktop Integration as described in Upgrading ADF Desktop Integration.
Download and install the Summit ADF schema. See How to Install the Summit ADF Schema in Developing Fusion Web Applications with Oracle Application Development Framework.
Download and install the Summit sample application for ADF Desktop Integration ZIP file from Oracle Technology Network.
How to Run the Summit Sample Application for ADF Desktop Integration
To run the Summit sample application, extract the contents of the zip file and open the
.JWS file in JDeveloper.
To run the Summit sample application for ADF Desktop Integration:
Extract the contents the zip file to a local directory.
SummitADFdi.jwsfile in JDeveloper.
This file is located in the
In the Applications window, click and expand the Model project.
Open Model > Application Sources > oracle.summitdi.model > Model.jpx file.
Expand the Connection group of the General tab, and click the Add icon to create a database connection.
In the Create Database Connection dialog, add the connection information shown in Table 2-1 for your environment.
Table 2-1 Database Connection Properties for the Summit Sample Application for ADF Desktop Integration
The host name for your database.
The port for your database.
The SID of your database.
Click Test Connection to verify the connection, and then click OK to close the dialog.
Select the ViewController project and click the Run button in JDeveloper's main menu.
Overview of the Fusion Web Application in the Summit Sample Application for ADF Desktop Integration
The Fusion web application in the Summit sample application for ADF Desktop Integration enables end users to download the integrated Excel workbooks.
About the Fusion Web Application in the Summit Sample Application for ADF Desktop Integration
When the end user runs the Summit sample application for ADF Desktop Integration in JDeveloper, the default browser opens the application home page. The end user can download various integrated Excel workbooks from the home page.
Figure 2-1 Home page of Summit Sample Application for ADF Desktop Integration
Description of "Figure 2-1 Home page of Summit Sample Application for ADF Desktop Integration "
Downloading Integrated Excel Workbooks
The Summit sample application for ADF Desktop Integration provides various integrated Excel workbooks to meet different requirements. End users can navigate and download different workbooks from the
MainPage.jsf of the application. When an end user clicks a link to download a workbook, a Java applet verifies that the ADF Desktop Integration add-in is present on the end user’s machine. If the add-in is found, the workbook download begins automatically. Otherwise, ADF Desktop Integration prompts the end user to install the add-in. If Java is not installed on the end user’s machine or is disabled by the end user’s security settings, the Java applet is unable to verify the presence of the ADF Desktop Integration add-in. ADF Desktop Integration informs the end user that the installation of the add-in cannot be verified. It presents the end user with the option to download the workbook and/or install the add-in.
Table 2-2 lists the menu options and the downloaded integrated Excel workbooks.
Table 2-2 Integrated Excel Workbooks of Summit sample application for ADF Desktop Integration
Edit Customers Sample
Edit Warehouse Inventory Sample
Edit All Inventory Sample
Search Customers Sample
Overview of the Integrated Excel Workbooks in the Summit Sample Application for ADF Desktop Integration
The Summit sample application for ADF Desktop Integration provides the
CustomerSearch.xlsx, EditAllInventory.xlsx, EditCustomers.xlsx, and
EditWarehouseInventory.xlsx integrated Excel workbooks.
CustomerSearch.xlsx workbook demonstrates how a custom web page can be used to perform a search prior to downloading data into an ADF Table component configured to be read-only.
EditAllInventory.xlsx workbook demonstrates how to create an editable table with a denormalized master-detail relationship. It also demonstrates how to use a date picker, group columns, and delete existing data records.
EditCustomers.xlsx workbook illustrates the most commonly used ADF Desktop Integration ADF Table component features. You can download, insert, update and commit data. It also demonstrates multiple ways to choose a value from a list of choices.
EditWarehouseInventory.xlsx workbook illustrates how to use ADF Desktop Integration form components with a detail table. You can download and update data in a master form and its detail table. This sample also demonstrates how to use workbook parameters to control the workbook initialization.
Subsequent sections in this chapter provide more information about the functionality in the workbooks along with cross-references to implementation details.
Log on to the Fusion Web Application from an Integrated Excel Workbook
At runtime, the integrated Excel workbooks in the Summit sample application for ADF Desktop Integration render an Excel ribbon tab that allows end users to log on to the Fusion web application. Figure 2-2 shows the runtime Customers tab in the Ribbon of the
Figure 2-2 Runtime Customers Tab
Description of "Figure 2-2 Runtime Customers Tab"
Downloading Data Rows
Some workbooks, such as
EditCustomers.xlsx workbook, use an ADF Table component to download information from the Fusion web application. This component allows end users to edit rows and upload modified rows to the Fusion web application.
The following sections provide information about how to implement the download functionality:
Each worksheet that you integrate with a Fusion web application requires an associated page definition file.
For example, the
Customersworksheet in the
EditCustomers.xlsxworkbook is associated with the
ExcelCustomers.xmlpage definition file. In JDeveloper, expand the following nodes in the Applications window to view this file:
ViewController > Application Sources > oracle.summitdi.view > pageDefs
For information about how to configure a page definition file, see Working with Page Definition Files for an Integrated Excel Workbook.
The ADF Table component
Downloadaction downloads data from the Fusion web application to the worksheet. For information about how you invoke this action, see Downloading Data to an ADF Table Component.
EditCustomers.xlsxworkbook, the worksheet
Startupevent invokes an action set that includes the ADF Table component
Downloadaction. For information about configuring worksheet events, see How to Invoke an Action Set from a Worksheet Event.
Modify Customers and Warehouses Information in the Workbooks
EditWarehouseInventory.xlsx workbooks enable end users to edit customers and warehouses information that the ADF Table component and form components downloads from the Fusion web application. Columns in the runtime ADF Table component that have an
UpdateComponent property configured permit end users to modify values and upload the changes to the Fusion web application. For example, end users can modify the values that appear in the Name, Phone, and Address columns in
Other columns, such as Status and Changed, appear in the ADF Table component to provide status information about upload operations and changed columns.
The following sections provide information about how to implement this functionality:
For information about inserting an ADF Table component, see Inserting an ADF Table Component into an Excel Worksheet.
For information about special columns, such as Status and Changed, see Special Columns in the ADF Table Component.
For information about action sets, see Adding Interactivity to Your Integrated Excel Workbook.
For information about lists of values, see Working with Lists of Values.
Upload Modified Information to the Fusion Web Application
The integrated workbooks allow end users to upload modified data in the ADF Table component to the Fusion web application. An action set is configured for the runtime Upload ribbon command that invokes the ADF Table component's
Upload action. For information about implementing this functionality, see Uploading Changes from an ADF Table Component .