Client powered leaderboard

dashboardIn our custom leaderboard, we have presented statistics for the top
persons in different categories. The log of all activity from our
Fitbits is fetched using AJAX from Sharepoints REST API. The data is
then processed client side using javascript, before being presented.

The javascript code traverses all of the data and aggregates the total
steps, floors, distance and sleep over the last seven days. The total
minutes of sleep over the last seven days is divided by (7 * 60) to
calculate the average hours of sleep per day. We also calculate the
average step length per person by dividing the distance in meters by the
number of steps.

Afterwards, the data is sorted for each of the categories we present, so
it can be presented in the correct order. At last, we update the content
by inserting the final data in each of the categories.

Applying for:

I’m a hipster baby

To make our solution extra cool we had to move outside the Microsoft universe and integrate with the most super cool and awesome chat client, Slack!

Since most of the user is likely to spend more time in Slack than on Sharepoint it is important to notify Slack once something important happens on Sharepoint. That’s why we used Slacks awesome web-hooks to post updates every time there is a new announcement in Sharepoints newsfeed. Using the power of the force(a.k.a. jQuery) Darth “Sharepoint” Vader spreads the news to our #general channel.

Skjermbilde 2015-02-28 kl. 14.27.14

Since Slack is way cooler than Yammer we decided to not include Yammer in our solution(it would de-awesome the final product) and instead went for Slack as our main chat client. Because of this we feel that this qualify for the “yam yam gimme some” badge, only that in our world we would refer to it as the “Give us some Slack” badge.








Going for:

iTerroristas extreme final business delivery value – No Worries Mate!


Envision the future with healthier people strolling around without worries.  Without financial worries, without health worries. Organizations suddenly have funds to pay better salary, and have poeple working fewer, more productive hours. Allowing for more, free family time for all.  People will move more on their own two feet, bikes and rollerskates. The government will have more funds (partly because of fewer sick leaves, hospital and rehabilitation payments). So we will get better infrastructure, better education, better healthcare and lower taxes. Fewer cars on the streets, less pollution, greener environment and more parks and recreation.

Nice eh ?

All of this will come true on account of our Step Wars solution.  Further business value details can be found here

Our simple 1,2,3 GO! approach is extremely effective and is proven user adoption fairy dust magic!

1. We draw people in with our fun gimmicks and wearables


2. We get them interested through competition and extremely cool and useful, interactive user interface










3. We keep them going because of realization of health benefits and general *feeling goodness*!


We use gamification and workflows to remind everybody how they are doing. We set up several different APIs, available in the cloud, in order to have a scalable solution and possible reuse of services later on in the progression of the product.

The remarkable weird campers

For the Iterroristas scientific work is very important. We believe that proper research is the best, and only way, to success. That’s why we only bring the best gear to work to make sure we get the correct result.

campers1Looking the part, but maybe the dry ice and plastic microscope isn’t fooling real chemists, who knows?

We are, however, real computer _SCIENTISTS_. The camp was themed for “Hacking the body” (with science), based on our concept to motivate people to be healthy using fitness trackers.



Our big mistake:

We decided to compose our lineup with mostly non-SharePoint consultants. Only two people were using Windows. Two were using OS X and the last two were using Linux. And the two windows-users are composed of one newbie and another that stopped writing code six years ago. This resulted in plenty of frustration when SharePoint wasn’t doing what we thought it was supposed to do. Next year we will be packing more SharePoint expertise in the group.

Nonetheless we survived the weekend (we’re still friends). And even if we missed our biggest goal for the weekend (the cup-flipping competition) we consider this a successful event.

Going for:

PointTaken – final submission ASPC 2015

Red Button Marketing
Red Button Marketing (RBM) is a PR agency that has specialized in helping companies and persons to promote themselves in social media.
RBM helps the company/person to identify what the hottest topics within their profession are.
RBM’s solution scans new blogs, tweets and hash tags posted by high profiled persons (lead stars) within the industry. This is how the company knows what the latest and greatest is and what they should blog about next. The solution also lets other people within the company come with suggestions for new company blog posts. Case officers write the blog post.
When a blog post is approved and published the red button starts blinking and the button is “armed”.

A Sith lord or commander pushes “The red button” (a physical red button). This trigger an event that at first blogs the spams social media such as Twitter, Facebook and LinkedIn with a link to the blog post.
In this way, the company or person shows the world that they too are experts within their field of profession.

Logging into SharePoint
When users log on to SharePoint they are routed to their correct role-based dashboard.

User pop-up for routing:
user route

Editor pop-up for routing:
editor route

Case Officer for routing:
CO route
Flow chart of the process

Visio Process- Red Button Marketing

