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.
You want to move to Domino? You need a plan!
Thu, Apr 17th 2014 6:12a Stephan H Wissel Cloud services are all en vogue, the hot kid on the block and irressitible. So you decided to move there, but you decided your luggage has to come along. And suddenly your realize, that flipping a switch won't do the trick. Now you need to listen to the expert.
The good folks at Amazon have compiled a table that gives you some idea how much it would take to transfer data:
Available Internet Connection
Theoretical Min. Number of Days to Transfer 1TB at 80% Network Utilization
T1 [read] Keywords: domino
Mustache and CKEditor - Round two
Mon, Apr 14th 2014 9:11a Stephan H Wissel ving just a few static values in the CK Editor drop down list really doesn't cut it. So we extend the bean today to have more flexible options. There are a few that spring to mind:
List of all items in a given document
List of all fields in a form (including subforms), eventually with or without the $ fields
List of provided field names
So here we go:
Mustache and CKEdit demo
The big change here is the replacement of the EL Expression mustache.sampleData wit [read] Keywords: ibm
Lotus de la Mancha
Wed, Apr 9th 2014 10:12a Stephan H Wissel One of my personal heroes is Don Quixote de la Mancha. He is a bat-shit crazy knight, who is true in his courtship of his Lady Dulcinea and never tired to pick a fight with a giant (windmill). His charge against the windmills, is regarded as a result of his craziness, but digging deeper you will find a nobility, worthy of a true knight: stand in for what you deem is right, regardless of the odds of success. Being true to your calling resonates with me. Wikipedia has an image of the crest of La [read] Keywords: lotus
CKEditor and Mustache become friends
Tue, Apr 8th 2014 9:11p Stephan H Wissel In the beginning there was WordStar and CSV and the possibility of (then printed) personalized mass-communication arrived in the form of mail-merge. For Notes eMails that is still a challenge (the latest version of OpenOffice now seems to have a reasonable eMail-Merge, but that's off topic here) since creating the template is kind of fuzzy (a.k.a usually out of the reach of mere mortal users).
XPages, Mustache and CKEditor to the rescue! The CKEditor shipping with XPages can be easily customiz [read] Keywords: ibm
MongoDB to switch to IBM storage backend
Tue, Apr 1st 2014 6:12a Stephan H Wissel One of the rising stars in NoSQL land is MongoDB. It is prominently featured in IBM BlueMix and in conjunction with Node.js the darling of the startup scene.
However it isn't trouble free, has been called broken by design, bad for data and a folly.
In a bold move to silence all critiques, the makers turned to IBM to get access to a distributed, robust and secure backend storage engine: the venerable NSF. As Bryce Nyeggen clearly stated:"But actually, thatâ€™s the Tao-like genius of MongoDB â [read] Keywords: ibm
Communicate with a German
Tue, Apr 1st 2014 6:12a Stephan H Wissel It was going around for a while, how to decode what an English man actually means when he says something. A Harvard Business Review article attributes the insights to Nannette Ripmeester's research and insights. What I was missing in all those tables is the reverse translation. So here it goes:
What a German saysWhat the British should hearWhat the German meant
Bad idea!Please think about that some moreBad idea! But I will still drink beer with you
This won't workInteresting approach, qui [read] Keywords: google
On a quest for the best biking application
Thu, Mar 27th 2014 9:11p Stephan H Wissel Preparing for my June adventure, I'm tracking my cycling progress. So far I tried Endomondo, RunKeeper and had a look at Strava. They all have their ups and downs:
Endomondo doesn't provide a open data API and I never got the live broadcast working, but the UI is readable on a bike
RunKeeper UI is too tiny for cycling mount, but live broadcast works nicely and the data API is open
Strava doesn't seem to provide live updates, but rather tracking after the tour
Battery live sucks for all of th [read] Keywords: application