Ashish Awasthi's Blog

Monday, 16 June 2014

Creating and Exporting hierarchical data to excel using dvt:pivotTable & dvt:exportPivotTableData in Oracle ADF

Hello All,
This post is about exporting tree structured(hierarchical ) data to an excel file.
suppose we have export department wise detail of employees , we can achieve this in ADF using pivot table (<dvt:pivotTable>)

What is pivot tabel (oracle docs)-

UIComponent class: oracle.adf.view.faces.bi.component.pivotTable.UIPivotTable
Component type: oracle.dss.adf.pivotTable.PivotTable
The Pivot Table supports the display of multiple nested attributes on a row and column header. In addition, the Pivot Table supports the ability to dynamically change the layout of the attributes displayed in the row or column headers via drag and drop pivoting.
now see the implementation part -

Create a Fusion Web Application using HRSchema , for this sample app i have created a view (Department Wise Employees) to export data

CREATE OR REPLACE FORCE EDITIONABLE VIEW "APP_USR"."DEPT_EMP" ("DEPARTMENT_NAME", "EMPLOYEE_NAME", "SALARY") AS 
  SELECT A.DEPARTMENT_NAME, B.FIRST_NAME,B.SALARY FROM DEPARTMENTS A, EMPLOYEES B WHERE A.DEPARTMENT_ID=B.DEPARTMENT_ID (+);

Prepare model using this view

Create a page and drop this view as pivot table (ADF Faces component) from data control

Now configure pivot table (set row & column attributes, insert appropriate drilling) - see the snaps

Now run your page and see working pivot table - here pivot table is created successfully

Drop a button and a <dvt:exportPivotTableData> under button to export pivot table

<af:commandButton text="Export" id="b1">
                    <dvt:exportPivotTableData type="excelHTML" exportedId="pt1" filename="Dep_Empl.xls"
                                              title="PivotTable export"/>
                </af:commandButton>

Run your page and click on export button and see your tree structured data in exported excel file

Cheers :) Happy Learning Sample ADF Application

Tuesday, 10 June 2014

Export ViewObject dataset to XML, Generate customized XML file using ViewObject in Oracle ADF

Hello All,
this post is about exporting a viewObject data to a XML document.
Sometimes we need to generate XML document with the same data in ViewObject, for this ADF provides a facility to directly export data to a XML document using ViewObjectImpl class

See the steps to generate XML for a ViewObject

Create a Fusion Web application and model using HR schema (Departments & Employees) table (master detail relation using viewLink)

Now to generate XML, i have used writeXML method of ViewObjectImpl class, it produce XML using two parameters

from oracle docs-

writeXML(int depthCount, long options)

XMLInterface.XML_OPT_ALL_ROWS

XMLInterface.XML_OPT_LIMIT_RANGE

created a method in DepartmentsVOImpl class to export data to XML, added it to client Interface

    /**Method to generate XML from ViewObject data
     * @param level
     * @return
     */
    public String writeVoToXml(int level) {
        FileOutputStream out;
        ByteArrayOutputStream opStream = new ByteArrayOutputStream();
        try {
            // Generating XML for All rows and adding it to Output Stream
            ((XMLNode) this.writeXML(level, XMLInterface.XML_OPT_ALL_ROWS)).print(opStream);
            System.out.println(opStream);
            // Creating a XML document in D Drive
            out = new FileOutputStream("D://Departments.xml");
            out.close();

        } catch (Exception e) {
            System.out.println(e.getMessage());
        }

        return opStream.toString();

    }

Now run application module to execute method and see generated XML on console

i have created a simple page with a af:codeEditor to show generated XML , button to generate XML and a spinner to pass depth level of viewLink accessor

In case depth level is '0' , it export data only for Departments viewObject

Change level to '1' , Now it generate XML for Departments --> Employess relation

now to how to customize XML ? How to change default tags for attribute names and rows ?
To change attribute label (tag in xml)- Suppose i have to change DepartmentName to Name in XML
Add attribute level custom property named XML_ELEMENT to a value AnyOtherName to change the XML element name used for that attribute

To change Row label (tag in xml)- Suppose i have to change DepartmentsVORow to DepartmentLine in XML
Add ViewObject level custom property named XML_ROW_ELEMENT to a value AnyOtherName to change the XML element name used for that Row

Now Run and see generated XML -

Cheers :-) Happy Learning

Sunday, 8 June 2014

ADF Basics: Using CSS to change appearance of application (Skins and Styles in ADF Faces)

Hello All
This is a basic post about using CSS in ADF applications, how can you change appearance of ADF application using Skins (.css file)
See the steps to create and apply css in your ADF applications

Create a Fusion Web Application and create a page
Add Some ADF Faces component (input text,button,panel box, panel collection etc)
Now to change appearance of default ADF Faces components , create an ADF Skin
Right click on ViewController--->New--->Web Tier--->JSF/Facelets--->ADF Skin

By default ADF Skin name is like skin1,2 etc

After creating ADF Faces skin open it and, on left you will see all components as Button, Layouts, Output text and so on. this is ADF Skin Editor

Now expand the components that you want to change , change it's color(on active, focus , hover etc) and other properties. See in image below

After creating your ADF Skin ,open trinidad-config.xml file in Jdeveloper editor and your will see like this

<skin-family>skin1</skin-family>

now if you another ADF Skin file- skin2 then in trinidad-config.xml, it will be changed to

<skin-family>skin2</skin-family>

ADF automatically choose the most recent skin, so here this is done , now create and configure your ADF Skin and customize appearance of application
For more details see Oracle Docs- http://docs.oracle.com/cd/E16764_01/web.1111/b31973/af_skin.htm