Yanling's Blog

Toggle Ribbon with JQuery

2011-12-14T16:28:00.001-05:00

To toggle 2010's ribbon neat and short:

Reference JQuery:
<script src="/sites/inet/_js/jquery-1.4.4.min.js" type="text/ecmascript"></script>
Put this either in a separate .js and reference the js file:
$(document).ready(function(){
    $('#s4-ribbonrow').hide();
    $('#toggleribbon').click(function() {
         $('#s4-ribbonrow').toggle();
    });
});

Put this some where. This is what you will click to toggle the ribbon:
<img id="toggleribbon" src="/../../images/imgToggle.jpg"/>

Custom form did not stick to list

2011-11-23T11:42:00.001-05:00

A site owner customized a new form for a list. He then went into SharePoint Designer and went to list properties to set the form as the 'new item form'. When he clicked OK, the setting did not seem to be saved and reverted back to the original newform.aspx.

Solution: Under 'List Properties' -> 'Supporting Files' (4th tab), make sure the second drop down 'Content type specific forms' is set to 'item', then go and select the new customized form:

Cannot connect to sql express 2008, server doesn't support requested protocol

2011-11-16T14:39:00.001-05:00

Got the following error:

Need to enable TCP/IP on Sql Server Configuration Manager:

Once TCP/IP is enabled, restart the SQL Instance:

Now connecting from VS 2010 works.

Hide left nav

2011-11-14T16:00:00.001-05:00

Hiding the left nav:

<script type="text/javascript">
$(document).ready(function(){
$("#s4-leftpanel").addClass("hide");
$("#MSO_ContentTable").css("margin-left", "-10px"); //adjust for the margin
});
</script>

The css:
.hide{
display:none;
}

Add Left Nav to new page

2011-11-02T15:08:00.005-04:00

1. Open the page in SharePoint Designer 2010.

2. Go to the 'style' tab in the ribbon, on the 'master page' section, click on 'Attach' and attach the custom (or default) master page:

3. Afterwards, you should see something like this:

The place holder for left nav:

4. Select the PlaceHolderleftNavBar, click on the arrow and select 'Default to Master's content'. The page should now show the left nav:

SharePoint 2010 branding: webpart

2011-10-18T10:54:00.002-04:00

A really nice article on rounding corners for the webpart:
https://www.nothingbutsharepoint.com/sites/eusp/Pages/web-part-style-in-sharepoint-2010.aspx

SharePoint 2010 branding: keep title area visible

2011-10-18T09:20:00.000-04:00

To keep the title area visible when clicking on the ribbon commands, modify #s4-titlerow in the css to:

#s4-titlerow {  
    display: block !important;  
}

SharePoint 2010 branding: left nav accordion, highlight location

2011-10-17T16:17:00.001-04:00

Collapse/expandable left nav:
$(document).ready(function() {
$("#s4-leftpanel-content ul.root>li.static").css("border-bottom","1px Solid #eaeaea");

$("div.s4-ql div.menu-vertical > ul.root > li.static >a").each(function()
{
    // Does this have children UL elements
     if($(this).parent().children("ul").size() > 0){

   //initial load hide
   $(">ul", $(this).parent()).hide();
   $($(this).parent()).addClass("cssClosed");

   $("div.menu-vertical>ul.root>li.static>ul.static>li.selected").parent().css("display", "block");
   $("div.menu-vertical>ul.root>li.static>ul.static>li.selected").parent().parent().addClass("cssOpen");

   //add toggle
   $(this).toggle(function() {
    $(">ul", $(this).parent()).show("slow");
    $($(this).parent()).removeClass("cssClosed");
    $($(this).parent()).addClass("cssOpen");

     },
     function() {
    $(">ul", $(this).parent()).hide("slow");
    $($(this).parent()).removeClass("cssOpen");
    $($(this).parent()).addClass("cssClosed");
     }
   );

  }
});

});

The css:
.cssClosed {
background:url('/_layouts/images/Menu-right.gif') no-repeat 160px 7px;
}
.cssOpen{
background:url('/_layouts/images/Menu2.gif') no-repeat 150px 7px;
}

