Posts Tagged ‘tutorials’

11 Apr 2013
5

Appcelerator Mobile Development – Season 1: Prologue

Hi everyone. I’m very excited about my next Blogging Project. Over the past year I’ve had some very decent exposure to Mobile Development, whether Phonegap, jQuery Mobile, Dojo Mobile, XPages Mobile Controls, Appcelerator Titanium, etc.

This is a Prologue to some upcoming Video Tutorials that I am grouping together as “Appcelerator Mobile DevelopmentSeason 1“, where I will be showing everyone how to get started with Appcelerator Titanium Development to build native iOS and Android Mobile Applications.

Season 1 will focus on some basic methods of getting up and running with Native Mobile Development. Our focus will be to create a Mobile Application that runs on iOS and Android which allows the capturing of data, some reports and a couple of other nifty features like SplitWindows for iPads, Pull to Refresh Actions for Views, etc.

We will also be integrating this Mobile App with a Basic Domino XPages Application. I’ll show you how to authenticate with Domino, make use of XAgents and REST Services to push and pull information to an from Domino, as well as triggering your business logic on the Domino side for your Workflow Processes.

Finally, I will be showing you what, at the moment, seem to be best practices for developing mobile Apps using frameworks like commonJS, underscore.js, etc. This will allow us to avoid memory leaks and poor performance by making use of a very basic form of MVC Architecture within our Mobile Application.

My next Blog Post will focus on getting you up and running with Appcelerator Titanium and installing the SDKs for iOS and Android.

I would love your comments, feedback and suggestions regarding this venture. Feel free to post comments against this Blog Post or catch me on Twitter.

Cheers for now
John.
14 Mar 2013
0

Video Tutorial: Get up and running with Lotus Domino Designer 8.5.3

Hi everyone. So here’s my next Video Tutorial. I show you how to download Lotus Domino Designer 8.5.3 and I also give a quick demo on how to set up your first Notes Application.

I decided to go back to basics and assist those who are new to IBM (Lotus) Notes, especially those who want to get started on Notes/Domino and XPages Development. I end off the Video Tutorial showing you how easy it is to create a working CRUD Application (Create/Read/Update/Delete) in the Notes Client.

If you use iTunes, you can download this video via David Leedy’s NotesIn9 Podcast series.

Enjoy :)

John.

18 Sep 2012
3

TUTORIAL: Integrating XPages with DB2 – Part 2

Hi everyone. So, just 2 things firstly:

1. This is an extended Post to David Leedy’s NotesIn9 Posting of “Intro to XPages and Relational Data – Part 2“.

2. I do apologize that this took a while to publish. This is one of the more challenging years to find some free time to contribute to the Domino and XPages community. Having said that, I have quite a few Video Tutorials planned before this year ends, so stay tuned :)

 

Now that that’s out the way…..this post is Part 2 to the “Integrating XPages with DB2 – Part 1“. In this Video I show you how to Create/Read/Update/Delete DB2 Data using XPages. More importantly, I show you how to empower the User to perform all these functions via a User Interface. It’s usually easy to write this logic in the back-end, but a little more involved when handing that power over to the User.

 

The good news is that it’s fairly straightforward. I show you some quick functions that will get you up and running in no time. As I explained in the Video though, there are much more advanced ways of integrating to DB2. This will involve some knowledge of DB2 itself. The keyword is…..”Stored Procedures“. This is where the power lies. A Stored Procedure is very much like a Sub Routine in LotusScript or a Function in Java or JavaScript, but you code in SQL Language. You can pass the Stored Procedure parameters, have all your logic neatly set out in a central place in DB2 and return values from the Stored Procedure which will allow you do things like create Child Documents, etc.

Later on in the near future, I will think up a straightforward Tutorial which will show you how this all works.

I hope you enjoy this Video. I really enjoyed making it. It was one of my smoothest recordings where everything went right the first time.

I want to thank David Leedy as always for adding this to his NotesIn9 Series. You da man :)

Cheers.

John

 

IMPORTANT NOTE: If you are not able to view this Video in HD, please Click Here to open this video up in a different Player.

4 May 2012
6

XPages TIP: What to check when Domino doesn’t install OSGI plugins from UpdateSite

Hi everyone.

So, yesterday I faced a doozy. We wanted the XPages Extension Library installed on one of our Client’s Servers using the UpdateSite that ships with Lotus Domino 8.5.3. Interestingly enough, no matter what we tried, it just wouldn’t install.

 

FIRST THINGS FIRST

In order to use the UpdateSite to deploy OSGI plugins, you’ll need to do the following:

1. Create a Database called “Whatever UpdateSite” in the Domino Data Directory, using the UpdateSite Template that ships with the Lotus Domino 8.5.3 Server.

