.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Bulk Change of Items with Exempt from Policy to Nonexemption Status

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :C#

I have an announcements list that we use for alerts. This list has a working custom SPD workflow attached for emailing the posted alerts.

Recently, I setup and applied an information policy to the alert content type assigned to this list that takes the Expires date and runs a workflow that copies the expired items to another list (archive list) and then deletes the expired items from the active list. The policy works great for newly created items. However, for the already existing 300 list items the Information Policy and its workflow do not work. In the Exempt From Policy column, these items are marked as follows: "This item is exempt from policy. This item will not be expired until the exemption is removed. Remove Exemption..."   

I cannot make the change in Data View because the Exempt From Policy status is set by SharePoint. It cannot be updated except by opening each item and clicking Remove Exemption. My boss has assigned me with finding a bulk method to make the change.

I've tried to create a workflow in SPD (with extended workflows added) to change the Exempt From Policy column status to nonexempt. Unfortunately, I cannot find a way to make this happen even though I googled this issue

View Complete Post

More Related Resource Links

Change the Workflow Status through code


HI Folks,

I have a scenario where i need to develop a 6 stage approval workflow(sequential) using WWF and depoly it to sharepoint. Everythigns fine till here.

Now we look ahead to change the Status field on the documents library which actually has the Workflow Name as the column name and its value being In Progress, depending on the stage of approval. Like(Approved 1, Approved 2, Approved 3.)

And if rejected the status should be rejected than Completed. Any idea how can we update this column of the List item.

I have tried item[workflowProperties.Workflow.ParentAssociation.Name]="Approved 1";

But this throws an error saying input string is not in a correct format.

Any information would be of great help :)


Sreeharsha Alagani

dropdownlist javascript change items


I can't find solution for this problem for very long time:

I have dropdownlists in Gridview. I need to dinamicly change content of dropdown on client with javascript. Ok, I know to do that. But the problem is when I send data to server changes in dropdownlist does not see. On server I have  old items. How can I change items in dropdown on client with javascript and than see that items on sever when postback data?


dropdownlist bound to sqldatasource adds items instead of replacing on change



I have a series of dropdownlists on webform in ASP 4.0. The first drop down is filled upon load, and then when a user selects a value from that list, it populates the second dropdown. To accomplish this, I have a SQLdatasource with a parametersource of the first drop-down list control. This works great, except when a user changes their selection from the first drop down. It performs the query, but then adds the list of items to the ones that were already there from the previous selection, instead of replacing it with the new data. Here is the code:

 <asp:DropDownList ID="ddlMajor" runat="server" DataMember="DefaultView" 
      DataSourceID="SqlDataSource1" DataTextField="majortext" 
      DataValueField="majorkey" AppendDataBoundItems="True" AutoPostBack="True">
         <asp:ListItem Value="0">Select Major</asp:ListItem>
<asp:DropDownList ID="ddlReq" runat="server" DataMember="DefaultView" 
      DataSourceID="SqlDataSource2" DataTextField="req" DataValueField="admreqkey" 
            AppendDataBoundItems="True" AutoPostBack="True">
                <asp:ListItem Value="0">Sel

How do i resize teh status bar items?

hi friends, i have the following status bar and i have added a color scheme so the it's clear what im asking of:     here what i want: 1. How do i set the statusstrip item colored in black to change it's length when teh form resizes and and i want all the other statusstrip items to have fixed size (that doesnt change) when form resizes? 2. How do i set the status strip item colored with pink and blue to fixed length but all others changes its lenght when form resizes? thanks

how to change the permissions list items using the workflow?

How to change the permissions list items using the workflow? Or how to instull SPDActivities on sharepoint 2010?

Change Item order wont work for folder items

Hello. Links lists in Sharepoint 2010 have Change Item Order Action which can order your items. I added new content type based on folder content type to my list. And When I want to order my folder items with Change Item Order action Sharepoint sorts my items randomly. For example with 4 folder items it sorts it right in 3 or 4 times. I can't see any rule in it's behavior sometimes it works sometimes not. For Link list items everything is OK. Anyone have an idea? Thanks.

Change style for aspMenu items

I am using a aspMenu that renders the horizontal global navigation with useSimpleRendering="true" so that a list (ul,li) menu implementation is used rather than the table implementation.  My question is - how do I change the style of the UL, LI elements? They have class names such as "root static", "static dynamic children", etc. etc.  I can overwrite the css definition for these styles in my custom css. But what if I want the implementation to use my css element names? I tried with using the "CssClass=classname" and "UseSeparateCss=true" for the <Sharepoint:AspMenu> .... but this doesn't seem to have any influence on the CSS elements for the List. Any suggestions? Thanks in advance, Jake.

How to Change Workflow Status Programatically on DueDate reached


I have developed a sharepoint approval workflow using VS.NET 2008. Workflow fires when any new item is created. Three parallel task is created and waiting for approval.

Workflow will only completed when all three approvers approves/completes their task. I want to change the status (denied) of the workflow every tuesday 11:59PM if any one of the approval is pending. This  denial work I want to perform by programatically within the workflow.

so I need suggestion how do I achieve the above scenario?

Do I write any timer job to monitor workflow status on every tuesday 11:59PM and denied as per the logic mentioned above.


Do I encaptualte the denial logic withing the workflow itself?

Please suggest a way to solve the problem...

thanksArup MCTS - SharePoint

Play Sudoku

Change the Status in Gridview column




I have a gridview and a button-Start in aspx page.

In gridview 3 columns checkbox , Name and Status.

Select multiple columns and click on Start then Status column for selected rows should be changed to "Starting...", later it should be changed to "Started".


