How To: Uninstall a Passageways Module - TSR

***This article is under construction & may not contain all application scripts for deletion from the database.***

1.       Remove the module entry from Add/Remove Programs or Programs and Features by right clicking the desired module and selecting ‘Uninstall’.
           a.       If while trying to uninstall, an error message like this appears, ''Error Applying
Transforms - Verify that the specified Transformer Paths are valid", use the Windows Installer Utility Cleanup download or follow these instructions  to remove it manually from the registry.
 
2.       Delete the module folder, usually located here: C:\Inetpub\wwwroot\PassagewaysFolder\Modules\ModuleName
 
3.       Delete the dll from the bin folder, usually located here: C:\Inetpub\wwwroot\PassagewaysFolder\bin\ Passageways.Modules.ModuleName.dll

This should be deleted after completing step 1. 
 
4.       Delete the module database from the SQL Server. 
           a.       Right click the database name and select 'Delete' 
           b.       Check the 'Delete backup and restore history information for databases' & then 'OK'. 'Close connections' may also need to be checked if the delete does not succeed when only having the delete backup option selected. 
 
5.       A script will need to be run to delete the module islands from portal pages from the Passageways Framework Database.
           a.       Take a backup of the Passageways Framework database.  (Passageways or entitlementname_PortalFX)
           b.      Run the queries below for the appropriate module to see how many island instances are in the Passageways database, then delete these island instances from the 2 tables.

**Note how many records are returned in the SELECT statement as this should be the same number as DELETE script.**

Announcements

1. SELECT      IslandID, PageID, PrefString, IslandInstanceID, DisplayText, ColumnPlacement, DisplayOrder, IconFileName, ColumnID
FROM         PWPageIslands
WHERE   (IslandID='PWGroupAnnouncements') OR (IslandID='PWMyGroupAnnouncements')

2. DELETE FROM PWPageIslands

WHERE   (IslandID='PWGroupAnnouncements') OR (IslandID='PWMyGroupAnnouncements')

3. SELECT      IslandID, RoleID
FROM       PWIslandACL
WHERE (IslandID='PWGroupAnnouncements') OR (IslandID='PWMyGroupAnnouncements')

4. DELETE FROM       PWIslandACL
WHERE (IslandID='PWGroupAnnouncements') OR (IslandID='PWMyGroupAnnouncements')

Assigned Tasks

1. SELECT      IslandID, PageID, PrefString, IslandInstanceID, DisplayText, ColumnPlacement, DisplayOrder, IconFileName, ColumnID
FROM         PWPageIslands
WHERE    (IslandID='AssignedTasks') OR  (IslandID='MyAssignedTasks')

2. DELETE    FROM         PWPageIslands
WHERE    (IslandID='AssignedTasks') OR  (IslandID='MyAssignedTasks')

3.  SELECT      IslandID, RoleID
FROM       PWIslandACL
WHERE (IslandID='AssignedTasks') OR  (IslandID='MyAssignedTasks')

4.  DELETE FROM   PWIslandACL
WHERE (IslandID='AssignedTasks') OR  (IslandID='MyAssignedTasks')

Calendar

1. SELECT      IslandID, PageID, PrefString, IslandInstanceID, DisplayText, ColumnPlacement, DisplayOrder, IconFileName, ColumnID
FROM         PWPageIslands
WHERE    (IslandID='PWGroupCalendar') OR (IslandID='PWWeeklyEvents')

2. DELETE FROM         PWPageIslands
WHERE    (IslandID='PWGroupCalendar') OR (IslandID='PWWeeklyEvents')

3. SELECT      IslandID, RoleID
FROM       PWIslandACL
WHERE (IslandID='PWGroupCalendar') OR (IslandID='PWWeeklyEvents')

4. DELETE FROM       PWIslandACL
WHERE (IslandID='PWGroupCalendar') OR (IslandID='PWWeeklyEvents')

Dashboards

1. SELECT      IslandID, PageID, PrefString, IslandInstanceID, DisplayText, ColumnPlacement, DisplayOrder, IconFileName, ColumnID
FROM         PWPageIslands
WHERE    (IslandID='Passageways.Modules.DashboardCreator.Islands.ViewDashboard') OR (IslandID='Passageways.Modules.DashboardCreator.Islands.MyVisualizations')

