Powershell 和Sharepoint 通过视图将列表项导出到 csv

发布于 2024-10-13 18:51:01 字数 378 浏览 6 评论 0原文

我正在尝试通过特定视图从共享点列表中导出项目。

我已经成功返回了项目，但现在我无法正确地将其导出到 csv 文件，

这是我迄今为止所拥有的：

$web = Get-SPWeb $url
    $splist = $web.Lists[$listname]
    $view = $splist.Views["Current Month"] 
    $items = $splist.GetItems($view)
    $items | Select-Object "Check Number", "Purchaser" | Export-Csv -Path f:\test.csv
    $web.Dispose()

提前谢谢您！

原文

I am attempting to export items from a sharepoint list via a specific View.

I have the items returning successfully but now I am stuck trying to export it to a csv file correctly

here is what i have thus far:

$web = Get-SPWeb $url
    $splist = $web.Lists[$listname]
    $view = $splist.Views["Current Month"] 
    $items = $splist.GetItems($view)
    $items | Select-Object "Check Number", "Purchaser" | Export-Csv -Path f:\test.csv
    $web.Dispose()

Thank you in advance!

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

羅雙樹 2024-10-20 18:51:01

对于 sharepoint 2007，

[Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") | out-null
$site = new-object Microsoft.SharePoint.SPSite("http://yoursite")
$web = $site.RootWeb
$list = $web.Lists[$listname]
$view = $list.Views["Current Month"] 
$items = $list.GetItems($view)
$items | %{ select-object -input $_ -prop @{Name='Title';expression={$_.Title;}}, @{Name='Check Number';expression={$_["Check Number"];}}; } | Export-Csv -Path c:\test.csv

您必须先从 SPListItem 属性构建选择对象，然后再将其传递到 Export-CSV

For sharepoint 2007

[Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") | out-null
$site = new-object Microsoft.SharePoint.SPSite("http://yoursite")
$web = $site.RootWeb
$list = $web.Lists[$listname]
$view = $list.Views["Current Month"] 
$items = $list.GetItems($view)
$items | %{ select-object -input $_ -prop @{Name='Title';expression={$_.Title;}}, @{Name='Check Number';expression={$_["Check Number"];}}; } | Export-Csv -Path c:\test.csv

You have to build your select object up from the SPListItem properties before passing it to Export-CSV

回复收藏 0 原文

~没有更多了~