Project

General

Profile

気づき #699

Redmine以外でのデータ表示/操作例

Added by 奈良 裕記 almost 3 years ago. Updated 14 days ago.

Status:
進行中
Priority:
通常
Assignee:
-
Category:
-
Target version:
-
Start date:
08/15/2017
Due date:
% Done:

0%

Estimated time:

Description

■現象/要望

Redmine以外でのデータ表示/操作例
REST等を利用し、Redmine外でデータ表示/操作する方法もある。
事例蓄積用チケット

■解決策

注:動作検証は一部しか行っていません。
バージョン、DBに依存する場合もあります。

Redmine API(本家)

http://www.redmine.org/projects/redmine/wiki/Rest_api
紹介記事
https://www.farend.co.jp/blog/2017/02/redmine-api/

Redmine DB データモデル(Redmine1.0.1時点)
https://www.redmine.org/projects/redmine/wiki/DatabaseModel


プログラム言語

Ruby

JavaScript

  • RedmineのJavaScriptから各種データを取得する方法
    https://qiita.com/forenoonM/items/7f42701b2ea40353a820
    RedmineのJavaScriptからRedmineの内部データを取得する方法の中で、
    authenticity_tokenを使う方法と、REST APIを使う方法を紹介する。
    (注:view customize1.2にて、内部データを直接取得可能となった)

python

Perl

PHP

Java

Powershell

golang


Office関連

Excel、EXCEL+VBA

MS-Project

Outlook/VBA

Slack


開発ツール関連

GitBucket

Github

GitLab

Visual Studio Code

TFS

  • TFSのチェックインをトリガーにRedmineのAPIを叩く
    チケットから開発プロセスを追跡できるように、チェックインとチケットを紐づける操作を自動化。
    TFSのチェックインをトリガーにRedmineにメール送信、Redmine側では受信メールからチケット処理実行し反映。チェックイン時にRedmineのチケット番号入力要。
    https://speakerdeck.com/miokakusu/20190518di-16hui-redmine-dot-tokyomian-qiang-hui-shou-yu-xian

Jenkins


Angular

Express,Node.js

Node-Red

Electron

curl,shell

Zabbix

Vuls

GAS(google apps script)

R言語


BIツール関連(データ可視化)

ELK,Kibana

Re:dash

Metabase

RedmineのOpen/Closeチケット数の推移をMetabaseでグラフ表示する方法
https://qiita.com/moni-hide/items/1646f532838956433d5b

Metabase自体については下記参照
OSSのデータ可視化ツール「Metabase」が超使いやすい
https://qiita.com/acro5piano/items/0920550d297651b04387

Tableau

とあるメーカーのRedmine 活用事例 – RedmineとTableau
https://www.slideshare.net/crosspoints/redmineosaka-20-talkcrosspoints


その他

アプリ/その他

  • CSVを読み込んでRedmineのチケットを新規作成、更新するツール(redmine-issue-loader)
    http://blog.enjoyxstudy.com/entry/2019/01/06/000000
    https://github.com/onozaty/redmine-issue-loader/blob/master/README.ja.md
     
    下記特長があり、定型処理を自動実行する場合に有利
    ・コマンドラインで実行できる(他システムと連携し自動処理など)
    ・設定ファイルにマッピング情報を記載
    ・カスタムフィールドをキーとしてチケットを更新できる(勿論一意性必要)
     
    Java(JDK8以上)で動作
    Redmineのユーザ認証にはAPIアクセスキーまたはBasic認証を利用可能

■対応状況

■補足

#1

Updated by 奈良 裕記 almost 3 years ago

  • Description updated (diff)
#2

Updated by 奈良 裕記 almost 3 years ago

  • Description updated (diff)
#3

Updated by 奈良 裕記 almost 3 years ago

  • Description updated (diff)
#4

Updated by 奈良 裕記 almost 3 years ago

  • Description updated (diff)
#5

Updated by 奈良 裕記 almost 3 years ago

  • Description updated (diff)
#6

Updated by 奈良 裕記 almost 3 years ago

  • Description updated (diff)
#7

Updated by 奈良 裕記 almost 3 years ago

  • Description updated (diff)
#8

Updated by 奈良 裕記 about 2 years ago

  • Subject changed from Redmine以外でのデータ表示例 to Redmine以外でのデータ表示/操作例
  • Description updated (diff)
#9

