Here is the default value

Style="overflow: auto;height: 400px;width: 150px; "

Simply change it to anything you like:

Style="overflow: auto;height: 400px;width: 250px; "

Cheers
Alireza

Your backup is from a different version of Windows SharePoint Services and cannot be restored to a server running the current version. The backup file should be restored to a server with version '12.0.0.6335' or later.

It sounds like an odd error but lets face it. STSADM backups are not service-pack independent. It just reminds me of restoring SQL Server system databases. Remember that you need to have identical service packs on source and destination of the backup. Otherwise your restore shows you this.

Check this little post by Aaron Saikovski to get your exact solution.

Cheers
Alireza

 Now take a look at this course content for a change:
Architecting Web Content Management Solutions with Microsoft Office SharePoint Server 2007 

Hey, it seems like Microsoft response to this need. Or look at this one:

Architecting and Planning the Search Capability in Microsoft® Office SharePoint® Server 2007

Actually this is not a new course approach, I have delivered database modeling from Microsoft Official Curriculum 6 years ago. I only believe these courses are not marketed well simply because most of the clients see Microsoft as pure technology provider. SharePoint is a new product with new concepts around it. Consider basics before you get into the technology!

 Cheers
Alireza

Now here are the magic C# words to break the spell! Your code should automate this step.

Here are some important considerations.
1. You have 200 sites and there is no guarantee that all sites are following the same role inheritance setting. In better word some sites may inherit the roles and some don't. It is obvious that you cannot and you don't need to create this role in the sites that they inherit.
2. You have to create this role in the root website of the site collection.

Take a look at this code.

    SPWeb myWeb = mySite.AllWebs[i];
    if (myWeb.HasUniqueRoleDefinitions || myWeb.IsRootWeb)
    {
 
        try
        {
            MessageBox.Show(myWeb.Title);
            myWeb.AllowUnsafeUpdates = true;
            SPRoleDefinition rd = new SPRoleDefinition();
            rd.BasePermissions = SPBasePermissions.ManageLists |
            SPBasePermissions.CancelCheckout |

SPBasePermissions.AddListItems
| SPBasePermissions.EditListItems |

SPBasePermissions.DeleteListItems;
      rd.Name = "Custom role 01";
      myWeb.RoleDefinitions.Add(rd);
      myWeb.Update();
  }
  catch (Exception ex)
  {
            MessageBox.Show(ex.Message, myWeb.Title);
  }
}

 Don't forget to import:
using Microsoft.SharePoint;

Cheers
Alireza

  SPSite mySite = new SPSite("http://sharepoinsiteaddress");
  SPWeb myweb = mySite.OpenWeb();
  SPList myList = myweb.Lists["Announcements"];
  SPListItem myListItem = myList.GetItemById(1);
  foreach (String attachmentname in myListItem.Attachments)
  {
   String attachmentAbsoluteURL =
   myListItem.Attachments.UrlPrefix // gets the containing directory URL
   + attachmentname;

   // To get the SPSile reference to the attachment just use this code
   SPFile attachmentFile = myweb.GetFile(attachmentAbsoluteURL);

   // To read the file content simply use this code
   Stream stream = attachmentFile.OpenBinaryStream();
   StreamReader reader = new StreamReader(stream);
   String fileContent = reader.ReadToEnd();

   // assuming that file is a text attachment
   MessageBox.Show(fileContent);
  }

I think the code is self descriptive. Just some points to remember:

• Attachments collection of SPListItem object is not SPFile. It is string that only represents file name.
• Most of the time just a hyperlink to the attachment serves the purpose for the web UI design.
• I used a windows application to present this code, you may implement it in any project.
• Don't forget the required namespaces.

  • using System.IO;

  • using Microsoft.SharePoint;

Enjoy!
Alireza

 My new choice is CamStudio. It doesn't give you a fancy movie editing studio, but it happily works on Windows 2003 server loaded with MOSS 2007 and BizTalk 2006. It doesn't slow down any process and it is FREEEEEE!!! Ok, for the editing studio go for Microsoft Movie Maker and you are all set.

