ADF Desktop Integration Where can I get a running Sample?
By Juan Camilo Ruiz on Nov 15, 2009
With ADF 11g release1 we put ADF Desktop Integration (ADFdi) in production which I’ve explained in a previous post. In this article I will explain how you can learn ADFdi by exploring a sample application that we shipped together with the Fusion Order Demo.
The Master Price List module is an application that provides Web and MS Excel frontends for accessing and editing the list of products that are sell within the StoreFront Module of FOD.
In order to access the MPL you first need to download the demo and install the required database schema. You can find detailed instructions in the following link http://www.oracle.com/technology/products/jdev/samples/fod/index.html
Running the demo for the First Time
For this article I will use JDeveloper 18.104.22.168.0 (PS1), although the steps are the same for the ADF 11g R1 release. Open the Master Price List Application located under <FOD_Home>\FusionOrderDemoV2\MasterPriceList
Now set your database connection properties on the Model project, then rebuild your projects and finally run the login.jspx page located on your ViewController project.
Overview of the Application Structure
This is a secured application and for instance all of the protected pages are located under Secured package, the excel spreadsheets are located under the excel package,
if you expand this folder you will see all the spreadsheets with the -DT suffix which means that these are spreadsheets for design time or in other words the spreadsheets that as developer you would work on. The published sub-package groups all the spreadsheets that have been published and would be available for the end users.
Also notice that besides the regular page definitions for the Web pages we have pageDefs for each one of the spreadsheets.
Executing the Demo in Excel
There are two alternatives on how execute the demo in Excel one from the design spreadsheet which we use on development time to Test the spreadsheets or we could access directly the runtime version of the published spreadsheets that are accessible from the Web Application Menu.
Before you run the spreadsheet the ADFdi client must be installed on the client machine, the instructions for installing ADFdi are described in detail on the ADF Developer's guide (see at the bottom).
After running the setup, you can open directly from JDeveloper any of the design-time (*DT) spreadsheets in excel. I recommend you to run you application from JDeveloper first before you jump to excel so you can execute your spreadsheet on test mode at any point in time.
When opening the spreadsheet you can notice on the right hand side the ADFdi component palette which contains the bindings coming from the pageDefinition that this spreadsheet is set to use. On the cells there are visual components like buttons, tables, input texts, etc. you can right click into any component and inspect its properties from the Edit ADF Component Properties
To go back to design time you can stop the application from the Add-ins menu as well. Remember that we the Oracle ADF Desktop Integration Developer's Guide is available and it uses the MPL module to cover the ADFdi features. Instructions and detail explanations about the MPL are also provided in this document.