Forum Discussion

itsbrad's avatar
itsbrad
Iron Contributor
Jan 17, 2018

Large picture Library

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...
Document Library
SharePoint Online
Paul de Jong's avatar
Paul de Jong
Iron Contributor
Jan 18, 2018
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.
  • itsbrad's avatar
    itsbrad
    Iron Contributor
    Jan 18, 2018

    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?

    • Paul de Jong's avatar
      Paul de Jong
      Iron Contributor
      Jan 18, 2018

      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/migrating-to-office-365-from-sp-2007-issues-with-metadata?forum=sharepointgenerallegacy#25460697-19fb-49fd-af44-eb5eab93f1c6

       

      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-automatically-in-sharepoint-2010/).

       

      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), ..