Sign in Subscribe

Topic

Useful Script

A collection of 30 posts

Stop windows lowering the music volume when a call starts

We've started using Sqwiggle to aid remote working which is awesome. The only issue is recently I've noticed that when someone starts a conversation or sends an instant message Spotify and Windows Media player reduced their volume and wouldn't come back up. Turns out

Quickly delete Umbraco nodes by document type in SQL

Ever needed to delete all nodes by a document type or delete all nodes from the recycle bin in Umbraco? This little script should help. Delete Umbraco nodes by Document Type Alias BEGIN TRAN DECLARE @Nodes TABLE (NodeId int) INSERT INTO @Nodes (NodeId) SELECT top 1000 n.id FROM cmsContent

How to: Delete duplicate products from a category in uCommerce

I was looking into an issue with one of our sites that couldn't delete a product from a category in uCommerce today and noticed that there were a lot of duplicate product-category relationships in the table. Deleting them is fairly simple so I thought I'd share

Add every country to uCommerce

Something I learnt the other day was that uCommerce uses the culture code you specify for a country to determine the two/three digit ISO code when sending the order to the payment gateway. This is fine if you know all the various countries -but I didn't so

Quickly delete all products and orders from uCommerce

Note: An updated version of this code for the new Ucommerce schema is available here: https://thesitedoctor.co.uk/blog/delete-all-products-and-orders-from-ucommerce/ Sometimes you need to blitz your uCommerce database e.g. just before launch or to remove the testing products etc. This is a quick database clear script which will

Script to migrate an SVN repository to Git including commit history

We started using source control years ago and have a load of projects still on SVN. As great as SVN was at the time, we've moved over to Git (if you've not already done so, you really should) but needed an easy way of migrating repositories

Output the currency symbol in uCommerce

One thing that's always bugged me about uCommerce is the way the prices are displayed (using the not so inviting ISO codes), this is a simple switch statement to output the (prettier) HTML symbol instead. <xsl:choose> <xsl:when test="@currency = 'GBP'

Remove uCommerce Product Definition Field in SQL

Sometimes you need to remove a product definition field from uCommerce e.g. one created in a test environment. Although you can just right click and click "delete" within the administration area, this sometimes doesn't work e.g. when it's a pre-release so this

Download any Umbraco document type’s values as crosstab/Excel table

In a follow up to my post yesterday -How to download Umbraco content properties into a crosstab table this is the follow up SQL Script that makes it even easier to download any Umbraco document type into Excel. This SQL Script is fairly simple, basically what it does is it

Search every table and field in a SQL Server Database Updated

As some of my blog posts are a little out of date, I thought I would spend some time updating the most popular ones. As I use this script on a regular basis and there was an error with the original posting, I thought I'd update it with