Cheers
Alireza

  public string RemoveTags(String originalMessage)

  {

      Regex rgx = new Regex("<[^>]*>");

      return rgx.Replace(originalMessage, "");

  }

This function simply gets an HTML/XML String and returns pure text. Don’t forget to add
using System.Text.RegularExpressions;
to your file header.
Enjoy
Alireza
 

But how this is related to SharePoint?
Remember that when you create MOSS or WSS Site collections it gives you the chance to pick a database name? Now remember when you uninstall SharePoint it doesn’t delete the databases?
Ok, here is what happens. You uninstall MOSS or delete Site Collection. Then you may think that, I may use these data in the future or for any reason database is in use and you cannot delete it so you take it off-line and then you delete and forget it while the files are still there. When you want to create another site collection or a new installation the existing files will not let you create the new database.
But why do you want to take the database off-line?
Taking the database off-line means that we don’t want anybody connect to the database anymore but we are polite enough to let the current users to the database finish their work. It doesn’t kill the existing connections and it takes some time for all the live users to finish their work and disconnect and in the meanwhile no new connection is made to the database. Usually when junior database administrators want to delete a database that there is live connection to that and they come up to related errors they try to take the database off-line, which is a good move, but do you really want to keep the current users when you want to delete what ever the data that they enter? So to drop a database simply go to SQL Server 2005 management studio and Management -> Activity Monitor. If you just double click on the activity monitor you can see a list of all the databases and existing connections to them. Simply right click on the database and kill the connection. Then you will be good to delete the database.
Cheers
Alireza

Have you seen this error before? Hah, you just noticed it? Cool! Let's see where the error is coming from.

I created two tables as Products and Sales. There is a foreign key that forces the sales table to use only valid values for ProductAbbreviation in Products table. To create a foreign key constraint I can simply run this script:

ALTER TABLE [dbo].[Sales]  WITH CHECK ADD  CONSTRAINT [FK_Sales_Products] FOREIGN KEY([ProductAbbreviation])

REFERENCES [dbo].[Products] ([Abbreviation])

GO

Here is the point. This foreign key refers to a field called Abbreviation. There is just one simple rule on this game. You cannot make a reference to a field that is not unique. In better word your foreign key can only refer to a field that has a unique constraint like Primary Key or Unique Index. Now read the error again and you can simply understand what is going on.

To have this script work you need to create a unique index on Abbreviation field in Products table or make it a primary key that guarantees uniqueness. So simply go to index management and create a unique index on that field or run this script to create it like old fashioned developers:

CREATE UNIQUE NONCLUSTERED INDEX unq_abbr ON dbo. Products

Then you can create your foreign key happily ever after.
Enjoy
Alireza

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SharePoint;

namespace StopActiveTaskDelete
{
    //Inhertit your class from SPItemEventReceiver
    public class CActiveTasksDelete: SPItemEventReceiver
    {
        // Override the ItemDeleting function. You will find also ItemDeleted
        // function that fires when the item is deleted. For your scenario we
        // need ItemDeleting to stop the delete process before it is complete.
        public override void ItemDeleting(SPItemEventProperties properties)
        {
            //Built in call to the initial definition
            base.ItemDeleting(properties);
            // Get reference to the current item being deleted
            SPListItem myItem = properties.ListItem;
            // Read the status field of the item being deleted
            String taskStatus = myItem["Status"].ToString();
           

            // Is the task status is Complete it is not active task any more
            // Otherwise we cancel the deletion
            if (taskStatus != "Completed")
            {
                // This is the message that we'd like to show to the user
                // if he/she tries to delete an active task
                properties.ErrorMessage = "This task is still in progress and cannot be deleted";
                // This line actually cancels the delete
                properties.Cancel = true;
            }
        }
    }

Sign the assembly with a strong name key and deploy it to the global assembly cache. Now all you need to do is to introduce the this assembly to a task list in SharePoint. There are different ways of doing it, but the simplest way is using a simple consol application to do so.

Your script should look like this:

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SharePoint; 

namespace RegsiterEventReceiver
{
    class Program
    {
        static void Main(string[] args)
        {
            // Get reference to the the site that containd your task list
            SPSite mySite = new SPSite("http://sharepointSiteURL");
            SPWeb myWeb = mySite.OpenWeb();
            // Get the reference to your task list
            SPList myList = myWeb.Lists["Tasks"];
            myList.EventReceivers.Add(SPEventReceiverType.ItemDeleting,
                "StopActiveTaskDelete, Version=1.0.0.0, Culture=neutral" +
                //Replace this key with your own assembly publick key token
                ", PublicKeyToken=8a1a592e4ca85c4c",
                "StopActiveTaskDelete.CActiveTasksDelete");
            // Don't forget to update the list
            myList.Update();
            // Make sure you add this life to feel good after your
            // Solution is deployed successfully
            Console.WriteLine("Haha, done!");

        }
    }
}

Now go to the SharePoint Site and try to delete an incomplete task. You will get this error page.

And this code will protect active tasks from deletion happily ever after.
Cheers
Alireza

