Andrew Pollack's Blog

Technology, Family, Entertainment, Politics, and Random Noise

Some good old back to basics Domino code this week

By Andrew Pollack on 03/14/2008 at 09:53 PM EDT

The nature of my practice is that I focus on the real specialty stuff and don't really get to do basic web apps very much. The last few days I've enjoyed working on classic Domino web app though. With all the time spent focusing on Javascript fanciness, AJAX, and pages that don't look like pages you can forget what a joy it can be to just let the server do the work.

Some of the built in features have come a long way since the last time I used them. Embedded html views with selectable entries and buttons that trigger agents worked like nobody's business. I was able to toss a little CSS around them and do some really good work.

Here's a twist on an old trick. I've done it before in agents, but never as an embedded view.

Create a view for export, but in the view properties, mark it so that it treats the contents as html. In the first column, just put "<tr><td>" then between each column of data use "</td><td>", and at the end, add "</td></tr>".

Embed that on a page, as an html view (not a java applet) and surround it with <table> before and </table> behind. On the page properties, select path type "Other" and type in "application/excel". Name the page "export.xls" and when a user gets directed to the link, the whole thing opens as a spreadsheet.

The nice twist on using an embedded view, is that you can you can duplicate it, change it up, and quickly change the columns around.

Since views normally get rendered as tables anyway, I've thought about just leaving it the way it is and letting it render in the page to see what excel does it in its native rendering.


There are  - loading -  comments....

re: Some good old back to basics Domino code this weekBy mdmadph on 03/17/2008 at 05:42 PM EDT
That is so disgustingly easy it's... disgusting. I had heard of other
frameworks having to construct Excel output manually via Java and the like --
glad to know we've got it easier!


Other Recent Stories...

  1. 03/26/2019Undestanding how OAUTH scopes will bring the concept of APPS to your Domino serverWhile a full description of OATH is way beyond what I can do in this quick blog entry, I wanted to talk a bit about how "SCOPES" interact with the already rich authorization model used by Domino. Thanks to the fantastic work by John Curtis and his team, the node.js integration with Domino is going to be getting a rich security model. What we know is that a user's authorizations will be respected through the node.js application to the Domino server -- including reader names, ACLs, Roles, and so on. The way ...... 
  2. 02/05/2019Toro Yard Equipment - Not really a premium brand as far as I am concernedDear Toro Customer Service, I arm writing about the following machine: Toro Power Max 1120 OXEModel:38654S/N:31000#### Specifically, bearing part #:63-3450 This is the part ($15 online / $25 at the local dealer) that caused me to raise my objections on-line. This piece of garbage is supposed to be a bearing. It carries the shaft which drives both stages of the auger. The shaft passes through the bearing (which is what bearings do) after the auger drive pulley as the shaft goes through the back (engine ...... 
  3. 10/08/2018Will you be at the NYC Launch Event for HCL Domino v10 -- Find me!Come find me in NYC on Wednesday at the Launch Event if you're there. I really do want to talk to ...... 
  4. 09/04/2018With two big projects on hold, I suddenly find myself very available for new short and long term projects.  
  5. 07/13/2018Who is HCL and why is it a good thing that they are now the ones behind Notes and Domino? 
  6. 03/21/2018Domino Apps on IOS is a Game Changer. Quit holding back. 
  7. 02/15/2018Andrew’s Proposed Gun Laws 
  8. 05/05/2016Is the growing social-sourced economy the modern back door into socialism? 
  9. 04/20/2016Want to be whitelisted? Here are some sensible rules for web site advertising 
  10. 12/30/2015Fantastic new series on Syfy called “The Expanse” – for people who love traditional science fiction 
Click here for more articles.....


pen icon Comment Entry
Subject
Your Name
Homepage
*Your Email
* Your email address is required, but not displayed.
 
Your thoughts....
 
Remember Me  

Please wait while your document is saved.