Task report empty after migration

[Stijn Agten]

We recently migrated to confluence cloud and starting using the new editor (https://support.atlassian.com/confluence-cloud/docs/convert-pages-to-the-new-editor/)

Before the migration I was using the old editor and I was creating tasks assigned to myself, spread over different pages and spaces. I was following up on my tasks via the "Tasks" page which can be accessed via the profile menu.

Since we migrated I noticed my list of tasks is empty. When I convert a page to the new editor the task shows up again in the task report. So it looks like tasks from the old editor are no longer displayed.

This is a big problem for me because I basically lost my full task list on which I depend to have an overview of my to do's from different meetings. 

I don't know which pages have tasks and they are literally spread over 100's of pages and different spaces. I can't find them back manually.

I tried looking for a bulk convert option to convert all pages to the new editor, hoping to get my tasks back but even if that was possible, I would need to convert all spaces (also the ones I don't own) so not even sure that's a valid option.

Question: anyone who knows if it's possible to create a task report which displays tasks from the old and the new editor combined? Or any other suggestions, tips, best practices?

[Midori]

You should automatically generate this report with the Archiving Plugin.

This plugin displays a so-called Content Quality report which will calculate and list the pages not updated in the recent N days. The age of the page is calculated recursively (propagating upwards), this is what you originally asked for, if I'm not mistaken. See a sample report below.

Even better, the plugin will also help you to archive the pages that are not updated and/or not viewed.

And it features a fully automated "set it up and forget it" approach, which scales nicely to thousands of pages.

content-quality-statistics.png

[Matthew J. Horn]

Ok, maybe you can try this user macro (put it on all your pages, in a Layout Decorator). You can hide it by wrapping an IF statement around it that checks against a user type (like admin), your username, or some other comparison.

## Macro title: Recently Updated Children
##
## Developed by: Matthew J. Horn
## Date created: 01/16/2014
## Installed by: ______
## Description: Lists all children and their timestamps. Similar to "Recently Updated" macro, except it only applies to child pages of the current page. It's a combination of "Recently Updated" and "Children Display".

## @noparams

#set ($pageListArray = [])
#set ($rootPage = $content)

#macro ( process $rp )
## note: Not sure what diff is between getChildren() and getSortedChildren()  -- "sort" is not by timestamp
  #set ($pagelist = $rp.getSortedChildren() )  ## returns List<Page>
  #foreach( $child in $pagelist )
    #set($p = $pageListArray.add( $child ) )
    #if( $child.hasChildren() )
      #process ( $child )
    #end
  #end
#end

#process ( $rootPage )

<table class="confluenceTable">
 <tbody>
 <tr>
  <th class="confluenceTh">Title</th>
  <th class="confluenceTh">Version</th>
  <th class="confluenceTh">Mod Date</th>
  <th class="confluenceTh">Modifier</th>
 </tr>

 #foreach( $child in $pageListArray)   ## child is of type Page
   <tr>
     <td class="confluenceTd">$child.getTitle()</td>
     <td class="confluenceTd">$child.getVersion()</td>
     <td class="confluenceTd">$child.getLastModificationDate()</td>     
     <td class="confluenceTd">$child.getLastModifierName()</td>
   </tr>
 #end 

</tbody>
</table>

Let me know if this does what you want. It sounds like you want to integrate this with a date range search, but I haven't quite gotten my head around how to do that yet.

matt

[Matthew J. Horn]

And a quick note, this does not include sorting in the macro. But tables in Confluence can be sorted on any column with a mouse click, as of Confluence 4.3.something...

[Mick Davidson]

Matthew,

Thanks for all your efforts on this. I've given this to our IT team but we've been having some issues recently (Confluence and non-Confluence) that has meant we still haven't tried it. I'll let you know what happens when we do.

Cheers.

[Matthew J. Horn]

For 1,000s of pages, I would definitely look into using the SQL plug-in:

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

[Mick Davidson]

Thanks Matthew,

Yes, I wasn't clear there was I? :) I mean that in the space there's 1000s of pages, but using my modified search, I'll find a page within a group of related child pages.

Often the head page won't have been edited since it was created, but the others might have been.

So I'm not looking through 1000s in one go, I'm looking at a group that might be ten or twenty strong.

Cheers.

[Matthew J. Horn]

Ok, in that case I would write a User Macro because it sounds like you're going to want to show the your info on many pages (maybe "parent nodes" of small groups of sub pages)?

Lessee, maybe an "illustration" would make this clearer:

http://yuml.me/89832755

In this image, the second "row" (Topics 1, 2, and 3) is where you want to put your macro. Is this about right?

[Mick Davidson]

Matthew,

Yes, that's right. All I want to do is ID the last edited page so I can go straight to it to see who edited it.

The info doesn't need storing or displaying to anyone else. It's all mine... :)

[Matthew J. Horn]

Sorry to keep belaboring the point, but figuring out exactly what you want to do determines the best way to do it. (By best, I mean most performant and easiest...)

If I understand you correctly, you want to ID the last edited page within each "child group" (the Topics 1-3 in the image)? Is that correct?

Are these known pages (do you know the page names or IDs of the pages?), or do you need to sniff them out as well?

[Mick Davidson]

Sorry if I'm not being clear, thanks for sticking with me. :)

"If I understand you correctly, you want to ID the last edited page within each "child group" (the Topics 1-3 in the image)? Is that correct?"

Yes, that's right.

They are known to me because they, the pages, come up in the results from my date search.

[Matthew J. Horn]

Sorry, now I'm the one being unclear: are the parent pages known to you? In other words, Topic 1 is a parent page with 10 child pages. You want to find the most recently edited page of the children of Topic 1, correct? How many "Topic 1s" are there? And do you have a list of them somewhere?

[Mick Davidson]

Yes, but only because I find the child page, then see what the parent is called.

I then check that to see when it was last updated. It's a very manual process. :)

Cheers.