ADF Desktop Integration Where can I get a running Sample?

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 11.1.1.2.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

image

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

image 

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.

image

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.

image

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.

image

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

imageYou can also access the worksheet and the workbook properties that are located under the ADFdi Component Palette

image If the application is already being executed into the server you can go to the Excel Add-Ins tab en Run the Spreadsheet in Test Mode.

image

This will launch the authentication dialog in which you can enter credential sking/welcome1 and you will see the spreadsheet in runtime.image

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.

Comments:

Your site is always up to date and fresh for me. Thanks for working hard on it.

Posted by reverse cell phone lookup on January 07, 2010 at 01:10 PM PST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

me
A blog that explores features, tips and tricks of ADF and JDeveloper by Juan Camilo Ruiz, Product Manager on the ADF and JDeveloper team
Follow me:
Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today