            SPListItem myItem = properties.ListItem;
//This line detaches the item security from the list
            myItem.BreakRoleInheritance(false);
            myItem.Update();
            SPWeb myWeb = properties.OpenWeb();
// Creates an object of type SPMember to represent a group
            SPMember member = myWeb.SiteGroups["TestGroup"];
// We can simply cast a SPMember object into a SPPrincipal variable
            SPPrincipal principal = (SPPrincipal)member;
// A role definition is required to represent a permission level in SharePoint site
            SPRoleDefinition roledefinition =
                myWeb.RoleDefinitions.GetByType(SPRoleType.Contributor );
            SPRoleAssignment myRoleAssignment = new SPRoleAssignment(principal);
            myRoleAssignment.RoleDefinitionBindings.Add(roledefinition);
            myItem.RoleAssignments.Add(myRoleAssignment);
            myItem.Update();

 Enjoy the code.
Alireza

• How can I learn InfoPath tricks?
  Learning InfoPath is pretty simple. Just go to this link on msdn website. This is the best resource to let you know all the tricks about InfoPath.

• How can I learn SharePoint development?
  Don't waste time with the classes. The best resource for learning SharePoint is Microsoft e-Learning. See this lovely collections:

  • Collection 6071: Developing Solutions with Microsoft Office SharePoint Server 2007 and Visual Studio 2005

  • Collection 5404: Implementing Microsoft® Office SharePoint® Server 2007

  • Collection 5403: Implementing Microsoft® Windows® SharePoint® Services 3.0

  • Collection 5392: Developing and Extending Microsoft Windows SharePoint Services 3.0 with Visual Studio 2005

  • Collection 5385: Developing Solutions with Microsoft Windows SharePoint Services 3.0 and Visual Studio 2005

  • Collection 5266: Core Training for Windows SharePoint Services 3.0

