SharePoint Online task list web part

Sean,
you can now enter column aliases [ie.display a �friendly header name� instead of the default column name] by appending the friendly name to the column, separated by the �|� pipe symbol.

Example:
PercentComplete|Percent Complete

1. We actually forgot to include the �*� wildcard option for the �Lists to be included� field. This has now been fixed.
2. To include a custom column in the web part�s �Field Template� setting, please prefix it with an �*� asterisk character:
   Example:
   Title;Priority;AssignedTo;*Subject

/Tasks

I'm doing some testing with it first, and I've noticed the following:

- Custom date fields show as: 2012-10-01 00:00:00 [even if they are set to date only in the source List].

- Currency fields show as: 44666.0000000000 [no matter how few decimals you specify in the source List].

- If you group by the Site, the Site link stops working. Can this link remain, or ideally go in the Group heading?

- I cannot filter by custom columns not showing in your view output [e.g. if I have a custom status field called SomeStatus, and I only want to show items where SomeStatus='Current', but I don't want to show SomeStatus in the view].

- I cannot filter by calculated columns [it does not recognise equality]. We have a custom field that calculates the severity of an issue, and I want to show only items of one of the two highest levels of severity, but I cannot compare with the output of the calculated column.

- I'm having a lot of issues with the 'Lists to be Included'. I can't seem to specify two or more Lists or Sites [e.g. projects/blahProject/Schedule;projects/program/Schedule or projects/blahProject*;projects/program*] - only resolves the first.

Is it possible for any of these be looked into and/or resolved?

Thanks for creating such a useful Web Part.

.AETRpager TABLE TR TD {font-size:11pt }

[change the font size accordingly]

- ID
- Title
- Author
- Created
- Modified

If you would to add a custom column [ie. a column that is not listed above], please prefix it by an "*" asterisk character.
Example:
Title;Author;*PhoneNumber

Example:
Title;AssignedTo;*Comments

If you are actually referring to the Sharepoint �Issues� List�s �Comments� field, please enter it as follows:

Example:
Title;AssignedTo;*V3Comments

[the internal name of this List column is �V3Comments�]

Examples:
AssignedTo LIKE '%{username}%' AND Status'Completed'
AssignedTo LIKE '%Fred Webster%'

Lists to be included:
This has been fixed in the most recent release.

Yes, it is possible to use custom fields for sorting, grouping and filtering.
Please note that we just added a fix [with version 1.0.25] to properly format numeric fields so that they can be used in a Property Filter expression.

Example:
Title|Task;!Site;Priority;DueDate;Status

This is a custom field that was created.

Thanks,

Example:
TaskSoftware='Mobile Iron'

*Requested_x0020_By

Use the asterisk prefix to indicate a custom [non-standard] task list column and replace the space character by _x0020_

Friendly Header Names:
If you would like to display a �friendly header name� instead of the default column name please append it to the column, separated by the �|� pipe symbol.
Example:
Title|Task;AssignedTo|Responsible

You also can suppress the column name in the groups [ie. just display the value] by appending the �/suppress� option to the web part�s �Group By� setting.

Please send us a quick note if you still need to be able to localize the �Group By� column name.

Thanks for your fast and kindly support. The "/supress" option works fine. It's very useful and I hope to add this option in the "Employee Directory web part" too.
But I need more localization and customizations. For example:
1- I changed and added some items in the "Status" field of the "sharepoint task list". but I can't add or change the icons or hints for them in the task rollup web part. These items can be difference from one task list to another!
1-1- Is there any way to change or add the icons in the web part?
2-1- Is there any way to change or add the hint texts [near the icons] in the web part? It will be useful if they read from the "status" field in the "task list"

2- I have the above questions about the field "priority"
3- I need to show an "edit button" for each record in the web part.
4- Is there any way to have some search boxes above the web part? [like staff directory web part]
5- I selected the "Show Groups collapsed" field, but the web part allways works in "expanded mode"
6- When I connect this web part to "Custom lists", it does not work and the page can not load any item.

regards,
Abbas

1. Sharepoint unfortunately is not able to return the value of a �multiple value� Lookup column in a cross site data query.
2. Did you prefix the column name with an �*� asterisk character in the web part�s �Field Template� setting ? Also, what is the column type ?

2- Yes, I prefix the column name with an �*� asterisk character with these column types: lookup, calculated field and multi choice.
these columns are not in all task lists in all sub-sites.

Thanks and regards

Abbas

• extract the WSP file from the downloaded Zip file
• upload the WSP file into the Solution Gallery in the Site Setting of your top site
• activate the solution

Thanks.

Thanks.

Thanks!

Isn't there any workaround?
Thanks.

On each of the Regional Sub-Sub-Sites, I have the standard Task list.
At the Quality Sub-Site Level, I want to add the web part that will roll-up all the Task lists in the Regional Sub-Sites.

From the instructions, I think the minimum requirements to see anything would be:
Field Template needs at least one column
List Type should be set to "Tasks"
Search Subsites Only box checked
Cache Retention Time = 0 [which I presume would make it 'current' all the time]

I added some test examples on the AAM Site Task list but the web part just shows "Nbr. of Tasks found: 0".

The only way I can get anything to show up in the roll-up is the uncheck the option to "Search Subsites Only". When I do that, I get a single task from a list in the collection root but nothing else. I also tried changing the list type to the other options and only get items from lists on the collection root site. Lastly, I also tried moving the web part to the root collection level and had the same problem.

As a last ditch effort, I also tried a number of explicit "Lists to be included" but couldn't get anything to work... but that could have been syntax errors because there is no example showing if the web part is in a Tier 2 site and the task lists to roll up are on Tier 3 subsites.

Thanks for any help.

Thanks again for your great support.

I've never tried this part so maybe I'm doing it wrong.... all I did was add the web part, and under list types select "Tasks" and hit apply. I get the following error at the top of the Web Part Properties

"Cannot save all of the property settings for this Web Part. There is a problem with one or more of the field values below."

Could whatever causes this error be causing the Amrein part to be empty as well? Maybe a collection setting or feature that needs to be enabled to get this to work?

Thanks

I just tried your Document Rollup on both our Sandbox and Production environment.
In the Sandbox, the rollup works worked perfectly the first time without even looking at the instructions...
In Production, it doesn't seem to show any documents I just added in the Shared Documents libraries. It only shows items in the Site Assets libraries.

Unfortunately, we don't have the Task Rollup in the Sandbox or I'd try that and see what happens.

Is it possible something was not installed correctly in production? I'm not the architect so I have no idea how that's done...
Thanks again.

To answer your questions first:
SP2010, Tried multiple things in field including just "Title", most things are customized [libraries and task lists].
I'll try your 4711 and report back but since you mentioned customzing, I thought I'd give you this additional info:

I've done some more testing on the Sharepoint Content Rollup, our production and sandbox environment and your parts.

One thing I noticed, was that in our production environment, we defined new default content types or Documents and Tasks.
We have a new default Task Type called "Company Task" which is a child of the Sharepoint "Task" Type. The same with Documents.

I also noticed in the Query section of the SP Content Query, there are a lot of options for content type.
When I scroll through them I can see that I can pick specific Task Types including "Company Task" and "Task".
But there is also a check box to "Include child content types".

In your Task Rollup part, I noticed you have "List Type" which has only 4 options including "Tasks".
Could it be that your query only looks for the SP Default content types and does not look for Child Content types?
That would be the only thing I can see different.
I didn't see any drop down for Types in your document roll-up so I'm not sure if that would also apply there as well.

If that's not the issue, I'm wondering if it could be one of the following:
Some hidden setting on Production farm limiting roll-ups [because SP Rollups also seem to error out].
Something to do with permissions [although I'm Collection Admin so that shouldn't be a problem].
Something in the library preventing it from working [although I just tested a default library with no modifications and still no success].

Thanks,

I added an item in the Tier 3 subsite which has our default task list named "Tasks" [which has "Company Task" as the default type].
So I'm not doing any customization but our template has been customized becuase of it's content type.
I also tried creating a task list at the Root called "Tasks" but it wouldn't let me because that's used for site worfkows.
So I created a new list named "Test ALV Tasks" instead and added an item for testing.

In your Task Rollup, I put the following settings:
Field Template: Title;PercentComplete
Nbr. of Tasks: 4711
Checked all "Show" check boxes except the last one.
List Top Option: "Tasks"
Lists to be included: Tasks;Test ALV Tasks;Quality/AAMQuality/Lists/Tasks;Quality*
I included a bunch of variants from being specific to generic.
Search Subsites Only = NOT Checked

Result: No Items to display

2010=True
CAML=
creating DataView:Nbr of rows=1
getting List:{80D2B813-51ED-4399-8A60-D4844BB3C442}/sites/alvCustBUTemplate|Tasks 1|/sites/alvCustBUTemplate/Lists/Tasks 1/AllItems.aspx
checking Site:/sites/alvCustBUTemplate/Tasks 1 - tasks
checking Site:/sites/alvCustBUTemplate/Tasks 1 - test alv tasks
checking Site:/sites/alvCustBUTemplate/Tasks 1 - quality/aamquality/lists/tasks
checking Site:/sites/alvCustBUTemplate/Tasks 1 - quality* ..skipping Site
Nbr. of Tasks found: 0
Databinding..

I also tried the following:
Cleared "Lists to be included" and got a single task from Tasks 1 which is linked to site workflows.
Tried list Type "Issues" and didn't get any results.
Tried custom lists and it returned a lot of things from my custom lists.
Tried changing default content type on list Test ALV Tasks to just "Task",
Cleared Lists to be included, Then reated new items, then refeshed view.... Only shows the 1 workflow task.

My question is that by using the listID, does it disable the other "Lists to be included" functions like the "*" wildcard and "!" exclude?

I tried the following in that setting: /id=10000;!AAM Quality/Tasks & also just /id=10000;!AAM Quality

In both cases, the items from the Tasks list on the AAM Quality Subsite still show up. One comment is that my structure is:
Home Site/Global Quality/AAM Quality
The Task Rollup Web Part is on the Global Quality Sub Site and it rolls up 8 regional sub-sites under it.

Thanks agian for your great response.

As far as I can tell, I don't have any properties set that impact the formatting of the column Titles.

Is this something by design in the web part that I'm missing the intent? Or could it be due to something in our default template or layout?

Thanks for any help you can provide.

I downloaded this great Web Part but I have problem with adding Tasks list?

After add all field I always see "There is no items to show in the view"

Could you write me how should be looks like proper list address in field "Lists to be included?

I will be very grateful for it,
Best regards,

Home Site/Global Quality/AAM Quality/Tasks/id=10000

ie. append the �/id=10000� at the end of the field and enter the full path to the list [without the domain part].

- Field Template
- Sort By
- Group By

SomeSite/SomeSubsite/Tasks

[the above example assumes that the List is called �Tasks�]

So I should use SomeSite/Tasks with out // and .aspx?

Best regards,

Best regards,

We have a site which just has a bunch of company wide calendars which can be used by all the collections. I'd like to have a way to show all the latest changes on the calendars... they all have different names but all have List ID = 106.

Thanks

Title;*EventDate;*Location

Nbr. of Tasks found: {n}

I have tried this previously on a live Sharepoint Online site collection running the older version and it works fine with that.

I saw the earlier post about a similar issue and tried both this: *Project_x0020_Value/cn2|Project Value; and *Project_x0020_Value|Project Value/cn2; and neither of them seems to work. The prior, however, breaks it and shows "Project_x0020_Value" in the web part.

I'm currently evaluating this web part in our Sharepoint Online environment and if I were to get this working we would probably buy this for our company.

*Project_x0020_Value|Project Value/cn2

Can you quickly check the web part�s version number by opening the web part�s tool pane and looking it up at the top ?
We added this feature with version 1.0.25 on October 19, 2012.

Yes, there are still a lot of trailing zeroes. My "Field Template" setting is as follows:

Title;*Project_x0020_Value|Project Value/cn2;*Project_x0020_Category|Project Category;Priority|Project Priority;StartDate|Project Start;DueDate|Project Due;*Project_x0020_Phase|Project Phase;AssignedTo|Project Manager;PercentComplete;

/mylist

If you want to roll up all lists [including the list in the root site], please make sure to uncheck the web part�s �Search Subsites only�.

I have now sent the additional details to your support address.

/mylist/id=105

If you do not specify the ID, the web part will roll up lists based on the �Custom List� template.
Can you quickly check the web part�s version number by opening the web part�s tool pane and looking it up at the top ?
The above feature was added with version 1.0.27 on December 18, 2012.

settings ?

Everything else is by default

Title,ListId,Site,PercentComplete,Priority

[ie. use commas instead of semicolons as the separators]

Please, ca i change the language to frech ?

Have a good days

We are evaluating using version 1.0.38
First issue: we keep receiving this error: AssignedTo Error: Column 'AssignedTo' does not exist. It may have been deleted by another user.

We allow multiple selections and groups in the AssignedTo field.
I have tried the filter as shown above: AssignedTo LIKE '%{username}%' AND Status'Completed' but no luck

Second issue: Only showing tasks companyweb/subsites/subsites but no deeper levels of subsites. Thanks

I'm using SP2013 Preview.

1. are you using a language pack different from English ?
2. the web part should not be limited regarding the hierarchy level of the subsites. Could it be that you limit the number of tasks to be shown via the "Nbr. of Tasks" setting ?

I finally got it to work for a particular site and it's subsites using the setting for "Lists to be included" value: Projects* and checking the box "Search Subsites only" The web part being added to the site collection homepage.

I think the problem we have with the hierarchy is the use of custom site templates and custom task lists. If I create sites using the out of box templates and then more subsites the tasks are showing in these subsites. Thanks for your assistance.

Thanks, changing the list type to Timeline worked. I'm doing some more in depth testing now.

One thing to note: I had some trouble getting specific lists [Lists to be included] to work - it seems that there are issues if the list name and list URL aren't the same.

!/Archive*

to exclude all Lists that start with �Archive� in the List name.

Please re-download the updated Zip file, extract the WSP file and then update the web part solution.

Example:
#ffffcc;#ffff99

Please re-download the updated Zip file, extract the WSP file and then update the web part solution.

Thanks,
Mike

AssignedTo='{username}' AND Status NOT = 'Completed'

And am receiving an error:

Error: Cannot find column [AssignedTo].

AssignedTo='{username}' AND Status'Completed'

Can you also indicate the content of the web part�s �Field Template� setting.

*WorkflowLink;*WorkflowOutcome

1] I can't find AE task rollup part when i try to "insert" web part, however if I upload the webpart first when editing the page, I am then able to find needed webpart.

