Yesterday I participated in the Hackathon at European SharePoin Conference in Stockholm. The main goal was to learn more about Office Add-Ins. I wanted to create a very very simple app to learn the basics. Here in this post I’ll provide some links and describe the steps needed to start developing your Office Add-Ins.
The Add-in I created is an Outlook Add-In, it is called “Joke Inserter” and with it you can insert a random Chuck Norris joke. It is just for fun, but it demonstrated how an add-in can be installed, made available in “New E-mail” and interact with the e-mail you are writing.
All the code is on github. The random jokes come from The Internet Chuck Norris Database. As I said, the jokes were just for fun, this add-in is of course, not a business app. During the hackathon I got help from Pretish Abraham, Jeremy Thake and …
This is the result:
- Any OS, I happened to have Windows :)
- git, nodejs, npm (they should be in the $env:PATH)
Install following npm packages globally:
npm install -g tsd yeoman generator-office gulp
Creating the Add-In
Now with the yeoman support it is very easy:
Create a folder and scaffold an app:
After that update the manifest file: Icon Url, and Support Url
Start the application on localhost:
Go to your Outook.office365.com. Click on Manage Apps and add the manifest file from your solution.
Now when one is done with that simple fun add-in, it is very easy to go ahead and create real add-ins that provide value to you and your colleages.
Today I found a nice Visual Studio Extension for working with localization and resx files: Resx Resource Manager. This extension provides an additional view in your project and scans all the resx files. I would recommend it to all projects where you have to translate your interface. Here is how it looks in my project:
It can also assist with some machine translation from Bing and MyMemory:
Another good thing is the Export and Import to and from Excel. Wonderful if you need help from Non-developers.
var uri = _spPageContextInfo.webAbsoluteUrl.replace(/https?:///i, "\\").replace(///g, "\");
window.prompt("Copy to clipboard: Ctrl+C, Enter", uri);
Recently I have looked more at IoT, Raspberry Pi in my spare time. In my blog post I want to share my experience in a series of posts. This post is about measuring temperature, humidity and pressure with Raspberry Pi 2 Model B and Sense Hat and posting this data to Azure Table Storage.
I followed this tutorial for connecting to azure with python and these instructions for reading data from Sense Hat.
The python script is on github. Along the way I learned that only python 2.x can be used with azure and table names cannot contain underscore (I got Bad Request error when I tried to create a table with the name “climate_data”). But overall, the process was straightforward. The temperature is not correct, maybe because the sensor is inbetween Raspberry Pi and Sense Hat where it gets warm. But it is just a Proof-of-Concept.
I have used Visual Studio 2015 to see the data in Azure Table Storage. For that I needed to install Azure SDK 2.7. There are many other “explorers” for Azure Storage.
Accessing Azure from Linux and Mac