Hi,
Maybe the answer to this is staring me in the face, but I can't work it out…
Is there a quick way to clear most of the entries from the remap manager?
We only have 3 remaps that we want to keep, but there are currently 6 pages of remaps in our remap manager (it's normally cleaned out regularly enough so that it doesn't get beyond 1 page, but a bunch of old files were archived and moved last week so it has become a bit bloated).
Our process in this situation used to be that we'd just delete all of them and then upload a CSV file containing the 3 permanent remaps.
Now that process doesn't work because all of the remaps have 'Never delete' ticked by default. Plus the CSV doesn't override what is there - it just adds to the list.
Above the Delete column there's a tick box so you can select or de-select all of the assets on a page for deletion, but the Never Delete column doesn't have the same thing.
So as far as I can tell the only way to get rid of them is to untick the 'Never Delete' box next to each and every one, except for the 3 we want to keep.
There must be a better way… If you know, please enlighten me.
Oh, by the way, the 'Automatically add remaps when webath changed' on the remap manager screen is not ticked, and the 'Automatically add remaps' box was not ticked when assets were being moved and folders renamed last week, so I'm not 100% sure why so many ended up in the remap manager…
We're on version 3.24.4.
Thanks!
Margaret
Quick way to clear remap manager?
[quote]
Hi,
Maybe the answer to this is staring me in the face, but I can't work it out…
Is there a quick way to clear most of the entries from the remap manager?
We only have 3 remaps that we want to keep, but there are currently 6 pages of remaps in our remap manager (it's normally cleaned out regularly enough so that it doesn't get beyond 1 page, but a bunch of old files were archived and moved last week so it has become a bit bloated).
Our process in this situation used to be that we'd just delete all of them and then upload a CSV file containing the 3 permanent remaps.
Now that process doesn't work because all of the remaps have 'Never delete' ticked by default. Plus the CSV doesn't override what is there - it just adds to the list.
Above the Delete column there's a tick box so you can select or de-select all of the assets on a page for deletion, but the Never Delete column doesn't have the same thing.
So as far as I can tell the only way to get rid of them is to untick the 'Never Delete' box next to each and every one, except for the 3 we want to keep.
There must be a better way… If you know, please enlighten me.
Oh, by the way, the 'Automatically add remaps when webath changed' on the remap manager screen is not ticked, and the 'Automatically add remaps' box was not ticked when assets were being moved and folders renamed last week, so I'm not 100% sure why so many ended up in the remap manager…
We're on version 3.24.4.
Thanks!
Margaret
[/quote]
Hi Margaret,
Unfortunately there is no script that can take care of what is needed. and yes de-selecting each the check box is indeed a tedious job. Easiest way to get rid of "ALL" of them would be from the DB directly under sq_ast_lookup_remap table.
Alternately you could update all the remaps in the table with "never delete" option to '0' and then you would be able to check all the remaps from the backend but the 3 you want and delete rest.
Cheers
[quote]
Hi Margaret,
Unfortunately there is no script that can take care of what is needed. and yes de-selecting each the check box is indeed a tedious job. Easiest way to get rid of "ALL" of them would be from the DB directly under sq_ast_lookup_remap table.
Alternately you could update all the remaps in the table with "never delete" option to '0' and then you would be able to check all the remaps from the backend but the 3 you want and delete rest.
Cheers
[/quote]
Hi Ashish,
Thanks for confirming. Unfortunately, even if there was a script, I wouldn't be able to run it as we're under an SLA with Squiz - I'd have to do it as a support request.
The second option is unfortunately not possible either. The new remaps are not in my CSV and as far as I can see the remaps can't be exported, so it looks like the only way is to sit and untick…
I might put in a feature request to add a 'select/de-select all' box at the top of the Never Delete column.
Thanks.
Cheers,
Margaret
Yes, just run into this myself now that we've upgraded to 3.26.4. It is pretty annoying that the default is never delete since usually I do want to delete.
[quote]
Hi Ashish,
Thanks for confirming. Unfortunately, even if there was a script, I wouldn't be able to run it as we're under an SLA with Squiz - I'd have to do it as a support request.
The second option is unfortunately not possible either. The new remaps are not in my CSV and as far as I can see the remaps can't be exported, so it looks like the only way is to sit and untick…
I might put in a feature request to add a 'select/de-select all' box at the top of the Never Delete column.
Thanks.
Cheers,
Margaret
[/quote]
Hi,
You are welcome.
I was wondering why could not truncate the whole table and just manually add the three remaps that are required ?
Also if not deleting all the remap from DB directly, i reckon it would be a LOT easier to update all the entries in DB so that "never_delete" is set to '0' hence un-ticked. This would reduce the work needed to be done to manually delete the unwanted Remaps.
Cheers,
Ash
[quote]
I was wondering why could not truncate the whole table and just manually add the three remaps that are required ?
[/quote]
Sorry, I'm not sure I follow… I would happily delete the whole lot and then manually add the three remaps, but there's no way to do that from the Admin interface. I don't have direct access to the database because of our SLA.
[quote]
Also if not deleting all the remap from DB directly, i reckon it would be a LOT easier to update all the entries in DB so that "never_delete" is set to '0' hence un-ticked. This would reduce the work needed to be done to manually delete the unwanted Remaps.
[/quote]
It would be great if the default for Never Delete in the Admin interface was unticked - as long individual remaps stay ticked once you have marked them Never Delete.
[quote]
Yes, just run into this myself now that we've upgraded to 3.26.4. It is pretty annoying that the default is never delete since usually I do want to delete.
[/quote]
Yes, I thought the Never Delete option would be fantastic when I first heard about it, but in practice it has turned out to be more of a hindrance than a help. The system shouldn't assume that every single remap is a 'never delete' one…
Yes, and I have 45 pages worth of remaps now. 
Anyway, I can't 'truncate the table' because I don't know what a table is or how to truncate one. ;p
You can use Firebug to easily add a new checkbox which lets you remove all the "Never Delete" checks at the same time.
In firebug, find the place in the DOM where the "Never Delete" text is located, then add:
If your remap manager has a different asset ID than 19, you will have to replace the 19 in the code with your asset id.
After doing that, you should be able to see a new checkbox, which when clicked will let you remove all the checks from the Never Delete column.
Here is a quick screen cast so there is no confusion: [b]http://web2.puc.edu/PUC/files/ScreenSnapz.mov[/b]
[quote]
You can use Firebug to easily add a new checkbox which lets you remove all the "Never Delete" checks at the same time.
In firebug, find the place in the DOM where the "Never Delete" text is located, then add:
If your remap manager has a different asset ID than 19, you will have to replace the 19 in the code with your asset id.
After doing that, you should be able to see a new checkbox, which when clicked will let you remove all the checks from the Never Delete column.
Here is a quick screen cast so there is no confusion: [b]http://web2.puc.edu/PUC/files/ScreenSnapz.mov[/b]
[/quote]
Oh thanks Nic, you rock! Works like a dream! :)
[quote]
Oh thanks Nic, you rock! Works like a dream! 
[/quote]
Glad to help!
Nic, that's brilliant! Is there any way to make the addition (semi-)permanent? We have many, many pages of remaps to remove.
[quote]
Nic, that's brilliant! Is there any way to make the addition (semi-)permanent? We have many, many pages of remaps to remove.
[/quote]
Not without going in and editing the code for that screen. Which, is not too hard…
Ok everyone, I thought I would write a bookmarklet that would create the button for you.
I added it to the Tips and Tricks section: http://forums.matrix.squiz.net/index.php?showtopic=7434
Let me know what you think.