Forums for the Business Analyst

 
  Modern Analyst Forums  Business and Sy...  Business Proces...  Document Storage Solution
Previous Previous
 
Next Next
New Post 8/16/2021 2:18 AM
Resolved
User is offline EvdB
3 posts
No Ranking


Document Storage Solution 

Good day,

Hope everyone is well.  I need some advice on the below and hope someone will be able to guide me in the right direction.

We need a document store solution for an approval framework, the idea being it will be the single source of the truth in terms of what documents business has approved . Currently the doc sits on Sharepoint. 

 

The issue is we can't control read or write access to it.

 

Anyone encountered this before - how do we store this and control who can view and who can edit it? 

 

Thank you and have a great day!

 

 

 
New Post 8/17/2021 5:22 AM
User is offline Stewart F
119 posts
7th Level Poster


Re: Document Storage Solution 

Hi EvdB, Correct me if I am wrong, but what youa re saying is that you have some documents. Some have been approved by the Business, some have not. Currently they sit in a Sharepoint site (presumably all mixed together?).

What you want is to some how distinguish between the two, with maybe the 'Approved' Docs sitting in one place, and the 'Not Approved. sitting elsewhere. Is that correct?

I think the bit that is confussuing is that one the one hand you say you have many docs and require a Document Storage solution (I would assume to clearly show the difference betwen those Docs that are approved and those that are not) and then mention "Currently the doc [singular]...". 

So my first question is this - are we talking one document or many documents? Do they all have the same edit restrictions (no acces to Read & Write) or just the one? 

Sharepoint allows you to have a folder system and shilst Sharepoint as a whole is not my favourite place to put documents, it does have its advantages. Can you place the documents apporived into a new "Approved" folder or is that what you don't have access to?

Push comes to shove I would say create a folder called "Approved", and place approved Docs in there. IN each document, if you have a Version History section, show a line saying when it was approved and by whom. If you use Sharepoint, and approval has come via email, then maybe store the approvals in a sub folder. You don;t have to, but it may be useful later on - someone always asks about a year later "Who approved this...?"

If you send the answers to my questions above then I am sure I can sort something for you.  

 
New Post 8/17/2021 5:22 AM
User is offline Stewart F
119 posts
7th Level Poster


Re: Document Storage Solution 

Hi EvdB, Correct me if I am wrong, but what youa re saying is that you have some documents. Some have been approved by the Business, some have not. Currently they sit in a Sharepoint site (presumably all mixed together?).

What you want is to some how distinguish between the two, with maybe the 'Approved' Docs sitting in one place, and the 'Not Approved. sitting elsewhere. Is that correct?

I think the bit that is confussuing is that one the one hand you say you have many docs and require a Document Storage solution (I would assume to clearly show the difference betwen those Docs that are approved and those that are not) and then mention "Currently the doc [singular]...". 

So my first question is this - are we talking one document or many documents? Do they all have the same edit restrictions (no acces to Read & Write) or just the one? 

Sharepoint allows you to have a folder system and shilst Sharepoint as a whole is not my favourite place to put documents, it does have its advantages. Can you place the documents apporived into a new "Approved" folder or is that what you don't have access to?

Push comes to shove I would say create a folder called "Approved", and place approved Docs in there. IN each document, if you have a Version History section, show a line saying when it was approved and by whom. If you use Sharepoint, and approval has come via email, then maybe store the approvals in a sub folder. You don;t have to, but it may be useful later on - someone always asks about a year later "Who approved this...?"

If you send the answers to my questions above then I am sure I can sort something for you.  

 
New Post 8/17/2021 6:25 AM
User is offline EvdB
3 posts
No Ranking


Re: Document Storage Solution 

Hi Stewart F,

Thanks for the quick reply.  Sorry if I was vague in my question!

Let me clarify:

We have ONE document (Excel) on Sharepoint, being accessed by a lot of users.  However, the different users should have different access "levels" to the same document - some should have Read-only permissions while others should have both Read and Write permissions.

Hope this makes more sense.

Thank you!

 

 

 
New Post 8/17/2021 12:18 PM
User is offline Stewart F
119 posts
7th Level Poster


Re: Document Storage Solution 

Hi EvdB, 

So there are two ways to do this:

1. Set the permissions on the Excel spreadsheet itself

2. Set permissions in Sharepoint.

If I start with the second option - it depends on what version of Sharepoint you are running. As it is a company wide version, I am guessing it may be Sharepoint Server. If this is the case then it has useful defaults values within it. However, by setting these permissions in Sharepoint - you set them for ALL documents in Sharepoint, not just your Excel spreadsheet. so this may not be the best option. However, just so you know what those permissions are see this site:

https://docs.microsoft.com/en-us/sharepoint/sites/user-permissions-and-permission-levels#:~:text=Default%20permission%20levels%20%20%20%20Permission%20level,%20All%20permissions%20%203%20more%20rows%20

If it isn't quite the version of Sharepoint you have, just google the relevant version. There are plenty of help topics out there.

For the first option, you set the permissions in Excel itself. Again, just Google "Setting Excel permissions". There are plenty of helpful videos on YouTube. Again, it depends slightly on what version of Excel you have. 

This should answer your query, but come back if you can't find a suitable answer online. I have had similar queries in the past, so I know the answers are there.  

 

 

 
Previous Previous
 
Next Next
  Modern Analyst Forums  Business and Sy...  Business Proces...  Document Storage Solution

Community Blog - Latest Posts

The CEO/CIO's Guide to Architecting AI: Vision to Value in Minutes Introduction to Architected AI Artificial intelligence (AI) is becoming part of our life at an unprecedented pace. As CEOs and CIOs grapple with how to leverage this powerful technology to drive strategy and enhance operations, the concept of Architected AI becomes importa...
In today's dynamic business environment, mastering effective business analysis techniques is crucial for organizations aiming to achieve sustainable growth and competitive advantage. Business analysis involves the systematic evaluation of business processes, requirements, and strategies to uncover insights that drive informed decision-making. T...
For many years now, a lot of people have found it difficult to identify the difference between Sankey diagrams and parallel sets. The two have made headlines, given that most people find it challenging to note what makes them different from each other. What remains to be undeniable is the fact that the Sankey diagram is among the top data visualiza...

 






 

Copyright 2006-2024 by Modern Analyst Media LLC