0

I have a Document Library that contains about 100,000 folders (tickets from Remedy), and each ticket (folder) has 1-5 files associated with it. All ticket folders are on the same level hierarchy with respect to the root folder, if that makes sense. Also, each ticket is prefixed with three characters to denote the nature of the ticket. Folder names are the same as the ticket ID.

What I'd like to do is, create a custom view for each ticket category (prefix), and then, for each record (ticket) within each custom view, provide a link to the Document Library, specifically to the folder that contains all attachments for the given ticket.

My concern is: How can I obtain a spreadsheet that contains the links to each ticket attachment folder within the Document Library? Manually doing this would of course be insane.

Improve this question
1
  • Do you need just a spreadsheet with the folder links or a SharePoint view also?
    – SharePointer
    Aug 25, 2017 at 11:03

1 Answer 1

Reset to default
0

Solution 1

Create a view with "Group By" in the same library that has 100k folders.

  1. Create a calculated column "Prefix" with formula below.

    =LEFT(Title,3)
  2. Create a view and use Group By on "Prefix"

A sample looks this

enter image description here

Solution 2

Enable the "Metadata navigation settings" on the document library as below. This gives a navigation tree view on the left navigation.

enter image description here

enter image description here

Solution 3

Use custom code. You need to loop through the folders recursively, read the folder with pattern "data_xxxx", generate the url as a string and store it back to the root level in an hyperlink field. You need to add that hyperlink field to the "folder" content type.

Improve this answer
4
  • Hmm.. I do like the idea of grouping by the prefix, however, the attachment files for each ticket aren't stored in the root folder of that ticket. Which is to say, the user would still have to navigate through a series of folders to get to the attachments, given the approach you offer.
    – user69333
    Aug 24, 2017 at 16:30
  • Could you brief how the ticket and related attachments are structured? Can you give example of a ticket with its attachments as a tree structure?
    – Ahmad Zia
    Aug 24, 2017 at 23:55
  • @AhmadZai Sure, it's really simple. For each ticket there's a folder that's titled the same as the ticket ID. Within that folder, there's a data file that contains the form that the ticket was created by, and then, there's a subfolder that's titled "data_xxxxxxxxxxx", which contains all the attachment files. The "xxxxxxxxxxx" is completely random, but the hierarchy is consist in this way. So, the attachment folder directory would be, "\\rootFolder\ticketID\data_xxx\".
    – user69333
    Aug 24, 2017 at 23:57
  • @Charles thank you for the brief. I have edited my answer. Please refer to the Solution 2 in my answer.
    – Ahmad Zia
    Aug 25, 2017 at 2:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.