56 lines
1.9 KiB
PowerShell
56 lines
1.9 KiB
PowerShell
#install module if neccesary
|
|
#Install-Module -Name PnP.PowerShell -RequiredVersion 1.12.0
|
|
|
|
# Variables
|
|
$NewRfcClientId = "ac13078d-5621-4e28-81db-f5501d222e5d"
|
|
$NewRfcClientSecret = "BQOHS6LoESeBku+HIszR7cYvDMJp7EhGLhgkp369NAE="
|
|
$NewRfcUrl = "https://thalesdk.sharepoint.com/sites/SMO/TM/"
|
|
$ListTitle = "RFC"
|
|
|
|
$OldRfcClientId = "c3c3817d-8c3d-49fa-91cb-bdd498e2cc52"
|
|
$OldRfcClientSecret = "csXug7EEB3AQ71S+srSCZHOzVPoUxbazkDLvw/Mb8Bw="
|
|
$OldRfcUrl = "https://thalesdk.sharepoint.com/DriftsPortal/"
|
|
$ListTitle = "RFC"
|
|
|
|
|
|
#new RFC
|
|
Connect-PnPOnline -Url $OldRfcUrl -ClientId $OldRfcClientId -ClientSecret $OldRfcClientSecret
|
|
$items1 = Get-PnPListItem -List 'RFC' -Fields 'ChangeTitle','Status','Environmentimpacted','TypeofChange'
|
|
$result1 = foreach($item1 in $items1) {
|
|
$obj1 = [pscustomobject]@{}
|
|
|
|
foreach($key1 in $item1.FieldValues.Keys) {
|
|
$obj1 = $obj1 | Add-Member -MemberType NoteProperty -Name $key1 -Value $item1.FieldValues[$key1] -PassThru
|
|
}
|
|
|
|
Write-Output $obj1
|
|
}
|
|
|
|
|
|
|
|
#Old RFC
|
|
Connect-PnPOnline -Url $OldRfcUrl -ClientId $OldRfcClientId -ClientSecret $OldRfcClientSecret
|
|
$items = Get-PnPListItem -List 'RFC' -Fields 'Title','Status','Milj_x00f8_','System','Beskrivelse','Kontakt_x0020_person_x003f_','Tidspunkt_x0020_for_x0020_udf_x0','Attachments','IBM_x0020_Change_x0020_nummer'
|
|
$result = foreach($item in $items) {
|
|
$obj = [pscustomobject]@{}
|
|
|
|
|
|
foreach($key in $item.FieldValues.Keys) {
|
|
|
|
if ($key -notin @("ScopeId","FileRef","MetaInfo","_ModerationStatus","_Level","ID","UniqueId","owshiddenversion","FSObjType")) {
|
|
$obj = $obj | Add-Member -MemberType NoteProperty -Name $key -Value $item.FieldValues[$key] -PassThru
|
|
}
|
|
|
|
}
|
|
|
|
$obj.Kontakt_x0020_person_x003f_ = $obj.Kontakt_x0020_person_x003f_.LookupValue
|
|
Write-Output $obj
|
|
}
|
|
|
|
|
|
#grab fields
|
|
#$fields = Get-PnPField -List "RFC"
|
|
#Write-Output $fields.InternalName
|
|
|
|
|