Customer List in Confluence

Question

Hello everybody,

is it possible to add a Table into Confluence (8000 rows/4 columns) where we can list all of our customers?

I know, that Confluence is not made to display tables which are that big, but it would be the easiest way to share customer information in our company.

Greets

Alex

Andrey Khaneev _StiltSoft_ · Answer

Hello Alexander,

Please, try the latest 2.2.8 version of Table Filter, It works with SQL macro and many other macros.

Alexander Schät_rlfs0x · Answer

Hey Steve,

thank you for your answer.

I'm getting this out of our ERP System. I am already testing the SQL Macro in combination wih the tablefilter Add-on. The problem is, that the content, which is generated by the sql macro, is dynamic, so the table filter add on does not have any chance to use the filter:

image2015-3-25 16:13:48.png

(Table Filter Add-On plus Bobswift SQL)

But as soon as I'm choosing one of the filters the whole table dissappears:

image2015-3-25 16:15:7.png

You see my problem

I already thought about using this add-on:

https://marketplace.atlassian.com/plugins/org.swift.confluence.run

The aim is, that the user can simply e.g. filter for a name and he gets all the global customer entries.

You know what I mean?

Sonst erklär ich es in deutsch

Greets

Alex

image2015-3-25 16:13:48.png

image2015-3-25 16:15:7.png

Steve Gerstner [bridgingIT] · Answer

Hello Alex,

if you intend to manage it manually and besides a really bad performance in your browser, no, that schould not be a problem.

But the table would need some kind of filtering and to speed up the performance a pagination would be helpful.

Which brings me to the next question. From where do you get your data? From a CRM? A database? A webservice?

I think, the following plugins might be useful:

https://marketplace.atlassian.com/plugins/com.stiltsoft.confluence.plugin.tablefilter.tablefilter

If you are using a database for data retrival:

https://marketplace.atlassian.com/plugins/com.playsql.playsql-plugin

https://marketplace.atlassian.com/plugins/org.swift.confluence.sql

But, for a good user experience, you'll need a custom writen plugin.

Regards

Steve