# הצעות הקשורות לתיוג (הורדה, העלאה "משופרת")

**URL:** https://meta.discourse.org/t/suggestions-related-to-tagging-download-improved-upload/264259
**Category:** Feature
**Tags:** tags
**Created:** [8 במאי,‏ 2023,‏ 1:29pm UTC](https://meta.discourse.org/t/suggestions-related-to-tagging-download-improved-upload/264259 "2023-05-08T13:29:11Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![sterretje](https://avatars.discourse-cdn.com/v4/letter/s/cdc98d/32.png) [@sterretje](https://meta.discourse.org/u/sterretje)
#### Post date: [8 במאי,‏ 2023,‏ 1:29pm UTC](https://meta.discourse.org/t/suggestions-related-to-tagging-download-improved-upload/264259/1 "2023-05-08T13:29:12Z")

</div>

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

---

<div class="post-metadata">

### Author: ![Lilly](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/lilly/32/575047_2.png) [@Lilly](https://meta.discourse.org/u/Lilly)
#### Post date: [8 במאי,‏ 2023,‏ 3:21pm UTC](https://meta.discourse.org/t/suggestions-related-to-tagging-download-improved-upload/264259/2 "2023-05-08T15:21:57Z")

</div>

not sure if this helps, but if you have access to admin you can use the [data explorer](https://meta.discourse.org/t/32566?silent=true) plug-in to run some SQL queries.

---

<div class="post-metadata">

### Author: ![sterretje](https://avatars.discourse-cdn.com/v4/letter/s/cdc98d/32.png) [@sterretje](https://meta.discourse.org/u/sterretje)
#### Post date: [8 במאי,‏ 2023,‏ 3:48pm UTC](https://meta.discourse.org/t/suggestions-related-to-tagging-download-improved-upload/264259/3 "2023-05-08T15:48:48Z")

</div>

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 😉

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

---

<div class="post-metadata">

### Author: ![sterretje](https://avatars.discourse-cdn.com/v4/letter/s/cdc98d/32.png) [@sterretje](https://meta.discourse.org/u/sterretje)
#### Post date: [11 במאי,‏ 2023,‏ 11:32am UTC](https://meta.discourse.org/t/suggestions-related-to-tagging-download-improved-upload/264259/4 "2023-05-11T11:32:04Z")

</div>

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

```plaintext
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.