Archive for January, 2005

30/1/2005: 1:14 pm: Justin FreemanLotus Domino, Free & Open Source Software

I just love Open Office! It’s free, all data is stored as a zip’d XML, it can be automated using COM (and various other API’s), it can produce quality PDF’s and most importantly, it’s not a Microsoft product. What a fantastic program and an excellent opportunity for integration with Notes.

This database is an example of how to integrate Open Office (OoO) with Lotus Notes using COM automation. It exports information from an Invoice document in a Notes database into a OoO Writer document. The Writer document is then formatted sincely into a printable invoice, then both a completed PDF and OoO version is re-attached to the Invoice document in Notes - all within a few seconds!

I use a variation of this system in my business for sending out invoices to clients and it works really well. Saves me heaps of time mucking around formatting documents etc.

Download the Demonstration
Download the Open Office & Notes Integration demonstration database (200kb)

How To Use The Demonstration Database
In the Invoice by Status view, use the New Invoice button to create a new Invoice. Complete all fields on the Invoice Form (yes, I know there’s a lot, sorry). Create a number of Invoice Detail documents (optional - these are used to breakdown large costs into smaller identiable items). Click the Generate Invoice button to execute the code which will then:

  1. Launch Open Office
  2. Export the Notes data
  3. Generate a OoO file and a PDF file, and then
  4. Attach the Resultant files back to the original Invoice document.

Tip: To make things easier for this demonstration, inheritance has been enabled on the Invoice form, so if you select the existing Invoice document and click New Invoice you’ll get a pre-populated Invoice.

The ooo-template view contains a Open Office document used as a template for the Invoice. To change the Invoice layout, simply change this template.

Other Useful Resources:

  1. It obviously requires an installation of Open Office, download from http://www.openoffice.org
  2. http://api.openoffice.org/DevelopersGuide/DevelopersGuide.html
  3. http://www.ooomacros.org
  4. http://www.oooforum.org

Questions?
If you have any questions about this demonstration, then please contact us.

19/1/2005: 11:32 am: Justin FreemanConsumer Computing

Government Technology World Australia is an ICT showcase event targeted specifically at Government buyers and decision-makers.

The conference will allow companies to demonstrate their ICT products to a wide range of Government consumers. The conference will also address all the strategic issues of sourcing and implementing ICT into all tiers of Government.

The Conference will feature international industry gurus and well-renowned speakers and panellists, discussing their success and experiences and sharing their ICT knowledge and expertise.

The Government Technology World will feature a high level strategic plenary and streams, in the following areas:

  • Storage/disaster recovery/business continuity
  • Information security/Access management
  • Identity Management/Biometrics
  • Systems integrators
  • Customer contact CRM/Billing/Service management
  • Enterprise Content Management ECM/Records Management/Document Management

Government Technology World will be held in Canberra, at the National Convention Centre, on April 27 and 28, 2005.

For more information go to http://www.terrapinn.com/2005/gtw%5FAU/

Or contact:
Steve Congerton, Project Director
(02) 9005 0773
steve.congerton@terrapinn.com

12/1/2005: 9:39 am: Michael ManningFree & Open Source Software, IT General

This one has been a long time coming. It was three months ago that Justin, Darryl and myself attended a Stallman presentation on Free Software. On what had to be one of the warmest afternoons last Spring Richard Stallman, the founding member of the Free Software Foundation (FSF) and developer of the GNU Emacs text editor (one among many other key operating system applications) delivered a speech at the Australian National University on Free Software, some of the philosophies behind it and some of the obstacles now confronting it.

Richard Stallman - Alter Ego

Richard speaks all over the world promoting the philosophies of the FSF and the reasons behind the movement. He covered in detail the four levels of freedom which when applied to software make it free. The freedom he speaks of is a user freedom not a cost freedom. Free software can still cost money to develop. It allows users “to run, copy, distribute, study, change and improve the software” without the need to ask or pay for permission to do so. All of this information and more can be obtained from the GNU web site.

The speech was sincere, as you would expect from a man that has lived his life by these beliefs and has also made a lot of money by following this software philosophy. Richard had real life scenarios which supported each argument of the philosophy. There was also humour thrown in here and there, directed at those oppposing the movement and also at some of the wrong turns they had made in the development cycle of their software.

I know I came away knowing a little more about the movement and a lot more about the man who started the whole thing. One thing it did do was to reinforce what I have believed for a long time. Free Software is a path which gives control of ones own computer to the owner, not to the software which is installed and being used.

Taking this to the extreme Richards’ belief is that you should not use software that is not free as by doing so you are encouraging and empowering those that develop such software and taking away the control you have over your own machine. I tend to agree, to a point, and wish that I could agree wholly. The problem in todays IT world is that a large proportion of the community are already “locked” into using proprietary software and thereby proprietary standards. To support them and develop for them you must develop under those licensing schemes and use those proprietary applications. There are also some really good proprietary applications out there, and these licensing schemes should not be used to discredit the work of the developers which have worked on them or the functions which they perform. Just recently I read an article on NewsForge which presents good arguments for both sides. One of the few articles that I have read which does not seem too biased either way. I don’t totally agree with all that is said, but never the less the author presents some valid arguments.

To sum it up the Stallman FSF speech brought up some really interesting points and vocalised them to a large group. That can’t be a bad thing and I think it was a really good afternoon.