Solved

SharePoint 2007 Workflow with Link to Documents on Encrypted Network Share Drive

Posted on 2013-01-16
2
330 Views
Last Modified: 2013-01-31
Looking to see if someone has done something similar to this and if so can provide some insight on how you went about doing it (did you use SP Designer, did you use a list, if so what kind, etc.).

The desired outcome: Create a workflow in SharePoint (likely using SP Designer) that is used to notify reviewers/approvers (possibly via an MS Outlook email) that documents have been saved to a network drive are ready for review. The reviewer/approver would review and either approve or reject (within the SP workflow) the documents (so there would have to be something within each workflow that identifies exactly which documents that workflow pertains to as this information needs to be maintained for audit purposes).

Ideally the workflow would have a hyperink to the network drive where the documents will be stored. SharePoint would basically be used for the notification and approval/rejection pieces (the documents cannot be routed and stored via/on SharePoint for various reasons pertaining to the content in the documents and per direction from IT).

Some options, insights (if you've completed a similar workflow), etc. would be appreciated.

I am site admin/have full control and also have SP Designer (2007).

Thanks!!
0
Comment
Question by:lessthan2
2 Comments
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 500 total points
ID: 38786706
Hi,
sorry have not done this exactly before, but I just want to share my 2ct.

1. Create a list where the document information is stored (e.g. file name. folder path, other meta data,...)
2. The person who saves a document to the network share has to create the related list item
3. After the list item has been created, a standard SharePoint approval workflow will run.
The link to the document itself has to be generated partially hard coded in the mail  (only sub folder path and filename are from the list item)

If you want to automate it a little bit more, then you my think of a tool/program written in .NET to implement a file system watcher, which will then either generate or update the list items accordingly. But this approach would need some more planning / design, e.g. the program must run with a user account who has permissions to all folders...

HTH
Rainer
0
 

Author Comment

by:lessthan2
ID: 38841645
I will accept the above as a solution because I think it could be a solution if I wanted (and could) take this to a different level.

However, this is what I've tested so far and will likely be the immediate solution.
Created a simple list with the following columns: description, check boxes with the report names that are to be saved to the network drive, and a comments box). Created a workflow in SPD and in the body of the email notification, I added the path to the network drive. Now, at this point the user receives two emails because of the email notification that I added plus there is the one created by the task in SP. I still need to look into having only one email sent but I think this will be a viable solution. For the interim, I added the url to a network path that I have access to but we still need to test the path that IT will provide which will be to a secure network drive that only the individuals who are involved with this workflow will have access to. I don't foresee that being an issue.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
MS Outlook is a world-class email client application that is mainly used for e-communication globally.  In this article, we will discuss the basic idea about MS Outlook, its advanced features, and types of MS Outlook File formats.
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question