Suggestions related to tagging (download, "improved" upload)

feature
1

Hello

I’ve been paying around with tags for two weeks now and I would like to make some suggestions. I’m not sure if I must split them or not.

  1. There is an option to upload tags / tag groups from CSV. Can it be expanded with the other relevant fields for tag groups “parent tag”, “limit to one tag” and "visibility? I have no experience with the “visibility” but I did miss the first two options at occasion.
  2. A download option. When modify the tags on the website, there is a risk that there will be a mismatch between the web site and the CSV files that were uploaded. The download option woul;d allow me to have the tags in sync.

Note that (to my knowledge) I do not have access to the backend, else I could probably run a query.

Thanks for reading

2

not sure if this helps, but if you have access to admin you can use the data explorer plug-in to run some SQL queries.

1 Like
3

Thanks @Lilly

I can probably use that to download the existing tags; will look at it. The DB behind this is postgress if not mistaken? So it might require a bit of study with rusty knowledge of MySQL and MSSQL :wink:

Based on the name I have some doubts that it can be used to upload tags :slight_smile:

4

Thanks

One part solved; it would still be nice to have it as a functionality.

For those that need a query to extract tags with tag groups in the format that is also used for the upload of tags / tag groups, the below query will do that

SELECT t.name as tag, tg.name as "tag group"
from tag_groups as tg
left join tag_group_memberships as tgm on tg.id = tgm.tag_group_id
left join tags as t on tgm.tag_id = t.id
where tg.name = 'boards-and-microcontrollers'
order by tg.name asc, t.name asc

Next you can save to csv (or json) after running the query.

1 Like