How to hide or remove the System Default Skins

[Arjan]

Hi all,

 

During our use of Swyx we've accumulated quite a lot of skins because of testing, misnaming and optimization. Today, I decided to go clean up the mess my predecessors left behind, and the amount of skins users get to choose from is now significantly lower.

However, there are still all the system default skins, and I would like to either hide of remove those. I read that it could perhaps be done after changing a setting in a config file, but which one is that? 

If there is another way to do so, please let me know. 

 

Arjan

[Floeti]

Default skins are saved in the system default scope of the database, there's no way to delete those and afaik no way to hide them.

 

Regards,

David

[Arjan]

Hi David,

 

Thanks. I consider that's a challenge

[Arjan]

And here's how you do it:

 

In SQL management studio, browse to the database choose 'new query'

add this rule and execute:

 SELECT * FROM Files WHERE Category='skins'

the output gives you all the skins available. You can export the data to  csv.

copy the names of all the skins you want gone

 

paste them in any text editor and add ' in front and behind the names.

Paste this: DELETE FROM dbo.files WHERE Name= in front of every rule, so that you end up with a list of rules like this:

 

DELETE FROM dbo.files WHERE Name='SwyxIt! 11 [3x UHD WebXT].cab'
DELETE FROM dbo.files WHERE Name='SwyxIt! 2013 [10x] Call Log.cab'
DELETE FROM dbo.files WHERE Name='SwyxIt! 11 [3x UHD].cab'
DELETE FROM dbo.files WHERE Name='SwyxIt!_2011R2_Index_Skin.cab'
DELETE FROM dbo.files WHERE Name='SwyxIt! 2013 [8x Visual Contacts].cab'
DELETE FROM dbo.files WHERE Name='SwyxIt! 2013 [4x WebXT].cab'

 

Copy paste these in a new query and execute.

 

That cleans up a lot of mess...

 

[Floeti]

You'll have to delete the skins every time you update your swyx installation, because the system default files are overwritten with each update and the swyx customer support propably doesn't like this...

But nevertheless thanks for the feedback on how to achieve this.

[Arjan]

Thank you too, David. It was your first reply that set me on the right track.

With a few commands, it's no more than a few minutes work to clean up the list if needed again, so I guess I can live with this 😉 

My users are happy with the way it looks now, which is what I was doing it for in the first place.