  • Collection 3376: Implementing Enterprise Search Using Sharepoint Technologies
    To be honest I have learned more than 80% of what ever that I know about MOSS 2007 from these collections.

• How can I find resources for XML development?
   - Learn XML and XPath from www.w3schools.com for FREE
   - XPathNavigator and XMLDocument objects in .NET Framework satisfy more that 80% of your MOSS related XML programming needs and you can find good starting samples here.

• As I promised in the conference here you can download the source code for WordML access.

• The most valuable resource for anything in SharePoint is "Microsoft SharePoint Products and Technologies Team Blog" and it's worth visiting this website everyday.

• For using XML Web Services in InfoPath you can check this video that I have recorded myself. You don't need to be a developer to use this video. The sample web service is already deployed on my website. Just watch and do it yourself.

Enjoy
Alireza

• Using Excel Services to build BI solutions: I personally believe this title is not well articulated. I guess Excel Services is something that everybody should explore it personally so I am not going to completely cover features and capabilities of excel services. I will do my best to deliver the presentation so that the audience can repeat the experience themselves. This lecture will include:
  • Excel services from scratch (how to have it running from a clean installation)
  • Excel services architectural design (Data sources, trusted locations, security structure)
  • Using Excel Services to bring data from SQL Server to MOSS interface with data graphs
  • Using Excel Services to bring Analysis Services Cube data and graphs to MOSS Server
  • Excel Services and BI components (Introducing MOSS out of box and how excel services interacts with MOSS BI lists and BI Dashboard)
  • Q&A
• Building applications using MOSS 2007 web services: Don't get me wrong, this presentation is not for developers. I am targeting IT-Professionals and I am trying to keep it at 200 level. Here is my presentation outlines:
  • What is XML Web Service?
  • How can we call XML Web Services without code (I am targeting InfoPath)?
  • Introducing built-in XML Web Services in MOSS 2007.
  • Connecting XML Web Services and MOSS 2007 document libraries using InfoPath 2007 glue (Hay InfoPath 2007 glue is NOT a product name - lol).
  • How to deploy these XML Web Service containing InfoPath forms to the MOSS 2007 forms server
  • How can developers build custom Web Services to expose more MOSS features
• Office Automation using Microsoft Word 2007 and MOSS 2007: This is basically a case study around using Microsoft Word 2007 XML file that is also called WordML. This presentation is basically an open discussion around using WordML files instead of normal word files. I am just trying to explain how easy it is to utilize your basic XML Programming skills to manipulate sections of the WordML files.

I really appreciate if you spare a minute or two and give me your feedback.
Alireza

Take a look at this code:
DateTime holiday = DateTime.Parse("28/02/2008");

Sounds ok and works well on my Canadian computer (hey, it is made in China but Windows regional options is set to English(Canada)). But the very same line of code fails to run on an American machine. Simply because the American version of this code should be like this:
DateTime holiday = DateTime.Parse("02/28/2008");

That's just the date format but what can you do in a compiled code for this? Aha, .NET Framework is the answer. If you read the time variable from a Calendar or a DateTimePicker then the control is smart enough to do that, but if you are reading a preformatted string or you are hard-coding the date in your application then this issue come up. Here is the right way of solving this problem:

using System;
using System.Globalization;

namespace DotNetKing
{
    class Program
    {
        static void Main(string[] args)
        {
            CultureInfo culture = new CultureInfo("en-CA");
            DateTime holiday = DateTime.Parse("28/02/2008", culture);
            Console.Write(holiday.ToString());
        }
    }
}

This way you not only hardcode the date but also hardcode the date culture, so your code behaves Canadian even on an American server!
Cheers
Alireza

An error occurred accessing a data source.
An entry has been added to the Windows event log of the server.
Log ID:5566
 

Does it look familiar? No? How about this one?

I assume that you love it because without these errors we could never have a job as consultant. I got this error when I deployed an InfoPath 2007 form to MOSS 2007 forms server. There was nothing wrong with the form but it was getting the user information from MOSS profile to have some part of the form pre-populated. First of all when I checked the application log on the front end server I found nothing. Considering the farm installation I could find the error on the server box that was hosting the SharePoint Central Administration service. Here is the error in the application log:

A runtime exception was detected. Details follow.
Message: Access Denied! Only site admin can access Data Source object from user profile DB.

Techinal Details:
System.UnauthorizedAccessException: Access Denied! Only site admin can access Data Source object from user profile DB.
at Microsoft.Office.Server.UserProfiles.SRPSite.AdminCheck(String message)
at Microsoft.Office.Server.UserProfiles.DataSource._LoadDataSourceDef(IDataRecord rec)
at Microsoft.Office.Server.UserProfiles.DataSource._LoadDataSourceDef(String strDSName)
at Microsoft.Office.Server.UserProfiles.DataSource..ctor(SRPSite site, Boolean fAllowEveryoneRead)
at Microsoft.Office.Server.UserProfiles.DataSource..ctor(SRPSite site)
at Microsoft.Office.Server.UserProfiles.UserProfileConfigManager.GetDataSource()
at Microsoft.Office.Server.UserProfiles.BDCConnector.RefreshConfiguration(String sspName)

For more information, see Help and Support Center at

It seems that the forms server is trying to access to Profile Services on MOSS and it is complaining that Only Site Admin can do that. Here was the tricky part. On the top of the page I could see the spadmin login account. This account was site admin for MOSS, SharePoint Central administration and also Shared Services Provider site. So what else is missing?

The answer is here:
Go to SharePoint Central administration --> Application Management --> Authentication Providers. Then select the default zone. Make sure the right Web Application is selected on the top of the page. Clear the checkbox for the anonymous access. And now you can run your form with the forms server happily ever after.

Important point:
When you are using Forms Server with MOSS the site security is not applied to the underlying services. It means even if your MOSS website requires authentication, if Provider is anonymous enabled forms services uses anonymous login for the external access, because it looks at the provider, not the site that is hosting the form. It took me a long time to find it out because I had the impression that Forms Server impersonates the user login information and when I see the user ID on the top of my SharePoint page, this is not anonymous call. I was wrong.

With special thanks to Infusion SharePoint Technical team that gave me wonderful guides to resolve this issue.

