通过数据库更新共享点列表? [英] Updating sharepoint lists via database?
问题描述
我试图找到一种更有效的方法来更新共享点站点上的多个字段，而无需下拉 -> 右键单击，或者必须以我们可以从网络编辑字段的方式手动加载网站页面本身.
I'm trying to find a more efficient way to update multiple fields on a sharepoint site without having to dropdown -> right click, or having to manually load the website in such a way that we can edit the field from the web page itself.
我没有也不会访问共享点设计器，所以我希望有一些我可以访问的数据库，在那里我可以一次更新字段而不是手动编辑每个字段(非常慢).
I don't and will not have access to sharepoint designer, so I was hoping there is some database out there I could have access to, where I could UPDATE the fields at one time instead of manually editing each field(extremely slow).
如果我错了，请原谅我，但我相信 sharepoint 站点上的所有字段都保存在数据库中?如果我拥有共享点的管理员访问权限，我是否可以访问这些数据库中的任何一个?
Forgive me if I'm wrong, but I believe all fields on a sharepoint site are held in a database? If I have admin access to the sharepoint, will I have access to any of these databases?
推荐答案
不，您将无权访问后端数据库.
No, you will not have access to the backend database.
即使您这样做了，也不赞成直接查询底层 SQL Server 数据库……它仅在少数极端情况下受支持(主要用于报告)，并且任何修改都存在将您的数据库置于不受支持状态的风险.
Even if you did, directly querying the underlying SQL Server database is frowned upon... it's only supported in a few edge cases (mainly for reporting) and any modifications run the risk of putting your database into an unsupported state.
相反，SharePoint 公开了一个对象模型，可用于以编程方式访问 SharePoint 对象(例如网站、列表、列和列表项).
Instead, SharePoint exposes an object model that can be used to programmatically access SharePoint objects (such as sites, lists, columns, and list items).
SharePoint 对象模型通过以下 API 公开:
The SharePoint object model is exposed through the following APIs:
- 托管服务器端对象模型(必须从其中一台 SharePoint Web 前端服务器执行)
- 托管 .NET 客户端对象模型
- 基于 SOAP 的网络服务
- REST 接口
- JavaScript 客户端对象模型
- Managed server-side object model (which must be executed from one of the SharePoint web front-end servers)
- Managed .NET client-side object model
- SOAP-based web services
- REST Interface
- JavaScript client object model
根据您的访问级别，您可以使用后四个选项中的任何一个(只是没有服务器端代码)，但它们每个都需要不同级别的编程专业知识.
With your level of access, you can use any of the four latter options (just no server-side code), but they each require varying levels of programming expertise.
这篇关于通过数据库更新共享点列表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
