***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.
Comments
0 comments
Please sign in to leave a comment.