Contact us on: +44 (0)1432 617 006

The Site Doctor Blog

Footprints in the snow of a warped mind

  1. Apr

    Delete all products and orders from Ucommerce

    Here's an updated script to delete all the products, orders and any other testy type data from Ucommerce. This is an updated version of my previous script to delete all product and order data from

    Posted by: Tim on Tuesday, April 23 2019
    Read On

    Leave your mark

  2. Drop/Kill all connections to a SQL Database

    Every now and again you need to get exclusivity to a database e.g. to do a database restore but someone is connected. You can manually find who it is using EXEC sp_who but that can result in having to

    Posted by: Tim on Thursday, April 04 2019
    Read On

    Leave your mark

  3. How To: Automatically set Umbraco folder permissions after AppVeyor deploy

    We've been playing more with AppVeyor over the past few weeks to automate the deployment of our sites and one of the things we got caught out with was the Umbraco folder permissions which we do with

    Posted by: Tim on Tuesday, April 03 2018
    Read On

    Leave your mark

  4. Aug

    Error editing Ucommerce marketing campaign

    We came across an odd error recently which was thrown when editing a marketing campaign in Ucommerce. It was a fresh install (albeit via nuget) and was along the lines

    Posted by: Tim on Thursday, August 30 2018
    Read On

    Leave your mark

  5. Mar

    How To: Quickly Set Umbraco File and Folder Permissions with PowerShell

    In 2010 I blogged about how to set Umbraco folder permissions using PowerShell. This has been a really handy snippet -but it's always been a bit of a pain when dealing with new servers, remembering

    Posted by: Tim on Friday, March 16 2018
    Read On

    Leave your mark

  6. Feb

    How To: Return the customer to your site after paying with WorldPay

    Stripe is generally our go-to PCI compliant payment gateway but from time to time we're asked to use alternatives such as WorldPay. For the most this is fine but redirecting the shopping from WorldPay

    Posted by: Tim on Wednesday, February 14 2018
    Read On

    Leave your mark

  7. Jan

    Group Newsletter Studio mailing lists by name in the Umbraco backend tree

    In a follow-on from my previous post about how to Group Newsletter Studio newsletters by month in the Umbraco backend tree. This is a quick post to give you an idea of how to group the mailing lists

    Posted by: Tim on Monday, January 22 2018
    Read On

    Leave your mark

  8. Group Newsletter Studio newsletters by month in the Umbraco backend tree

    One of our customer's websites uses the Newsletter Studio Umbraco package to manage their mailing lists but had an issue because they send a lot of emails (40+ a month) so the draft/sent/archive

    Posted by: Tim on Thursday, January 18 2018
    Read On

    Leave your mark

  9. Dec

    GDPR Data Flow Diagram Template

    GDPR (General Data Protection Regulation) is one of the hot topics at the moment and we've been helping clients get their website ready for the pending changes.One of the trickier required (but

    Posted by: Tim on Monday, December 04 2017
    Read On

    Leave your mark

  10. Oct

    View the property values in SQL for latest version of a page in Umbraco

    I've previously blogged about how to download any Umbraco document as a CSV from SQL but we hit a slightly different issue today and needed to view the values for a property in SQL. By default Umbraco

    Posted by: Tim on Friday, October 27 2017
    Read On

    Leave your mark