http://www.endusersharepoint.com/STP/ SharePoint QA en Sun, 24 May 2009 07:06:46 +0000 http://www.endusersharepoint.com/STP/topic/workflow-stuck-on-starting-status-2#post-6989 Fri, 22 May 2009 16:57:32 +0000 shalinparmar 6989@http://www.endusersharepoint.com/STP/ <p>Hi,</p> <p>All of a sudden workflow working fine since yesterday, are getting stuck in 'Starting' state and not getting started at all. These are SPD workflow and are working fine. I thought it could be the Pause for duration activity issue, so I created a new workflow without that activity still the new one is also getting stuck......</p> <p>What could be the issue here? </p> http://www.endusersharepoint.com/STP/topic/workflow-stuck-on-starting-status-1#post-6988 Fri, 22 May 2009 16:56:28 +0000 shalinparmar 6988@http://www.endusersharepoint.com/STP/ <p>Hi,</p> <p>All of a sudden workflow working fine since yesterday, are getting stuck in 'Starting' state and not getting started at all. These are SPD workflow and are working fine. I thought it could be the Pause for duration activity issue, so I created a new workflow without that activity still the new one is also getting stuck......</p> <p>What could be the issue here? </p> http://www.endusersharepoint.com/STP/topic/workflow-stuck-on-starting-status#post-6987 Fri, 22 May 2009 16:55:28 +0000 shalinparmar 6987@http://www.endusersharepoint.com/STP/ <p>Hi,</p> <p>All of a sudden workflow working fine since yesterday, are getting stuck in 'Starting' state and not getting started at all. These are SPD workflow and are working fine. I thought it could be the Pause for duration activity issue, so I created a new workflow without that activity still the new one is also getting stuck......</p> <p>What could be the issue here? </p> http://www.endusersharepoint.com/STP/topic/delete-multiple-items-from-list#post-2046 Fri, 24 Oct 2008 11:13:45 +0000 erugalatha 2046@http://www.endusersharepoint.com/STP/ <p>Hi,</p> <p>In a workflow it does not seem to be possible to delete multiple items (e.g. if deleted parent then delete all child items related to parent).</p> <p>Anyone know of a way to accomplish it? </p> http://www.endusersharepoint.com/STP/topic/workflow-email-to-more-than-one-approver-lacks-headers#post-539 Tue, 05 Aug 2008 17:13:00 +0000 GeorgeWNYC 539@http://www.endusersharepoint.com/STP/ <p>OK This is an issue with Workflows with more than one person as an approver.</p> <p>The outgoing email message is missing headers, so it comes through 'un-formatted'.</p> <p>Have you every seen this?</p> <p>----- Original Message -----<br /> From: &lt;[email protected]&gt;<br /> To: &lt;[email protected]&gt;<br /> Sent: Tuesday, August 05, 2008 4:53 PM</p> <p>&gt;:<br /> &gt; Content-Transfer-Encoding: 8bit<br /> &gt; Content-Type: text/html; charset=utf-8<br /> &gt; Subject: Approval started on _directory_.<br /> &gt; MIME-Version: 1.0<br /> &gt; X-Mailer: Windows SharePoint Services (version 3)<br /> &gt;<br /> &gt; &lt;style&gt;<br /> &gt; TABLE.mail { border-style:none; border-collapse:collapse; font:8pt Tahoma; width:100%; }TD.header { background:#F8F8F9; border:1px solid #E8EAEC; padding:12pt 10px 4pt 10px; }TD.body { padding:12pt 10px 24pt 10px; }TD.footer { border-width:1px; border-style:solid none none none; border-color:#9CA3AD; padding:4pt 10px 4pt 10px; }A { text-decoration:none; }DIV.title { font:16pt Verdana; }DIV.headertext { margin:5px 0px 0px 0px; }DIV.error { font-weight:bold; }DIV.comment { color:#9CA3AD; }SPAN.wfname { font:bold italic; }<br /> &gt; &lt;/style&gt;&lt;table cellpadding="2" cellspacing="0" class="mail" DIR="none"&gt;<br /> &gt; &lt;tr class="header"&gt;<br /> &gt; &lt;td class="header"&gt;&lt;div class="title"&gt;<br /> &gt; &lt;span class='wfname'&gt;Approval&lt;/span&gt; has started on <a href='http://amportal.MyCompany.com/IT/Shared Documents/_directory_.aspx'>_directory_</a>.<br /> &gt; &lt;/div&gt;&lt;div class="headertext"&gt;<br /> &gt; Participants are George Winters<br /> &gt; &lt;/div&gt;&lt;/td&gt;<br /> &gt; &lt;/tr&gt;&lt;tr class="body"&gt;<br /> &gt; &lt;td class="body" valign="top"&gt;&lt;div&gt;<br /> &gt; Each person will receive a task to approve <a href='http://amportal.MyCompany.com/IT/Shared Documents/_directory_.aspx'>_directory_</a>. The tasks will be assigned one at a time in the order shown above.<br /> &gt; &lt;/div&gt;&lt;/td&gt;<br /> &gt; &lt;/tr&gt;&lt;tr class="footer"&gt;<br /> &gt; &lt;td class="footer"&gt;&lt;div&gt;<br /> &gt; <a href="http://amportal.MyCompany.com/IT/_layouts/WrkStat.aspx?List={70b24df8-1c4d-4065-aa98-aa3af78422ec}&amp;WorkflowInstanceID={5ac9e05f-65f6-4e78-bcfc-72d79f22df23}">View the status of this workflow.</a><br /> &gt; &lt;/div&gt;&lt;/td&gt;<br /> &gt; &lt;/tr&gt;<br /> &gt; &lt;/table&gt;<br /> &gt;<br /> &gt; </p> http://www.endusersharepoint.com/STP/topic/wiki-library-folders#post-1045 Mon, 08 Sep 2008 19:41:28 +0000 deliafrog 1045@http://www.endusersharepoint.com/STP/ <p>#1 This is related to the <a href="http://www.endusersharepoint.com/STP/topic.php?id=62#post-253">Maximum Number of List Items</a> post from last month.</p> <p>The quoted White Paper recommends avoiding performance issues in large lists by using containers/limiting the number of items per container to 2000 items. We want to migrate between 10,000 and 20,000 total records from a SQL database to a SharePoint Wiki. So here is question one (subsequent question will be in second post)</p> <p>1. The predefined browser-based SharePoint wiki library interface does not seem to allow folder creation. Can we create folders in another way within a wiki, so as to remain under the 2000 item limit? If not – what other types of “containers” might we use inside of a wiki library? Would using folders/containers break the wiki functionality within the wiki library, namely wiki-linking? </p> http://www.endusersharepoint.com/STP/topic/prevent-a-user-from-running-a-workflow-twice#post-6818 Tue, 19 May 2009 13:33:52 +0000 Mr Rough 6818@http://www.endusersharepoint.com/STP/ <p>I've put together a discussion board that an employee can post an idea to the company and employees can discuss that idea. I've also created two workflows. One to vote an idea up and another to vote an idea down.</p> <p> Unfortunately that means a user can vote an idea up or down as many times as they want. Is there a way to prevent a user from running workflows more than once on each discussion board posting?</p> <p> Alternatively I could just make you only be able to vote an idea up or down if you add a reply, but would it be possible to restrict one vote per person that way either?</p> <p> Any help is appreciated. Thank you for your time.</p> <p>Kirk </p> http://www.endusersharepoint.com/STP/topic/i-always-have-this-problem-laura-can-you-help#post-6747 Sat, 16 May 2009 19:23:11 +0000 ihmunro 6747@http://www.endusersharepoint.com/STP/ <p>Everytime I add in a workflow, I end up getting hundreds of emails from the workflow.</p> <p>What I am trying to do is wait say 5 days after a new document has been added into the system then start the workflow. The workflow could be anything - say missing info as an example that may not be able to be obtained when the document was created.</p> <p>The workflow will then remind the person to get the info added.</p> <p>It always seems to go into a loop.</p> <p>Any ideas?</p> <p>Iain </p> http://www.endusersharepoint.com/STP/topic/routing-using-database-information#post-6751 Sun, 17 May 2009 09:41:20 +0000 Sean 6751@http://www.endusersharepoint.com/STP/ <p>Hi,</p> <p>I want to create a "single" workflow that can be assigned to many libraries and sites, such that the routing information is derived from a rather complex routing table. </p> <p>Tables are "ProcessesTable" with columns ProcessNo, ProcessName; and "ProcessRedirectionTable" with columns FromProcess, ToProcess.</p> <p>Thing being I might route OneToOne or OneToMany based on the database read of the<br /> ProcessRedirectionTable.</p> <p>Why do it this way - well I have in excess of 500 documents across 15 individuals of various reponsibility etc...</p> <p>Any thoughts, can SPD use a Database Routing Table for example, or s it simply a case of "use VS"...</p> <p>many thanks in advance,<br /> regards<br /> Sean</p> <p>Many thanks </p> http://www.endusersharepoint.com/STP/topic/wss-30-038-sql-database#post-6609 Wed, 13 May 2009 12:04:53 +0000 erugalatha 6609@http://www.endusersharepoint.com/STP/ <p>Hi,</p> <p>In MOSS Enterprise we have BDC to allow us to look out to external datasources from lists. </p> <p>Is there anything available for WSS 3.0 to allow me to expose data from a SQL Database in a SharePoint List? </p> http://www.endusersharepoint.com/STP/topic/alerts-and-content-approval#post-5643 Thu, 02 Apr 2009 19:00:00 +0000 jlschu1 5643@http://www.endusersharepoint.com/STP/ <p>My team has set up a basic knowledgebase in Sharepoint that collects a variety of article items for our Helpdesk team. We have enabled content approval so the submitted items will go into a pending queue until the list admin approves. Once approved we are interested in automating an email to go out alerting the helpdesk team a new item has been added to the KB list. I was thinking I could enable alerts for the team, however it seems the Content Approval and Alerts have no relationship or not dependent on each other. Because when I submitted a new item an alert was sent out to everyone even though the item is pending. I want the alert to be set up to where, when the item is approved the alert is sent out to everyone. Is this possible? Am I missing a setting? We are using basic SP features. I am on Moss 2007.</p> <p>thanks! </p> http://www.endusersharepoint.com/STP/topic/advice-on-initial-structure-for-workflow-purposes#post-6527 Mon, 11 May 2009 17:12:13 +0000 tobrien 6527@http://www.endusersharepoint.com/STP/ <p>We're planning ahead for MOSS 2007. For ease of backup/restore, we want several site collections. New items created in lists in several sub sites within Site Collection 1 need to be copied to(or at elast displayed in) a single list in Site Collection 2. Can this be achieved with a workflow? Or would we be better off to create the new items in Site Collection 1 and simply use some sort of DataView to display the data from all the sub sites in Site Collection 2? We don't have SharePoint yet, so we can't "play" - but knowing the best way to do this would really help us plan our Site Collections. All advice appreciated! </p> http://www.endusersharepoint.com/STP/topic/sharepoint-workflow#post-6528 Mon, 11 May 2009 17:52:40 +0000 kathy.gray 6528@http://www.endusersharepoint.com/STP/ <p>Hello:</p> <p>I created a task workflow with 15 users. After creating the workflow, it was noted that a users name was spelled incorrectly in AD. The user's name was then corrected in AD. The users account name upated on the site access list after completing a profile import, however, the name did not update in the task workflow. The workflow has now been completed by all users, but I cannot close the workflow as the users name is spelled wrong. I need to preseve the workflow history and the user with the mispelled name cannot update the workflow task assigned to him. Would you have any suggestions on how to complete and close this workflow? Any help would be greatly appreciated. Your site has offered me a wealth of information. Much thanks and Kindest Regards, /kathy </p> http://www.endusersharepoint.com/STP/topic/restrict-users-from-submitting-multiple-document-is-a-week#post-6489 Mon, 11 May 2009 02:17:16 +0000 sneha0206 6489@http://www.endusersharepoint.com/STP/ <p>The users should not be able to upload the content/document in following conditions<br /> a) The user should be able to upload documents only till Wednesday (not after that).<br /> b) One user cannot upload more than one document in a week. </p> http://www.endusersharepoint.com/STP/topic/workflow-email-with-link#post-6579 Tue, 12 May 2009 18:06:27 +0000 caryl 6579@http://www.endusersharepoint.com/STP/ <p>My alert workflow, created with Designer 2007, is triggered by a newsly saved form in a SharePoint (MOSS) forms library. The workflow sends an email that picks up data from multiple fields within the newly saved form. The email body also picks up the Encoded Absolute URL of the form. Clicking on this url link in the received email is supposed to open the form for review.</p> <p>Problem: The workflow works fine and the email gets sent with the appropriate data. However, I'm the only one who receives an active link in the email. Others get a non-clickable url.</p> <p>I have Outlook/Office 2007 while most others are using Outlook/Office 2003. Is there some compatibiilty issue with Outlook? Any workaround to getting the active link to everyone? </p> http://www.endusersharepoint.com/STP/topic/can-you-suppress-the-time-from-displaying-in-a-spd-workflow-email#post-6314 Fri, 01 May 2009 15:04:20 +0000 shaase 6314@http://www.endusersharepoint.com/STP/ <p>I have a custom SharePoint Designer workflow that sends an email to users. The email includes current item lookups for a variety of fields from my list--including a Due Date date/time field. </p> <p>Since we suppress the time display for this Due Date field in the SharePoint web interface, the database value for the time is always midnight. I'd prefer not to display the time in my email but keep the date. Is there any way to prevent the time from displaying? </p> http://www.endusersharepoint.com/STP/topic/employee-training-and-scheduling-template-workflow#post-6280 Thu, 30 Apr 2009 14:09:11 +0000 jsmith 6280@http://www.endusersharepoint.com/STP/ <p>I have downloaded the Employee Training and Scheduling Template. I completed the "Employee Training and Scheduling Template - a couple fixes Part 1-3" as posted on:<br /> <a href="htp://www.sharepointblogs.com/dez/archive/2007/09/19/employee-training-and-scheduling-template-a-couple-fixes.aspx" rel="nofollow">htp://www.sharepointblogs.com/dez/archive/2007/09/19/employee-training-and-scheduling-template-a-couple-fixes.aspx</a></p> <p>In my environment supervisors must approve training activity. When a user registers for a course I want the supervisor to be notified so they can approve the registration. Once approved by the supervisor the workflow continues as it works today.</p> <p>Has anyone worked on this or maybe there is something out there to assist me in setting this up?</p> <p>Thank you for your input. </p> http://www.endusersharepoint.com/STP/topic/approval-workflow-question#post-6117 Fri, 24 Apr 2009 10:52:28 +0000 Toekiller 6117@http://www.endusersharepoint.com/STP/ <p>I have a workflow that asks for approval from two people before the workflow can continue. Is it possible to have an approval workflow that can continue if either of the two approvers approves the request? </p> http://www.endusersharepoint.com/STP/topic/preview-data-collected-from-a-user#post-6254 Wed, 29 Apr 2009 14:29:18 +0000 jbhoward 6254@http://www.endusersharepoint.com/STP/ <p><strong>Set-up</strong><br /> I've created a custom list that fires a Workflow on New.</p> <p>The Workflow uses the <strong>Collect Data from a User</strong> action. The ListItemID of the collected data (an Item in a Tasks List) is stored in the Custom list</p> <p><strong>Goal</strong><br /> On the DispForm of the custom list item, I want to show a preview pane of the data collected (in a Tasks list) by the user. The person view the custom list won't necessarily be able to edit the Task.</p> <p>Conversely, if the Task DispForm could show the original list item that created it, that would be great, too.</p> <p><strong>Next...</strong><br /> Assuming all of that is doable somehow, depending on how the first data collection goes, a second one <em>may</em> also be initiated. Showing all three pieces of this puzzle on one page (from any of the three DispForm pages) would be a huge win! </p> http://www.endusersharepoint.com/STP/topic/error-on-manual-workflow-start#post-6206 Tue, 28 Apr 2009 14:43:56 +0000 Bismarck 6206@http://www.endusersharepoint.com/STP/ <p>I have an SPD workflow created on a form Library. When I attempt to manually start the workflow on a form I get presented with: </p> <p>"Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Windows SharePoint Services-compatible HTML editor such as Microsoft Office SharePoint Designer. If the problem persists, contact your Web server administrator."</p> <p>Automatic start on Create or Edit works fine...</p> <p>How can I troublshoot this error? </p> http://www.endusersharepoint.com/STP/topic/workflows#post-6169 Mon, 27 Apr 2009 17:02:01 +0000 RUANAPE 6169@http://www.endusersharepoint.com/STP/ <p>Has anyone needed to use a workflow across site collections. I have a list, and if someone changes a field, I want a workflow to trigger and move the ticket over to another list on another site in a different site collection. I hope that makes sense, if not, please ask questions, I really need to work this out. Thanks for any info ahead of time! </p> http://www.endusersharepoint.com/STP/topic/spd-stopping-a-workflow#post-3194 Wed, 31 Dec 2008 12:24:10 +0000 cepes 3194@http://www.endusersharepoint.com/STP/ <p>Hi:<br /> I am doing bulk importing of data into a List and I have several WF's that are triggered when new items are added. </p> <p>Is there a way to go into SharePoint Designer and put a temporary pause (or suspense) on a workflow until the import is done?</p> <p>Thanks- </p> http://www.endusersharepoint.com/STP/topic/how-to-create-an-spd-workflow-for-blog-comment-notification#post-6048 Wed, 22 Apr 2009 10:03:21 +0000 NancyCentury 6048@http://www.endusersharepoint.com/STP/ <p>I want to create an SPD workflow that will send an email to anyone whose SharePoint blog post was commented on. So far everything I have tried is not working. </p> <p>It was my assumption that a comment on a post is a type of "change," so I have my WF set to run every time an item (the original post) is changed. Again- I assumed that every new comment = a change to the original item. </p> <p>The first action is to send an email to the person who created the original post, and body of the email contains a link to the post itself. I also have "Comment made by: [%modified by%]" included, assuming that this would add in the commenter's name since he/she was the person who "changed" the original item.</p> <p>However- it's not working! </p> <p>Any advice on what I SHOULD be doing? Thanks! </p> http://www.endusersharepoint.com/STP/topic/spd-connect-to-sp-site-as#post-5835 Mon, 13 Apr 2009 17:48:09 +0000 dschmidt 5835@http://www.endusersharepoint.com/STP/ <p>I login to my workstation and use SP Designer to create workflows in MOSS 2007. While I have several accounts at my disposal, including our SP System Account, I cannot change the windows login process. I wish to have SPD connect to the SharePoint site as the System Account (so that workflows will be saved under that account, rather than my user account), but it seems determined to connect using my local account. Is there a way to get SPD to connect to a SP Site using credentials other than my windows logon?</p> <p>Here is why I am trying to do this:<br /> <a href="http://blogs.technet.com/victorbutuza/archive/2009/03/14/workflows-do-not-start.aspx" rel="nofollow">http://blogs.technet.com/victorbutuza/archive/2009/03/14/workflows-do-not-start.aspx</a> </p> http://www.endusersharepoint.com/STP/topic/workflow-failing-when-trying-to-calculate-next-item-id#post-5715 Mon, 06 Apr 2009 12:07:10 +0000 NancyCentury 5715@http://www.endusersharepoint.com/STP/ <p>I have a workflow that keeps crashing at the same spot and I can't figure out why. </p> <p>I inserted "log to workflow history" after every single action and it looks like the "Calculate..." action is the culprit. Please help!<br /> _______________</p> <p>My list called "Process Steps" is a series of steps that must run in order each month. Every list item begins with a default status of "Not Started." </p> <p>Changing the status to "In Progress" or "Completed" triggers other workflows which are set to automatically run when an item is changed, with conditions to make sure it fires on the right items.</p> <p><strong>Workflow 1</strong> is a manual intitation whose purpose is to kick off the process for the month, and will only ever run on the first step (the "Kick off" step). Let's say the ID of the Kick Off step is 100. This WF also contains a variable called "ID number of next step". </p> <p>To produce the value for this variable, I have this action:</p> <p>then Calculate Process Steps:ID plus 1 (Output to Variable: ID number of next step)</p> <p>So- since the ID of Step 1 is 100, the result I am looking for is the value 101. </p> <p>I need this value to be available later in Workflow 1 to use in the "Update item in ___ list" action, where I tell the item whose ID matches my variable (the next consecutive step ID, 101 in this case) to update its status to "In Progress." </p> <p><em>That</em> status update triggers a second workflow designed to run when an item changes, that then fires off its own set of actions, one of which calculates the ID of the next item, and so on and so on, so that each time a step's status is changed from In Progress to Completed, the next consecutive step is initiated by calculating the next consecutive ID number and updating the matching list item's status.</p> <p>The step that keeps failing is the very first Calculate step in Workflow 1. Is it not possible for a value produced by the 'Calculate...' workflow action to be used as a list ID variable? </p> <p>Is there a better way to make sure my steps are firing in order? </p>