| Recent Blog Posts
IBM Domino and Java problem with old applets|
Mon, May 25th 2015 9:35a Fredrik Norling
All the old Java applets that is YES in some old apps not yet converted used got another problem today. They are now blocked by Oracle because the code signing certificate is outdated, it seams like when they where updated to work with Java 1.7 45 the person who resigned them did that with an old certificate and now that cert is outdated and has been so for 1 month. If IBM or you want to keep track on when your code or SSL certs exires QNova Systems contract management system works really gre
Moving on with Excel Export part 6 : But now we Import|
Fri, May 1st 2015 4:13a Fredrik Norling
The previous 5 steps in this series (part 1 part 2 part 3 part 4 part 5) has been getting data out to excel in different ways this part will show you how to get data back into Domino again thru your XPage, this will give you the possibility to roundtrip data handling. Export all customers mark the rows you have changed and re import the data. Because Apache POI is installed on the server as an OSGI we have access to these classes in all java code on the server and that is what I’m going t
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.