umbraco Forum » umbraco Core » Bugs and issues » Cleaning up orphan files in media folder.

Cleaning up orphan files in media folder. Options
Previous Topic · Next Topic
dawoe
Posted: Wednesday, April 16, 2008 12:47:52 PM

Rank: Aficionado

Joined: 1/19/2008
Posts: 182
Location: Belgium
Hi,

I have several documenttypes that use a upload property.

When creating nodes of this documenttype the file is uploaded to a new folder in the media folder. When I remove the node the file and folder doesn't get deleted.

Does somebody have a script to see what files are being used by the document types that have a upload property ?

Converting a DotNetNuke site to Umbraco : Follow it here
Back to top
 
tim
Posted: Wednesday, April 16, 2008 1:26:35 PM

Rank: Addict

Joined: 2/19/2007
Posts: 825
Location: Belgium
Haven't seen something like that around, but shouldn't be that hard to make, just a couple of lines, I'll check it out later
Umbraco tips and tricks: http://www.nibble.be - umbraco mvp 08/09 - certified level 1 & 2 professional
Back to top
 
dawoe
Posted: Wednesday, April 16, 2008 1:42:02 PM

Rank: Aficionado

Joined: 1/19/2008
Posts: 182
Location: Belgium
tim wrote:
Haven't seen something like that around, but shouldn't be that hard to make, just a couple of lines, I'll check it out later


Yep found it myself already.

Here is the SQL to get all files still in db.
Code:

SELECT [versionId]
      ,[alias]
      ,[content]
  FROM [umbracoCMS].[dbo].[umbracoContentData]
WHERE [alias] = 'umbracofile' -- Files in media section
    OR [alias] = 'AnotherUploadPropHere'
    OR [alias] = 'AnotherUploadPropHere'


Gonna write a small tool to do this clean up.
Converting a DotNetNuke site to Umbraco : Follow it here
Back to top
 
timgaunt
Posted: Wednesday, September 03, 2008 6:16:43 PM

Rank: Aficionado

Joined: 10/31/2007
Posts: 114
Location: Birmingham (UK)
I've just written a little application to do this, check out: http://blogs.thesitedoctor.co.uk/tim/2008/09/03/Clean+Out+Unused+Media+Items+From+Umbraco+Media+Folder.aspx

HTH

Tim
Managing Director at The Site Doctor Ltd - My personal blog is here - Umbraco Newbie ;)
Back to top
 
Users browsing this topic
Guest

umbraco Forum » umbraco Core » Bugs and issues » Cleaning up orphan files in media folder.


You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.