No one has responded to this discussion for at least a year, so this information may be out of date. If you're looking for information about this topic, please search for a more recent discussion or post a new question.

More than 5,000 images

This question is not answered This question is not answered

On Office Live I had 12,000 images of old postcards. Each image being named by a 2 letter UK County code (e.g. Lo for London) followed by a 3 digit number.

I have successfully migrated to Office 365 EXCEPT for the images. It will only upload 5,000 and then I get

This view cannot be displayed because it exceeds the list view threshold (5000 items) enforced by the administrator.

as I am the administrator and have imposed no such threshold, this doesn't make sense. I've tried to research it and it mentions views. I've created views for the images prefixed by av and bd (e.g. using a Title contains av) but I still get the above message.

Is 5,000 the view threshold or the total number of images threshold?

Can I have any number of images, as long as I don't try to display more than 5,000 at once?

I'll happily delete them and start again but as I've gone over 5,000, I can't see them to delete them.

 My 12,000 images on Office Live had filled almost the limit of 500Mb, so the prospect of 10Gb on Office 365 was a big incentive, but if the limit on images is 5,000 then I'm totally stuck.

All Replies
  • This issue appears fairly frequently. In SharePoint, there is a 5,000 item limit on a view - yet the library can hold more than 5,000 items. However, in Office 365 it seems there is a 5,000 limit in a library (total number of items in the library) regardless of the view setup. It is an Office 365 setting and cannot be modified, so it is nothing that was configured by you.

    My advice would be to create 2 libraries to add the images to and break it up that way.

    This response is based on my personal experience and other issues similar to this that I have seen on the board.

    -John

    1 out of 1 people found this post helpful.

  • Hello,

    This is Justin with Microsoft Office 365 SharePoint Support.  Thanks for responding to the thread John.

    Since the public site is based on SharePoint, John is correct about the 5000 item view limit threshold.  However, the library limit should be within the limits of SharePoint as well, which is 30,000,000.  So then, try to access the library an alternate way to reduce the view to below 5000.

    One way to do this could be to 'Map network drive' from the Computer window of your Windows OS, and enter the URL of the Images library (ex. 'http://<domain>.sharepoint.com/SiteImages') to open the list.  You could also try to open the list in SharePoint Designer and manage the list here. 

    Once the lists are below 5000, create more views using the drop down menu on the right side of your picture library. Let us know your progress and I will monitor this thread for updates within the next few days.

    Thanks and Regards,

    Justin Ronan
    Microsoft Office 365 SharePoint Support

  • I have now successfully uploaded all my current images into various libraries, but they are named as pictures. When I go to edit a web page the only option seems to be to Insert image, which points at the empty image file. How can I point this at the appropriate library to extract the image to insert?

    On Office live, because of the number of images I had, I found it easier to insert images using HTML, i.e.

    <IMG SRC="">

    Is this still an option? (I'm reluctant to try it as I still haven't got my domain name changed and verified after 16 days, and I will probably have to change the HTML code after it's verified). Insert Image seems to be the best option.

  • The insert image tool only works with the default site images library, not libraries you created. The suggestion above to use "views" would work but it's probably too late.

    To use that, click "view" at the top right of the image library and select "create new view".

    Name it and when its settings open, add some kind of a filter. For instance you could add:

    filter when the name field CONTAINS "Lo" 

    So only your "Lo" images would be in that view.

    All the images will then appear in the image insert tool.

    And I hate to mention this at this point, but with Office 2010 you can also sync up the image library with your computer. So if you did that you could have just connected the library and had to upload nothing. I wish MSFT would alert people to tools like this more (Sharepoint Workspace)..  

    Maybe easier would be to use html which you can insert as you did in OLSB with the html gadget.

    This would be a perfect candidate for a Sharepoint list (which the image library is) because you could simply import all your images or connect them to an Access database but the capability to deploy custom lists in the public site has been disabled.  

  • Thank you for your reply. It seems to raise more questions than it answers.

    1. What is the point of picture libraries if you can't use them?

    2. I tried to create views, as you suggested, but it still came up with the:

    This view cannot be displayed because it exceeds the list view threshold (5000 items) enforced by the administrator

    even though the view was only for 200 images.

    3. Your response re Sharepoint Workspace seems to imply I would have to keep my computer on 24/7.

    4. When I originally uploaded and went over the 5000 limit, it now says I have no uploaded images but it can't display them because I have over 5000. I can't access them to delete them.

    We are a two person small business. I have already lost nearly three months income transferring from a highly useful Office Live system, to a highly useless Office 365 system which doesn't seem fit for purpose, and in a few months I will have to pay Microsoft for the privilege. Perhaps, in the USA, small business equals only 100 employees. In the UK it means 1-10 people.

  • My ideal solution is as follows (though I'm not sure whether it would work on Office 365).

    When I created my website on Office Live, but had only uploaded a few hundred pictures, I used Insert image and it seemed to paste the image onto the page (as opposed to a link). When I copied the pages onto Office 365, the pictures stayed and are still visible even though the images aren't in the image file.

    When the image number (on Office Live) got too great, I used HTML and those images clearly need the image in the image file.

    Can I not, therefore, upload 1000 images at a time, use insert image to put them onto pages, delete them from the image file and then do the next 1000? (This will be very slow only if Office 365 has inherited Office Live's problem - that it only let me delete 1 mb at a time).

    (This seems so simple that I'm sure that Microsoft have found a way of stopping me).

    No one has offered a solution yet as to how I can access and delete the 5002 images I have already uploaded to the Image File.

  • It may help to understand how it works. When you "insert an image" with the editor tool, you're actually creating a link to the image which is hosted in your gallery. If you delete images there, they will no longer be available for the link. 

    A few posts up, one of the MSFT reps posted how to repair your library/view by reducing the number of items in the library. The default "all items" view is overfull which breaks the ability to use the library. Once it's below 5000, you should be able to create more views and add more images.. 

    Once that's done you can arrange the images into multiple views within the public site default image library as he and I suggested and STILL use the insert image tool.I've a feeling though with that many images it may be a slow process.

    It might be easier if you have a listing of all the image file names in a spreadsheet (or Access database) to use that to generate the html code and then insert that in an html module on the appropriate pages. Something.like:

     A B
    C      
     D Combine
     1  <img src="
     {filename}  "/> =B1&C1&D1





       

    To be honest, O365 isn't well suited to these types of uses because its database capabilities have been disabled in the public site.
  • My state of play:

    I've tried all the Sharepoint designer options listed above, and they all come back with 'too many images'.

    I've tried creating views but they give the same message after creation.

    I've tried making one of my views the default and deleting the 'Select all' view, but it won't let me complete this because I can't select the 'select all' view, because it has too many images.

    I am left with two specific questions:

    a) can a server administrator please delete all my images, as I cannot?

    b) can you 'insert image' from a view. If you can does it have to be the default view?

  • Have you tried "open with explorer"? I ask because it's possible SPD is referencing the "all items" view and that's why it fails. Open any team site library, click "open with explorer view" from the ribbon and navigate up to your public site images library. If that doesn't work, you'll need a service request.

    Yes, you can insert image from any view. I noticed all the images show up in the box and the views are ignored. As I said though that might be very slow with so many images.  

  • I have tried with explorer, but with the same error message. How can I create a service request, please?

    ps - I'm used to slow - its taken us five years to build my website so far and we still have a long way to go. That's why I will be fairly unhappy to lose everything.

  • Hello again,

    Have you tried the mapped network drive method mentioned previously?  Just ensure you are signed into Office 365 with Internet Explorer and click Computer from your Start Menu in Windows.  Then, click Map Network Drive in the top link bar options and under the drive letter, in the 'Folder:' box enter your SiteImages library location (ex. http://<domain>.sharepoint.com/SiteImages for a non custom domain).  Let us know if you can manipulate the files and place them in seperate folders to get them under 5000 each this way.

    Thanks,

    Justin Ronan
    Microsoft Office 365 SharePoint Support

  • Thank you. I have tried that but the drive letter is a problem. It defaults to my operating system drive and asks 'are you sure you want to overwrite you current drive path'. If I choose any other drive it does nothing (no messages).

    I would still like to proceed with a service request, if you could please tell me how.

  • Hello,

    If the drive path is a problem, simply choose the link below the drive path called 'Connect to a Web site that you can use to store your documents and pictures'.  Ensure you are logged into the admin account of Office 365 in Internet Explorer and click Next twice, followed by entering your site in the box (ex. 'Internet or Network address: <sitename>/SiteImages/').  This way, you can customize the name of the location.  If you receive an error, you are not correctly signed in with Internet Explorer.

    Service requests for Small Business customers are only included and created for billing related issues, as detailed in the Service Description and features list below.

    http://www.microsoft.com/en-us/office365/all-plans.aspx#fbid=oUUJLIZyZ-E

    http://www.microsoft.com/en-us/download/details.aspx?id=13779

    Let us know if this is helpful to your issue.

    Thanks,

    Justin Ronan
    Microsoft Office 365 SharePoint Support

  • I'm going round in circles here.

    I've done the above and it connects ok but when I go to the siteimages folder it says its empty

    If I look at the properties of the folder it has 0 size, but I can't use it to upload images because it has 5003 images in it.

    They cannot both be correct.

  • When a folder goes over the 5,000 item limit this is what happens (I have been experimenting with this over the weekend). There is only one way to get around this - create a new view without folders being displayed. Go to the Library options and select Create View. Select Standard View - for the Folders option select Show All Items Without Folders and for the Item Limit, limit the total number of items to less than 5,000 (knowing that the larger the number, the longer it will take to work with this view).  Now items can be deleted from the view to get the folder limit under 5,000. The only catch is knowing what file names are within that folder. I hope this helps - if you have any questions on this just let me know.

    -John