2. In the Domino Server’s notes.ini, add the following ini Variable:

OSGI_HTTP_DYNAMIC_BUNDLES=yourupdatesitefilename.nsf

3. In the UpdateSite Database, import your OSGI Plugins.

4. Restart the Domino Server. (Note: A Server restart is only required if you modified the notes.ini. Other than that, a Restart Task HTTP will do the trick).

5. During the restart of the HTTP Task, you should see at some point a message along the lines of installing OSGI plugins. If you don’t see this message, then it’s not working.

 

BACK TO THE MATTER AT HAND

If you’ve done everything mentioned above, and the Server still won’t install the OSGI plugins, then the problem most likely lies with the Security settings for the specific Domino Server. When you import the OSGI Plugins into the UpadateSite database, the System automatically performs a Signing of all the Imports that took place. This means that it will sign the Imported Profiles with your current Lotus Notes ID.

So, it’s important that your Notes ID has access to perform XPages based operations on that Specific Server. To confirm this, do the following:

1. In the Domino Server’s Address Book, navigate to the All Server Documents view, and open the relevant Server Document (Note: You’ll need some Admin Access to perform these operations)

2. Click on the Edit Server button.

3. Navigate to the Security Tab.

4. In the Top right section of the Security Tab, you’ll see a field called “Sign agents or XPages to run on behalf of the invoker:“. If this field is empty, then every signature will be authorized on that Server as a default. Otherwise, you’ll need to be part of the list either as a User or as part of a Group. If the list is not empty and you are not featured in any way, the OSGI Plugins will NOT be installed.

 

That should do the trick. I don’t know of any other reason that the OSGI plugins won’t install from the UpdateSite Database.

Until next time…happy coding.

 

Cheers,

John

29 Feb 2012
13

TUTORIAL: Integrating XPages with DB2 – Part 1

Hi everyone. I’m happy to announce a Video Tutorial where I explain how to integrate one’s XPages Application with DB2 directly, and not through back-end Forms and Views.

The trick here is to have a bit of JDBC understanding, as well as a basic understanding of Relational Databases and SQL Query.

To work with this Video Tutorial, you’ll need to have the following in place:

1. An installed version of DB2. This can be DB2 Express as well, which is free – Click here to download.

2. An installed version of Domino Designer 8.5.3. I tested everything on my Domino Server, but there’s no reason why this shouldn’t work using your local HTTP session for Domino Designer – Click here to download.

3. An UpdateSite to install OSGI Plugins on Domino Server. NOTE: The UpdateSite database gets used for Domino Servers, and will not work for your local environment. To test everything using your Local HTTP, you’ll need to install the OSGI Plugins manually. You do this by extracting the contents of the Plugins Zip File to the Notes Data Directory, under “domino/workspace/applications/eclipse” folder.

 

Click here to view the Tutorial on how to setup the UpdateSite database and deploy OSGI Plugins on your Domino Server.

 

4. With reference to point number 3, Install the XPages Extension Library and JDBC Driver Plugins.

Download XPages Extension Library

Download JDBC Driver

 

5. Once you’ve deployed your plugins to your Domino Server, you can type in the following Commands to check if the Plugins were installed properly:

XPages Extension Libary:

tell http osgi ss com.ibm.xsp.extlib

JDBC DB2 Plugin:

tell http osgi ss extlib.driver.db2

The Domino Server should return information relating to the plugins you installed.

 

6. Here’s a copy of the Code that needs to be added to the db2.jdbc file that I speak about in the Video

<jdbc>
<driver>com.ibm.db2.jcc.DB2Driver</driver>
<url>jdbc:db2://localhost:50000/TESTDEMO</url>
<user>db2admin</user>
<password>password123</password>
</jdbc>

 

7. Here’s a copy of the Code that I use in the Video to add/remove/update and delete data in DB2

var mydata = {
FIRST_NAME: “John”,
LAST_NAME: “Jardin”
}

@JdbcInsert(“db2″,  “JJARDIN.USERPROFILES”, mydata)
var mydata = {
FIRST_NAME: “Sean”,
LAST_NAME: “Smith”
}

@JdbcUpdate(“db2″, “JJARDIN.USERPROFILES”, mydata, “ID=?”,1)
@JdbcDelete(“db2″,”JJARDIN.USERPROFILES”,”ID=?”,1)

 

I trust you will enjoy this Video. A Big thanks to David Leedy for making the video part of his NotesIn9 Series, and congrats once again on his recent milestone of 100 000 Views.

Also, another Big Thanks to the Domino and XPagees community, for always been available to assist wherever help is needed.

 

STAY TUNED FOR PART 2 OF XPAGES AND DB2 INTEGRATION!!!