Transcript NMSP Partner Training Session 7.pptx

Quest Notes Migrator for SharePoint
Partner Training Webcast Series - Session 7
Even more Advanced Content Migration Jobs
Steve Walch, Senior Product Manager
Blog: http://notes2sharepoint.org
November, 2011
©2011 Quest Software, Inc. All rights reserved.
Partner Training Webcast Series
1. Migration Basics with the NMSP Designer Client
2. Analysis and Automation with the NMSP
Migration Console
3. Advanced Content Migration Jobs
4. Tool Deployment, Domino.Doc and QuickPlace /
QuickR migrations
5. Migrating Application Designs
6. Tips and Tricks for Managing Large Migration
Projects
7. Even More Advanced Content Migration Jobs
(Product demos using NMSP 6.1 beta)
1
©2011 Quest Software, Inc. All rights reserved.
Today’s Agenda
Even more Advanced Content Migration Jobs
• Working with Document Sets
• Migrating to Wiki and Basic Pages
• Migrating to Web Part Pages
• Migrating to Publishing Pages
• Migrating to InfoPath Form Libraries
• Introduction to SQL Server Migrations
2
©2011 Quest Software, Inc. All rights reserved.
Working with Document Sets
• Multiple document library files in one logical document
– Similar to a folder
– Maintains header/detail properties
• Create a target column of type “Document Set“
• Optional: Use “Document Set Template” designer to…
– Specify custom Content Type for doc set
– Define mappable columns on doc set header
• Map Notes data to properties on Mapping Tab
– Use “Column.Property” notation to map to doc set header
– At a minimum, map to “Name” property of doc set
– Any attachments mapped to File column become doc set members
– Any generated documents (Word, etc.) become doc set members
3
©2011 Quest Software, Inc. All rights reserved.
More Document Set rules
• By default, the value mapped to the Name property
identifies one unique doc set
– Two docs with the same mapped Name get merged into the same doc set
– Allows flexibility for combining multiple Notes docs into one doc set
– But may give unexpected results
• Or, set “Unique By Document ID” property to true
– Notes UNID controls document set uniqueness
• Either way, first document wins for header properties
– Subsequent documents can only add additional doc set members
• Document sets can be placed inside folders
– But not the other way around
4
©2011 Quest Software, Inc. All rights reserved.
Document Set case #1
Notes Document
Data Items
Data Items
Data Items
Rich Text Body
Attachment
Attachment
Document Set
Properties
Metadata
Rich Text Document
(HTML, ASPX, Word, InfoPath)
Properties
Metadata
File
Properties
Metadata
Metadata
File
Properties
Metadata
©2011 Quest Software, Inc. All rights reserved.
5
Document Set case #2
Document Set
Properties #1
Metadata #1
Notes
Document #1
Data Items
Rich Text Document #1
(HTML, ASPX, Word, InfoPath)
Properties #1
Data Items
Rich Text Body
Notes
Document #2
Data Items
Metadata
Metadata #1
Rich Text Document #2
(HTML, ASPX, Word, InfoPath)
Data Items
Properties #2
Rich Text Body
Metadata #2
Attachment
Metadata
File
Properties
Metadata
©2011 Quest Software, Inc. All rights reserved.
6
Generating ASPX Content Pages
“Basic” content pages
• Rarely used in SharePoint 2010
“Wiki” content pages
• Greatly expanded in SharePoint 2010 (web parts, etc.)
Web Part Pages
• set Web Part Properties from Notes data
“Publishing” pages
• leverage SharePoint ECM features
Move embedded images/attachments/objects to separate
library while migrating
Use “AttachmentLinks” construct to compensate for lack of
attachment area
7
©2011 Quest Software, Inc. All rights reserved.
Migrating to Wiki pages
• Create a target column of type “Page Name”
– Set Page Type property to “Wiki”
– Mapped value will be appended with “.aspx”
• Create a target column of type “Note”
– Name must be set to “WikiField”
• Create additional target columns (optional)
– Additional metadata properties
– File columns with Alternate Library / Folder
– Folder columns
• Required column mappings
– Map Notes text column to Page Name column (above)
– Map Notes rich text column to Wiki Field column (above)
• Tip: Use prebuilt Target Data Definition
8
©2011 Quest Software, Inc. All rights reserved.
Migrating to Basic pages
• Create a target column of type “Page Name”
– Set Page Type property to “Basic”
• Create a target column of type “Web Part Property”
– Web Part Title must be named “Content”
– Web Part Property must be named “Content”
• Create additional target columns (optional)
– Additional metadata properties
– File columns with Alternate Library / Folder
– Folder columns
• Required column mappings
– Map Notes text column to Page Name column (above)
– Map Notes rich text column to Content column (above)
• Tip: Use prebuilt Target Data Definition
9
©2011 Quest Software, Inc. All rights reserved.
Migrating to Web Part pages
• Create a target column of type “Page Name”
– Set Page Type property to “Template”
– Paste in ASPX code into Template property (copy from SharePoint
Designer)
• Create target “Web Part Property” columns as needed
– Web Part Title, Web Part Property must match ASPX code
– Supports Content Editor Web Part
• Create additional target columns (optional)
– Additional metadata properties
– File columns with Alternate Library / Folder
– Folder columns
• Required column mappings
– Map Notes text column to Page Name column (above)
10
©2011 Quest Software, Inc. All rights reserved.
Migrating to Publishing pages
• Create a target column of type “Page Name”
– Set Page Type property to “Template”
– Paste in ASPX code into Template property (use “Download a Copy”)
• All Custom Document Properties may be set as standard
target columns (or hardcoded in ASPX Template)
– Define PublishingPageContent as a Note column
– Define PublishingPageLayout as a Text column
• Create additional target columns (optional)
– File columns with Alternate Library (“Images”, “Documents”)
• Required column mappings
– Map Notes text column to Page Name column (above)
– Map valid string to PublishingPageLayout column
• Approval Code, Content Type columns may be required
• Tip: Use prebuilt Target Data Definition
11
©2011 Quest Software, Inc. All rights reserved.
Don’t forget “Render with Form”
12
©2011 Quest Software, Inc. All rights reserved.
Migrating to InfoPath Form Libraries
• Generate InfoPath XML documents from Notes docs
• Supports any InfoPath XML schema
– Hand-developed InfoPath Form Templates
– NMSP-generated InfoPath Form Templates (automatic field mapping)
• Full support for generating complex documents
– Map Notes data to desired XML elements
– Supports hierarchical schema and repeating elements
– Supports rich text, doc links, images
– Supports internal or external attachments
• Generated docs checked into target Form Library
– Optional: Map SharePoint properties explicitly
– Optional: Leverage automatic synching of InfoPath properties
13
©2011 Quest Software, Inc. All rights reserved.
Designing a migration job for InfoPath generation
• Add a target column of type “InfoPath” to your job
• Use template editor to import InfoPath Form Template
– Tool discovers mappable fields
• Override mappable field properties as needed
– Encoding options
– Options for handling missing Notes items
– Options for handling multi-valued Notes items
– Automap hints
• Optional: Override Published XSN location
– Sometimes the default is the form is missing or incorrect
– Example: InfoPath form publish as part of a solution
14
©2011 Quest Software, Inc. All rights reserved.
Advanced InfoPath Migration Magic
• Repeating InfoPath Groups
– Map each group member individually
– Set Multi property to RepeatParent consistently
15
©2011 Quest Software, Inc. All rights reserved.
Advanced InfoPath Migration Magic (2)
• Mapping Notes users to People Picker controls
– Preliminary steps required in InfoPath Designer
– Detailed workaround available on SharePoint4All site
• Use the version of the XSN that is published
– XSN may live in List, Content Type, or Central Administration
– Publishing from InfoPath Designer can rev version number
– Best bet: Download XSN from final SharePoint location
– Workaround: Hand edit Document XML template as needed
• Do not use XHTML encoding unless the field on your
form is really a rich text field
16
©2011 Quest Software, Inc. All rights reserved.
Reminder: NMSP migrate Notes forms to InfoPath
(Covered in Session 5 on “Design Migration”)
17
©2011 Quest Software, Inc. All rights reserved.
Why migrate directly to SQL Server tables?
• Very high volume of data records
• Application requires transactions
• Data is needed by other applications
• Data needs to be migrated to other systems
• SharePoint limitations (example: number of columns)
• SharePoint not deployed yet
18
©2011 Quest Software, Inc. All rights reserved.
Migrate to SQL Server
• Populates existing SQL Server tables only
– Does not delete prior contents
– Does not detect “duplicate” documents
• Supports most column types
– Rich text typically written as HTML on Text columns
– Binary files typically written to Image columns
• Supports a variety of primary key schemes
– Migrated columns
– Identity columns
• Supports data normalization
– One-to-many (especially images and attachments)
– Lookup columns
• Supports link tracking / finalization
19
©2011 Quest Software, Inc. All rights reserved.
Migrate to SQL Server example
20
©2011 Quest Software, Inc. All rights reserved.
Creating a SQL Server migration job
• Specify target type “SQL Server” on Target tab
• Select target databases from predefined server list
– Server list configured in tool Options
• Create target data definition
– Load schema from existing table
– Column properties control primary keys and normalization behavior
• Extra configuration needed to support record linking
– How should links to SQL documents be formatted?
– How should links to images / attachments be formatted?
– Where does the redirector page live?
21
©2011 Quest Software, Inc. All rights reserved.
External Lists: SQL Server data in SharePoint
22
©2011 Quest Software, Inc. All rights reserved.
Notes Migrator for SharePoint 6.1 Beta Program
• Beta in progress now!
• Go to http://communities.quest.com/groups/notesmigration-product-beta-group
• Sign in with your Quest Community ID
•
•
Or register to create a new one
Use corporate email (No gmail or hotmail accounts)
• Press the “Ask To Join This Group” button
• Once approved, log in and download
•
•
Reviewers Guide
Product Installer
• Expected release: January 2012
23
©2011 Quest Software, Inc. All rights reserved.
Steve’s blog: http://notes2sharepoint.org
Product: http://quest.com/notes-migrator-for-sharepoint/
©2011 Quest Software, Inc. All rights reserved.