Forum Discussion

amydharrelson's avatar
amydharrelson
Copper Contributor
May 15, 2018

SharePoint 2013 Relationship Possibilities - Need Resource

Hi All,   I am wondering where I can find information to prove a theory that SP2013 does not support a many to one relationship the way ECM tools do (I understand that SP can handle the one to many ...
2013
files
Sites
jcgonzalezmartin's avatar
jcgonzalezmartin
MVP
May 15, 2018
And to be clear, SharePoint is not a relational system :-)...as Dean says, SharePoint is flexible enough to be extended so you can implement what you need but you must be aware of out-of-the-box features and how the platform is designed
amydharrelson's avatar
amydharrelson
Copper Contributor
May 15, 2018

All here are a few more known details

  • SP2013 out of the box does not support filing documents under multiple folders, the only option is to create a one to many relationship using document metadata to replace the folder structure. (instead of the many to one approach used in current ECM config)
  • To do this filing structure has to be flat, in a single repository
  • Predefining a relationship hierarchy would restrict users from creating ad-hoc relationships like they do in present workflow (folder/sub folder would then be impossible)
  • Custom views and creation would need to occur
  • Data mapping to ensure correct migration must happen
  • Modification of current workflow/ operational process would be exxpected

We know this much could probably be done..  With that said, there are a list of concerns

  • Process can't be migrated to be as simple and customer will have less freedom on document tagging  (perceived)
  • Worry about in ability to correctly reflect tagging and relationships in the system views, and propagate changes throughout multiple views.
  • Potential with new forced process to create confusion and higher % of misfiles

Biggest factor is customer adoption, if the look and feel, and added stress is there and the product does not offer mailability adoption will not happen and the project would be a failure.

 

How do we address the concerns?  It seems like we can force with a lot of work something that will meet the need but possibly negatively impact the user.

 

Any assistance is appreciated.