Sign in Subscribe

Topic

Script

A collection of 6 posts

An invalid parameter or option was specified for procedure 'sys.sp_change_users_login'.

Today, we encountered a new issue that we had not seen before. When trying to update a database's logins after restoring it from prod, the usual stored procedure we run (sys.sp_change_users_login) didn't seem to function as we would expect. EXEC sp_change_

Export all products, properties and categories from uCommerce

A while ago I posted about how to Export products from Ucommerce into a CSV type format. The database schema has changed slightly since so today I'm posting an updated version of the code for v9. I've also added a second script that outputs the categories

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 Ucommerce and accommodates Ucommerce's new database schema for prices. BEGIN TRAN

Export Umbraco members as CSV/table

A while ago I blogged about how to list umbraco document types as an Excel table which has come in handy a few times. Today I thought I’d blog about how to list Umbraco members in a CSV format with their properties as column headings. If you’ve ever

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