http://www.endusersharepoint.com/STP/ SharePoint QA en Sun, 24 May 2009 01:25:50 +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-6959 Fri, 22 May 2009 03:00:13 +0000 dwinter 6959@http://www.endusersharepoint.com/STP/ <p>That would create orphans if you forced it to happen, which would make it so that you could not delete the children. That is why this is not something you can accomplish.</p> <p>The preferred method is to delete 'bottoms-up', and if you can do that in a lazy fashion, even better. </p> http://www.endusersharepoint.com/STP/topic/workflow-email-to-more-than-one-approver-lacks-headers#post-6947 Fri, 22 May 2009 02:32:36 +0000 dwinter 6947@http://www.endusersharepoint.com/STP/ <p>What is the structure of your outbound email setup? Are you configured to a local relay or do you go directly to your corporate email infrastructure? </p> <p>Can you configure a local relay, set up a test workflow to send a message, trap it in a aliased local drop folder, and then take a look at that header? I find it unlikely that the mail we are generating has truncated headers like that. </p> http://www.endusersharepoint.com/STP/topic/wiki-library-folders#post-6926 Thu, 21 May 2009 16:59:48 +0000 mrbun 6926@http://www.endusersharepoint.com/STP/ <p>I agree with comment from AutoSponge, it's the View that matters, not the list size. To improve performance to impatient end users I have had some success filtering the content of lists down to a few 100, thus improving speed of delivery. BTW, I removed the view all option to prevent users crashing the system.</p> <p>With 10000 in sql I would definitely be looking at BDC, and preserve the excellent db data.</p> <p>Could always try to push the data into Access 2007 and then upload it into sharepoint lists, and filter those.</p> <p>Mike B </p> http://www.endusersharepoint.com/STP/topic/prevent-a-user-from-running-a-workflow-twice#post-6822 Tue, 19 May 2009 15:28:23 +0000 Toni 6822@http://www.endusersharepoint.com/STP/ <p>I would love to see it, can you email me some screens at toni.frankola_at_gmail.com? </p> http://www.endusersharepoint.com/STP/topic/prevent-a-user-from-running-a-workflow-twice#post-6821 Tue, 19 May 2009 15:20:40 +0000 Mr Rough 6821@http://www.endusersharepoint.com/STP/ <p>Not sure why I didn't think of that. Anyway, that worked fine. Thank you </p> http://www.endusersharepoint.com/STP/topic/prevent-a-user-from-running-a-workflow-twice#post-6820 Tue, 19 May 2009 14:07:41 +0000 Toni 6820@http://www.endusersharepoint.com/STP/ <p>I would create additional list with the following columns: User, Idea ID, Direction (UpVote/DownVote) to track if user already voted. </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-6765 Mon, 18 May 2009 10:50:57 +0000 laura67 6765@http://www.endusersharepoint.com/STP/ <p>Lain,<br /> Please type in your workflows conditions &#38; actions for us, so that we can tell you where it's going wrong and why it's looping. Also, note that once you install service pack 2, this looping problem will supposedly go away. </p> http://www.endusersharepoint.com/STP/topic/i-always-have-this-problem-laura-can-you-help#post-6759 Mon, 18 May 2009 08:48:44 +0000 eric 6759@http://www.endusersharepoint.com/STP/ <p>That usually points to bad logic or not unique lookups. I've spammed myself hundreds of times buildng and testing workflows.</p> <p>Also what you can do is when a new item is created, set a workflow variable that is 5 days from the current date. next step, pause until that date, then do something.</p> <p>Paul's idea of batching looks interesting </p> http://www.endusersharepoint.com/STP/topic/routing-using-database-information#post-6756 Mon, 18 May 2009 03:36:30 +0000 erugalatha 6756@http://www.endusersharepoint.com/STP/ <p>Sean, I have done this but not using database tables - in a Custom VS solution I look up to a Configuration List in SharePoint to get my routing information. I use CAML queries to get that routing information. This way everything is managed within SharePoint. I guess you could do it in SQL table also if you wanted to.</p> <p>The workflow part is not easy but it is doable in Visual Studio. I didn't attempt to do it in SPD because SPD still has too many rough edges for me.</p> <p>As Toni mentions you will use Content Types (if you use VS way) ... more than one if you want custom Task editing pages.</p> <p>If you decide to go the VS route then check out the Headcount Request article on MSDN before you start. It will give you a fair idea of the amount of work involved. Here is the link: <a href="http://msdn.microsoft.com/en-us/library/cc811589.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/cc811589.aspx</a></p> <p>This sample does not contain lookup for routing but if you're stuck with that part post back. All it entails is a custom class addition that queries a SharePoint list. </p> http://www.endusersharepoint.com/STP/topic/i-always-have-this-problem-laura-can-you-help#post-6754 Sun, 17 May 2009 18:21:12 +0000 AutoSponge 6754@http://www.endusersharepoint.com/STP/ <p>Think of it as a state control list. You're going to record the item and the state. Then you have to trigger the state check nightly. That part may need a Visual Studio workflow, honestly.</p> <p>Another option is to look into Information Management Policies. You can see if it will trigger a reminder at create date + 5 (IMP workflow already runs daily). </p> http://www.endusersharepoint.com/STP/topic/routing-using-database-information#post-6753 Sun, 17 May 2009 17:24:18 +0000 Toni 6753@http://www.endusersharepoint.com/STP/ <p>Well I would suggest building a custom VS workflow and attaching it to a content type. This content type and workflow should be then used across your sites.</p> <p>SPD workflows cannot be attached to content types and do not support what you need OOTB.</p> <p>I do not know of 3rd party solution that works with content types. </p> http://www.endusersharepoint.com/STP/topic/i-always-have-this-problem-laura-can-you-help#post-6752 Sun, 17 May 2009 13:19:34 +0000 ihmunro 6752@http://www.endusersharepoint.com/STP/ <p>Hi Paul</p> <p>Thanks for pointing me in the right direction. I have searched STP as well as the web but cannot find anything relating to a holding list.</p> <p>It is possible to give me some further guidance?</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/i-always-have-this-problem-laura-can-you-help#post-6750 Sat, 16 May 2009 23:23:52 +0000 AutoSponge 6750@http://www.endusersharepoint.com/STP/ <p>IMHO you're better off using the workflow to immediately send the date + 5 days to a holding list. Every night, you run a workflow (or better a batch job) to check the holding list for any dates = today. If there are entries, the batch checks the referred item (by a lookup column or link) and sends/triggers the email. </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/alerts-and-content-approval#post-6656 Thu, 14 May 2009 09:39:37 +0000 candyro 6656@http://www.endusersharepoint.com/STP/ <p>Thanks - unfortunately, still trying to get permission to use SPD. </p> http://www.endusersharepoint.com/STP/topic/advice-on-initial-structure-for-workflow-purposes#post-6651 Thu, 14 May 2009 07:34:45 +0000 pagalvin 6651@http://www.endusersharepoint.com/STP/ <p>Thanks for the kind words :)</p> <p>I have used the core search results before and written about it a few times:</p> <p><a href="http://paulgalvin.spaces.live.com/blog/cns" rel="nofollow">http://paulgalvin.spaces.live.com/blog/cns</a>!1CC1EDB3DAA9B8AA!251.entry<br /> <a href="http://blogs.conchango.com/paulgalvin/archive/2008/03/11/walk-through-use-people-search-for-department-contacts.aspx" rel="nofollow">http://blogs.conchango.com/paulgalvin/archive/2008/03/11/walk-through-use-people-search-for-department-contacts.aspx</a></p> <p>I'm definitely interested in doing a screen cast. I may try and do it this weekend. I've added it to my list.</p> <p>(If you can't tell, I'm trying to re-introduce myself to the EUSP community both here in the forums and regular contributions to the main page :) ) </p> http://www.endusersharepoint.com/STP/topic/advice-on-initial-structure-for-workflow-purposes#post-6647 Thu, 14 May 2009 00:09:07 +0000 laura67 6647@http://www.endusersharepoint.com/STP/ <p>Paul,<br /> You've mentioned this "core search results" web part idea several times. I tried it once, and couldn't get it to work. Sounds very cool.</p> <p>Do you think you could do a little screencast or some step-by-step instructions, or point me to some?</p> <p>You ROCK, by the way, and it was great meeting you at the Best Practices conference.</p> <p>Laura Rogers<br /> <a href="http://spinsiders.com" rel="nofollow">http://spinsiders.com</a> </p> http://www.endusersharepoint.com/STP/topic/advice-on-initial-structure-for-workflow-purposes#post-6640 Wed, 13 May 2009 20:21:51 +0000 pagalvin 6640@http://www.endusersharepoint.com/STP/ <p>I can think of a few ways to do that using search, but it's not so good with WSS. Assuming MOSS, you could have the one site collection with the master library of suspension letters. Use a content type as planned and enable item level security in that library.</p> <p>When creating a letter, the author specifically specifies who is supposed to be able to view it. This is an extra administrative step and that could be a problem.</p> <p>Each individual school site collection has a core search results web part with a fixed keyword query that searches on that content type. Search is security trimmed, so the result will be that each school sees only what it's supposed to see.</p> <p>If you want individual schools to be able to create/edit/delete suspension letters, just give them access to the master library.</p> <p>I don't want to push search too far. A DVWP is great too. </p> http://www.endusersharepoint.com/STP/topic/advice-on-initial-structure-for-workflow-purposes#post-6620 Wed, 13 May 2009 15:05:32 +0000 tobrien 6620@http://www.endusersharepoint.com/STP/ <p>We have 18 schools. Student suspension letters are issued by the schools - we want all suspension letters available to our Superintendents (not in folders), but each school should only be able to view their own. Our first thoght was to have a centralized library that held all of the letters, while each school would have a filtered data view of that library - but with the ability to create a new letter (it will be a content type)from that data view. Once I create a filtered data view in WSS3, the ability to create New disappears, though. Thanks for your help! </p> http://www.endusersharepoint.com/STP/topic/sharepoint-workflow#post-6618 Wed, 13 May 2009 14:45:34 +0000 pagalvin 6618@http://www.endusersharepoint.com/STP/ <p>There is an stsadm command that may be useful in this case. stsadm is a command line program that runs on the server. You can read about it here: <a href="http://technet.microsoft.com/en-us/library/cc261956.aspx" rel="nofollow">http://technet.microsoft.com/en-us/library/cc261956.aspx</a></p> <p>I have the "migrateuser" command in mind.</p> <p>Depending on how this change was done in AD, it may solve the problem for you. I don't recommend doing it without some kind of test first, though. </p>