Screencast: Using ERExcelLook

Project Wonder’s ERExcelLook is a framework that leverages Direct To Web and the ExcelGenerator framework to easily generate Excel exports. I just finished a short screencast on adding it to an existing project. The topics covered are:

  • Adding Direct To Web to an existing project
  • Adding and action to trigger an .xls export for an array of entities
  • Creating a new model file
  • Modifying the rules

Links for the screencast:

  • There is an archive of the completed sample project available here.
  • The project is based on the Movies database, and a MySQL dump is available here.
  • The Rule Modeler tool used in the screencast can be found here.
  • The screencast itself can be found here.

I hope you enjoy it, let me know what you think.

Update: Dave Holt points out that you can specify the worksheet name by adding it in parenthesis as the first item in your displayPropertyKeys array. i.e:

(
    "(WorksheetName)",
    "title",
    "dateReleased",
    "category",
    "studio.name"
)

Advanced track at WOWODC 2009 East?

WOWDC 2009 West (held just before WWDC) was an outstanding success (and I’m not just saying that because I presented 🙂 ) We had a gathering of very knowledgeable and talented WO developers and the conversation over dinners and breaks was as illuminating and educational as the sessions themselves.

Pascal is working feverishly on hammering the videos into shape and working hard on planning WOWODC 2009 East to be held in Montreal late in August.

Our plan for WOWODC 2009 East is for a conference focused on getting novice WO developers up to speed on the tools and frameworks. The sessions we have planned should teach you how to setup and use the tools, understand the frameworks, and build your applications using the best practices around.

However, this year’s WOWODC West also made it clear that there is a lot of value for more advanced developers in simply being able to share their experience with one another. So we are thinking about adding a second track to WOWODC East. A second room for more advanced sessions, labs, and case studies.

For this to happen though, we will need your help. Are you interested in hanging out in Montreal with a bunch of other crazed WO developers? Would you be interested in hosting a lab, presenting a case study, or giving a session on a topic that is near and dear to your heart? Either way, please take a moment to fill out our latest survey (hosted by the kind folks at survs.com).

We also heard from several people that they didn’t know about WOWODC West and/or the other surveys we’ve run this year. If you know of any WebObjects developers who don’t follow the mailing lists or Twitter feeds (wowodc, wocommunity), or know about the WOCommunity organization, please spread the word!

Alternate D2W Looks

A Direct To Web Look is a set of templates for the common task pages that defines the look and feel of the application. In the bad old days the templates were heavily table based and many of your rules would end up setting display parameters (like table cell background colour etc.)

Thankfully this is changing. I demoed Ravi Mendis’ amazing ERDivaLook (now part of Project Wonder) at WOWODC 2009 West, but since then several others have come to light. So here is a list of the Looks that I know about (excluding the ones from Apple)

  • Project Wonder – ERDirectToWeb – Though technically not a Look, the templates in ERDirectToWeb can be duplicated with Wonder’s Template_creator.pl script and can be used as the basis for your own look. Heavily leverages the power of D2W to offer massive flexibility. Not a good choice for a first attempt at creating your own look but definitely worth looking at for ideas.
  • Project Wonder – ERNeutralLook – A nasty old school Look with lots of table based layout. However, ERNeutralLook can easily be duplicated using the Template_creator.pl script and is simple enough to be useable as the basis for your first attempt at creating your own Look
  • Project Wonder – AjaxLook – I’ve not used or investigate this Look at all. However my understanding is this it is an experiment only and not ready for prime time.
  • Project Wonder – ExcelLook – This very useful Look is a bit of an oddity in that it is not designed to create an end user interface. It does however, generate easily customizable Excel exports to any application. Look for a screencast on this one soon.
  • Project Wonder – ERDivaLook – A very powerful Ajax enabled, XHTML 1.0 strict, semantic markup based Look that looks like it will be amazing once it is completed. It is currently under heavy development and has dependencies on the new WO2 framework and requires WebObjects 5.4.x. Keep an eye on this one.
  • DMSimpleLook – Used by Denis Frolov as part of his SiteMonitor demo at WOWODC 2009 West. It is a simple look with only a few templates but may be a good starting point as the basis for your own look. The SiteMontior project is available here.
  • R2D2W – Ramsey Lee Gurley’s custom Look. This look boasts XHTML 1.1 strict compliance, Section 508 compliance for accessibility, RSS, inline SVG, and user management. I haven’t explored this one in detail yet, but it definitely looks interesting. The project page is here.
  • EVDirectToWeb – Guido Neitzer’s custom Look. Currently listed as unstable pre-alpha so take that under advisment. The project page including screen shots is here.

If you know of any other D2W Looks that are released into the wild, or have any additional experience with any of these. Let me know.

Update: Oops, forgot Guido’s EVDirectToWeb

Direct To Web

At WOWODC this weekend I gave a talk on Direct To Web that spurred a lot of interest which I was thrilled to see.

Getting started with D2W is not an easy task and I owe a massive debt to the two chapters in the Wrox book: Professional WebObjects 5.0 with Java which is sadly out of print. The book was a team effort but I believe that Jim Roepcke wrote those two chapters and is still involved in the WebObjects community. I would like to send a big thanks his way.