Showing posts from September, 2017

Get into ChatBots NOW, its what your customers want, but don't know it yet

OK, lets cover the basics.  What are ChatBots?  Its a computer program designed to simulate conversation with human users, typically via messenger apps or chat windows.  I’m sure most of you already got that, but I wanted to make sure that we all on the same page here.So why should we focus on ChatBots?  No one is asking for them, right? Wrong.  Companies are looking for ways to engage with their customers in a way that their customers are already familiar with.  Customers don’t want to download an extra app for the companies they engage with so in order to engage with your customers in a manner that is convenient to them, you need to use a medium that they are already familiar with.You may have noticed that chat tools are becoming our clients more natural and preferred way to communicate.  In fact, towards the end of 2016, Facebook announced that they host over 30 000 ChatBots.  These bots can check the weather, order food, organise travel and even play games. China uses WeChat and t…

SharePoint Lists Views + JS Links + Data Tables = Awesome Threesome

SharePoint Lists Views SharePoint lists are the primary building blocks when setting up a SharePoint site. Pretty much any system is designed to takes and give information and SharePoint relies on lists to make that happen.

So list are important, it stores the information you want to share, it sources workflows and forms and it defines how things relate to each other. We rely on List Views to interact with these lists which is great, but these views are created by SharePoint and gives us limited control in how we can configure the interface, which is a shame because sometimes the lists are just too important to rely of the basic configurations.
Thankfully, Microsoft gave us JS links, an ability to influence the way the views are rendered via JavaScript.

JS Links This opens a great new world of possibilities, we can now use JavaScript to read the data from the list view, check if certain conditions are met, and if these conditions are met, we can change the information that needs to…

Transposing a single column of data in Excel with a set number of columns

I was faced with an interesting challenge, I was tasked to provide a list of all the sites available via our O365 subscription, but I was not given sufficient access rights to navigate to the administration portal to pull this list.

In fact, this is the only view I had available to me: 

Selecting, copying and pasting the content into Excel seems like the obvious next step, but alas, I was faced with one column of data with all the information that appeared in my view, i.e. the site title, the news title, the news synopsis the author and the modified date. All I want was the site title. 

After cleaning up the Excel a bit, I noticed that the information that I wanted appeared in every 4th row.  Meaning that if I could somehow transpose this single column of data into a grid with 4 columns, I will easily get the information I want. Unfortunately, this type of transpose function does not exist in Excel.
After a little googling and tweaking I finally derived a formula that will transpose …

Office 365 is changing the rules for Intranets

Before Office 365 (O365), when we were asked to build an intranet, we built a SharePoint solution with an inviting home page and some sub sites that promotes team collaboration. Maybe we added in a few interactive features and "Ta-daaa", your intranet was done.
Now, its the game is different, and many of the players don't even realise this. 
An intranet that is using Office 365 is more than just a pre-defined set of pages that has a starting point and set navigation plan that should be used by all. Its use is now dictated by the users, and if done right, no 2 users will experience their Intranet in the same way. 
We all know that O365 has this new, beautiful SharePoint Communications sites, for example, this site can help promote Corporate-Level communication and is typically seen as an ideal Home Page to an intranet, but why force that as the Home Page to everyone? Everyone is different, with different objectives when using the Intranet, why not make the users chose a hom…