Automated Sharepoint Task Creation with Powershell

Question

My organization is experimenting with new processes to coordinate developers as they integrate their code into our main branch. Right now it's just a basic task list in Sharepoint, but it seems to be doing the trick pretty well. However, there's a lot of tedious manual labor in the creation of those task tickets, and we're looking to improve this. To that end, I have two questions.

1) I've looked through the list of Powershell cmdlets for Sharepoint, but without being a Sharepoint wiz I don't see anything immediately obvious in terms of automated task creation. Can this be done, or are the cmdlets more for administrative (configuration) purposes rather than for usage?

2) Is this a horrible abuse of sharepoint? Ultimately we're just trying to create a centralized location for tasks to be registered with some basic information concerning task details, task owner, and completion status. If there's some obviously better way to do this I'm all ears since no matter what we do we're probably reinventing some wheel or another.

Post here maybe? sharepoint.stackexchange.com

manojlds
– manojlds

2011-11-17 16:18:48 +00:00
Commented Nov 17, 2011 at 16:18 — manojlds
– manojlds, Commented Nov 17, 2011 at 16:18

jumbo · Accepted Answer · 2012-05-01 14:27:41Z

1

Task creation in powershell for Sharepoint is as easy as adding item to list. So the basic steps for such script would be: get web, get task list, add item, fill in properties, update item.

This code should work:

$w = get-spweb http://localhost/subweb
$l = $w.Lists['Tasks'] # use display name to index lists collection
$newitem = $l.AddItem()
$newitem['Title'] = 'Task for Peter'
$newitem['Body'] = 'Description of the task'
$newitem['DueDate'] = (get-date).AddDays(5)
$newitem['AssignedTo'] = $userId
$newitem.Update()

But this would mean, you run your PS script on sharepoint server machine. Basically it is possible to run sharepoint cmdlet against local sharepoint.
It is also possible to run those cmdlets remotely, but that needs setting of WinRM service on both sides and is not basic task...

answered May 1, 2012 at 14:27

jumbo

4,8986 gold badges41 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Automated Sharepoint Task Creation with Powershell

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related