But it is showing directly "Started". In the mean time i should see "Starting..." also.


Here is my code


<b>Aspx page</b>


 <asp:GridView runat="server" AutoGenerateColumns="False">


<asp:TemplateField>   <ItemTemplate>                                                    <asp:CheckBox runat="server"/>



<ItemTemplate> <asp:BoundField HeaderText="Name" DataField="Name" />  

<asp:TemplateField HeaderText="Status">          &nb

How to change a SharePoint list item Approval Status from Silverlight webpart



I'm facing the following problem:

I have an embedeed silverlight xap application inside a custom visual webpart, that access SharePoint data through Microsoft.SharePoint.Client.Silverlight classes, and I have to modify some fields from an item from a list that has "Require content approval" enabled. I update the item successfully, but its approval status is set to "Pending" afterwards. 

How can I re-approve the content programatically?

Some additional information:

  • SPList item has a moderation information field, but in Silverlight there is only "ListItem" which does not contain such field.
  • When I try to do "item["_moderationinformation"] = something", I receive a PropertyOrFieldNotInitializedException.
  • I can check for Item.ParentList.EnableModeration, but there is neither a field nor a method related to moderation on the item itself.
A possible solution would be to create and call a web service that approves the items, but I'd rather prefer to avoid hosting and calling a ws to cover this functionality.

Any help on this would be greatly appreciated.




Change Document Library default action on Items



I have a standard Document Library where I uploaded various  kinds of file (.pdf, swf). Whenever I click on an item (or I paste its direct link into the browser) it prompts me to download it instead of opening it into the browser directly (with flash player or acrobrat in my example).

How to obtain the desired behavior? Thanks

Policy-Based Management and On Change - Prevent




I’m working on Policy-Based management feature and I’m keen to implement some of the features. I tried to setup a Policy for a “backup device” facet based on the condition that the name starts with bkd_. I tried to set the evaluation mode to “On Change – Prevent” but unfortunately I could not find the mode at all in the Policy Screen. I also made sure the “Nested Triggers” advanced Option is set to 1.


I went through this  link http://blogs.msdn.com/b/sqlpbm/archive/2009/04/13/policy-evaluation-modes.aspx and checked for the execution_mode in  msdb..sysp

Facebook connect and change status using asp.net


Hi All:
I need to do this using asp.net. What are steps to do this. Do i need to use some third party etc?
One asp.net form with a 'facebook connect' button and a 'change status' button 
2.Every time someone clicks the 'facebook connect' button it collects their facebook authentication keys and save them somewhere (e.g. sql table) 
3.When someone clicks the 'change status' button it goes through the keys it has and changes all

Content Query WebPart shows page items with status "draft", and page items that current user does no



I have this issue that CQWP is rendring items that it should not render. I test this with a read-only user, that should NOT see draft pages or pages with different permissions. But the read-only user do see the items, but when I click on the link I get access denied. This access denied is correct, but why does the page items appear in the CQWP at all?


1) I use OOTB CQWP (inherits from ContentByQueryWebPart in my .webpart file) : "<type name="Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart ....." and I have my custom xsl to get the look and feel I need

2) The issue with page items showing when status = drafts only appear when using the PublishingExpirationDate field. When I try creating new pages and give them status draft by using "check in to share draft" (logged on as an contributer/approver user), this item wil NOT appear in the CQWP for the read-only user. When I change a pages' status from approved to draft, this item will still be shown in the CQWP, but this will point correctly to the published version. But after the pages' expired date (PublishingExpirationDate) is expired, the page gets status "draft" (handeled by a timer job I guess), and this page item will still be rendered in the CQWP, but sending the read-only user to an access-

Change the content type for multiple list items


I have a document library which is configured to manage content types.  Users will be expected to upload multiple documents into the library.  Then they will be expected to choose the content type of the file and fill in the required metadata.  The only difference in these content types is the template which will be used to create new files of the specific content type so the columns are identical for each content type.

I have created a public view with inline editing enabled but Content Type is not an editable field.

The problem I have is that when I enable Inline editing, the users don't have an opportunity to select the content type, even though the files have just been uploaded and have not been checked in.

My question is this; how can users change the content type of multiple items without having to go through the complete New Item form? 

With literally thousaands of documents to be imported, having the users fill out a separate form for each document when many will have the same column values is a show stopper for our rollout.  It will take too much time.  The project will be a failure. 

I've also tried to create a datagrid view but the same problem exists.  Content type is not an editable column value.

Thanks for helping.


Policy Evaluation Mode On change: prevent and On Change: Log Only not available


Hi All,

I am creating a policy to ristict Developer to use definied naming convention for stored procedure , but i am not able to see Policy Evaluation Mode  On change: prevent and On Change: Log Only.

Please let me know what is the problem.

i have checked the sp_configure option nested triggers and server trigger recursion is enabled.


Mohd Sufian www.sqlship.wordpress.com Please mark the post as Answered if it helped.

How to change Progressbar status Text in setup project dynamically


Hello ,

I create a Setup for my project in Visual Studio.I want to change the progress bar status Text at runtime.The default status text is "Please Wait" .To change the Status Text I call the API method "MsiGetMode" .But there are two parameter of this method one is "install (Handle to the installation provided to a DLL custom action or obtained through <see cref="MsiOpenPackage"/>, <see cref="MsiOpenPackageEx"/>, or <see cref="MsiOpenProduct"/>) " How can i get this first parameter in my installer class.And second parameter is "runmode(Specifies the run mode)" .If there is any other way how can i do that.

Please help me

Thanks & Regards,

Vipin Kumar

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend