IBM Connections – Deleted Folders workaround

Deleted folders don’t go to the trash in Connections 5 and 5.5. Getting them back from the db backup can take some time. If you just need to know which files have been in a particular folder to recreate it, it’s a lot of work.

To make it a bit easier I’ve created this little sql command

connect to files@

export to folderInfo.csv of DEL Modified by NOCHARDEL select folders.title as foldername,media.title as filename, folders.external_container_id as community_uuid, hex(me
dia.id) as fileID ,hex(folders.id) as folderid from files.media as media right outer join (select folder.ID,folder.TITLE,folder.external_container_id,folder.Label, map.media_id from files.collection as folder inner join files.collection_to_media as map on folder.ID=map.collection_id) as folders on media.id=folders.media_id order by folders.title@

Now if someone accidentially deleted the folder instead of the file in the folder I just have to search the csv files instead of the doing a complete db restore.

Posted in Connections