I’ve posted series on a few different ISV addons for Microsoft Dynamics GP over the last few years, but, somewhat ironically I guess, have not posted all that much about the addin I’ve used the most over the years.
SmartList Builder allows you to create both brand new SmartLists or modify existing SmartList. You can link up to 32 tables together. Tables can be standard GP tables, any of the Third Party (ISV) tables, any SQL table, SQL views or SQL Scripts, other SmartLists or Extender resources.
This series is going to cover the implementation of SmartList Builder; I’ll take a look at report builder in a future series.
When the Pi-hole is installed, you have the option to select which blocklists should be used. The blocklists will be downloaded at that point, but need to be kept up-to-date. Fortunately, there is a cron job which runs automatically once a week and updates these blocklists.
If you want to run a manua update of the blocklists, log into the Pi-hole admin interface and select Tools and then click Update Gravity; when the page loads, click Update:
The update may take a few minutes to complete; when it is finished, a message bar will be displayed:
When using a Pi-hole to block adverts, you will come across sites which you want to access, but which are being blocked. The message you will see is not readily apparent that the site has been blocked by the Pi-hole:
This is because the error message is displayed by the browser and all it knows is that the site didn’t respond; it does not and cannot know that the failure was because the DNS query had been stopped by the Pi-hole. Fortunately, the Pi-hole project has a solution to sites being blocked when you really want to access them in the form of creating a whitelist. It is also easy to add a site to the whitelist.
To add a site to the whitelist, log into the Pi-hole admin interface and select Whitelist on the left pane:
Enter the domain to be whitelisted and click the ,em>Add button. All requests to this domain will now be allowed through without being blocked.
While the Pi-hole has worked very well, there are times when I’ve had issues and wondered if it was the Pi-hole causing them. One of the good features of the Pi-hole is that it is very easy to temporarily disable it, which allows you to either easily rule out the Pi-hole as the cause of the problem or confirm that it was responsible.
To temporarily disable the Pi-hole, log into the admin interface and click Disable on the right pane:
As you can see in the screenshot, above, there are a few disable options. You can use one of the default disable times or enter a custom length.
When you select a time, Pi-hole will be immediately disabled and show the remaining time it is disabled in the right pane:
Once the disabled time expires, Pi-hole will re-enable and resume the blocking of ads.
I created a customisation recently for a client which would generate a Vendor ID based on the name, by removing alphanumeric characters. In order to make it as flexible as possible, I created the function to accept a parameter for type which will cause the function to strip different characters:
A – leaves alpha characters only.
N – leaves numeric characters only.
AN – leaves alphanumeric characters.
The second parameter is the string which should have the characters stripped:
IF OBJECT_ID (N'uv_AZRCRV_StripCharacters', N'FN') IS NOT NULL
DROP FUNCTION uv_AZRCRV_StripCharacters
CREATE FUNCTION uv_AZRCRV_StripCharacters(@Type VARCHAR(100), @String VARCHAR(MAX))
Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (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).
DECLARE @PatIndex VARCHAR(20)
IF (@Type = 'Alpha' OR @Type = 'A')
SET @PatIndex = '%[^a-z]%'
IF (@Type = 'Numeric' OR @Type = 'N')
SET @PatIndex = '%[^0-9]%'
IF (@Type = 'AlphaNumeric' OR @Type = 'AN')
SET @PatIndex = '%[^a-z0-9]%'
WHILE PATINDEX(@PatIndex, @String) < 0
SET @String = STUFF(@String, PATINDEX(@PatIndex, @String), 1, '')
GRANT EXECUTE ON uv_AZRCRV_StripCharacters TO DYNGRP
With the router directing all DNs queries to the Pi-hole, it will use the loaded block lists to stop adverts from those domains being loaded. I’ve found the experience of surfing the Internet far smooth since I installed the Pi-hole. The amount of data has also noticeably dropped.
I have been white-listing some sites which do not have overly intrusively adverts (no sound, no video or moving images). I’ll cover white-listing later in this series.
I recently got a new laptop at work which meant getting all applications installed. Previously I’d had Microsoft Office 2016 installed; on the new laptop I got Microsoft Office 365 which came with AutoSave enabled by default in all of the applications, such as Excel and Word, for files opened from SharePoint Online:
You can switch off AutoSave using the slider at the top, but this is not remembered.
I did some exploring and found a setting in the application options to switch off AutoSave by default. To change this setting in Microsoft Excel, click the File menu and select Options. Click the Save tab and mark the checkbox next to AutoSave OneDrive and SharePoint Online files by default on Excel. Click OK to save the change:
Next time you open a SharePoint Online file, AutoSave will be off by default: