For those on Connect 2016: Have you seen plans for the next Notes release?

Stanislav Marszalek  2 February 2016 13:51:37
Hi guys.
we develop an applications on Xpages and one of the big issue here, is the old Java version in Domino. IBM promises to upgrade Java in the next release, but we still don't know when this will be. Has anybody mentioned more accurate release date then just the half of some year?
Thanks a lot for comments and have a good time in Orlando!

Notes data on Android mobile ...and offline

Stanislav Marszalek  5 January 2016 10:44:16
How to get data from your Notes database to Android mobiles and use them offline? That was a task which we need to solve in recent days. Users should be able to edit and save their contacts, activities on Android mobiles and then send them back to Notes database. But not only texts, numbers, dates but also images, audio and files. And that all in offline mode as well. On top of that, the application should access mobile’s sensors like location, speed, camera etc. The last point means that we have to create native Android application, so we’ve chosen Android Studio to do the job but how to store data on mobile.
Image:Notes data on Android mobile ...and offline

Where to store data on mobile

You can pick up from several options, how to store your data on mobiles. You can use text files or more obvious choice is SQLite database, in-memory mobile database for storing structured data. But we need to synchronize that data with server, which means write your own code which will handle all synchronization challenges, something like Notes replication and that is not quite easy. That is why we’ve selected Couchbase database which promises to solve that issue.      

Couchbase mobile and Sync Gateway

Couchbase database is like Lotus Notes, no structured database, which stores its data in JSON format. Apart from standard server, it has also mobile version, which can be installed on mobile together with your application. Mobile application stores data in Couchbase Mobile and then replicate them with server part using Sync Gateway. Main replication features:
  • Push and pull replication
  • Replication can start on command or it can be continuous. It means that replication is active whenever user is connected to the internet. For instance, user saves his contact and that change is replicated to the server within seconds.
  • Replication includes not only primitive data but also images, files.
Using Couchbase infrastructure we get data from mobile devices to the Couchbase server, but we still need to move them to Notes databases.
Image:Notes data on Android mobile ...and offline
Java synchronization agent between Couchbase and Notes

