I posted some common string functions that I’ve been using alot during the years in @formula, lotusscript (strleft, strright, strrightback, strleftback) and later in SSJS. So I thought that I need them in Java too. There might be some features like the one with dot in the replacesubstring function, feel free to comment so will I fix that 😉
Hope you find it useful.
The standby widget snippet has need around for a while and doing it’s job in lots of my projects but now more and more of my projects is using bootstrap. So then there was time to also change the standby widget to support bootstrap. This is the first version that will give you a responsive standby “loading” indicator.
Download the updated version here
http://openntf.org/XSnippets.nsf/snippet.xsp?id=bootstrap-standby-dialog
I usually write a little post about what I would like to see an announcement about in January
You can probably think of more things you would like feel free to make a comment
Today I had a strange issue on an XPage application I was working on I it didn’t matter where I clicked
my button on the form got clicked. Very strange. First thing I started to look for was if I had some onClick event that was bind wrong. Nope that wasn’t the case.
Then I went over to the client side and thought I could find what event listener that was making the call but this doesn’t say anything to me.
Then I started to look at the XSP.Attachevents at the bottom of the xpage
But if you have a large xpage and 20 events attached to it, it’s hard to find what is what. The my suggestion is give you components real names. And it was then I found the problem.
Can you spot the difference
The working client side code
This this the XPage with the faulty code
Don’t scroll more spoiler alert
Yes, the partial event listener is bound to an object that doesn’t exist view:_id1:_id5
why you might ask, I found that this happens if a button don’t have a name and is set to do a partial refresh.
Then you will get that you will click the button where every you click on the xpage. Hopefully fixed in a future release with an error or a correctly generated id.
You Bluemix XPage server can interact with other services using the VCAP_SERVICES where all the credentials for contacting other services is stored. This JSON data can be retrieved using
var services = fromJson(bluemixContext.getVCAP_SERVICES());
This will give you a direct access to the connected services credentials and exposed information, the credentials is what I have found updated each time you deploy a new version of you code so you need to use this way to get the credentials.
If you login to your Bluemix dashboard and click on your XPage service icon, you’ll find environment variables in the left hand navigator. This will display the structure of the VCAP_SERVICES JSON data check it out.
Most of the services has different methods of accessing them, I’m still investigating how to use different services and future posts will show how to use Bluemix services using XPages
I have seen more than once both of own and other developer experience that a loop in XPages gone bad and you have to kill the server. How can this kind of behavior be fixed in XPages for Bluemix will the dashboard work to “kill” the server?
Also see my XPages for Bluemix the questions post lot’s of questions is updated with answers
When I started to try out XPages for Bluemix I started to create a list of questions for the future because this is in Beta and between now and Gold release some of this questions would be good to have an answer on.
I will probably get more questions and will then update this post. I will also add any answers I get to this post. If you know any answer please comment.
On friday the XPages runtime on Bluemix was released and also the new version of OpenNTF Extension library that enables to work with.
My first impression is that it works great I haven’t had time to do any deep diving into the new possibilities but I thought I should share as long as I have tried it.
To get it to work you need a bluemix account and install the latest extlib into you designer client when you done that you will get a new entry in your preference in the designer.
I have selected the US South (Don’t know if the XPage engine is deployed in the UK site) write your user name and password and Test Connection
if this is ok your designer is connected to Bluemix
Go to bluemix and setup an XPage Starter app when you have logged in to Bluemix you need to go to catalog and at the bottom click on Bluemix Labs Catalog
inside this beta catalog you will find the XPage Bluemix engine and also a web starter application click on this entry.
Fill out an name for you app at the lefthand side and press Create
Your started application is now being setuped and the next step is to download the webstarter app, I actually don’t know if you need the Bluemix commandline tool and I haven’t been able to download it and had it from before so I couldn’t test with out it, but try without it and let me know.
When you have downloaded the starter code go to designer and in the tools menu
This will start a wizard when you need to specify a path to a bluemix staging area, this area should not be in the client data folder and connect to the bluemix app area.
To deploy your code to bluemix you need to right click on the database and select deploy application remember to sign your database before doing this if you have multiple signers in the application.
The deployment will take very long time and if you check the Bluemix the application will show as started but it’s not. This might hopefully be improved with better status updates in future releases.
This will add the design database if you want to connect to the data nsf you need to go into Bluemix and download a notes id and connect you will find this information below services in the Bluemix dashboard.
It seams like the backend data store for the Bluemix is a Linux Domino server because if you browse it you will find regular databases in the root of the server. It will be interesting to see any performance data from the Bluemix setup.
Also read my XPages for Bluemix the questions
Finally did the beta arrive and I wasn’t dissapointed. Setting up the web start app was very simple, a few minor things but no error.
But overall great first release will be fun to see what the future will give us.
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 to show you today and how to upload an Excel file and read some data from a cell.
In the example database for POI4XPages there is a class you really need and that is the ImportAction this is needed to open up a workbook of a xlsx file you don’t need it if you are only using xls. This class is used for changing the classpath of the jvm and some security stuff so you don’t need to modify the java.policy file on your server (Thanks Christian for pointing this out)
We start with some OpenNTF data in Excel
We create an java class
public String getData(java.io.File file,Integer row,Integer cell){
try {
String inputFile = file.getPath();
String CellVal=””;
ImportAction ioAction = new ImportAction();
HashMap<String, String> hsCurrent = new HashMap<String, String>();
hsCurrent.put(“FILE”, inputFile);
workbook = ioAction.run(null, hsCurrent);
if (ioAction.hasError()) {
Exception exLst = ioAction.getLastException();
throw(exLst);
}else{
Sheet worksheet=workbook.getSheetAt(0);
Row rowdata = worksheet.getRow(row);
Cell celldata = rowdata.getCell(cell);
CellVal= celldata.getStringCellValue();
}
return CellVal;
}catch(Exception e){
return “”;
}}
lets look at the parts of this class
ImportAction ioAction = new ImportAction();
HashMap<String, String> hsCurrent = new HashMap<String, String>();
hsCurrent.put(“FILE”, inputFile);
workbook = ioAction.run(null, hsCurrent);
if (ioAction.hasError()) {
Exception exLst = ioAction.getLastException();
}
This is the magic call the the ImportAction class that will create a Excel POI workbook Object.
The following rows will get the first sheet in the excel file get the first row and the first cell and return the string
Sheet worksheet=workbook.getSheetAt(0);
Row rowdata = worksheet.getRow(row);
Cell celldata = rowdata.getCell(cell);
CellVal= celldata.getStringCellValue();
Now we need to create the XPage to enable the upload of the Excel file
The interesting part is behind the read button onclick event
importPackage(com.xpagedeveloper)
var con = facesContext.getExternalContext();
var request:com.sun.faces.context.MyHttpServletRequestWrapper = con.getRequest();
var map:java.util.Map = request.getParameterMap();
var fileDataName = getClientId(“fileUpload1”) ;
var fileData:com.ibm.xsp.http.UploadedFile = map.get( fileDataName );
if( fileData == null ){
return;
}
var tempFile:java.io.File = fileData.getServerFile();
var Excel=new com.xpagedeveloper.ExcelData()
viewScope.data=Excel.getData(tempFile,0,0)
We get the uploaded file in fileData and retrieve the actual file using fileData.getServerFile() remember that this file is a server based temp file and with that I mean that you will not get the same same on the file as it was when the user uploaded it. And next I create an object of my class and call the getData function with the java io file object the row and the cell number remember that this has a zero based index so 0,0 is actual row 1 and cell 1, this is the result I get when running the code against the Excel sheet
If you are going to loop thru a full excel sheet you probably need to rewrite the code but this will give you a hint where to begin.
