Managing Attachment Tags

Cole Welsh

Happy Friday Eve everyone, I have a situation that I'm looking for advice on.

I've inherited a database that required some serious cleaning, and after much of it I've stumbled upon the issue of the attachment tags. These were put in seemingly without thought to how they'd be used, and there's many that I just don't want people to be able to select when uploading documentation. Is there any way to query these out and change them?

JoAnn Strommen

@Cole Welsh The list is in the table ‘Media Types.'
In web view, look at Control Panel > Tables > Media types. There you can combine types using clean up, open a type an mark as inactive, or if removed from all uses delete it.

Rachel Kauer

@Cole Welsh

Hi Cole,

We had a similar issue. If you are looking to query them out first before changing them I would use:

1. Constituent Query
2. Criteria: Media>Media Type
   1. Operator = Equals
   2. Value = (name of media type you want to review)
3. Output:
   1. Media Type, Media Title, Media Description, Media Date, Media Author.

Matthew Nareff

@Cole Welsh These responses are actually about the Media Type in database view when you upload attachments there. Are you talking specifically abut the tags that are associated with attachments when you upload them in web view? As far as I know we're not able to edit tags at this point. It would be nice if they were added to the Tables now that it's in web view since we also have a lot of typos and duplicates that need to be cleaned up. I'm also not sure if you can lock these down so no one else can add to them like you can with tables so that people can't randomly add new ones.

JoAnn Strommen

@Matthew Nareff These are a table - the table is called Media Type. It's used in db and in web view they are called ‘tags’. Table entries can be found, edited, cleaned up, marked inactive from Control Panel > Tables > Media Types.

I don't think the option to lock down/limit entries is possible any longer. Will be another things that hopefully will be added in the future.

Cole Welsh

@JoAnn Strommen This table does not reflect the tags for Web View - according to mine, there's “No Rows to Show” despite the fact that there's definitely tags being used in the database.

JoAnn Strommen

@Cole Welsh Could be definition of ‘tags.’ Are we talking about the same thing? Maybe screenshot would help.

This is what I see in web view. When I went to the Media Type table and selected Photo > View Uses. I did have to go Media in the left panel to see the results I was looking for. Do you have options to select from? I almost missed that but I assume option is only there when tags are present.

This what shows in db view for the same file:

Alex Wong

@JoAnn Strommen
Cannot manage right now.

Maybe your attachment just happens to have same value