| Recent Blog Posts
Moving on with Excel Export part 5 : XPages Export|
Sun, Mar 29th 2015 2:27p Fredrik Norling
In 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.
Moving on with Excel Export part 4 : XPages Export|
Wed, Mar 18th 2015 2:38p Fredrik Norling
The 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
Moving on with Excel Export part 3 : XPages Export|
Thu, Mar 12th 2015 6:20a Fredrik Norling
Making 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
Moving on with Excel Export part 2 : XPages Export|
Tue, Mar 10th 2015 4:38a Fredrik Norling
In 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
If your user want reports in Excel you should read this|
Mon, Mar 9th 2015 5:23p Fredrik Norling
XPages 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
News from IBM ConnectED15|
Mon, Jan 26th 2015 7:30p Fredrik Norling
Some 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.
Part 2 of Partial Refresh in Notes Forms|
Sun, Jan 25th 2015 10:53a Fredrik Norling
2014 a year of change|
Wed, Dec 31st 2014 1:59p Fredrik Norling
Looking 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
Holiday Hack: Get some XPage power in old Notes apps|
Wed, Dec 31st 2014 3:23a Fredrik Norling
One 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.
Setting up a sFTP server to be used with an existing Domino SSL certificate|
Mon, Dec 8th 2014 11:51a Fredrik Norling
With 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
Some performance tips for your Domino / XPages servers|
Thu, Nov 20th 2014 7:33a Fredrik Norling
When your applications has grown very big you might face a problem with performance in this case I had a customer with quite a large crm system that in some cases got very high disk io but the cpu didn’t spike.
neither did the memory almost 50% not used by the system.
So what I did was I increased the memory available for the XPage runtime JVM using HTTPJVMMaxHeapSize
and to get get better database performance I increased the database IO buffers using
also using cac
How to get plugins working again after installing 9.0.1 FP2 IF2|
Wed, Nov 5th 2014 7:54a Fredrik Norling
The new IF2 for fickpack2 in the Client seams to mess up the locally installed plugin in the Designer client somehow. But there is an easy fix to that.
Close down the client and navigate to the workspaceapplicationseclipse folder and delete everything in it (You should probably make a backup before )
restart the designer and go into File – Application – Install
Select the “Search for new features to install” option and click next
Sorry Samsung, Apple you’re wrong|
Sun, Oct 19th 2014 3:14p Fredrik Norling
Samsung, Apple and the Peddle smart watch everybody seams to releasing watches now but how smart is these watches. They have displays, and different kinds of sensors, but smart, I don’t know. They are only an extension of the phone. because you need the phone for them to work.
Then I watched one of the keynotes from Dreamforce 14
And saw the new cuff phone smart watch PULS created by Will I AM this might not be the best product but the way is the correct one. Create the smart device and p
The new keylogger function in ios8|
Tue, Sep 30th 2014 5:58a Fredrik Norling
Yes, if you install a third party keyboard one of the new features in IOS8 and give it full access. You also agree to send everything you write to a third party. Not only do you agree that the developers of the keyword can read anything you write, they are also allowed to send the information to their own servers for processing and once what you have written is there. You have no chance of knowing what they will do with your written passwords, credit card numbers and all other personal informati
The difference between more or less|
Mon, Sep 29th 2014 1:45p Fredrik Norling
Building up expectations before you start using something must be one of the greatest feelings, opening up the box to a new “thing”, Jippi!!!
When you’re looking to buy something, you look at all the features of the “thing” and how that fit’s your list of needs. If the list of features comes from reading a spec or from a video presentation of the feature(s). The feeling when you find a “thing” that meet your list of needs is really great. It’
Maximum file upload size in Domino all the places to edit|
Thu, Sep 11th 2014 1:00p Fredrik Norling
If you ever wanted to increase the file upload size in Domino you have probably seen that there are several places to update depending on the configuration. I was increasing this on a server this week and missed one of the places and couldn’t understand where I missed, Per-Henrik Lausten pointed me what I missed. So I though I would write a post about this I might help someone else, or help me the next time I forget.
Open up the Server document and go to the “Internet Protocols”
What can we expect from Apple today and where can I watch the event?|
Tue, Sep 9th 2014 8:03a Fredrik Norling
IOS 8 with Release around the 15:th of September – Ultra high
a new IPhone with larger screen – Very high
NFC and iPay, apples take on mobile payments – High
iWatch, the only watch you ever need – Medium
iHealthband, a wristband that monitor you health – Medium
a new Corporate appstore with IBM – Low
New IPad – Low
New Apple TV, with appstore – Low
New iPod – Low
iGlasses, Apples take on the Google glasses – Low
You can watch the Appl
Evolving the easy XPage keyword bean|
Mon, Sep 8th 2014 4:18a Fredrik Norling
The first part of the easy keyword bean can be found here
When working with keywords in XPages your application could greatly take advantage of the possibilities in the XPage Engine. Thru caching of data, What do I mean with caching?
Well today the keyword bean is located in viewScope and that means that it lives only on the current page that is opened. If you move the bean to applicationscope and add some caching functionality we only need to go into the database if the keyword never have been
Creating an easy XPage keyword bean|
Thu, Sep 4th 2014 2:12p Fredrik Norling
Start by creating a form named Keyword, in this form add the fields Name and Data, add the multivalue checkbox in the datafield
Save the form
Now you need to create the lookup view, create a view called byKeyword
Add 2 columns name and data. The name column should display the name of the Namefield and it must be sorted and the second view should show the data field, Save the new view.
Let move over to the interesting code, create a new java class named FormHelper and place it
Take the time and show some appreciation for someone, I will!!!|
Wed, Sep 3rd 2014 1:11p Fredrik Norling
It’s that time of the year where IBM want you to nominate the people that bring the ICS Community forward. There are several ways of doing this, an IBM Champion could be someone that helps people on stackoverflow, share projects on openntf.org or just some great xSnippets. Perhaps someone of the great bloggers on Planetlotus.org. Or perhaps one of the great people how speak at conferences like IBM Connect or some local event.
Nominate a IBM Champion now, it’s a great way t
Why you should move all routines to an application|
Thu, Aug 21st 2014 3:39a Fredrik Norling
How many paper based-routines does your company have?
If you are lucky you can answer none on this question, but are you sure?
What about vacations
When you are sick
Travel expense requests
Performance Appraisals (PA)
And there is probably lots more routines
If you still can say no, then your company has came very far and you are one of the lucky few employees that can work 100% digital.
These are some reasons why your company should move towards ge
Internet of things is that something to care about|
Wed, Aug 13th 2014 3:42a Fredrik Norling
Finally is the revolution here, since I’ve started as a developer I have waited for this. Integration of things is really interesting. And will help us a lot, you might say why should my coffee maker be connected to the internet?
The answer to that is how many times have you asked yourself, did I turn off the coffee maker. That’s only one thing, add sensors to everything in your house and you can start to get an alarm if there is an water leakage, a fire is starting, the sensors can
Creating your first XPage Repository using GitBlit|
Mon, Aug 4th 2014 3:21a Fredrik Norling
If you read my last article about setting up your own GitBlit Server with Domino credentials this is the next step. Creating your first repository and pushing up an xpage application to the server.
Login to your git blit server and click on the repositories tab
Click on new Repository at the right hand side of the UI
Give your new repository a name, and write a description if you like.
There is lot’s of other options that you can setup but they are not needed for this example.
Another great developer book found|
Tue, Jun 10th 2014 1:32p Fredrik Norling
I often like to have all my resources as pdf files but in some cases a reference book can come in handy. Easy to pick up without the need for extra screens (They are full with applications anyway)
This book is one of them, if you develop using jQuery this book has lots of short code snippets that will come in handy when developing using JQu
Setup a Free Git server with Domino Credentials in a few minutes|
Thu, May 29th 2014 4:29a Fredrik Norling
Today I’m going to show you hav to setup you own internal Free Git server in five minutes
Make sure that you have java version 7 installed in you windows server. JRE or JDK any version works. If you don’t have one goto java.com and install the a java jre.
Goto the java download page scroll down to the bottom of the page and download the JCE
Open up the downloaded zip file and copy the 2 selected files
To the folder libsecurity below your java installation folder in my case it was
Importing a Files and folders as fileresources|
Mon, May 19th 2014 12:32p Fredrik Norling
I saw a question today inside a linkedin forum about how to import files and folders into a Domino database and there are several ways on how to do this. Check out these three ways of importing files and folders into your nsf file.
1. Import the files into the webcontent folder using package explorer. using import
Select general -> file system to import files and folders
Browse for the from folder, any subfolder will be the top folder when impor
HTTP Server is waiting for threads to finish: the wait is over part 2|
Thu, May 15th 2014 11:56a Fredrik Norling
If you did read my post yesterday about how to break long running requests on the Domino server if not you can find it here The wait is over part 1
Sven Hasselbach commented that this didn’t work for him and yes he is probably right because I suspect that Sven was trying a long running XPage and yes you can’t break them using Restart Task Http but I have a solution/workaround but that requires you to implement a failsafe into your long running code.
If you add this inside your l
HTTP Server is waiting for threads to finish: the wait is over|
Wed, May 14th 2014 6:11a Fredrik Norling
How many times have you tried to stop the http task on a Domino server and got this back on the console
HTTP Server: Waiting for session to finish: Session State [Processing Request]
And there you are waiting and waiting for the http to restart och shut down
The solution is not to use tell http quit or tell http restart if you want to shut down http
Use restart task http instead if you want to restart http or restart task http and when the task is restarted use tell http quit.
This will force t
Mastering XPages – a good addition to every XPagers bookshelf|
Fri, May 2nd 2014 1:47p Fredrik Norling
As I promised in my previous article about the book here is the review of Mastering XPages.
I did read the old Mastering XPages from cover to cover over a couple of days when that one came out. And have been using it as reference but not enough I understand now. While reading the second edition of Mastering XPages I had to go back into the first edition several times, was this really in the first edition? And yes it was, I hadn’t read the first edition enough it seams.
I rediscovered so