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.
Evolution of the Self
Fri, Nov 29th 2013 7:16a Stephan H Wissel We all are are somebody some body more than others, but at least we want to be somebody. Interestingly build into us it the opposite wish: disappear, be nobody. We are masters to disguise that wish: 3 hours in the movies, when it sucked you in, where were you? Working on something exiting, getting into the flow, where where you? Your self disappeared! But it doesn't stop there
There is a third level of self: the Everybody self. The Rotarians would call it Service above self. Lama Marut calls [read] Keywords: wiki
eLearning - are we there yet?
Sat, Nov 9th 2013 11:11p Stephan H Wissel having two teenagers in two of Singapore's top schools, friends providing eLearning solutions and interesting conversations led me to a lot of interactions with schools, teachers and other educators. The education space is getting more and more attention from technology companies and passionate educators:
The Khan Academy provides an ever growing K12 syllabus, that rivals top schools
Coursera offers higher education as does ED/X (I still would love to work at the MIT)
Intel buys Kno and become [read] Keywords: google
Aggregating view data for use in d3js graphics
Tue, Sep 24th 2013 7:11a Stephan H Wissel Dashboards are all the rage, so it is natural that your XPages application need a dash of a dashboard. A view makes an excellent source for dashboard data and the ability to categorize views handles the heavy lifting of aggregating the values you want to use e.g. in a bar or pie chart. I've been fallen in love with d3js since she is the ultimate visualization (if in doubt, read the classics).
D3Js is a harsh mistress of exceptional beauty, so you might want to check out some of her offsprings [read] Keywords: xpages application
Notes addressbook sync with IBM SmartCloud
Thu, Sep 19th 2013 12:11a Stephan H Wissel Every organisation has its little secrets. The running joke about IBM is, that the secret are the products.
When you use IBM SmartCloud for Social Business Engage (SCSB) you get a contacts feature. It will list all your network contacts, but also is able to list arbitrary contacts, serving as your address book. Latest since the arrival of mobile devices however the saying goes: "only a synced contact is a good contact".
Well hidden in the SCSB help are the instructions how to sy [read] Keywords: ibm
Extend the Replicator
Tue, Aug 20th 2013 5:35a Stephan H Wissel One elegant way to improve perceived performance is to run computing task outside of user time. In Notes that is done using (scheduled) agents and scheduled replication (On mobile devices it is called PushMail ). When you have longer running tasks that only make sense when new data might have arrived, a scheduled agent doesn't make much sense.
Triggering a process "On Replication" is much preferable. Classic Notes agents don't have this ability, but the Notes full client can do that. Alread [read] Keywords: agent