For the synchronization purpose we’ve created Java agent in Notes database, which compares modification dates on both sides then compares values of each record and creates, updates or deletes records on specific side. It was not as tricky as one can image. Especially replication conflicts can be avoided by setting up proper permissions, assign which device has higher priority, shortly by set up specific application logic. For Java agent development we’ve use Couchbase Java SDK. Here is a snapshot of Java code:
Image:Notes data on Android mobile ...and offline

    Change your Domino into SQL

    Stanislav Marszalek  26 November 2015 13:06:46
    We bring you a presentation from SUTOL conference in which we focused on creating dynamic charts from Notes data using AlaSQL javascript library. Do you need to group your Notes data according your criteria? Do you want to filter out specific documents? Do you like to see records within the time range you specify? Basically, do you want to send SQL commands to your Notes data and don’t let users wait forever? Then come have a look on this presentation, in which I show you how to build up a drill-down reports connected to Google Charts in XPages using AlaSQL.js library. AlaSQL.js is in-memory SQL database which is very fast and can work with JSON arrays and objects to which you can convert your Notes data.

    Here a presentation:
    Image:Change your Domino into SQL2

    SUTOL Conference - About Notes in Prague - 11.11.2015

    Stanislav Marszalek  5 November 2015 05:48:00
    Image:About Notes in Prague - 11.11.2015 SUTOL Conference

    We would like to invite you to SUTOL Conference in Prague where we will have a presentation about using SQL-like databases in Xpages.
    The 7th SUTOL Technical Conference will be held on November 11, 2015 in Prague. For the first time, the agenda is full in English and up to 200 attendees is expected mainly from Central and Eastern Europe.
    SUTOL, The Czech "Lotus user group", runs two conferences per year - one business oriented and one technical - with a stable audience of 100 people. This year, we decided to make the autumn event more international to bring together customers, business partners, sponsors and IBMers across country borders. The conference has two tracks (administration and development) focused on IBM Collaboration Solutions portfolio - IBM Notes/Domino, IBM Connections, IBM Sametime, IBM Connections Cloud and others.

    Here is an abstract from our session:
    Boost your Notes database with SQL-like features - Stanislav Marszalek
    Do you need to group your Notes data according your criteria? Do you want to filter out specific documents? Do you like to see records within the time range you specify? Basically, do you want to send SQL commands to your Notes data and don’t let users wait forever? Then come to our session, in which we will show you how to build up a drill-down reports connected to Google Charts in XPages using AlaSQL.js library. AlaSQL.js is in-memory SQL database which is very fast and can work with JSON arrays and objects to which you can convert your Notes data. In this session we will show you a technical overview of the entire process, user interface and a glimpse of the code behind.

    Here is the link to the conference details.

    NET.Notes EVENTS – Notifications

    David Marko  15 June 2015 10:32:58
    Quick and precise information is key for succesful Event organization. How do I get to know someone has created a new important todo for upcoming Event? What happened on the Event during my week long vacation?

    Several information channels are available for users:
    • Timeline
    Timeline is perfect system overview available for each particular day. Is there any new todo created for the Event or did someone marked task as completed yesterday? Did anyone update the Event schedule within the last week? All these things are available on Timelne including precise timestamp and author name.

    nn_timeline style=

    • Email notifications
    Email notifications keep users up-to-date with the last changes on the Event. Users are receiving email notifications of 3 types:
      a)  timeline based notifications covering every day event updates …. sent weekly
      b) todos in progress for this week …. sent weekly
      c) calendar based notifications for scheduled todos …. sent daily
    • Discussion and notifications
    Discussion allows nice idea exchange among different users. Discussion is available for Event itself or particular todos. Email notifications are being sent after new comment submission.


    NET.Notes EVENTS - Native Mobile Companion App

    David Marko  8 June 2015 04:26:00
    Mobile application allows you to work off-line with events, tasks, companies and contacts. When connected to the internet data are synchronized and by this they can be accessible without connection. Data are read only.

    Mobile application - features available:
    • see events, tasks, contacts without internet connection
    • tasks contain detailed description
    • call contact directly from the application
    • send email from the application
    • copy contacts to device’s address book
    • links among events, tasks, companies and contacts
    • full-text search

    Now you can download application for Android 4.x a higher and  iOS 7 and higher. You can test the application together with our demo data. Just download the application from Google Play, searching phrase NET.Notes or click on links below.

    download from Google PlayAppStore style=  

    Screenshot_2015-04-29-10-49-28 Screenshot_2015-04-29-10-49-41

    NET.Notes EVENTS - iOS version is available

    Stanislav Marszalek  3 June 2015 13:02:18
    NET.Notes EVENTS mobile application is finaly available for iOS 7 and above. Supported are iPhone and iPad devices. To test application you can download app from App Store and connect using NET.Notes EVENTS demo account. Login details are available here, mobile app product page is available here.

    Mobile application features:
    • see events, tasks, contacts without internet connection
    • tasks contain detailed description
    • call contact directly from the application
    • send email from the application
    • copy contacts to device’s address book
    • links among events, tasks, companies and contacts
    • full-text search
    Now you can download application for Android 4.x a above and iOS 7 and above. You can test the application together with our demo data. Just download the application from the store, searching phrase NET.Notes.
    Image:NET.Notes Events - iOS version is available 


    NET.Notes EVENTS - HELP

    David Marko  20 May 2015 03:59:00
    There are two options available in “NET.Notes EVENTS” that help users to understand each part of the entire application. Both are available from top-right menu:
    • Help – this option activates in-line help integrated into “NET.Notes EVENTS” . Small bulb symbol appears around the particular parts of the entire system. Clicking on the symbol opens the window with contextual help.
    • Description – opens product web site in another browser tab. This information is commonly available on our public web site as well.


    Details available here: http://tcl-digitrade.com/net-notes-events/

    help_inline style=

    NET.Notes EVENTS - Dashboard

    David Marko  14 May 2015 03:58:00
    "NET.Notes EVENTS" workspace manages tabs user interface for convenient work. The very first tab contains Dashboard. Here we can see all significant information all together.

    The four basic panels are available here:

    • EVENTS: active events with progress information, overall number of related todos and todos behind the schedule in red
    • What is planed: calendar view displays my currently scheduled todos
    • My Tasks: my todos waiting for my action
    • What happened recently: timeline displaying the last changes in the entire application


    Details available here: http://tcl-digitrade.com/net-notes-events/
    net_notes_events_dashboad style=

    NET.Notes EVENTS - Native Mobile version

    Stanislav Marszalek  11 May 2015 09:32:00
    Mobile application allows you to work off-line with events, tasks, companies and contacts. When connected to the internet data are synchronized and by this they can be accessible without connection. Data are read only.

    Mobile application features:
    • see events, tasks, contacts without internet connection
    • tasks contain detailed description
    • call contact directly from the application
    • send email from the application
    • copy contacts to device’s address book
    • links among events, tasks, companies and contacts
    • full-text search
     Now you can download application for Android 4.x a above, iOS version will be available soon. You can test the application together with our demo data. Just download the application from Google Play, searching phrase NET.Notes or click on below mentioned link.

    Image:NET.Notes EVENTS - Native Mobile version

    Screenshot_2015-04-29-10-49-28Screenshot_2015-04-29-10-49-41

    Screenshot_2015-04-29-10-49-49Screenshot_2015-04-29-10-50-23  
    TOPlist