Question #1309
完了
Would it be possible to create a query that replicates templates across projects.
100%
説明
Hello,
Cool plugin. I'm finding it really useful. Thank you for writing.
We have over 150 projects in redmine and I would like to create at least 10-15 templates for various trackers. I have read that global templates are on your roadmap.
Do you think that it is feasible to write a query to create in bulk the 1500 -> 2000 templates we need? If so what table(s) should I be looking at?
Thanks for the help and thanks again for the plugin.
Chris
Akiko Takano さんが約10年前に更新
- ステータス を 新規（New） から 担当（Assigned） に変更
- 担当者 を Akiko Takano にセット
- 対象バージョン を ver0.0.8 にセット
Hello, Christopher.
Thank you for your using my plugin! And I'm sorry I have not implemented global template yet.
Now I have 2 workaround.
1. Use inherited template feature.
From version 0.0.6, inherited template feature is supported.
- First, create dummy project as a top-level, parent project of others.
- Then enabled issue tracking and issue template module, and select all trackers other projects use.
- Create templates.
- Move projects as a child project that you want to use common templates and activate issue template module.
2. Write a query for bulk insert templates, as you described above.
We can bulk insert template data, but I don't recommend this because of maintenance and performance reasons…
Tables for issue template are:
- issue_templates
- issue_template_settings
Anyway, in your case, I think global template should be implement as soon as possible.
Christopher Caruk さんが約10年前に更新
Hello,
Thank you for responding. I also thought about option 1 but we already have sub-projects and I did not want to mess around with how these are displayed.
Regarding option 2. I can certainly see how maintenance would be a problem. Why are you concerned about performance?
It's good to hear that a more permanent solution is on the way. I may just enable a couple of the projects until you are able to put some time into Global Templates.
It may please you to hear that we are also getting allot of use out of the Wiki Extensions. So... Thanks again for the useful plugins.
Akiko Takano さんが約10年前に更新
- 進捗率 を 0 から 10 に変更
Hi, Christopher.
I'm sorry I have not implement above request yet.
But ver 0.0.8 was released yesterday, which supports global template feature.
Since this implementation is so rough that please give me some feedback.
Does this meet your request or not.
You can access my demo site and log in via admin account. Please try.
Of course, I'l make the sql query or rake task to replicate templates across projects, for older version users 
Akiko Takano さんがほぼ10年前に更新
- ステータス を 担当（Assigned） から 終了（Closed） に変更
- 進捗率 を 10 から 100 に変更
Closed.
Please reopen or create new issue if above did not meet your request.
Sincerely,