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


Top 5 Contributors of the Month
david stephan
Santhakumar Munuswamy
Fauzul Azmi
Asad Ali
Post New Web Links

Approval Status Value and Version missing in "Edit in datasheet" and "Export to Excel "

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

Hi there.

Anyone knows how to show the WF approval status value (Approved, In process, Rejected...) and the version column from library and list to xecel download (Export) or in datasheet?

Your expert advise will be much apprecaited.




View Complete Post


More Related Resource Links

Content Query Webpart Missing Content Type and Approval Status

  

I'm a great fan o the CQWP , and love the changes made in 2010 on this webpart. What bothers me is that I use to Filter Documents by Approval Status, thus showing Draft or Pending Documents and Group these by their Content Type.

Both these were available in 2007, but removed from 2010 CQWP. Any idea why, or how to bring this back? sample or URL guidance would be great. My gut feeling is custom XSLT but id like to confirm this first.

Thx a lot

 

 


Send alerts based on approval status

  
Hello, I have a list of posts on blog site and set alerts on this list. The problem is that every time I post a new blog entry an alert is sent to the users despite the approval status of this post. So every edit attempt causes a new alert. The users does have only read permission set on this Post list. Is it possible to configure the alerts so the alert is being sent only when the post status is set to approved? BR, Tomek

OOTB Approval Workflow - Approval status could not be updated

  
I've setup up a standard OOTB (out of the box) approval workflow on a Pages library, in order to manage the approval of all pages created and updated.  This operates as expected, and the users are mostly happy, execpt for one scenario: Once a page has been submitted for approval, if the approver wants to edit the page, it stops the workflow (after prompting) which then requires the workflow to be started again.  They would like it so the approver can edit and then approve, without restarting the whole workflow process. There is a setting in the approval workflow configuration of the 'Complete the Workflow' section in the 'Cancel this Workflow when the' area, and by unchecking the 'Document is changed' option, I believe this should enable approvers to edit the page and then approve the page, without stopping the workflow  However, the workflow appears to operate as expected, except the page does not automatically get approved.  By looking in the workflow history, I can see the following error: Post-completion activity performed. Approval status could not be updated. I've tried this on two separate MOSS 2007 Enterprise farms, both are publishing sites and I'm running as a site collection administrator, both with the same results. Is anyone else getting this, is this normal?! Is there another way to approach this, without having to go

Thread status image missing

  
Note the "Red Box" where the image is missing. There are replies posted to that thread and also an accepted answer.Here is that thread link: http://forums.asp.net/t/1601163.aspxP.S. This might be normal but I noticed today.

Approval Workflow does not update the Content Approval status if started automatically

  

Hi,

I’m using a simple Approval Workflow associated with Content Approval on site pages. It works fine when I set it to be started manually (by using Allow this workflow to be manually started by an authenticated user with Edit Item permissions  option) and on the completion of the workflow the Content Approval status is updated accordingly. But when I set it to be started automatically (by using Start this workflow when a new item is created  / Start this workflow when an item is changed options), it does not updates the Content Approval status. Note that I’ve set the Update the approval status after the workflow is completed (use this workflow to control content approval) option to true.

Regar

Approval Workflow does not update the Content Approval status if started automatically

  

Hi,

I’m using a simple Approval Workflow associated with Content Approval on site pages. It works fine when I set it to be started manually (by using Allow this workflow to be manually started by an authenticated user with Edit Item permissions  option) and on the completion of the workflow the Content Approval status is updated accordingly. But when I set it to be started automatically (by using Start this workflow when a new item is created  / Start this workflow when an item is changed options), it does not updates the Content Approval status. Note that I’ve set the Update the approval status after the workflow is completed (use this workflow to control content approval) option to true.

Regards

Approval Workflow does not update the Content Approval status if started automatically

  

Hi,

I’m using a simple Approval Workflow associated with Content Approval on site pages. It works fine when I set it to be started manually (by using Allow this workflow to be manually started by an authenticated user with Edit Item permissions  option) and on the completion of the workflow the Content Approval status is updated accordingly. But when I set it to be started automatically (by using Start this workflow when a new item is created  / Start this workflow when an item is changed options), it does not updates the Content Approval status. Note that I’ve set the Update the approval status after the workflow is completed (use this workflow to control content approval) option to true.

Regards

Update Approval Workflow task status

  

Hello All

I am trying to update the task status automatically after a list item is approved without much luck. I need to set the task status to "completed" without having to manually hitting the "complete task" button, so the next person in line can approve the list item.

How can I change the status of a task using SharePoint Designer 2010?

In my SharePoint Designer task editor I have:

<code>

if Current Item:Approval Status equals 0;Approved

---I need to add a line in here that updates the task status to "completed"

Assign Approve list item to User2

</code>

 

Thank you all in advance.

Regards

Yoshi


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

  

Hello, 

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.

