Colligo Contributor is awesome
- Offline access to your SharePoint data
- Very useful as a public folder to SharePoint library migration tool
- Adds missing SharePoint functionality in Outlook
May 2008 Archives
Well what'dya know. This keeps cropping up its ugly little head. Since the advent of SP2 for Windows Server 2003, the Network Salability Pack (and TCP Chimney size, etc.) seems to be causing more and more 'intermittent network problems', for Windows Server, SBS and I've seen it with SQL as well.
Sure enough, Microsoft patch 948496 'disables' this and is part of the critical patch set (yeesh, I thought it was learned through service pack 2 of Windows NT that introducing new features in a service pack was a bad idea, yet here we are again). You can download the patch here (with caution, see below re: MOSS).
http://support.microsoft.com/kb/936594
Lots of symptoms (but be cautious, there are several reports that this breaks MOSS 2007, although I've yet to personally verify/experience this):
- When you try to connect to the server by using a VPN connection, you receive the following error message: Error 800: Unable to establish connection.
- You cannot create a Remote Desktop Protocol (RDP) connection to the server.
- You cannot connect to shares on the server from a computer on the local area network.
- You cannot join a client computer to the domain.
- You cannot connect to Microsoft Exchange Server from a computer that is running Microsoft Outlook.
- You can only connect to Web sites that are hosted on the server or on the Internet by using a secure sockets layer (SSL) connection. In this scenario, you cannot connect to a Web site that does not use SSL encryption.
- You experience slow network performance.
- You cannot create an outgoing FTP connection from the server.
- The DHCP Server service crashes.
- Clients experience slow domain logons.
- Network Address Translation (NAT) clients that are located behind Windows SBS 2003 experience intermittent connection failures.
- You experience intermittent RPC communications failures.
- Clients that are configured as SecureNat clients may be unable to connect to the Internet.
- Some Outlook clients may be unable to connect to Exchange.
- You cannot run the Configure E-mail and Internet Connection Wizard successfully.
- Microsoft Internet Security and Acceleration (ISA) Server blocks RPC communications.
- Clients cannot visit the http://companyweb Web site.
- You cannot browse Internet Information Services (IIS) Virtual Directories.
SharePoint Dataviews - ROCK!
The BDC may be cool but it's also expensive (it's not in WSS, and in MOSS, it is only in the Enterprise product which is BIG $$).
Learned a bunch about them this week, and then learned more, by reviewing some articles presented on Microsoft's website. These were worthy of a bookmark.
More on Data View in Sharepoint Designer:
- http://office.microsoft.com/en-us/sharepointdesigner/HA101009081033.aspx
- http://office.microsoft.com/en-us/sharepointdesigner/HA100948041033.aspx
And here's a link to a filter on 'Data View' posts on the Office website.
Ok, so I've never found this information outlined clearly in one place, so I've done it.
If you want to enable incoming e-mail in SharePoint, you need to know the following:
- You need to be running MOSS 2007 (Microsoft Office SharePoint Server 2007) - the $$ version, not WSS 3.0 (Windows SharePoint Services 3.0)
- You will own be able to email enable the following list types
- Discussion Boards
- Calendars
- Document Libraries
- Announcements
Powered by www.itgroove.net
Sponsored by Major Change (.com) - The Online Change Register
I've seen quite a bit of chatter around people having difficulties importing Excel spreadsheets into WSS 3.0 (or MOSS 2007 utilizing WSS 3.0 of course). Particularly, it seems more prevalent when using Excel 2007 over Excel 2003.
There are many posts about modifying Excel macro files, etc. However, I found the solution was pretty simple, at least for me.
- Add the site you trying to import to, into your Local Intranet Sites' list
- Clear your IE cache (after/following any attempted imports and after adding to your Intranet sites list
- Be sure to use a named range in Excel (my preference anyways)
Hope that helps.
Just starting to build out this list but some good entries to start:
Demo Builder - cheaper than Adobe Captivate (by a mile) and does a good job, so linking for myself here.
Simple, Free, bookmarking it so I can find it in the future... :)
'Bout Time. But does anyone really care anymore?
itgroove announces a new focus.
It was time for a change, and while we used to label ourselves 'Your Trusted IT Advisor' (and we still are), that slogan just simply did not do our abilities and service offering justice. We are now itgroove, 'Business Technology Solutions'.
With solutions like CMS, itGuardian (we watch your technology for you) and our laser beam focus on the coolest platform ever, Microsoft SharePoint, it was time to revamp our corporate message and website. Using our new CMS (Content Management System) we have rebuilt our website to reflect our new focus. Please check out our new website at your convenience @ www.itgroove.net.
Here’s a query for listing indexes… Needed this today…
select ‘tablename’=objectname(i.id) ,i.indid ,’indexname’=i.name ,i.groupid ,’filegroup’=f.name ,’filename’=d.physicalname ,’dataspace’=s.name from sys.sysindexes i ,sys.filegroups f ,sys.databasefiles d ,sys.dataspaces s where objectproperty(i.id,’IsUserTable’) = 1 and f.dataspaceid = i.groupid and f.dataspaceid = d.dataspaceid and f.dataspaceid = s.dataspaceid order by f.name,objectname(i.id),groupid go
I'm starting to put a listing of tools together:
SharePoint Portal Server Support Report Tool (SPSReport)
This is a information gathering tool that collects logs and reports that we need to troubleshoot the issue. It will create a cab file at following location: c:\windows\spsreports\portal\rpt\cab
http://www.codeplex.com/spsreport/Release/ProjectReleases.aspx?ReleaseId=5706
Microsoft Best Practices Analyzer for Windows SharePoint Services 3.0 and the 2007 Microsoft Office System
The Microsoft Best Practices Analyzer for Windows SharePoint Services 3.0 and the 2007 Microsoft Office System Best Practices Analyzer programmatically collects settings and values from data repositories such as MS SQL, registry, metabase and performance monitor. Once collected, a set of comprehensive 'best practice' rules are applied to the topology.
Administrators running this tool will get a detailed report listing the recommendations that can be made to the environment to achieve greater performance, scalability and uptime.
