How to create bulk tasks in a Sharepoint List?

Question

Is it possible to create Bulk Tasks for any SharePoint 2010 List?

There is no option to create multiple tasks in SharePoint. And, it is very cumbersome to create multiple task for the person who heads a project.

So can some one help me out on this?

-saumil

Answer 1

Depending on the tasks, there are ways to use SharePoint Foundation Remote Procedure Calls (RPC) in combination with Collaborative Application Markup Language (CAML) to create batch operations on lists.

This includes deleting, updating, adding and other commands.

There is an article covering this here.

This can also be done from code. Examples here and here.

Answer 2

Most efficient way of doing it in the UI I think is using the Datasheet view.

If you have an Excel spreadsheet with the columns laid out in the same way as the datasheet view, you can copy & paste from Excel directly into the Datasheet view.

Answer 3

Another approach, if you have a base set of tasks for each project, you could create them via workflow once a new project is added to your project list.