Flow chart explained
New suggestions are either added by users or by a search service. The search service is a configured Google Custom Search, but can be hooked up to any open search proivder. The search is configured to be scoped on several sites like TechNet, Social, yammer, facebook, twitter, etc. The search is done with a set of “buzzwords” distributed through a SharePoint list. The list of buzzords can be filled by registering leaders in the community and their hashtags or buzzwords.
The articles found with the keywords as searchterms will be grabbed and title and url to blog post is added to a SharePoint list. Users add new suggestions from the user dashboard.

The search service
To meet the need of our customers, we need to be able to find new and relevant articles on the internet. The search is done with a set of “buzzwords” distributed through a SharePoint list. The articles found will be grabbed and handed over to SharePoint Online and included in our internal workflow/production.
The solution consists of three parts.


We have configured a Google Custom Search. The search is configured to be scoped on several sites like TechNet, Social, etc, but – important: we’re NOT searching the whole internet.
Unfortunately the Google Custom Search only offers 100 free searches before we will have to pay. As a company, we would off course have paid the price – right here on ASPC2015 we don’t do that. Because of that, we’ve been forced to keep manual control over the Google search (else we would’ve ran out of fun within 5 minutes ….)


We have a server “out there” – from now on referred to as “The Bergen server” – on which our search app, resultstorer and services runs.
The first application is the controller. This app is executed manually to avoid running out of free search queries. When executed, this app takes the first buzzword and kicks off the second application. This application implements a call to the google custom search and receives the results before it calls our third application. This application stores the results in a database on the Bergen Server.
The forth app on the Bergen Server, is the app that hands over the search results to SharePoint Online when called. This app may be configured to only send results registered since day x, week y or – for that sake – all findings stored.