 Cheers
Alireza

Remember that first version of .NET was released on February 13th, 2002.

I Wish all .NET Developers a
wonderful birthday ]]>http://www.dotnetking.com/TechnicalComments.aspx?LogID=333Feb 13, 2008  

 I had a funny problem today. On one of the client sites we were trying to enable audience targeting on a development server box and simply I couldn't find the Target Audiences box. Simply it was not there. Guess what the problem was!

Shared Service Provider was not created on the server.

Morale:

1. Please do the setup steps completely and review the Setup tasks
2. If the problem is very weird, look for some weird cause
3. When you find the cause share it with the others

It is interesting that I couldn't find any cause for this problem by searching the internet.

Cheers
Alireza

  ]]>http://www.dotnetking.com/TechnicalComments.aspx?LogID=331Feb 08, 2008  Have you ever used iFilters for PDF in MOSS? It's beautiful. You may simply download it from adobe website and install it on the MOSS Server and enjoy the enterprise content search for the PDF content. Such a sweet component becomes a pain once you'd like to upgrade to 64 bit platform, simply because  adobe iFilter it doesn't have 64 bit support.
 Last week I found Foxit PDF iFilter. It is not a free product, but $1184.93 doesn't look like an issue for a huge enterprise with 64 bit implementation of MOSS. I haven't tried it yet myself, so if you have used it before send me your feedback.

Cheers
Alireza

1. Configure a virtual PC machine with at lease 1GB memory allocated
2. Install windows 2003 Server standard edition on the virtual PC (You may also go for enterprise edition, but because of some unnecessary services on enterprise edition it will perform slower than enterprise edition while it doesn't give you anything extra for MOSS development)
3. Go to windows Control panel and Add/remove windows component:
   1. Add ASP .NET (as a result of this selection any necessary IIS component will be installed)
   2. Add local SMTP server
   3. Make sure FrontPage server extension is not selected
   4. Remove "Internet Explorer Enhanced Security Configuration". It is not a MUST, but for development environment that we need absolute freedom, it is quite annoying.
4. Install the latest service pack available for windows 2003. (it is still too early to go for windows component update)
5. Install Visual Studio .NET 2005 (Professional or VSTS) and make sure you Install C# components (VB .NET is not enough) and make sure you UNCHECK the SQL Server express edition that comes as embedded component in Visual Studio .NET.
6. Install Visual Studio .NET Service pack 1.0
7. Install .NET Framework 3.0
8. Install MOSS 2007 as stand alone installation with all default settings
9. Install "Visual Studio 2005 extensions for .NET Framework 3.0 (Windows Workflow Foundation)"
10. Install MOSS 2007 SDK
11. Install Windows SharePoint Services 3.0 Tools: Visual Studio 2005 Extensions
12. Install Microsoft Office 2007 (InfoPath, Outlook, Word, PowerPoint, Access and Excel are mandatory). You may uncheck Microsoft Publisher, Microsoft Groove and One Note.
13. Install Microsoft SharePoint designer 2007
14. Install VSTO
15. Connect the Virtual PC to Internet and run Windows Update
16. Read this and install all the components mentioned there.

Have fun
Alireza