SharePoint 2007 to 2010 Help Desk Upgrade

Scenario

• You have installed the HelpDesk Fab 40 Template
• You are performing a database attach upgrade from SharePoint 2007 or WSS 3.0 to SharePoint Server or Foundation 2010 and have run test-spcontentdatabase

Issue

• The test-spcontentdatabase report contains the following errors (the cooresponding feature names have been added):
• Category        : MissingFeature - HelpDeskModules
Error           : True
UpgradeBlocking : False
Message         : Database [MOSS_ContentDB] has reference(s) to a missing featu
                  re: Id = [75a0fea7-02cb-4f87-bb11-1ffde748a953].
Remedy          : The feature with Id 75a0fea7-02cb-4f87-bb11-1ffde748a953 is r
                  eferenced in the database [MOSS_ContentDB], but is not instal
                  led on the current farm. The missing feature may cause upgrad
                  e to fail. Please install any solution which contains the fea
                  ture and restart upgrade if necessary.
• Category        : MissingFeature - HelpDeskListInstances, HelpDeskServiceRequestsList
  Error           : True
  UpgradeBlocking : False
  Message         : Database [MOSS_ContentDB] has reference(s) to a missing featu
                    re: Id = [75a0fea7-fe9d-4119-9615-2c2ef22d6fdb].
  Remedy          : The feature with Id 75a0fea7-fe9d-4119-9615-2c2ef22d6fdb is r
                    eferenced in the database [MOSS_ContentDB], but is not instal
                    led on the current farm. The missing feature may cause upgrad
                    e to fail. Please install any solution which contains the fea
                    ture and restart upgrade if necessary.
• Category        : MissingFeature - HelpDeskListInstances, KnowledgeBaseKeywordsList
  Error           : True
  UpgradeBlocking : False
  Message         : Database [MOSS_ContentDB] has reference(s) to a missing featu
                    re: Id = [75a0fea7-12fe-4cad-a1b2-525fa776c07e].
  Remedy          : The feature with Id 75a0fea7-12fe-4cad-a1b2-525fa776c07e is r
                    eferenced in the database [MOSS_ContentDB], but is not instal
                    led on the current farm. The missing feature may cause upgrad
                    e to fail. Please install any solution which contains the fea
                    ture and restart upgrade if necessary.
• Category        : MissingFeature - HelpDeskListInstances, HelpDeskTasks
  Error           : True
  UpgradeBlocking : False
  Message         : Database [MOSS_ContentDB] has reference(s) to a missing featu
                    re: Id = [75a0fea7-3b2a-4838-8a0c-57ba864feed3].
  Remedy          : The feature with Id 75a0fea7-3b2a-4838-8a0c-57ba864feed3 is r
                    eferenced in the database [MOSS_ContentDB], but is not instal
                    led on the current farm. The missing feature may cause upgrad
                    e to fail. Please install any solution which contains the fea
                    ture and restart upgrade if necessary.
• Category        : MissingFeature - HelpDeskListInstances
  Error           : True
  UpgradeBlocking : False
  Message         : Database [MOSS_ContentDB] has reference(s) to a missing featu
                    re: Id = [75a0fea7-97c5-4487-88e4-70fde8f79b25].
  Remedy          : The feature with Id 75a0fea7-97c5-4487-88e4-70fde8f79b25 is r
                    eferenced in the database [MOSS_ContentDB], but is not instal
                    led on the current farm. The missing feature may cause upgrad
                    e to fail. Please install any solution which contains the fea
                    ture and restart upgrade if necessary.
• Category        : MissingFeature - HelpDeskListInstances, HelpDeskSupportFaqList
  Error           : True
  UpgradeBlocking : False
  Message         : Database [MOSS_ContentDB] has reference(s) to a missing featu
                    re: Id = [75a0fea7-70e3-40b1-b395-c06f85d0d158].
  Remedy          : The feature with Id 75a0fea7-70e3-40b1-b395-c06f85d0d158 is r
                    eferenced in the database [MOSS_ContentDB], but is not instal
                    led on the current farm. The missing feature may cause upgrad
                    e to fail. Please install any solution which contains the fea
                    ture and restart upgrade if necessary.
• Category        : MissingFeature - HelpDeskExpertsList, HelpDeskListInstances
  Error           : True
  UpgradeBlocking : False
  Message         : Database [MOSS_ContentDB] has reference(s) to a missing featu
                    re: Id = [75a0fea7-e63b-4059-8f5a-ce9cbbadad2a].
  Remedy          : The feature with Id 75a0fea7-e63b-4059-8f5a-ce9cbbadad2a is r
                    eferenced in the database [MOSS_ContentDB], but is not instal
                    led on the current farm. The missing feature may cause upgrad
                    e to fail. Please install any solution which contains the fea
                    ture and restart upgrade if necessary.
• Category        : MissingFeature - HelpDeskListInstances
  Error           : True
  UpgradeBlocking : False
  Message         : Database [MOSS_ContentDB] has reference(s) to a missing featu
                    re: Id = [75a0fea7-d31d-491a-9177-f0e461a81e3f].
  Remedy          : The feature with Id 75a0fea7-d31d-491a-9177-f0e461a81e3f is r
                    eferenced in the database [MOSS_ContentDB], but is not instal
                    led on the current farm. The missing feature may cause upgrad
                    e to fail. Please install any solution which contains the fea
                    ture and restart upgrade if necessary
• There will also be some MissingSetupFile - Need to install messages as well.

Resolution

• The following solution is to get existing sites working.  To create new sites using the fab 40 templates, you may download and install the 2010 upgraded versions
• I would recommend starting from a blank site template to build a tailored solution instead of using these templates due to the issues we've had modifying and upgrading them
• See my earlier post on sealed columns
• The solution is to copy and then install the missing features
• Copy the erroring feature folders from the 12 hive on the 2007 server to the 14 hive on the 2010 server
• ...\12\template\features
• ...\14\template\features
• The ones we copied were: HelpDeskExpertsList, HelpDeskInIssuesList, HelpDeskListInstances, HelpDeskModules, HelpDeskServiceRequestsList, HelpDeskSupportFaqList, HelpDeskTasks, HelpLibrary 
• Install the features on the 2010 server from PowerShell (SharePoint 2010 Management Shell)
• Ex: install-spfeature -path "helpdeskservicerequestslist"
• Do this for each of the folders copied earlier

Android: Upload documents, images, list items, or metadata to SharePoint

Scenario

• You are developing an Android OS application on an Android tablet or Android phone and need to upload a document or photo to a SharePoint list or library.

Issues

• NTLM authentication is not natively supported
• SOAP protocal is difficult to implement
• REST interface is limited
• Need to batch upload multiple documents and set metadata while reducing bandwidth
• Need to thread multiple uploads

Resolution

• Kiefer Consulting, Inc. has experienced SharePoint and Mobile development teams that can help address these issues.

User Profile properties from a User or Group Column

Scenario

• You have user profile properties (Company, Role, Contact Info, etc.) in a user's SharePoint profile.  You have a People Picker (User or Group) Field in a list and select that user.  You would also like the selected user's profile properties to be automatically saved to columns in the list.

Issue

• You cannot do this out of the box.

Resolution

• Kiefer Consulting, Inc. has developed a custom workflow that will allow you to do this. 
  Contact me if you need this.