MdP's MOSS Blog

Check out my new blog on SharePoint 2007 on the SharePoint 2007 platform:

http://www.thesug.org/blogs/MOSSMania/default.aspx

For my subscribers, update your readers, here is my new RSS Feed Url:
http://www.thesug.org/blogs/MOSSMania/_layouts/listfeed.aspx?List={3f7d7b8a-a822-409c-97ed-d4367160f6d7}

Filed under: Uncategorized

Too many certifications is never a bad thing.  I was playing around with Microsoft's logo builder after Pearson VUE finally got my microsoft profile updated, a month after I passed the tests and I noticed that if I tried to create a logo with all 4 of my WSS/MOSS certifications, I received an error telling me to remove one.  I worked hard for all four, so I would want them all displayed.

 Microsoft's site says that "Due to design and branding requirements, a logo may only display up to four or six lines."  If they moved Configuration up, that would allow for two more lines.  Also, why is MOSS 2007 Application Development on one line and WSS 3.0 Application Development is on two lines? 

On the usage guide page, it does not say that the certifcation list is limited to 4 to 6 lines, but to 4 to 6 certifcation areas:
The right side of the bar can accommodate 4-6 certification areas depending upon the credential.  I also have other problems with this since when I will go to upgrade my MCAD/MCSD, I will be getting more MCTS certs, which won't be able to be all listed together.  I still think these certifications should have been MSCS (Microsoft Sharepoint Certified Specialist) since MCSS is already taken by Microsoft Certified Security Specialist instead of MCTS.

Filed under: Uncategorized

Out of the box, the content query web part can only get items from one content type, but what happens if you want it to display items from more than one content type?  You don't have to write a custom web part to do this thanks to Microsoft adding overrides in their content query web part. 

First, build the CQWP (Content Query Web Part) with everything how you want it, including the query, then you will need to export it to a location on your drive.  To export the web part, navigate to the page that contains the web part.  Open up the page in edit mode and on that page, click on the edit drop down menu for the web part and click "Export."

Save the file locally.  Once you have exported the web part as a .webpart file, open it with notepad and edit the ListsOverride property.

If you want to get everything based on a Generic List (BaseType = 0), you would use the following property:

 <property name="ListsOverride" type="string"><![CDATA[ <Lists BaseType="0"> </Lists>]]></property>

 
If you want to get everything based on a document library (BaseType = 1), you would use the following property:

 <property name="ListsOverride" type="string"><![CDATA[ <Lists BaseType="1"> </Lists>]]></property>

 Once you have finished editting the webpart, save the file.  Now we have to import the new .webpart file.  To do this, go to "Site Actions" -> "Site Settings" -> "Modify All Site Settings" on the top level site.

 Under "Galleries", click on "Web Parts".  Now click the "Upload" button.

Click on the "Browse" button and select the .webpart file that you made changes to.

Now set all of the properties for the webpart and click "OK" when finished.

Now browse to the page you want to add the web part to.  Open up the page in edit mode and in the web part zone where you want to add the web part, click on "Add a web part" and select your new webpart and then click "Add."

How to: Customize the Content Query Web Part by using Custom Properties
http://msdn2.microsoft.com/en-us/library/aa981241.aspx

Filed under: Uncategorized

Filed under: Uncategorized

Today I learned a hard lesson.  A single letter was causing a big problem for me: The query cannot be completed because the number of lists in the query exceeded the allowable limit. For better results, limit the scope of the query to the current site or list or use a custom column index to help reduce the number of lists.MaxListsLimit vs MaxListLimit

After a while of researching, I found out that the original example that I had been using for the basis of my SPSiteDataQuery had used MaxListsLimit where MaxListLimit should have been for the Lists property of my SPSiteDataQueryI was using

"<Lists BaseType='1' MaxListsLimit='0'/>"

When what I needed was just:

"<Lists BaseType='1' MaxListLimit='0'/>"

This made the error go away as it let me search all of the lists in the entire site.  Not specifying a MaxListLimit would only search 1000 lists, but seems to throw an error if there are more than 1000 lists, instead of just searching the first 1000 that it finds.  I would recommend always using '0' if you are not sure that the client will have less than 1000 lists. 

Filed under: Uncategorized

Filed under: Uncategorized

Filed under: Uncategorized

Filed under: Uncategorized

     Guid g = {GUID};
     SPSecurity.RunWithElevatedPrivileges(delegate()
     {
         using (SPSite site = new SPSite(SPContext.Current.Site.Url))
         {
             SPSiteDataQuery query = new SPSiteDataQuery();
             query.Webs = "<Webs Scope='SiteCollection' />";
             query.Query = string.Format("<Where><Eq><FieldRef Name="UniqueId" />" +
		+ "<Value Type="Text">{0}</Value></Eq></Where>", Convert.ToString(g));
             query.RowLimit = 1;

             using (DataTable dt = site.RootWeb.GetSiteData(query))
             {
                 foreach (DataRow dr in dt.Rows)
                 {
                     Guid webId = new Guid(Convert.ToString(dr["WebID"]));
                     Guid listId = new Guid(Convert.ToString(dr["ListID"]));
                     using (SPWeb web = site.AllWebs[webId])
                     {
		          SPList list = web.Lists[listId];

		          SPListItem li = null;
		          try
		          {
		              li = list.Items[ g ];
		          }
		          catch { }
		          if (li != null)
		          {
		              // Now you have your item, do what you need to do
		          }
		          list = null;
                     }
                 }
             }
             site.RootWeb.Dispose();
         }
     });

Filed under: Uncategorized

IE7Pro is a free add-on for IE7 that finally makes up for some of IE7's flaws.  The biggest fix is the one that when IE7 crashes, which it does often, it will load your pages back in instead of closing, re-opening and taking you back to your homepage, nice!  The site also says it is compatible with IE6.

Filed under: Uncategorized