Friday, October 10, 2008

Day 2, Monday September 22nd 2008

Creating Advanced Charts in Oracle Application Express

This session was interesting because of the majority of the projects I work on do not include charts. It was nice to see that simple customizations that take a few minutes make a difference in the look of a report. Presently Apex uses Anychart 3 for chart reports. The latest version or Application express 3.1 uses Anycharts 4 for the interactive reports.
A nice live demo cap off the session with subjects such as drill-down charts and reports, adapting scales, customizing with copyright and logos, and security.

Developing a Real-World Logistic Application with Oracle Application Express

We got to see in this session very nice things that Roel Hartman developped using JavaScript/Ajax. Many attendees(including myself) were amazed with the drag & drop features in the calendar. Very nice features for demanding users.

Migrating from Oracle Forms to Oracle Application Express

This session was one of my most anticipated ones at Open world. I have lots of clients that are waiting to convert their old forms applications to Apex.

Oracle Apex form conversion is
- A way to jumpstart an Oracle Forms to Apex modernization project.
- Automatic conversion of forms components that can be automatically converted to native Apex components.
- An easy way to browse your Forms application logic.
- A convenient tool to track manual conversion of Triggers and other non-convertible logic.

Oracle Apex form conversion is NOT
- A "Silver Bullet" (push a button and voila solution)
- A Forms emulator
- Hard to maintain computer-generated code

How does it work ?
1) Your forms must be 6i, 9i or 10g
2) From Forms builder generate an XML file of your FMB file
3) In Apex, create a project and load your XML file
4) Choose objects that will not included in the conversion like control and navigation blocks
5) Generate the Apex application
6) Since triggers will not be converted automatically, you will have to do it yourself. There will be a list of all objects that were not converted. A tool will help us track these objects to convert/work on them.
7) Other customizing will be required since we are coming from a client-server application towards a web based application.
All in all, the conversion process is not a simple task. But still, it provides us with a good head start toward a Form to Apex conversion.

The Forms migration is part of version 3.2 of Apex or is version 3.2 should I say, and it is due out soon :)

Oracle Application Express Mashup

What is a mashup you ask. Well, here is Simon Boorsma's (the presenter) definition of a mashup : Collect and combine data, functionality and sources for single entry use.

Here are a few pretty cool tools he uses to do his mashup :
Dapper, Yahoo Pipes, Popfly.
Here are a few very interesting mashup examples :

Flickr, Photosynth.

Web 2.0 Development with Oracle Application Express

I think that this was one of the most interesting session of the week. I must start looking into JSON and JQUERY. I am also looking forward to dynamic actions.
Here is the link to Carls' blog where you can get mutch more details about his presentation.

No comments: