Solved

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

Posted on 2013-01-16
2
307 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

These days socially coordinated efforts have turned into a critical requirement for enterprises.
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.
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: …

743 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now