The result (closed):

The result (opened):

Result selected:

SharePoint 2010 branding: left nav 2

2011-10-17T15:28:00.000-04:00

From:

to:

Css modification:
Modify:
.s4-ql,.s4-specialNavLinkList{
list-style-type:none;
margin:0px 0px 20px 0px;
padding:0px;
}

to:.s4-ql,.s4-specialNavLinkList{
list-style-type:none;
margin:0px 0px 5px 0px; /*space between recycle bin and lists*/
padding:0px;
}

SharePoint branding: left nav

2011-10-17T15:18:00.000-04:00

To minimize the space between the left nav headings and the below links, update this style:

.s4-ql ul.root ul{
margin:0px 0px 20px 0px;
padding-left:0px;
}

to

.s4-ql ul.root ul{
margin:0px 0px 0px 0px;
padding-left:0px;
}

Page will change from:

SharePoint 2010 customization: trouble getting rid of right border

2011-10-12T15:24:00.000-04:00

After the page is being centered, it leaves a right border at 100% width on this element:
div id="s4-bodyContainer"

After much digging and somehow removing this style:
body #s4-workspace{
overflow-y:scroll;
overflow-x:auto;
position:relative;
left:0px;
}

html inspector will show:
div class="s4-pr s4-notdlg s4-titlerowhidetitle ms-titlerowborder" id="s4-titlerow" style="width: 1595px;"

note: the ms-titlerowborder was not showing before.

go to ms-titlerowborder in the stylesheet, remove the right border and viola! No more right border hanging by itself!

changes in the masterpage didn't show

2011-10-05T14:21:00.000-04:00

Site owner reported that she was not able to get rid of the site title. She doesn't see the title, but others are still seeing it.

Solution: It happened that the default.master page was also keeping minor versions. Go to the master page gallery and publish a major version so the changes will show for all users.

Separating radio button selections into another row in SharePoint

2011-05-19T15:02:00.003-04:00

Came across an interesting problem when an user requirement is to separate the radio buttons into two different rows in a form. Plus attaching some click events to both selections. It took me about 15 mins or so to figure out but I thought it was interesting. SharePoint renders the radio buttons together as something like this:

<SharePoint:FormField runat="server" id="ff2{$Pos}" controlmode="New" fieldname="No_x0020_Knowledge" __designer:bind="{ddwrt:DataBind('i',concat('ff2',$Pos),'Value','ValueChanged','ID',ddwrt:EscapeDelims(string(@ID)),'@No_x0020_Knowledge')}" />

You can't simply move one as you would if you are using html. Thankfully, a little jQuery and a little css comes to the rescue. The solution is actually a real simple one. BTW, I did tried using just jQuery to move the the 2nd radio button down but the attached click event was lost somehow.

On to the solution. If you have a field with selections 'A' and 'B', you want to move 'B' to the next row, the jQuery line:

$("span[title='B']").addClass('positionB');

of course the css:

.positionB{
position:absolute;
left:23;
top:355;
}

The after effect:

The attached events for each radio button also worked. You would need to update the left and top positions to fit your needs though.

access denied when clicking on an item with read access

2011-02-28T13:37:00.003-05:00

Problem: In SharePoint 2007, user sees a list on the home page, the list of items are pull from an ordinary list. User clicks on any item on that list and gets access denied. Checked that authenticated users indeed have read access.

Solution: In the permission level, checked the 'read' permission, make sure the 'view application pages' is checked.

User get access denied with Excel services

2011-02-08T14:45:00.003-05:00

Even though trusted location was setup in excel services, with the trust children checked.

Turns out the there is a difference between http://url/ and http://url.com/ etc. Trusted location has to be config with both.

problem: multi text fields don't align on newform

2011-01-13T09:45:00.002-05:00

Solution: on list settings, reset the number of lines on one/both fields to another number.

Update topnav "home" tab to contain default.aspx

