Solved

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

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Resolve DNS query failed errors for Exchange
Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…

910 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

20 Experts available now in Live!

Get 1:1 Help Now