InfoPath Data Connection Performance Issues
Using web services instead of SharePoint list data connections in an InfoPath form to improve performance.
SharePoint Development News & Resources
Daily SharePoint Development resources and news.
SharePoint 2010 Development
Learn SharePoint 2010. Daily SharePoint 2010 & MOSS 2007 news resources.
Showing posts with label InfoPath SharePoint. Show all posts
Showing posts with label InfoPath SharePoint. Show all posts
InfoPath & SharePoint Development Reosurces
Posted by DanielS Sunday, January 16, 2011 at 6:52 AM 0 commentsGenerate SharePoint Site Permissions Report Using Excel
Posted by DanielS Tuesday, November 23, 2010 at 1:38 AM 0 comments
Using an Excel spreadsheet and a data connection to the site permissions page of a site in SharePoint, you can display the permissions from the site on a worksheet. By adding multiple data connections to the spreadsheet to the site permissions page on other site in the SharePoint farm, or another SharePoint farm, you can list the permissions for multiple sites on one worksheet, or in the same file on separate sheets.
A data connection that can be used to retrieve the permissions from a site in SharePoint is to 'scrape' the data directly from the site permissions page of the using the web interface proved by SharePoint and a “Web Query” data connection in Excel. Each data connection can be configured to refresh at intervals, when the spreadsheet loads, or to only allow manual refreshes. If there are many connections in one sheet, you should consider staggering the refresh for each so that they are not all executed at the same time. As a separate web request to the SharePoint site must be completed for each connection, the SharePoint server may experience periods of high load if all connections are refreshed at the same time. Configuring each connection to refresh at intervals so that no two are refreshed at the same time should balance the load on the server. Sheets with a small or moderate number of connections can be configured to refresh at the same time if required, but you should test the impact on performance when refreshing data connections if the spreadsheet is to be used frequently or by a large number of users.
SharePoint Site Permissions Report Using Excel
A data connection that can be used to retrieve the permissions from a site in SharePoint is to 'scrape' the data directly from the site permissions page of the using the web interface proved by SharePoint and a “Web Query” data connection in Excel. Each data connection can be configured to refresh at intervals, when the spreadsheet loads, or to only allow manual refreshes. If there are many connections in one sheet, you should consider staggering the refresh for each so that they are not all executed at the same time. As a separate web request to the SharePoint site must be completed for each connection, the SharePoint server may experience periods of high load if all connections are refreshed at the same time. Configuring each connection to refresh at intervals so that no two are refreshed at the same time should balance the load on the server. Sheets with a small or moderate number of connections can be configured to refresh at the same time if required, but you should test the impact on performance when refreshing data connections if the spreadsheet is to be used frequently or by a large number of users.
SharePoint Site Permissions Report Using Excel
InfoPath SharePoint
Posted by DanielS Saturday, August 21, 2010 at 5:20 AM 1 comment
InfoPath SharePoint
Integrate InfoPath Forms with SharePoint lists, libraries and workflows. The following blog provides various tutorials and resources relating in InfoPath form development & integration with SharePoint. Use InfoPath Forms as an interface or input mechanism for business data and workflow.
blog-sharepoint.blogspot.com/
Integrate InfoPath Forms with SharePoint lists, libraries and workflows. The following blog provides various tutorials and resources relating in InfoPath form development & integration with SharePoint. Use InfoPath Forms as an interface or input mechanism for business data and workflow.
blog-sharepoint.blogspot.com/
Subscribe to:
Posts (Atom)