Join Gini von Courter for an in-depth discussion in this video What you need for this course, part of SharePoint 2016: Managing Large Lists.
- [Instructor] If you'd like to work along with me in this course then you'll need some software, and some files. Let's begin with the software. You'll need SharePoint. This course is aimed at the newer versions of SharePoint, I will be using SharePoint Online, part of Office 365, for this course, but I will also point out differences between SharePoint Online and SharePoint 2016 On-Premises, another valid version of SharePoint that you can use. If you have SharePoint 2013, you'll be okay as well, and when I'm pointing out distinctions between SharePoint Online and SharePoint 2016, those are probably valid for you, too.
If you have some very large lists, more than 5,000 items, and some lists of around 3,000 items, in your SharePoint site, you're ready to go. But if not, you'll need to have a way to create those lists, and for that you will want to have Excel. I'll be using Excel 2016, and Excel 2013 will also work. If you have a premium subscription to the training library, then you have access to the exercise files for this course.
Simply click the link and download the files. I've placed mine here on my desktop, and we have files like Contributions, Inventory, Person City State Zip Phone, and you'll find, for example, that the Contributions list has thousands of items in it. If you don't have access to the exercise files, and you don't have large lists in your SharePoint site, I can tell you how you can create them. You can use a data generator.
Data generators are used to be able to create sample data, and are typically used by developers, business analysts, and others, to be able to test applications. There are two data generators that I recommend. The first is called Generate data, and this is the data generator that I used to create the files for this course. You'll find a link at generatedata.com. There's also the Spawner data generator, which is available at sourceforge.net.
You can use either of these for free, but they will create only a thousand rows. You'll need, therefore, to run the same request five times, and copy and paste, to be able to have 5,000 rows or more, or you'll need to pay something for the product. Generate data costs 20 dollars a year, Spawner around 50; if this is something that you do a lot, then you might want to simply pay those fees and get one of these generators.
But the other clue is that if you work in an IT department, or if you're good friends with the folks in your IT department, find out if they have a data generator, and perhaps you can describe the file you'd like to create, and they will simply create it for you. It takes a matter of minutes, particularly for people who are already used to using the data generators. SharePoint, Excel, and some data, and you'll be ready to go.
- Managing large lists and libraries
- Importing Excel data
- Using indexes and folders
- Creating a filtered view
- Using item limits and groups
- Creating an Access web app