Re: Probleme bei Excel-Import per PowerShell

GuentherWilkens erstellt 10 Juni 2013 11:30

Danke für den Hinweis mit dem SPList Update. Habe es jetzt hinbekommen. Falls jemand interessiert ist, hier das Script:

Get-Content C:\Import\adressen.txt | Set-Content -Encoding utf8 C:\Import\adressen_utf8.txt

$contents = Import-CSV ‘C:\Import\adressen_utf8.txt' -header("Kundennummer", "Anrede", "Vorname", "Nachname", "Name2", "Straße","Land", "PLZ", "Ort", "Briefanrede", "Telefon", "EMail" ) -Delimiter ";"

$webURL = “http://fh-p-ap”

$web = Get-SPWeb -Identity $webURL

$listName = "Kunden"

$list= $web.Lists["$listName"]

$caml=""

$query=New-Object Microsoft.SharePoint.SPQuery

$query.ViewAttributes = "Scope='Recursive'"

$query.Query=$caml

$items=$list.GetItems($query)

foreach ($row in $contents )

{

                #Check for existing item

                $item = $list.Items | Where { $_["Kundennummer"] -eq $row.Kundennummer }

                If ($item -ne $null) {

                               $item["Kundennummer"] = [System.Convert]::ToInt32($row.Kundennummer)

                               $item["Anrede"] = $row.Anrede

                               $item["Vorname"] = $row.Vorname

                               $item["Nachname"] = $row.Nachname

                               $item["Name2"] = $row.Name2

                               $item["Straße"] = $row.Straße

                               $item["Land"] = $row.Land

                               $item["PLZ"] = $row.PLZ

                               $item["Ort"] = $row.Ort

                               $item["Briefanrede"] = $row.Briefanrede

                               $item["Telefon"] = $row.Telefon

                               $item["EMail"] = $row.EMail

                               $item.Update()

                }

                Else {

                               $item = $list.Items.Add();

                               $item["Kundennummer"] = $row.Kundennummer

                               $item["Anrede"] = $row.Anrede

                               $item["Vorname"] = $row.Vorname

                               $item["Nachname"] = $row.Nachname

                               $item["Name2"] = $row.Name2

                               $item["Straße"] = $row.Straße

                               $item["Land"] = $row.Land

                               $item["PLZ"] = $row.PLZ

                               $item["Ort"] = $row.Ort

                               $item["Briefanrede"] = $row.Briefanrede

                               $item["Telefon"] = $row.Telefon

                               $item["EMail"] = $row.EMail

                               $item.Update()

                }             

}

Write-Host -ForegroundColor green "List Updated Successfully"

$web.Dispose()