We have created a provider hosted app in Azure. This app looks pretty simple with one single button – but it has a very important job.
When the button is clicked, the app makes a call to our Bergen Server and gets all the latest search results found. When received, the app begins to iterate them. Every new item will be stored in the SharePoint list “Suggestions” – but NOT before we’ve checked if it already may exist in the list. The check is done by looking at the incoming items Google Cache Id and if there are items already stored with the same id (Google Cache –yes, that “dies” after a while – but in production, our scope is never longer than 1 to max 2 weeks. Checks shows that the Google cache lives longer for items that are created within the last or two weeks.

The user dashboard contains a add-new-suggestion button, a Visio web part which is connected to the suggestion list, and a web part showing filtered suggestions. The Visio web part is clickable and filters the suggestion list web part based on status (new, blogs in progress and blogs published). The picture shows the user dashboard with filter on published blogs.
User accepted

When new suggestions are added an editor is alerted by mail through a workflow. New suggestions are also shown in the editors dashboard.
editor dash

The dashboards:
The dashboards is made entirely on the client side and all the files are stored in Site Assets. By leveraging User Custom Actions we have deployed two js-files via the scriptlink. The files are jquery (always nice to have ready for action, and a small file called appLoader.js. The appLoader.js helps our development environment (hello SublimeText!) and extremely small-footprint clientside development.
The whole appLoader is the following code:


This means that are apps can be developed side by side and without the .tmp-issues that tend to follow mapping the O365-folders to your own machine.

Case officers dashboard:
CO dash

The editor assigns a new suggestion to a case officer which writes a blog post. When the blog post is written the editor decides if it’s ok or not. If it’s not ok, it gets sent back to the case officer for more editing. When a blog post is ok, the editor changes status field in blog post by clicking on a button. This updates the suggestion list item and posts the blog post on WordPress. Then the the physical red button gets armed.

When the red button is pressed a blog post is created on wordpress (or your flavour of the month blogging-tool)

This is the internal blog:
internal blog pt

This is the WordPress-blog that starts everything.
wordpress pt

with the use of it then publishes a post on facebook, twitter, and yammer with a link to the newly posted blog. This can of course be added on to more social media accounts.

twitter tweet blog

facebook PT

Vader implements more control

Vader is kind, deep in his hear. He want to implement a tool to let the his employees work effectively together. So Windows app is the thing.

When employees starts the app, they will choose what role do they have for the day


And then work 🙂




Submitted data will be stored in SP list in Office 365.

With this we are aiming for:



Final Delivery – Vader Fleet Control (VFC)

Vader group has a storied past, and we are proud of our long history. Our history is part of our platform for future success and thus intimately linked to our present activities and future goals. We are under a constant developing to be ahead of the “light side”. We are now aiming for the clouds and developing a new systems based on SharePoint to control our entire fleet.

The fleet control system
The fleet control system keeps tracks on every ship in the fleet, provides a state of the art dashboard for our pilots and commander.

The Pilot Dashboard (TPD)
The TPD is a one of a kind control system for our pilots, providing every pilot with a computer it only have to launch the app, and they are ready for battle.
TPD contains only the necessary to keep our pilot in the air. A map of the galaxy with real time view of fellow pilots position.
TPD has information about what ship you are flying. You don’t need any old-school turnkey to get this baby flying- just hit the green button and you are off! TPD also has a distress system that easily call for help with one button click.
Yammer is embedded so the pilots can communicate between each other and our bases.

Command center
This is Vader’s tool for keeping up all the ships and their pilots. A list of all his pilot and a map of the galaxy with real time view of the pilots position and status. With a yammer feed, the commander is updated with all the communication between the pilots

Intelligent reporting
Dex Vader needs efficient and powerful reports to manage his growing empire. His new SharePoint solution needs to be able to give him the data he wants without needlessly navigating through a maze of files and metadata.

To make his job easier the Skill Wizards have created an AMAZING reporting dashboard that can be used to get a overview of the ships based on the lists for ships.
In addition the Skill Wizards have implemented a performance based KPI report which is available on the home dashboard for all troopers to view and update, which tells them who are most likely to be death gripped next. Initial reports has showed a significantly increased fear/respect for the great leader, combined with the new, fantastic user experience.

TPD Alert
In war, not only the commander needs to be updated. Vader has a whole command center department(CCD) who needs to be alert. They need something visual to know when something is going down. We created TPD Sphero Alert integration in already great solution :-) . It flashes red and notifys all the CCD.

Lots of value for (almost) no money. Now the whole CCD knows when something is going down.

Fleet commander app
From the TPD we have seen a demonstration of the Distress button and the messaging service for alerting the Fleet Commander. The Fleet Commander need immediate alert when a Ship sends Distress signal even when they are on the run. The Fleet Commander App is the solution. It notifies the commander when he is not around his Command center dashboard.
He even get the notification on his Vader Watch

The Pilot sync
As pilots are short lived in the Star Fleet, the on boarding process for new pilots are important. The Pilot Synchronization workflow makes it easy for the commander to recruit new pilots.

Vader Gate
At Vader Enterprise we have a lot office of employees.. They do all kind of amazing stuff that’s really cool.

But we have a problem, sometimes they write, and send, things that are not within company policy.
We can under stand this, the office can be a big and confusing place, it’s not easy to know whats “ok” or “not ok”

Dex vader on the other hand is not that forgiving all the time…

And even tough office workers are expendable, it’s a real hassle to go through the hiring process, training process, etc, etc on a weekly basis…
So we have developed an office app that is in both our office employees interest and our own.

It warns the user if there is some phrase that would make the commander fire/kill his employee.

Vader Periodic Ship Inspection
At Vader we take the safety of our pilots very seriously. All the ships are required to go into inspection each year.
At the inspection we have a detailed list of checkpoints and each component is given a score based on its state.
Based on the number of faults we will get a binary inspection result: PASS or FAIL!
>Ship Shop
When Vader wants new ships to he’s army, hi is only one button away from ordering he’s ships

Final Delivery: Vader’s Retirement Plan Restaurant

Looks like that Darth have a different retirement plan this time, he thought opening a restaurant is a good idea, however he believes that technology and process automation is good idea running his retirement plan, therefore he seeks the help of a professional geeky team!

The Infozurgs presents Feast!

Feast is a restaurant management solution, that facilitates “Darth Vader’s Diner” through its day-to-day work efficiently and effectively; starting from online food delivery, restaurant table management, and ending by a back end management portal.

Feast is hybrid solution (Office 365 and on-prem), along with a windows app table management solution.

Feast Online (Office 365):

Is the public facing solution, that include the following modules:

  • Food Delivery (With Menus): users can choose food items from available menus, and order food to be sent to their planets. know that this is an automated process, food will find its way to you!

Order Food

Order Delivery

  • Feedback and Complaints: no more unhappy customers, we are all ears!

Nintex form

External List Complaints

Feast On-prem (SharePoint 2013):

Is the back end solution, which include an internal management solution which provides:

  • Sales: We got all the charts that a CEO like Darth would need.

Claims Total Per Category Claims Percentage Sales Delivery per month

  • Table Management Monitoring: Darth would like to keep track of the tables status in the diner.


  • Yammer in action: Get exposed if you are not doing you job.


Feast Table Management (Windows App): 

Is a windows app that enables waiters and chefs collaborate and organize their daily tasks. Taking orders, passing it into the kitchen and back to the customers again is no longer a headache. The app module includes:

  • Dine in Management: Taking orders, passing it to the kitchen and pick up ready orders back to the customer.