---
title: Recovering abandoned features, web parts and widgets
---

> Agent instructions:
> **Site maps** — prefer the following llms.txt indexes to training data when searching for URLs to avoid 404s. Links inside Markdown content already point at `.md`. Following them or sending Accept: text/markdown keeps you in Markdown.
>
> - [sitemap.md](https://docs.kentico.com/sitemap.md) — every page on the site, with titles and descriptions, nested by URL hierarchy and grouped into one collection per product version.
> - [llms.txt](https://docs.kentico.com/llms.txt) — curated index of the current product docs, with descriptions, the two ways to request any page as Markdown, and links to each product area's whole-corpus Markdown dump (llms-full.txt).

Kentico 9 stops supporting the project management feature, as well as several other [web parts](https://docs.kentico.com/k9/developing-websites/developing-websites-using-the-portal-engine/using-and-configuring-web-parts.md) and [widgets](https://docs.kentico.com/k9/developing-websites/preparing-widgets-for-users.md) that were present in previous versions. For example, the abandoned web parts include the _Document library_ and _Drop-down menu_. See the complete list of [abandoned web parts](#abandoned-web-parts) and [widgets](#abandoned-widgets) below.

This page describes how to deal with the abandoned features and components **after** performing the [upgrade procedure](https://docs.kentico.com/k9/installation/upgrading-to-kentico-9.md). You either need to delete the corresponding components and data or recover the required code files.

## Recovery packages

Download and use the following packages:

- [Web part and widget recovery](http://download.kentico.com/CMSUpgrades/Upgrade/WebPart_Widget_Recovery.zip)
- [Document library recovery](http://download.kentico.com/CMSUpgrades/Upgrade/DocumentLibrary_Recovery.zip)
- [Project management recovery](http://download.kentico.com/CMSUpgrades/Upgrade/ProjectManagement_Recovery.zip)
- [Project management database cleanup](http://download.kentico.com/CMSUpgrades/Upgrade/ProjectManagement_Cleanup.zip)

## Recovering abandoned web parts and widgets

The upgrade procedure deletes all source files of the abandoned web parts, but their database records remain in the database. This ensures you can recover any of the removed web parts or widgets that you use on your site and make everything work as before the upgrade. You do not need to worry about losing these web parts from your site's pages and templates (their configurations is stored in the database).

Go through the list list of [abandoned web parts](#abandoned-web-parts) and [widgets](#abandoned-widgets) and take the desired action for each component. Follow the steps in the sections below to either remove or recover the listed web parts or widgets.

> **Note:** **Important**: The abandoned web parts will not be considered in future Kentico versions and anything that you recover becomes your own custom code. You have access to all source files of the web parts and are free to modify them, but you need to maintain them yourself.

### Recovering widgets

Start by determining whether your site **actively uses** the given widget:

1. Open the **Widgets** application.
2. Select the widget in the tree.
3. View the **Usage** tab.

If you are NOT using the widget, delete the widget in the **Widgets** application.

If you are using the widget, you have the following options:

- Recover the widget – find the widget in the[ list of abandoned widgets](#abandoned-widgets) and check if the widget's parent web part was removed. If so, recover the parent web part.\
  – OR –
- Create your own custom widget and delete the abandoned widget in the **Widgets** application.

### Recovering web parts

Start by determining whether your site **actively uses** the given web part:

1. Open the **Web parts** application.
2. Select the web part in the tree.
3. View the **Usage** tab.

If you are NOT using the web part, delete the web part in the **Web parts** application.

If you are using the web part, you have the following options:

- Recover the web part – find the web part in the [list of abandoned web parts](#abandoned-web-parts) and perform the following steps:

  1. Copy all related files from the [recovery package](http://download.kentico.com/CMSUpgrades/Upgrade/WebPart_Widget_Recovery.zip) into the **CMS** folder of your upgraded project (see the **Web part files** table column).
  2. If the web part requires web.config modifications (see the **Additional modifications** table column), add the specified directive into your project's web.config file.
  3. **Web application projects only**:
     1. Open your Kentico project in Visual Studio.
     2. Include the copied files into the _CMSApp_ project (or _CMSApp\_AppCode_ for files in the _Old\_App\_Code_ folder).

        1. Click **Show all files** at the top of the Solution Explorer.
        2. Locate the newly added files.
        3. Select the folders or files you wish to include one-by-one while holding the **Ctrl** key.
        4. Right-click one of the files and select **Include in Project**.
     3. Add any assembly references required by the web part (see the **Additional modifications** table column).
     4. Convert the added files to the web application format:
        - Visual Studio 2012: Right-click the project node (CMSApp) in the Solution Explorer and select **Convert To Web Application**.
        - Visual Studio 2013/2015: Select the project node (CMSApp) in the Solution Explorer, open the _Project_ menu on the main toolbar and select **Convert To Web Application**.
     5. Build the affected projects (CMSApp, CMSApp\_AppCode).

  – OR –
- Replace the web part with a different set of Kentico web parts or create your own web part according to your needs. Delete the abandoned web part in the **Web parts** application.

### Abandoned widgets

The following is a list of widgets that were removed in Kentico 9.

| Display name                   | Code name                       | Removed parent web part     |
| ------------------------------ | ------------------------------- | --------------------------- |
| Article list                   | ArticleList                     |                             |
| Article list                   | ArticleListEditors              |                             |
| Articles RSS Feed              | ArticlesRSSFeed                 |                             |
| Blog posts RSS feed            | BlogPostsRSSFeed                |                             |
| Blog posts RSS feed            | BlogPostsRSSFeedEditors         |                             |
| Building your on-line store    | BuildingYourOnlineStore         |                             |
| Document library               | DocumentLibrary                 | Document library            |
| Drop-down menu                 | cmsmenu\_1                      | Drop-down menu              |
| E-commerce settings checker    | EcommerceSettingsChecker        | E-commerce settings checker |
| News RSS Feed                  | NewsRSSFeed                     |                             |
| Latest blog posts              | LatestBlogPostsEditors          |                             |
| Latest blog posts              | LatestBlogPostsUsers            |                             |
| Latest news                    | LatestNewsUsers                 |                             |
| Latest news                    | LatestNewsEditors               |                             |
| Latest news for Corporate site | CorporateSite.LatestNewsEditors |                             |
| My projects                    | MyProjects                      | My projects                 |
| Social bookmarking             | SocialBookmarking               | Social bookmarking          |
| Tasks assigned to me           | TasksAssignedToMe               | Tasks assigned to me        |
| Tasks owned by me              | TasksOwnedByMe                  | Tasks owned by me           |
| Tree Menu                      | cmstreemenu\_1                  | Tree menu                   |

### Abandoned web parts

The following is a list of web parts and server controls that were removed in Kentico 9.

> **Info:** All recovery files except for the document library and project management web parts are located in the [Web part and widget recovery](http://download.kentico.com/CMSUpgrades/Upgrade/WebPart_Widget_Recovery.zip) package.

> **Note:** **Note**: Always copy the listed _ascx_ files along with their corresponding code behind file (_.ascx.cs_).

| Display name                      | Code name                  | Web part files                                                                                                                                                                                                                                                                                                                                                                                                                                                          | Additional modifications                                                                                                                                                                                                                                                                                                                                                                       |
| --------------------------------- | -------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Article list                      | ArticleList                | None                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | Inherited from the **Repeater** web part. You do not need to recover any files, only decide whether to delete or keep the web part in the **Web parts** application.                                                                                                                                                                                                                           |
| Articles RSS feed                 | ArticlesRSSFeed            | None                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | Inherited from the **CMS RSS feed** web part. You do not need to recover any files, only decide whether to delete or keep the web part in the **Web parts** application.                                                                                                                                                                                                                       |
| Attachments Lightbox              | AttachmentsLightbox        | \~/CMSWebParts/Viewers/Effects/jQueryFancyBox\_files/                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                |
| Attachment image gallery          | AttachmentImageGallery     | \~/CMSWebParts/attachments/attachmentlightboxgallery.ascx                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                                                                                                                                                                                                                                                                                                                |
| Attachments Carousel              | Attachments Carousel       | \~/CMSSripts/jquery/jquery-carousel.js                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                                                                                                |
| Attachments Carousel 3D           | AttachmentsCarousel3D      | \~/CMSSripts/jquery/jquery-cloud-carousel.js                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                |
| Blog posts RSS Feed               | BlogPostsRSSFeed           | None                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | Inherited from the **CMS RSS feed** web part. You do not need to recover any files, only decide whether to delete or keep the web part in the **Web parts** application.                                                                                                                                                                                                                       |
| Drop-down menu                    | cmsmenu                    | \~/CMSWebParts/Navigation/cmsmenu.ascx<br>\~/CMSScripts/skmmenu.js<br>\~/CMSScripts/skmmenuup.js<br>\~/App\_Code/skmMenu<br>\~/App\_Code/CMSControls/CMSMenu.cs<br>**Web application projects**<br>Copy the folders and files from _\~/App\_Code_ into the _\~/Old\_App\_Code_ folder instead.<br>You then need to include these files into the _CMSApp\_AppCode_ project in Visual Studio.                                                                             | **Web application projects**<br>CMSApp\_AppCode project - add a reference to the **System.Design** assembly.<br>Web.config:<br>`  <pages ...>     <controls>         <add tagPrefix="cms" namespace="CMS.Controls" assembly="CMSAppAppCode" />
...
 `<br>**Web site projects**<br>Web.config:<br>`  <pages ...>     <controls>         <add tagPrefix="cms" namespace="CMS.Controls" />
...
 ` |
| Document library                  | DocumentLibrary            | All files in the [Document library recovery](http://download.kentico.com/CMSUpgrades/Upgrade/DocumentLibrary_Recovery.zip) package.                                                                                                                                                                                                                                                                                                                                     | On web site projects, restart the application after you copy the document library files – open the **System** application in the Kentico administration interface and click **Restart application**.                                                                                                                                                                                           |
| E-commerce settings checker       | EcommerceSettingsChecker   | \~/CMS/CMSWebParts/Ecommerce/EcommerceSettingsChecker.ascx                                                                                                                                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                |
| Facebook activity feed            |  FacebookActivityFeed      | \~/CMS/CMSWebParts/SocialMedia/Facebook/FacebookActivityFeed.ascx                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                                                                                                                                                                                                                                                                                                                |
| Facebook comments                 | FacebookComments           |  \~/CMS/CMSWebParts/SocialMedia/Facebook/FacebookComments.ascx                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                                                                                                                                                                                                                                                                                                                                                |
| Facebook facepile                 | FacebookFacepile           |  \~/CMS/CMSWebParts/SocialMedia/Facebook/FacebookFacepile.ascx                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                                                                                                                                                                                                                                                                                                                                                |
| Facebook like box                 | FacebookLikeBox            |  \~/CMS/CMSWebParts/SocialMedia/Facebook/FacebookLikeBox.ascx                                                                                                                                                                                                                                                                                                                                                                                                           |                                                                                                                                                                                                                                                                                                                                                                                                |
| Facebook like button              | FacebookLikeButton         |  \~/CMS/CMSWebParts/SocialMedia/Facebook/FacebookLikeButton.ascx                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                |
| Facebook recommendations          | FacebookRecommendations    |  \~/CMS/CMSWebParts/SocialMedia/Facebook/FacebookRecommendations.ascx                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                |
| Facebook send button              | FacebookSendButton         |  \~/CMS/CMSWebParts/SocialMedia/Facebook/FacebookSendButton.ascx                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                |
| Google+ +1 button                 | GooglePlusButton           | \~/CMS/CMSWebParts/SocialMedia/GooglePlus/GooglePlusButton.ascx                                                                                                                                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                |
| Google+ activity feed             | GooglePlusActivityFeed     |  \~/CMS/CMSWebParts/SocialMedia/GooglePlus/GooglePlusActivityFeed.ascx                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                                                                                                |
| Google+ badge                     | GooglePlusBadge            |  \~/CMS/CMSWebParts/SocialMedia/GooglePlus/GooglePlusBadge.ascx                                                                                                                                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                |
| Group document library            | GroupDocumentLibrary       | All files in the [Document library recovery](http://download.kentico.com/CMSUpgrades/Upgrade/DocumentLibrary_Recovery.zip) package.                                                                                                                                                                                                                                                                                                                                     | On web site projects, restart the application after you copy the document library files – open the **System** application in the Kentico administration interface and click **Restart application**.                                                                                                                                                                                           |
| Language selection                | languageselection          | \~/CMS/CMSWebParts/Localization/languageselection.ascx<br>\~/App\_Code/CMSPortalControls/WebParts/CMSAbstractLanguageWebPart.cs<br>**Web application projects**<br>Copy the folder and files from _\~/App\_Code_ into the _\~/Old\_App\_Code_ folder instead.<br>You then need to include these files into the _CMSApp\_AppCode_ project in Visual Studio.                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                |
| Language selection drop-down      | languageselectiondropdown  | \~/CMS/CMSWebParts/Localization/languageselectiondropdown.ascx<br>\~/CMS/CMSWebParts/Localization/dd\_arrow.gif<br>\~/CMS/CMSWebParts/Localization/langselector.css<br>\~/App\_Code/CMSPortalControls/WebParts/CMSAbstractLanguageWebPart.cs<br>**Web application projects**<br>Copy the folder and files from _\~/App\_Code_ into the _\~/Old\_App\_Code_ folder instead.<br>You then need to include these files into the _CMSApp\_AppCode_ project in Visual Studio. |                                                                                                                                                                                                                                                                                                                                                                                                |
| Language selection with flags     | languageselectionwithflags | \~/CMS/CMSWebParts/Localization/languageselectionwithflags.ascx<br>\~/App\_Code/CMSPortalControls/WebParts/CMSAbstractLanguageWebPart.cs<br>**Web application projects**<br>Copy the folder and files from _\~/App\_Code_ into the _\~/Old\_App\_Code_ folder instead.<br>You then need to include these files into the _CMSApp\_AppCode_ project in Visual Studio.                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                |
| Latest news                       | LatestNews                 | None                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | Inherited from the **Repeater** web part. You do not need to recover any files, only decide whether to delete or keep the web part in the **Web parts** application.                                                                                                                                                                                                                           |
| Lightbox gallery                  | lightbox                   | \~/CMSWebParts/Viewers/Effects/lightbox.ascx                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                |
| LinkedIn company insider          | LinkedInCompanyInsider     | \~/CMS/CMSWebParts/SocialMedia/LinkedIn/LinkedInCompanyInsider.ascx                                                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                |
| LinkedIn company profile          | LinkedInCompanyProfile     |  \~/CMS/CMSWebParts/SocialMedia/LinkedIn/LinkedInCompanyProfile.ascx                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                                                                                                                                                                                                                                                                                                                                |
| LinkedIn member profile           | LinkedInMemberProfile      |  \~/CMS/CMSWebParts/SocialMedia/LinkedIn/LinkedInMemberProfile.ascx                                                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                |
| LinkedIn share button             | LinkedInShareButton        | \~/CMS/CMSWebParts/SocialMedia/LinkedIn/LinkedInShareButton.ascx                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                |
| My projects                       | MyProjects                 | See the [Project management](#project-management) section.                                                                                                                                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                |
| News list                         | NewsList                   | None                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | Inherited from the **Repeater** web part. You do not need to recover any files, only decide whether to delete or keep the web part in the **Web parts** application.                                                                                                                                                                                                                           |
| News RSS Feed                     | NewsRSSFeed                | None                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | Inherited from the **CMS RSS feed** web part. You do not need to recover any files, only decide whether to delete or keep the web part in the **Web parts** application.                                                                                                                                                                                                                       |
| Product filter                    | ProductFilter              | \~/CMS/CMSModules/Ecommerce/Controls/Filters/ProductFilter.ascx<br>\~/CMS/CMSWebParts/Ecommerce/Products/ProductFilter.ascx                                                                                                                                                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                                                                |
| Project list                      | ProjectList                | See the [Project management](#project-management) section.                                                                                                                                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                |
| Project tasks                     | ProjectTasks               | See the [Project management](#project-management) section.                                                                                                                                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                |
| Pinterest follow button           | PinterestFollowButton      | \~/CMS/CMSWebParts/SocialMedia/Pinterest/PinterestFollowButton.ascx                                                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                |
| Pinterest pin it button           | PinterestPinItButton       | \~/CMS/CMSWebParts/SocialMedia/Pinterest/PinterestPinItButton.ascx                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                                                                                                                                                                                                                                                                                                                                                |
| Repeater with Carousel            | RepeaterWithCarousel       | \~/CMSSripts/jquery/jquery-carousel.js                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                                                                                                |
| Repeater with Lightbox            | RepeaterWithLightbox       | \~/CMSWebParts/Viewers/Effects/jQueryFancyBox\_files/                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                |
| Scrolling news                    | ScrollingNews              | None                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | Inherited from the **Scrolling text** web part. You do not need to recover any files, only decide whether to delete or keep the web part in the **Web parts** application.                                                                                                                                                                                                                     |
| SharePoint data source (obsolete) | SharePointDataSource       | -                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | The obsolete SharePoint web parts were removed without any recovery options. The upgrade automatically deletes the web parts from the database and file system.<br>See the [Integrating SharePoint](https://docs.kentico.com/k9/integrating-3rd-party-systems/integrating-sharepoint.md) chapter to learn how to display SharePoint content without the obsolete web parts.                    |
| SharePoint datagrid (obsolete)    | SharePointDatagrid         | -                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                                                                                                                                                                                                                                                                                                                |
| SharePoint datalist (obsolete)    | SharePointDatalist         | -                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                                                                                                                                                                                                                                                                                                                |
| SharePoint repeater (obsolete)    | SharePointDataViewer       | -                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                                                                                                                                                                                                                                                                                                                |
| Shopping cart preview             | ShoppingCartMiniPreview    | \~/CMS/CMSWebParts/Ecommerce/ShoppingCart/ShoppingCartMiniPreviewWebPart.ascx                                                                                                                                                                                                                                                                                                                                                                                           |                                                                                                                                                                                                                                                                                                                                                                                                |
| Social bookmarking                | SocialBookmarking          | \~/CMS/CMSWebParts/SocialMedia/SocialBookmarking.ascx                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                |
| Task info panel                   | TaskInfoPanel              | See the [Project management](#project-management) section.                                                                                                                                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                |
| Tasks assigned to me              | TasksAssignedToMe          | See the [Project management](#project-management) section.                                                                                                                                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                |
| Tasks owned by me                 | TasksOwnedByMe             | See the [Project management](#project-management) section.                                                                                                                                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                |
| Tree menu                         | cmstreemenu                | \~/CMS/CMSWebparts/Navigation/cmstreemenu.ascx<br>\~/CMSScripts/Controls/treemenu.js<br>\~/App\_Code/CMSControls/CMSTreeMenu.cs<br>**Web application projects**<br>Copy the folder and files from _\~/App\_Code_ into the _\~/Old\_App\_Code_ folder instead.<br>You then need to include these files into the _CMSApp\_AppCode_ project in Visual Studio.                                                                                                              | **Web application projects**<br>CMSApp\_AppCode project - add a reference to the **System.Design** assembly.<br>Web.config:<br>`  <pages ...>     <controls>         <add tagPrefix="cms" namespace="CMS.Controls" assembly="CMSAppAppCode" />
...
 `<br>**Web site projects**<br>Web.config:<br>`  <pages ...>     <controls>         <add tagPrefix="cms" namespace="CMS.Controls" />
...
 ` |
| Twitter feed                      | TwitterFeed                | \~/CMS/CMSWebParts/SocialMedia/Twitter/TwitterFeed.ascx                                                                                                                                                                                                                                                                                                                                                                                                                 |                                                                                                                                                                                                                                                                                                                                                                                                |
| Twitter follow button             | TwitterFollowButton        |  \~/CMS/CMSWebParts/SocialMedia/Twitter/TwitterFollowButton.ascx                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                |
| Twitter tweet button              | TwitterTweetButton         |  \~/CMS/CMSWebParts/SocialMedia/Twitter/TwitterTweetButton.ascx                                                                                                                                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                |

## Project management

The project management features are no longer supported in Kentico 9. Decide whether you wish to continue using project management after you perform the upgrade procedure.

### Cleaning up project management data

If you do NOT use project management, download the [Project management database cleanup](http://download.kentico.com/CMSUpgrades/Upgrade/ProjectManagement_Cleanup.zip) package. The package contains SQL scripts that remove all data related to project management from your upgraded database.

Run the SQL scripts against your database in the following order:

1. DB data removal.sql
2. DB object removal.sql
3. DB objects - alter procedure.sql

### Recovering project management

If you wish to continue using project management after you upgrade, download the [Project management recovery](http://download.kentico.com/CMSUpgrades/Upgrade/ProjectManagement_Recovery.zip) package and perform the following steps:

> **Info:** **Note**: You cannot recover project management for new Kentico 9 installations. The process only works for upgraded instances.

> **Note:** **Important**: Project management will not be considered in future Kentico versions. The recovery package gives you access to all project management files and source code and you are free to modify anything. However, the files become your own custom code that you need to maintain.

1. Copy all folders from the recovery package into your Kentico project's **CMS** folder and merge all content.
2. Open your Kentico solution in Visual Studio.
3. Click **File -> Add -> Existing Project** and choose the _CMS\ProjectManagementLibrary\ProjectManagement.csproj_ file.
4. Unfold the **References** section of the **ProjectManagement** project and delete all invalid references.
5. Add references to the required libraries in your Kentico project:

   1. Right-click the **ProjectManagement** project and select **Add Reference**.
   2. In the **Reference Manager** dialog, click **Browse** and navigate to the **Lib** folder of your Kentico web project.
   3. Add references to the following libraries:

      - CMS.Base.dll
      - CMS.Core.dll
      - CMS.DataEngine.dll
      - CMS.DocumentEngine.dll
      - CMS.EmailEngine.dll
      - CMS.EventLog.dll
      - CMS.Helpers.dll
      - CMS.LicenseProvider.dll
      - CMS.Localization.dll
      - CMS.MacroEngine.dll
      - CMS.Membership.dll
      - CMS.Modules.dll
      - CMS.Scheduler.dll
      - CMS.SiteProvider.dll
6. Build the **ProjectManagement** project.

**Web site Kentico projects** - copy the resulting **CMS.ProjectManagement.dll** file into the Kentico project's **CMS\bin** folder. The built DLL is located in the _ProjectManagementLibrary\bin\Debug_ (default) or _Release_ folder.

**Web application Kentico projects** - you need to perform additional steps:

1. Move the content from the copied _CMS\App\_Code_ folder into the _CMS\Old\_App\_Code_ folder within your project files (you can then delete the _App\_Code_ folder).
2. Include the copied folders and files into the Kentico projects:
   - **CMSApp project**:
     - App\_Data\CMSModules\ProjectManagement\\.\*
     - App\_Themes\Default\CMSModules\\.\*
     - CMSModules\Groups\Tools\ProjectManagement\\.\*
     - CMSModules\ProjectManagement\\.\*
     - CMSResources\CMS.ProjectManagement\\.\*
     - CMSWebParts\ProjectManagement\\.\*
   - **CMSApp\_AppCode project**:
     - Old\_App\_Code\Pages\\.\*
     - Old\_App\_Code\ProjectManagement\\.\*
   1. Click **Show all files** at the top of the Solution Explorer.
   2. Locate the newly added files.
   3. Select the folders or files you wish to include one-by-one while holding the **Ctrl** key.
   4. Right-click one of the files and select **Include in Project**.
3. Convert the added files to the web application format:
   1. Visual Studio 2012: Right-click the CMSApp project in the Solution Explorer and select **Convert To Web Application**.
   2. Visual Studio 2013/2015: Select the CMSApp project in the Solution Explorer, open the _Project_ menu on the main toolbar and select **Convert To Web Application**.
4. Add references from the **CMSApp** and **CMSApp\_AppCode** projects to **ProjectManagement**:

   1. Right-click the project and select **Add Reference**.
   2. In the **Reference Manager** dialog, select **ProjectManagement** on the **Projects -> Solution** tab.
5. Build the Kentico solution.

To finish the recovery (for both web application and web site projects), recreate a project management property that the upgrade deleted from the **Group profile** web part:

1. Open the Kentico administration interface.
2. Open the **Web parts** application.
3. Select the **Community -> Management -> Group profile** web part in the tree.
4. Switch to the **Properties** tab.
5. Select the last property in the list and click **New field**.
6. Set the following values for the property:
   - **Field name**: DisplayProjects
   - **Data type**: Boolean (Yes/No)
   - **Required**: Yes (selected)
   - **Default value**: No (not selected)
   - **Field caption**: Display projects tab
   - **Form control**: Check box
7. Click **Save**.

You can now continue using project management features on your upgraded website (all related applications, web parts and widgets).