2010-10-18T09:40:00.001-04:00

go to all site settings and update the welcome page to contain default.aspx. view source will show that the site now has home tab as /sites/test/default.aspx.

SharePoint local breadcrumb not showing

2010-06-17T11:30:00.001-04:00

Problem: using the same master page, the local breadcrumb shows on some pages but not other sites/pages.

Upon digging, the no breadcrumb pages are in a folder instead of a doc library. Moving those pages to a doc lib and problem was solved.

Breadcrumb shows wrong url for a list

2010-04-01T09:25:00.002-04:00

Came across this problem when i went in the list settings, the url on the breadcrumb shows the url of the web app instead of the url to the list itself.

Solution: it turns out on the list properties, it's missing the default view page. Go to SharePoint Designer, right click on the list to bring up the properties, under 'Supporting Files' tab, select the 'default view page'.

Workflow showed 'stopped' for some users

2010-02-12T16:13:00.003-05:00

I have a SPD workflow with a lookup to assigned to groups. The workflow will send send an email to the group and assign tasks to the gorup etc. For some users (all site col admins, WF runs w/o problems). For normal contributors, the workflow shows stopped after entering a record.

Solution: This is permission related. The user has to be able to see the group memberships. Go to 'site settings' -> 'People and Groups', go to each group and go to Group Settings to switch the 'Who can view the membership of the group?' to Everyone. The workflow will start the next time you enter a record.

Filter between two dates using the DataView and jQuery

2010-02-08T14:12:00.018-05:00

This is the second round of filtering between dates in a SharePoint DataView. With this version, you do not need to be using the filters from the Enterprise version. (I am using the Standard version for now so was forced to get this working....)

Step by Step Instructions:
1. Using SPD, create an asp.net page. Add in the web part to be filtered to the page.

2. Add 4 asp.net controls. I named them txtDate1, txtDate2 and alttxtDate1, alttxtDate2. Feel free to choose your own. Note: thanks to the views below, the txtDate1 and txtDate2 asp.net textboxes have to have the AutoPostBack attribute set to true. We will hide the latter two. (Now the reason for the latter two fields: After some digging, the filter takes the dates formatted as yy-mm-dd. We are in the US so we don’t want to display the date like this. Thus the use of alternate fields to pass in for processing, but display we’ll see the good display. >.< )

From Date:

<asp:TextBox runat="server" AutoPostBack="true" id="txtDate1" CssClass="right">
</asp:TextBox>
<asp:TextBox runat="server" id="alttxtDate1" CssClass="invis"/>

To Date:

<asp:TextBox runat="server" id="txtDate2" AutoPostBack="True" CssClass="right"></asp:TextBox>

<asp:TextBox runat="server" id="alttxtDate2" CssClass="invis"/>

3. Select the WebPart and convert it to XSLT dataview. We will filter using the two dates on the dataview.

4. Setup the dataview parameters:

5. Setup the filter on the DataView using the parameters from step 4:

6. Add the jquery stuff to make it work:
<link rel="stylesheet" href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.7.2/themes/ui-lightness/jquery-ui.css"
type="text/css" media="all" />

<script type="text/javascript">

if(typeof jQuery=='undefined'){

var jQPath="http://ajax.googleapis.com/ajax/libs/jquery/1.3.1/";

document.write('<script src="',jQPath,'jquery.min.js" type="text/javascript"><\/script>');

}

</script>

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.7.2/jquery-ui.min.js"></script>

<SCRIPT type=text/javascript>

$(function() {

$("#txtDate1").datepicker({altField: '#alttxtDate1', altFormat: 'yy-mm-dd'});

$("#txtDate2").datepicker({altField: '#alttxtDate2', altFormat: 'yy-mm-dd'});

});
</SCRIPT>

7. Result:

8. Of course, hide the latter two alt controls:
<style type="text/css">

.invis{

visibility:hidden;

width:30px;

}

</style>

and....Done!

Note: this could be extended to more filters. Just modify the DataView filters criteria....

infopath form quick note

