263 Lotus blogs updated hourly. Who will post next? Home | Blogs | Search | About 
 
Latest 7 Posts
Moving on with Excel Export part 5 : XPages Export
Sun, Mar 29th 2015 119
Moving on with Excel Export part 4 : XPages Export
Wed, Mar 18th 2015 23
Moving on with Excel Export part 3 : XPages Export
Thu, Mar 12th 2015 10
Moving on with Excel Export part 2 : XPages Export
Tue, Mar 10th 2015 6
If your user want reports in Excel you should read this
Mon, Mar 9th 2015 8
News from IBM ConnectED15
Mon, Jan 26th 2015 13
Part 2 of Partial Refresh in Notes Forms
Sun, Jan 25th 2015 5
Top 10
Moving on with Excel Export part 5 : XPages Export
Sun, Mar 29th 2015 119
Moving on with Excel Export part 4 : XPages Export
Wed, Mar 18th 2015 23
2014 a year of change
Wed, Dec 31st 2014 16
Holiday Hack: Get some XPage power in old Notes apps
Wed, Dec 31st 2014 15
Maximum file upload size in Domino all the places to edit
Thu, Sep 11th 2014 14
News from IBM ConnectED15
Mon, Jan 26th 2015 13
HTTP Server is waiting for threads to finish: the wait is over
Wed, May 14th 2014 12
Sorry Samsung, Apple you’re wrong
Sun, Oct 19th 2014 11
Setting up a sFTP server to be used with an existing Domino SSL certificate
Mon, Dec 8th 2014 10
Moving on with Excel Export part 3 : XPages Export
Thu, Mar 12th 2015 10


Fredrik Norling
Blog Title
Blog URL http://www.xpagedeveloper.com
RSS Feed http://www.xpagedeveloper.com/feed
Validate Feed feedvalidator.org or validator.w3.org
Feed Last Checked Mar 29, 2015 2:27:30 PM EST. Realtime Update:
Location Sweden


Recent Blog Posts
119
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.
23
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
10
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
6
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
8
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
13
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. View I
5
Part 2 of Partial Refresh in Notes Forms
Sun, Jan 25th 2015 10:53a   Fredrik Norling
I 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
16
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
15
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. function
10
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
6
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 NSF_BUFFER_POOL_SIZE_MB also using cac
6
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
11
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
2
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
3
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’
14
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”
4
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
6
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
5
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
3
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
5
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 Expence report Time report Purcase requests 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
4
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
4
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. C
2
Another great developer book found
Tue, Jun 10th 2014 1:32p   Fredrik Norling
Summer is here and book reading time for me is also here, I’ve read and added this great resource to my desk at work, JQuery and Javascript Phasebook. 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
4
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 C:
5
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
5
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
12
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
6
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
3
What happens in enemy camp: Microsoft Build 2014
Mon, Apr 14th 2014 9:18a   Fredrik Norling
Microsoft developer conference Build was at Moscow center this week. Microsoft new CEO Satya Nadella talked about that Microsoft will be the developers best friend, well we will see about this. They also talked a lot about Internet of Things or to be exact Windows for Things. Windows in your car, your tv and all your other machines. It’s probably only is the multimedia system so we can be calm, no blue screen on the highway. If you want to know more this is the session to view Windows pho
6
Mastering XPages is here soon
Fri, Apr 11th 2014 1:12p   Fredrik Norling
The upcoming second edition of Mastering XPages is here soon with a realease date of the 25:th of April. Impressive 1200 pages of XPages information. Apart from all the old stuff the authors has added content about mobile, extension library, debugging (my favorite part) and performance. I will write a follow up with a review as soon as I get my hands of a copy of the book. Check out what the authors say about the new book You can preorder the book here IBM Press amazon.com
5
Domino and heartbleed
Wed, Apr 9th 2014 11:50a   Fredrik Norling
A support flash has been sent out by IBM Support that Domino is not affected by the bug. Link to IBM Support flash can be found here. http://goo.gl/q9hMBx If you want to know more about hearthbleed check out links krebson security heavy.com




Created and Maintained by Yancy Lent - About - Planet Lotus Blog - Advertising - Mobile Edition