CJSmith dot me

I dump stuff I find useful here

Test Pop3

Published / by Chris Smith / Leave a Comment

Pop3 can be tested via Command line using the telnet executable (Will need to be selected from Windows features). Telnet to the Pop3 server in question, this will test Pop3 is accessible, then enter the username and password. As long as the status is OK then it should work. If not the error should provide […]

My Windows 10 Desktop Settings

Published / by Chris Smith / Leave a Comment

I hate the default Windows settings, I normally run the following to customise the profile to my liking (I don’t like programs grouped and like to see seconds on the clock, I like to show all folders in Explorer, launch Explorer to This PC not Quick Access) ;https://ss64.com/nt/syntax-reghacks.html Set-ItemProperty -Path HKCU:\Software\Microsoft\Windows\CurrentVersion\Explorer\Advanced -Name LaunchTo -Value 1 […]

Remove document protection from PDF files for ABBYY FineReader Engine 10 SDK

Published / by Chris Smith / Leave a Comment

We came across an issue where PDF’s with any sort of protection failed to process via ABBYY FineReader Engine 10 SDK. The PDF’s were placed in a network share and then failed to process. To get around this I implemented a program called Foldermill (Which has a trial to test it with and a very […]

Remove invalid Datalinx WHM Report Records

Published / by Chris Smith / Leave a Comment

Where printers have been removed can cause issues with the user report program where you can control where users print to. The code below simply looks at the printer table and compares with the report control table. BEGIN TRAN –Check number of records which have invalid printers SELECT * FROM “scheme”.”wh_rctl” WHERE NOT EXISTS (SELECT […]

Setup MS SQL Server Alerts via TSQL

Published / by Chris Smith / Leave a Comment

Amend TSQL to your environment, run the TSQL, restart the agent service and test (I find it easy to enter an incorrect username and password). USE [msdb] GO EXEC msdb.dbo.sp_set_sqlagent_properties @email_save_in_sent_folder=1,                              @databasemail_profile=N'<TSQL_MAIL_PROFILE>’,                              @use_databasemail=1 GO USE [msdb] GO EXEC msdb.dbo.sp_add_alert @name=N’Login Mismatch’,                               @message_id=18456,                               @severity=0,                               @enabled=1,                               @delay_between_responses=0,                               @include_event_description_in=1,                              @job_id=N’00000000-0000-0000-0000-000000000000’GO USE [msdb] […]

Tidy Sage Line 500 ERP Temporary Tables via TSQL

Published / by Chris Smith / Leave a Comment

The official Sage Help has a select statement to delete temporary tables, but doesn’t allow an automated way to remove. This script will delete tables so you must take extra care, I recommend trialing this on your Development Sage ERP system first. Review every step and when you are happy Commit the transactions (If run […]

Avoid error “2427 You entered an expression that has no value” when passing a parameter to a form

Published / by Chris Smith / Leave a Comment

To avoid getting an error when passing a variable to a form, using If Not against the EOF (I believe means End of File) property. If Not Me.Recordset.EOF And Not Me.Recordset.EOF Then Dim stDocName As String Dim stLinkCriteria As String stDocName = “someform” stLinkCriteria = “[recordnumber]=” & Me.[recordnumber] DoCmd.OpenForm stDocName, , , stLinkCriteria Else MsgBox […]

Arcsoft Totalmedia Extreme causing issues upgrading to Windows 10 Version 1909

Published / by Chris Smith / Leave a Comment

I recently had fun with being unable to upgrade to version 1909 for Window 10 failing with a BSOD and an error which pointed to a memory issue. After using Nirsoft’s BSOD ViewNirsoft’s BSOD View it pointed to ArcSec.sys. I uninstalled Arcsoft Totalmedia Extreme. however the uninstaller left the drivers installed. I then used SysInternals […]

Powershell issue with output characters changing to ?

Published / by Chris Smith / Leave a Comment

On PowerShell command pipe to export CSV add Encoding Unicode if characters change to ? Credit: Idera execute xp_cmdshell ‘powershell -Command “Get-ChildItem -File -Path @path -filter *.* -Recurse | ForEach-Object {[PsCustomObject]@{Fullname = “$($_.FullName)”; LastWriteTime = “$($_.LastWriteTime)”}} | Sort Fullname -Descending | Export-Csv -Path @CSVFile -NoTypeInformation -Encoding unicode”‘ If using BULK INSERT ensure widechar is used […]