2009-08-14T16:10:00.002-04:00

Note: When a form has a dropdown from a reference list in SharePoint, changing the values of the reference list does NOT change the selected values in the existing forms....which is an excellent thing.

SSRS integration with MOSS notes

2009-08-14T15:56:00.002-04:00

Some quick notes on integrating SSRS with MOSS. Using Sql 2005 SP2.

1. Configure Report Services BEFORE installing the add-in.
2. Must use the Reporting Services Configuration tool in Sql to configure the virtual directory. DO NOT use IIS.
3. If don't see the Reporting Services section in CA after installing the add-in, check and see if the Reporting Services site collection feature is enabled in the CA. Must login as a site collection admin for the CA to see this section.

Cannot delete content type from list

2009-04-30T14:45:00.002-04:00

Problem: Added in a content type to a list and it's not letting me delete it. Says content type in use.

Soln: Modify the view of the list and see which item is using the content type. (Check the 'content type' column to have it in the view.) Then change the content type to some other one (perhaps 'Document'). After all the items are changed to a different content type, you can then delete the one that says in use.

Alerts setup findings

2009-04-03T10:40:00.003-04:00

For users to see their own alerts on "My Settings", they must have at least READ access.

With READ access, they see the "alert me", but when they click on "alert me", it gives "access denied".

With anonymous access turned on, everyone can read. However, if user is not in read access category, user will NOT get the alert.

Generate Unique ID for InfoPath form

2009-03-24T09:57:00.003-04:00

We are going to generate a Unique ID for each InfoPath form using a SharePoint list. We will then use this ID as the unique filename.
1. Create a SharePoint list with a key column:

2. Each time we load the InfoPath form, we will grab the key and then increment the key by 1:
XPathNavigator xNav = MainDataSource.CreateNavigator();

XPathNavigator nodeTermid = xNav.SelectSingleNode("my:myFields/my:TermID",
NamespaceManager);

if (nodeTermid.InnerXml == "0")
{

string termid = getTermID();
nodeTermid.SetValue(termid);
….
}

private string getTermID()
{
string termSite = ConfigurationManager.AppSettings["url_termsite"].ToString();
string termIDListName = ConfigurationManager.AppSettings["list_termid"].ToString();
string termIDKey = string.Empty;

SPSite mysite = null;
SPWeb site = null;

try
{
mysite = new SPSite(termSite);
site = mysite.RootWeb;
site.AllowUnsafeUpdates = true;

SPList list = site.Lists[termIDListName];

SPQuery query = new SPQuery();
string queryText = "<Where><Eq><FieldRef Name='{0}'" +
"/><Value Type='Text'>{1}</Value></Eq></Where>";

queryText = string.Format(queryText, "Title", "termid");

query.Query = queryText;

SPListItemCollection results = list.GetItems(query);
foreach (SPListItem item in results)
{
termIDKey = item["key"].ToString();
}

int newID = Convert.ToInt32(termIDKey) + 1;

UpdateFieldValues(termIDListName, "key", newID.ToString(), "Title", "termid");

return termIDKey;
}
catch (Exception ex)
{

throw ex;
}
finally
{
if (mysite != null) mysite.Dispose();
if (site != null) site.Dispose();
}
}

public static void UpdateFieldValues(string listName, string attribute, string attrValue,
string filterField, string filterValue)
{
SPSite mysite = null;
SPWeb site = null;

try
{

mysite = new SPSite(ConfigurationManager.AppSettings["url_termsite"].ToString());
site = mysite.RootWeb;
site.AllowUnsafeUpdates = true;

SPList list = site.Lists[listName];

SPQuery query = new SPQuery();
string queryText = "<Where><Eq><FieldRef Name='{0}'" +
"/><Value Type='Text'>{1}</Value></Eq></Where>";

queryText = string.Format(queryText, filterField, filterValue);

query.Query = queryText;

SPListItemCollection results = list.GetItems(query);
foreach (SPListItem item in results)
{

item[attribute] = attrValue;
item.UpdateOverwriteVersion();
}

}
catch (Exception ex)
{
throw ex;
}
finally
{
if (mysite != null) mysite.Dispose();
if (site != null) site.Dispose();
}
}

