Project

General

Profile

Actions

task #6020

closed

Consider replacing custom field 'keywords' by redmine_tags

Added by Andreas Kohlbecker over 6 years ago. Updated over 6 years ago.

Status:
Closed
Priority:
Highest
Category:
devOps
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
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


Files

split-kdata.awk (1.46 KB) split-kdata.awk Andreas Kohlbecker, 09/20/2016 06:35 PM
migrate-keywords-to-tags.sh (642 Bytes) migrate-keywords-to-tags.sh Andreas Kohlbecker, 09/20/2016 06:35 PM
Actions #1

Updated by Andreas Kohlbecker over 6 years ago

  • Description updated (diff)
Actions #2

Updated by Andreas Kohlbecker over 6 years ago

  • Priority changed from New to Highest
Actions #3

Updated by Andreas Kohlbecker over 6 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
Actions #4

Updated by Andreas Kohlbecker over 6 years ago

  • Description updated (diff)
Actions #5

Updated by Andreas Kohlbecker over 6 years ago

  • Description updated (diff)
Actions #6

Updated by Andreas Kohlbecker over 6 years ago

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

migration scripts are ready, see attachments

Actions #7

Updated by Andreas Kohlbecker over 6 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
Actions #8

Updated by Andreas Kohlbecker over 6 years ago

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

Updated by Andreas Kohlbecker over 6 years ago

  • File deleted (split-kdata.awk)
Actions #10

Updated by Andreas Kohlbecker over 6 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.

Actions #12

Updated by Andreas Kohlbecker over 6 years ago

  • File deleted (split-kdata.awk)
Actions #13

Updated by Andreas Kohlbecker over 6 years ago

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

Updated by Andreas Kohlbecker over 6 years ago

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

could you do the xcheck once again?

Actions #15

Updated by Andreas Kohlbecker over 6 years ago

  • Category set to devOps
Actions #16

Updated by Andreas Müller over 6 years ago

  • Assignee changed from Andreas Müller to Andreas Kohlbecker
Actions #17

Updated by Andreas Kohlbecker over 6 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.

Actions

Also available in: Atom PDF