2. DELETE  FROM         PWPageIslands
 WHERE    (IslandID='Passageways.Modules.DashboardCreator.Islands.ViewDashboard') OR (IslandID='Passageways.Modules.DashboardCreator.Islands.MyVisualizations')

3. SELECT      IslandID, RoleID
FROM       PWIslandACL
WHERE  (IslandID='Passageways.Modules.DashboardCreator.Islands.ViewDashboard') OR (IslandID='Passageways.Modules.DashboardCreator.Islands.MyVisualizations')

4. DELETE FROM       PWIslandACL
WHERE  (IslandID='Passageways.Modules.DashboardCreator.Islands.ViewDashboard') OR (IslandID='Passageways.Modules.DashboardCreator.Islands.MyVisualizations')

Discussions

1. SELECT      IslandID, PageID, PrefString, IslandInstanceID, DisplayText, ColumnPlacement, DisplayOrder, IconFileName, ColumnID
FROM         PWPageIslands
WHERE    (IslandID='PWGroupDiscussionBoards') 

 2. DELETE  FROM         PWPageIslands
WHERE    (IslandID='PWGroupDiscussionBoards') 

3. SELECT      IslandID, RoleID
FROM       PWIslandACL
WHERE (IslandID = 'PWGroupDiscussionBoards')

4. DELETE FROM PWIslandACL WHERE (IslandID = 'PWGroupDiscussionBoards')

Employee Recognition

1. SELECT      IslandID, PageID, PrefString, IslandInstanceID, DisplayText, ColumnPlacement, DisplayOrder, IconFileName, ColumnID
FROM         PWPageIslands
WHERE    (IslandID='Employee.Recognition.Manager') OR (IslandID='Employee.Recognition.Island')

2. DELETE  FROM         PWPageIslands
WHERE    (IslandID='Employee.Recognition.Manager') OR (IslandID='Employee.Recognition.Island')

3. SELECT      IslandID, RoleID
FROM       PWIslandACL
WHERE (IslandID='Employee.Recognition.Manager') OR (IslandID='Employee.Recognition.Island')

4. DELETE FROM PWIslandACL WHERE (IslandID='Employee.Recognition.Manager') OR (IslandID='Employee.Recognition.Island')

Expense Reports

1. SELECT      IslandID, PageID, PrefString, IslandInstanceID, DisplayText, ColumnPlacement, DisplayOrder, IconFileName, ColumnID
FROM         PWPageIslands
WHERE    (IslandID='Passageways.Modules.ExpenseTracking.MyExpenseReports') OR (IslandID='Passageways.Modules.ExpenseTracking.ApproveExpenseReports') OR (IslandID='Passageways.Modules.ExpenseTracking.PayExpenseReports') 

2. DELETE FROM         PWPageIslands
  WHERE    (IslandID='Passageways.Modules.ExpenseTracking.MyExpenseReports') OR (IslandID='Passageways.Modules.ExpenseTracking.ApproveExpenseReports') OR (IslandID='Passageways.Modules.ExpenseTracking.PayExpenseReports') 

3. SELECT      IslandID, RoleID
FROM       PWIslandACL
WHERE  (IslandID='Passageways.Modules.ExpenseTracking.MyExpenseReports') OR (IslandID='Passageways.Modules.ExpenseTracking.ApproveExpenseReports') OR (IslandID='Passageways.Modules.ExpenseTracking.PayExpenseReports') 

4. DELETE FROM       PWIslandACL
WHERE  (IslandID='Passageways.Modules.ExpenseTracking.MyExpenseReports') OR (IslandID='Passageways.Modules.ExpenseTracking.ApproveExpenseReports') OR (IslandID='Passageways.Modules.ExpenseTracking.PayExpenseReports') 

Form Builder

1. SELECT      IslandID, PageID, PrefString, IslandInstanceID, DisplayText, ColumnPlacement, DisplayOrder, IconFileName, ColumnID
FROM         PWPageIslands
WHERE (IslandID='Passageways.Modules.FormBuilder.FormManager.MyFormsLibrary') OR (IslandID='Passageways.Modules.FormBuilder.FormManager.MyForms')

