SharePoint 2013; Creating a document set based on a library column

Document sets are different now.  How to create a "library" view of documents in different libraries, using a value in the other site libraries?

For example: Library A is for documents of type A, one document per person.  Library B is for documents of Type B, one document per person.  Document in A and B have a column with a unique identifier for the person.

Now create a library for the person the presents documents from both Library A and Library B?
VirtualKansasAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Nuno RogadoCommented:
Hi,

I think you are missing View and Library concepts.

One View is only for one Library.

What you are requesting is not available OOTB (out of the box).

You can use scopes and search to search.
Or you can develop a search web part to do a custom search on those specific libraries.

I hope this can help you.

Best Regards,
Nuno Rogado
0
VirtualKansasAuthor Commented:
OK, eliminate the word "view" and assume we would look outside the box; what's a reliable way to aggregate documents from two libraries to one, based in a common list field?  

Library A and Libary B each have a document type, but also each has a common list field number i.e. Document 001.  Later in document life, we want a new document Library for all documents of any type that have field value of 001.  How to do, with some automation?
0
Nuno RogadoCommented:
Hi,

For your first Question please read this article:
https://web.archive.org/web/20120401233117/http://www.sptechweb.com/content/article.aspx?ArticleID=35702 

For second question you can use: PowerShell, Workflows, 3rd Party Tools or a custom Timer Job.

Best Regards,
Nuno Rogado
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

VirtualKansasAuthor Commented:
The web link is a bit dated.  We're O365/SP2013 Ent.  Is there a similar response available for our configuration?

"PowerShell, Workflows, 3rd Party Tools or a custom Timer Job." is awfully broad response.  Been trying to keep the question simple so answers could be more specific.  The real challenge is much bigger.

Hard to believe this challenge is uncommon; are we over or under simplifying the question (can we rephrase for a better response?)
0
Nuno RogadoCommented:
Hi,

It's dated but still applies to your configuration.

SharePoint is an amazing platform.
You can use OOTB functionality or you can extend it.

Yes, please rephrase. Better requirement definition leads to better solutions!

Taking just your first question example: "Now create a library for the person the presents documents from both Library A and Library B?"

I would ask: should the document physically move between their original Libraries (A and B) and the new library for the person? Or this new library for the person is just a virtual one and is showing the documents from their original locations (Library A and B)?

Knowing the different concepts like Libraries and Views really helps in defining the problem and finding the best solution!

Best Regards,
Nuno Rogado
0
VirtualKansasAuthor Commented:
Ultimately a physical move would be a goal.  For now?   Call it a virtual library that presents an aggregate called for lack of a better way to put it "Library C".  So, Library C is an aggregate of Libraries A and B, where the documents in Library A and in Library B are keyed the same.

i.e. Document Library A contains documents, some with a key field of 001 and Document Library B also contains documents, some with a key field of 001.  Document Library C presents all documents in Library A and B with key field of only 001.

Better?
0
Nuno RogadoCommented:
Perfect.

In this case you need to implement a web part with code that reads data from both libraries, does the join and presents the data to the user.

There's nothing in SharePoint that can do that for you automatically.

You could create also a 3rd Library with links to the documents and populate that library with timer job or every time documents were added or removed to those 2 libraries... but I thinks that's more code and I prefer not to create more data...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
VirtualKansasAuthor Commented:
Benn on to other things, apologies for not catching your response.  No OOB is a surprise, seems like this is a chore that should be on every librarians mind.  

For now, I have a 3rd party app. (been avoiding 3rd party like the plague) that will at least create a view of all doc.'s grouped with a similar tag and presents the doc.'s and their library location that creates a pseudo document set.

Still doesn't solve the issue of on library per document set, however I have another 3rd party tool in SkySync that is not an app. but is agnostic and adept at speaking to SharePoint.  Their new release due out in coming weeks also will ready metadata for the sync.'s,  We can create sync. jobs that cycle through all the document libraries for specific tags and then move/copy/sync to any point B locations, including another library.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.