2] Web part does not find any tasks in my site collection. this is the settings i tryed:
filed template:
Title; ListId;

Nbr. of Tasks
120

Sort By
Author

Group By
Author

Lists to be included
tried *, leaving blank or just putting a link to one of my task lists

webpart shows its name and "Nbr. of Tasks found : 0". nothng else.

What am I doing wrong? thanks for your help!

Is there a way to use a "friendly name" not only in list column names, but in "group by" option?
For example I want to use group by AssignedTo|Responsible but i get an error saying

DataBind Error: DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'AssignedTo|responsible'.

Thanks, your webpart is GREAT, probably going to purchase it.

Example:
AssignedTo|Responsible

Please re-download the updated Zip file, extract the WSP file and then update the web part solution.

I have 2 sub-sites and 1 task list on each.
I have a Task Roll Up Web Part on each sub-site, all fields are displayed correctly ["Site;Title|T�che;Priority|Priorit�;Status|Statut;DueDate|D�lai;PercentComplete|Avance"].
Icons column are displayed correctly too.

The Web Part is already on the Site Collection homepage, with the same fields, same filter, no list limitation is defined.
All tasks are displayed correctly except the status column.

My problem is :
The status column will not display the status icon but only the text if I uncheck the corresponding Web Part property.

Thanks in advance for your help.