2. DELETE FROM         PWPageIslands
WHERE (IslandID='Passageways.Modules.FormBuilder.FormManager.MyFormsLibrary') OR (IslandID='Passageways.Modules.FormBuilder.FormManager.MyForms')

3. SELECT      IslandID, RoleID
FROM       PWIslandACL
WHERE  (IslandID='Passageways.Modules.FormBuilder.FormManager.MyFormsLibrary') OR (IslandID='Passageways.Modules.FormBuilder.FormManager.MyForms')

4. DELETE FROM       PWIslandACL
WHERE  (IslandID='Passageways.Modules.FormBuilder.FormManager.MyFormsLibrary') OR (IslandID='Passageways.Modules.FormBuilder.FormManager.MyForms')

Help Desk

1. SELECT      IslandID, PageID, PrefString, IslandInstanceID, DisplayText, ColumnPlacement, DisplayOrder, IconFileName, ColumnID
FROM         PWPageIslands
WHERE     (IslandID = 'PWSubmitHelpRequest') OR  (IslandID = 'PWMyWorkOrders') OR (IslandID='MySubmittedWorkOrders')
 
2. DELETE FROM PWPageIslands
WHERE     (IslandID = 'PWSubmitHelpRequest') OR  (IslandID = 'PWMyWorkOrders') OR (IslandID='MySubmittedWorkOrders')

3. SELECT      IslandID, RoleID
FROM       PWIslandACL
WHERE (IslandID = 'PWSubmitHelpRequest') OR  (IslandID = 'PWMyWorkOrders') OR (IslandID='MySubmittedWorkOrders')

4. DELETE
FROM PWIslandACL
WHERE (IslandID = 'PWMyWorkOrders') OR (IslandID='MySubmittedWorkOrders') OR (IslandID='PWSubmitHelpRequest')

Learning Management

1. SELECT      IslandID, PageID, PrefString, IslandInstanceID, DisplayText, ColumnPlacement, DisplayOrder, IconFileName, ColumnID
FROM         PWPageIslands
WHERE     (IslandID = 'CourseReport') OR  (IslandID = 'LMS.Supervisor') OR (IslandID='LMS.MyTraining')
 
2. DELETE FROM PWPageIslands
WHERE     (IslandID = 'CourseReport') OR  (IslandID = 'LMS.Supervisor') OR (IslandID='LMS.MyTraining')

3. SELECT      IslandID, RoleID
FROM       PWIslandACL
WHERE (IslandID = 'CourseReport') OR  (IslandID = 'LMS.Supervisor') OR (IslandID='LMS.MyTraining')

4. DELETE
FROM PWIslandACL
WHERE (IslandID = 'CourseReport') OR (IslandID='LMS.Supervisor') OR (IslandID='LMS.MyTraining')

      

Lobby Management

1. SELECT      IslandID, PageID, PrefString, IslandInstanceID, DisplayText, ColumnPlacement, DisplayOrder, IconFileName, ColumnID
FROM         PWPageIslands
WHERE    (IslandID='Lobby.MyLobbyReport') OR (IslandID='Lobby.LiveAdvisorReport') OR (IslandID='Lobby.ServiceManagement') OR (IslandID='Lobby.ReportManagement')

2. DELETE FROM  PWPageIslands

    WHERE    (IslandID='Lobby.MyLobbyReport') OR (IslandID='Lobby.LiveAdvisorReport') OR (IslandID='Lobby.ServiceManagement') OR (IslandID='Lobby.ReportManagement')

 3. SELECT      IslandID, RoleID
FROM       PWIslandACL
WHERE  (IslandID='Lobby.MyLobbyReport') OR (IslandID='Lobby.LiveAdvisorReport') OR (IslandID='Lobby.ServiceManagement') OR (IslandID='Lobby.ReportManagement')

4. DELETE FROM       PWIslandACL
WHERE  (IslandID='Lobby.MyLobbyReport') OR (IslandID='Lobby.LiveAdvisorReport') OR (IslandID='Lobby.ServiceManagement') OR (IslandID='Lobby.ReportManagement')

         

Management Blogs

1. SELECT      IslandID, PageID, PrefString, IslandInstanceID, DisplayText, ColumnPlacement, DisplayOrder, IconFileName, ColumnID
FROM         PWPageIslands
WHERE    (IslandID='Blogs.ManagementBlogs') OR   (IslandID='Blogs.ManagementBlogsFocused')

