http://www.endusersharepoint.com/STP/ SharePoint QA en Thu, 21 May 2009 14:31:39 +0000 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/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/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>