Day: March 19, 2019

azurecurve ClassicPress Plugins: Filtered Categories

Ian Grieve2 minute read0 comment

ClassicPress PluginsThis is part of the azurecurve ClassicPress Plugins which introduces the plugins I have available for ClassicPress.

The plugin I am going to cover in this post, is an existing one which has been brought up to standard brand new one; Filtered Categories.

Functionality

The Filtered Categories plugin adds a new widget which can be used in the sidebar, or other widget areas, which can be set to include or exclude certain categories; widget details are configurable and allows a link to be set to a full category list on a page.

Demo

The Categories widget in this sites sidebar uses this plugin to present a much shortened list of categories; the full category list can be found here.

Download

The plugin can be downloaded via my Development site.

Click to show/hide the azurecurve ClassicPress Plugins Series Index

azurecurve ClassicPress Plugins
Add Twitter Cards
Avatars
BBCode
Breadcrumbs
Call-out Boxes
Code
Comment Validator
Conditional Links
Display After Post Content
Filtered Categories
Flags
Floating Featured Image
Icons
Images
Insult Generator
Loop Injection
Mobile Detection
Multisite Favicon
Page Index
Post Archive
RSS Feed
RSS Suffix
Series Index
Shortcodes in Comments
Shortcodes in Widgets
Sidebar Login
Tag Cloud
Taxonomy Index
Theme Switcher
Timelines
Toggle Show/Hide
URL Shortener
Add Open Graph Tags
Markdown
To Twitter
Nearby
Gallery From Folder
Taxonomy Order
Snippets
Widget Announcements
Events
From Twitter
Update Admin Menu
Maintenance Mode
SMTP
Check Plugin Status
Estimated Read Time
Username Protection
Remove Revisions
Disable FLoC
Redirect
Contact Forms
Strong Password Generator
Load Admin CSS
Support for Plugins
Translating Plugins
All plugins now auto-update

Delete Corrupt Fixed Allocation Master (GL00103) Data

Ian Grieve2 minute read1 Comment

Microsoft Dynamics GPI was recently putting together a report for a client on Fixed Allocation Accounts and came across some corrupt data in the Fabrikam, Sample Company, Database. To avoid encountering this issue again, next time I am working in this area, I put together a simple script to remove the corrupt records by joining Fixed Allocation Master (GL00103) with Breakdown Account Master (GL00100) to identify the data which should not be there and delete it; this makes the script generic enough that I can use it on a live company should the need ever arise.

/*
Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (https://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).
*/
DELETE FROM
	['Fixed Allocation Master']
FROM
	GL00103 AS ['Fixed Allocation Master']
INNER JOIN
	GL00100 ['Account Master']
		ON
			['Account Master'].ACTINDX = ['Fixed Allocation Master'].ACTINDX
		AND
			['Account Master'].FXDORVAR = 2

As always, before you run any script, ensure you have a good backup of your database and verify the results after the script has been run.