2. DELETE FROM         PWPageIslands
WHERE    (IslandID='Blogs.ManagementBlogs') OR   (IslandID='Blogs.ManagementBlogsFocused')

3. SELECT      IslandID, RoleID
FROM       PWIslandACL
WHERE    (IslandID='Blogs.ManagementBlogs') OR   (IslandID='Blogs.ManagementBlogsFocused')

4. DELETE FROM         PWIslandACL
WHERE    (IslandID='Blogs.ManagementBlogs') OR   (IslandID='Blogs.ManagementBlogsFocused')

    

Photos

1. SELECT      IslandID, PageID, PrefString, IslandInstanceID, DisplayText, ColumnPlacement, DisplayOrder, IconFileName, ColumnID
FROM         PWPageIslands
WHERE    IslandID='PWPhotoAlbum'

2. DELETE FROM         PWPageIslands
WHERE    IslandID='PWPhotoAlbum'

3. SELECT      IslandID, RoleID
FROM       PWIslandACL
WHERE  IslandID='PWPhotoAlbum'

4. DELETE FROM       PWIslandACL
WHERE  IslandID='PWPhotoAlbum'

Polls

1. SELECT      IslandID, PageID, PrefString, IslandInstanceID, DisplayText, ColumnPlacement, DisplayOrder, IconFileName, ColumnID
FROM         PWPageIslands
WHERE    (IslandID='PWGroupPoll') OR   (IslandID='PWGroupPollResults')

2. DELETE FROM         PWPageIslands
WHERE    (IslandID='PWGroupPoll') OR   (IslandID='PWGroupPollResults') 

3. SELECT      IslandID, RoleID
FROM       PWIslandACL
WHERE (IslandID='PWGroupPoll') OR   (IslandID='PWGroupPollResults')

4. DELETE FROM         PWIslandACL
WHERE    (IslandID='PWGroupPoll') OR   (IslandID='PWGroupPollResults')

Products & Services

1. SELECT      IslandID, PageID, PrefString, IslandInstanceID, DisplayText, ColumnPlacement, DisplayOrder, IconFileName, ColumnID
FROM         PWPageIslands
WHERE    (IslandID='PWProductComparison') OR (IslandID='PWProductHighlight')

2. DELETE FROM         PWPageIslands
WHERE    (IslandID='PWProductComparison') OR (IslandID='PWProductHighlight') 

3. SELECT      IslandID, RoleID
FROM       PWIslandACL
WHERE  (IslandID='PWProductComparison') OR (IslandID='PWProductHighlight') 

4. DELETE FROM       PWIslandACL
WHERE  (IslandID='PWProductComparison') OR (IslandID='PWProductHighlight') 

Read Receipt

1. SELECT      IslandID, PageID, PrefString, IslandInstanceID, DisplayText, ColumnPlacement, DisplayOrder, IconFileName, ColumnID
FROM         PWPageIslands
WHERE  (IslandID='Passageways.Modules.ReadReceipt.ViewReport') OR (IslandID='Passageways.Modules.ReadReceipt.ViewItem')   

2. DELETE  FROM         PWPageIslands
WHERE  (IslandID='Passageways.Modules.ReadReceipt.ViewReport') OR (IslandID='Passageways.Modules.ReadReceipt.ViewItem')   

3. SELECT      IslandID, RoleID
FROM       PWIslandACL
WHERE (IslandID='Passageways.Modules.ReadReceipt.ViewReport') OR (IslandID='Passageways.Modules.ReadReceipt.ViewItem')   

4. DELETE FROM       PWIslandACL
WHERE (IslandID='Passageways.Modules.ReadReceipt.ViewReport') OR (IslandID='Passageways.Modules.ReadReceipt.ViewItem')  

Reservations

1. SELECT      IslandID, PageID, PrefString, IslandInstanceID, DisplayText, ColumnPlacement, DisplayOrder, IconFileName, ColumnID
FROM         PWPageIslands
WHERE  IslandID='ReservationObjects'

2. DELETE FROM         PWPageIslands
WHERE  IslandID='ReservationObjects' 

