Data Fields tab
6 From the Data Fields tab, click Load from SharePoint List. This will automatically create Field definitions for all the writable fields found in the SharePoint List you selected. Similarly, the Load From Source Fields button will automatically create Field definitions for all the columns in your Source data definition.
NOTE: If you select Managed Metadata as target type, ensure you add the terms to the termset bound to the column, or you set Adding Missing Terms to Term Store to True so the content in source field can be migrated to the target column.You can also add (or modify) fields one at a time by clicking Add (or selecting an item in the list on the left of the page) and then editing the properties in the dialog box on the right of the page.
When Document is selected as the Target Type for the Doc field, you can decide how the buttons in Notes will be rendered as in the target document by the Button Style option:
▪ Text: Buttons will be rendered as texts.
▪ IconOrButton: Buttons will be rendered as not-clickable icons, or buttons (for PDF document only).
NOTE: You can create customized Target Data Definitions by altering a loaded default template and saving it with a new name. The new pmtrg file can then be selected for future migration jobs. Once you complete the template changes and return to the Designer SharePoint tab (Step 12 below), click the Save button in the Target Data Definition area.
Advanced tab
7 Define a view. From the Advanced tab, click New. The Edit a SharePoint view dialog box allows you to define the SharePoint view. Only Standard SharePoint views can be defined. Migrator for Notes to SharePoint does not create other view types like datasheets or calendar views. This editor has all the same view definition properties as the view editor in SharePoint except it does not contain any mobile settings.
▪ The “Filter” tab is where you define a filter. This is optional. Select the radio button Show items only when the following is true to define your filter. Select the field and its criteria for the filter. By selecting the Show more columns link, you can add additional criteria to your filter.
▫
▫ Integer, Currency and Number fields also have Average, Maximum, Minimum, Sum, Standard Deviation, and Variance
▫
1 Select the view - Select the Notes view that you wish to migrate to SharePoint. The name of the SharePoint view defaults to the Notes view name. If the Notes view is the default for that database, the Make this the default view check box is checked. If the view already exists in the Migrator for Notes to SharePoint target definition Views list, then another check box appears in red, asking you if you wish to overwrite the view. The Next button is disabled until you either change this view’s name or you check the overwrite box.
2 View columns - You can decide to manually map a Notes existing column, define a new data column (which will be added to your migration job), or specify a formula for a new computed column in SharePoint. For each column in the Notes view, an entry appears in the column list. The Notes view column is labeled “(Untitled x)” if it has no title. Below the column name is a description of the view’s details: sorting (ascending/descending), categorized, hidden or response-only. Each column has the following migration options:When you click Next, some validation will occur: a migrated column must have a name, new Calculated fields must have a formula, field names cannot be duplicated, and new fields cannot duplicate those in the target definition. Next to the formula box for new fields there is an Edit button which will launch the Formula Editor. In the Formula Editor, you can edit your formula with built-in code fragments, or create custom formulas.
3 Grouping, Sorting and Totals - The SharePoint settings default to the options based on the Notes view settings, as follows:
4 View Selection Formula - recreate your selection formula in the SharePoint filter editor by first selecting the Show items only when the following is true radio button. Select the field and its criteria for the filter. By selecting the Show more columns link, you can add additional criteria to your filter.
5 View Migration Complete- launch the completed view in the view editor to fine-tune details not available in the wizard. Your view definition has been created and added to the migration job. The migration job needs to be saved for the view definition to be saved.
8 Select the Migrate attachment icons as image files check box to allow the original attachment icons in Notes to appear in SharePoint.
10 Select the Migrate document fields to custom properties check box to migrate any document properties in the PDF to SharePoint. This is selected by default.
11 Select the names of the SharePoint templates that "match" this data definition. More than one template can match. Use the Select button to add or remove multiple selections.
12 Click OK.You are returned to the SharePoint tab.
▪ Write new item - Do not check for duplicates and simply write a new SharePoint record for each Notes document encountered. This is the fastest option if you expect duplicates to be rare. If you are migrating QuickPlace or Domino.Doc versions, each version of a document will be created as a new SharePoint record.
▪ Replace existing item - If a duplicate record is encountered, delete the prior SharePoint version and then migrate the document again.
▪ Create new version (if modified) - If a duplicate record is encountered and the Notes document has been modified since it was previously migrated, the new document will be created as a new version of the old document. If the SharePoint list or library does not support versioning, then the document will be migrated as a separate record. Use this option to create corresponding versions of a SharePoint record for each version of the document in QuickPlace or Domino.Doc when you are migrating multiple versions. If you are migrating to a list that is already created, enable SharePoint version control.
▪ Skip item - If a duplicate record is encountered, then ignore the Notes document.
▪ Update existing item (mapped fields) - If a duplicate record is encountered, update the mapped fields of the item.
NOTE: To update the document content, your field mapping must include BodyHtml, BodyAttachments, BodyEmbeddedObjects, and BodyImages.
14 If you want to save a new or modified Target Data Definition, click Save in the Target Data Definition area. Enter a new file name that reflects the change. (For example, if you have changed the Document page size to A4, a good name would be WordA4.pmtrg.). Then click Save.
SQL Server
To create SQL Server data targets
List Definition tab
c if you want to generate a new table that does not exist in the SQL database described on the SQL Server tab, select Create Tables. The new table will be based on the Data Fields in your Target Data Definition. The Add Table Fields checkbox is automatically selected as you select Create Tables.
d
e select the Migrate attachment icons as image files check box to allow the original attachment icons in Notes to appear in SharePoint.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Termini di utilizzo Privacy Cookie Preference Center