Large picture Library

[itsbrad]

My desire is to have some type of large repository for about 30000 media assets that I will be uploading from my file server that are in nested folders into Sharpoint Online.  What is the best way to accomplish this so I can have a view that allows me to preview or see all the thumbnails without having to drill through folders and not encounter the 5000 List View Threshold warnings.

[#2]

You can create columns for the media assets and fill that in as the files go up.
Then you can have multiple views based on the column contents.
Do they all have to be in the one library though?

[#3]

Additional points of attention: 1. If you completely remove the folder structure and place all media assets into a single container (e.g. Picture library) make sure the names are unique. 2 Capturing the original path (on the current file server) into SharePoint columns will likely simplify creating views 3. Setup the columns in the library prior to migration if you want to capture Exif or similar data (e.g. GPS coordinates, copyright, ...). 4. Instruct your users to not sync this picture library using offline tools. 5. Make sure you have sufficient storage, e.g. 30000 items x 10 MB each = about 300 GB.

[#4]

Thanks for the insight.

---

@Paul de Jong wrote:
2 Capturing the original path (on the current file server) into SharePoint columns will likely simplify creating views

---

How do you accomplish grabbing the folder names to a column?

---

@Paul de Jong wrote:
3. Setup the columns in the library prior to migration if you want to capture Exif or similar data (e.g. GPS coordinates, copyright, ...). 

---

If a EXIF data such "comments" or "tags" in a jpg file have multiple values when you import it into Sharepoint how does the column structure deal with it?

Any recommendations on what software to actually import the files?

[#5]

How do you accomplish grabbing the folder names to a column?

This functionality is part of the Migration Manager tool. You can configure an upload to skip folders and flatten the structure. It takes into account existing names by mimicking behaviour on windows by renaming items to e.g. filename(1).jpg
Your requirement is very similar to another post on technet where they actually used the tool for a set of 4000 documents. See 

https://social.technet.microsoft.com/Forums/office/en-US/cc87874e-5992-45cb-9d4d-75b15dc206f1/migrat...

If a EXIF data such "comments" or "tags" in a jpg file have multiple values when you import it into Sharepoint how does the column structure deal with it?
It is stored in a column of type single line of text or as Multiple Lines of text. I can imagine it would be beneficial to be able to split it into separate fields. Standard SharePoint also extracts metadata from graphical files but the column names need to be fixed up front (see https://spjohnadams.wordpress.com/2012/10/24/how-to-extract-exif-meta-data-from-photographs-automati...).

There are lots of tools (see e.g. https://directory.collab365.community/office365-sharepoint/office-365-migration-software/). This list seems to grow on a daily basis. Typical criteria to look at when selecting a tool are: easy of use, throughput, costs, support for metadata, support for large files (GB's), logging, support for the target library type, ability to flatten folder structure (and capture path in SharePoint columns), no server-side installs (since the target platform is SharePoint Online), ..

[#6]

So I took the approach of splitting up the library into smaller chunks.  I have split it into Picture Library's separated by year.  However I am still trying to have an elegant way to search and query the pictures.  I thought I should be able to do that with a Data View but still have issues, see my other post.

https://techcommunity.microsoft.com/t5/SharePoint/View-Multiple-Document-Libraries-together/td-p/147...