July 28, 2009

How to Import External Data into a SharePoint list using SQL Server Integration Services

Filed under: Sharepoint — Tags: , , , , , , , — Tim Lefler @ 12:51 pm

Recently I wanted to be able to take data from an external source and populate an existing SharePoint list.  The intent was to quickly get some customer data pre-loaded into the Call Center Application template available from Microsoft. For new custom lists SharePoint does this out of the box with the “Import Spreadsheet” option.

ImportSpreadsheet

Unfortunately, this doesn’t help us out for an existing list that was part of the Call Center Microsoft application template.  So I Googled around for a bit and explored options that included BDC definitions and writing custom code to interact the the SharePoint API.  It seemed so complicated.  Shouldn’t this be easier?  (more…)

July 10, 2009

Enabling SSL on an existing MOSS 2007 site

Filed under: Sharepoint — Tags: , , , , , , — Tim Lefler @ 2:53 pm

First of all you have to have DNS setup to direct your https://sharepoint.contoso.com url to the right location (duh)

Our situation is we have an existing SharePoint (MOSS) site that authenticated via kerberos.  We want to enable SSL and forms base authentication (FBA) for external entities that are not on the same active directory domain.

So to start with we need to:

  • Enable SSL on our SharePoint Site
  • Extend our existing Web Application becuase we want our FBA users to see the same content
  • Install the IIS Certificate

For this discussion lets assume external entities will be connecting to https://sharepoint.contoso.com across an intranet WAN connection. (more…)

July 1, 2009

Problems installing MOSS SP2

Filed under: Sharepoint — Tags: , , , , — Tim Lefler @ 10:09 pm

Problems after installing the Windows SharePopint Services SP2 from download updates.

First downloaded:

Downloaded Hotfix Update to prevent Expiration:  http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=3ece7285-30cd-4b62-9548-6bba63cf5d7a

Windows ShzrePoint Services SP2 from http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=79bada82-c13f-44c1-bdc1-d0447337051b

And downloaded Office SharePoint Services SP2 from: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=b7816d90-5fc6-4347-89b0-a80deb27a082

Installed the Hotfix without error.

Installed the WSS SP2 and got an error after running WSS SP2 install wizard.

sp2_error4

Error from upgrade log:

[SPManager] [INFO] [7/1/2009 4:44:15 PM]: Preparing to upgrade PersistedUpgradableObject: SearchSharedDatabase Name=BankwaySSP_Search_DB Parent=SPDatabaseServiceInstance.  This object’s current status is Online.

[SharedSearchDatabaseSequence] [ERROR] [7/1/2009 4:44:15 PM]: Upgrade object too new (build version = 12.0.6219.1000, schema version = 12.0.0.0). Current server (build version = 12.0.4518.1016, schema version = 12.0.0.0).

[SPManager] [ERROR] [7/1/2009 4:44:15 PM]: CanUpgrade [SearchSharedDatabase Parent=SPDatabaseServiceInstance] failed.

[SPManager] [ERROR] [7/1/2009 4:44:15 PM]: The specified SearchSharedDatabase Parent=SPDatabaseServiceInstance has been upgraded to a newer version of SharePoint. Please upgrade this SharePoint application server before attempting to access this object.

When trying to go to Administration site got “Server Error: http://go.microsoft.com/fwlink?LinkID=96177″sp2_error2
Hmmmm…..wizard depends on a schema version that is too new?  Maybe shouldn’t run wizard for WSS SP2 install until after run of Office SP2 Install…..

Installed the WSS SP2…canceled the Wizard and then install the Office SP2 update and it completed successfully.

Powered by WordPress