Pre 6.0 Update- Retired / Deprecated Islands Check

The following islands are not compatible with 6.0, or any further releases, as these islands were retired several years ago:

• Document List
  • The List island was the replacement for the Document List island, released in late 2010.  Prior to updating, you will need to get all documents moved to the new List island. 
• List of Links
  • The List island was the replacement for the List of Links island, released in late 2010.  Prior to updating, you will need to get all links moved to the new List island. See query below. 
• Discussion Boards
  • Conversations is the replacement for Discussion Boards released in v4.10 on 11/9/2012.  Prior to updating, you will need to get all discussion boards converted to conversations by updating to Discussions 4.10 or manually recreating content in conversations. 
• Meeting Packets
  • OnBoard is the replacement for Meeting Packets.  We would love to help you transition to OnBoard, or you can use List island. 
• Read Receipt (retired)
• Auction Manager (retired)
• Timesheets Module (retired)
• MS Outlook (retired)

If you’re not using any of the above islands, everything should be working as expected. If you are unsure, below is a query you can run to see if any of these islands are being used on pages within OnSemble.

Our Support team is happy to assist with these queries if you would like assistance.

Here's what you need to do in order to check for these islands:

1. Have SQL server access. 

2. Select the Passageways framework database and run the following query. The framework database will be named something like: Passageways, Production_Portal_PortalFX, TestPortal, or Sandbox_PortalFx. The naming convention just depends on when your portal was installed. There is no other difference. 

--Document List

SELECT dbo.PWWorkGroups.WorkGroupName, dbo.PWPages.DisplayText AS PageName, dbo.PWPageIslands.DisplayText AS Islandtitle, dbo.PWPageIslands.IslandID
FROM dbo.PWPageIslands INNER JOIN
dbo.PWPages ON dbo.PWPageIslands.PageID = dbo.PWPages.PageID INNER JOIN
dbo.PWWorkGroups ON dbo.PWPages.ViewID = dbo.PWWorkGroups.ViewID
WHERE (dbo.PWPageIslands.IslandID = 'PWDocumentsList')

--Discussion Boards

OR (IslandID='PWGroupDiscussionBoards')

--Meeting Packets

OR (IslandID='Passageways.Modules.MeetingPackets.Islands.BoardPacketViewer') OR (IslandID='Passageways.Modules.MeetingPackets.Islands.PendingPacketForApproval') OR (IslandID='Passageways.Modules.MeetingPackets.Islands.ConfigurePendingSectionIsland') OR (IslandID='Passageways.Modules.MeetingPackets.Islands.AuditTrail') OR (IslandID='Passageways.Modules.MeetingPackets.Islands.BoardPacketCreator') 

--List of Links

OR (IslandID='PWLinks')

--Auction

OR (IslandID='Auctioneer') OR (IslandID='AuctionReport')

--MS Outlook

OR (IslandID='ExchangeTasks') OR (IslandID='OutlookLocalInbox') OR (IslandID='OutlookLocalCalendar') OR (IslandID='OutlookLocalContacts')

--Timesheets

OR (IslandID='Passageways.Modules.Timesheets.TimesheetHistory') OR (IslandID='Passageways.Modules.Timesheets.ApproveTimeSheets')

OR (IslandID='Passageways.Modules.Timesheets.RecordTimesheets') OR

(IslandID='Passageways.Modules.Timesheets.MyTimesheets')

--Read Receipt

OR (IslandID='Passageways.Modules.ReadReceipt.ViewItem') OR (IslandID='Passageways.Modules.ReadReceipt.ViewReport')

3. Click the top left cell of the results to select all. Copy then paste that data in to an Excel spreadsheet. 

4. Remove or update to use supported islands. 

Below is a script that will permanently delete these islands. Use with caution, and always take a backup before making any changes to a database!!

--Document List
delete p
FROM dbo.PWPageIslands p INNER JOIN
dbo.PWPages ON p.PageID = dbo.PWPages.PageID INNER JOIN
dbo.PWWorkGroups ON dbo.PWPages.ViewID = dbo.PWWorkGroups.ViewID
WHERE (p.IslandID = 'PWDocumentsList')
--Discussion Boards
OR (IslandID='PWGroupDiscussionBoards')
--Meeting Packets
OR (IslandID='Passageways.Modules.MeetingPackets.Islands.BoardPacketViewer') OR (IslandID='Passageways.Modules.MeetingPackets.Islands.PendingPacketForApproval') OR (IslandID='Passageways.Modules.MeetingPackets.Islands.ConfigurePendingSectionIsland') OR (IslandID='Passageways.Modules.MeetingPackets.Islands.AuditTrail') OR (IslandID='Passageways.Modules.MeetingPackets.Islands.BoardPacketCreator')
--List of Links
OR (IslandID='PWLinks')
--Auction
OR (IslandID='Auction') OR (IslandID='AuctionReport')
--MS Outlook
OR (IslandID='ExchangeTasks') OR (IslandID='OutlookLocalInbox') OR (IslandID='OutlookLocalCalendar') OR (IslandID='OutlookLocalContacts')
--Timesheets
OR (IslandID='Passageways.Modules.Timesheets.TimesheetHistory') OR (IslandID='Passageways.Modules.Timesheets.ApproveTimeSheets')
OR (IslandID='Passageways.Modules.Timesheets.RecordTimesheets') OR
(IslandID='Passageways.Modules.Timesheets.MyTimesheets')
--Read Receipt
OR (IslandID='Passageways.Modules.ReadReceipt.ViewItem') OR (IslandID='Passageways.Modules.ReadReceipt.ViewReport')