K2 Europe Customer Day Recap

customerday2016K2 Northern Europe team held the K2 Europe customer day in Frankfurt, Germany earlier this month. Around 50 customer representatives from Germany,Switzerland, Austria, Ukraine and Scandinavia came together on October 5th at the Hilton Hotel with some key partners including jEyLaBs.

It was a great event that saw ideas exchanged and knowledge shared. People learnt a lot about the latest of K2 technology. In addition to numerous updates to 4.7, Mobile and the new K2 Cloud Platform, there were great presentations by partners and customers and a Best Practice Session.

The day started off with the opening keynote by Ruan Scott of K2 NE. There were sessions by  Markus Alt, Konstantin Riegel, Nicolas Chabrier, André Alfter, Ruben D’Arco, Ivan Slavioglo and our own Gary Sasse on How to Accelerate K2 Success.

The day was rounded off then with an Ask The Experts Panel, in which the team of Andrew Murphy from K2 UK joined. There was a special program by the group of Drum Café Germany. They have played some wonderful drums entertaining the delegates.

jEyLaBs was proud to have supported this event. We showcased our PowerToolz for K2 and many of the customers gave us very positive feedback.

Querying Data with Power BI

Microsoft introduced Self Service BI back in 2009, just around when jEyLaBs was founded, announcing Power Pivot for Microsoft Excel 2010.For several years SharePoint was the answers for the demand to share reports with a team.

Fast forward to 2014 and Power BI was made avaialble in Office365. The first release of Power BI was based on the Microsoft Excel-based add-ins: Power Query, Power Pivot and Power View. With time, Microsoft also added many additional features like Question and Answers, enterprise level data connectivity and security options via Power BI Gateways and many more. Power BI was first released to the general public on July 24, 2015

PowerBI gives you a single view of your most critical business data. Monitor the health of your business using a live dashboard, create rich interactive reports with Power BI Desktop and access your data on the go with native Power BI Mobile apps.

Power BI allows user to connect to the data using two different methods, Direct query and Import. Continue reading “Querying Data with Power BI”

Auditing in Office 365 Sites

The audit feature in SharePoint helps you track user activities. It tells you Who changed What, When and Where.

Providing accurate information and keeping it accurate is critical to any business. Tracking user activity and ensuring data changes are audited is important so that when mistakes happen you can quickly fix them. In most business scenarios, Auditing is a critical business requirement.

In Offcie 365, The SharePoint Online environment provides you with 3 primary configuration options for audit at the Site collection level:

  1. Audit Log Trimming
  2. Audit settings for Documents and Items
  3. Audit settings for Lists, Libraries and Sites

Continue reading “Auditing in Office 365 Sites”

PowerToolz 4.7 is Released!

jEyLaBs just released PowerToolz 4.7. With this release we now officially support K2 4.7.

We encourage all K2 customers to upgrade to K2 4.7 as soon as possible to leverage the latest of K2’s innovations.

You can use PowerToolz to get your regression test suites developed to assist with a smooth upgrade and post upgrade verification.

With this release we have added two new SmartForm themes called jEyLaBs Apple and jEyLaBs Mango. Acquire them for free now from within the PowerToolz Themes Installer.

We also Support looping in SmartForm and SmartObject test script execution. This allows you to kick off multiple forms submissions with a single script execution call. Great for load testing.

Also, Multiple SmartView instances in a single SmartForm now gets special support with test scripting.

Please Request an evaluation of PowerToolz 4.7 at http://powertoolz.com.au now!


K2 4.7 is right here, right now!

The wait is over and K2 4.7 is yours to experience now. Head over to the K2 customer portal and get your hands on it. It is worth the wait.

This release includes enhancements on end-user experience including K2 Mobile, Universal Windows App, SmartStarters, and deeper DocuSign integration. It also includes capabilities that empower technical teams with a new REST broker with Swagger compatibility, K2 Management, Application Lifecycle Management (ALM) and more.

K2 now supports SharePoint 2016 and adds key enhancements to performance, forms rules and registering web applications, which simplifies application registration and activation management for the K2 for SharePoint app.

For more information on the supported third-party product versions, please see http://help.k2.com/blackpearl/support-matrix.

Check out our tips on upgrading to K2 4.7.

jEyLaBs has been working with the early versions of K2 4.7 and The next PowerToolz for K2 update, Version 4.7, will be released shortly. We will support and enhance K2 4.7’s impressive array of new and enhanced capabilities with a deep focus on Test Automation.

FREE Themes for K2 SmartForms

We are excited to be releasing a number of New Themes for K2 SmartForms. These are made available for FREE via the Theme Installer tool in PowerToolz for K2.

