Project

General

Profile

task #6020

Consider replacing custom field 'keywords' by redmine_tags

Added by Andreas Kohlbecker about 3 years ago. Updated about 3 years ago.

Status:
Closed
Priority:
Highest
Category:
devOps
Target version:
-
Start date:
07/26/2016
Due date:
% Done:

0%

Severity:
normal
Tags:

Description

custom issue fields cannot be edited via the bulk edit function.
Maybe the redmine_tags plugin provides better functionality

HowTo migrate the keywords to tags

To get an overview on the keywords

select c.value, count( c.value) as cnt from custom_values c where c.custom_field_id=8   group by c.value order by cnt DESC

==> some keywords are not split into single tokens, they are still concatenated by ',' characters. TODO split the keywords into tokens.

The plugin brings two new tables:

  • tags - the tag text and count of the tags in use
  • taggings - relations between the tag and the issue, wiki, etc

I should be quite easy to write an sql statement or procedure to perform a migration

split-kdata.awk (1.46 KB) Andreas Kohlbecker, 09/20/2016 06:35 PM

migrate-keywords-to-tags.sh View (642 Bytes) Andreas Kohlbecker, 09/20/2016 06:35 PM

History

#1 Updated by Andreas Kohlbecker about 3 years ago

  • Description updated (diff)

#2 Updated by Andreas Kohlbecker about 3 years ago

  • Priority changed from New to Highest

#3 Updated by Andreas Kohlbecker about 3 years ago

During installation, more specifically at bundle install the following information is printed out.
This might be important when upgrading redmine later on:

Installing acts-as-taggable-on 3.5.0
...
Bundle complete! 32 Gemfile dependencies, 57 gems now installed.
Gems in the groups development and test were not installed.
Use `bundle show [gemname]` to see where a bundled gem is installed.
Post-install message from acts-as-taggable-on:
When upgrading

Re-run the migrations generator

    rake acts_as_taggable_on_engine:install:migrations

#4 Updated by Andreas Kohlbecker about 3 years ago

  • Description updated (diff)

#5 Updated by Andreas Kohlbecker about 3 years ago

  • Description updated (diff)

#6 Updated by Andreas Kohlbecker about 3 years ago

  • File migrate-keywords-to-tags.sh added
  • File split-kdata.awk added

migration scripts are ready, see attachments

#7 Updated by Andreas Kohlbecker about 3 years ago

  • File split-kdata.awk added
  • File migrate-keywords-to-tags.sh added
  1. NOTE: This plugin seems not to support 'Bulk edit' :(
  2. Updating the migration scripts

#8 Updated by Andreas Kohlbecker about 3 years ago

  • File deleted (migrate-keywords-to-tags.sh)

#9 Updated by Andreas Kohlbecker about 3 years ago

  • File deleted (split-kdata.awk)

#10 Updated by Andreas Kohlbecker about 3 years ago

Da scheint es leider noch Probleme zu geben.

2 Beispiele: http://130.133.70.38/redmine/issues/1420 sollte Tags FaunaEuropaea und Cuba haben hat aber nur FaunaEuropaea , Keywords stimmen noch

http://130.133.70.38/redmine/issues/2218 sollte platform_specific und review2014-07-12 haben hat aber nur platform_specific

Viele Grüße,
Andreas M.

#11 Updated by Andreas Kohlbecker about 3 years ago

This is fixed now.

#12 Updated by Andreas Kohlbecker about 3 years ago

  • File deleted (split-kdata.awk)

#13 Updated by Andreas Kohlbecker about 3 years ago

  • File deleted (migrate-keywords-to-tags.sh)

#14 Updated by Andreas Kohlbecker about 3 years ago

  • Status changed from New to Feedback
  • Assignee set to Andreas Müller

could you do the xcheck once again?

#15 Updated by Andreas Kohlbecker about 3 years ago

  • Category set to devOps

#16 Updated by Andreas Müller about 3 years ago

  • Assignee changed from Andreas Müller to Andreas Kohlbecker

#17 Updated by Andreas Kohlbecker about 3 years ago

  • Status changed from Feedback to Closed

The tags plugin is now enabled and the keywords have been migrated to tags.

I will also disable the keywords custom field.

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)