3. SELECT      IslandID, RoleID
FROM       PWIslandACL
WHERE  IslandID='ReservationObjects' 

4. DELETE FROM       PWIslandACL
WHERE  IslandID='ReservationObjects' 

Single Sign On

1. SELECT      IslandID, PageID, PrefString, IslandInstanceID, DisplayText, ColumnPlacement, DisplayOrder, IconFileName, ColumnID
FROM         PWPageIslands
WHERE  IslandID='Passageways.Modules.SSO.Applications'

2. DELETE FROM         PWPageIslands
WHERE  IslandID='Passageways.Modules.SSO.Applications'

3. SELECT      IslandID, RoleID
FROM       PWIslandACL
WHERE  IslandID='Passageways.Modules.SSO.Applications'

4. DELETE FROM       PWIslandACL
WHERE  IslandID='Passageways.Modules.SSO.Applications'  

Strategic Planning

1. SELECT      IslandID, PageID, PrefString, IslandInstanceID, DisplayText, ColumnPlacement, DisplayOrder, IconFileName, ColumnID
FROM         PWPageIslands
WHERE  IslandID='StrategicPlanning'

2. DELETE FROM         PWPageIslands
WHERE  IslandID='StrategicPlanning'

3. SELECT      IslandID, RoleID
FROM       PWIslandACL
WHERE  IslandID='StrategicPlanning'

4. DELETE FROM       PWIslandACL
WHERE  IslandID='StrategicPlanning'

 

Supply Order

1. SELECT      IslandID, PageID, PrefString, IslandInstanceID, DisplayText, ColumnPlacement, DisplayOrder, IconFileName, ColumnID
FROM         PWPageIslands
WHERE  IslandID='SupplyCart.UserIsland'

2. DELETE FROM         PWPageIslands
WHERE  IslandID='SupplyCart.UserIsland'

3. SELECT      IslandID, RoleID
FROM       PWIslandACL
WHERE  IslandID='SupplyCart.UserIsland'

4. DELETE FROM       PWIslandACL
WHERE  IslandID='SupplyCart.UserIsland'

System Permissions

1. SELECT      IslandID, PageID, PrefString, IslandInstanceID, DisplayText, ColumnPlacement, DisplayOrder, IconFileName, ColumnID
FROM         PWPageIslands
WHERE    (IslandID='SystemPermissions.DirectReports') OR (IslandID='SystemPermissions.PendingAssignments')

2. DELETE FROM  PWPageIslands

    WHERE    (IslandID='SystemPermissions.DirectReports') OR (IslandID='SystemPermissions.PendingAssignments')

 3. SELECT      IslandID, RoleID
FROM       PWIslandACL
WHERE    (IslandID='SystemPermissions.DirectReports') OR (IslandID='SystemPermissions.PendingAssignments')

4. DELETE FROM       PWIslandACL
WHERE    (IslandID='SystemPermissions.DirectReports') OR (IslandID='SystemPermissions.PendingAssignments')

   

Vendor Management

1. SELECT      IslandID, PageID, PrefString, IslandInstanceID, DisplayText, ColumnPlacement, DisplayOrder, IconFileName, ColumnID
FROM         PWPageIslands
WHERE    (IslandID='Passageways.Modules.VendorManagement.Islands.BrowseVendors') OR (IslandID='Passageways.Modules.VendorManagement.Islands.MyVendors')

2. DELETE FROM  PWPageIslands

    WHERE    (IslandID='Passageways.Modules.VendorManagement.Islands.BrowseVendors') OR (IslandID='Passageways.Modules.VendorManagement.Islands.MyVendors')

 3. SELECT      IslandID, RoleID
FROM       PWIslandACL
WHERE  (IslandID='Passageways.Modules.VendorManagement.Islands.BrowseVendors') OR (IslandID='Passageways.Modules.VendorManagement.Islands.MyVendors')

4. DELETE FROM       PWIslandACL
WHERE  (IslandID='Passageways.Modules.VendorManagement.Islands.BrowseVendors') OR (IslandID='Passageways.Modules.VendorManagement.Islands.MyVendors')

 

Verify that pages with these islands do not error. If so, please contact Passageways Support by emailing support@passageways.com or submitting a ticket through the Support Center.