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

Fabricio Laguna talks Business Analysis and AI
I recently connected with Fabricio Laguna, aka The Brazilian BA. Fabricio is a passionate and pioneering business analyst from Brazil. During our conversation, we had a thought-provoking discussion on how artificial intelligence stands to shape the field of business analysis in the years ahead. While AI promises to transform many aspects of busines...
Business Architecture, Ontology and More with Terry Roach
It's been a privilege meeting Terry Roach, a visionary in the field of enterprise architecture and business architecture. Terry's insights into the evolution of business models, the importance of ontology in architecture, and the potential of AI to shape our future were not only thought-provoking but also a reflection of his extensive exper...
Today I had the pleasure of chatting to Jignesh Jamnadas, Chief Operations Officer at Mosaic, about his Blueprints for Success. As a Senior Finance and Operations Executive, Jigs (as he is known to many) has a holistic understanding of all facets of business and a flair for managing both people and processes. Having worked with Jigs, I was struc...

 



Upcoming Live Webinars




 

Copyright 2006-2024 by Modern Analyst Media LLC