Uploading file to Sharepoint List items

Question

I got a custom sharepoint list, with a title column which contains Servernames and i got alot of .csv files that has the same name as the title

Is it somehow possible to upload em to the list item as an attachment with a script? Maybe Powershell? I got over 100 files so it would be a pain if i had to do it all manually.

The File and Title column looks like this:

Title
Server1.domain.com

.csv
Server1.domain.com.csv

Have been looking around for quite a while but havent been able to find anything i could use

Stefan Stefan · Accepted Answer · 2011-12-08T09:43:15

Approach:

Iterate over the SharePoint list items.
Load the corresponding CSV file by the SPListItem.Title
Add the file as attachment to the SPListItem.

Script:

$w = Get-SPWeb http://List/Location/Url
$l = $w.Lists["TheList"]

foreach ($item in $l.Items)
{
     $file = Get-Item "$($item.Title).csv"
     $stream = $file.OpenRead()
     $buffer = New-Object byte[] $stream.length
     [void]$stream.Read($buffer, 0, $stream.Length)

     $item.Attachments.AddNow($file.Name, $buffer)
}

Considerations:

Disposing of the file stream
Disposing of the SPWeb object
Handle missing files

Edit

Two mistakes in first attempt:

SPAttachmentCollection.Add expects a byte array.
SPAttachmentCollection.AddNow should be used to add the attachment directly (without update of the SPListItem)

Updated the code...

Uploading file to Sharepoint List items

1 Answers