We have released the first of these Themes – jEyLaBs Orange – now. You can get hold of this exciting new Theme by downloading the Latest PowerToolz (version 4.1) from the PowerToolz website.

Please Fill out the PowerToolz evaluation form and get this theme.


Run PowerToolz on the server where SmartForms is installed. Go to Theme Installer node, select jEyLaBs Orange and click install. A quick IIS reset will be prompted and you are good to go.

Two additional themes, jEyLaBs Apple and jEyLaBs Mango are in the making and will be instantly available once they are released. You will be able to install them with a single click from within PowerToolz.

Please let us know what you think of jEyLaBs Orange. You can email us at powertoolz@jeylabs.com.au

Should you Buy or Build?

The Buy vs Build argument has been around ever since we had reusable code. We face this every time we propose a solution to a customer problem. This question somes times surfaces as Cloud vs On-Prem. This also affects businesses that have invested in a legacy platform such as Lotus Notes or a homegrown system that is clearly outdated.

Do you buy a product and customise it to your needs or build a solution from the ground up to meet your requirements? Nobody writes a database or an operating system anymore. We license them and build solutions on top of them or buy products that uses these as prerequisites.

These days we are used to platforms and we have our preferred choice of toolkit.

Which way we go depends on whether we have a clear case presented. If we can meet 80% of our requirements by using a solution or product then customising the rest should be an obvious option. But what if that 20% of the requirements could cost you a whole lot more to customise or impossible to achieve? What if 10% is the most critical of requirements?

What happens if the company that produces the product or solution you are going to use as the base goes out of business or get bought out by your competitor?

What happens if you decide to build it yourself and the key people of your team go missing? What if your team couldn’t solve a critical Scalability, Performance or Security related issue with your code or integration or customisation?

What if you invest in a product and suddenly there are much cheaper and better options become available in the next 8 months?

What if you couldn’t be sure of your entire requirement set? What if your business requirements completely change in 6 months?

There are many aspects that affect which way you decide to move. 

What is more important is that you consider all avenues and make an informed choice. Once you make it stick to your guns and see through it.

jEyLaBs specialised in Application platform migrations and modernisation of legacy systems. Reach out to us, if you need any help with your Buy or Build decisions.

PowerToolz V4 is available!

PowerToolz V4.0 has been released.

This release includes the following new features and enhancements:

1. Multi Tab control support for SmartForms is now included. You can script SmartForms with multiple tab controls.

2. Configurable Control activation delay is added into PowerScript. This allows you to add delays into the test script such that real end user behaviour can now be mimicked very closely.

This delay configuration allows for SmartForm controls to be activated and PowerScript will wait for longer period of time before activating the next control as required by the test scenario.

3. You can now customise the SmartForm control assertion failure messages as you wish.

4. You can now setup unlimited assertions against any Smartform control.

5. We have added More Random data generation functions to PowerToolz. You also have test data templates for generating randomised input that looks more realistic.

6. You can now Send Log files and a screenshot to PowerToolz support team with a single click of a button.

7. We have added more Filtering options in the  UI allowing you to narrow down the information you see quickly.

8. Process management feature performance is improved and UI is enhanced to handle thousands of instances.

9. SmartForm scripting UI is now improved to list controls under specific views and it groups them by views. You can also move Views and controls as you wish.

Now, Head over to and download the latest version.

More information on PowerToolz is available at http://PowerToolz.com.au/FAQ


5 Steps to Turn BAU into BI

Are you that person who looks at tables and rows of data and performs data manipulation all day long to create charts and reports?

How many times in the past few months, you wished you could see relations between different data trends in more than one way?

Are you still waiting on your development team to create that dashboard you asked for last month? Did you ever wonder getting your dashboards onto business executives’ phones could be a lot easier?

Well, your wishes have finally come true. Welcome to the new way of converting your data into business insights in no time with Microsoft Power BI.


Read more at jEyLaBs.com

Why should you Automate your Accounts Payable?

We were at the Melbourne #Office365 Saturday presenting our Accounts Payable solution using  #K2 #Abby and #PowerBI. Check out this short video we made covering that presentation.


1. The Australian economy, although not huge compared to many western nations, is made up of complex supply chains.

2. SMB sector is a core part of This supply chain and does not have proper systems put in place to optimise their Accounts payable processes.

3. Many organisations are surprisingly still dealing with invoices that are paper based or in image/PDF format.

4. Validation and approvals usually take a long time and impacts the flow of cash within the entire supply chain.

5. Using PowerBI we were able to visualise this and provide insights into this supply chain.

6. jEyLaBs has a solution that uses K2 and Abby, integrated with Office365 to provide an effective solution to Automate your Accounts Payable processes.

Read more at https://jEyLaBs.com/AP