As you may know I have released a tool you can use for SharePoint site provisioning. But what does it mean and how can you use it? During your development process you may need a test environment with lots of data. You can either create this test data by hand or you can use my tool Content Generator 2011 in order save time.
This article shows you how to create 10.000 list items in 5 minutes in a SharePoint list using Content Generator 2011.
Download & User Manual
SharePoint Site Provisioning - Content Generator 2011
How to
Connect to an existing site collection using the top menu –> SharePoint –> Connect to…
Using this connection you will be able to use site, page and list templates which are available at your site.
- First click on Lists in the tree to mark the list node.
- Second go to the template selector and choose Lists and libraries.
- Third double click on a custom list.
You have now added a list.
A new custom list was created as you can see in the picture.
Please click the custom list.
If you click at the list you will see the properties of the list in the lower right corner.
- Using Copies you can decide how many copies of that list should be created. You can easily create hundreds of lists with this property.
- Using title or description you can set the title and description which are shown in SharePoint after creating the list.
- Using the other properties you can decide if this list allows the creation of folder, versions, and so on…
If you right click on the list you can add folders (since version 2.1.0.10) and list items.
If you select the list item with the left mouse button you can edit the properties.
- Check in and Approve allows you to check in or approve list items if the list supports it. You can also keep items checked out.
- Using FileName you can set the title of a list item. The property is called FileName since you can also upload files if the list is a document library.
- Using the column collection you can set certain meta data of the list item. Please refer to the user manual.
Please choose to create 10.000 copies if this list item. Items are created in the following manner:
- MyListItem1
- MyListItem2
- MyListItem3
- …
Save your tree as a template using File –> Save as… Now go to the tab Jobs and create a job for your template.
- Choose a web application where your template should be created.
- Choose a target site collection.
- Choose your template and click Add job.
Right click on your newly created job and click run. Your list will be created with 10.000 list items. Depending on the resources of your hardware it takes around 5 minutes to create 10.000 list items in 5 minutes in a SharePoint list.