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/21/2018Domino Apps on IOS is a Game Changer. Quit holding back.BOOM. This will be as important for the platform as Traveler. If your company has ditched Notes and Domino, I feel sorry for you. For companies that do use Notes/Domino this is a game changer and Apple should be paying attention. Here's why: There are hundreds of little Notes client applications you'd never spend the time and money to build and deploy for your internal user base on IOS that we use Notes for all the time (those of us still using it). Now, those are suddenly ALL available on the iPad. ...... 
  2. 02/15/2018Andrew’s Proposed Gun LawsThese are my current thoughts on gun laws that would radically change the culture and safety of gun ownership in the United States without removing the rights of gun owners or compromising their privacy rights. * Please feel free to link to, or just copy, these ideas. It would be wonderful to see them spread widely and eventually become the basis for something to rally around and become legislation. Update: 3/3/2018 I added #7, increasing the age to purchase. Update: 4/27/2018 Please be aware that I am not ...... 
  3. 05/05/2016Is the growing social-sourced economy the modern back door into socialism?Is the growing social-sourced economy the modern back door into socialism? I read a really insightful post a couple of days ago that suggested the use of social network funding sites like “Go Fund Me” and “Kickstarter” have come about and gained popularity in part because the existing economy in no longer serving its purpose for anyone who isn’t already wealthy. Have the traditional ways to get new ventures funded become closed to all but a few who aren’t already connected to them and so onerous as to make ...... 
  4. 04/20/2016Want to be whitelisted? Here are some sensible rules for web site advertising 
  5. 12/30/2015Fantastic new series on Syfy called “The Expanse” – for people who love traditional science fiction 
  6. 10/20/2015My suggestion is to stay away from PayAnywhere(dot)com  
  7. 08/07/2015Here is one for you VMWARE gurus - particularly if you run ESXi without fancy drive arrays 
  8. 08/06/2015The Killer of Orphans (Orphan Documents) 
  9. 06/02/2015Homeopathic Marketing: Traveler on my Android is now calling itself VERSE. Allow me to translate that for the IBM Notes community... 
  10. 03/17/2015A review of British Airways Premium Economy Service – How to destroy customer goodwill all at once 
Click here for more articles.....

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

Please wait while your document is saved.