Guest User

Untitled

a guest
Jan 18th, 2019
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.08 KB | None | 0 0
  1. #Get the Target List
  2. $list = $web.Lists["Stand-By rooster AM Ambot"]
  3. #Get the View
  4. $view = $list.Views["Uitprinten"]
  5.  
  6. #Get All items from the view
  7. $items = $list.GetItems($view)
  8.  
  9. #Array to Hold Result - PSObjects
  10. $ListItemCollection = @()
  11.  
  12. #Get All List items where Status is "In Progress"
  13. $items | foreach {
  14. $ExportItem = New-Object PSObject
  15. $ExportItem | Add-Member -MemberType NoteProperty -name "Datum" -value $_["Datum"].ToLocalTime().ToString("dd.MM.yyyy");
  16. $ExportItem | Add-Member -MemberType NoteProperty -Name "00:00 - 07:59" -value $_["00:00 - 07:59"]
  17. $ExportItem | Add-Member -MemberType NoteProperty -name "08:00 - 16:59" -value $_["08:00 - 16:59"]
  18. $ExportItem | Add-Member -MemberType NoteProperty -name "17:00 - 23:59" -value $_["17:00 - 23:59"]
  19. $ExportItem | Add-Member -MemberType NoteProperty -name "Opmerkingen" -value $_["Opmerkingen"]
  20.  
  21. #Add the object with property to an Array
  22. $ListItemCollection += $ExportItem
  23. }
  24. #Export the result Array to CSV file
  25. $ListItemCollection | epcsv "c:tempStand-By rooster AM Ambot.csv" -NoT
  26.  
  27. #Dispose the web Object
  28. $web.Dispose()
Add Comment
Please, Sign In to add comment