Regards,

Ezequiel

 


Workflow Approval Process not setting item's Approval Status

  

Hello,

I've been pounding my head against the desk about this all afternoon.  I have a simple workflow attached to a document library that runs on item creation.  All it does is start the approval process on the current item and emails me and a few other people a task (in parallel).  I have another workflow attached to the document library that runs on modify and it looks to see what the Approval Status of the Current Item is.  If the Approval Status is Approved, the workflow copies the item to another library then deletes the current item.  Same with rejected (only sends it to another library).  Pending does nothing.  I modified the Completed step in the approval workflow to modify the item (to make sure the second workflow triggers)

All that works except, no matter what the Approval Status is alway Approved!  Even when first create the item and run the approval process, the item comes out as approved.  I even explicately set the Approval Status to Pending at the beginning of the first WF, but right after that, the item reverts back to being Approved.  How do I make the item be Pending until everyone has responded to the approval task?  I kinda thought that was the default procedure...

Thanks!


how to get the status of an approval workflow of item using sharepoint object model ?

  

Hi,

There is a list on which an approval workflow is associated,workflow starts when an item is added.The list is having anonymous access so anyone can enter an item,but the item needs to be approved by an approver.Hence,each item will have a status(e.g. approved,rejected etc.).

Now,I am creating a visual webpart.I want to display the list items in a grid.But I need to display only those items which are approved.I am using sharepoint object model,How can I filter the items based on the approval status.

Thanks


Publish a major version after custom approval workflow

  

Hi,

I want to create a custom approval workflow in SharePoint Designer that allows me to use the "Collect Data From a User" action. After data has been collected and if the document has been "approved" I want to publish a Major Version of the document. Until that point I want the document to be in draft. The whole idea is that certain users cannot see the document until it has been approved.

How do I manage to publish a major version of a document after completion of the custom SPD workflow? There doesn't seem to be an action that allows me to change the version. Is there a workaround I need to use?

Thanks


SPD Approval Workflow approval status is always approved

  

Hi,


I have started approval process through workflow.The problem here is approval status is always "Approved". but in task list outcome is showing correct data.
How to check whether the item is approved or rejected in SPD? any samples? Kindly advice.

I checked the following link. No help.

http://stackoverflow.com/questions/1964596/sharepoint-designer-2010-how-to-get-workflow-status

Thanks.


Missing Worklfow Status Column

  

I have a workflow running against a custom list and it is working pretty fine but I can't see the the column that is associated with the existing workflow, usually a list has a column containing the name of the workflow and this particular column register the current status value like "In Progress"

 

I removed the workflow, and attached again to the list but no columns were creaated, them I removed again the workflow and removed all the data from the list and I removed all items form the recycle bin before re-attaching the workflow and creating a new instance but I had no lucky in obtaining the status column of my workflow.

 

I'm really frustrated because I can't find any means to have this column on my list and I just want to find a way to have the status of the workflow being published to my list like any other workfow usually does.

 

 


SharePoint Designer: Set content approval status

  

Hi,

 

I have a Document Library with the following Versionning Settings:
- Require content approval for submitted items: yes
- Require documents to be checked out before they can be edited=No

 

When a new file is created in the Doc. Library a workflow designed by SharePoint Designer is started.
The only action is Set content approval status to Approved with comments.

 

The workflow stopped and in the History section I have:
     Event Type = Error
     User Id = System Account
     Description = Error updating a list item
     Outcome = Document checked out

 

Why the document is checked out and why the System account, which has Full Control can't execute the action?


Calculate a Field Based on Approval Status

  

I have a list that coordinates purchasing approval and tracks our budget.  Someone submited a new item to the list with Estimated Cost, Vendor, Description, etc.  When a new item is submitted, it triggers a workflow that sends it to me as the purchasing approver.  I approve the task and it noties everyone and puts the Approval colum as Approved.  This is all out of the box functioning.  I don't have designer on our network yet (working on it).

What I want to do now is create a column that checks the approval status and if it's approved puts the estimated cost in the column, if it's not approved, it puts 0.  This way I can sum that column to track the expenditures of only approved purchases and ignore the ones I disapproved.  This will allow me to have an accurate picture of how much money we have without having to totally delete a purchase request out of the list.

I've tried using the calulcated field for a new column but it doesn't like having to look at approval status.  I've tried it as both text and integer.  IE "=IF([Approval Status]='Approved',[Estimated Cost],0)" as well as "=IF([Approval Status]=16,[Estimated Cost],0)" as 16 is the number in datasheet view for approval.  Neither of them works as it doesn't like the approval status column use in general.


How to hide approval status field?

  

Hi all

I have created a custom list in sharepoint 2007.

In dispform.aspx I get to see the "approval status", which I want to hide. I can not find it if I open the SharePoint designer, or in the site columns.
How can this field be hidden?


Categories: 
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