Day: April 29, 2019

Adventures With A Raspberry Pi: Series Index

Ian Grieve2 minute read9 Comments

Raspberry PiI’ve looked at the Raspberry Pi a number of times over the years, but never bought one as I both lacked a convincing use case and have virtually zero experience with non-Windows operating systems. However, more recently, I have reached my limit with how intrusive online adverts have become and have finally bought a Raspberry Pi and installed Pi-Hole.

I have a number of posts about my adventures with a Raspberry PI in which I am going to be looking at how to assemble and install the Raspberry PI as well as my experiences with Pi-Hole and probably some other software.

If you’re reading this post on azurecurve, this index will automatically update, otherwise you need to check back to the original post.

Continue reading “Adventures With A Raspberry Pi: Series Index”

Implementing SalesHQ Portal: Portal Deployment on Azure

Ian Grieve2 minute read0 comment

SalesHQ PortalThis post is part of a series on Implementing SalesHQ Portal, which is one of the GP Elementz Portals from my new employer, ISC Software Solutions.

This is a step which ISC Software will perform, but some information is required for this to be accomplished. In the last post in this series, I showed how to register a company with SalesHQ; this generated a unique GUID for each company.

For ISC Software to deploy the portal, they need the Company ID for each company registered.

Run the script below against your Elementz database, to extract the CompanyID GUIDs:

/*
Created by Ian Grieve of azurecurve | Ramblings of an IT Professional (http://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int).
*/
SELECT
	DynamicsDB,CompanyDB,CompanyId
FROM
	CustomerPortalCompany

Once you have this information reply back to the Azure settings email you received before installing the connector service.