Pivot Table for Confluence

Inspiration

I published my first free open-source add-on in August just before the beginning of Codegeist Hackaton. As I wanted to participate, I developed another free add-on

What it does

Confluence proposes a great tool to create beautiful tables, but nothing to aggregate data into a Pivot Table. Pivot Table macro can be nested within Chart Macro to display graphs. And also Jira Issue Macro can be nested within my Pivot Table macro to present useful pivot tables.

How I built it

Using the Atlassian Plugin SDK, Java language, Jsoup library to parse HTML table and a velocity template to render the Pivot Table

Challenges I ran into

Publish this add-on on time and quality to participate to Codegeist Hackaton

Accomplishments that I'm proud of

I developed Integration Tests using PageObjects and I published a tutorial for Confluence. I would like to contribute to the official Atlassian documentation, so I've signed up for the Atlassian Contributor License Agreement. But I'm waiting for approval for a month

What I learned

Automatic Integration Tests using Selenium and PageObjects

What's next for Pivot Table for Confluence

Cloud version is under development. I'm in contact with the Atlassian Connect Javascript Team CE-232, ACJS-71 and I've posted some questions on Atlassian Answers. I initially planned to publish a fist version of this cloud version but I encountered too many issues and some of them aren't yet solved

Built With

• java
• sdk
• velocity