Blog

Using Office Scripts in Power Automate to Generate Graphs without Third Party Connectors or Services

Office Scripts is a relatively newer feature in Microsoft 365. Currently available on Excel Online, Office Scripts allows TypeScript code to execute within the context of Power Automate. It can be used to automate Excel; however, because of its integration with Power Automate it also allows the user to call...

Microsoft Customer Relationship Management Data Migration

Microsoft’s customer relationship management system, better known as Microsoft CRM, is a tool used by companies to organize, track, and maintain healthy relationships with its clientele. It’s not unusual for businesses to be a few updates behind the newest software. In order to migrate a CRM server to a newer...

User Centred Design at Spot Solutions

User Centered Design (Human Centered Design) is a design and development approach that keeps users' needs and goals as the focus of the design process. Solutions begin and end with the end user in mind. By involving human perspective in all phases of the process, a product is produced that...

Creating your first Phonegap (Cordova) application

Before starting, it’s worth knowing the difference between Cordova and Phonegap: Apache Cordova is mobile application development framework. In 2011 Cordova was purchase by Adobe and rebranded to PhoneGap. The open source version of PhoneGap continues to be released as Apache Cordova. Apache enables software developers to build mobile applications using HTML5,...

Build or Buy: Deciding between Custom Software or COTS

You need software to run your business effectively. It is a core tool of your business operations and your people depend on it. So when should you buy Commercial Off-The-Shelf (COTS) software and configure it for your needs; and when should you consider a custom software solution? The reason I started...

SharePoint Saturday – A Hacker’s Dream: SharePoint Talk

A recent study shows two-thirds of SharePoint users have no security policy !! Ian Naumenko is the Director of IT and Security Operations at Spot Solutions. He has worked with SharePoint since its inception (Taho). He is also an expert and certified as an Information Security professional. The combination of the...

How to prepare for Custom Software Development

At Spot Solutions, we make sure that your quality custom software is delivered on time and on budget. To achieve that, we have to build a productivity tool that tailors to your business needs. Here’s a guide to how you can help us achieve the business purpose of the software. General...

Automated Tests Use Case with CMC

Working on the CMC Sensor Monitoring project, we found the test utilities in Visual Studio to be very helpful. One of the components of the CMC system, web service, was utilized by gateways in the local network. The gateways relayed data from a series of sensors, this data was then...