263 Lotus blogs updated hourly. Who will post next? Home | Blogs | Search | About 
 
Latest 7 Posts
Moving on with Excel Export part 4 : XPages Export
Wed, Mar 18th 2015 35
Moving on with Excel Export part 3 : XPages Export
Thu, Mar 12th 2015 5
Moving on with Excel Export part 2 : XPages Export
Tue, Mar 10th 2015 8
If your user want reports in Excel you should read this
Mon, Mar 9th 2015 15
News from IBM ConnectED15
Mon, Jan 26th 2015 6
Part 2 of Partial Refresh in Notes Forms
Sun, Jan 25th 2015 8
2014 a year of change
Wed, Dec 31st 2014 9
Top 10
Moving on with Excel Export part 4 : XPages Export
Wed, Mar 18th 2015 35
If your user want reports in Excel you should read this
Mon, Mar 9th 2015 15
HTTP Server is waiting for threads to finish: the wait is over
Wed, May 14th 2014 14
Holiday Hack: Get some XPage power in old Notes apps
Wed, Dec 31st 2014 14
2014 a year of change
Wed, Dec 31st 2014 9
Mastering XPages is here soon
Fri, Apr 11th 2014 8
Sorry Samsung, Apple you’re wrong
Sun, Oct 19th 2014 8
Part 2 of Partial Refresh in Notes Forms
Sun, Jan 25th 2015 8
Moving on with Excel Export part 2 : XPages Export
Tue, Mar 10th 2015 8
Why you should move all routines to an application
Thu, Aug 21st 2014 7




Recent Blog Posts
35
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
5
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
8
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
15
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
6
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
8
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
9
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
14
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
2
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
2
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




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