Is there a plugin or another workaround for getting information from multiple pages and multiple rows.
What I want to have is almost lage page Properties but with multiple rows.
I have one page for each server
On that page I want to have a different tables. One of the tables is a matrix of services and what wanted status is. Like Running, Stopped, etc. and some other colums on that should happen if the status change and so on.
Then I want to have one page that have a big table of all the servers and service information from all the pages. So that the guy who is responsible to set up surveilance of the server can check one page that have information about all the services on every server.
Please send question if something was unclear...
Off-the-shelf, that sounds like the excerpt-include macro could do the job - you'd have a snippet or block of information about each server selected on source pages, and the target page would have set of excerpt-include macros on it that would pull the current data out of the source pages whenever it is viewed.
However, the macro does some formatting unfortunately, so you can't merge all of it into a table easily. If you wanted to do it in a less structured format (a simple list), you'd be ok, but it doesn't really lend itself to standard tables.
I think you'd need to find or write a new version of the macro that can do the same job but format stuff in a table. I've not tried this, but you might also be able to do something with user macros and custom html to turn it into a table.
Yes, per source page. You can put as many includes as your server can cope with on the target page.
A lot of us install the multi-excerpt add-on when we have multiple things to extract from single pages, but that still doesn't really do the tabulation thing either.
The Page Properties Report will take columns from ALL of the Page Properties macros on a page, as long as you don't specify a Page Properties ID in the Page Properties or Page Properties Report macro.
In the case of your example
How to do this:
The Page Properties Report will now show column A, B, Y and Z from each of the 5 server page.
Does that solve your problem? If not, please reply and I'll rework the example.
I'm not sure if I understand
The thing is that on each page (server) there is
One table With services:
Service | Name | Status | On Error
AOS60$01 | Microsoft Dynamics AX Object Server 6.3$01-MicrosoftDynamicsAX | Running | Restart
MSSQL$SQLEXPRESS | SQL Server (SQLEXPRESS) | Running | Restart
The formatting here is a bit wrong but as you can see the table has multiple rows.
I think see what you mean:
You want a page that will take the tables of information from each server page and combine it into 1 table, so that an engineer can see immediately the information for each service, on each server, all on the same page.
Is that correct?
If it is correct, do each of the pages have the same columns, e.g. Service | Name | Status | On Error ?
This can be done using Page Properties and Page Properties Reports. Unfortunately, whilst you can have multiple Page Properties macros on a single page, the Page Properties Report will only pick them up if they have different column names, so you'll have to have each server/service combination on a unique page, like this:
In this example I've assumed that each server will have the same services on it. Therefore in order to have unique page names I've used "Server1 Service1", "Server2 Service2", etc. If each server has difference services this won't be necessary, but you'll have to add a row to the Page Properties macro to include the server name. (Another option would be to give each page a number, i.e. 1, 2, 3, 4, etc, and add the server name in a row to the Page Properties. That would make it easier to sort on the column headers, but that's up to you.)
On each of those child pages you have a Page Properties macro like this:
Each of the child pages has the same label (e.g. "server")
On the parent page (called Servers in the screen shot of the tree view), or wherever you want to have the page for the engineers, you set up your Page Properties Report to look for these pages and you get:
Page Properties Report.png
You can set up Page Properties Reports to just show e.g. the services from Server1 by using additional labels, if that's something you want as well.
This isn't necessarily ideal - you have to have a page for each service, and the page names are a bit clunky - but if you want a free, simple way to aggregate the server data, that's the way I'd do it.
Otherwise you're looking at either Nic's multi-excerpt method, or a more manual method of aggregating the data.
Does all that make sense?
Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time! We're looking for people to participate in a remote 1-hr workshop...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs