Moving on with Excel Export part 5 : XPages Export
Sun, Mar 29th 2015 2:27p Fredrik NorlingIn the previous parts (Part 1 Part 2 Part 3 Part 4) we covered plain export, styling your exports and doing selective exports. Today I want to show you how to create more advanced and flexible way to get your data using a java object that we use for the export.
We start by creating 2 java classes one for the export and one of the Export Data
Then in each class add implements Serializable and the private variable on the row below. This is so the java VM can swap the data out disk if needed.

27

Moving on with Excel Export part 4 : XPages Export
Wed, Mar 18th 2015 2:38p Fredrik NorlingThe recent parts of this series has shown you how to create excel exports from a view and also changing the layout of the reports with headers and logos. This post will show you how to filter the data in your excel reports both using keys and fulltext searches. Let’s get started.
To get some filtered export we add an combobox into our XPage and in this case to show both a Export with a key and search we have two buttons for the different export options.
The code behind the com

10

Moving on with Excel Export part 3 : XPages Export
Thu, Mar 12th 2015 6:20a Fredrik NorlingMaking you report look a bit nicer with some formatting.
Excel reporting from views can be so dull and boring the XPages for POI can give you more options in this matter and help you create some design to your report.
1. Customizing your template
Because POI is using a copy of you template you can customize your temple with logos and predefined information.
We need to import this new template and change the startRow and template name
In this case we start at row 12 below the logo and

6

Moving on with Excel Export part 2 : XPages Export
Tue, Mar 10th 2015 4:38a Fredrik NorlingIn my last post I wrote about how to in some simple steps generate an automated export of an view to excel. In this post I will show you how to fine grain this using the excel component instead.
Start by creating a blank excel file note what the sheet you want to place data on is called usually Sheet1 if you have an english version of Excel. Save and import it as a file resource in the database, name it export.xlsx
Now create a new XPage add a button and the Excel component POI Workbook

8

If your user want reports in Excel you should read this
Mon, Mar 9th 2015 5:23p Fredrik NorlingXPages did get a great addon more than a year ago to be more exact 13:th of September 2013. It was when C
hristian Güdemann uploaded the first version of POI for XPages. Apache POI is a rather old apache project, 13 years to be exact. And there have even been a Notes in 9 show by Paul Calhoun on how to use the standalone version of Apache POI.
But Christians version makes everything that much simpler to get the Excel file out to the end user, start by going to poi4xpages.openntf.org/ or ess

11

News from IBM ConnectED15
Mon, Jan 26th 2015 7:30p Fredrik NorlingSome of the news from IBM Connect
IBM releases early access to IBM Verse. http://ibm.co/1BfM4S1
IBM Verse will come an an Domino solution for on premise deployment later this year
The Domino HTTP engine will get more updates that the previous released updates with SHA2 and TLS 1.0
It will get new HTTP security options as TLS 1.2, PFS and AEAD
the IBM HTTP server addon released with Domino 9 will be deprecated
The NSF Datastore will get updates that we have all wanted for a long time.
View I

3

Part 2 of Partial Refresh in Notes Forms
Sun, Jan 25th 2015 10:53a Fredrik NorlingI couldn’t actually accept myself defeated in the battle to get partial refresh into old school Notes applications. And after a second look at my code I found a way, so I rewrote the javascript library to be a javascript object class so all calls are made inside the class. So now partial refresh of the entire form tag is the standard way of refresh but you can also narrow the refresh to everything inside a div or a table sell if you want to. And Serverside refreshes from a QuerySave agent

14

2014 a year of change
Wed, Dec 31st 2014 1:59p Fredrik NorlingLooking back at 2014, I see the year that XPages really got accepted as the primary language for Domino.
IBM Bluemix got launched and the response was no XPage support in Bluemix, but in the last 2 months we saw that IBM had changed their minds and now there are talking of some kind of support for xPages apps in Bluemix. Great IBM that will get the community to start using the service even more if you can deploy your apps in a real scalable App Engine. The Domino OpenNTF API, evolved and have l

18

Holiday Hack: Get some XPage power in old Notes apps
Wed, Dec 31st 2014 3:23a Fredrik NorlingOne of the great things with XPages is the partial refresh that help you to update information inside the page without a full reload of the page. Well that is not possible with older notes applications because it does a full roundtrip to the server each time we change something. But we can update the screen without the users notice it with ajax. What I did was create a copy of the main js function that Domino uses _doClick and replace that with my own copy of that function in onload.
function

10

Setting up a sFTP server to be used with an existing Domino SSL certificate
Mon, Dec 8th 2014 11:51a Fredrik NorlingWith the new way of creating SSL certs for Domino a new opportunity occurred to me and actually it worked great. Because we create the certificates using OpenSSL the generated Key and certificate can actually be used on the same server to setup a sFTP server. Saidly because the Domino FTP server on OpenNTF.org doesn’t support sFTP I had to use the FileZilla server the setup was super simple.
Run the setup
go into settings and enable FTP over SSL select your .Key file and your certificate