How to export a plugin table and additional criteria in only one Excel document?

Question

Hello,

I am looking for a soulution to add a table with drop down options and calculations of totals to Jira. In a later process this table should be possible to be exported with further criteria that was tracked within the process.

I found a Plugin (Table Grid Editor) which is supporting my requirenments for tracking within the tool. Apparently, it wont allow me to export the data within Excel. I suppose the export is not possible due to the usage of different databases.

Is there any way I can track measures within a table (allowing drop down and calculations) and export the data from the table as well as further criteria which is tracked within the proccess in only one Excel document?

Thanks in advance for your response :)

Regards,

Dominique

francis · Answer

Hi Dominique,

(I'm from iDalko - the company behind the table grid editor)

One of the approaches to meet the excel requirement is by providing your users a odbc connection (using a read only user) directly to the database.  Views can simplify the life of the users.

Another approach is by using the pivot table gadget which has an excel export capability.

Hope this helps

Francis

Dominique Nickel · Answer

Hey Aron,

thanks for your answer. Excel exports are definetely a requirenment. I suppose the export problem is caused by the usage of two different databases.

Is there maybe a way/Plugin - other than Table Grid - to integrate tables with calculations and drop down options within Jira?

Thanks in advance,

Dominique

Aron Gombas [Midori] · Answer

Hey,

If Excel is not a hard requirement, the PDF View Plugin can export Table Grid fields to PDF, see these samples.

If Excel is a hard requirement, then the Better Excel Plugin is a great tool, but at the moment it does not support Table Grid out of the box. You can still try to write the Groovy script to integrate those, or find some other mechanism to manage the data that is already supported by Better Excel.