Outlook 2007 not rendering external/internet images

2009-02-10T15:40:00.005-05:00

Ran into this problem when working on Alerts for blog sites. The alert renders images that are stored in the intranet, but not from internet sites.

Solution: As suspected, it was my Outlook 2007 settings. To fix, go to Tools -> Trust Center

UNCHECK the "Don't download pictures automatically in HTML e-mail messages or RSS Items"

Switching application pools, site not rendering correctly

2009-02-10T13:52:00.003-05:00

This is an easy one, but might take some people sometime to figure out.

Problem: The admin run into an problem today when switching an application pool for a site. The site was not rendered correctly once switched to the new application pool and with the old one stopped. Upon taking a look, all the images were not showing.

Solution: Make sure the 'images', along with all other applications (virtural directories) are using the same app pool. In this case, the new app pool.

Don't see the style library in the newly created team site

2009-02-05T12:21:00.004-05:00

If you don't see the style library, you have to activate the publishing features.

In site collection features, activate

Then in the site features, activate

"Cannot evaluate expression because the code of the current method is optimized"

2008-12-05T11:19:00.001-05:00

While trying to debug, came across this error on items on the watch list: "Cannot evaluate expression because the code of the current method is optimized". Non of the parameters can be 'watched'.

Steps to resolve:
1. Check if the code is really optimized on Project Properties. Also check if debug mode is 'Release'. If those checks are done and still get the same message, go to step 2.
2. Check the config mgr (drop down on the menu somewhere in the center). make sure it says 'debug' and not 'release'.

Filter between two dates (date range) with the Data view Webpart

2008-11-04T10:19:00.009-05:00

To filter a date range in sharepoint:

1. What you need on a page:

a. 2 Date Filter webparts
b. 1 list to be filtered

