We all know "Notes doesn't print". Nevertheless the topic of document output and reports is not going away, even if I'd like to ban the reports. There are plenty of ready made tools, but today I'd like to start with home cooked reporting.
Why the effort? Using only tools that use open standards you gain more control over the whole process and you can use whatever deems fit. The downside: it is more things you need to know and might not be suitable for business users (but its great to torture interns). In the long run you have a portfolio of source transformations that you can combine potentially faster than any reporting tool. The general principle is "Extract Transform Render":
Extract: Whatever will pull out the XML for the second step will do the trick. For list type of rendering ?ReadViewEntries will do the trick or simple DXL exports. Quite often you might opt for some bespoke code to extract code with an eye of a fast and/or easy transformation phase. You also might consider to extract your data in conformance with an established international standard
This step usually takes the XML from the extract phase and runs it through one or more XSLT transformations. XSLT is kind of IT Black Magic (other say it's just settheory) and can use quite some computing power. For high performance the pros use a dedicated applicance. Once you get the heck of XPath you can do some amazing reporting (e.g. "give me all sales guys where withing the last 5 sales of the 3 guys next to his ranking there was a carpenter")
Rendering is easy. The outcome of the transformation step will be XSL:FO which is a page description language. Use a free renderer or a commercialoffering and a few lines of code. The output typically is a PDF file, but you can target graphic formats too.
Rethinking Social Software
Sat, Mar 1st 2014 5:11a Stephan H Wissel Einstein is attributed with a famous quote:"Everything should be made as simple as possible, but no simpler." (called Einstein's razor, the counter balance to Occam's razor). Looking at the social software landscape today I must conclude that it is both too simple and not as simple as possible.
In the "too simple" camp with have the notion: "everything is just one big stream of collaboration and a few tags will do" (and it's variations). If you follow this notion all collaboration you w [read] Keywords: collaboration
Numbers are numbers, you have to see it! - Selenium edition
Sat, Feb 15th 2014 8:11a Stephan H Wissel When looking at performance data and comparisons, numbers are just that: "X is 23% faster than y" is a statement few people can actually visualize. You have to see it in action to get a feel for the real difference. Applies to vehicles and web sites in the same manner.
Instinctively one would opt for a load test to see loading speeds, but after checking options I found a functional test will do just fine. My tool of choice here is Selenium WebDriver. It can be easily integrated into JUnit tes [read] Keywords: ajax
The perception of emptiness
Mon, Feb 10th 2014 7:11p Stephan H Wissel In an ACI Singapore class I'm studying Master Shantideva's famous work "A Guide to the Bodhisattva's Way of Life" (Bodhicaryavatara). A recurring tenant in his, or any other deep Buddhist teaching, is the concept, that the perception of the world around us isn't coming at us, but from us. Objects around us have no inherit nature without being observed (did the tree in the forest fall if nobody sees it?). The true nature of things is emptiness which Buddhist practise tries to perceive on th [read] Keywords: apple
Download Connect 2014 presentation files
Tue, Feb 4th 2014 5:10a Stephan H Wissel The show is over and the annual question arises: how do I download all the presentations? To do that, you will need a valid username and password for the Connect 2014 site, no anonymous access here. The 2014 site is build on IBM Portal and IBM Connections. IBM Connections has a ATOM REST API, that opens interesting possibilities. With a few steps you can get hands on all files. I will use CURL to do this.
Create or edit your .netrc file to add your Connect 2014 credentials (in one line)
machin [read] Keywords: connections
GMail2XPages in less than 300 lines
Tue, Jan 14th 2014 11:11a Stephan H Wissel I admit, the headline is an attention grabber
The total number of lines is, of cause, longer. For one, I used previous code, as well e.printStackTrace() isn't error handling.
Moving data between two places is a favorite IT pasttime (believe me, there are worse ways to kill time). Since I made friends with MIME Messages before, I was wondering how that would fit together with gMail. Every eMail system has its little "specialties". To connect to gMail I used the IMAP with username and passwo [read] Keywords: ibm
Using a web service to send an eMail
Sun, Jan 5th 2014 10:11p Stephan H Wissel In an integration project with other platforms the need arose to send messages that are triggered by a web service. In Domino this is just a few lines of code. Added bonus: the message is fully "embedded experiences" enabled. This is the LotusScript class:
Public Class SendADocumentWithPDFAttachment
Public sendTo As String
Public subject As String
Public textBody As String
Public htmlBody As String
Public callBackURL As String
Public attachmentAsMime As String
Public Function sendM [read] Keywords: domino