I tried the task roll-up web part to collect the open tasks from a large number of sites [100+].

When I configure the web part I always get the following error [with setting 4711] that states thet the number of lists in the current query is too large. I tried specifying a single list, but still get the same error.
What can I try?

Current Locale=1043
Default Locale=1043
2010/2013=False
License File Read Error:Could not find file 'C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\template\Features\AETaskRollupWebpart\License.txt'.
CAML=
SP Version=12
Error: De query kan niet worden voltooid omdat het aantal lijsten in de query groter is dan de toegestane limiet. Beperk het bereik van de query tot de huidige site of lijst of gebruik een aangepaste kolomindex om het aantal lijsten te helpen verkleinen.

I see that you told another user that I need to select the List Type of GANTT. I have tried that and am not getting any data back yet.

My Project Tasks lists are called "Project Task". They are in subsites one level below my roll-up on project sites. There can be a few dozen of these and I wont know their names in advance. Do I need to enter anything in the LIST NAME field?

The subsites have names like Project1, Project2, Project3 and again the list on each Project site is "Project Tasks".

Thanks
Larry

You can override this setting by adding the "AETR_MaxListLimit" appSetting variable [to be added to the appSettings section of your Sharepoint application's web.config file]:

.
.

The value entered restricts the search to the specified number of lists.
You can enter �0� to remove the limit [so all your lists are included in the search].

I tried in a standard webpart page and it works. So the problem seems to appear when I insert the webpart in a wikipage. Did you already see this problem?

Pierre