sage computing services · sage computing services. ... – plsql driven integration. sitemap •...

33
SAGE Computing Services Customised Oracle Training Workshops and Consulting Portal Wizardry Adapt, Alter and Augment Portal behaviour and features Ray Tindall Senior Consultant

Upload: buihanh

Post on 08-Jun-2018

220 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

SAGE Computing ServicesCustomised Oracle Training Workshops and Consulting

Portal WizardryAdapt, Alter and Augment Portal behaviour and features

Ray TindallSenior Consultant

Page 2: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

Let’s cut the …

And get to the point

• WYSIWYG Editor

• Dynamic Sitemap

• Alter / Augment Built-ins

Date Picker

and ...

Page 3: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

The “REAL” Title

Portal Wizardry

Hacking the Portal GUIJavascript/CSS

&3rd Party Stuff

Warning / Disclaimer

Page 4: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

WYSIWYG Editor

• What is it?

– WYSIWYG HTML content editor plug-in

Page 5: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

WYSIWYG Editor

<DEMO>

Page 6: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

WYSIWYG Editor

• What are the concepts?

– Opensource

– Freeware

– Javascript / CSS

– Plug-in

Page 7: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

WYSIWYG Editor

• The Source / Resources– 3rd Party

• FCKeditor• FredCK.com (Frederico Caldeira Knabben)• http://www.fckeditor.net/• > http://docs.fckeditor.net/ <

– Oracle• Tech: “Oracle Application Server Portal 10g Release 2 (10.1.4) –

Enhanced Rich Text Editor”

• Tech: “OracleAS Portal 9.0.4.1 – Enhanced Rich Text Editor”

• Ahhhem & OTN forums

OK - Dubious namebut it works & it’s free!

Page 8: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

WYSIWYG Editor

• How– Installation… the basics

• Turn on Portal RTE (per page group)

• Download FCK source (js/css version)

• Copy & Unzip to OAS file system

• Customise editor as required

• Replace portal/images/wordweb/buildUIHTML.html (10.1.4)

or portal/images/buildUIembed.html (9.0.4.1)

as case may be

• Invalidate the OAS Webcache& clear Browser cache

• Test / Tshoot / Tweak

Page 9: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

WYSIWYG Editor

• But I want to…

– Configuration• Menu Options and …

– Runtime Manipulation• Is What You See What You really Get?

Page 10: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

WYSIWYG Editor

<DEMO>

Page 11: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

WYSIWYG Editor

• Quick Gotchas

– Portal versions• 9.0.4 vs 10.1.4

– Tag Nesting• Is that really Heading 1 ??

– Extensions / Dialogs vs Portal• Not all will work

– FCK Updates• Fixes & enhancements

Page 12: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

Sitemap

• What is it?

– Repository generated Interactive Sitemap

Page 13: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

Sitemap

<DEMO>

Page 14: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

Sitemap

• What are the concepts?

– Opensource

– Freeware

– Javascript / CSS

– PLSQL driven integration

Page 15: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

Sitemap

• The Source / Resources– 3rd Party

• JavaScript.CoolDev.Com• COOLjsTree• http://javascript.cooldev.com/scripts/cooltree/

– Oracle• good old htp.p

Page 16: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

Sitemap

• How– Implementation / Integration… the general idea

• Categories or Perspectives driven

• COOLjsTree js & css

• The cool side

• The data / code side

• The Portal side – stitching it together

• How– Implementation / Integration… the general idea

• Categories or Perspectives driven

• COOLjsTree js & css

• The cool side

• The data / code side

• The Portal side – stitching it together

Page 17: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

Sitemap

• But I want to…– Configuration / Customisation

• Placement

• Extend eg expand all, expand node…

– Quick Gotchas• see above - Customisation

– ps ADF/JSF• Yes, but…

Page 18: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

Hacking Built-ins

• What is it?

– Hacking Custom Search Portlets

• Navigation Controls

• Jump to feature

Page 19: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

Hacking Built-ins

<DEMO>

Page 20: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

Hacking Built-ins

• What is the concept?

– Purely basic & dirty Javascript / CSS hacking

Page 21: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

Hacking Built-ins

• The Source / Resources

– Leave Best Practice at the door please

– Ingenuity / Parallel thinking

– W3Schools?... Other js/css gurus

– Google

Page 22: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

Hacking Built-ins

• How– The Approach

• Find a hook

• Create a script or library to exploit the hook

• Call your exploit (override) at runtime

– Again in English…?

Page 23: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

Hacking Built-ins

• But I want to…– ??? the Possibilities…

• Minor changes to built-ins

• Simple/Minor form element changes– Size of text box

– Same technique• Find a hook & exploit it; mimic; override

Page 24: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

Hacking Built-ins

• Quick Gotchas

– Don’t look sideways at it!

Page 25: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

Date Picker

• What is it?

– Calendar Popup

• You mean Portal doesn’t have one?

Page 26: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

Date Picker

<DEMO>

Page 27: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

Date Picker

• What, Where, How– Concept

• 3rd Party Component• HTML form & js hack

– Source / Resources• nsftools DatePicker• nsftools.com (Julian Robichaux)• http://www.nsftools.com/tips/NotesTips.htm#datepicker

– How• Download component js / css • Integrate it to your Form component

Page 28: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

So what are you saying?

• The underlying messages– Not all that Hard

– Opensource & Freeware(Community)

– Javascript / CSS

• Supported (3rd Party)• Hack…errrr.. Integrate with Portal

– PLSQL to drive plug-ins

Page 29: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

and...

• Look around; what else is there…– ULTRA quick & dirty sitemap (Portal’s own)

– COOL Menu & other components

– Scriptaculous

– APEX

– and Sylohe (Sylohe Applications)• Forums app

• Calendar

• FAQs

Page 30: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

Sylohe Forums

<DEMO>

Page 31: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

Thankyou/s & References

• Thankyou– Dept of Water WA– Dept of Environment & Conservation WA

• Notable References– FredCK.com (Frederico Caldeira Knabben)– Oracle (Oracle Technology Network)– JavaScript.CoolDev.Com– nsftools.com (Julian Robichaux )

Page 32: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

SAGE Computing ServicesCustomised Oracle Training Workshops and Consulting

Presentations are available from our website:http://www.sagecomputing.com.au

[email protected]@sagecomputing.com.au

Page 33: SAGE Computing Services · SAGE Computing Services. ... – PLSQL driven integration. Sitemap • The Source / Resources ...  Hacking Built-ins • What is the concept?

SAGE Computing ServicesCustomised Oracle Training Workshops and Consulting

The next best thing will be to attend Sage's course in advanced development techniques to be held early July.

Advanced Developers Workshop (3 days)Presented by Penny Cookson and Chris Muir

- Advanced SQL techniques- Advanced PL/SQL techniques- Application performance tuning- The best of version 10g and a look at what’s available in 11g.

Contact Penny Cookson [email protected] to register.