|
History
| Log In
|
|
|
|
[
Permlink
| « Hide
]
Jeff Turner [Atlassian] - 06/Nov/05 06:04 PM
Attached is a replacement JIRA 3.2.3's navigator-excel.jsp file which implements comments for the 'Default view' Excel view. It will only work in JIRA 3.2.3. In later versions this approach will not work (navigator-excel.jsp has vanished), and it would be necessary to write a custom field exposing the comments as a field. There is a tutorial on using the Custom Field Plugin available at http://confluence.atlassian.com/display/JIRA/How+to+create+a+new+Custom+Field+Type
 . We are using Jira 3.1.1
When you say write a cutom field to trap the comment. The custome field will only appear on the form allocated to an issue type initially. Can the custom field be used to trap comments made by users on a Jira once it has been created ? If we were to write a filter to pick up JRA-8426 and press the EXCEL button to write it to excel could we see this comment. Currently we are using Jira to track issues and when we report out to management we really need the last comment/all comments a user/users have made. At the moment we have to manually look up every Jira to see what the update is. All help appreciated regards Colm Carmody Ireland 00353 61714591 > Can the custom field be used to trap comments made by users on a Jira once it has been created ?
The custom field would look up the last comment at runtime, when JIRA asks it to render itself. It would therefore always appear to contain the last comment value. > If we were to write a filter to pick up JRA-8426 and press the EXCEL button to write it to excel could we see this comment. I'm not sure what you mean here? What is 'this comment'? I do not have any programming background.
What should be done with the attached file ? Does this have to be run Rgs Hi,
Thanks for the feedback. Lets say we write a filter to pick up JRA-8426. Press the EXCEL button If we can use a custom field to view the last comment what are the I have created many custom fields before via the admin sign on. In order to see the last comment as per your solution Jeff using custom Rgs Colm,
To use the navigator-excel.jsp attached to this issue online, you'd download it and copy it over the existing file (./atlassian-jira/secure/views/navigator/navigator-excel.jsp in JIRA Standalone). > Would I then be able to see the comment I have just added to Jira-8426 in the new custom field? No, currently no comments are shown in the Excel view. With the patch you'd be able to see all of them. > If we can use a custom field to view the last comment what are the required steps I need to take? If you don't have any programming background then you wouldn't be able to. It requires some programming and general Java experience. We have some partners who can do custom programming tasks if you're interested. If so let us know and we'll put you in touch with someone. Cheers, Hi,
When I log issues within a project I get the name "ITR-01" If I create another project how can I change this to be "INF-01" for the Regards Colm,
Can you mail jira-support@atlassian.com with more details on what you mean? This doesn't sound like it has anything to do with this issue (about Excel). Cheers, We are using JIRA 3.5.2. In the scenario with a current project, one of our software vendors also uses JIRA and we export cases out in CSV and they import it in and vice versa once the cases are resolved. But this model does not allow us to export all comments, neither does it allow us to import comments. Is there an efficient manner in which we can accomplish this in our current version? If we started using a custom field, that would limit us to having only one comment section.
TIA Gourav,
No, JIRA simply doesn't support arbitrary migration of issues between JIRA instances. About the best you could do is export a set of JIRA issues as XML (which includes comments), and then write an XSLT to transform this into a Jelly Is there a way to get comments in the current Excel export for JIRA 3.6 ?
Can a similiar modification be made to the navigator-excel-current.jsp using the actionManager.getComments()? I do not have any background knowledge in using XSLT to create a template for Excel. > Is there a way to get comments in the current Excel export for JIRA 3.6 ?
No (this issue is still open). > Can a similiar modification be made to the navigator-excel-current.jsp using the actionManager.getComments()? Possibly, though, the most logical approach would be to expose comments as a field type. I agree, this would be a nice feature to have. I just ran into an issue today where one of my users wanted to export their issues for a particular project into Excel format with the comments.
Cheers, E. Russell What is the time frame for this issue? It appears there is no status against this in a almost a year. Reporting on the "comments" field seems to be basic funcationality. Especially since it is a main input value when entering the issue.
Julianah,
As the "open" status suggests, there is no solution in JIRA yet. If you need to do this, I suggest using a tool that queries the database directly (eg. dbvisualizer). If you look at the content of the "Excel" view, it's really just HTML served with a .xls extension and a particular MIME type that causes Excel to read it (application/vnd.ms-excel).
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
 |
|
New Feature
Open
Major
View comments as a field (eg. in Excel view)