Updated by 奈良 裕記 about 2 years ago

  • Description updated (diff)
#10

Updated by 奈良 裕記 about 2 years ago

  • Description updated (diff)
#11

Updated by 奈良 裕記 about 2 years ago

  • Description updated (diff)
#12

Updated by 奈良 裕記 about 2 years ago

  • Description updated (diff)
#13

Updated by 奈良 裕記 about 2 years ago

  • Description updated (diff)
#14

Updated by 奈良 裕記 about 2 years ago

  • Description updated (diff)
#15

Updated by 奈良 裕記 about 2 years ago

  • Description updated (diff)
#16

Updated by 奈良 裕記 about 2 years ago

  • Tracker changed from QA to 気づき
#17

Updated by 奈良 裕記 about 2 years ago

  • Description updated (diff)
#18

Updated by 奈良 裕記 about 2 years ago

  • Description updated (diff)
#19

Updated by 奈良 裕記 almost 2 years ago

  • Description updated (diff)
#20

Updated by 奈良 裕記 almost 2 years ago

  • Description updated (diff)
#21

Updated by 奈良 裕記 almost 2 years ago

  • Description updated (diff)
#22

Updated by 奈良 裕記 over 1 year ago

  • Description updated (diff)
#23

Updated by 奈良 裕記 over 1 year ago

  • Description updated (diff)
#24

Updated by 奈良 裕記 over 1 year ago

  • Description updated (diff)
#25

Updated by 奈良 裕記 over 1 year ago

  • Description updated (diff)
#26

Updated by 奈良 裕記 over 1 year ago

  • Description updated (diff)
  • Status changed from 新規 to 進行中
#27

Updated by 奈良 裕記 over 1 year ago

  • Description updated (diff)
#28

Updated by 奈良 裕記 over 1 year ago

  • Description updated (diff)
#29

Updated by 奈良 裕記 over 1 year ago

  • Description updated (diff)
#30

Updated by 奈良 裕記 over 1 year ago

  • Description updated (diff)
#31

Updated by 奈良 裕記 over 1 year ago

  • Description updated (diff)
#32

Updated by 奈良 裕記 over 1 year ago

  • Description updated (diff)
#33

Updated by 奈良 裕記 over 1 year ago

  • Description updated (diff)
#34

Updated by 奈良 裕記 over 1 year ago

  • Description updated (diff)
#35

Updated by 奈良 裕記 over 1 year ago

  • Description updated (diff)
#36

Updated by 奈良 裕記 about 1 year ago

  • Description updated (diff)
#37

Updated by 奈良 裕記 about 1 year ago

  • Description updated (diff)
#38

Updated by 奈良 裕記 11 months ago

  • Description updated (diff)
#39

Updated by 奈良 裕記 10 months ago

  • Description updated (diff)
#40

Updated by 奈良 裕記 9 months ago

  • Description updated (diff)
#41

Updated by 奈良 裕記 9 months ago

  • Description updated (diff)
#42

Updated by 奈良 裕記 9 months ago

  • Description updated (diff)
#43

Updated by 奈良 裕記 9 months ago

  • Description updated (diff)
#44

Updated by 奈良 裕記 9 months ago

  • Description updated (diff)
#45

Updated by 奈良 裕記 9 months ago

  • Description updated (diff)
#46

Updated by 奈良 裕記 9 months ago

  • Description updated (diff)
#47

Updated by 奈良 裕記 5 months ago

  • Description updated (diff)

各言語対応のライブラリ/使用例と、ツール機能自体の側面を分けた方が良いかも。。

#48

Updated by 奈良 裕記 5 months ago

  • Description updated (diff)
#49

Updated by 奈良 裕記 5 months ago

  • Description updated (diff)
#50

Updated by 奈良 裕記 3 months ago

  • Description updated (diff)
#51

Updated by 奈良 裕記 about 1 month ago

  • Description updated (diff)
#52

Updated by 奈良 裕記 about 1 month ago

  • Description updated (diff)
#53

Updated by 奈良 裕記 about 1 month ago

  • Description updated (diff)
#54

Updated by 奈良 裕記 about 1 month ago

  • Description updated (diff)
#55

Updated by 奈良 裕記 about 1 month ago

  • Description updated (diff)
#56

Updated by 奈良 裕記 29 days ago

  • Description updated (diff)
#57

Updated by 奈良 裕記 14 days ago

  • Description updated (diff)

Also available in: Atom PDF