Q&A

Q&A (18)

Questions & Answers Section

Question:

>>How to pull back data even pass the throttling point for list?

Answer:

The only way to achieve this is to disable throttling temporarily, for the particular list

 

Thursday, 04 February 2010 11:34

Q#16: How to configure SharePoint with Gmail

Written by

Question:

>> Our company uses GMail for corporate mail. How can we configure the SharePoint to work with @gmail mailbox?

Answer:

I got several questions how to configure the SharePoint on Windows Server 2008 to alternative email addresses when you don't have Exchange (for those who don't know Microsoft removed internal Mailbox support from Windows Server 2008).

There are several solution for this situation - using 3rd party mail servers, like Visendo and others. But in some cases you company can use GMail or Live mail for the corporate correspondence, and you need to configure your SharePoint to work with external mail servers.

Such configuration a bit tricky but possible. I recommend to read that post http://www.oceanapproach.com.au/blog/Lists/Posts/Post.aspx?ID=44 where described how to configure SharePoint to work with GMail accounts

Question:

>> Hello, I'm using InfoPath with dozen of DataSources that query data from Web Services, lists and etc. I'd like to know how can I update DataSource URL at run-time and use URL from config?

Answer:

What you asked is very common question when InfoPath form need to be deployed from DEV to Staging and to Production environment and updating the DataSources manually is really daunting task.

The easiest way to achieve desired behavior is using DataConnections class, instead of DataSources. You can access DataConnection SiteURL property casting the object to the right connection object,. for example WebServiceConnection.

Use the following CodeSnippet, that allows you to iterate through all DataConnections and update its URL to the values from config file. This CodeSnippen assumes that only WebServices connections are used. You can extend it to support file object connections and other stuff

Code Snippet
  1. public static void UpdateDataSourceURL(DataConnectionCollection dataConnections)
  2. {
  3. if (SPContext.Current != null)
  4. {
  5. var webServiceURL = WebConfigurationManager.AppSettings["<WSurl>"];
  6. var siteURL = WebConfigurationManager.AppSettings["<siteURL>"];
  7. foreach (var connection in dataConnections)
  8. {
  9. if (connection is WebServiceConnection)
  10. {
  11. Uri webservicePath;
  12. var dataConnection = (connection as WebServiceConnection);
  13. if (dataConnection.ServiceUrl.ToString().Contains("_vti_"))
  14. {
  15. webservicePath = new Uri(string.Format("{0}{1}{2}", siteURL, dataConnection.ServiceUrl.Segments[2], dataConnection.ServiceUrl.Segments[3]));
  16. }
  17. else
  18. {
  19. webservicePath = new Uri(webServiceURL + dataConnection.ServiceUrl.Segments[2]);
  20. }
  21. dataConnection.ServiceUrl = webservicePath;
  22. }}}}

 

Monday, 16 November 2009 07:00

Q#14: How to convert a List Template to Feature

Written by

Question:

>> How can I convert List Template to a Feature

Answer:

The way to achieve this to use use Visual Studio Extentions for WSS to extract List Resources and then deploy them either via VSeWSS or via STSDEV

  1. Guideline http://dotnetdeveloper.co.uk/blogs/sharepoint/archive/2009/02/18/deploying-custom-lists-with-stsdev.aspx
  2. Tool http://www.microsoft.com/downloads/details.aspx?familyid=FB9D4B85-DA2A-432E-91FB-D505199C49F6&displaylang=en#filelist

 

Monday, 05 October 2009 11:48

Q#14: How to customize Upload page

Written by

Question:

>> How can I customized _Layout/Upload.aspx?!

Answer:

It's a tricky question, because to do it propertly you not only need to add the new toolbar action, but hide existing one, and it's where the thicks is. You can't hide the "upload" action via "HideCustomAction" feature, because "Upload" is not rendered via custom action feature. "Upload" page is the custom control in toolbar, that is implemented in "Microsoft.Sharepoint.WebControls.UploadMenu" class.

So, to implement the custom "Upload" page you need to subclass the standard "UploadMenu" class and render your own page.

The detailed description and code snippet can be found in this post

Friday, 02 October 2009 06:03

Q#13: How to package and move SPD WorkFlow

Written by

Question:

>> How can I deploy SPD Workflow from Dev to prod

Answer:

Unfortunatelly, SharePoint designer workflows are not portable by default. There are several OOB activities that come with SharePoint itself that are used by SharePoint Designer Workflow. These activities when serialized to XOML (the temporary file is generated by SPD when you create new WorkFlow), store GUIDS to lists itself instead of ‘pointers’ to list, or any other indirection or that matter. And here is the problem -  List IDs are generated each time a list is instantiated the XOML workflows aren’t reusable, since they will most likely point to non existing lists.

The detailed process of what happens in backgroup when you start new WorkFlow via SPD is described in that post.

The solution is to use Visual Studio WorkFlow, because they don't have such an issue. Or, if you still need to move the SPD WorkFlows you can do the following trick described in this post

Question:

>> Can we create a Minimal Master page in WSS 3.0, not MOSS? 

Answer:

There are no official information how to create minimal master page for WSS. Microsoft published article for MOSS only http://msdn.microsoft.com/en-us/library/aa660698.aspx, and this master page is not supported for WSS due to specific MOSS controls and paths.

Usually, when you create WSS master page you use that MOSS guideline, and then start fixing erros removing/replacing the controls that doesn't exist in MOSS.

There are couple of post, where you can find already minimalistic master page for the WSS:

  1. http://www.heathersolomon.com/blog/articles/BaseMasterPages.aspx (collaborative section)
  2. http://www.thesharepointpeople.com/blog/Lists/Posts/Post.aspx?ID=6

Question:

>> I am trying to export a list to excel, but the "assigned to" column does not export. I suspect it is because there are multiple selections, but I don't know how to fix this

Answer:

This is a known issue for Excel 2003, because excel doesn't support importing columns with the multiple selection. Unfortunately, there is now fix as I know, and the only way to make such export is to use Excel 2007 and above.

Monday, 20 July 2009 10:52

Q#10: What are the limitations of SSP?!

Written by

Question:

>> What are the limitations of SSP?!

Answer:

The major disadvantage of SSP in its architecture, when you configure SSP services and all Web Applications are linked to SSP and services, even if these services are not used by that Web Application. Such situation creates overheading of SSP services.

You also can't link one or any SSP service to specific Web Application - only create new SSP for this purposes

Question:

>> How to find out the content DB name for one site collection when there are multi content DBs under one application

Answer:

The easiest way to find the content DB for a site is to install Microsoft SharePoint Administration Toolkit and then navigate to the "Central Administration --> Application Management --> Move, Lock and Delete Site Collections", where you can find the content DB names for your sites

 

Page 1 of 2