2. Open the page w/ SPD, convert the list to be filtered to DataView (Convert to DataView will give you a lot more columns to choose in the DataView’s Filter critiera, as oppose to going to Insert->Sharepoint Controls->DataView. However, you will still not see a ‘[StartDate]’ and ‘[EndDate]’ when you go to Filter on the DataView's 'Common Date View Tasks'.

3. Now it's time to create the 'StartDate' and 'EndDate' parameters:
Under the DataView's 'Common Date View Tasks', choose Filter, click on the 'Click here to add a phase', scroll down and click on 'Create a new parameter'

4. Now we are ready to configure the filter for the Date View:

5. In the code view, you should see the newly added parameters:

<ParameterBinding Name="StartDate" Location="QueryString(StartDate)" DefaultValue=""/>
<ParameterBinding Name="EndDate" Location="QueryString(EndDate)" DefaultValue=""/>

6. Now we need to setup the connections from the DataView so it knows where to get the data for the parameters. Click on the little arrow for ‘Common Dataview tasks’, go to webpart connections (Note: makes sure you choose the ‘Get Parameters From’)

When done going through the Web part Connections Wizard, you should see something like this:

7. Almost done. Now go to the browser and edit page. Click on the date filters to connect the webparts. The Data needs to know where to get the filter values. Even though the connections were setup from the DataView, you still have to setup the filter fields from the Date Filters. Note the consumer field name is the parameter we setup earlier. Do the same for each date filter, one for the 'StartDate' parameter, one for the 'EndDate' parameter.

8. Done. Final result could be something like this:

Cannot find wss feature.xml snippet...

2008-10-28T13:12:00.002-04:00

To get the snippet for wss workflows:

Using the Code Snippet Manager (if not seen, Ctrl-K, B or Tools -> Customize -> Commands, Tools, drag the Code Snippet Manager to the Tools menu), add c:\program files\microsoft visual studio 8\xml\1033\snippets\Windows SharepointServices Workflow to get the deployment xmls for the workflow (feature.xml, workflow.xml etc).

SmartPart: could not load

2008-10-27T16:31:00.003-04:00

Problem: After adding a SmartPart on a webpart page, go to select a user control in the dropdwn of the tool pane, some user controls show 'Could not load '.

Soln: Select the user control anyway and click 'Apply', this would provided a detailed error message as to what's wrong. If there is a missing assembly reference (if the UC references it, but missing from web.config etc), then add the assembly reference to the web.config.

SPD does not open file

2008-10-24T23:15:00.003-04:00

Installed a fresh copy of Sharepoint Designer on a new VM. Connect to the site with no problem. See all the files. However, when double-clicking to open a file, NOTHING HAPPENS! Very intruging.

Soln: Must activate the copy of SPD! They are not kidding when they say 'some features are not available'....why not just say 'you can't open the files unless you activate the software' or 'you need to activate NOW'....duh

Allow anonymous

2008-10-23T21:32:00.000-04:00

To enable anonymous to a moss site:

First enable it on Central Admin -> Application Management -> Authentication Providers, choose the zone, check 'Enable anonymous access'. This does not yet allow an anonymous user to the site itself though. Must also ALLOW anonymous on the site itself: Site Settings -> People and Groups, on the left nav choose 'Site Permissions'. On the Permissions list, 'Settings' -> Anonymous Access, choose the 'Entire Web Site' radio botton....

Take out the need for approval before publishing page

2008-10-22T10:52:00.000-04:00

Just messing around with the Publishing Portal on my local VM. I decided I don't need to approval my own changes so I decided to take out the approval feature:

Go to the 'Pages' document library -> Document Lirary Settings, remove the workflow. Now there is a 'Publish' button when i going back to the page I was working on.

infopath dataconnection: AllowOverWrite="0"

2008-04-16T12:16:00.000-04:00

If you don't allow overwrite of the form with the same name, it would cause an error 'an error occurred while submitting the form' if there exists an infopath form of the same name.

Soln: use the now() function to make the filename unique. cheesy but a quick fix if you don't care about the name.

After updating Infopath Browser Enabled Form Template, new field became read-only on old/existing forms

2008-03-12T17:34:00.000-04:00

Problem: After updating Infopath Browser Enabled Form, the newly added field became read-only on old forms. If you open the existing forms in notepad, you will not see your new field in the xml.

Soln: This happens when you choose 'Do nothing' on version upgrade. To make the fields selectable/editable, republish the form with the following options. Go to Tools -> Form Options -> Versioning -> On version upgrade, choose "Automatically upgrade existing forms". Once the new version is uploaded in Central Admin, go back to your old forms, you should see your new fields as editable.

Moss - importing profiles from Active Directory

2008-03-05T15:19:00.000-05:00

While trying to configure import user profiles from AD, encountered the following warning message:

'This directory service setting has not been validated because the current user is not authenticated to the directory. It may be a valid setting. Do you want to save this directory service connection setting?'

This could happen when in configurating the Import Connection, 'Use Default Account' is selected. This default account refers to the application pool account. If this is a local account user profiles cannot be imported. In the Authentication Information section in the bottom of the Edit Connection page, click 'Specify Account' and specify a domain account. Go back to the 'User Profiles and Properties' page and 'Start full import'.

Message: Cannot open log for source 'ExceptionManagerInternalException'. You may not have write access.

2008-02-04T17:05:00.001-05:00

Message: Cannot open log for source 'ExceptionManagerInternalException'. You may not have write access.

Came across this message when trying to write to the event log using Microsoft.ApplicationBlocks.ExceptionManagement.dll in the Infopath (IFS) form codebehind. However, if you are an administrator of the box (web server where this is running on), you won't have a problem writing to the event log. Since we cannot grant all users administrator rights, that option is out.

Solution: by default, a sharepoint site uses impersonation. Use the SPSecurity class:

SPSecurity.RunWithElevatedPrivileges(delegate()
{
ExceptionManager.Publish(ex);

});

As a side note, do not mess with the existing settings in web.config of the sharepoint site. Taking out impersonate="true" messed up our BDC and other things....

Infopath Submit Error

2008-02-04T17:00:00.000-05:00

Came across this error today while trying to use ExceptionManager to write to the eventlog:
Message: The form cannot be submitted to the following location: http://d7014yleimoss:2007/Investments/10118.xml. There is a problem with the Web server. Make sure the Web server exists, try again later or contact the Web server administrator.

Happily this didn't take me time to figure out.

Solution: The user role was created to be able to submit the form, BUT the user was not granted 'contribute' access to to the Forms Library 'Investments'. Grant the logon user the 'contribute' access in the Forms Library Settings and the form submitted successfully.

BDC authentication RevertToSelf

2008-01-07T16:52:00.000-05:00

Recently there is a case where we need to use BDC to generate some views from our sqlserver database. We have a database with a sqlserver serviceID. However, we do not want to setup SSO. One of the developers is supposed to provide a solution to this view since I was on vacation. He used Passthrough as the AuthenticationMode in the BDC application definition. However, that is not a viable solution considering we have no access to the database and we do NOT want to keep adding IDs to the database, adds an extra step to maintenance. (It actually pisses me off to some extend since he didn't even bother to figure out a workable solution for our particular environment.)

Anyhoo, using RevertToSelf would work in our particular case. In the RevertToSelf scenario, the BDC will be using the application pool account to reach out to the database. We only have to give access to this one account in the database. Saved us a lot of time. In addition to putting this ID for access to the database, this ID also needs access to the BDC Entity on the SSP page (SSP > Business Data Catalog Applications > YourLOBSystem > YourView > Manage Permissions). Also noticed that other domain IDs that try to access the BDC list webpart also needs to have their IDs here! ...

This form template is browser-compatible, but it cannot be browser-enabled on the selected site !!!

2008-01-03T15:08:00.000-05:00

Get error:
This form template is browser-compatible, but it cannot be browser-enabled on the selected site
when trying to published a full-trust infopath browser enabled form.

Soln: must activate Office SharePoint Server Enterprise Site Collection features
(Features such as the business data catalog, forms services, and Excel Services, included in the Office SharePoint Server Enterprise License) from the Central Admin site also, besides the site feature and site collection that you are publishing to

Central Administration > Site Settings > Site Features
activate Office SharePoint Server Enterprise Site Collection features

MOSS AAM - Need Redirecting to alternate url (but same page!)

2007-11-08T12:02:00.001-05:00

Problem: We had a moss site of , added alternative access mapping (AAM) so collegues of other countries can view the pages. The changed in url messed up the infopath browser-enabled forms that was on the old site. errors could be prompting you to save the form or saying the form has been closed. However, forms will open and work well on the new url.

Soln: To prevent users from using the old url, we had to do a redirect like so on the same default.aspx page:

<asp:Content ContentPlaceHolderId="PlaceHolderAdditionalPageHead" runat="server">
<META Name="CollaborationServer" Content="SharePoint Team Web Site">

<script type="text/javascript">

//add here:
var url = window.location.href;
if(url.search(/servername:1234/i) != -1){
window.location="http://servername.co.com:1234/default.aspx";
}
//
var navBarHelpOverrideKey = "wssmain";
</script>

</asp:Content>

access denied going to newly created sharepoint (moss) site

2007-11-06T13:32:00.000-05:00

Encountered this problem:

Created a moss site using host header (http://intranet.machinename.com), created site collection of / and /sites/hr. tried to logon but kept getting prompted. no matter what id used, access always denied.

Soln: to to Central Administration, Application Management, Authentication Providers, click on zone, make sure IIS Authentication Settings is set to NTLM (was kerberos!).

Infopath form upload, stuck on installing, upgrading etc

2007-10-30T16:17:00.000-04:00

Problem: This is a new issue that suddently happened after I published a form with databinding issues (trying to use dynamic links). After going to 'Manage Form Templates' in Central Administration, Application Management, the form is stucked on upgrading. Checked Operations -> Timer job definitions, and status, try to delete the job and redo to no avail.

Solution: C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN>stsadm.exe -o execadmsvcjobs

Infopath browser form - test from client, doesn't see properties show up on sharepoint list/library

2007-10-30T16:12:00.000-04:00

Problem: when testing from the client with the infopath form, submitting to sharepoint library, only see the name column, none of the properties seemed to be populated/promoted. On the repair documents/relink documents page, shows up as the 'Form' content type instead of the 'Investment' content type. (Investment is the content type of the published form.)

Soln: Steps to resolve: check the site content type, make sure the default content type is Investment, not Form. Reset IIS, resubmit from client should see the properties.

When deploying to .net 2.0 web application project to production, looks for .cs file

2007-07-05T11:21:00.000-04:00

Problem: when deploying to production, the web application is looking for the .cs file after the cs files were deleted. The cs files should have been wrapped in the assembly but didn't.
Solution: Codefile was specified in the directive. Use 'Codebehind' instead. Codebehind should have been converted automatically when you convert the website to a Web Application. Somehow if it didn't, it will look for the codefile specified.

VM Guest OS takes forever to load

2007-06-26T11:18:00.001-04:00

Problem: VM Workstation comes up fast, however, the Guest OS took forever to come up. ~ 18 mins!

Solution: check the memory usage on the menu (VM --> Settings). Make sure the setting is at the recommended memory. Do not go beyond the 'Maximum recommended memory.' They are not kidding when they say 'Memory swapping may occur beyond this size').

Renaming file with local resource (multi-langual)

2007-06-18T15:35:00.000-04:00

After renaming a multi-langual file that contains local/global resources, translation won't come through - always resort to one language.

Solution: Open the page and switch to designer. Rebuild.

Programmatically setting anonymous access to a list

2007-06-13T09:38:00.000-04:00

To programmatically turn on anonymous access to a list: http://www.u2u.info/Blogs/Patrick/Lists/Posts/Post.aspx?ID=876

'-------------
Dim web As SPWeb = New SPSite("http://").OpenWeb()
Dim list As SPList = web.Lists("")
list.AnonymousPermMask = sprights.ViewListItems | sprights.OpenWeb |
sprights.ViewPages
'-------------

For disable the anonymous on your list, you only need to specify the
SPRights.EmptyMask to the AnonymousPermMask Property.
list.AnonymousPermMask = SPRights.EmptyMask

You do not have permissions to open this file on Excel Services. Make sure that the file is in an Excel Services trusted location ....

2007-05-07T15:53:00.001-04:00

Error:

You do not have permissions to open this file on Excel Services. Make sure that the file is in an Excel Services trusted location and that you have access to the file.

Sln: Trusted Locations is not configured properly. Make sure the full URL of the FILE to be trust is not put in as the Address. Use http://<server>/<folder> instead.

'Service Unavailable' after iisreset

2007-05-07T14:37:00.000-04:00

Soln: Need to update the password on the application pool the site is using.

Problem Converting Ajax files to .Net Web Application

2007-04-27T14:55:00.000-04:00

So, I was toying with Ajax recently.

Here's the problem of the day:
When trying to convert VS2005 website to a VS2005 web application with some files having Ajax controls, I ran into this error:

Generation of designer file failed: unknown server tag 'asp:ScriptManager'

Checked web.config, even though for sure I configured ajax correctly, otherwise how was I able to run the VS2005 website without problems?! Sure enough, configured correctly with:

<controls>
<add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
</controls>

However, page still throws error the same error when I tried to convert to web app...

Added System.Web.Extensions to References. Same error.

Googled: found this post:
http://mcosier.blogspot.com/2006/12/element-scriptmanager-is-not-known.html

Didn't fix the problem still!

After puzzling for a bit, I got creative. I copied the old .aspx.designer.cs file over from an old version (before the ajax stuff), added in the controls that I used:
protected System.Web.UI.UpdatePanel UpdatePanel1;

and...viola! Rebuild and error went away! It had nothing to do w/ not recognizing the ScriptManager! How misleading!