Wednesday Jul 18, 2012

How to access published ADFdi enabled excel workbook from ADF Library jar

We generally tend to create multiple applications and re-use them in one main application by adding them as ADF Library jars.Applications with ADF Desktop Integration support added to ViewController can also be re-used.

This blog is about how to access workbooks in ADF Library jar from a different application(which consumes ADF Library Jar).

Assumption : Let's assume that a simple ADF application(TestApp) is created with Dept and Emp as entities and added as Master Form Detail Table in jspx.Also an ADFdi enabled excel workbook is created to simulate DeptView and EmpView as Master Form Detail Table.Publish the workbook(PBook1.xlsx) and store it in ViewController/public_html/excel/ folder and check for the working of published workbook by re-deploying the application.

Now,let's proceed to the steps to be done before deploying ViewController as ADF Library jar.

Open web.xml in ViewController->Web Content->WEB-INF of TestApp, in Filters tab, check for adfBindings and adfdiExcelDownload filters. If not present add by referring this ADFdi guide.

Create a new deployment profile for ViewController by right-click ViewController and Deploy->New Deployment profile. Select ADF Library Jar File as Profile Type and give a profile name like TestAppLibJar

Create a new custom application(ClientApp) with ADF ViewController as project.

Create a FileSystemConnection to import the deployed library jar of TestApp as below:
In Resource Pallete, open New File System Connection, give Connection Name as TestAppConn and for DirectoryPath browse and select the deploy folder inside ViewController of TestApp application.

FSConnection

Select ViewController of ClientApp, expand the TestAppConn(File System Connection) created, select TestAppLibJar, right-click and Add to Project. In Confirmation dialog, click on Add Library,

AddJar

In ViewController add ADF Desktop Integration support by right-click ViewController->Project Properties->Features, click on + sign and move ADF Desktop Integration from Available to Selected.

ADFdiScope

Add ADF Library Web Application Support into ViewController of ClientApp by right-click ViewController->Project Properties->ADF View, select Enable ADF Library WebApp Support checkbox.

ADFLibWebAppSup

Open web.xml and check for the correct ordering of ADFLibraryFilter and adfdiExcelDownload filter. Make sure adfdiExcelDownload filter is above ADFLibraryFilter.

webxml_clientApp

Add Initialization Parameter for ADFLibraryFilter with Name 'include-extension-list' and Value 'png,jpg,jpeg,gif,js,css,htm,html,xlsx' as shown in above pic.

Now we will create a jspx page and add Go link with Text 'Download Excel' and Destination '/excel/PBook1.xlsx'

DloadPage

Run the jspx page and click on Download Excel link. Click on Open, and give yes in Login dialog. There we go, here is our published workbook.

FinalPBook

Friday May 20, 2011

Customizing display of components in ADF Libraries

Introduction:

ADF Libraries are Java archive files, from which ADF Components like Business Components, Data controls, taskflows etc can be reused. This data however only lists default names of components. This ariticle deals with cuztomizing metadata visibility in ADF Libraries through the  use of resource bundles.  

Sample Application:

Customizing visibility and component names inside an ADF Library needs two things:

  • A custom Meta-Inf file.
  • A Resource bundle - a .properties file.
The following steps illustrate this feature:

  1. Create a Fusion Web Application and create ADFBC Components based on Dept and Emp tables in the model,
  2. Create a View controller with a bounded taskflow, with 2 view objects - Dept and Emp. Define control flow scope, and create page fragments out of them.
  3. Create an ADF Library deployment profile in the View Controller project.
  4. In the View Controller project create a .properties file - LibraryBundle.properties.



.name=Friendly jar name
.description=Friendly long description of the jar
.tooltip=This is the tooltip text to display on mouse hover
.helptopic=alternateHelpSystemTopicId

ADF_DataControl|model/AppModule.xml.name=Friendly BC DC name

5. Create a custom metainf file in your local system:




Specification-Title: WebCenter ServiceList TaskFlows
Specification-Version: 11.1.1.0.0
Specification-Vendor: Oracle Corp.
Implementation-Version: JDEVADF_MAIN_GENERIC_080316.1855.4913
Implementation-Vendor: Oracle Corp.
Help-Topic: someHelpSystemTopicId
Bundle-Classes: LibraryBundle

6. Save this as Custommetainf.mf. Create a ADF Library deployment profile.

7. Add Custommetainf.mf in the Jar options while creating the deployment profile.

Thumbnail image for jaroptions.PNG



8. Deploy the jar, and create a file system connection to it. Open it in the resource palette.

respalette.PNG


Note that both the Jar names, and the Data control names are both displayed with customized names that were defined in the resource bundles.

About

Tips and Tricks from Oracle's JDeveloper & ADF QA

Search

Archives
« July 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
31
  
       
Today